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)
{
}
}
}
