private void btnSave_Click(object sender, RoutedEventArgs e) { if (MessageBox.Show("Confirm Save?", this.Title, MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.No) { return; } // get date nowDate = DateTime.Now.Date.AddDays(-1); while (offDayList.Select(s => s.Date).ToList().Contains(nowDate)) { nowDate = nowDate.AddDays(-1); } dt = ((DataView)dgOutsoleMaterial.ItemsSource).ToTable(); foreach (DataRow dr in dt.Rows) { int qtyActual = 0; for (int i = 0; i <= sizeRunList.Count - 1; i++) { string sizeNo = sizeRunList[i].SizeNo; int quantity = (Int32)dr[String.Format("Column{0}", i)]; qtyActual += quantity; if (quantity >= 0) { SewingOutputModel model = new SewingOutputModel { ProductNo = productNo, SizeNo = sizeNo, Quantity = quantity, }; sewingOutputToInsertList.Add(model); } } if (qtyActual > 0 && sewingActualStartDateAuto == "") { sewingActualStartDateAuto = String.Format("{0:M/d}", nowDate); } sewingActualFinishDateAuto = ""; if (qtyActual >= sizeRunList.Sum(s => s.Quantity) && sewingActualFinishDateAuto == "") { sewingActualFinishDateAuto = String.Format("{0:M/d}", nowDate); } } if (bwInsert.IsBusy == false) { this.Cursor = Cursors.Wait; btnSave.IsEnabled = false; bwInsert.RunWorkerAsync(); } }
public static bool Insert(SewingOutputModel model) { var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo); var @SizeNo = new SqlParameter("@SizeNo", model.SizeNo); var @Quantity = new SqlParameter("@Quantity", model.Quantity); SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities(); if (db.ExecuteStoreCommand("EXEC spm_InsertSewingOutput @ProductNo,@SizeNo,@Quantity", @ProductNo, @SizeNo, @Quantity) >= 1) { return(true); } return(false); }