private void bwLoad_DoWork(object sender, DoWorkEventArgs e) { orderList = OrderController.Select(); supplierList = SupplierController.Select(); componentList = ComponentController.Select(); sizeRunList = SizeRunController.Select(); offDayList = OffDayController.Select(); offDayMapList = OffDayMapController.Select(); }
private void RemoveOffDayMap(int offDayID) { var offDayMapList_RemoveItem = OffDayMapController.Select().Where(w => w.OffDayID == offDayID).ToList(); if (offDayMapList_RemoveItem.Count() > 0) { foreach (var removeOffDayMap in offDayMapList_RemoveItem) { OffDayMapController.Delete(removeOffDayMap.ID); } } }
private void dgOffDay_MouseLeftButtonDown(object sender, MouseButtonEventArgs e) { offDayCurrent = dgOffDay.CurrentItem as OffDay; if (offDayCurrent == null) { return; } insertOrUpdate = false; InjectModelToControl(offDayCurrent); HighlightItemClicked(); var offDayMapClickedList = OffDayMapController.Select().Where(w => w.OffDayID == offDayCurrent.OffDayID).ToList(); var supplierID_OffDayMapClickedList = offDayMapClickedList.Select(s => s.SupplierID).Distinct().ToList(); var supplier_OffDayMapClicked = supplierDefaultList.Where(w => supplierID_OffDayMapClickedList.Contains(w.SupplierID)).ToList(); supplierCurrentList.Clear(); supplierCurrentList.AddRange(supplier_OffDayMapClicked); LoadSupplier(supplierCurrentList); }
private void bwSave_DoWork(object sender, DoWorkEventArgs e) { if (insertOrUpdate == true) { OffDayController.Insert(offDay); offDayCurrentList.Add(offDay); foreach (var supp in supplierCurrentList) { var offDayMapInsert = new OffDay_Supplier_Mapping() { SupplierID = supp.SupplierID, OffDayID = offDay.OffDayID }; OffDayMapController.Insert(offDayMapInsert); } } if (insertOrUpdate == false) { // Update OffDay OffDayController.Update(offDayCurrent); // Delete OffDayMap RemoveOffDayMap(offDayCurrent.OffDayID); // Insert OffDayMap foreach (var supp in supplierCurrentList) { var offDayMapInsert = new OffDay_Supplier_Mapping() { SupplierID = supp.SupplierID, OffDayID = offDayCurrent.OffDayID }; OffDayMapController.Insert(offDayMapInsert); } } }