public int update(sys_vendor_item_model model, sys_vendor_item_history_model modelHistory) { var db = _context.sys_vendor_items.Where(d => d.id == model.db.id).FirstOrDefault(); db.min_stock_order = model.db.min_stock_order; db.delivery_time = model.db.delivery_time; db.update_by = model.db.update_by; db.update_date = model.db.update_date; modelHistory.db.action = "Sửa"; _context.sys_vendor_item_historys.AddAsync(modelHistory.db); _context.SaveChanges(); return(1); }
public async Task <int> insert(sys_vendor_item_model model, sys_vendor_item_history_model modelHistory) { if ((model.db.id_specification ?? 0) != 0) { var specification = _context.sys_item_specifications.Where(t => t.id == model.db.id_specification).SingleOrDefault(); model.db.id_unit = specification.id_unit; model.db.id_unit_main = _context.sys_items.Where(t => t.id == model.db.id_item).Select(t => t.id_unit).SingleOrDefault(); model.db.conversion_factor = specification.conversion_factor; } modelHistory.db.action = "Tạo mới"; await _context.sys_vendor_item_historys.AddAsync(modelHistory.db); await _context.sys_vendor_items.AddAsync(model.db); _context.SaveChanges(); return(1); }
private bool checkModelStateCreateEdit(ActionEnumForm action, sys_vendor_item_model item) { if (item.db.min_stock_order.ToString() == null || item.db.min_stock_order == 0) { ModelState.AddModelError("db.min_stock_order", "required"); } if (item.db.price_item.ToString() == null || item.db.price_item == 0) { ModelState.AddModelError("db.price_item", "required"); } if (item.db.delivery_time.ToString() == null || item.db.delivery_time == 0) { ModelState.AddModelError("db.delivery_time", "required"); } if (string.IsNullOrEmpty(item.db.id_item)) { ModelState.AddModelError("db.id_item", "required"); } int searchName = 0; if (action == ActionEnumForm.create) { searchName = repo.FindAll().Where(d => d.db.create_by == item.db.create_by && d.db.id_item == item.db.id_item && d.db.id_specification == item.db.id_specification && d.db.id != item.db.id).Count(); } if (searchName > 0) { ModelState.AddModelError("db.id_item", "existed"); ModelState.AddModelError("db.id_specification", "existed"); } return(ModelState.IsValid); }
private bool checkModelStateEdit(sys_vendor_item_model item) { return(checkModelStateCreateEdit(ActionEnumForm.edit, item)); }