public async Task <int> insert(sys_factory_line_model model) { await _context.sys_factory_lines.AddAsync(model.db); _context.SaveChanges(); var db = await _context.sys_factory_lines.Where(t => t.status_del == 1).Where(t => t.status_del == 1).Where(t => t.name == model.db.name).Select(t => t).SingleOrDefaultAsync(); string id_factory_line = db.id; string id_factory = db.id_factory; if (model.list_maintenance_system.Count != 0) { for (int i = 0; i < model.list_maintenance_system.Count; i++) { model.list_maintenance_system[i].id = 0; model.list_maintenance_system[i].id_factory = id_factory; model.list_maintenance_system[i].id_factory_line = id_factory_line; } saveDetailList(model); } _context.SaveChanges(); return(1); }
private void deleteDetailList(sys_factory_line_model model) { var listDelete = _context.sys_factory_line_list_maintenance_systems .Where(d => d.id_factory_line == model.db.id) .Select(d => d).ToList(); _context.sys_factory_line_list_maintenance_systems.RemoveRange(listDelete); _context.SaveChanges(); }
public int update(sys_factory_line_model model) { var db = _context.sys_factory_lines.Where(t => t.status_del == 1).Where(d => d.id == model.db.id).FirstOrDefault(); db.name = model.db.name; db.note = model.db.note; db.id_factory = model.db.id_factory; db.update_by = model.db.update_by; db.update_date = model.db.update_date; db.status_del = model.db.status_del; _context.SaveChanges(); deleteDetailList(model); saveDetailList(model); return(1); }
private void saveDetailList(sys_factory_line_model model) { for (int i = 0; i < model.list_maintenance_system.Count(); i++) { _context.sys_factory_line_list_maintenance_systems.Add(new sys_factory_line_list_maintenance_system_db { id = 0, id_system = model.list_maintenance_system[i].id_system, id_factory_line = model.db.id, id_factory = model.db.id_factory, name = model.list_maintenance_system[i].name, note = model.list_maintenance_system[i].note, create_date = DateTime.Now, }); } _context.SaveChanges(); }
private bool checkModelStateCreateEdit(ActionEnumForm action, sys_factory_line_model item) { if (string.IsNullOrEmpty(item.db.id_factory)) { ModelState.AddModelError("db.id_factory", "required"); } if (string.IsNullOrEmpty(item.db.name)) { ModelState.AddModelError("db.name", "required"); } var searchName = repo.FindAll().Where(d => d.db.id_factory == item.db.id_factory && d.db.name == item.db.name && d.db.id != item.db.id).Count(); if (searchName > 0) { ModelState.AddModelError("db.name", "existed"); } return(ModelState.IsValid); }
private bool checkModelStateEdit(sys_factory_line_model item) { return(checkModelStateCreateEdit(ActionEnumForm.edit, item)); }