var branchId = conn.ExecuteScalar<string>("SELECT pos_branch_id from restaurants where id = @restid", new { restid = restId });