public static bool Insert(OutsoleMaterialCheckingModel model) { var @WorkerId = new SqlParameter("@WorkerId", model.WorkerId); var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo); var @CheckingDate = new SqlParameter("@CheckingDate", model.CheckingDate); var @OutsoleSupplierId = new SqlParameter("@OutsoleSupplierId", model.OutsoleSupplierId); var @SizeNo = new SqlParameter("@SizeNo", model.SizeNo); var @Quantity = new SqlParameter("@Quantity", model.Quantity); var @Reject = new SqlParameter("@Reject", model.Reject); var @ErrorId = new SqlParameter("@ErrorId", model.ErrorId); var @Excess = new SqlParameter("@Excess", model.Excess); var @WorkingCard = new SqlParameter("@WorkingCard", model.WorkingCard); var @ReturnReject = new SqlParameter("@ReturnReject", model.ReturnReject); var @ReturnRemark = new SqlParameter("@ReturnRemark", model.ReturnRemark); //var @SizeNoUpper = new SqlParameter("@SizeNoUpper", model.SizeNoUpper); using (var db = new SaovietMasterScheduleEntities()) { if (db.ExecuteStoreCommand("EXEC spm_InsertOutsoleMaterialChecking_4 @WorkerId, @ProductNo, @CheckingDate, @OutsoleSupplierId, @SizeNo, @Quantity, @Reject, @ErrorId, @Excess, @WorkingCard, @ReturnReject, @ReturnRemark", @WorkerId, @ProductNo, @CheckingDate, @OutsoleSupplierId, @SizeNo, @Quantity, @Reject, @ErrorId, @Excess, @WorkingCard, @ReturnReject, @ReturnRemark) > 0) { return(true); } return(false); }; }
public static bool updateBorrow(OutsoleMaterialCheckingModel model) { var @OSCheckingId = new SqlParameter("@OSCheckingId", model.OSCheckingId); var @ProductNoBorrow = new SqlParameter("@ProductNoBorrow", model.ProductNoBorrow); var @QuantityBorrow = new SqlParameter("@QuantityBorrow", model.QuantityBorrow); using (var db = new SaovietMasterScheduleEntities()) { if (db.ExecuteStoreCommand("EXEC spm_UpdateOSWHBorrow @OSCheckingId, @ProductNoBorrow, @QuantityBorrow", @OSCheckingId, @ProductNoBorrow, @QuantityBorrow) > 0) { return(true); } return(false); }; }
private void InsertModel(int workingCart) { int qty = 0, reject = 0, returnReject = 0, returnRemark = 0; if (modeReturnReject == true) { returnReject = qtyInputted; Int32.TryParse(txtReturnRemark.Text.Trim().ToString(), out returnRemark); } else { if (modeReject == true) { reject = qtyInputted; } else { qty = qtyInputted; } } var osmCheckCurrent = new OutsoleMaterialCheckingModel { ProductNo = poSearch, WorkerId = workerId, CheckingDate = checkingDate, OutsoleSupplierId = supplierClicked.OutsoleSupplierId, SizeNo = sizeNoInputted, Quantity = qty, Reject = reject, ReturnReject = returnReject, ReturnRemark = returnRemark, ErrorId = errorPressed.ErrorID, WorkingCard = workingCart, UpdateReject = modeReject, UpdateQuantity = !modeReject, UpdateReturnReject = modeReturnReject }; if (bwInsert.IsBusy == false) { var tempValidateList = currentOSMCheckListBySupp.ToList(); tempValidateList.Add(osmCheckCurrent); // Case Input or Reject if (modeReject == false && modeReturnReject == false) { osmCheckCurrent.Quantity = tempValidateList.Where(w => w.SizeNo == osmCheckCurrent.SizeNo && w.CheckingDate == osmCheckCurrent.CheckingDate && w.WorkingCard == osmCheckCurrent.WorkingCard).Sum(s => s.Quantity); if (MessageBox.Show(string.Format("Confirm add(update) record ?\n Size : {0}\n Qty : {1}\n Working Cart(Index No): {2}", osmCheckCurrent.SizeNo, osmCheckCurrent.Quantity, osmCheckCurrent.WorkingCard), this.Title, MessageBoxButton.OKCancel, MessageBoxImage.Question) != MessageBoxResult.OK) { txtSizeNo.Focus(); txtSizeNo.SelectAll(); return; } if (osmCheckCurrent.Quantity < 0) { MessageBox.Show("Quantity cannot be < 0 !", this.Title, MessageBoxButton.OK, MessageBoxImage.Error); txtQuantity.Focus(); txtQuantity.SelectAll(); return; } } else if (modeReject == true && modeReturnReject == false) { osmCheckCurrent.Reject = tempValidateList.Where(w => w.SizeNo == osmCheckCurrent.SizeNo && w.CheckingDate == osmCheckCurrent.CheckingDate && w.WorkingCard == osmCheckCurrent.WorkingCard && w.ErrorId == osmCheckCurrent.ErrorId).Sum(s => s.Reject); if (MessageBox.Show(string.Format("Confirm add(update) record ?\nSize : {0}\nQty : {1}\nReject : {2} - {3}", osmCheckCurrent.SizeNo, osmCheckCurrent.Reject, errorPressed.ErrorName, errorPressed.ErrorVietNamese), this.Title, MessageBoxButton.OKCancel, MessageBoxImage.Question) != MessageBoxResult.OK) { txtSizeNo.Focus(); txtSizeNo.SelectAll(); return; } if (osmCheckCurrent.Reject < 0) { MessageBox.Show("Reject cannot be < 0 !\nHàng phế < 0 !", this.Title, MessageBoxButton.OK, MessageBoxImage.Error); txtQuantity.Focus(); txtQuantity.SelectAll(); return; } } // Case Return Reject if (modeReturnReject == true) { osmCheckCurrent.ReturnReject = tempValidateList.Where(w => w.SizeNo == osmCheckCurrent.SizeNo && w.CheckingDate == osmCheckCurrent.CheckingDate && w.WorkingCard == osmCheckCurrent.WorkingCard).Sum(s => s.ReturnReject); if (osmCheckCurrent.ReturnReject < 0) { MessageBox.Show("Return Reject cannot be < 0 !", this.Title, MessageBoxButton.OK, MessageBoxImage.Error); txtQuantity.Focus(); txtQuantity.SelectAll(); return; } if (MessageBox.Show(string.Format("Confirm add (update) record ?\nSize : {0}\nQtyReturn OK : {1}\nQtyRemark : {2}", osmCheckCurrent.SizeNo, osmCheckCurrent.ReturnReject, osmCheckCurrent.ReturnRemark), this.Title, MessageBoxButton.OKCancel, MessageBoxImage.Question) != MessageBoxResult.OK) { txtSizeNo.Focus(); txtSizeNo.SelectAll(); return; } } this.Cursor = Cursors.Wait; txtQuantity.IsEnabled = false; txtSizeNo.IsEnabled = false; currentOSMCheckListBySupp.Add(osmCheckCurrent); object[] par = new object[] { osmCheckCurrent, currentOSMCheckListBySupp }; bwInsert.RunWorkerAsync(par); } }