private void btnSave_Click(object sender, RoutedEventArgs e)
{
if (bwInsert.IsBusy == true || dt == null)
{
return;
}
rejectDetailFromTableList = new List <OutsoleMaterialRejectDetailModel>();
dt = ((DataView)dgOutsoleMaterialRejectDetail.ItemsSource).ToTable();
if (dt.Rows.Count == 0)
{
return;
}
if (MessageBox.Show("Confirm Save?", this.Title, MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.No)
{
return;
}
var rejectIssuesIdList = rejectIssuesList.Select(s => s.OutsoleMaterialRejectIssuesId.ToString()).ToList();
for (int i = 0; i < dt.Rows.Count; i++)
{
int rejectIssuesId = 0;
DataRow dr = dt.Rows[i];
string rejectIssuesIdString = "";
rejectIssuesIdString = dr["OutsoleMaterialRejectIssuesId"].ToString();
if (rejectIssuesIdList.Contains(rejectIssuesIdString) == false)
{
continue;
}
Int32.TryParse(rejectIssuesIdString, out rejectIssuesId);
for (int j = 0; j <= sizeRunList.Count - 1; j++)
{
int rejectDetailPerSize = 0;
Int32.TryParse(dr[String.Format("Column{0}", j)].ToString(), out rejectDetailPerSize);
var rejectDetailModel = new OutsoleMaterialRejectDetailModel()
{
ProductNo = productNo,
SizeNo = sizeRunList[j].SizeNo,
OutsoleSupplierId = supplierClicked.OutsoleSupplierId,
CreatedBy = account.UserName,
QuantityReject = rejectDetailPerSize,
OutsoleMaterialRejectIssuesId = rejectIssuesId,
IndexNo = INDEXNO,
Round = ROUND,
};
rejectDetailFromTableList.Add(rejectDetailModel);
}
}
this.Cursor = Cursors.Wait;
btnSave.IsEnabled = false;
bwInsert.RunWorkerAsync();
}
public static bool Insert(OutsoleMaterialRejectDetailModel model)
{
var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo);
var @OutsoleSupplierId = new SqlParameter("@OutsoleSupplierId", model.OutsoleSupplierId);
var @OutsoleMaterialRejectIssuesId = new SqlParameter("@OutsoleMaterialRejectIssuesId", model.OutsoleMaterialRejectIssuesId);
var @SizeNo = new SqlParameter("@SizeNo", model.SizeNo);
var @QuantityReject = new SqlParameter("@QuantityReject", model.QuantityReject);
var @CreatedBy = new SqlParameter("@CreatedBy", model.CreatedBy);
var @IndexNo = new SqlParameter("@IndexNo", model.IndexNo);
var @Round = new SqlParameter("@Round", model.Round);
if (db.ExecuteStoreCommand("EXEC spm_InsertOutsoleMaterialRejectDetail @ProductNo, @OutsoleSupplierId, @OutsoleMaterialRejectIssuesId, @SizeNo, @QuantityReject, @CreatedBy, @IndexNo, @Round", @ProductNo, @OutsoleSupplierId, @OutsoleMaterialRejectIssuesId, @SizeNo, @QuantityReject, @CreatedBy, @IndexNo, @Round) > 0)
{
return(true);
}
return(false);
}
