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)); }