/// <summary>
/// This happes when there is plenty of transaction at the same time
/// and will result a partial commit.
/// This fake rows should be deleted from DB.
/// </summary>
/// <param name="orderID"></param>
private void RemoveFakePartialCommitPickListDetails(int orderID)
{
var order = new Order();
order.LoadByPrimaryKey(orderID);
if (order.OrderStatusID == OrderStatus.Constant.ORDER_APPROVED)
{
var pickList = new PickList();
pickList.LoadByOrderID(order.ID);
if (pickList.RowCount == 0) //~ If there is no picklist, there is nothing to delete. ~//
{
return;
}
var picklistDetail = new PickListDetail();
picklistDetail.LoadByPickListID(pickList.ID);
picklistDetail.Rewind();
while (!picklistDetail.EOF)
{
PickListDetailDeleted.AddNewLog(picklistDetail, CurrentContext.UserId);
picklistDetail.MarkAsDeleted();
picklistDetail.MoveNext();
}
picklistDetail.Save();
pickList.MarkAsDeleted();
pickList.Save();
}
}
private Dictionary <int, Dictionary <decimal, decimal> > MergePickListsOfSameInfo(PickListDetail pld) //~ Dic(Pld.ID,Dic<pld.Pack,pld.QuanInBU>) Just to make things simple~//
{
var mergedPickLists = new Dictionary <int, Dictionary <decimal, decimal> >();
var valid = _receiveDocConstraintHelper.IsValid(pld.DefaultView.Table);
if (valid)
{
pld.Rewind();
while (!pld.EOF)
{
var pack_QInBU = new Dictionary <decimal, decimal> {
{ pld.Packs, pld.QuantityInBU }
};
mergedPickLists[pld.ID] = pack_QInBU;
pld.MoveNext();
}
return(mergedPickLists);
}
var groupedPickLists = _receiveDocConstraintHelper.GroupByConstraints(pld.DefaultView.Table);
foreach (DataRow groupedPickList in groupedPickLists.Rows)
{
var pack_QInBU = new Dictionary <decimal, decimal>
{
{ Convert.ToDecimal(groupedPickList["Packs"]), Convert.ToDecimal(groupedPickList["QuantityInBU"]) }
};
mergedPickLists[Convert.ToInt32(groupedPickList["ID"])] = pack_QInBU;
}
pld.Rewind();
while (!pld.EOF)
{
if (mergedPickLists.ContainsKey(pld.ID))
{
var packs = mergedPickLists[pld.ID].FirstOrDefault().Key;
pld.Packs = packs;
pld.QuantityInBU = mergedPickLists[pld.ID][packs];
}
pld.MoveNext();
}
return(mergedPickLists);
}
/// <summary>
/// Releases the reservation.
/// </summary>
public void ReleaseReservation()
{
PickList pickList = new PickList();
pickList.LoadByOrderID(this.ID);
if (pickList.RowCount == 0) //If there is no picklist, there is nothing to release.
return;
PickListDetail pld = new PickListDetail();
pld.LoadByPickListID(pickList.ID);
pld.Rewind();
while (!pld.EOF)
{
ReceivePallet receivePallet = new ReceivePallet();
receivePallet.LoadByPrimaryKey(pld.ReceivePalletID);
ReceiveDoc rdoc = new ReceiveDoc();
rdoc.LoadByPrimaryKey(pld.ReceiveDocID);
receivePallet.ReservedStock = receivePallet.ReservedStock - Convert.ToInt32(pld.QuantityInBU);
if (receivePallet.ReservedStock < 0)
receivePallet.ReservedStock = 0;
receivePallet.Save();
//Delete from picklistDetail and add to pickListDetailDeleted
PickListDetailDeleted.AddNewLog(pld, BLL.CurrentContext.UserId);
pld.MarkAsDeleted();
pld.MoveNext();
//Delete issues if the order has any
var iss = new Issue();
iss.GetIssueByOrderID(this.ID);
iss.Rewind();
if (iss.RowCount > 0)
{
while (!iss.EOF)
{
iss.MarkAsDeleted();
iss.MoveNext();
}
iss.Save();
}
}
pld.Save();
pickList.MarkAsDeleted();
pickList.Save();
}
/// <summary>
/// This happes when there is plenty of transaction at the same time
/// and will result a partial commit.
/// This fake rows should be deleted from DB.
/// </summary>
/// <param name="orderID"></param>
private void RemoveFakePartialCommitPickListDetails(int orderID)
{
var order = new Order();
order.LoadByPrimaryKey(orderID);
if (order.OrderStatusID == OrderStatus.Constant.ORDER_APPROVED)
{
var pickList = new PickList();
pickList.LoadByOrderID(order.ID);
if (pickList.RowCount == 0) //~ If there is no picklist, there is nothing to delete. ~//
return;
var picklistDetail = new PickListDetail();
picklistDetail.LoadByPickListID(pickList.ID);
picklistDetail.Rewind();
while (!picklistDetail.EOF)
{
PickListDetailDeleted.AddNewLog(picklistDetail, CurrentContext.UserId);
picklistDetail.MarkAsDeleted();
picklistDetail.MoveNext();
}
picklistDetail.Save();
pickList.MarkAsDeleted();
pickList.Save();
}
}
//~ Dic(Pld.ID,Dic<pld.Pack,pld.QuanInBU>) Just to make things simple~//
private Dictionary<int, Dictionary<decimal, decimal>> MergePickListsOfSameInfo(PickListDetail pld)
{
var mergedPickLists = new Dictionary<int, Dictionary<decimal, decimal>>();
var valid = _receiveDocConstraintHelper.IsValid(pld.DefaultView.Table);
if(valid)
{
pld.Rewind();
while (!pld.EOF)
{
var pack_QInBU = new Dictionary<decimal, decimal> {{pld.Packs, pld.QuantityInBU}};
mergedPickLists[pld.ID] = pack_QInBU;
pld.MoveNext();
}
return mergedPickLists;
}
var groupedPickLists = _receiveDocConstraintHelper.GroupByConstraints(pld.DefaultView.Table);
foreach (DataRow groupedPickList in groupedPickLists.Rows)
{
var pack_QInBU = new Dictionary<decimal, decimal>
{
{Convert.ToDecimal(groupedPickList["Packs"]), Convert.ToDecimal(groupedPickList["QuantityInBU"])}
};
mergedPickLists[Convert.ToInt32(groupedPickList["ID"])] = pack_QInBU;
}
pld.Rewind();
while (!pld.EOF)
{
if (mergedPickLists.ContainsKey(pld.ID))
{
var packs = mergedPickLists[pld.ID].FirstOrDefault().Key;
pld.Packs = packs;
pld.QuantityInBU = mergedPickLists[pld.ID][packs];
}
pld.MoveNext();
}
return mergedPickLists;
}
/// <summary>
/// Commits the account to account transfer.
/// </summary>
/// <param name="orderID">The order ID.</param>
/// <param name="userID">The user ID.</param>
/// <param name="convertedEthDate">The converted eth date.</param>
public void CommitAccountToAccountTransfer(int orderID, int userID, DateTime convertedEthDate)
{
int? supplierID = null;
BLL.Transfer transfer = new Transfer();
transfer.LoadByOrderID(orderID);
if (transfer.RowCount == 0)
return;
int newStoreID, newPhysicalStoreID;
newStoreID = transfer.ToStoreID;
newPhysicalStoreID = transfer.ToPhysicalStoreID;
PhysicalStore toPhysicalStore = new PhysicalStore();
toPhysicalStore.LoadByPrimaryKey(transfer.ToPhysicalStoreID);
BLL.PickList picklist = new PickList();
picklist.LoadByOrderID(orderID);
BLL.PickListDetail pld = new PickListDetail();
pld.LoadByPickListIDWithStvlogID(picklist.ID);
BLL.ReceiveDoc rdOriginal = new ReceiveDoc();
rdOriginal.LoadByPrimaryKey(pld.ReceiveDocID);
BLL.Order order=new Order();
order.LoadByPrimaryKey(orderID);
if(order.OrderTypeID == OrderType.CONSTANTS.ACCOUNT_TO_ACCOUNT_TRANSFER)
{
var activity = new Activity();
activity.LoadByPrimaryKey(newStoreID);
supplierID = activity.SupplierID;
}
else if(order.OrderTypeID == OrderType.CONSTANTS.STORE_TO_STORE_TRANSFER)
{
var activity = new Activity();
activity.LoadByPrimaryKey(newPhysicalStoreID);
supplierID = activity.SupplierID;
}
PO po = PO.CreatePOforStandard( (int) order.GetColumn("OrderTypeID"),transfer.ToStoreID,supplierID,"Transfer",CurrentContext.LoggedInUser.ID);
int IDPrinted = Convert.ToInt32(pld.GetColumn("IDPrinted"));
int receiptTypeID = order.OrderTypeID == OrderType.CONSTANTS.ACCOUNT_TO_ACCOUNT_TRANSFER
? ReceiptType.CONSTANTS.ACCOUNT_TO_ACCOUNT_TRANSFER
:order.OrderTypeID == OrderType.CONSTANTS.STORE_TO_STORE_TRANSFER
? ReceiptType.CONSTANTS.STORE_TO_STORE_TRANSFER
: order.OrderTypeID == OrderType.CONSTANTS.ERROR_CORRECTION_TRANSFER
? ReceiptType.CONSTANTS.ERROR_CORRECTION:ReceiptType.CONSTANTS.STANDARD_RECEIPT;
Receipt receipt = ReceiptInvoice.CreateReceiptInvoiceAndReceiptForTransfer(receiptTypeID,po.ID,toPhysicalStore.PhysicalStoreTypeID,IDPrinted,userID);
var mergedPickLists = MergePickListsOfSameInfo(pld); // Picklists of the same info means: Based on all constraints we have on receiveDoc(Batch,Exp,ItemID,UnitID...): should be merged with summed quantity.
pld.Rewind();
while (!pld.EOF)
{
if(IDPrinted != Convert.ToInt32(pld.GetColumn("IDPrinted")))
{
IDPrinted = Convert.ToInt32(pld.GetColumn("IDPrinted"));
receipt = ReceiptInvoice.CreateReceiptInvoiceAndReceiptForTransfer(receiptTypeID,po.ID, toPhysicalStore.PhysicalStoreTypeID, IDPrinted, userID);
}
var rDoc = new ReceiveDoc();
if (!mergedPickLists.ContainsKey(pld.ID))
{
pld.MoveNext();
continue;
}
rDoc.SaveNewReceiveDocEntryFromPicklistDetail(pld, userID, newStoreID, newPhysicalStoreID,
convertedEthDate,receipt.ID,supplierID);
pld.MoveNext();
}
}
/// <summary>
/// Commits the account to account transfer.
/// </summary>
/// <param name="orderID">The order ID.</param>
/// <param name="userID">The user ID.</param>
/// <param name="convertedEthDate">The converted eth date.</param>
public void CommitAccountToAccountTransfer(int orderID, int userID, DateTime convertedEthDate)
{
int?supplierID = null;
BLL.Transfer transfer = new Transfer();
transfer.LoadByOrderID(orderID);
if (transfer.RowCount == 0)
{
return;
}
int newStoreID, newPhysicalStoreID;
newStoreID = transfer.ToStoreID;
newPhysicalStoreID = transfer.ToPhysicalStoreID;
PhysicalStore toPhysicalStore = new PhysicalStore();
toPhysicalStore.LoadByPrimaryKey(transfer.ToPhysicalStoreID);
BLL.PickList picklist = new PickList();
picklist.LoadByOrderID(orderID);
BLL.PickListDetail pld = new PickListDetail();
pld.LoadByPickListIDWithStvlogID(picklist.ID);
BLL.ReceiveDoc rdOriginal = new ReceiveDoc();
rdOriginal.LoadByPrimaryKey(pld.ReceiveDocID);
BLL.Order order = new Order();
order.LoadByPrimaryKey(orderID);
if (order.OrderTypeID == OrderType.CONSTANTS.ACCOUNT_TO_ACCOUNT_TRANSFER)
{
var activity = new Activity();
activity.LoadByPrimaryKey(newStoreID);
supplierID = activity.SupplierID;
}
else if (order.OrderTypeID == OrderType.CONSTANTS.STORE_TO_STORE_TRANSFER)
{
var activity = new Activity();
activity.LoadByPrimaryKey(newPhysicalStoreID);
supplierID = activity.SupplierID;
}
PO po = PO.CreatePOforStandard((int)order.GetColumn("OrderTypeID"), transfer.ToStoreID, supplierID, "Transfer", CurrentContext.LoggedInUser.ID);
int IDPrinted = Convert.ToInt32(pld.GetColumn("IDPrinted"));
int receiptTypeID = order.OrderTypeID == OrderType.CONSTANTS.ACCOUNT_TO_ACCOUNT_TRANSFER
? ReceiptType.CONSTANTS.ACCOUNT_TO_ACCOUNT_TRANSFER
:order.OrderTypeID == OrderType.CONSTANTS.STORE_TO_STORE_TRANSFER
? ReceiptType.CONSTANTS.STORE_TO_STORE_TRANSFER
: order.OrderTypeID == OrderType.CONSTANTS.ERROR_CORRECTION_TRANSFER
? ReceiptType.CONSTANTS.ERROR_CORRECTION:ReceiptType.CONSTANTS.STANDARD_RECEIPT;
Receipt receipt = ReceiptInvoice.CreateReceiptInvoiceAndReceiptForTransfer(receiptTypeID, po.ID, toPhysicalStore.PhysicalStoreTypeID, IDPrinted, userID);
var mergedPickLists = MergePickListsOfSameInfo(pld); // Picklists of the same info means: Based on all constraints we have on receiveDoc(Batch,Exp,ItemID,UnitID...): should be merged with summed quantity.
pld.Rewind();
while (!pld.EOF)
{
if (IDPrinted != Convert.ToInt32(pld.GetColumn("IDPrinted")))
{
IDPrinted = Convert.ToInt32(pld.GetColumn("IDPrinted"));
receipt = ReceiptInvoice.CreateReceiptInvoiceAndReceiptForTransfer(receiptTypeID, po.ID, toPhysicalStore.PhysicalStoreTypeID, IDPrinted, userID);
}
var rDoc = new ReceiveDoc();
if (!mergedPickLists.ContainsKey(pld.ID))
{
pld.MoveNext();
continue;
}
rDoc.SaveNewReceiveDocEntryFromPicklistDetail(pld, userID, newStoreID, newPhysicalStoreID,
convertedEthDate, receipt.ID, supplierID);
pld.MoveNext();
}
}
private static void HandleReceiveDocDeleting(int receiveDocID, int userID, ReceiveDoc rd)
{
//Check if there is a Related Picklists
var pld = new PickListDetail();
pld.LoadByReceiveDocID(receiveDocID);
pld.Rewind();
if(pld.RowCount > 0)
{
var pl = new PickList();
pl.LoadByPrimaryKey(pld.PickListID);
var order = new Order();
order.LoadByPrimaryKey(pl.OrderID);
string printedIDs = "";
var stvs = new BLL.Issue();
stvs.Where.PickListID.Value = pl.ID;
stvs.Query.Load();
stvs.Rewind();
while (!stvs.EOF)
{
printedIDs += stvs.IDPrinted.ToString(CultureInfo.InvariantCulture) + " ,";
stvs.MoveNext();
}
printedIDs = printedIDs.Remove(printedIDs.Length - 1, 1);
throw new Exception(
string.Format("Please cancel/void the following Stvs: Ref No = {0} With PrintedIDs : {1}",
order.RefNo,printedIDs));
}
// Add new record on ReceiveDocDeleted
var recDel = ReceiveDocDeleted.AddNewLog(rd, userID);
// Delete related ReceivePallet
var receivePallet = new BLL.ReceivePallet();
receivePallet.LoadByReceiveDocID(receiveDocID);
receivePallet.Rewind();
while(!receivePallet.EOF)
{
receivePallet.MarkAsDeleted();
receivePallet.MoveNext();
}
// Delete related ReceivePriceConfirmation
var receivePriceConfirmation = new ReceivePriceConfirmation();
receivePriceConfirmation.LoadByReceiveDocID(rd.ID);
receivePriceConfirmation.MarkAsDeleted();
// Delete related ReceiveDocShortage
var rdShr = new ReceiveDocShortage();
rdShr.Where.ReceiveDocID.Value = rd.ID;
rdShr.Query.Load();
rdShr.Rewind();
while(!rdShr.EOF)
{
rdShr.MarkAsDeleted();
rdShr.MoveNext();
}
// Delete related ReceiveDocConfirmation
var rdConf = new ReceiveDocConfirmation();
rdConf.Where.ReceiveDocID.Value = rd.ID;
rdConf.Query.Load();
rdConf.Rewind();
while(!rdConf.EOF)
{
rdConf.MarkAsDeleted();
rdConf.MoveNext();
}
rd.MarkAsDeleted();
var transaction = MyGeneration.dOOdads.TransactionMgr.ThreadTransactionMgr();
transaction.BeginTransaction();
try
{
receivePallet.Save();
receivePriceConfirmation.Save();
rdShr.Save();
rdConf.Save();
recDel.Save();
rd.Save();
transaction.CommitTransaction();
}
catch (Exception exception)
{
transaction.RollbackTransaction();
throw;
}
}