private void deleteCheckListDevice(maintenance_system_device_group_model model) { var listDelete = _context.maintenance_system_device_maintenance_group_devices .Where(d => d.id_group == model.db.id) .Select(d => d).ToList(); _context.maintenance_system_device_maintenance_group_devices.RemoveRange(listDelete); _context.SaveChanges(); }
private void saveCheckList(maintenance_system_device_group_model model) { for (int i = 0; i < model.list_check_list.Count(); i++) { model.list_check_list[i].id = 0; _context.maintenance_checklist_groups.Add(model.list_check_list[i]); } _context.SaveChanges(); }
private void saveCheckListDevice(maintenance_system_device_group_model model, string id_group) { for (int i = 0; i < model.list_system_device.Count(); i++) { _context.maintenance_system_device_maintenance_group_devices.Add(new maintenance_system_device_maintenance_group_device_db { id = 0, id_group = id_group, id_system_device = model.list_system_device[i].id, note = model.list_system_device[i].note, create_date = DateTime.Now, }); } _context.SaveChanges(); }
private bool checkModelStateCreateEdit(ActionEnumForm action, maintenance_system_device_group_model item) { if (string.IsNullOrEmpty(item.db.name)) { ModelState.AddModelError("db.name", "required"); } var searchName = repo.FindAll().Where(d => d.db.name == item.db.name && d.db.id != item.db.id).Count(); if (searchName > 0) { ModelState.AddModelError("db.name", "existed"); } return(ModelState.IsValid); }
public int update(maintenance_system_device_group_model model) { var db = _context.maintenance_system_device_groups.Where(d => d.id == model.db.id).FirstOrDefault(); db.name = model.db.name; db.status_del = model.db.status_del; var id_group = _context.maintenance_system_device_groups.Where(t => t.name == model.db.name).Select(t => t.id).SingleOrDefault(); db.update_by = model.db.update_by; db.update_date = model.db.update_date; deleteCheckList(model); saveCheckList(model); deleteCheckListDevice(model); saveCheckListDevice(model, id_group); _context.SaveChanges(); return(1); }
public async Task <int> insert(maintenance_system_device_group_model model) { await _context.maintenance_system_device_groups.AddAsync(model.db); _context.SaveChanges(); var id_group = await _context.maintenance_system_device_groups.Where(t => t.name == model.db.name).Select(t => t.id).SingleOrDefaultAsync(); if (model.list_check_list.Count != 0) { for (int i = 0; i < model.list_check_list.Count; i++) { model.list_check_list[i].id_group = id_group; } saveCheckList(model); } if (model.list_system_device.Count != 0) { saveCheckListDevice(model, id_group); } _context.SaveChanges(); return(1); }
private bool checkModelStateEdit(maintenance_system_device_group_model item) { return(checkModelStateCreateEdit(ActionEnumForm.edit, item)); }