public void saveListItemRepair(maintenance_repair_process_model model)
{
for (int i = 0; i < model.list_item_repair.Count(); i++)
{
var newDb = new maintenance_repair_replaced_device_db()
{
create_by = model.list_item_repair[i].db.create_by,
create_date = DateTime.Now,
id_maintenance_repair_process = model.db.id,
id_item = model.list_item_repair[i].db.id_item,
id_specification = model.list_item_repair[i].db.id_specification,
id_unit = model.list_item_repair[i].db.id_unit,
id_unit_main = model.list_item_repair[i].db.id_unit_main,
id_warehouse_position = model.list_item_repair[i].db.id_warehouse_position,
quantity = model.list_item_repair[i].db.quantity,
quantity_unit_main = model.list_item_repair[i].db.quantity_unit_main,
sys_item_unit_main_name = model.list_item_repair[i].db.sys_item_unit_main_name,
type_add = model.list_item_repair[i].db.type_add,
status_del = 1,
id = 0,
};
_context.maintenance_repair_replaced_devices.Add(newDb);
}
_context.SaveChanges();
}
public void deleteListPeople(maintenance_repair_process_model model)
{
var listDelete = _context.maintenance_repair_process_peoples
.Where(d => d.id_maintenance_repair_process == model.db.id)
.Select(d => d).ToList();
_context.maintenance_repair_process_peoples.RemoveRange(listDelete);
_context.SaveChanges();
}
private bool checkModelStateCreateEdit(ActionEnumForm action, maintenance_repair_process_model item)
{
if (string.IsNullOrEmpty(item.db.name))
{
ModelState.AddModelError("db.name", "required");
}
var searchName = repo._context.maintenance_repair_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 int update(maintenance_repair_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);
deleteListPeople(model);
saveListPeople(model);
deleteListItemRepair(model);
saveListItemRepair(model);
deleteListSolution(model);
saveListSolution(model);
_context.SaveChanges();
return(1);
}
public void saveListPeople(maintenance_repair_process_model model)
{
for (int i = 0; i < model.list_people.Count(); i++)
{
var newDb = new maintenance_repair_process_people_db()
{
create_by = model.list_people[i].db.create_by,
create_date = DateTime.Now,
id_maintenance_repair_process = model.db.id,
id_people = model.list_people[i].id_people,
note = model.list_people[i].db.note,
status_del = 1,
id = 0,
};
_context.maintenance_repair_process_peoples.Add(newDb);
}
_context.SaveChanges();
}
public void saveListSolution(maintenance_repair_process_model model)
{
for (int i = 0; i < model.list_solution.Count(); i++)
{
var newDb = new maintenance_repair_error_solution_db()
{
create_by = model.list_solution[i].db.create_by,
create_date = DateTime.Now,
status_maintenance = model.list_solution[i].db.status_maintenance,
id_maintenance_repair_process = model.db.id,
id_error = model.list_solution[i].db.id_error,
id_reason = model.list_solution[i].db.id_reason,
id_solution = model.list_solution[i].db.id_solution,
note = model.list_solution[i].db.note,
status_del = 1,
id = 0,
};
_context.maintenance_repair_error_solutions.Add(newDb);
}
_context.SaveChanges();
}
public async Task <int> insert(maintenance_repair_process_model model)
{
model.db.status_del = 1;
model.db.id = 0;
await _context.maintenance_repair_processes.AddAsync(model.db);
_context.SaveChanges();
var id_repair_process = await _context.maintenance_repair_processes.Where(t => t.name == model.db.name).Select(t => t.id).SingleOrDefaultAsync();
model.db.id = id_repair_process;
if (model.list_item_repair.Count != 0)
{
saveListItemRepair(model);
}
if (model.list_solution.Count != 0)
{
saveListSolution(model);
}
if (model.list_people.Count != 0)
{
saveListPeople(model);
}
return(1);
}
private bool checkModelStateEdit(maintenance_repair_process_model item)
{
return(checkModelStateCreateEdit(ActionEnumForm.edit, item));
}
