public OrderDateModel GetListOrderPrevOrder(string idTable, int idOrder, DateTime ts)
{
OrderDateModel OrderMain = new OrderDateModel();
try
{
var dataOrder = _context.INVOICEs.Where(x => x.OrderID == idOrder && x.Status == 1).SingleOrDefault();
if (dataOrder != null)
{
OrderMain.Seat = dataOrder.Seat ?? 0;
//OrderMain.FloorID = dataOrder.FloorID;
OrderMain.OrderID = dataOrder.OrderID ?? 0;
OrderMain.TotalAmount = dataOrder.Total;
OrderMain.ShiftID = dataOrder.ShiftID ?? 0;
OrderMain.CreateBy = dataOrder.CreateBy;
OrderMain.UpdateBy = dataOrder.UpdateBy;
OrderMain.Payment = dataOrder.Payment ?? 0;
OrderMain.Change = dataOrder.Change ?? 0;
OrderMain.Discount = dataOrder.Discount ?? 0;
OrderMain.DiscountType = dataOrder.DiscountType ?? 0;
OrderMain.InvoiceID = dataOrder.InvoiceID;
var listPayMent = _context.INVOICEs.Join(_context.PAYMENT_INVOICE_HISTORY, inv => inv.InvoiceID, pay => pay.InvoiceID, (inv, pay) => new { inv, pay })
.Where(x => x.inv.InvoiceID == x.pay.InvoiceID && x.inv.InvoiceID == dataOrder.InvoiceID && x.pay.InvoiceID == dataOrder.InvoiceID)
.Select(x => new PayMentModel
{
InvoiceNumber = x.inv.InvoiceID.ToString(),
Total = x.pay.Total,
PaymentTypeID = x.pay.PaymentTypeID,
PaymentHistoryID = x.pay.PaymentHistoryID
}
);
foreach (PayMentModel pay in listPayMent)
{
PayMentModel item = new PayMentModel();
item.InvoiceNumber = pay.InvoiceNumber;
item.PaymentHistoryID = pay.PaymentHistoryID;
item.PaymentTypeID = pay.PaymentTypeID;
item.Total = pay.Total;
OrderMain.ListPayment.Add(item);
}
var listCard = _context.INVOICEs.Join(_context.INVOICE_BY_CARD, invoice => invoice.InvoiceID, incard => incard.InvoiceID, (invoice, incard) => new { invoice, incard })
.Where(x => x.incard.InvoiceID == x.incard.InvoiceID && x.incard.InvoiceID == dataOrder.InvoiceID)
.Select(x => new InByCardModel
{
InvoiceID = x.incard.InvoiceID,
CardID = x.incard.CardID,
Total = x.incard.Total,
}
);
var Account = _context.INVOICEs.Join(_context.ACC_PAYMENT, invoice => invoice.InvoiceNumber, acc => acc.InvoiceNumber, (invoice, acc) => new { invoice, acc })
.Join(_context.CLIENTs, cus => cus.acc.CusNo, c => c.ClientID, (cus, c) => new { cus, c })
.Where(x => x.cus.acc.InvoiceID == x.cus.invoice.InvoiceID && x.cus.acc.InvoiceNumber == x.cus.acc.InvoiceNumber && x.c.ClientID == x.cus.acc.CusNo && x.cus.acc.InvoiceNumber == dataOrder.InvoiceNumber).SingleOrDefault();
if (Account != null)
{
OrderMain.CusItem.Fname = Account.c.Fname;
OrderMain.CusItem.ClientID = Account.c.ClientID;
}
foreach (InByCardModel item in listCard)
{
var getCardName = _context.Cards.Where(x => x.CardID == item.CardID).SingleOrDefault();
InvoiceByCardModel byINCard = new InvoiceByCardModel();
byINCard.Total = item.Total;
byINCard.NameCard = getCardName.CardName;
OrderMain.ListInvoiceByCard.Add(byINCard);
}
var data = _context.INVOICEs.Join(_context.INVOICE_DETAIL, order => order.InvoiceID,
item => item.InvoiceID, (order, item) => new { order, item })
.Join(_context.PRODUCTs, pro => pro.item.ProductID, c => c.ProductID, (pro, c) => new { pro, c })
.Where(x => x.pro.order.InvoiceID == dataOrder.InvoiceID && x.pro.order.InvoiceID == x.pro.item.InvoiceID && x.pro.order.InvoiceID == dataOrder.InvoiceID && x.pro.item.InvoiceID == dataOrder.InvoiceID && x.pro.item.ProductID == x.c.ProductID)
.Select(x => new OrderDetailModel()
{
ProductID = x.pro.item.ProductID ?? 0,
Price = x.pro.item.Price,
Qty = x.pro.item.Qty,
Total = x.pro.item.Qty * x.pro.item.Price,
InvoiceID = x.pro.item.InvoiceID,
Satust = x.pro.item.Status,
ProductName = x.c.ProductNameSort,
KeyItem = x.pro.item.KeyItem ?? 0,
Seat = x.pro.item.Seat ?? 0,
DynID = x.pro.item.DynId ?? 0,
OrderDetailID = x.pro.item.OrderDetailID ?? 0
});
var openitems = _context.INVOICE_DETAIL.Join(_context.ORDER_OPEN_ITEM, x => x.DynId, openitem => openitem.dynID, (x, openitem) => new { x, openitem })
.Where(a => a.x.DynId == a.openitem.dynID && a.x.InvoiceID == dataOrder.InvoiceID)
.Select(a => new OrderDetailModel()
{
ProductName = a.openitem.ItemNameShort,
Qty = a.x.Qty,
Price = a.openitem.UnitPrice,
ProductID = a.x.ProductID ?? 0,
Total = a.x.Qty * a.x.Price,
InvoiceID = a.x.InvoiceID,
Satust = a.x.Status,
KeyItem = a.x.KeyItem ?? 0,
Seat = a.x.Seat ?? 0,
DynID = a.x.DynId ?? 0,
OrderDetailID = a.x.OrderDetailID ?? 0
});
foreach (OrderDetailModel openItem in openitems)
{
OrderMain.addItemToList(openItem);
}
foreach (OrderDetailModel item in data)
{
int keyItemOld = item.KeyItem;
var dataOrderModifire = _context.INVOICE_DETAIL.Join(_context.INVOICE_DETAIL_MODIFIRE, pro => pro.ProductID,
modifire => modifire.ProductID, (pro, modifire) => new { pro, modifire })
.Join(_context.MODIFIREs, modi => modi.modifire.ModifireID, c => c.ModifireID, (modi, c) => new { modi, c })
.Where(x => x.modi.pro.InvoiceID == item.InvoiceID && x.modi.modifire.InvoiceID == item.InvoiceID && x.modi.pro.ProductID == item.ProductID && x.modi.modifire.ProductID == item.ProductID && x.modi.modifire.ModifireID == x.c.ModifireID && x.modi.modifire.KeyModi == keyItemOld && x.modi.pro.KeyItem == keyItemOld)
.Select(x => new OrderDetailModifireModel()
{
ModifireID = x.modi.modifire.ModifireID ?? 0,
Price = x.modi.modifire.Price,
Qty = x.modi.modifire.Qty,
ModifireName = x.c.ModifireName,
Total = x.modi.modifire.Price * x.modi.modifire.Qty,
Seat = x.modi.modifire.Seat ?? 0,
OrderModifireID = x.modi.modifire.OrderModifireID ?? 0,
InvoiceID = x.modi.pro.InvoiceID,
DynID = x.modi.modifire.DynId ?? 0
});
OrderMain.addItemToList(item);
foreach (OrderDetailModifireModel itemmodifire in dataOrderModifire)
{
OrderMain.addModifierToList(itemmodifire, item.KeyItem);
}
var openItemModiier = _context.INVOICE_DETAIL_MODIFIRE.Join(_context.ORDER_OPEN_ITEM, modi => modi.DynId, open => open.dynID, (modi, open) => new { modi, open })
.Where(x => x.modi.DynId == x.open.dynID && x.modi.ProductID == item.ProductID && x.modi.InvoiceID == item.InvoiceID && x.modi.KeyModi == keyItemOld)
.Select(x => new OrderDetailModifireModel()
{
ModifireID = x.modi.ModifireID ?? 0,
Price = x.modi.Price,
Qty = x.modi.Qty,
ModifireName = x.open.ItemNameShort,
Total = x.modi.Price * x.modi.Qty,
Seat = x.modi.Seat ?? 0,
OrderModifireID = x.modi.OrderModifireID ?? 0,
InvoiceID = x.modi.InvoiceID ?? 0,
DynID = x.modi.DynId ?? 0
});
foreach (OrderDetailModifireModel Openitem in openItemModiier)
{
OrderMain.addModifierToList(Openitem, item.KeyItem);
}
}
}
}
catch (Exception ex)
{
SystemLog.LogPOS.WriteLog("OrderService::::::::::::::::GetListOrderPrevOrder::::::::::::::" + ex.Message);
}
return OrderMain;
}
private void btnCard_Click(object sender, EventArgs e)
{
try
{
if (txtTender.Text != string.Empty && Convert.ToDouble(txtTender.Text)>0)
{
lockTextChange = true;
frmChooseCard frm = new frmChooseCard(cardTemp);
if (frm.ShowDialog() == System.Windows.Forms.DialogResult.Yes)
{
cardTemp = frm.Card;
cardTemp.PayMenyID = 2;
cardTemp.SubTotal = Convert.ToDouble(txtTender.Text);
addCard(cardTemp);
addPayment(cardTemp);
InvoiceByCardModel item = new InvoiceByCardModel();
item.CardID = cardTemp.CardID;
item.Total = cardTemp.SubTotal * 1000;
item.NameCard = cardTemp.CardName;
lstInvoiceByCard.Add(item);
lstInvoiceByCardSplitBill.Add(item);
CheckTotal();
lockTextChange = false;
}
}
}
catch (Exception ex)
{
LogPOS.WriteLog("frmPayMent:::::::::::::::::::::::::::::::::;btnCard_Click::::::::::::::::::::::::::;;" + ex.Message);
}
}