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();
}
