public static List <PendingPrints> GetAll() { DBCon dBCon = new DBCon(); SqlCommand cmd = null; SqlDataReader SDR = null; List <PendingPrints> listpending = new List <PendingPrints>(); try { string Quary = "Select * from pendingprint "; cmd = new SqlCommand(Quary, dBCon.Con); SDR = cmd.ExecuteReader(); while (SDR.Read()) { PendingPrints OBJPENDING = new PendingPrints(); OBJPENDING.ID = SDR.GetInt32(0); OBJPENDING.OID = SDR.GetInt64(1); OBJPENDING.OrgId = SDR.GetInt32(2); OBJPENDING.InvoiceNoCopy = SDR.GetInt32(3); OBJPENDING.KotNoOfCopy = SDR.GetInt32(4); OBJPENDING.Createdate = SDR.GetDateTime(5); OBJPENDING.TicketNo = SDR.GetInt32(6); listpending.Add(OBJPENDING); } } catch (Exception e) { e.ToString(); } finally { cmd.Dispose(); dBCon.Con.Close(); } return(listpending); }
//if (ObjOrg.OrderDisplay == 2 && AppType != 3 && ObjOrg.PrinttingType == 2 && (PaymtSts > 0 ||ObjOrg.PaymentType==2)) // { // PendingPrints.SaveKotPrint(ObjOrders, ObjOrg.Copy, Ticketno); // } public static void SaveInvoicePrint(HG_Orders order, int NoOfCopy) { PendingPrints pendingPrints = new PendingPrints(); pendingPrints.OID = order.OID; pendingPrints.OrgId = order.OrgId; pendingPrints.InvoiceNoCopy = NoOfCopy; pendingPrints.KotNoOfCopy = 0; pendingPrints.TicketNo = 0; try { pendingPrints.Save(); } catch (Exception e) { } }
public static void SaveKotPrint(HG_Orders order, int NoOfCopy, int TicketNo = 0, List <HG_OrderItem> hG_OrderItems = null) { if (TicketNo == 0) { var tickets = hG_OrderItems.GroupBy(x => x.TickedNo); foreach (var ticket in tickets) { PendingPrints pendingPrints = new PendingPrints(); pendingPrints.OID = order.OID; pendingPrints.OrgId = order.OrgId; pendingPrints.KotNoOfCopy = NoOfCopy; pendingPrints.InvoiceNoCopy = 0; pendingPrints.TicketNo = ticket.Key; try { pendingPrints.Save(); } catch (Exception e) { } } } else { PendingPrints pendingPrints = new PendingPrints(); pendingPrints.OID = order.OID; pendingPrints.OrgId = order.OrgId; pendingPrints.KotNoOfCopy = NoOfCopy; pendingPrints.InvoiceNoCopy = 0; pendingPrints.TicketNo = TicketNo; try { pendingPrints.Save(); } catch (Exception e) { } } }