private void deleteCheckListDevice(maintenance_system_device_group_model model)
{
var listDelete = _context.maintenance_system_device_maintenance_group_devices
.Where(d => d.id_group == model.db.id)
.Select(d => d).ToList();
_context.maintenance_system_device_maintenance_group_devices.RemoveRange(listDelete);
_context.SaveChanges();
}
private void saveCheckList(maintenance_system_device_group_model model)
{
for (int i = 0; i < model.list_check_list.Count(); i++)
{
model.list_check_list[i].id = 0;
_context.maintenance_checklist_groups.Add(model.list_check_list[i]);
}
_context.SaveChanges();
}
private void saveCheckListDevice(maintenance_system_device_group_model model, string id_group)
{
for (int i = 0; i < model.list_system_device.Count(); i++)
{
_context.maintenance_system_device_maintenance_group_devices.Add(new maintenance_system_device_maintenance_group_device_db
{
id = 0,
id_group = id_group,
id_system_device = model.list_system_device[i].id,
note = model.list_system_device[i].note,
create_date = DateTime.Now,
});
}
_context.SaveChanges();
}
private bool checkModelStateCreateEdit(ActionEnumForm action, maintenance_system_device_group_model item)
{
if (string.IsNullOrEmpty(item.db.name))
{
ModelState.AddModelError("db.name", "required");
}
var searchName = repo.FindAll().Where(d =>
d.db.name == item.db.name && d.db.id != item.db.id).Count();
if (searchName > 0)
{
ModelState.AddModelError("db.name", "existed");
}
return(ModelState.IsValid);
}
public int update(maintenance_system_device_group_model model)
{
var db = _context.maintenance_system_device_groups.Where(d => d.id == model.db.id).FirstOrDefault();
db.name = model.db.name;
db.status_del = model.db.status_del;
var id_group = _context.maintenance_system_device_groups.Where(t => t.name == model.db.name).Select(t => t.id).SingleOrDefault();
db.update_by = model.db.update_by;
db.update_date = model.db.update_date;
deleteCheckList(model);
saveCheckList(model);
deleteCheckListDevice(model);
saveCheckListDevice(model, id_group);
_context.SaveChanges();
return(1);
}
public async Task <int> insert(maintenance_system_device_group_model model)
{
await _context.maintenance_system_device_groups.AddAsync(model.db);
_context.SaveChanges();
var id_group = await _context.maintenance_system_device_groups.Where(t => t.name == model.db.name).Select(t => t.id).SingleOrDefaultAsync();
if (model.list_check_list.Count != 0)
{
for (int i = 0; i < model.list_check_list.Count; i++)
{
model.list_check_list[i].id_group = id_group;
}
saveCheckList(model);
}
if (model.list_system_device.Count != 0)
{
saveCheckListDevice(model, id_group);
}
_context.SaveChanges();
return(1);
}
private bool checkModelStateEdit(maintenance_system_device_group_model item)
{
return(checkModelStateCreateEdit(ActionEnumForm.edit, item));
}
