public int additional_export(production_order_set_up_scheduleModel model)
{
var listinsertNeed = new List <production_order_need_supplier_schedule_db>();
var ids = model.list_item_need_suppliers_schedule.Select(t => t.db.id).Distinct().ToList();
var listdelete = _context.production_order_need_supplier_schedules
.Where(t => t.id_production_order_item == model.db.id)
.Where(t => t.type == 2)
.Where(t => !ids.Contains(t.id));
_context.RemoveRange(listdelete);
_context.SaveChanges();
for (int i = 0; i < model.list_item_need_suppliers_schedule.Count; i++)
{
var item = model.list_item_need_suppliers_schedule[i];
if (item.db.id == 0)
{
item.db.quantity_unit_main = item.db.quantity * item.db.conversion_factor;
item.db.status_export = 1;
item.db.index_pos = i;
item.db.id_production_order = model.db.id_production_order;
item.db.id_production_order_item = model.db.id;
item.db.status_del = 1;
listinsertNeed.Add(item.db);
}
}
_context.production_order_need_supplier_schedules.AddRange(listinsertNeed);
_context.SaveChanges();
return(1);
}
public void saveDetail(sys_item_model model)
{
var delete1 = _context.sys_item_unit_others.Where(t => t.id_item == model.db.id);
_context.RemoveRange(delete1);
_context.SaveChanges();
model.listsys_item_unit_other.ForEach(t =>
{
t.db.id = 0;
t.db.id_item = model.db.id;
});
var listInsert1 = model.listsys_item_unit_other.Select(d => d.db).ToList();
_context.sys_item_unit_others.AddRange(listInsert1);
_context.SaveChanges();
var delete = _context.sys_item_min_max_stocks.Where(t => t.id_item == model.db.id);
_context.RemoveRange(delete);
_context.SaveChanges();
model.list_item_min_max_stock.ForEach(t =>
{
t.db.id = 0;
t.db.id_item = model.db.id;
});
var listInsert = model.list_item_min_max_stock.Select(d => d.db).ToList();
_context.sys_item_min_max_stocks.AddRange(listInsert);
_context.SaveChanges();
}
public void saveDetail(sys_group_user_model model)
{
var delete1 = _context.sys_group_user_details.Where(t => t.id_group_user == model.db.id);
_context.RemoveRange(delete1);
_context.SaveChanges();
model.list_item.ForEach(t =>
{
t.db.id = 0;
t.db.id_group_user = model.db.id;
});
var listInsert1 = model.list_item.Select(d => d.db).ToList();
_context.sys_group_user_details.AddRange(listInsert1);
_context.SaveChanges();
var delete = _context.sys_group_user_roles.Where(t => t.id_group_user == model.db.id);
_context.RemoveRange(delete);
_context.SaveChanges();
model.list_role.ForEach(t =>
{
t.db.id = 0;
t.db.id_group_user = model.db.id;
});
var listInsert = model.list_role.Select(d => d.db).ToList();
_context.sys_group_user_roles.AddRange(listInsert);
_context.SaveChanges();
}
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 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 saveDetail(sys_approval_config_model model)
{
var delete = _context.sys_approval_config_details.Where(t => t.id_approval_config == model.db.id);
_context.RemoveRange(delete);
_context.SaveChanges();
model.list_item.ForEach(t =>
{
t.db.id = 0;
t.db.id_approval_config = model.db.id;
t.db.duration_hours = t.db.duration_hours ?? 0;
});
var listInsert = model.list_item.Select(d => d.db).ToList();
_context.sys_approval_config_details.AddRange(listInsert);
_context.SaveChanges();
}
public void saveDetailProvide(production_order_need_supplier_master_model model)
{
var delete = _context.production_order_need_suppliers.Where(t => t.id_production_order_item == model.db.id);
_context.RemoveRange(delete);
_context.SaveChanges();
var production_item = _context.production_order_items.Where(t => t.id == model.db.id).SingleOrDefault();
model.list_need_supplier.ForEach(t =>
{
t.db.id = 0;
t.db.quantity = t.db.quota * production_item.quantity;
t.db.quantity_unit_main = t.db.quota_main * production_item.quantity;
});
var listInsert = model.list_need_supplier.Select(d => d.db).ToList();
_context.production_order_need_suppliers.AddRange(listInsert);
_context.SaveChanges();
}
public void saveStep(sys_approval_model model)
{
var delete = _context.sys_approval_steps.Where(t => t.id_approval == model.db.id);
_context.RemoveRange(delete);
_context.SaveChanges();
model.list_step.ForEach(t =>
{
t.db.id = 0;
t.db.status = 4;
if (t.db.step_num == 1)
{
t.db.status = 1;
}
t.db.id_approval_config = model.db.id_sys_approval_config;
t.db.id_approval = model.db.id;
});
var listInsert = model.list_step.Select(d => d.db).ToList();
_context.sys_approval_steps.AddRange(listInsert);
_context.SaveChanges();
}
public void saveDetail(inventory_receiving_model model)
{
var delete = _context.inventory_receiving_items.Where(t => t.id_inventory_receiving == model.db.id);
_context.RemoveRange(delete);
_context.SaveChanges();
model.list_item.ForEach(t =>
{
t.db.id_warehouse = model.db.id_warehouse;
t.db.id = 0;
t.db.id_inventory_receiving = model.db.id;
t.db.line_up_status = 1;
if (t.db.conversion_factor == null)
{
t.db.conversion_factor = 1;
}
t.db.quantity_unit_main = t.db.quantity * t.db.conversion_factor;
});
var listInsert = model.list_item.Select(d => d.db).ToList();
_context.inventory_receiving_items.AddRange(listInsert);
_context.SaveChanges();
}