private async Task UpdateGroupsUsers(SqlConnection connection1, string id, GroupsUsersUpdateModel model) { String commandText1 = "update Usersgroups " + "set ischecked = @ischecked " + "where idgroup = @idgroup and iduser = @iduser"; SqlCommand command1 = new SqlCommand(commandText1, connection1); SqlParameter parameter = new SqlParameter("@idgroup", SqlDbType.VarChar); parameter.Value = id; command1.Parameters.Add(parameter); parameter = new SqlParameter("@iduser", SqlDbType.VarChar); parameter.Value = model.iduser; command1.Parameters.Add(parameter); parameter = new SqlParameter("@ischecked", SqlDbType.Bit); parameter.Value = model.ischecked; command1.Parameters.Add(parameter); await command1.ExecuteNonQueryAsync(); }
private async Task SaveGroupsUsers(SqlConnection connection1, string id, GroupsUsersUpdateModel model) { String commandText1 = "INSERT INTO Usersgroups " + "(idgroup,iduser,ischecked) " + "values (@idgroup,@iduser,@ischecked)"; SqlCommand command1 = new SqlCommand(commandText1, connection1); SqlParameter parameter = new SqlParameter("@idgroup", SqlDbType.VarChar); parameter.Value = id; command1.Parameters.Add(parameter); parameter = new SqlParameter("@iduser", SqlDbType.VarChar); parameter.Value = model.iduser; command1.Parameters.Add(parameter); parameter = new SqlParameter("@ischecked", SqlDbType.Bit); parameter.Value = model.ischecked; command1.Parameters.Add(parameter); await command1.ExecuteNonQueryAsync(); }