public frmPayMent(OrderDateModel _OrderMain, int AnimationTime, int Flags) { //animationTime = AnimationTime; //flags = Flags; animationTime = AnimationTime; flags = Flags; InitializeComponent(); OrderMain = _OrderMain; txtTender.Focus(); ucKeyPadOrder1.txtResult = txtTender; this.Location = new Point(0, 100); }
public int CancelOrder(OrderDateModel Order) { int Result = 0; try { using (var tran = _context.Database.BeginTransaction()) { _context.Database.ExecuteSqlCommand("update ORDER_DATE set Status=4 where OrderID='" + Order.OrderID + "'"); tran.Commit(); Result = 1; } } catch (Exception ex) { } return Result; }
public bool checkOrderChange(OrderDateModel order) { bool flag = false; for (int i = 0; i < order.ListOrderDetail.Count; i++) { if (order.ListOrderDetail[i].ChangeStatus == 1) flag = true; if (order.ListOrderDetail[i].ListOrderDetailModifire.Count > 0) { for (int j = 0; j < order.ListOrderDetail[i].ListOrderDetailModifire.Count; j++) { if (order.ListOrderDetail[i].ListOrderDetailModifire[j].ChangeStatus == 1) flag = true; } } } if (order.HaveNote == 1) flag = true; return flag; }
private List<PAYMENT_INVOICE_HISTORY> CopyListPayment(OrderDateModel Order) { List<PAYMENT_INVOICE_HISTORY> lst = new List<PAYMENT_INVOICE_HISTORY>(); lst.Clear(); for (int i = 0; i < Order.ListPayment.Count; i++) { PAYMENT_INVOICE_HISTORY item = new PAYMENT_INVOICE_HISTORY(); item.PaymentTypeID = Order.ListPayment[i].PaymentTypeID; item.Status = 1; item.Total = Order.ListPayment[i].Total*1000; item.CreateBy = Order.ListPayment[i].CreateBy ?? 0; item.CreateDate = DateTime.Now; item.UpdateBy = Order.ListPayment[i].UpdateBy ?? 0; item.UpdateDate = DateTime.Now; item.Note = Order.ListPayment[i].Note ?? ""; lst.Add(item); } return lst; }
private List<INVOICE_DETAIL> CopyInvoicedetail(OrderDateModel itemOrder) { List<INVOICE_DETAIL> lstorderDetailDate = new List<INVOICE_DETAIL>(); lstorderDetailDate.Clear(); try { for (int i = 0; i < itemOrder.ListOrderDetail.Count; i++) { INVOICE_DETAIL orderDetaiDate = new INVOICE_DETAIL(); orderDetaiDate.OrderDetailID = itemOrder.ListOrderDetail[i].OrderDetailID; orderDetaiDate.ProductID = itemOrder.ListOrderDetail[i].ProductID; orderDetaiDate.DynId = itemOrder.ListOrderDetail[i].DynID; orderDetaiDate.Seat = itemOrder.ListOrderDetail[i].Seat; orderDetaiDate.Qty = itemOrder.ListOrderDetail[i].Qty; orderDetaiDate.KeyItem = itemOrder.ListOrderDetail[i].KeyItem; orderDetaiDate.Total = itemOrder.ListOrderDetail[i].Total; orderDetaiDate.Price = itemOrder.ListOrderDetail[i].Price; orderDetaiDate.Status = itemOrder.ListOrderDetail[i].Satust; orderDetaiDate.Note = itemOrder.ListOrderDetail[i].Note; orderDetaiDate.CreateBy = itemOrder.ListOrderDetail[i].CreateBy ?? 0; orderDetaiDate.CreateDate = itemOrder.ListOrderDetail[i].CreateDate ?? DateTime.Now; orderDetaiDate.UpdateBy = itemOrder.ListOrderDetail[i].UpdateBy ?? 0; orderDetaiDate.UpdateDate = itemOrder.ListOrderDetail[i].UpdateDate ?? DateTime.Now; lstorderDetailDate.Add(orderDetaiDate); } } catch (Exception ex) { LogPOS.WriteLog("CopyOrderDetailDate:::::::::::::::::::::::::" + ex.Message); } return lstorderDetailDate; }
private INVOICE CopyInvoice(OrderDateModel itemOrder) { INVOICE invoice = new INVOICE(); invoice.InvoiceNumber = itemOrder.InvoiceNumber; invoice.OrderID = itemOrder.OrderID; invoice.OrderNumber = itemOrder.OrderNumber; invoice.Total = Convert.ToInt32(itemOrder.TotalAmount); invoice.Status = 1; invoice.DiscountType = itemOrder.DiscountType; invoice.Discount =(itemOrder.Discount); invoice.Payment = itemOrder.Payment; invoice.Change = itemOrder.Change; invoice.CashOut =Convert.ToInt32(itemOrder.CashOut); if (itemOrder.ListInvoiceByCard.Count > 0) invoice.InvoiceByCardID =Convert.ToInt32(CustomerInvoiceByCardID()); else invoice.InvoiceByCardID = 0; invoice.CreateBy = itemOrder.CreateBy ?? 0; invoice.CreateDate = DateTime.Now; invoice.UpdateBy = itemOrder.UpdateBy ?? 0; invoice.UpdateDate = DateTime.Now; invoice.Note = itemOrder.Note ?? ""; invoice.ShiftID = itemOrder.ShiftID; return invoice; }
public void BindOrder(OrderDateModel OrderMain) { try { detailScreen(); if (OrderMain.ListSeatOfOrder.Count > 0) { OrderMain.IsLoadFromData = true; Boolean addSet; foreach (SeatModel seat in OrderMain.ListSeatOfOrder) { addSet = true; if (OrderMain.ListOrderDetail.Count > 0) { for (int i = 0; i < OrderMain.ListOrderDetail.Count; i++) { if (OrderMain.ListOrderDetail[i].Seat == seat.Seat) { if (addSet) { UCSeat ucSeat = new UCSeat(); ucSeat.lblSeat.Text = "Seat " + seat.Seat.ToString(); ucSeat.Tag = seat.Seat; flowLayoutPanel1.Controls.Add(ucSeat); indexControl = flowLayoutPanel1.Controls.Count; addSet = false; } addOrder(OrderMain.ListOrderDetail[i]); indexControl++; for (int j = 0; j < OrderMain.ListOrderDetail[i].ListOrderDetailModifire.Count; j++) { UCItemModifierOfMenu uc = new UCItemModifierOfMenu(); uc.Tag = OrderMain.ListOrderDetail[i].ListOrderDetailModifire[j]; addModifreToOrder(uc, OrderMain.ListOrderDetail[i].ListOrderDetailModifire[j]); indexControl++; } } else { if (OrderMain.ListOrderDetail[i].Seat == 0) { addOrder(OrderMain.ListOrderDetail[i]); indexControl++; for (int j = 0; j < OrderMain.ListOrderDetail[i].ListOrderDetailModifire.Count; j++) { UCItemModifierOfMenu uc = new UCItemModifierOfMenu(); uc.Tag = OrderMain.ListOrderDetail[i].ListOrderDetailModifire[j]; addModifreToOrder(uc, OrderMain.ListOrderDetail[i].ListOrderDetailModifire[j]); indexControl++; } } } } } } } else { if (OrderMain.ListOrderDetail.Count > 0) { OrderMain.IsLoadFromData = true; for (int i = 0; i < OrderMain.ListOrderDetail.Count; i++) { addOrder(OrderMain.ListOrderDetail[i]); for (int j = 0; j < OrderMain.ListOrderDetail[i].ListOrderDetailModifire.Count; j++) { UCItemModifierOfMenu uc = new UCItemModifierOfMenu(); uc.Tag = OrderMain.ListOrderDetail[i].ListOrderDetailModifire[j]; addModifreToOrder(uc, OrderMain.ListOrderDetail[i].ListOrderDetailModifire[j]); } } } } this.lblSubtotal.Text = money.Format2(OrderMain.SubTotal()); this.lblTax.Text = "N/A"; this.lblTotal.Text = money.Format2(OrderMain.SubTotal()); } catch (Exception ex) { SystemLog.LogPOS.WriteLog("POS::frmCustomerDisplay:::::::::::::::::::" + ex.Message); } }
private void RefeshOrderMain(OrderDateModel OrderRefesh,FlowLayoutPanel flp) { flp.Controls.Clear(); if (OrderRefesh.ListOrderDetail.Count > 0) { for (int i = 0; i < OrderRefesh.ListOrderDetail.Count; i++) { addOrder(OrderRefesh.ListOrderDetail[i], flp); for (int j = 0; j < OrderRefesh.ListOrderDetail[i].ListOrderDetailModifire.Count; j++) { UCItemModifierOfMenu uc = new UCItemModifierOfMenu(); uc.Tag = OrderRefesh.ListOrderDetail[i].ListOrderDetailModifire[j]; //uc.Click += ucItemModifierOfMenu_Click; addModifreToOrder(uc, OrderRefesh.ListOrderDetail[i].ListOrderDetailModifire[j],flp); } } } }
public float printnTransferTableNotAll(OrderDateModel Order, PrintPageEventArgs e) { float l_y = 0; l_y = posPrinter.DrawString(Header, e, new Font("Arial", 14, FontStyle.Italic), l_y, 2); l_y += posPrinter.GetHeightPrinterLine() / 10; l_y=posPrinter.DrawLine("", new Font("Arial", 14), e, System.Drawing.Drawing2D.DashStyle.Dot, l_y, 1); l_y = posPrinter.DrawString(DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString(), e, new Font("Arial", 14, FontStyle.Italic), l_y, 1); l_y += posPrinter.GetHeightPrinterLine() / 10; l_y = posPrinter.DrawString("OPERATOR#MANAGER", e, new Font("Arial", 14, FontStyle.Italic), l_y, 1); posPrinter.DrawString("Table# " + Order.FloorID, e, new Font("Arial", 14, FontStyle.Italic), l_y, 1); l_y = posPrinter.DrawString("Order#" + Order.OrderID, e, new Font("Arial", 14), l_y, 3); posPrinter.DrawLine("", new Font("Arial", 14), e, System.Drawing.Drawing2D.DashStyle.Dot, l_y, 1); l_y += posPrinter.GetHeightPrinterLine() / 10; int countItem =0; for (int i = 0; i < Order.ListOrderDetail.Count; i++) { float yStart = l_y; if (Order.ListOrderDetail[i].ChangeStatus == 2) { l_y = posPrinter.DrawString(Order.ListOrderDetail[i].ProductName, e, new Font("Arial", 14), l_y, 1); posPrinter.DrawCancelLine(e, yStart, l_y); } else { if (Order.ListOrderDetail[i].ChangeStatus == 1) { l_y = posPrinter.DrawString("--Add " + Order.ListOrderDetail[i].ProductName, e, new Font("Arial", 14), l_y, 1); } else { countItem++; l_y = posPrinter.DrawString(Order.ListOrderDetail[i].Qty.ToString() + " " + Order.ListOrderDetail[i].ProductName, e, new Font("Arial", 14), l_y, 1); } } //l_y = posPrinter.DrawString(OrderMain.ListOrderDetail[i].Qty.ToString(), e, new Font("Arial", 14), l_y, 2); //posPrinter.DrawString("$" + money.Format2(OrderMain.ListOrderDetail[i].Price.ToString()), e, new Font("Arial", 14), yStart, 3); if (Order.ListOrderDetail[i].ListOrderDetailModifire.Count > 0) { for (int j = 0; j < Order.ListOrderDetail[i].ListOrderDetailModifire.Count; j++) { if (Order.ListOrderDetail[i].ListOrderDetailModifire[j].ChangeStatus == 2) { l_y = posPrinter.DrawString(Order.ListOrderDetail[i].ListOrderDetailModifire[j].ModifireName, e, new Font("Arial", 10), l_y, 1); posPrinter.DrawCancelLine(e, yStart, l_y); } else { if (Order.ListOrderDetail[i].ListOrderDetailModifire[j].ChangeStatus == 1) { l_y = posPrinter.DrawString("--Add" + Order.ListOrderDetail[i].ListOrderDetailModifire[j].ModifireName, e, new Font("Arial", 10, FontStyle.Italic), l_y, 1); } else { if(!OrderMain.IsLoadFromData) l_y = posPrinter.DrawString("--" + Order.ListOrderDetail[i].ListOrderDetailModifire[j].ModifireName, e, new Font("Arial", 10, FontStyle.Italic), l_y, 1); } } //l_y = posPrinter.DrawString("$" + money.Format2(OrderMain.ListOrderDetail[i].ListOrderDetailModifire[j].Price.ToString()), e, new Font("Arial", 14), l_y, 3); } } } l_y += posPrinter.GetHeightPrinterLine() / 10; posPrinter.DrawLine("", new Font("Arial", 14), e, System.Drawing.Drawing2D.DashStyle.Dot, l_y, 1); l_y = posPrinter.DrawString("", e, new Font("Arial", 14), l_y, 1); l_y += posPrinter.GetHeightPrinterLine() / 10; posPrinter.DrawString("Total item: "+countItem, e, new Font("Arial", 14, FontStyle.Bold), l_y, 1); //l_y = posPrinter.DrawString("$" + money.Format2(OrderMain.SubTotal()), e, new Font("Arial", 14, FontStyle.Bold), l_y, 3); l_y += posPrinter.GetHeightPrinterLine()/2; return l_y; }
public IEnumerable<OrderDateModel> LoadOrder(OrderDateModel idOrder) { throw new NotImplementedException(); }
public int DeleteJoinTableAll(OrderDateModel itemOrder) { int result = 0; try { ORDER_DATE orderDateTemp = new ORDER_DATE(); List<ORDER_DETAIL_DATE> lstOrderDetaiDate = new List<ORDER_DETAIL_DATE>(); List<ORDER_DETAIL_MODIFIRE_DATE> lstOrderDetailModifire = new List<ORDER_DETAIL_MODIFIRE_DATE>(); OrderDateModel orderDateMoldeTemp = new OrderDateModel(); orderDateMoldeTemp = GetOrderByTable(itemOrder.FloorID, 0); if (itemOrder.ListOrderDetail.Count > 0) { using (var transaciton = _context.Database.BeginTransaction()) { orderDateTemp = CopyOrder(itemOrder); //_context.Entry(orderDateTemp).State = System.Data.Entity.EntityState.Modified; _context.Database.ExecuteSqlCommand("delete from ORDER_DATE where OrderID='" + itemOrder.OrderID + "'"); lstOrderDetaiDate = CopyOrderDetailDate(itemOrder); foreach (ORDER_DETAIL_DATE item in lstOrderDetaiDate) { _context.Database.ExecuteSqlCommand("delete from ORDER_DETAIL_DATE where OrderDetailID='" + item.OrderDetailID + "'"); } lstOrderDetailModifire = CopyOrderMidifireDate(itemOrder); foreach (ORDER_DETAIL_MODIFIRE_DATE item in lstOrderDetailModifire) { //_context.Entry(item).State = System.Data.Entity.EntityState.Deleted; // _context.ORDER_DETAIL_MODIFIRE_DATE.Remove(item); _context.Database.ExecuteSqlCommand("delete ORDER_DETAIL_MODIFIRE_DATE where OrderModifireID='" + item.OrderModifireID + "'"); } _context.SaveChanges(); transaciton.Commit(); result = 1; } } } catch (Exception ex) { LogPOS.WriteLog("OrderService::::::::::::::::::::DeleteJoinTableAll::::::::::::::" + ex.Message); } return result; }
public int InsertOrder(OrderDateModel itemOrder) { int flag = 0; try { ORDER_DATE orderDateTemp = new ORDER_DATE(); List<ORDER_DETAIL_DATE> lstOrderDetaiDate = new List<ORDER_DETAIL_DATE>(); List<ORDER_DETAIL_MODIFIRE_DATE> lstOrderDetailModifire = new List<ORDER_DETAIL_MODIFIRE_DATE>(); List<SEAT> lstSeat = new List<SEAT>(); // ORDER_DETAIL_DATE orderDetailTemp = new ORDER_DETAIL_DATE(); //ORDER_DETAIL_MODIFIRE_DATE orderDetailModofireDate = new ORDER_DETAIL_MODIFIRE_DATE(); OrderDateModel orderDateMoldeTemp = new OrderDateModel(); orderDateMoldeTemp= GetOrderByTable(itemOrder.FloorID,0); if (orderDateMoldeTemp.ListOrderDetail.Count > 0) { using (var transaciton = _context.Database.BeginTransaction()) { orderDateTemp = CopyOrder(itemOrder); //_context.Entry(orderDateTemp).State = System.Data.Entity.EntityState.Modified; _context.Database.ExecuteSqlCommand("update ORDER_DATE set TotalAmount='" + orderDateTemp.TotalAmount + "',Seat='"+ itemOrder.Seat+"' where OrderID='"+ orderDateTemp.OrderID+"'"); lstSeat = CopySeat(orderDateMoldeTemp); foreach (SEAT item in lstSeat) { _context.Database.ExecuteSqlCommand("delete from SEAT where ID='" + item.ID + "'"); } lstSeat = CopySeat(itemOrder); foreach (SEAT item in lstSeat) { item.OrderNumber = itemOrder.OrderNumber; _context.Entry(item).State = System.Data.Entity.EntityState.Added; _context.SaveChanges(); } lstOrderDetaiDate = CopyOrderDetailDate(orderDateMoldeTemp); foreach (ORDER_DETAIL_DATE item in lstOrderDetaiDate) { _context.Database.ExecuteSqlCommand("delete from ORDER_DETAIL_DATE where OrderDetailID='" + item.OrderDetailID + "'"); } lstOrderDetaiDate = CopyOrderDetailDate(itemOrder); foreach (ORDER_DETAIL_DATE item in lstOrderDetaiDate) { // _context.Entry(item).State = System.Data.Entity.EntityState.Added;; _context.Database.ExecuteSqlCommand("insert into ORDER_DETAIL_DATE(OrderID,OrderNumber,ProductID,KeyItem,Status,Price,Qty,Total,Seat,DynId,PrintType)values" + "('" + item.OrderID + "', '"+ item.OrderNumber+"', '" + item.ProductID + "','" + item.KeyItem + "','" + item.Status + "','" + item.Price + "','" + item.Qty + "','" + item.Total + "','" + item.Seat + "','"+item.DynId+"','"+ item.PrintType+"')"); } lstOrderDetailModifire = CopyOrderMidifireDate(orderDateMoldeTemp); foreach (ORDER_DETAIL_MODIFIRE_DATE item in lstOrderDetailModifire) { //_context.Entry(item).State = System.Data.Entity.EntityState.Deleted; // _context.ORDER_DETAIL_MODIFIRE_DATE.Remove(item); _context.Database.ExecuteSqlCommand("delete ORDER_DETAIL_MODIFIRE_DATE where OrderModifireID='" + item.OrderModifireID + "'"); } lstOrderDetailModifire = CopyOrderMidifireDate(itemOrder); foreach (ORDER_DETAIL_MODIFIRE_DATE item in lstOrderDetailModifire) { // _context.Entry(item).State = System.Data.Entity.EntityState.Added; _context.Database.ExecuteSqlCommand("insert into ORDER_DETAIL_MODIFIRE_DATE (OrderDetailID,OrderID,OrderNumber,ProductID,KeyModi,ModifireID,Status,Price,Qty,Total,Seat,DynID)values" + "('" + item.OrderDetailID + "','" + item.OrderID + "','" + item.OrderNumber + "', '" + item.ProductID + "','" + item.KeyModi + "','" + item.ModifireID + "','" + item.Status + "','" + item.Price + "','" + item.Qty + "','" + item.Total + "','" + item.Seat + "','" + item.DynId + "')"); } transaciton.Commit(); flag = 1; } } else { using (var Tranx = _context.Database.BeginTransaction()) { orderDateTemp = CopyOrder(itemOrder); _context.Entry(orderDateTemp).State = System.Data.Entity.EntityState.Added; _context.SaveChanges(); int i = orderDateTemp.OrderID; string OrderNum = i + "" + DateTime.Now.Date.Year + "" + DateTime.Now.Date.Month + "" + DateTime.Now.Date.Day; _context.Database.ExecuteSqlCommand("update ORDER_DATE set OrderNumber='" + OrderNum + "' where OrderID='"+ i+"'"); lstSeat = CopySeat(itemOrder); foreach (SEAT item in lstSeat) { item.OrderNumber = Convert.ToInt32(OrderNum); _context.Entry(item).State = System.Data.Entity.EntityState.Added; } lstOrderDetaiDate = CopyOrderDetailDate(itemOrder); foreach (ORDER_DETAIL_DATE item in lstOrderDetaiDate) { item.OrderID = i; item.OrderNumber = Convert.ToInt32(OrderNum); _context.Entry(item).State = System.Data.Entity.EntityState.Added; } lstOrderDetailModifire = CopyOrderMidifireDate(itemOrder); foreach (ORDER_DETAIL_MODIFIRE_DATE item in lstOrderDetailModifire) { item.OrderID = i; item.OrderNumber = Convert.ToInt32(OrderNum); _context.Entry(item).State = System.Data.Entity.EntityState.Added; } _context.SaveChanges(); flag = 1; Tranx.Commit(); } } } catch (Exception ex) { LogPOS.WriteLog("InsertOrder::::::::::::::::::::::::::::::::::" + ex.Message); } return flag; }
public int CheckOrderComplete(OrderDateModel idOrder) { throw new NotImplementedException(); }
public OrderDateModel GetOrderByTKA(string tkaID, string ClientID) { OrderDateModel OrderTKA = new OrderDateModel(); try { var dataOrder = _context.ORDER_DATE.Where(x => x.FloorID == tkaID && x.Status != 1 && x.CreateDate.Year == DateTime.Now.Year && x.CreateDate.Month == DateTime.Now.Month && x.CreateDate.Day == DateTime.Now.Day).SingleOrDefault(); if (dataOrder != null) { OrderTKA.Seat = dataOrder.Seat ?? 0; OrderTKA.FloorID = dataOrder.FloorID; OrderTKA.OrderID = dataOrder.OrderID; OrderTKA.TotalAmount = dataOrder.TotalAmount; OrderTKA.ShiftID = dataOrder.ShiftID ?? 0; OrderTKA.CreateBy = dataOrder.CreateBy; OrderTKA.UpdateBy = dataOrder.UpdateBy; var data = _context.ORDER_DATE.Join(_context.ORDER_DETAIL_DATE, order => order.OrderID, item => item.OrderID, (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.FloorID == dataOrder.FloorID && x.pro.order.OrderID == x.pro.item.OrderID && x.pro.order.OrderID == dataOrder.OrderID && x.pro.item.OrderID == dataOrder.OrderID && x.pro.item.ProductID == x.c.ProductID) .Select(x => new OrderDetailModel() { ProductID = x.pro.item.ProductID, Price = x.pro.item.Price, Qty = x.pro.item.Qty, Total = x.pro.item.Qty * x.pro.item.Price, OrderID = x.pro.item.OrderID, 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, }); var openitems = _context.ORDER_DETAIL_DATE.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.OrderID == dataOrder.OrderID) .Select(a => new OrderDetailModel() { ProductName = a.openitem.ItemNameShort, Qty = a.x.Qty, Price = a.openitem.UnitPrice, ProductID = a.x.ProductID, Total = a.x.Qty * a.x.Price, OrderID = a.x.OrderID, Satust = a.x.Status, KeyItem = a.x.KeyItem ?? 0, Seat = a.x.Seat ?? 0, DynID = a.x.DynId ?? 0, OrderDetailID = a.x.OrderDetailID }); foreach (OrderDetailModel openItem in openitems) { OrderTKA.addItemToList(openItem); } foreach (OrderDetailModel item in data) { int keyItemOld = item.KeyItem; var dataOrderModifire = _context.ORDER_DETAIL_DATE.Join(_context.ORDER_DETAIL_MODIFIRE_DATE, 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.OrderID == item.OrderID && x.modi.modifire.OrderID == item.OrderID && 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, 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, OrderID = x.modi.pro.OrderID, DynID = x.modi.modifire.DynId ?? 0 }); var print = _context.PRINTE_JOB_DETAIL.Where(x => x.ProductID == item.ProductID) .Select(x => new PrinteJobDetailModel { ProductID = x.ProductID, PrinterID = x.PrinterID } ); foreach (PrinteJobDetailModel p in print) { item.ListPrintJob.Add(p); } OrderTKA.addItemToList(item); foreach (OrderDetailModifireModel itemmodifire in dataOrderModifire) { OrderTKA.addModifierToList(itemmodifire, item.KeyItem); } var openItemModiier = _context.ORDER_DETAIL_MODIFIRE_DATE.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.OrderID == item.OrderID && x.modi.KeyModi == keyItemOld) .Select(x => new OrderDetailModifireModel() { ModifireID = x.modi.ModifireID, 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, OrderID = x.modi.OrderID ?? 0, DynID = x.modi.DynId ?? 0 }); foreach (OrderDetailModifireModel Openitem in openItemModiier) { OrderTKA.addModifierToList(Openitem, item.KeyItem); } } } } catch (Exception ex) { } return OrderTKA; }
public OrderDateModel GetOrderByTable(string idTable, int idOrder) { OrderDateModel OrderMain = new OrderDateModel(); var dataOrder = _context.ORDER_DATE.Where(x => x.FloorID == idTable && x.Status != 1 && x.Status != 4 && x.CreateDate.Year == DateTime.Now.Year && x.CreateDate.Month == DateTime.Now.Month && x.CreateDate.Day == DateTime.Now.Day).SingleOrDefault(); if (dataOrder != null) { OrderMain.Seat = dataOrder.Seat ?? 0; OrderMain.FloorID = dataOrder.FloorID; OrderMain.OrderID = dataOrder.OrderID; OrderMain.TotalAmount = dataOrder.TotalAmount; OrderMain.ShiftID = dataOrder.ShiftID ?? 0; OrderMain.CreateBy = dataOrder.CreateBy; OrderMain.UpdateBy = dataOrder.UpdateBy; OrderMain.Status = dataOrder.Status; OrderMain.OrderNumber = dataOrder.OrderNumber??0; OrderMain.CreateDate = dataOrder.CreateDate; OrderMain.Note = dataOrder.Note; OrderMain.PrinterNote = dataOrder.PrinterNote ?? 0; var seat = _context.ORDER_DATE.Join(_context.SEATs, order => order.OrderNumber, seatmap => seatmap.OrderNumber, (order, seatmap) => new { order, seatmap }) .Where(x => x.order.OrderNumber == dataOrder.OrderNumber && x.seatmap.OrderNumber == dataOrder.OrderNumber && x.order.OrderNumber == x.seatmap.OrderNumber) .Select(x => new SeatModel { Seat = x.seatmap.Seat1, OrderNumber = x.seatmap.OrderNumber, ID = x.seatmap.ID } ); foreach(SeatModel item in seat) { OrderMain.ListSeatOfOrder.Add(item); } var data = _context.ORDER_DATE.Join(_context.ORDER_DETAIL_DATE, order => order.OrderID, item => item.OrderID, (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.FloorID == dataOrder.FloorID && x.pro.order.OrderID == x.pro.item.OrderID && x.pro.order.OrderID == dataOrder.OrderID && x.pro.item.OrderID == dataOrder.OrderID && x.pro.item.ProductID==x.c.ProductID) .OrderBy(x=>x.pro.item.OrderDetailID) .Select(x => new OrderDetailModel() { ProductID = x.pro.item.ProductID, Price = x.pro.item.Price, Qty = x.pro.item.Qty, Total = x.pro.item.Qty * x.pro.item.Price, OrderID = x.pro.item.OrderID, 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, Printer = x.pro.item.PrintType??0, OrderNumber =x.pro.item.OrderNumber??0 }); var openitems = _context.ORDER_DETAIL_DATE.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.OrderID==dataOrder.OrderID) .Select(a => new OrderDetailModel() { ProductName = a.openitem.ItemNameShort, Qty = a.x.Qty, Price = a.openitem.UnitPrice, ProductID = a.x.ProductID, Total = a.x.Qty * a.x.Price, OrderID = a.x.OrderID, Satust = a.x.Status, KeyItem = a.x.KeyItem ?? 0, Seat = a.x.Seat ?? 0, DynID = a.x.DynId ?? 0, OrderDetailID = a.x.OrderDetailID, OrderNumber = a.x.OrderNumber??0, Printer = a.openitem.PrinterID??0 }); foreach (OrderDetailModel openItem in openitems) { PrinteJobDetailModel pritn = new PrinteJobDetailModel(); pritn.PrinterID = openItem.Printer; openItem.ListPrintJob.Add(pritn); OrderMain.addItemToList(openItem); } foreach(OrderDetailModel item in data) { int keyItemOld = item.KeyItem; var print = _context.PRINTE_JOB_DETAIL.Where(x => x.ProductID == item.ProductID) .Select(x => new PrinteJobDetailModel { ProductID = x.ProductID, PrinterID = x.PrinterID } ); foreach (PrinteJobDetailModel p in print) { item.ListPrintJob.Add(p); } OrderMain.addItemToList(item); var dataOrderModifire = _context.ORDER_DETAIL_DATE.Join(_context.ORDER_DETAIL_MODIFIRE_DATE, 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.OrderID == item.OrderID && x.modi.modifire.OrderID == item.OrderID && 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, 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, OrderID = x.modi.pro.OrderID, DynID = x.modi.modifire.DynId ?? 0, OrderNumber = x.modi.modifire.OrderNumber??0 }); foreach (OrderDetailModifireModel itemmodifire in dataOrderModifire) { OrderMain.addModifierToList(itemmodifire, item.KeyItem); } var openItemModiier = _context.ORDER_DETAIL_MODIFIRE_DATE.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.OrderID == item.OrderID && x.modi.KeyModi == keyItemOld ) .Select(x=>new OrderDetailModifireModel() { ModifireID = x.modi.ModifireID, 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, OrderID = x.modi.OrderID??0, DynID = x.modi.DynId??0, OrderNumber = x.modi.OrderNumber??0 }); foreach (OrderDetailModifireModel Openitem in openItemModiier) { OrderMain.addModifierToList(Openitem, item.KeyItem); } } } return OrderMain; }
public void LoadOrderTKA(string TableID, int ClientID) { indexControl = 1; try { OrderMain = new OrderDateModel(); OrderMain = OrderService.GetOrderByTKA(TableID, ""); OrderMain.isTKA = 1; lblSubtotal.Text = money.Format2(Convert.ToDouble(OrderMain.TotalAmount)); if (OrderMain.Seat > 0) { OrderMain.IsLoadFromData = true; lblSeat.Text = OrderMain.Seat.ToString(); for (int seat = 1; seat <= OrderMain.Seat; seat++) { UCSeat ucSeat = new UCSeat(); ucSeat.lblSeat.Text = "Seat " + seat.ToString(); ucSeat.Click += ucSeat_Click; flpOrder.Controls.Add(ucSeat); indexControl = flpOrder.Controls.Count; if (OrderMain.ListOrderDetail.Count > 0) { for (int i = 0; i < OrderMain.ListOrderDetail.Count; i++) { if (OrderMain.ListOrderDetail[i].Seat == seat) { addOrder(OrderMain.ListOrderDetail[i]); indexControl++; for (int j = 0; j < OrderMain.ListOrderDetail[i].ListOrderDetailModifire.Count; j++) { UCItemModifierOfMenu uc = new UCItemModifierOfMenu(); uc.Tag = OrderMain.ListOrderDetail[i].ListOrderDetailModifire[j]; uc.Click += ucItemModifierOfMenu_Click; addModifreToOrder(uc, OrderMain.ListOrderDetail[i].ListOrderDetailModifire[j]); indexControl++; } } } } else { OrderMain.FloorID = TableID + "" + (OrderService.CountOrder() + 1); if (ClientID > 0) OrderMain.ClientID = ClientID; else OrderMain.ClientID = 0; OrderMain.ShiftID = UserLoginModel.ShiffID; OrderMain.CreateBy = UserLoginModel.UserLoginInfo.StaffID; OrderMain.UpdateBy = UserLoginModel.UserLoginInfo.StaffID; int OrderID = OrderService.CountOrder() + 1; OrderMain.OrderID = OrderID; } } } else { if (OrderMain.ListOrderDetail.Count > 0) { OrderMain.IsLoadFromData = true; for (int i = 0; i < OrderMain.ListOrderDetail.Count; i++) { addOrder(OrderMain.ListOrderDetail[i]); indexControl++; for (int j = 0; j < OrderMain.ListOrderDetail[i].ListOrderDetailModifire.Count; j++) { UCItemModifierOfMenu uc = new UCItemModifierOfMenu(); uc.Tag = OrderMain.ListOrderDetail[i].ListOrderDetailModifire[j]; uc.Click += ucItemModifierOfMenu_Click; addModifreToOrder(uc, OrderMain.ListOrderDetail[i].ListOrderDetailModifire[j]); indexControl++; } } } else { OrderMain.FloorID = TableID + "" + (OrderService.CountOrder() + 1); OrderMain.ClientID = ClientID; OrderMain.ShiftID = UserLoginModel.ShiffID; OrderMain.CreateBy = UserLoginModel.UserLoginInfo.StaffID; OrderMain.UpdateBy = UserLoginModel.UserLoginInfo.StaffID; int OrderID = OrderService.CountOrder() + 1; OrderMain.OrderID = OrderID; } } } catch (Exception ex) { LogPOS.WriteLog("LoadOrder:::::::::::::::::::::::::::::::::" + ex.Message); } }
private void btnPayMent_Click(object sender, EventArgs e) { //flags = WinAPI.AW_ACTIVATE | WinAPI.AW_HOR_POSITIVE; try { if (OrderMain.Status == 1) OrderCompleted(); else { if (OrderMain.ListOrderDetail.Count > 0) { frmse.BindOrder(OrderMain); frmPayMent frm = new frmPayMent(OrderMain, 1000, 131073); if (frmOpacity.ShowDialog(this, frm) == System.Windows.Forms.DialogResult.OK) { GetListPaymentPrinter(); int result = 0; OrderMain = frm.OrderMain; OrderMain.PrintType = 2; result = InvoiceService.InsertInvoice(OrderMain); if (result == 1) { if (OrderMain.isNoPrintBill == 1) { if (OrderMain.isTKA == 1) { this.Close(); frmTakeAway frmTKA = new frmTakeAway(); frmTKA.Show(); } else { CallBackStatusOrderCancel(); this.Close(); } } else { PrinterServer printServer = new PrinterServer(); printServer.PrintData(OrderMain, PrintData); if (OrderMain.isTKA == 1) { this.Close(); frmTakeAway frmTKA = new frmTakeAway(); frmTKA.Show(); } else { frmse.fullScreen(); CallBackStatusOrderCancel(); this.Close(); } } foreach(PrinterModel item in PrintData) { if (item.PrinterType == 4) Class.RawPrinterHelper.openCashDrawer(item.PrinterName); } } } } else { frmMessager frm = new frmMessager("PayMent", "Order empty"); frmOpacity.ShowDialog(this, frm); } } } catch (Exception ex) { LogPOS.WriteLog("frmOrder:::::::::::::::::::::::btnPayMent_Click::::::::::::::::;" + ex.Message); } }
public int VoidItemHistory(OrderDateModel OrderVoid) { int result = 0; try { foreach (OrderDetailModel item in OrderVoid.ListOrderDetail) { if (item.ChangeStatus == 2) { VOID_ITEM_HISTORY voidItem = new VOID_ITEM_HISTORY(); voidItem.OrderID = OrderVoid.OrderID; voidItem.OrderNumber = OrderVoid.OrderNumber; voidItem.FloorID = OrderVoid.FloorID; voidItem.ShiftID = OrderVoid.ShiftID; voidItem.ProductID = item.ProductID; voidItem.Total =Convert.ToInt32(item.Total); voidItem.Qty = Convert.ToInt32(item.Qty); voidItem.CreateBy = 0; voidItem.CreateDate = DateTime.Now; voidItem.UpdateBy = 0; voidItem.UpdateDate = DateTime.Now; _context.Entry(voidItem).State = System.Data.Entity.EntityState.Added; _context.SaveChanges(); result = 1; } } } catch (Exception ex) { LogPOS.WriteLog("OrderService::::::::::::::::::::VoidItemHistory::::::::::::::" + ex.Message); } return result; }
private void btnLeftAll_Click(object sender, EventArgs e) { try { flpOldTable.Controls.Clear(); LoadOrder(lblNoTable.Text, 0,flpNewTable); OrderSlpitNew = OrderMain; OrderSlpitNew.FloorID = lblNewTable.Text; OrderMain.isTransferTableAll = 1; tableOld = this.lblNoTable.Text; } catch (Exception ex) { LogPOS.WriteLog("frmTransferTable:::::::::::::::::::::::::ebtnLeftAll_Click:::::::::::::::" + ex.Message); } }
private void CallBackOrder(OrderDateModel orderCallBack) { //UCTable uctable = (UCTable)flowLayoutPanel1.Controls[Convert.ToInt32(orderCallBack.FloorID)-1]; //uctable.BackColor = Color.FromArgb(0, 102, 204); //uctable.ForeColor = Color.White; //uctable.lbTime.Text = orderCallBack.CreateDate.ToString(); //uctable.Tag = orderCallBack; //SetText("$" + monetFormat.Format(Convert.ToDouble(orderCallBack.SubTotal())), uctable.lbSubTotal); CheckStatusTable(); }
public void LoadOrder(string TableID, int orderID,FlowLayoutPanel flp) { int indexControl = 1; try { OrderMain = OrderService.GetOrderByTable(TableID, 0); if (OrderMain.ListSeatOfOrder.Count>0) { OrderMain.IsLoadFromData = true; //lblSeat.Text = OrderMain.Seat.ToString(); foreach (SeatModel seat in OrderMain.ListSeatOfOrder) { UCSeat ucSeat = new UCSeat(); ucSeat.lblSeat.Text = "Seat " + seat.Seat.ToString(); // ucSeat.Click += ucSeat_Click; flpOldTable.Controls.Add(ucSeat); indexControl = flpOldTable.Controls.Count; if (OrderMain.ListOrderDetail.Count > 0) { for (int i = 0; i < OrderMain.ListOrderDetail.Count; i++) { if (OrderMain.ListOrderDetail[i].Seat == seat.Seat) { addOrder(OrderMain.ListOrderDetail[i],flp); indexControl++; for (int j = 0; j < OrderMain.ListOrderDetail[i].ListOrderDetailModifire.Count; j++) { UCItemModifierOfMenu uc = new UCItemModifierOfMenu(); uc.Tag = OrderMain.ListOrderDetail[i].ListOrderDetailModifire[j]; //uc.Click += ucItemModifierOfMenu_Click; addModifreToOrder(uc, OrderMain.ListOrderDetail[i].ListOrderDetailModifire[j],flp); indexControl++; } } } } else { OrderMain.FloorID = TableID; int OrderID = OrderService.CountOrder() + 1; OrderMain.OrderID = OrderID; } } } else { if (OrderMain.ListOrderDetail.Count > 0) { OrderMain.IsLoadFromData = true; for (int i = 0; i < OrderMain.ListOrderDetail.Count; i++) { addOrder(OrderMain.ListOrderDetail[i],flp); indexControl++; for (int j = 0; j < OrderMain.ListOrderDetail[i].ListOrderDetailModifire.Count; j++) { UCItemModifierOfMenu uc = new UCItemModifierOfMenu(); uc.Tag = OrderMain.ListOrderDetail[i].ListOrderDetailModifire[j]; //uc.Click += ucItemModifierOfMenu_Click; addModifreToOrder(uc, OrderMain.ListOrderDetail[i].ListOrderDetailModifire[j],flp); indexControl++; } } } else { OrderMain.FloorID = TableID; int OrderID = OrderService.CountOrder() + 1; OrderMain.OrderID = OrderID; } } } catch (Exception ex) { LogPOS.WriteLog("frmTranferTable:::::::::::::::::::LoadOrder:::::::::::::::::::::::::::::::::" + ex.Message); } }
private void CallBackOrderCancel(OrderDateModel orderCallBack) { CheckStatusTable(); }
private ACC_PAYMENT CopyAcc(OrderDateModel Order) { ACC_PAYMENT acc = new ACC_PAYMENT(); acc.SubTotal = Convert.ToInt32(Order.TotalAmount); acc.CusNo = Order.CusItem.ClientID; acc.InvoiceID = Order.InvoiceID; acc.InvoiceNumber = Order.InvoiceNumber; acc.Cash = 0; acc.Card = 0; acc.IsCredit = 1; acc.IsDebit = 0; acc.CreateBy = Order.CreateBy ?? 0; acc.CreateDate = DateTime.Now; acc.UpdateBy = Order.UpdateBy ?? 0; acc.UpdateDate = DateTime.Now; return acc; }
public frmFloor(OrderDateModel _orderMain) { InitializeComponent(); orderMain = _orderMain; }
private List<INVOICE_BY_CARD> CopyInvoiceByCard(OrderDateModel Order) { List<INVOICE_BY_CARD> lst = new List<INVOICE_BY_CARD>(); lst.Clear(); for (int i = 0; i < Order.ListInvoiceByCard.Count; i++) { INVOICE_BY_CARD item = new INVOICE_BY_CARD(); item.InvoiceByCardID =Convert.ToInt32(CustomerInvoiceByCardID()); item.CardID = Order.ListInvoiceByCard[i].CardID; item.Total = Order.ListInvoiceByCard[i].Total; item.CreateBy = Order.ListInvoiceByCard[i].CreateBy ?? 0; item.CreateDate = DateTime.Now; item.UpdateBy = Order.ListInvoiceByCard[i].UpdateBy ?? 0; item.UpdateDate = DateTime.Now; item.Note = Order.ListInvoiceByCard[i].Note ?? ""; lst.Add(item); } return lst; }
public void LoadOrder(string TableID, int orderID) { indexControl = 1; try { OrderMain = new OrderDateModel(); OrderMain = OrderService.GetOrderByTable(TableID, 0); OrderMain.ListOrderDetail = OrderMain.ListOrderDetail.OrderBy(x => x.OrderDetailID).ToList(); if (OrderMain.TotalAmount > 0) { lblSubtotal.Text = money.Format2(Convert.ToDouble(OrderMain.TotalAmount)); } else { lblSubtotal.Text = "0.0"; } if (OrderMain.ListSeatOfOrder.Count > 0) { OrderMain.IsLoadFromData = true; lblSeat.Text = OrderMain.Seat.ToString(); lblStatus.Text = "OLD"; Boolean addSet; foreach (SeatModel seat in OrderMain.ListSeatOfOrder) { addSet = true; if (OrderMain.ListOrderDetail.Count > 0) { for (int i = 0; i < OrderMain.ListOrderDetail.Count; i++) { if (OrderMain.ListOrderDetail[i].Seat == seat.Seat) { if (addSet) { UCSeat ucSeat = new UCSeat(); ucSeat.lblSeat.Text = "Seat " + seat.Seat.ToString(); ucSeat.Tag = seat.Seat; ucSeat.Click += ucSeat_Click; flpOrder.Controls.Add(ucSeat); indexControl = flpOrder.Controls.Count; addSet = false; } addOrder(OrderMain.ListOrderDetail[i]); indexControl++; for (int j = 0; j < OrderMain.ListOrderDetail[i].ListOrderDetailModifire.Count; j++) { UCItemModifierOfMenu uc = new UCItemModifierOfMenu(); uc.Tag = OrderMain.ListOrderDetail[i].ListOrderDetailModifire[j]; uc.Click += ucItemModifierOfMenu_Click; addModifreToOrder(uc, OrderMain.ListOrderDetail[i].ListOrderDetailModifire[j]); indexControl++; } } else { if (OrderMain.ListOrderDetail[i].Seat == 0) { addOrder(OrderMain.ListOrderDetail[i]); indexControl++; for (int j = 0; j < OrderMain.ListOrderDetail[i].ListOrderDetailModifire.Count; j++) { UCItemModifierOfMenu uc = new UCItemModifierOfMenu(); uc.Tag = OrderMain.ListOrderDetail[i].ListOrderDetailModifire[j]; uc.Click += ucItemModifierOfMenu_Click; addModifreToOrder(uc, OrderMain.ListOrderDetail[i].ListOrderDetailModifire[j]); indexControl++; } } } } } else { OrderMain.FloorID = TableID; OrderMain.ShiftID = UserLoginModel.ShiffID; OrderMain.CreateBy = UserLoginModel.UserLoginInfo.StaffID; OrderMain.UpdateBy = UserLoginModel.UserLoginInfo.StaffID; int OrderID = OrderService.CountOrder() + 1; OrderMain.OrderID = OrderID; lblStatus.Text = "NEW"; } } } else { if (OrderMain.ListOrderDetail.Count > 0) { OrderMain.IsLoadFromData = true; lblStatus.Text = "OLD"; for (int i = 0; i < OrderMain.ListOrderDetail.Count; i++) { addOrder(OrderMain.ListOrderDetail[i]); indexControl++; for (int j = 0; j < OrderMain.ListOrderDetail[i].ListOrderDetailModifire.Count; j++) { UCItemModifierOfMenu uc = new UCItemModifierOfMenu(); uc.Tag = OrderMain.ListOrderDetail[i].ListOrderDetailModifire[j]; uc.Click += ucItemModifierOfMenu_Click; addModifreToOrder(uc, OrderMain.ListOrderDetail[i].ListOrderDetailModifire[j]); indexControl++; } } } else { OrderMain.FloorID = TableID; OrderMain.ShiftID = UserLoginModel.ShiffID; OrderMain.CreateBy = UserLoginModel.UserLoginInfo.StaffID; OrderMain.UpdateBy = UserLoginModel.UserLoginInfo.StaffID; int OrderID = OrderService.CountOrder() + 1; OrderMain.OrderID = OrderID; lblStatus.Text = "NEW"; } } } catch (Exception ex) { LogPOS.WriteLog("frmOrder:::::::::::::::::::::::LoadOrder:::::::::::::::::::::::::::::::::" + ex.Message); } }
private List<INVOICE_DETAIL_MODIFIRE> CopyInvoiceMidifire(OrderDateModel itemOrder) { List<INVOICE_DETAIL_MODIFIRE> lstOrderModifreDate = new List<INVOICE_DETAIL_MODIFIRE>(); lstOrderModifreDate.Clear(); try { for (int i = 0; i < itemOrder.ListOrderDetail.Count; i++) { for (int j = 0; j < itemOrder.ListOrderDetail[i].ListOrderDetailModifire.Count; j++) { INVOICE_DETAIL_MODIFIRE orderDetailModifire = new INVOICE_DETAIL_MODIFIRE(); orderDetailModifire.ModifireID = itemOrder.ListOrderDetail[i].ListOrderDetailModifire[j].ModifireID; orderDetailModifire.OrderModifireID = itemOrder.ListOrderDetail[i].ListOrderDetailModifire[j].OrderModifireID; orderDetailModifire.ProductID = itemOrder.ListOrderDetail[i].ListOrderDetailModifire[j].ProductID; orderDetailModifire.KeyModi = itemOrder.ListOrderDetail[i].ListOrderDetailModifire[j].KeyModi; orderDetailModifire.Price = itemOrder.ListOrderDetail[i].ListOrderDetailModifire[j].Price; orderDetailModifire.Qty = itemOrder.ListOrderDetail[i].ListOrderDetailModifire[j].Qty; orderDetailModifire.Total = itemOrder.ListOrderDetail[i].ListOrderDetailModifire[j].Total; orderDetailModifire.Status = itemOrder.ListOrderDetail[i].ListOrderDetailModifire[j].Satust; orderDetailModifire.Seat = itemOrder.ListOrderDetail[i].ListOrderDetailModifire[j].Seat; orderDetailModifire.DynId = itemOrder.ListOrderDetail[i].ListOrderDetailModifire[j].DynID; orderDetailModifire.CreateBy = itemOrder.ListOrderDetail[i].ListOrderDetailModifire[j].CreateBy ?? 0; orderDetailModifire.CreateDate = itemOrder.ListOrderDetail[i].ListOrderDetailModifire[j].CreateDate ?? DateTime.Now; orderDetailModifire.UpdateBy = itemOrder.ListOrderDetail[i].ListOrderDetailModifire[j].UpdateBy ?? 0; orderDetailModifire.UpdateDate = itemOrder.ListOrderDetail[i].ListOrderDetailModifire[j].UpdateDate ?? DateTime.Now; lstOrderModifreDate.Add(orderDetailModifire); } } } catch (Exception ex) { LogPOS.WriteLog("CopyOrderMidifireDate:::::::::::::::::::::::::::::::::" + ex.Message); } return lstOrderModifreDate; }
private void ModifireItemInOrder(OrderDateModel Order, OrderDetailModel Item) { for (int i = 0; i < Order.ListOrderDetail.Count; i++) { if (Order.ListOrderDetail[i].KeyItem == Item.KeyItem) { Order.ListOrderDetail[i].Price = Item.Price; } } }
public int InsertInvoice(OrderDateModel Order) { int result = 0; int InvoiceID; INVOICE invoice = new INVOICE(); List<INVOICE_DETAIL> invoiceDEtail = new List<INVOICE_DETAIL>(); List<INVOICE_DETAIL_MODIFIRE> invoiceDetailModifier = new List<INVOICE_DETAIL_MODIFIRE>(); List<PAYMENT_INVOICE_HISTORY> PaymentHistory = new List<PAYMENT_INVOICE_HISTORY>(); List<INVOICE_BY_CARD> InvoiceByCard = new List<INVOICE_BY_CARD>(); ACC_PAYMENT Acc = new ACC_PAYMENT(); using (var trans = _context.Database.BeginTransaction()) { _context.Database.ExecuteSqlCommand("update ORDER_DATE set Status=1 where OrderID='" + Order.OrderID + "'"); invoice = CopyInvoice(Order); _context.Entry(invoice).State = System.Data.Entity.EntityState.Added; _context.SaveChanges(); InvoiceID = invoice.InvoiceID; string InvNum = InvoiceID + "" + DateTime.Now.Date.Year + "" + DateTime.Now.Date.Month + "" + DateTime.Now.Date.Day; _context.Database.ExecuteSqlCommand("update invoice set InvoiceNumber='" + InvNum + "'where InvoiceID='" + InvoiceID + "'"); //Update balance for customer _context.Database.ExecuteSqlCommand("update client set balance=balance+'" + -Convert.ToInt32(Order.Payment) + "' where ClientID='" + Order.CusItem.ClientID + "'"); Acc = CopyAcc(Order); Acc.InvoiceID = InvoiceID; Acc.InvoiceNumber =Convert.ToInt32(InvNum); //_context.Entry(Acc).State = System.Data.Entity.EntityState.Added; string sql = "insert into acc_payment(CusNo,SubTotal,InvoiceID,InvoiceNumber,Cash,Card,IsCredit,IsDebit,CreateDate,CreateBy,UpdateDate,UpdateBy)values(" + "'" + Order.CusItem.ClientID + "','" + Convert.ToInt32(Order.Payment) + "','" + InvoiceID + "','" + Convert.ToInt32(InvNum) + "',0,0,1,0,'" + DateTime.Now + "','" + Order.ShiftID + "','" + DateTime.Now + "','" + Order.ShiftID + "')"; _context.Database.ExecuteSqlCommand("insert into acc_payment(CusNo,SubTotal,InvoiceID,InvoiceNumber,Cash,Card,IsCredit,IsDebit,CreateDate,CreateBy,UpdateDate,UpdateBy)values(" + "'" + Order.CusItem.ClientID + "','" +Convert.ToInt32(Order.Payment) + "','" + InvoiceID + "','" +Convert.ToInt32(InvNum) + "',0,0,1,0,'" + DateTime.Now + "','" + Order.ShiftID + "','" + DateTime.Now + "','" + Order.ShiftID + "')"); // invoiceDEtail = CopyInvoicedetail(Order); foreach (INVOICE_DETAIL item in invoiceDEtail) { item.InvoiceID = InvoiceID; item.InvoiceNumber = Convert.ToInt32(InvNum); _context.Entry(item).State = System.Data.Entity.EntityState.Added; } invoiceDetailModifier = CopyInvoiceMidifire(Order); foreach (INVOICE_DETAIL_MODIFIRE item in invoiceDetailModifier) { item.InvoiceID = InvoiceID; item.InvoiceNumber = Convert.ToInt32(InvNum); _context.Entry(item).State = System.Data.Entity.EntityState.Added; } PaymentHistory = CopyListPayment(Order); foreach (PAYMENT_INVOICE_HISTORY item in PaymentHistory) { item.InvoiceID = InvoiceID; item.InvoiceNumber = Convert.ToInt32(InvNum); _context.Entry(item).State = System.Data.Entity.EntityState.Added; } InvoiceByCard = CopyInvoiceByCard(Order); foreach(INVOICE_BY_CARD item in InvoiceByCard) { item.InvoiceID = InvoiceID; _context.Entry(item).State = System.Data.Entity.EntityState.Added; } _context.SaveChanges(); trans.Commit(); result = 1; } return result; }
public void LoadOrderPrev(int orderID) { indexControl = 1; try { OrderMain = new OrderDateModel(); OrderMain = OrderService.GetListOrderPrevOrder("", orderID, DateTime.Now.Date); lblSubtotal.Text = money.Format2(Convert.ToDouble(OrderMain.TotalAmount)); if (OrderMain.Seat > 0) { OrderMain.IsLoadFromData = true; lblSeat.Text = OrderMain.Seat.ToString(); lblStatus.Text = "OLD"; for (int seat = 1; seat <= OrderMain.Seat; seat++) { UCSeat ucSeat = new UCSeat(); ucSeat.lblSeat.Text = "Seat " + seat.ToString(); ucSeat.Click += ucSeat_Click; flpOrder.Controls.Add(ucSeat); indexControl = flpOrder.Controls.Count; if (OrderMain.ListOrderDetail.Count > 0) { for (int i = 0; i < OrderMain.ListOrderDetail.Count; i++) { if (OrderMain.ListOrderDetail[i].Seat == seat) { addOrder(OrderMain.ListOrderDetail[i]); indexControl++; for (int j = 0; j < OrderMain.ListOrderDetail[i].ListOrderDetailModifire.Count; j++) { UCItemModifierOfMenu uc = new UCItemModifierOfMenu(); uc.Tag = OrderMain.ListOrderDetail[i].ListOrderDetailModifire[j]; uc.Click += ucItemModifierOfMenu_Click; addModifreToOrder(uc, OrderMain.ListOrderDetail[i].ListOrderDetailModifire[j]); indexControl++; } } } } } } else { if (OrderMain.ListOrderDetail.Count > 0) { OrderMain.IsLoadFromData = true; lblStatus.Text = "OLD"; for (int i = 0; i < OrderMain.ListOrderDetail.Count; i++) { addOrder(OrderMain.ListOrderDetail[i]); indexControl++; for (int j = 0; j < OrderMain.ListOrderDetail[i].ListOrderDetailModifire.Count; j++) { UCItemModifierOfMenu uc = new UCItemModifierOfMenu(); uc.Tag = OrderMain.ListOrderDetail[i].ListOrderDetailModifire[j]; uc.Click += ucItemModifierOfMenu_Click; addModifreToOrder(uc, OrderMain.ListOrderDetail[i].ListOrderDetailModifire[j]); indexControl++; } } } } } catch (Exception ex) { LogPOS.WriteLog("LoadOrder:::::::::::::::::::::::::::::::::" + ex.Message); } }