private async Task SaveCompaniesUsers(SqlConnection connection1, string id, CompaniesUsersUpdateModel model) { String commandText1 = "INSERT INTO CompaniesUsers " + "(idcompany,iduser,ischecked) " + "values (@idcompany,@iduser,@ischecked)"; SqlCommand command1 = new SqlCommand(commandText1, connection1); SqlParameter parameter = new SqlParameter("@idcompany", 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 UpdateCompaniesUsers(SqlConnection connection1, string id, CompaniesUsersUpdateModel model) { String commandText1 = "update companiesusers " + "set ischecked = @ischecked " + "where idcompany = @idcompany and iduser = @iduser"; SqlCommand command1 = new SqlCommand(commandText1, connection1); SqlParameter parameter = new SqlParameter("@idcompany", 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(); }