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);
}
