private void btnUpdateAvailableMachine_Click(object sender, RoutedEventArgs e) { if (MessageBox.Show("Confirm Save?", this.Title, MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.No) { return; } if (bwUpdate.IsBusy == false) { this.Cursor = Cursors.Wait; btnUpdateAvailableMachine.IsEnabled = false; availableMachineToUpdate = dgAvailableMachine.Items.OfType <AvailableMachineModel>().FirstOrDefault(); bwUpdate.RunWorkerAsync(); } }
private void bwDelete_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e) { this.Cursor = null; btnDelete.IsEnabled = true; btnSearch.IsEnabled = true; if (e.Error != null) { MessageBox.Show(e.Error.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error); return; } availableMachineModel = null; dgAvailableMachine.ItemsSource = null; btnUpdateAvailableMachine.IsEnabled = false; MessageBox.Show("Deleted!", this.Title, MessageBoxButton.OK, MessageBoxImage.Information); }
private void bwLoad_DoWork(object sender, DoWorkEventArgs e) { Excel.Application excelApplication = new Excel.Application(); Excel.Workbook excelWorkbook = excelApplication.Workbooks.Open(filePath); //excelApplication.Visible = true; Excel.Worksheet excelWorksheet; Excel.Range excelRange; try { excelWorksheet = (Excel.Worksheet)excelWorkbook.Worksheets[1]; excelRange = excelWorksheet.UsedRange; progressBar.Dispatcher.Invoke((Action)(() => progressBar.Maximum = excelRange.Rows.Count)); //int[] column = {2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50 }; for (int i = 3; i <= excelRange.Rows.Count; i++) { AvailableMachineModel availableMachine = new AvailableMachineModel(); var id = (excelRange.Cells[i, 1] as Excel.Range).Value2; if (id != null) { string idValue = id.ToString(); availableMachine.Id = idValue; //float cuttingArmCliker = 0; var cuttingArmClikerValue = (excelRange.Cells[i, 3] as Excel.Range).Value2; string cuttingArmCliker = ""; if (cuttingArmClikerValue != null) { cuttingArmCliker = cuttingArmClikerValue.ToString(); } availableMachine.CuttingArmClicker = cuttingArmCliker; //float cuttingBeam = 0; var cuttingBeamValue = (excelRange.Cells[i, 4] as Excel.Range).Value2; string cuttingBeam = ""; if (cuttingBeamValue != null) { cuttingBeam = cuttingBeamValue.ToString(); } availableMachine.CuttingBeam = cuttingBeam; //float cuttingCutStrap = 0; var cuttingCutStrapValue = (excelRange.Cells[i, 5] as Excel.Range).Value2; string cuttingCutStrap = ""; if (cuttingCutStrapValue != null) { cuttingCutStrap = cuttingCutStrapValue.ToString(); } availableMachine.CuttingCutStrap = cuttingCutStrap; //float cuttingLaser = 0; var cuttingLaserValue = (excelRange.Cells[i, 6] as Excel.Range).Value2; string cuttingLaser = ""; if (cuttingLaserValue != null) { cuttingLaser = cuttingLaserValue.ToString(); } availableMachine.CuttingLaser = cuttingLaser; var cuttingPuncherHoleValue = (excelRange.Cells[i, 7] as Excel.Range).Value2; string cuttingPuncherHole = ""; if (cuttingPuncherHoleValue != null) { cuttingPuncherHole = cuttingPuncherHoleValue.ToString(); } availableMachine.CuttingPuncherHole = cuttingPuncherHole; //float cuttingSkiving = 0; var cuttingSkivingValue = (excelRange.Cells[i, 8] as Excel.Range).Value2; string cuttingSkiving = ""; if (cuttingSkivingValue != null) { cuttingSkiving = cuttingSkivingValue.ToString(); } availableMachine.CuttingSkiving = cuttingSkiving; // Prep //float prepVerticalHF = 0; var prepVerticalHFValue = (excelRange.Cells[i, 9] as Excel.Range).Value2; string prepVerticalHF = ""; if (prepVerticalHFValue != null) { prepVerticalHF = prepVerticalHFValue.ToString(); } availableMachine.PrepVerticalHF = prepVerticalHF; //float prepHorizontalHF = 0; var prepHorizontalHFValue = (excelRange.Cells[i, 10] as Excel.Range).Value2; string prepHorizontalHF = ""; if (prepHorizontalHFValue != null) { prepHorizontalHF = prepHorizontalHFValue.ToString(); } availableMachine.PrepHorizontalHF = prepHorizontalHF; var prepOnlineHeatPressValue = (excelRange.Cells[i, 11] as Excel.Range).Value2; string prepOnlineHeatPress = ""; if (prepOnlineHeatPressValue != null) { prepOnlineHeatPress = prepOnlineHeatPressValue.ToString(); } availableMachine.PrepOnlineHeatPress = prepOnlineHeatPress; //float prepAutoHF = 0; var prepAutoHFValue = (excelRange.Cells[i, 12] as Excel.Range).Value2; string prepAutoHF = ""; if (prepAutoHFValue != null) { prepAutoHF = prepAutoHFValue.ToString(); } availableMachine.PrepAutoHF = prepAutoHF; //float prepInye = 0; var prepInyeValue = (excelRange.Cells[i, 13] as Excel.Range).Value2; string prepInye = ""; if (prepInyeValue != null) { prepInye = prepInyeValue.ToString(); } availableMachine.PrepInye = prepInye; //float prepHotmeltMachine = 0; var prepHotmeltMachineValue = (excelRange.Cells[i, 14] as Excel.Range).Value2; string prepHotmeltMachine = ""; if (prepHotmeltMachineValue != null) { prepHotmeltMachine = prepHotmeltMachineValue.ToString(); } availableMachine.PrepHotmeltMachine = prepHotmeltMachine; // Sewing //float sewingSmallComputer = 0; var sewingSmallComputerValue = (excelRange.Cells[i, 15] as Excel.Range).Value2; string sewingSmallComputer = ""; if (sewingSmallComputerValue != null) { sewingSmallComputer = sewingSmallComputerValue.ToString(); } availableMachine.SewingSmallComputer = sewingSmallComputer; //float sewingBigComputer = 0; var sewingBigComputerValue = (excelRange.Cells[i, 16] as Excel.Range).Value2; string sewingBigComputer = ""; if (sewingBigComputerValue != null) { sewingBigComputer = sewingBigComputerValue.ToString(); } availableMachine.SewingBigComputer = sewingBigComputer; //float sewingUltrasonic = 0; var sewingUltrasonicValue = (excelRange.Cells[i, 17] as Excel.Range).Value2; string sewingUltrasonic = ""; if (sewingUltrasonicValue != null) { sewingUltrasonic = sewingUltrasonicValue.ToString(); } availableMachine.SewingUltrasonic = sewingUltrasonic; //float sewingFourNeeldleFlat = 0; var sewing4NeeldleFlatValue = (excelRange.Cells[i, 18] as Excel.Range).Value2; string sewing4NeeldleFlat = ""; if (sewing4NeeldleFlatValue != null) { sewing4NeeldleFlat = sewing4NeeldleFlatValue.ToString(); } availableMachine.Sewing4NeedleFlat = sewing4NeeldleFlat; //float sewingFourNeedlePost = 0; var sewing4NeedlePostValue = (excelRange.Cells[i, 19] as Excel.Range).Value2; string sewing4NeedlePost = ""; if (sewing4NeedlePostValue != null) { sewing4NeedlePost = sewing4NeedlePostValue.ToString(); } availableMachine.Sewing4NeedlePost = sewing4NeedlePost; //float sewingLongTable = 0; var sewingLongTableValue = (excelRange.Cells[i, 20] as Excel.Range).Value2; string sewingLongTable = ""; if (sewingLongTableValue != null) { sewingLongTable = sewingLongTableValue.ToString(); } availableMachine.SewingLongTable = sewingLongTable; //float sewingEyeleting = 0; var sewingEyeletingValue = (excelRange.Cells[i, 21] as Excel.Range).Value2; string sewingEyeleting = ""; if (sewingEyeletingValue != null) { sewingEyeleting = sewingEyeletingValue.ToString(); } availableMachine.SewingEyeleting = sewingEyeleting; //float sewingZZBinding = 0; var sewingZZBindingVlaue = (excelRange.Cells[i, 22] as Excel.Range).Value2; string sewingZZBinding = ""; if (sewingZZBindingVlaue != null) { sewingZZBinding = sewingZZBindingVlaue.ToString(); } availableMachine.SewingZZBinding = sewingZZBinding; //float sewingHotmeltMachine = 0; var sewingHotmeltMachineValue = (excelRange.Cells[i, 23] as Excel.Range).Value2; string sewingHotmeltMachine = ""; if (sewingHotmeltMachineValue != null) { sewingHotmeltMachine = sewingHotmeltMachineValue.ToString(); } availableMachine.SewingHotmeltMachine = sewingHotmeltMachine; //float sewingHotmeltHeldMachine = 0; var sewingHotmeltHeldMachineValue = (excelRange.Cells[i, 24] as Excel.Range).Value2; string sewingHotmeltHeldMachine = ""; if (sewingHotmeltHeldMachineValue != null) { sewingHotmeltHeldMachine = sewingHotmeltHeldMachineValue.ToString(); } availableMachine.SewingHandHeldHotmelt = sewingHotmeltHeldMachine; //float sewingStationaryHHHotmelt = 0; var sewingStationaryHHHotmeltValue = (excelRange.Cells[i, 25] as Excel.Range).Value2; string sewingStationaryHHHotmelt = ""; if (sewingStationaryHHHotmeltValue != null) { sewingStationaryHHHotmelt = sewingStationaryHHHotmeltValue.ToString(); } availableMachine.SewingStationaryHHHotmelt = sewingStationaryHHHotmelt; // Stockfit //float stockfitVerticalBuffing = 0; var stockfitVerticalBuffingValue = (excelRange.Cells[i, 26] as Excel.Range).Value2; string stockfitVerticalBuffing = ""; if (stockfitVerticalBuffingValue != null) { stockfitVerticalBuffing = stockfitVerticalBuffingValue.ToString(); } availableMachine.StockfitVerticalBuffing = stockfitVerticalBuffing; //float stockfitHorizontalBuffing = 0; var stockfitHorizontalBuffingValue = (excelRange.Cells[i, 27] as Excel.Range).Value2; string stockfitHorizontalBuffing = ""; if (stockfitHorizontalBuffingValue != null) { stockfitHorizontalBuffing = stockfitHorizontalBuffingValue.ToString(); } availableMachine.StockfitHorizontalBuffing = stockfitHorizontalBuffing; //float stockfitSideBuffing = 0; var stockfitSideBuffingValue = (excelRange.Cells[i, 28] as Excel.Range).Value2; string stockfitSideBuffing = ""; if (stockfitSideBuffingValue != null) { stockfitSideBuffing = stockfitSideBuffingValue.ToString(); } availableMachine.StockfitSideBuffing = stockfitSideBuffing; //float stockfitOutsoleStitching = 0; var stockfitOutsoleStitchingValue = (excelRange.Cells[i, 29] as Excel.Range).Value2; string stockfitOutsoleStitching = ""; if (stockfitOutsoleStitchingValue != null) { stockfitOutsoleStitching = stockfitOutsoleStitchingValue.ToString(); } availableMachine.StockfitOutsoleStitching = stockfitOutsoleStitching; //float stockfitAutoBuffing = 0; var stockfitAutoBuffingValue = (excelRange.Cells[i, 30] as Excel.Range).Value2; string stockfitAutoBuffing = ""; if (stockfitAutoBuffingValue != null) { stockfitAutoBuffing = stockfitAutoBuffingValue.ToString(); } availableMachine.StockfitAutoBuffing = stockfitAutoBuffing; //float stockfitHydraulicCutting = 0; var stockfitHydraulicCuttingValue = (excelRange.Cells[i, 31] as Excel.Range).Value2; string stockfitHydraulicCutting = ""; if (stockfitHydraulicCuttingValue != null) { stockfitHydraulicCutting = stockfitHydraulicCuttingValue.ToString(); } availableMachine.StockfitHydraulicCutting = stockfitHydraulicCutting; //float stockfitPadPrinting = 0; var stockfitPadPrintingValue = (excelRange.Cells[i, 32] as Excel.Range).Value2; string stockfitPadPrinting = ""; if (stockfitPadPrintingValue != null) { stockfitPadPrinting = stockfitPadPrintingValue.ToString(); } availableMachine.StockfitPadPrinting = stockfitPadPrinting; // Assembly //float assemblyToeLasting = 0; var assemblyToeLastingValue = (excelRange.Cells[i, 33] as Excel.Range).Value2; string assemblyToeLasting = ""; if (assemblyToeLastingValue != null) { assemblyToeLasting = assemblyToeLastingValue.ToString(); } availableMachine.AssemblyToeLasting = assemblyToeLasting; //float assemblySideLasting = 0; var assemblySideLastingValue = (excelRange.Cells[i, 34] as Excel.Range).Value2; string assemblySideLasting = ""; if (assemblySideLastingValue != null) { assemblySideLasting = assemblySideLastingValue.ToString(); } availableMachine.AssemblySideLasting = assemblySideLasting; //float assemblyHeelLasting = 0; var assemblyHeelLastingValue = (excelRange.Cells[i, 35] as Excel.Range).Value2; string assemblyHeelLasting = ""; if (assemblyHeelLastingValue != null) { assemblyHeelLasting = assemblyHeelLastingValue.ToString(); } availableMachine.AssemblyHeelLasting = assemblyHeelLasting; //float assemblySidePress = 0; var assemblySidePressValue = (excelRange.Cells[i, 36] as Excel.Range).Value2; string assemblySidePress = ""; if (assemblySidePressValue != null) { assemblySidePress = assemblySidePressValue.ToString(); } availableMachine.AssemblySidePress = assemblySidePress; //float assemblyTopDown = 0; var assemblyTopDownValue = (excelRange.Cells[i, 37] as Excel.Range).Value2; string assemblyTopDown = ""; if (assemblyTopDownValue != null) { assemblyTopDown = assemblyTopDownValue.ToString(); } availableMachine.AssemblyTopDown = assemblyTopDown; //float assemblyHotmeltMachine = 0; var assemblyHotmeltMachineValue = (excelRange.Cells[i, 38] as Excel.Range).Value2; string assemblyHotmeltMachine = ""; if (assemblyHotmeltMachineValue != null) { assemblyHotmeltMachine = assemblyHotmeltMachineValue.ToString(); } availableMachine.AssemblyHotmeltMachine = assemblyHotmeltMachine; //float assemblySocklinerHotmelt = 0; var assemblySocklinerHotmeltValue = (excelRange.Cells[i, 39] as Excel.Range).Value2; string assemblySocklinerHotmelt = ""; if (assemblySocklinerHotmeltValue != null) { assemblySocklinerHotmelt = assemblySocklinerHotmeltValue.ToString(); } availableMachine.AssemblySocklinerHotmelt = assemblySocklinerHotmelt; //float assemblyVWrinkleRemover = 0; var assemblyVWrinkleRemoverValue = (excelRange.Cells[i, 40] as Excel.Range).Value2; string assemblyVWrinkleRemover = ""; if (assemblyVWrinkleRemoverValue != null) { assemblyVWrinkleRemover = assemblyVWrinkleRemoverValue.ToString(); } availableMachine.AssemblyVWrinkleRemover = assemblyVWrinkleRemover; // Add model to List availableMachineList.Add(availableMachine); } progressBar.Dispatcher.Invoke((Action)(() => progressBar.Value = i)); } } catch { availableMachineList.Clear(); } finally { excelWorkbook.Close(false, Missing.Value, Missing.Value); excelApplication.Quit(); } }
private void bwSearch_DoWork(object sender, DoWorkEventArgs e) { availableMachineModel = AvailableMachineController.SelectTop1(Id); }
public static bool Insert(AvailableMachineModel model) { var @Id = new SqlParameter("@Id", model.Id); // Cutting var @CuttingArmClicker = new SqlParameter("@CuttingArmClicker", model.CuttingArmClicker); var @CuttingBeam = new SqlParameter("@CuttingBeam", model.CuttingBeam); var @CuttingCutStrap = new SqlParameter("@CuttingCutStrap", model.CuttingCutStrap); var @CuttingLaser = new SqlParameter("@CuttingLaser", model.CuttingLaser); var @CuttingPuncherHole = new SqlParameter("@CuttingPuncherHole", model.CuttingPuncherHole); var @CuttingSkiving = new SqlParameter("@CuttingSkiving", model.CuttingSkiving); // Prep var @PrepVerticalHF = new SqlParameter("@PrepVerticalHF", model.PrepVerticalHF); var @PrepHorizontalHF = new SqlParameter("@PrepHorizontalHF", model.PrepHorizontalHF); var @PrepOnlineHeatPress = new SqlParameter("@PrepOnlineHeatPress", model.PrepOnlineHeatPress); var @PrepAutoHF = new SqlParameter("@PrepAutoHF", model.PrepAutoHF); var @PrepInye = new SqlParameter("@PrepInye", model.PrepInye); var @PrepHotmeltMachine = new SqlParameter("@PrepHotmeltMachine", model.PrepHotmeltMachine); // Sewing var @SewingSmallComputer = new SqlParameter("@SewingSmallComputer", model.SewingSmallComputer); var @SewingBigComputer = new SqlParameter("@SewingBigComputer", model.SewingBigComputer); var @SewingUltrasonic = new SqlParameter("@SewingUltrasonic", model.SewingUltrasonic); var @Sewing4NeedleFlat = new SqlParameter("@Sewing4NeedleFlat", model.Sewing4NeedleFlat); var @Sewing4NeedlePost = new SqlParameter("@Sewing4NeedlePost", model.Sewing4NeedlePost); var @SewingLongTable = new SqlParameter("@SewingLongTable", model.SewingLongTable); var @SewingEyeleting = new SqlParameter("@SewingEyeleting", model.SewingEyeleting); var @SewingZZBinding = new SqlParameter("@SewingZZBinding", model.SewingZZBinding); var @SewingHotmeltMachine = new SqlParameter("@SewingHotmeltMachine", model.SewingHotmeltMachine); var @SewingHandHeldHotmelt = new SqlParameter("@SewingHandHeldHotmelt", model.SewingHandHeldHotmelt); var @SewingStationaryHHHotmelt = new SqlParameter("@SewingStationaryHHHotmelt", model.SewingStationaryHHHotmelt); // Stockfit var @StockfitVerticalBuffing = new SqlParameter("@StockfitVerticalBuffing", model.StockfitVerticalBuffing); var @StockfitHorizontalBuffing = new SqlParameter("@StockfitHorizontalBuffing", model.StockfitHorizontalBuffing); var @StockfitSideBuffing = new SqlParameter("@StockfitSideBuffing", model.StockfitSideBuffing); var @StockfitOutsoleStitching = new SqlParameter("@StockfitOutsoleStitching", model.StockfitOutsoleStitching); var @StockfitAutoBuffing = new SqlParameter("@StockfitAutoBuffing", model.StockfitAutoBuffing); var @StockfitHydraulicCutting = new SqlParameter("@StockfitHydraulicCutting", model.StockfitHydraulicCutting); var @StockfitPadPrinting = new SqlParameter("@StockfitPadPrinting", model.StockfitPadPrinting); // Assembly var @AssemblyToeLasting = new SqlParameter("@AssemblyToeLasting", model.AssemblyToeLasting); var @AssemblySideLasting = new SqlParameter("@AssemblySideLasting", model.AssemblySideLasting); var @AssemblyHeelLasting = new SqlParameter("@AssemblyHeelLasting", model.AssemblyHeelLasting); var @AssemblySidePress = new SqlParameter("@AssemblySidePress", model.AssemblySidePress); var @AssemblyTopDown = new SqlParameter("@AssemblyTopDown", model.AssemblyTopDown); var @AssemblyHotmeltMachine = new SqlParameter("@AssemblyHotmeltMachine", model.AssemblyHotmeltMachine); var @AssemblySocklinerHotmelt = new SqlParameter("@AssemblySocklinerHotmelt", model.AssemblySocklinerHotmelt); var @AssemblyVWrinkleRemover = new SqlParameter("@AssemblyVWrinkleRemover", model.AssemblyVWrinkleRemover); SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities(); if (db.ExecuteStoreCommand(@"EXEC spm_InsertAvailableMachine @Id, @CuttingArmClicker,@CuttingBeam,@CuttingCutStrap,@CuttingLaser,@CuttingPuncherHole,@CuttingSkiving, @PrepVerticalHF,@PrepHorizontalHF,@PrepOnlineHeatPress,@PrepAutoHF,@PrepInye,@PrepHotmeltMachine, @SewingSmallComputer,@SewingBigComputer,@SewingUltrasonic,@Sewing4NeedleFlat,@Sewing4NeedlePost, @SewingLongTable,@SewingEyeleting,@SewingZZBinding,@SewingHotmeltMachine,@SewingHandHeldHotmelt,@SewingStationaryHHHotmelt, @StockfitVerticalBuffing,@StockfitHorizontalBuffing,@StockfitSideBuffing,@StockfitOutsoleStitching, @StockfitAutoBuffing,@StockfitHydraulicCutting,@StockfitPadPrinting, @AssemblyToeLasting,@AssemblySideLasting,@AssemblyHeelLasting,@AssemblySidePress, @AssemblyTopDown,@AssemblyHotmeltMachine,@AssemblySocklinerHotmelt,@AssemblyVWrinkleRemover", @Id, @CuttingArmClicker, @CuttingBeam, @CuttingCutStrap, @CuttingLaser, @CuttingPuncherHole, @CuttingSkiving, @PrepVerticalHF, @PrepHorizontalHF, @PrepOnlineHeatPress, @PrepAutoHF, @PrepInye, @PrepHotmeltMachine, @SewingSmallComputer, @SewingBigComputer, @SewingUltrasonic, @Sewing4NeedleFlat, @Sewing4NeedlePost, @SewingLongTable, @SewingEyeleting, @SewingZZBinding, @SewingHotmeltMachine, @SewingHandHeldHotmelt, @SewingStationaryHHHotmelt, @StockfitVerticalBuffing, @StockfitHorizontalBuffing, @StockfitSideBuffing, @StockfitOutsoleStitching, @StockfitAutoBuffing, @StockfitHydraulicCutting, @StockfitPadPrinting, @AssemblyToeLasting, @AssemblySideLasting, @AssemblyHeelLasting, @AssemblySidePress, @AssemblyTopDown, @AssemblyHotmeltMachine, @AssemblySocklinerHotmelt, @AssemblyVWrinkleRemover) > 0) { return(true); } return(false); }