private bool checkModelStateCreateEdit(ActionEnumForm action, business_sale_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_customer == null)
{
ModelState.AddModelError("db.id_customer", "required");
}
if (item.db.estimated_delivery_date == null)
{
ModelState.AddModelError("db.estimated_delivery_date", "required");
}
if (item.list_export_date.Count == 0)
{
ModelState.AddModelError("list_export_date", "required");
}
return(ModelState.IsValid);
}
public async Task <int> insert(business_sale_order_model model)
{
model.db.status_del = 1;
await _context.business_sale_orders.AddAsync(model.db);
_context.SaveChanges();
saveDetail(model);
return(1);
}
public void saveDetail(business_sale_order_model model)
{
var delete1 = _context.business_sale_order_export_dates.Where(t => t.id_business_sale_order == model.db.id);
_context.RemoveRange(delete1);
_context.SaveChanges();
model.list_export_date.ForEach(t =>
{
t.db.id = 0;
t.db.status_export = 1;
t.db.id_business_sale_order = model.db.id;
t.db.quantity_export = 0;
});
var listInsert1 = model.list_export_date.Select(d => d.db).ToList();
_context.business_sale_order_export_dates.AddRange(listInsert1);
_context.SaveChanges();
var listInsert = model.list_export_date.GroupBy(d => new
{
id_item = d.db.id_item,
id_specification = d.db.id_specification,
id_unit = d.db.id_unit,
type_add = d.db.type_add,
conversion_factor = d.db.conversion_factor,
id_unit_main = d.db.id_unit_main,
id_business_sale_order = d.db.id_business_sale_order
}).Select(d => new business_sale_order_item_db()
{
id = 0,
id_item = d.Key.id_item,
id_specification = d.Key.id_specification,
conversion_factor = d.Key.conversion_factor,
id_business_sale_order = d.Key.id_business_sale_order,
id_unit = d.Key.id_unit,
id_unit_main = d.Key.id_unit_main,
quantity = d.Sum(d => d.db.quantity),
quantity_unit_main = d.Sum(d => d.db.quantity_unit_main),
type_add = d.Key.type_add,
note = "",
}).ToList();
var delete = _context.business_sale_order_items.Where(t => t.id_business_sale_order == model.db.id);
_context.RemoveRange(delete);
_context.SaveChanges();
_context.business_sale_order_items.AddRange(listInsert);
_context.SaveChanges();
}
public int update(business_sale_order_model model)
{
var db = _context.business_sale_orders.Where(d => d.id == model.db.id).FirstOrDefault();
db.name = model.db.name;
db.customer_address = model.db.customer_address;
db.customer_email = model.db.customer_email;
db.customer_fax = model.db.customer_fax;
db.customer_logo_path = model.db.customer_logo_path;
db.customer_name = model.db.customer_name;
db.customer_phone = model.db.customer_phone;
db.customer_tax_number = model.db.customer_tax_number;
db.name = model.db.name;
db.note = model.db.note;
db.id_customer = model.db.id_customer;
db.update_by = model.db.update_by;
db.update_date = model.db.update_date;
_context.SaveChanges();
saveDetail(model);
return(1);
}
private bool checkModelStateEdit(business_sale_order_model item)
{
return(checkModelStateCreateEdit(ActionEnumForm.edit, item));
}
