public void saveCheckList(maintenance_process_model model)
{
for (int i = 0; i < model.list_check_list.Count(); i++)
{
model.list_check_list[i].id = 0;
var newDb = new maintenance_process_checklist_detail_db()
{
create_by = model.list_check_list[i].create_by,
create_date = DateTime.Now,
device_information = model.list_check_list[i].device_information,
evaluated_information = model.list_check_list[i].evaluated_information,
id_maintenance_schedual_system_device = model.db.id,
id_maintenance_system = model.db.id_maintenance_system,
id_maintenance_system_device = model.db.id_maintenance_system_device,
note = model.list_check_list[i].note,
status_del = model.list_check_list[i].status_del,
status_maintenance = model.list_check_list[i].status_maintenance,
times = model.db.times,
estimate_maintenance_date = model.db.estimate_maintenance_date,
id = 0,
};
_context.maintenance_process_checklist_details.Add(newDb);
}
_context.SaveChanges();
}
private bool checkModelStateCreateEdit(ActionEnumForm action, maintenance_process_model item)
{
if (string.IsNullOrEmpty(item.db.name))
{
ModelState.AddModelError("db.name", "required");
}
if (item.db.start_time == default(DateTime))
{
ModelState.AddModelError("db.start_time", "required");
}
if (item.db.end_time == default(DateTime))
{
ModelState.AddModelError("db.start_time", "required");
}
var searchName = repo._context.maintenance_processes.Where(d =>
d.name == item.db.name && d.id != item.db.id).Count();
if (searchName > 0)
{
ModelState.AddModelError("db.name", "existed");
}
return(ModelState.IsValid);
}
public void deleteListPeople(maintenance_process_model model)
{
var listDelete = _context.maintenance_process_peoples
.Where(d => d.id_maintenance_process == model.db.id)
.Select(d => d).ToList();
_context.maintenance_process_peoples.RemoveRange(listDelete);
_context.SaveChanges();
}
public void deleteCheckList(maintenance_process_model model)
{
var listDelete = _context.maintenance_process_checklist_details
.Where(d => d.id_maintenance_system == model.db.id_maintenance_system)
.Where(d => d.id_maintenance_system_device == model.db.id_maintenance_system_device)
.Where(d => d.times == model.db.times)
.Select(d => d).ToList();
_context.maintenance_process_checklist_details.RemoveRange(listDelete);
_context.SaveChanges();
}
public void saveListPeople(maintenance_process_model model)
{
for (int i = 0; i < model.list_people.Count(); i++)
{
var newDb = new maintenance_process_people_db()
{
create_by = model.list_people[i].db.create_by,
create_date = DateTime.Now,
id_maintenance_process = model.db.id,
id_people = model.list_people[i].db.id_people,
note = model.list_people[i].db.note,
status_del = 1,
id = 0,
};
_context.maintenance_process_peoples.Add(newDb);
}
_context.SaveChanges();
}
public async Task <int> insert(maintenance_process_model model)
{
model.db.status_del = 1;
model.db.status_maintenance = 2;
long id_maintenance_schedual_system_device = model.db.id;
model.db.id_schedual_system_device = id_maintenance_schedual_system_device;
model.db.id = 0;
await _context.maintenance_processes.AddAsync(model.db);
// changeStatusMaintenance(id_maintenance_schedual_system_device);
_context.SaveChanges();
saveCheckList(model);
saveListPeople(model);
return(1);
}
public int update(maintenance_process_model model)
{
var db = _context.maintenance_schedual_system_devices
.Where(d => d.id == model.db.id)
.Where(d => d.id_maintenance_system == model.db.id_maintenance_system)
.Where(d => d.id_maintenance_system_device == model.db.id_maintenance_system_device)
.Where(d => d.id_factory == model.db.id_factory)
.Where(d => d.id_factory_line == model.db.id_factory_line)
.Where(d => d.id_planning == model.db.id_planning)
.Where(d => d.times == model.db.times).Select(d => d).SingleOrDefault();
db.status_maintenance = 2;
deleteCheckList(model);
saveCheckList(model);
deleteListPeople(model);
saveListPeople(model);
_context.SaveChanges();
return(1);
}
private bool checkModelStateEdit(maintenance_process_model item)
{
return(checkModelStateCreateEdit(ActionEnumForm.edit, item));
}