public static bool Insert(OSMaterialBorrowModel 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_InsertOSMaterialBorrow @OSCheckingID, @ProductNoBorrow, @QuantityBorrow", @OSCheckingID, @ProductNoBorrow, @QuantityBorrow) >= 1) { return(true); } return(false); } }
public static bool Update(OSMaterialBorrowModel model) { var @Id = new SqlParameter("@Id", model.Id); var @ProductNoBorrow = new SqlParameter("@ProductNoBorrow", model.ProductNoBorrow); var @QuantityBorrow = new SqlParameter("@QuantityBorrow", model.QuantityBorrow); using (var db = new SaovietMasterScheduleEntities()) { if (db.ExecuteStoreCommand("EXEC spm_UpdateOSMaterialBorrow @Id, @ProductNoBorrow, @QuantityBorrow", @Id, @ProductNoBorrow, @QuantityBorrow) >= 1) { return(true); } return(false); } }
private void btnBorrow_Click(object sender, RoutedEventArgs e) { var po = oswhCheckList.FirstOrDefault().ProductNo; var poInput = txtProductNo.Text.Trim().ToUpper().ToString(); int qtyInput = 0; string qtyInputString = txtQuantity.Text.Trim().ToUpper().ToString(); Int32.TryParse(qtyInputString, out qtyInput); if (string.IsNullOrEmpty(poInput)) { MessageBox.Show(string.Format("PO {0} is invalid !\nĐơn hàng không hợp lệ!", poInput), this.Title, MessageBoxButton.OK, MessageBoxImage.Error); txtProductNo.Focus(); return; } if (po.ToUpper().ToString() == poInput) { MessageBox.Show(string.Format("PO {0} duplicated !\nĐơn hàng bị trùng!", poInput), this.Title, MessageBoxButton.OK, MessageBoxImage.Error); txtProductNo.Focus(); return; } var osCheckingByPOList = new List <OutsoleMaterialCheckingModel>(); var osMaterialBorrowed = new List <OSMaterialBorrowModel>(); try { if (qtyInput == 0) { goto TheEnd; } osCheckingByPOList = OutsoleMaterialCheckingController.SelectByPO(poInput).Where(w => w.OutsoleSupplierId == supplier.OutsoleSupplierId).ToList(); if (osCheckingByPOList.Count() == 0) { MessageBox.Show(string.Format("PO {0} is invalid !\nĐơn hàng không hợp lệ!", poInput), this.Title, MessageBoxButton.OK, MessageBoxImage.Error); txtProductNo.Focus(); return; } //osCheckingBorrowedByPOList = OutsoleMaterialCheckingController.SelectByPOBorrow(poInput).Where(w => w.OutsoleSupplierId == supplier.OutsoleSupplierId).ToList(); osMaterialBorrowed = OSMaterialBorrowController.GetByPO(poInput).Where(w => w.OSCheckingId == osCheckingId).ToList(); var qtyBorrowed = osMaterialBorrowed.Sum(s => s.QuantityBorrow); var qtyCanBorrow = osCheckingByPOList.Where(w => w.SizeNo == sizeBorrow).Sum(s => s.Quantity + s.ReturnReject); var totalReject = oswhCheckBySupplier.Where(w => w.SizeNo == sizeBorrow).Sum(s => s.Reject); var qtyCanInput = qtyCanBorrow - qtyBorrowed; if (qtyInput + qtyBorrowed > totalReject) { goto TheEnd; } if (qtyInput > qtyCanInput) { goto TheEnd; } if (MessageBox.Show($"Confirm borrow {qtyInput} pairs size: #{sizeBorrow} from PO: {poInput} ?\nXác nhận mượn Outsole Material", this.Title, MessageBoxButton.OKCancel, MessageBoxImage.Question) != MessageBoxResult.OK) { txtQuantity.Focus(); return; } // Update Record DB var borrowItem = new OSMaterialBorrowModel { OSCheckingId = osCheckingId, ProductNoBorrow = poInput, QuantityBorrow = qtyInput }; OSMaterialBorrowController.Insert(borrowItem); //oswhBorrowedList = OSMaterialBorrowController.GetByOSCheckingId(osCheckingId); oswhAfterBorrow = OutsoleMaterialCheckingController.SelectByPO_1(poTransfer).Where(w => w.OutsoleSupplierId == supplier.OutsoleSupplierId).ToList(); this.Close(); return; TheEnd: { MessageBox.Show(string.Format("Quantity is invalid !\nSố lượng không hợp lệ!"), this.Title, MessageBoxButton.OK, MessageBoxImage.Error); txtQuantity.Focus(); return; } } catch (Exception ex) { MessageBox.Show($"{ex.InnerException.Message}", this.Title, MessageBoxButton.OK, MessageBoxImage.Error); txtProductNo.Focus(); return; } }