public async Task <int> insert(sys_factory_line_model model)
{
await _context.sys_factory_lines.AddAsync(model.db);
_context.SaveChanges();
var db = await _context.sys_factory_lines.Where(t => t.status_del == 1).Where(t => t.status_del == 1).Where(t => t.name == model.db.name).Select(t => t).SingleOrDefaultAsync();
string id_factory_line = db.id;
string id_factory = db.id_factory;
if (model.list_maintenance_system.Count != 0)
{
for (int i = 0; i < model.list_maintenance_system.Count; i++)
{
model.list_maintenance_system[i].id = 0;
model.list_maintenance_system[i].id_factory = id_factory;
model.list_maintenance_system[i].id_factory_line = id_factory_line;
}
saveDetailList(model);
}
_context.SaveChanges();
return(1);
}
private void deleteDetailList(sys_factory_line_model model)
{
var listDelete = _context.sys_factory_line_list_maintenance_systems
.Where(d => d.id_factory_line == model.db.id)
.Select(d => d).ToList();
_context.sys_factory_line_list_maintenance_systems.RemoveRange(listDelete);
_context.SaveChanges();
}
public int update(sys_factory_line_model model)
{
var db = _context.sys_factory_lines.Where(t => t.status_del == 1).Where(d => d.id == model.db.id).FirstOrDefault();
db.name = model.db.name;
db.note = model.db.note;
db.id_factory = model.db.id_factory;
db.update_by = model.db.update_by;
db.update_date = model.db.update_date;
db.status_del = model.db.status_del;
_context.SaveChanges();
deleteDetailList(model);
saveDetailList(model);
return(1);
}
private void saveDetailList(sys_factory_line_model model)
{
for (int i = 0; i < model.list_maintenance_system.Count(); i++)
{
_context.sys_factory_line_list_maintenance_systems.Add(new sys_factory_line_list_maintenance_system_db
{
id = 0,
id_system = model.list_maintenance_system[i].id_system,
id_factory_line = model.db.id,
id_factory = model.db.id_factory,
name = model.list_maintenance_system[i].name,
note = model.list_maintenance_system[i].note,
create_date = DateTime.Now,
});
}
_context.SaveChanges();
}
private bool checkModelStateCreateEdit(ActionEnumForm action, sys_factory_line_model item)
{
if (string.IsNullOrEmpty(item.db.id_factory))
{
ModelState.AddModelError("db.id_factory", "required");
}
if (string.IsNullOrEmpty(item.db.name))
{
ModelState.AddModelError("db.name", "required");
}
var searchName = repo.FindAll().Where(d =>
d.db.id_factory == item.db.id_factory &&
d.db.name == item.db.name && d.db.id != item.db.id).Count();
if (searchName > 0)
{
ModelState.AddModelError("db.name", "existed");
}
return(ModelState.IsValid);
}
private bool checkModelStateEdit(sys_factory_line_model item)
{
return(checkModelStateCreateEdit(ActionEnumForm.edit, item));
}
