public void deleteListSolution(maintenance_error_reason_model model)
{
var listDelete = _context.maintenance_error_reason_list_solutions
.Where(d => d.id_reason == model.db.id)
.Select(d => d).ToList();
_context.maintenance_error_reason_list_solutions.RemoveRange(listDelete);
_context.SaveChanges();
}
public async Task <int> insert(maintenance_error_reason_model model)
{
await _context.maintenance_error_reasons.AddAsync(model.db);
_context.SaveChanges();
var id_reason = await _context.maintenance_error_reasons.Where(t => t.reason_name == model.db.reason_name).Select(t => t.id).SingleOrDefaultAsync();
model.db.id = id_reason;
saveListSolution(model);
_context.SaveChanges();
return(1);
}
public int update(maintenance_error_reason_model model)
{
var db = _context.maintenance_error_reasons.Where(d => d.id == model.db.id).FirstOrDefault();
db.status_del = model.db.status_del;
db.id_error = model.db.id_error;
db.update_by = model.db.update_by;
db.update_date = model.db.update_date;
deleteListSolution(model);
saveListSolution(model);
_context.SaveChanges();
return(1);
}
public void saveListSolution(maintenance_error_reason_model model)
{
for (int i = 0; i < model.list_solution.Count(); i++)
{
var newDb = new maintenance_error_reason_list_solution_db()
{
create_by = model.db.create_by,
create_date = DateTime.Now,
id_error = model.db.id_error,
solution_name = model.list_solution[i].db.solution_name,
note = model.list_solution[i].db.note,
id_reason = model.db.id,
status_del = 1,
id = 0,
};
_context.maintenance_error_reason_list_solutions.Add(newDb);
}
_context.SaveChanges();
}
private bool checkModelStateCreateEdit(ActionEnumForm action, maintenance_error_reason_model item)
{
if (string.IsNullOrEmpty(item.db.reason_name))
{
ModelState.AddModelError("db.error_solution", "required");
}
if (item.db.id_error == null)
{
ModelState.AddModelError("db.id_error", "required");
}
var searchName = repo.FindAll().Where(d =>
d.db.reason_name == item.db.reason_name && d.db.id != item.db.id).Count();
if (searchName > 0)
{
ModelState.AddModelError("db.reason_name", "existed");
}
return(ModelState.IsValid);
}
private bool checkModelStateEdit(maintenance_error_reason_model item)
{
return(checkModelStateCreateEdit(ActionEnumForm.edit, item));
}
