internal async Task New(SqlConnection connection1, CompaniesUpdateModel model)
{
await SaveCompany(connection1, model);
List <string> users = new List <string>();
foreach (var item in model.users)
{
await SaveCompaniesUsers(connection1, model.id, item);
}
}
private async Task UpdateCompany(SqlConnection connection1, CompaniesUpdateModel model)
{
String commandText1 = "update companies set name = @name " +
"rfc = @rfc, direccion = @direccion, colonia = @colonia, ciudad = @ciudad, " +
"tel = @tel, photo = @photo " +
"where id = @id";
SqlCommand command1 = new SqlCommand(commandText1, connection1);
SqlParameter parameter = new SqlParameter("@id", SqlDbType.VarChar);
parameter.Value = model.id;
command1.Parameters.Add(parameter);
parameter = new SqlParameter("@name", SqlDbType.VarChar);
parameter.Value = model.name;
command1.Parameters.Add(parameter);
parameter = new SqlParameter("@rfc", SqlDbType.VarChar);
parameter.Value = model.rfc;
command1.Parameters.Add(parameter);
parameter = new SqlParameter("@direccion", SqlDbType.VarChar);
parameter.Value = model.direccion;
command1.Parameters.Add(parameter);
parameter = new SqlParameter("@colonia", SqlDbType.VarChar);
parameter.Value = model.colonia;
command1.Parameters.Add(parameter);
parameter = new SqlParameter("@ciudad", SqlDbType.VarChar);
parameter.Value = model.ciudad;
command1.Parameters.Add(parameter);
parameter = new SqlParameter("@tel", SqlDbType.VarChar);
parameter.Value = model.tel;
command1.Parameters.Add(parameter);
parameter = new SqlParameter("@photo", SqlDbType.Binary);
parameter.Value = model.photo;
command1.Parameters.Add(parameter);
await command1.ExecuteNonQueryAsync();
}
internal async Task Update(SqlConnection connection1, CompaniesUpdateModel model)
{
await UpdateCompany(connection1, model);
List <string> users = new List <string>();
foreach (var item in model.users)
{
if (item.isedit == 0)
{
await SaveCompaniesUsers(connection1, model.id, item);
}
else
{
await UpdateCompaniesUsers(connection1, model.id, item);
}
}
}
private async Task SaveCompany(SqlConnection connection1, CompaniesUpdateModel model)
{
String commandText1 = "INSERT INTO companies " +
"(id,name,rfc,direccion,colonia,ciudad,tel,photo,status) " +
"values (@id,@name,@rfc,@direccion,@colonia,@ciudad,@tel,@photo,1)";
SqlCommand command1 = new SqlCommand(commandText1, connection1);
SqlParameter parameter = new SqlParameter("@id", SqlDbType.VarChar);
parameter.Value = model.id;
command1.Parameters.Add(parameter);
parameter = new SqlParameter("@name", SqlDbType.VarChar);
parameter.Value = model.name;
command1.Parameters.Add(parameter);
parameter = new SqlParameter("@rfc", SqlDbType.VarChar);
parameter.Value = model.rfc;
command1.Parameters.Add(parameter);
parameter = new SqlParameter("@direccion", SqlDbType.VarChar);
parameter.Value = model.direccion;
command1.Parameters.Add(parameter);
parameter = new SqlParameter("@colonia", SqlDbType.VarChar);
parameter.Value = model.colonia;
command1.Parameters.Add(parameter);
parameter = new SqlParameter("@ciudad", SqlDbType.VarChar);
parameter.Value = model.ciudad;
command1.Parameters.Add(parameter);
parameter = new SqlParameter("@tel", SqlDbType.VarChar);
parameter.Value = model.tel;
command1.Parameters.Add(parameter);
parameter = new SqlParameter("@photo", SqlDbType.Binary);
parameter.Value = model.photo;
command1.Parameters.Add(parameter);
await command1.ExecuteNonQueryAsync();
}
