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();
}
