//:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
//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(
Resx.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(Resx.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);
}
}
}
public FIN_DocumentOrderTicket FinishOrder(Session pSession, bool pPrintTicket)
{
//Local Vars
DateTime currentDateTime = DateTime.Now;
FIN_DocumentOrderMain xOrderMain;
Session _sessionXpo = pSession;
bool isInUOW = (_sessionXpo.GetType() == typeof(UnitOfWork));
//Result
FIN_DocumentOrderTicket xOrderTicket = null;
//Get current Working Order from SessionApp
OrderMain currentOrderMain = GlobalFramework.SessionApp.OrdersMain[GlobalFramework.SessionApp.CurrentOrderMainOid];
OrderTicket currentOrderTicket = currentOrderMain.OrderTickets[currentOrderMain.CurrentTicketId];
//Get Place Object to extract TaxSellType Normal|TakeWay
POS_ConfigurationPlace configurationPlace = (POS_ConfigurationPlace)GlobalFramework.SessionXpo.GetObjectByKey(typeof(POS_ConfigurationPlace), currentOrderMain.Table.PlaceId);
//Use VatDirectSelling if in Retail or in TakeWay mode
TaxSellType taxSellType = (configurationPlace.MovementType.VatDirectSelling || SettingsApp.AppMode == AppOperationMode.Retail) ? TaxSellType.TakeAway : TaxSellType.Normal;
//Open Table on First Finish OrderTicket
POS_ConfigurationPlaceTable xTable = (POS_ConfigurationPlaceTable)FrameworkUtils.GetXPGuidObject(_sessionXpo, typeof(POS_ConfigurationPlaceTable), _table.Oid);
xTable.Reload();
if (xTable.TableStatus != TableStatus.Open)
{
xTable.TableStatus = TableStatus.Open;
FrameworkUtils.Audit("TABLE_OPEN", string.Format(Resx.audit_message_table_open, xTable.Designation));
xTable.DateTableOpen = FrameworkUtils.CurrentDateTimeAtomic();
if (!isInUOW)
{
xTable.Save();
}
}
//Get Current _persistentOid and _from Database
_persistentOid = GetOpenTableFieldValueGuid(_table.Oid, "Oid");
_orderStatus = (OrderStatus)GetOpenTableFieldValue(_table.Oid, "OrderStatus");
_UpdatedAt = FrameworkUtils.CurrentDateTimeAtomic();
//Insert
if (_persistentOid == Guid.Empty)
{
//OrderMain
xOrderMain = new FIN_DocumentOrderMain(_sessionXpo)
{
//Always assign New date to Persistent Date
DateStart = currentDateTime,//currentOrderMain.DateStart,
OrderStatus = OrderStatus.Open,
PlaceTable = xTable,
UpdatedAt = FrameworkUtils.CurrentDateTimeAtomic()
};
if (!isInUOW)
{
xOrderMain.Save();
}
//After Save, Get Oid
_persistentOid = xOrderMain.Oid;
//Change to Open Status
_orderStatus = OrderStatus.Open;
}
//Update
else
{
xOrderMain = (FIN_DocumentOrderMain)FrameworkUtils.GetXPGuidObject(_sessionXpo, typeof(FIN_DocumentOrderMain), _persistentOid);
if (xOrderMain.PlaceTable != xTable)
{
xOrderMain.PlaceTable = xTable;
}
//Force Changes in Record, else UpdatedAt dont Update
xOrderMain.UpdatedAt = FrameworkUtils.CurrentDateTimeAtomic();
//TODO: Check if User was Automatically Updated
//if (xOrderMain.UpdatedBy != GlobalFramework.LoggedUser) xOrderMain.UpdatedBy = GlobalFramework.LoggedUser;
if (!isInUOW)
{
xOrderMain.Save();
}
}
//Create OrderTicket
xOrderTicket = new FIN_DocumentOrderTicket(_sessionXpo)
{
TicketId = currentOrderMain.CurrentTicketId,
DateStart = currentOrderTicket.DateStart,
PriceType = currentOrderTicket.PriceType,
Discount = xTable.Discount,
OrderMain = xOrderMain,
PlaceTable = xTable
};
if (!isInUOW)
{
xOrderTicket.Save();
}
//Create OrderDetail
FIN_DocumentOrderDetail xOrderDetailLine;
FIN_Article xArticle;
uint itemOrd = 0;
decimal priceTax = 0;
foreach (OrderDetailLine line in currentOrderTicket.OrderDetails.Lines)
{
//Use Order in print tickets etc
itemOrd++;
xArticle = (FIN_Article)FrameworkUtils.GetXPGuidObject(_sessionXpo, typeof(FIN_Article), line.ArticleOid);
//Get PriceTax from TaxSellType
priceTax = (taxSellType == TaxSellType.Normal) ? xArticle.VatOnTable.Value : xArticle.VatDirectSelling.Value;
xOrderDetailLine = new FIN_DocumentOrderDetail(_sessionXpo)
{
//Values
Ord = itemOrd,
Code = xArticle.Code,
Designation = line.Designation,
Quantity = line.Properties.Quantity,
UnitMeasure = xArticle.UnitMeasure.Acronym,
Price = line.Properties.PriceNet,
Discount = (xArticle.Discount > 0) ? xArticle.Discount : 0.0m,
TotalGross = line.Properties.TotalGross,
TotalDiscount = line.Properties.TotalDiscount,
TotalTax = line.Properties.TotalTax,
TotalFinal = line.Properties.TotalFinal,
//Use PriceTax Normal|TakeAway
Vat = priceTax,
//XPGuidObjects
Article = xArticle,
OrderTicket = xOrderTicket
};
//Detect VatExemptionReason
if (line.Properties.VatExemptionReason != Guid.Empty)
{
xOrderDetailLine.VatExemptionReason = line.Properties.VatExemptionReason;
}
if (!isInUOW)
{
xOrderDetailLine.Save();
}
}
;
//Clean Details and Open a New Blank Ticket in Session
//Increment Terminal SessionApp CurrentTicketId
_currentTicketId += 1;
currentOrderMain.OrderTickets = new Dictionary <int, OrderTicket>();
currentOrderMain.OrderTickets.Add(currentOrderMain.CurrentTicketId, new OrderTicket(this, _table.PriceType));
//Finish Writing Session
GlobalFramework.SessionApp.Write();
return(xOrderTicket);
//Debug
//_log.Debug(string.Format("FinishOrder(): xOrderMain.Oid [{0}]", xOrderMain.Oid));
//_log.Debug(string.Format("FinishOrder(): _table.OrderMainId [{0}], _currentTicketId [{1}], _table.Name [{2}]", _table.OrderMainId, _currentTicketId, _table.Name));
}