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