private bool checkModelStateCreateEdit(ActionEnumForm action, sys_item_bom_model item)
{
if (item.db.quota <= 0)
{
ModelState.AddModelError("db.quota", "required");
}
return(ModelState.IsValid);
}
public int update(sys_item_bom_model model)
{
var db = _context.sys_item_boms.Where(d => d.id == model.db.id).FirstOrDefault();
db.id_item = model.db.id_item;
db.update_by = model.db.update_by;
db.update_date = model.db.update_date;
_context.SaveChanges();
return(1);
}
private bool checkModelStateCreate(sys_item_bom_model item)
{
if (string.IsNullOrEmpty(item.db.id_item_bom))
{
ModelState.AddModelError("db.id_item_bom", "required");
}
var search = repo.FindAll().Where(d =>
d.db.id_item == item.db.id_item &&
d.db.id_item_bom_config == item.db.id_item_bom_config &&
d.db.id_specification == item.db.id_specification &&
d.db.id_item_bom == item.db.id_item_bom && d.db.id != item.db.id).Count();
if (search > 0)
{
ModelState.AddModelError("db.id_item_bom", "existed");
}
return(checkModelStateCreateEdit(ActionEnumForm.create, item));
}
public async Task <int> insert(sys_item_bom_model model)
{
model.db.id = 0;
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.quota_main = specification.conversion_factor * model.db.quota;
model.db.conversion_factor = specification.conversion_factor;
}
else
{
model.db.id_unit = _context.sys_items.Where(t => t.id == model.db.id_item).Select(t => t.id_unit).SingleOrDefault();
model.db.id_unit_main = model.db.id_unit;
model.db.quota_main = model.db.quota;
model.db.conversion_factor = 1;
}
await _context.sys_item_boms.AddAsync(model.db);
_context.SaveChanges();
return(1);
}
private bool checkModelStateEdit(sys_item_bom_model item)
{
return(checkModelStateCreateEdit(ActionEnumForm.edit, item));
}
