private void btnSave_Click(object sender, RoutedEventArgs e)
{
if (MessageBox.Show("Confirm Save?", this.Title, MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.No)
{
return;
}
dt = ((DataView)dgInsockMaterial.ItemsSource).ToTable();
for (int r = 0; r <= dt.Rows.Count - 1; r = r + 2)
{
DataRow dr = dt.Rows[r];
DataRow dr1 = dt.Rows[r + 1];
InsockSuppliersModel insockSupplier = (InsockSuppliersModel)dr["Supplier"];
if (insockSupplier != null)
{
int insockSupplierId = insockSupplier.InsockSupplierId;
string actualDate = dr["ActualDate"] as String;
DateTime dtActualDate = TimeHelper.Convert(actualDate);
if (String.IsNullOrEmpty(actualDate) == false && dtActualDate != dtNothing)
{
InsockRawMaterialModel insockRawMaterial = new InsockRawMaterialModel
{
ProductNo = productNo,
InsockSupplierId = insockSupplierId,
ActualDate = dtActualDate,
};
insockRawMaterialToInsertList.Add(insockRawMaterial);
}
for (int i = 0; i <= sizeRunList.Count - 1; i++)
{
string sizeNo = sizeRunList[i].SizeNo;
int quantity = (Int32)dr[String.Format("Column{0}", i)];
int quantityReject = (Int32)dr1[String.Format("Column{0}", i)];
if (quantity >= 0 && quantityReject >= 0)
{
InsockMaterialModel model = new InsockMaterialModel
{
ProductNo = productNo,
InsockSupplierId = insockSupplierId,
SizeNo = sizeNo,
Quantity = quantity,
QuantityReject = quantityReject,
};
insockMaterialToInsertList.Add(model);
}
}
}
}
if (threadInsert.IsBusy == false)
{
this.Cursor = Cursors.Wait;
btnSave.IsEnabled = false;
threadInsert.RunWorkerAsync();
}
}
public static bool UpdateActualDate(InsockRawMaterialModel model)
{
var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo);
var @InsockSupplierId = new SqlParameter("@InsockSupplierId", model.InsockSupplierId);
var @ActualDate = new SqlParameter("@ActualDate", model.ActualDate);
if (db.ExecuteStoreCommand("EXEC spm_UpdateInsockRawMaterialActualDate @ProductNo, @InsockSupplierId, @ActualDate", @ProductNo, @InsockSupplierId, @ActualDate) > 0)
{
return(true);
}
return(false);
}
public static bool Insert(InsockRawMaterialModel model)
{
var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo);
var @InsockSupplierId = new SqlParameter("@InsockSupplierId", model.InsockSupplierId);
var @ETD = new SqlParameter("@ETD", model.ETD);
if (db.ExecuteStoreCommand("EXEC spm_InsertInsockRawMaterial @ProductNo, @InsockSupplierId, @ETD", @ProductNo, @InsockSupplierId, @ETD) > 0)
{
return(true);
}
return(false);
}
private void bwInsert_DoWork(object sender, DoWorkEventArgs e)
{
rawMaterial.ETD = dtDefault;
rawMaterial.IsETDUpdate = true;
foreach (var insockRawMaterial in insockRawMaterialViewToDeleteList)
{
int insockSupplierId = insockRawMaterial.InsockSupplier.InsockSupplierId;
InsockRawMaterialController.Delete(productNo, insockSupplierId);
}
if (insockRawMaterialViewToInsertList.Count > 0)
{
rawMaterial.ETD = insockRawMaterialViewToInsertList.Max(m => m.ETDReal);
}
foreach (var insockRawMaterial in insockRawMaterialViewToInsertList)
{
int insockSupplierId = insockRawMaterial.InsockSupplier.InsockSupplierId;
DateTime etd = TimeHelper.Convert(insockRawMaterial.ETD);
if (etd != dtDefault && etd != dtNothing)
{
var insertModel = new InsockRawMaterialModel()
{
ProductNo = productNo,
InsockSupplierId = insockSupplierId,
ETD = etd
};
InsockRawMaterialController.Insert(insertModel);
if (insertModel.ETD > rawMaterial.ETD)
{
rawMaterial.ETD = insertModel.ETD;
}
}
}
}
