//:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
//Used to Remove Articles from DocumentOrder ex when we Delete Article From TicketList.OrderMain Details
public decimal DeleteFromDocumentOrder(ArticleBagKey pKey, decimal pRemoveQuantity)
{
bool isDone = false;
decimal resultRemainQuantity = 0;
string where = string.Empty;
//Store Reference to Future delete Object (After foreach Loop)
fin_documentordermain deleteOrderMain = null;
fin_documentorderticket deleteOrderTicket = null;
fin_documentorderdetail deleteOrderDetail = null;
string articleDesignation = string.Empty;
//Start UnitOfWork
using (UnitOfWork uowSession = new UnitOfWork())
{
OrderMain orderMain = GlobalFramework.SessionApp.OrdersMain[GlobalFramework.SessionApp.CurrentOrderMainOid];
fin_documentordermain xDocumentOrderMain = (fin_documentordermain)FrameworkUtils.GetXPGuidObject(uowSession, typeof(fin_documentordermain), orderMain.PersistentOid);
if (xDocumentOrderMain != null && xDocumentOrderMain.OrderTicket != null)
{
foreach (fin_documentorderticket ticket in xDocumentOrderMain.OrderTicket)
{
foreach (fin_documentorderdetail detail in ticket.OrderDetail)
{
try
{
//Check Equal Key
if (pKey.ArticleOid == detail.Article.Oid && pKey.Price == detail.Price && pKey.Discount == detail.Discount && pKey.Vat == detail.Vat)
{
articleDesignation = pKey.Designation;
resultRemainQuantity += detail.Quantity;
if (!isDone)
{
detail.Quantity -= pRemoveQuantity;
//Assign references to Future Deletes
if (detail.Quantity <= 0)
{
deleteOrderDetail = detail;
}
isDone = true;
}
else
{
where += string.Format(" OR Oid = '{0}'", detail.Oid);
}
}
}
catch (Exception ex)
{
_log.Error(ex.Message, ex);
}
}
}
}
//Debug
//string sql = @"SELECT * FROM fin_documentorderdetail WHERE 1=0{0};";
//_log.Debug(string.Format("Delete(): sql [{0}]", string.Format(sql, where)));
//Audit
FrameworkUtils.Audit("ORDER_ARTICLE_REMOVED", string.Format(
resources.CustomResources.GetCustomResources(GlobalFramework.Settings["customCultureResourceDefinition"], "audit_message_order_article_removed"),
articleDesignation,
1,
resultRemainQuantity - 1,
GlobalFramework.LoggedUser.Name
)
);
if (isDone)
{
//Update xDocumentOrderMain UpdatedAt, Required for RealTime Update
xDocumentOrderMain.UpdatedAt = FrameworkUtils.CurrentDateTimeAtomic();
//Remove Quantity
resultRemainQuantity -= pRemoveQuantity;
//Delete Records, OrderMain, OrderTicket and OrderDetails
if (deleteOrderDetail != null)
{
deleteOrderTicket = deleteOrderDetail.OrderTicket;
deleteOrderMain = deleteOrderTicket.OrderMain;
//Delete Details
deleteOrderDetail.Delete();
//Check if OrderTicket in Empty, If so Delete it, its not required anymore
if (deleteOrderTicket.OrderDetail.Count <= 0)
{
deleteOrderTicket.Delete();
}
;
//Check if OrderMain in Empty, If so Delete it, its not required anymore
if (deleteOrderMain.OrderTicket.Count <= 0)
{
//Before Delete OrderMain, we must UnAssign DocumentMaster SourceOrderMain else we have a CONSTRAINT ERROR on FK_DocumentFinanceMaster_SourceOrderMain trying to delete used OrderMain
string sql = string.Format(@"UPDATE fin_documentfinancemaster SET SourceOrderMain = NULL WHERE SourceOrderMain = '{0}';", deleteOrderMain.Oid);
uowSession.ExecuteScalar(sql);
//Open Table
deleteOrderMain.PlaceTable.TableStatus = TableStatus.Free;
//Audit
FrameworkUtils.Audit("TABLE_OPEN", string.Format(resources.CustomResources.GetCustomResources(GlobalFramework.Settings["customCultureResourceDefinition"], "audit_message_table_open"), deleteOrderMain.PlaceTable.Designation));
//Delete OrderMain
deleteOrderMain.Delete();
}
;
}
;
}
;
try
{
//Commit UOW Changes
uowSession.CommitChanges();
//Update OrderMain UpdatedAt, Required to Sync Terminals
orderMain.UpdatedAt = FrameworkUtils.CurrentDateTimeAtomic();
//Update ArticleBag Price Properties
this[pKey].Quantity = resultRemainQuantity;
UpdateKeyProperties(pKey);
//SEARCH#001
//Require to Remove PartialPayed Items Quantity
return(resultRemainQuantity - FrameworkUtils.GetPartialPaymentPayedItems(uowSession, xDocumentOrderMain.Oid, pKey.ArticleOid));
}
catch (Exception ex)
{
_log.Error(ex.Message, ex);
uowSession.RollbackTransaction();
return(-1);
}
}
}