public async Task <int> insert(maintenance_error_list_model model) { await _context.maintenance_error_lists.AddAsync(model.db); _context.SaveChanges(); return(1); }
public async Task <int> insert(sys_warehouse_model model) { await _context.sys_warehouses.AddAsync(model.db); _context.SaveChanges(); return(1); }
public async Task <int> insert(sys_workstation_model model) { await _context.sys_workstations.AddAsync(model.db); _context.SaveChanges(); return(1); }
public async Task <int> insert(sys_template_opc_param_model model) { await _context.sys_template_opc_params.AddAsync(model.db); _context.SaveChanges(); return(1); }
public async Task <int> insertListError(List <quality_error_check_list_db> listError) { await _context.quality_error_check_lists.AddRangeAsync(listError); _context.SaveChanges(); return(1); }
public async Task <int> insert(sys_factory_model model) { await _context.sys_factorys.AddAsync(model.db); _context.SaveChanges(); return(1); }
public async Task <int> insert(sys_department_model model) { await _context.sys_departments.AddAsync(model.db); _context.SaveChanges(); return(1); }
public async Task <int> insert(sys_delivery_type_model model) { await _context.sys_delivery_types.AddAsync(model.db); _context.SaveChanges(); return(1); }
public async Task <int> insert(quality_solution_model model) { model.db.status_del = 1; await _context.quality_solutions.AddAsync(model.db); _context.SaveChanges(); return(1); }
public async Task <int> insert(maintenance_system_device_detail_model model) { //model.db.maintenance_period = _context.maintenance_systems.Where(m=>m.id == model.db.id_maintenance_system).Select(m=> m.maintenance_period).SingleOrDefault(); await _context.maintenance_system_device_details.AddAsync(model.db); _context.SaveChanges(); return(1); }
public async Task <int> insert(sys_approval_config_model model) { model.db.step = model.list_item.Select(d => d.db.step_num).Max(); await _context.sys_approval_configs.AddAsync(model.db); _context.SaveChanges(); saveDetail(model); return(1); }
public async Task <int> insert(maintenance_repair_order_model model) { model.db.repair_status = 1; //model.db.maintenance_period = _context.maintenance_systems.Where(m=>m.id == model.db.id_maintenance_system).Select(m=> m.maintenance_period).SingleOrDefault(); await _context.maintenance_repair_orders.AddAsync(model.db); _context.SaveChanges(); return(1); }
public async Task <int> insert(sys_item_specification_model model) { model.db.id = 0; await _context.sys_item_specifications.AddAsync(model.db); _context.SaveChanges(); syncItem(model.db.id_item); return(1); }
public void calculate(DateTime dateFilter, string id_factory, string id_factory_line) { //get list workstation var list_workstation = _context.sys_workstations.Where(d => d.id_sys_factory == id_factory).Where(d => d.id_sys_factory_line == id_factory_line) .Select(d => d.id).ToList(); var listadd = new List <production_report_work_done_db>(); for (int i = 0; i < list_workstation.Count; i++) { var list_process = _context.production_processes.ToList() .Where(d => d.id_workstation == list_workstation[i]) .Where(d => CompareDateTime(d.working_date, dateFilter) == 0) .Select(d => d).AsQueryable(); var all_quantity_item_done = list_process .Sum(d => d.quantity_product) ?? 0; var all_quantity_item_error = list_process .Sum(d => d.quantity_error) ?? 0;; var all_quantity_item_need = list_process .Sum(d => d.quantity_need) ?? 0;; var workstation_db = _context.sys_workstations.Where(w => w.id == list_workstation[i]).SingleOrDefault(); var db = new production_report_work_done_db() { date_update = DateTime.Now, id = 0, all_quantity_item_done = all_quantity_item_done, all_quantity_item_error = all_quantity_item_error, all_quantity_item_need = all_quantity_item_need, id_factory = workstation_db.id_sys_factory, id_factory_line = workstation_db.id_sys_factory_line, create_date = DateTime.Now, day = dateFilter.Day, month = dateFilter.Month, year = dateFilter.Year, id_workstation = workstation_db.id, }; listadd.Add(db); } for (int i = 0; i < listadd.Count; i++) { var db_need_update = _context.production_report_work_dones.Where(d => d.id_workstation == listadd[i].id_workstation).Where(d => d.day == dateFilter.Day && d.month == dateFilter.Month && d.year == dateFilter.Year).SingleOrDefault(); if (db_need_update != null) { db_need_update.update_date = DateTime.Now; db_need_update.all_quantity_item_done = listadd[i].all_quantity_item_done; db_need_update.all_quantity_item_error = listadd[i].all_quantity_item_error; db_need_update.all_quantity_item_need = listadd[i].all_quantity_item_need; _context.SaveChanges(); } if (db_need_update == null) { _context.production_report_work_dones.Add(listadd[i]); } _context.SaveChanges(); } }
public int update(production_order_need_supplier_master_model model) { var db = _context.production_order_items.Where(d => d.id == model.db.id).FirstOrDefault(); db.id_item_bom_config = model.db.id_item_bom_config; db.status_bom = 2; _context.SaveChanges(); saveDetailProvide(model); return(1); }
public int update(List <inventory_item_line_up_model> model) { var db_receiving_item = _context.inventory_receiving_items.Where(i => i.id == model[0].db.id_receiving_item).SingleOrDefault(); db_receiving_item.line_up_status = 2; deleteInventoryLineUp(model); saveInventoryLineUp(model); _context.SaveChanges(); return(1); }
public async Task <int> insert(sys_inventory_position_item_capacity_model model) { 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.conversion_factor = specification.conversion_factor; } await _context.sys_inventory_position_item_capacitys.AddAsync(model.db); _context.SaveChanges(); return(1); }
public int sync_approval(string id_record, string id_approval) { var db = _context.production_orders.Where(d => d.id == id_record).FirstOrDefault(); db.id_approval = id_approval; _context.SaveChanges(); return(1); }
public int sync_approval(string id_record, string id_approval) { var db = _context.inventory_receivings.Where(d => d.id == id_record).FirstOrDefault(); db.id_approval = id_approval; _context.SaveChanges(); return(1); }
public void changeStatusMaintenance() { var listDB = _context.maintenance_schedual_system_devices.Where(d => _context.Fn_check_finish_approval(_context.maintenance_processes.Where(p => p.id_schedual_system_device == d.id).Select(t => t.id_approval).SingleOrDefault()) == true) .Select(d => d).ToList(); listDB.ForEach(item => item.status_maintenance = 2); _context.SaveChanges(); }
public int update(production_order_set_up_scheduleModel model) { saveDetail(model); saveDetailProvide(model); var db = _context.production_order_items.Where(d => d.id == model.db.id).FirstOrDefault(); db.status_schedule = 2; _context.SaveChanges(); return(1); }
public async Task <int> insert(sys_item_model model) { await _context.sys_items.AddAsync(model.db); _context.SaveChanges(); saveDetail(model); return(1); }
public async Task <int> insert(sys_vendor_item_model model, sys_vendor_item_history_model modelHistory) { 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.conversion_factor = specification.conversion_factor; } modelHistory.db.action = "Tạo mới"; await _context.sys_vendor_item_historys.AddAsync(modelHistory.db); await _context.sys_vendor_items.AddAsync(model.db); _context.SaveChanges(); return(1); }
public void remove_approval(techproDefautContext context, string id) { var remove = context.sys_approval_details.Where(d => d.id_approval == id); context.sys_approval_details.RemoveRange(remove); var remove1 = context.sys_approvals.Where(d => d.id == id); context.sys_approvals.RemoveRange(remove1); context.SaveChanges(); }
public async Task <int> insert(quality_item_config_detail_model model) { model.db.id = 0; if (model.db.id_specification != 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(); } else { model.db.id_specification = 0; 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; } await _context.quality_item_config_details.AddAsync(model.db); _context.SaveChanges(); return(1); }
public async Task <int> insert(sys_factory_line_model model) { await _context.sys_factory_lines.AddAsync(model.db); _context.SaveChanges(); var db = await _context.sys_factory_lines.Where(t => t.status_del == 1).Where(t => t.status_del == 1).Where(t => t.name == model.db.name).Select(t => t).SingleOrDefaultAsync(); string id_factory_line = db.id; string id_factory = db.id_factory; if (model.list_maintenance_system.Count != 0) { for (int i = 0; i < model.list_maintenance_system.Count; i++) { model.list_maintenance_system[i].id = 0; model.list_maintenance_system[i].id_factory = id_factory; model.list_maintenance_system[i].id_factory_line = id_factory_line; } saveDetailList(model); } _context.SaveChanges(); return(1); }
public int update(production_process_model model, string id_user) { var db = _context.production_processes.Where(d => d.id == model.db.id).FirstOrDefault(); db.name = model.db.name; var db_workstation = _context.sys_workstations.Where(w => w.id == model.id_workstation).SingleOrDefault(); db_workstation.id_worker = id_user; db.id_worker = id_user; db.status_process = 2; db.id_workstation = model.id_workstation; if (model.status_import.ToString() == null) { db.status_import = 1; } if (model.status_import.ToString() != null) { db.status_import = 2; } 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.quantity_error = model.db.quantity_error; db.quantity_product = model.db.quantity_product; db.quantity_need = model.db.quantity_need; db.note = model.db.note; _context.SaveChanges(); return(1); }
public int sync_approval(string id_record, string id_approval) { var db = _context.maintenance_plannings.Where(d => d.id == id_record).FirstOrDefault(); db.id_approval = id_approval; _context.SaveChanges(); return(1); }
public async Task <int> save(sys_work_schedule_factory_line_model model, int action) { if (action == 1) { await _context.sys_work_schedule_factory_lines.AddAsync(model.db); _context.SaveChanges(); } else { var db = _context.sys_work_schedule_factory_lines.Where(d => d.id == model.db.id).FirstOrDefault(); db.timeStart_1 = model.db.timeStart_1; db.timeStart_2 = model.db.timeStart_2; db.timeStart_3 = model.db.timeStart_3; db.timeEnd_1 = model.db.timeEnd_1; db.timeEnd_2 = model.db.timeEnd_2; db.timeEnd_3 = model.db.timeEnd_3; _context.SaveChanges(); } return(1); }
public async Task <int> insert(maintenance_process_model model) { model.db.status_del = 1; model.db.status_maintenance = 2; long id_maintenance_schedual_system_device = model.db.id; model.db.id_schedual_system_device = id_maintenance_schedual_system_device; model.db.id = 0; await _context.maintenance_processes.AddAsync(model.db); // changeStatusMaintenance(id_maintenance_schedual_system_device); _context.SaveChanges(); saveCheckList(model); saveListPeople(model); return(1); }