private void ConfirmQuantityAndLocation() { MyGeneration.dOOdads.TransactionMgr transaction = MyGeneration.dOOdads.TransactionMgr.ThreadTransactionMgr(); transaction.BeginTransaction(); try { PalletLocation pl = new PalletLocation(); DataRow dr = gridReceiveView.GetFocusedDataRow(); if (dr == null) { throw new Exception("Nothing to confirm!"); } int ReceiptID = Convert.ToInt32(gridReceiveView.GetFocusedDataRow()["ReceiptID"]); if (gridDetailView.DataSource == null) { return; } BLL.ReceiveDoc receiveDoc = new ReceiveDoc(); receiveDoc.LoadByReceiptIDWithReceivePallet(ReceiptID); while (!receiveDoc.EOF) { int palletLocationID = Convert.ToInt32(receiveDoc.GetColumn("PalletLocationID")); pl.LoadByPrimaryKey(palletLocationID); pl.Confirmed = true; pl.Save(); receiveDoc.MoveNext(); } BLL.ReceiveDoc recDoc = new ReceiveDoc(); recDoc.LoadByReceiptID(ReceiptID); recDoc.ConfirmQuantityAndLocation(CurrentContext.UserId); BLL.Receipt receiptStatus = new BLL.Receipt(); receiptStatus.LoadByPrimaryKey(ReceiptID); receiptStatus.ChangeStatus(ReceiptConfirmationStatus.Constants.RECEIVE_QUANTITY_CONFIRMED, null, this.GetFormIdentifier(), CurrentContext.UserId, "Receive Confirmed"); transaction.CommitTransaction(); XtraMessageBox.Show("Receipt Confirmed!", "Success", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Information); BindFormContents(); } catch (Exception exp) { transaction.RollbackTransaction(); XtraMessageBox.Show(exp.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public IssueDoc CreateIssueFromPicklist(PickListDetail picklistDetail,Order order,DateTime convertedEthDate,Issue stvLog,User user) { ReceivePallet receivePallet = new ReceivePallet(); receivePallet.LoadByPrimaryKey(picklistDetail.ReceivePalletID); ReceiveDoc receiveDoc = new ReceiveDoc(); receiveDoc.LoadByPrimaryKey(receivePallet.ReceiveID); IssueDoc issueDoc = new IssueDoc(); issueDoc.AddNew(); issueDoc.BatchNo = picklistDetail.BatchNumber; if(!picklistDetail.IsColumnNull("Cost")) issueDoc.Cost = picklistDetail.Cost; issueDoc.Date = convertedEthDate; issueDoc.EurDate = DateTimeHelper.ServerDateTime; issueDoc.StoreId = picklistDetail.StoreID; issueDoc.STVID = stvLog.ID; issueDoc.IsTransfer = true; issueDoc.IssuedBy = user.FullName; issueDoc.ItemID = picklistDetail.ItemID; issueDoc.NoOfPack = picklistDetail.Packs; issueDoc.QtyPerPack = picklistDetail.QtyPerPack; issueDoc.Quantity = picklistDetail.QuantityInBU; issueDoc.OrderID = order.ID; issueDoc.UnitID = receiveDoc.UnitID; issueDoc.ManufacturerID = receiveDoc.ManufacturerId; issueDoc.SetColumn("UnitCost" ,receiveDoc.GetColumn("Cost")); issueDoc.SetColumn("SellingPrice" ,receiveDoc.GetColumn("SellingPrice")); issueDoc.SetColumn("Margin", receiveDoc.GetColumn("Margin")); issueDoc.SetColumn("PhysicalStoreID", receiveDoc.GetColumn("PhysicalStoreID")); issueDoc.PLDetailID = picklistDetail.ID; issueDoc.RecievDocID = picklistDetail.ReceiveDocID; issueDoc.SetColumn("InventoryPeriodID", receiveDoc.GetColumn("InventoryPeriodID")); // This is a deprecated field issueDoc.RecomendedQty = 0;// picklistDetail.Packs; issueDoc.RefNo = stvLog.IDPrinted.ToString(); issueDoc.DispatchConfirmed = false; issueDoc.Save(); //substract from QuantityLeft receiveDoc.QuantityLeft -= picklistDetail.QuantityInBU; if(receiveDoc.QuantityLeft < 0) { receiveDoc.QuantityLeft = 0; } receiveDoc.Save(); receivePallet.Balance -= picklistDetail.QuantityInBU; if(receivePallet.Balance < 0) { receivePallet.Balance=0; } receivePallet.ReservedStock -= picklistDetail.Packs; if(receivePallet.ReservedStock < 0) { receivePallet.ReservedStock = 0; } receivePallet.Save(); return issueDoc; }
public IssueDoc CreateIssueFromPicklist(PickListDetail picklistDetail, Order order, DateTime convertedEthDate, Issue stvLog, User user) { ReceivePallet receivePallet = new ReceivePallet(); receivePallet.LoadByPrimaryKey(picklistDetail.ReceivePalletID); ReceiveDoc receiveDoc = new ReceiveDoc(); receiveDoc.LoadByPrimaryKey(receivePallet.ReceiveID); IssueDoc issueDoc = new IssueDoc(); issueDoc.AddNew(); issueDoc.BatchNo = picklistDetail.BatchNumber; if (!picklistDetail.IsColumnNull("Cost")) { issueDoc.Cost = picklistDetail.Cost; } issueDoc.Date = convertedEthDate; issueDoc.EurDate = DateTimeHelper.ServerDateTime; issueDoc.StoreId = picklistDetail.StoreID; issueDoc.STVID = stvLog.ID; issueDoc.IsTransfer = true; issueDoc.IssuedBy = user.FullName; issueDoc.ItemID = picklistDetail.ItemID; issueDoc.NoOfPack = picklistDetail.Packs; issueDoc.QtyPerPack = picklistDetail.QtyPerPack; issueDoc.Quantity = picklistDetail.QuantityInBU; issueDoc.OrderID = order.ID; issueDoc.UnitID = receiveDoc.UnitID; issueDoc.ManufacturerID = receiveDoc.ManufacturerId; issueDoc.SetColumn("UnitCost", receiveDoc.GetColumn("Cost")); issueDoc.SetColumn("SellingPrice", receiveDoc.GetColumn("SellingPrice")); issueDoc.SetColumn("Margin", receiveDoc.GetColumn("Margin")); issueDoc.SetColumn("PhysicalStoreID", receiveDoc.GetColumn("PhysicalStoreID")); issueDoc.PLDetailID = picklistDetail.ID; issueDoc.RecievDocID = picklistDetail.ReceiveDocID; issueDoc.SetColumn("InventoryPeriodID", receiveDoc.GetColumn("InventoryPeriodID")); // This is a deprecated field issueDoc.RecomendedQty = 0;// picklistDetail.Packs; issueDoc.RefNo = stvLog.IDPrinted.ToString(); issueDoc.DispatchConfirmed = false; issueDoc.Save(); //substract from QuantityLeft receiveDoc.QuantityLeft -= picklistDetail.QuantityInBU; if (receiveDoc.QuantityLeft < 0) { receiveDoc.QuantityLeft = 0; } receiveDoc.Save(); receivePallet.Balance -= picklistDetail.QuantityInBU; if (receivePallet.Balance < 0) { receivePallet.Balance = 0; } receivePallet.ReservedStock -= picklistDetail.Packs; if (receivePallet.ReservedStock < 0) { receivePallet.ReservedStock = 0; } receivePallet.Save(); return(issueDoc); }