private bool checkModelStateCreateEdit(ActionEnumForm action, production_order_model item)
{
if (string.IsNullOrEmpty(item.db.name))
{
ModelState.AddModelError("db.name", "required");
}
var search = repo.FindAll().Where(d => d.db.name == item.db.name && d.db.id != item.db.id).Count();
if (search > 0)
{
ModelState.AddModelError("db.name", "existed");
}
if (item.db.id_business_sale_order == null)
{
ModelState.AddModelError("db.id_business_sale_order", "required");
}
if (item.list_item.Count == 0)
{
ModelState.AddModelError("list_item", "required");
}
//if (item.list_need_supplier.Count == 0)
//{
// ModelState.AddModelError("list_need_supplier_date", "required");
//}
return(ModelState.IsValid);
}
public async Task <int> insert(production_order_model model)
{
model.db.status_del = 1;
if (model.db.id_business_sale_order != null)
{
model.db.id_customer = _context.business_sale_orders.Where(t => t.id == model.db.id_business_sale_order)
.Select(d => d.id_customer).SingleOrDefault();
}
await _context.production_orders.AddAsync(model.db);
_context.SaveChanges();
saveDetail(model);
saveDetailProvide(model);
return(1);
}
public void saveDetail(production_order_model model)
{
var delete1 = _context.production_order_items.Where(t => t.id_production_order == model.db.id);
_context.RemoveRange(delete1);
_context.SaveChanges();
model.list_item.ForEach(t =>
{
t.db.id = 0;
t.db.status_schedule = 1;
t.db.id_production_order = model.db.id;
});
var listInsert1 = model.list_item.Select(d => d.db).ToList();
_context.production_order_items.AddRange(listInsert1);
_context.SaveChanges();
}
public void saveDetailProvide(production_order_model model)
{
var delete = _context.production_order_need_suppliers.Where(t => t.id_production_order == model.db.id);
_context.RemoveRange(delete);
_context.SaveChanges();
model.list_need_supplier.ForEach(t =>
{
t.db.id = 0;
t.db.id_production_order_item = model.list_item.Where(d => d.id ==
t.id_add_production_order_item).Select(d => d.db.id).FirstOrDefault();
t.db.id_production_order = model.db.id;
});
var listInsert = model.list_need_supplier.Select(d => d.db).ToList();
_context.production_order_need_suppliers.AddRange(listInsert);
_context.SaveChanges();
}
public int update(production_order_model model)
{
var db = _context.production_orders.Where(d => d.id == model.db.id).FirstOrDefault();
db.name = model.db.name;
db.update_by = model.db.update_by;
db.update_date = model.db.update_date;
if (model.db.id_business_sale_order != null)
{
db.id_customer = _context.business_sale_orders.Where(t => t.id == model.db.id_business_sale_order)
.Select(d => d.id_customer).SingleOrDefault();
}
db.id_business_sale_order = model.db.id_business_sale_order;
db.note = model.db.note;
_context.SaveChanges();
saveDetail(model);
saveDetailProvide(model);
return(1);
}
private bool checkModelStateEdit(production_order_model item)
{
return(checkModelStateCreateEdit(ActionEnumForm.edit, item));
}
