public static bool Insert(OutsoleWHFGModel model) { var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo); var @SizeNo = new SqlParameter("@SizeNo", model.SizeNo); var @Quantity = new SqlParameter("@Quantity", model.Quantity); var @CreatedDate = new SqlParameter("@CreatedDate", model.CreatedDate); if (db.ExecuteStoreCommand("EXEC spm_InsertOutsoleWHFG @ProductNo, @SizeNo, @Quantity, @CreatedDate", @ProductNo, @SizeNo, @Quantity, @CreatedDate) >= 1) { return(true); } return(false); }
private void btnSave_Click(object sender, RoutedEventArgs e) { if (bwInsert.IsBusy == true || dt == null) { return; } outsoleWHFGFromTableList = new List <OutsoleWHFGModel>(); dt = ((DataView)dgOutsoleWHFG.ItemsSource).ToTable(); if (dt.Rows.Count == 0) { return; } if (MessageBox.Show("Confirm Save?", this.Title, MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.No) { return; } for (int i = 0; i < dt.Rows.Count; i++) { DataRow dr = dt.Rows[i]; if (dr["Status"].ToString().Contains("Balance")) { continue; } for (int j = 0; j <= sizeRunList.Count - 1; j++) { OutsoleWHFGModel outsoleWHFG = new OutsoleWHFGModel(); outsoleWHFG.ProductNo = productNo; outsoleWHFG.SizeNo = sizeRunList[j].SizeNo; int qty = 0; if (dr["Status"].ToString().Contains("Quantity")) { Int32.TryParse(dr[String.Format("Column{0}", j)].ToString(), out qty); } outsoleWHFG.Quantity = qty; outsoleWHFG.CreatedDate = (DateTime)dr.ItemArray[0]; outsoleWHFGFromTableList.Add(outsoleWHFG); } } this.Cursor = Cursors.Wait; btnSave.IsEnabled = false; bwInsert.RunWorkerAsync(); }