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