//this is get One Function
public vw_HG_UsersDetails Checkvw_HG_UsersDetails()
{
DBCon dBCon = new DBCon();
SqlCommand cmd = null;
SqlDataReader SDR = null;
vw_HG_UsersDetails ObjTmp = null;
try
{
string Query = "SELECT TOP 1 * FROM HG_UsersDetails WHERE UserID = @UserID AND Password = @Password COLLATE Latin1_General_CS_AS;";
cmd = new SqlCommand(Query, dBCon.Con);
cmd.Parameters.AddWithValue("@UserID", UserId);
cmd.Parameters.AddWithValue("@Password", Password);
SDR = cmd.ExecuteReader();
while (SDR.Read())
{
ObjTmp = new vw_HG_UsersDetails();
ObjTmp.UserCode = SDR.GetInt32(0);
ObjTmp.OrgID = SDR.GetInt32(1);
ObjTmp.UserType = SDR.GetString(2);
ObjTmp.UserName = SDR.GetString(3);
ObjTmp.UserId = SDR.GetString(4);
ObjTmp.Password = SDR.GetString(5);
ObjTmp.EMail = SDR.GetString(6);
ObjTmp.UPhoto = SDR.IsDBNull(7) ? "" : SDR.GetString(7);
ObjTmp.EntryBy = SDR.GetInt32(8);
ObjTmp.EntryDate = SDR.GetDateTime(9);
ObjTmp.UpdateDate = SDR.GetDateTime(10);
ObjTmp.Status = SDR.GetBoolean(11);
ObjTmp.CurrentStatus = SDR.IsDBNull(12) ? false : SDR.GetBoolean(12);
ObjTmp.JoinByOrg = SDR.GetInt32(13);
ObjTmp.IsHeadChef = SDR.GetBoolean(14);
ObjTmp.TickUntick = SDR.GetBoolean(15);
ObjTmp.RateNow = SDR.GetInt32(16);
}
}
catch (Exception e) { e.ToString(); }
finally { cmd.Dispose(); SDR.Close(); dBCon.Con.Close(); dBCon.Con.Dispose(); SDR.Close(); }
return(ObjTmp);
}
public Int64 Save()
{
int ROW = 0;
DBCon dBCon = new DBCon();
SqlCommand cmd = null;
try
{
string Query = "";
if (this.ID == 0)
{
Query = "INSERT INTO pendingprint values (@OID,@OrgId,@InvoiceNoCopy,@KotNoOfCopy,@Createdate,@TicketNo)";
cmd = new SqlCommand(Query, dBCon.Con);
cmd.Parameters.AddWithValue("Createdate", DateTime.Now.Date);
cmd.Parameters.AddWithValue("OID", this.OID);
cmd.Parameters.AddWithValue("OrgId", this.OrgId);
cmd.Parameters.AddWithValue("TicketNo", this.TicketNo);
}
else
{
Query = "Update pendingprint set InvoiceNoCopy=@InvoiceNoCopy,KotNoOfCopy=@KotNoOfCopy where ID=@ID";
cmd.Parameters.AddWithValue("ID", this.ID);
}
cmd.Parameters.AddWithValue("InvoiceNoCopy", this.InvoiceNoCopy);
cmd.Parameters.AddWithValue("KotNoOfCopy", this.KotNoOfCopy);
if (this.ID == 0)
{
ROW = Convert.ToInt32(cmd.ExecuteScalar());
this.ID = ROW;
}
else
{
ROW = cmd.ExecuteNonQuery();
//this.CategoryID = Row;
}
}
catch (Exception e) { e.ToString(); }
finally { cmd.Dispose(); dBCon.Con.Close(); }
return(ROW);
}
public static bool IsJoined(Int64 CID, int OrgId)
{
string Query = "SELECT CID,OrgId from MyCustomer where CID=" + CID.ToString() + " and OrgId=" + OrgId.ToString();
bool joindSts = false;
SqlCommand cmd = null;
SqlDataReader SDR = null;
DBCon Obj = new DBCon();
try
{
cmd = new SqlCommand(Query, Obj.Con);
SDR = cmd.ExecuteReader();
while (SDR.Read())
{
joindSts = true;
//Cnt++;
}
}
catch (Exception e) { e.ToString(); }
finally { cmd.Dispose(); SDR.Close(); Obj.Con.Close(); Obj.Con.Dispose(); Obj.Con = null; }
return(joindSts);
}
public List <HG_Ticket> GetAll(int OrgId, DateTime?onDate = null)
{
if (!onDate.HasValue)
{
onDate = DateTime.Now;
}
var CurrOrgID = HttpContext.Current.Request.Cookies["UserInfo"];
List <HG_Ticket> listtemp = new List <HG_Ticket>();
DBCon con = new DBCon();
SqlCommand cmd = new SqlCommand();
string query = "select * from HG_Ticket where OrgId =" + OrgId.ToString() + " and CreateDate='" + onDate.Value.Date.ToString("MM/dd/yyyy") + "'";
try
{
cmd = new SqlCommand(query, con.Con);
SqlDataReader sqlDataReader = cmd.ExecuteReader();
while (sqlDataReader.Read())
{
HG_Ticket hG_Ticket = new HG_Ticket();
hG_Ticket.TicketId = sqlDataReader.GetInt64(0);
hG_Ticket.TicketNo = sqlDataReader.GetInt32(1);
hG_Ticket.OrgId = sqlDataReader.GetInt32(2);
hG_Ticket.OID = sqlDataReader.GetInt64(3);
hG_Ticket.CreationDate = sqlDataReader.GetDateTime(4);
hG_Ticket.DeliveryCharge = sqlDataReader.GetDouble(5);
listtemp.Add(hG_Ticket);
}
}
catch (Exception e)
{
e.ToString();
}
finally
{
con.Con.Close(); con.Con.Dispose(); cmd.Dispose();
}
return(listtemp);
}
public static PaytmResn Getone(Int64 OID)
{
PaytmResn Temp = new PaytmResn();
DBCon con = new DBCon();
SqlCommand cmd = new SqlCommand();
string query = "select * from PaytmTxn where OID=@OID";
try
{
cmd = new SqlCommand(query, con.Con);
cmd.Parameters.AddWithValue("@OID", OID);
SqlDataReader sqlDataReader = cmd.ExecuteReader();
while (sqlDataReader.Read())
{
int index = -1;
PaytmResn hG_Ticket = new PaytmResn();
hG_Ticket.id = sqlDataReader.GetInt32(++index);
hG_Ticket.OID = sqlDataReader.GetInt64(++index);
hG_Ticket.OIDkey = sqlDataReader.GetString(++index);
hG_Ticket.TxnId = sqlDataReader.GetString(++index);
hG_Ticket.TxnSts = sqlDataReader.GetInt32(++index);
hG_Ticket.TxtDate = sqlDataReader.GetDateTime(++index);
hG_Ticket.CID = sqlDataReader.GetInt64(++index);
hG_Ticket.PaytmResp = sqlDataReader.GetString(++index);
hG_Ticket.PaidAmount = sqlDataReader.GetString(++index);
Temp = hG_Ticket;
}
}
catch (Exception e)
{
e.ToString();
}
finally
{
con.Con.Close(); con.Con.Dispose(); cmd.Dispose();
}
return(Temp);
}
public HG_Orders GetOne(Int64 OID)
{
DBCon dBCon = new DBCon();
SqlCommand cmd = null;
SqlDataReader SDR = null;
HG_Orders ObjTemp = new HG_Orders();
try
{
string Query = "SELECT * FROM HG_Orders Where OID=" + OID.ToString();
cmd = new SqlCommand(Query, dBCon.Con);
SDR = cmd.ExecuteReader();
while (SDR.Read())
{
ObjTemp.OID = SDR.GetInt64(0);
ObjTemp.CID = SDR.GetInt64(1);
ObjTemp.Status = SDR.GetString(2);
ObjTemp.Create_By = SDR.GetInt64(3);
ObjTemp.Create_Date = SDR.GetDateTime(4);
ObjTemp.Update_By = SDR.GetInt64(5);
ObjTemp.Update_Date = SDR.GetDateTime(6);
ObjTemp.OrgId = SDR.GetInt32(8);
ObjTemp.Table_or_SheatId = SDR.GetInt64(9);
ObjTemp.PaymentStatus = SDR.GetInt32(10);
ObjTemp.PayReceivedBy = SDR.GetInt32(11);
ObjTemp.TableOtp = SDR.GetInt32(12);
ObjTemp.DisntChargeIDs = SDR.GetString(13);
ObjTemp.OrderApprovlSts = SDR.GetInt32(14);
ObjTemp.DeliveryCharge = SDR.GetDouble(15);
ObjTemp.ContactId = SDR.GetInt32(16);
ObjTemp.OfferDishCBID = SDR.GetInt32(17);
}
}
catch (Exception e) { e.ToString(); }
finally { dBCon.Close(); cmd.Dispose(); }
return(ObjTemp);
}
public static List <PaytmResn> GetAll()
{
List <PaytmResn> listtemp = new List <PaytmResn>();
DBCon con = new DBCon();
SqlCommand cmd = new SqlCommand();
string query = "select * from PaytmTxn";
try
{
cmd = new SqlCommand(query, con.Con);
SqlDataReader sqlDataReader = cmd.ExecuteReader();
while (sqlDataReader.Read())
{
int index = -1;
PaytmResn hG_Ticket = new PaytmResn();
hG_Ticket.id = sqlDataReader.GetInt32(++index);
hG_Ticket.OID = sqlDataReader.GetInt64(++index);
hG_Ticket.OIDkey = sqlDataReader.GetString(++index);
hG_Ticket.TxnId = sqlDataReader.GetString(++index);
hG_Ticket.TxnSts = sqlDataReader.GetInt32(++index);
hG_Ticket.TxtDate = sqlDataReader.GetDateTime(++index);
hG_Ticket.CID = sqlDataReader.GetInt64(++index);
hG_Ticket.PaytmResp = sqlDataReader.GetString(++index);
hG_Ticket.PaidAmount = sqlDataReader.GetString(++index);
listtemp.Add(hG_Ticket);
}
}
catch (Exception e)
{
e.ToString();
}
finally
{
con.Con.Close(); con.Con.Dispose(); cmd.Dispose();
}
return(listtemp);
}
public static List <JoinFoodDo> GetAll(int UserId = 0)
{
List <JoinFoodDo> listtemp = new List <JoinFoodDo>();
DBCon con = new DBCon();
SqlCommand cmd = new SqlCommand();
string query = "select * from JoinFoodDo";
if (UserId > 0)
{
query = "select * from JoinFoodDo where JoinedUserd=" + UserId;
}
try
{
cmd = new SqlCommand(query, con.Con);
SqlDataReader sqlDataReader = cmd.ExecuteReader();
while (sqlDataReader.Read())
{
JoinFoodDo hG_Ticket = new JoinFoodDo();
hG_Ticket.JoinId = sqlDataReader.GetInt32(0);
hG_Ticket.JoinType = sqlDataReader.GetInt32(1);
hG_Ticket.ProductType = sqlDataReader.GetString(2);
hG_Ticket.JoinedUserd = sqlDataReader.GetInt32(3);
hG_Ticket.JoinDate = sqlDataReader.GetDateTime(4);
listtemp.Add(hG_Ticket);
}
}
catch (Exception e)
{
e.ToString();
}
finally
{
con.Con.Close(); con.Con.Dispose(); cmd.Dispose();
}
return(listtemp);
}
public static int UnseenOrd(int OrgId)
{
string Query = "SELECT distinct TickedNo,OID FROM HG_OrderItem WHERE (Status=1 or Status=2) and OID In(select OID from HG_Orders where Status='1' ";
int Count = 0;
HG_OrganizationDetails ObjOrg = new HG_OrganizationDetails().GetOne(OrgId);
if (OrgId == 0 || (ObjOrg.OrgID > 0 && ObjOrg.PaymentType == 1))
{
Query = "SELECT distinct TickedNo,OID FROM HG_OrderItem WHERE (Status=1 or Status=2) and OID In(select OID from HG_Orders where Status='1' and PaymentStatus!= 0 ";
}
if (OrgId > 0)
{
Query += "and OrgId=" + OrgId.ToString() + " )";
}
else
{
Query += ")";
}
System.Data.SqlClient.SqlCommand cmd = null;
System.Data.SqlClient.SqlDataReader SDR = null;
HG_OrderItem ObjTmp = new HG_OrderItem();
DBCon Obj = new DBCon();
try
{
cmd = new System.Data.SqlClient.SqlCommand(Query, Obj.Con);
SDR = cmd.ExecuteReader();
while (SDR.Read())
{
Count = Count + 1;
}
}
catch (System.Exception e) { e.ToString(); }
finally { cmd.Dispose(); SDR.Close(); Obj.Con.Close(); Obj.Con.Dispose(); Obj.Con = null; }
return(Count);
}
public int Save()
{
int Row = 0;
DBCon con = new DBCon();
SqlCommand cmd = null;
try
{
string Quary = "";
if (this.ContctID == 0)
{
Quary = "Insert Into LocalContacts Values (@MobileNo,@Cust_Name,@OrgId);SELECT SCOPE_IDENTITY();";
}
else
{
Quary = "Update LocalContacts Set MobileNo=@MobileNo,Cust_Name=@Cust_Name where ContctID=@ContctID";
}
cmd = new SqlCommand(Quary, con.Con);
cmd.Parameters.AddWithValue("@ContctID", this.ContctID);
cmd.Parameters.AddWithValue("@MobileNo", this.MobileNo);
cmd.Parameters.AddWithValue("@Cust_Name", this.Cust_Name);
if (this.ContctID == 0)
{
cmd.Parameters.AddWithValue("@OrgId", this.OrgId);
Row = Convert.ToInt32(cmd.ExecuteScalar());
this.ContctID = Row;
}
else
{
Row = cmd.ExecuteNonQuery();
//this.CategoryID = Row;
}
}
catch (Exception e) { e.ToString(); }
finally { cmd.Dispose(); con.Con.Close(); }
return(Row);
}
public int save()
{
DBCon con = new DBCon();
SqlCommand cmd = new SqlCommand();
try
{
cmd = new SqlCommand("insert into MyCustomer values(@CID,@OrgId,@JoinDate)", con.Con);
cmd.Parameters.AddWithValue("@CID", this.CID);
cmd.Parameters.AddWithValue("@OrgId", this.OrgId);
cmd.Parameters.AddWithValue("@JoinDate", DateTime.Now);
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
e.Message.ToString();
return(0);
}
finally
{
cmd.Dispose(); con.Con.Close();
}
return(this.OrgId);
}
public int TicketCnt(int OrgID, DateTime?onDate = null)
{
int TicketOnDate = 0;
if (!onDate.HasValue)
{
onDate = DateTime.Now;
}
DBCon con = new DBCon();
SqlCommand cmd = new SqlCommand();
//string query = "select * from HG_Ticket where OrgId =" + OrgId.ToString() + " and CreateDate='" + onDate.Value.Date.ToString("MM/dd/yyyy") + "'";
try
{
cmd = new SqlCommand("TicketCntOnDate", con.Con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@OrgID", OrgID);
cmd.Parameters.AddWithValue("@Ondate", onDate.Value.Date.ToString("MM/dd/yyyy"));
SqlDataReader sqlDataReader = cmd.ExecuteReader();
while (sqlDataReader.Read())
{
TicketOnDate = sqlDataReader.GetInt32(0);
break;
}
}
catch (Exception e)
{
e.ToString();
}
finally
{
con.Con.Close(); con.Con.Dispose(); cmd.Dispose();
}
return(TicketOnDate);
}
public static List <OrdDiscntChrge> GetAll(string IDS)
{
DBCon Con = new DBCon();
SqlCommand cmd = null;
SqlDataReader SDR = null;
List <OrdDiscntChrge> TmpList = new List <OrdDiscntChrge>();
try
{
string Query = "SELECT * FROM OrderDiscntCharge where ID IN(" + IDS + ")";
cmd = new SqlCommand(Query, Con.Con);
SDR = cmd.ExecuteReader();
while (SDR.Read())
{
int Index = 0;
OrdDiscntChrge ObjTmp = new OrdDiscntChrge();
ObjTmp.ID = SDR.GetInt32(Index++);
ObjTmp.Title = SDR.GetString(Index++);
ObjTmp.OID = SDR.GetInt64(Index++);
ObjTmp.Type = SDR.GetInt32(Index++);
ObjTmp.Amt = SDR.GetDouble(Index++);
ObjTmp.Tax = SDR.GetDouble(Index++);
ObjTmp.Remark = SDR.GetString(Index++);
ObjTmp.Datetime = SDR.GetDateTime(Index++);
ObjTmp.CBID = SDR.GetInt32(Index++);
TmpList.Add(ObjTmp);
}
}
catch (Exception e)
{ e.ToString(); }
finally { SDR.Close(); cmd.Dispose(); Con.Con.Close(); Con = null; }
return(TmpList);
}
public int Save()
{
int Row = 0;
DBCon dBCon = new DBCon();
SqlCommand cmd = null;
try
{
string Query = "";
if (this.ItemID == 0)
{
Query = "Insert into HG_Items values(@CategoryID,@OrgID,@Items,@Price,@Plates,@ItemMode,@Discount,@EntryBy,@EntryDate,@UpdateDate,@Status,@Item_Img,@ApplyAddOn,@CostPrice,@AddOnCatId,@Type,@AddOnType,@ItmDiscriptn,@ItemAvaibility,@MultiServing); SELECT SCOPE_IDENTITY();";
cmd = new SqlCommand(Query, dBCon.Con);
cmd.Parameters.AddWithValue("@EntryBy", this.EntryBy);
cmd.Parameters.AddWithValue("@EntryDate", DateTime.Now);
cmd.Parameters.AddWithValue("@UpdateDate", DateTime.Now);
}
else
{
Query = "update HG_Items set CategoryID=@CategoryID,OrgID =@OrgID,Items=@Items,Price=@Price,Plates=@Plates,ItemMode=@ItemMode,Discount=@Discount,EntryBy=@EntryBy,UpdateDate=@UpdateDate,Status=@Status,Item_Img=@Item_Img,ApplyAddOn=@ApplyAddOn,CostPrice=@CostPrice,AddOnCatId=@AddOnCatId,Type=@Type,AddOnType=@AddOnType,ItmDiscriptn=@ItmDiscriptn,ItemAvaibility=@ItemAvaibility,MultiServing=@MultiServing where ItemID=@ItemID";
cmd = new SqlCommand(Query, dBCon.Con);
cmd.Parameters.AddWithValue("@ItemID", this.ItemID);
cmd.Parameters.AddWithValue("@EntryBy", EntryBy);
cmd.Parameters.AddWithValue("@UpdateDate", DateTime.Now);
}
cmd.Parameters.AddWithValue("@CategoryID", this.CategoryID);
cmd.Parameters.AddWithValue("@OrgID", this.OrgID);
cmd.Parameters.AddWithValue("@Items", this.Items);
cmd.Parameters.AddWithValue("@Price", this.Price);
cmd.Parameters.AddWithValue("@Plates", this.Qty);
cmd.Parameters.AddWithValue("@ItemMode ", this.ItemMode);
cmd.Parameters.AddWithValue("@Discount ", this.Tax);
cmd.Parameters.AddWithValue("@Status", this.Status);
cmd.Parameters.AddWithValue("@Item_Img", this.Image);
cmd.Parameters.AddWithValue("@ApplyAddOn", this.ApplyAddOn);
cmd.Parameters.AddWithValue("@CostPrice", this.CostPrice);
cmd.Parameters.AddWithValue("@AddOnCatId", this.AddOnCatId);
cmd.Parameters.AddWithValue("@Type", this.Type);
cmd.Parameters.AddWithValue("@AddOnType", this.AddOnType);
cmd.Parameters.AddWithValue("@ItmDiscriptn", this.ItemDiscription);
cmd.Parameters.AddWithValue("@ItemAvaibility", this.ItemAvaibility);
cmd.Parameters.AddWithValue("@MultiServing", this.MultiServing);
if (this.ItemID == 0)
{
Row = System.Convert.ToInt32(cmd.ExecuteScalar());
this.ItemID = Row;
}
else
{
Row = cmd.ExecuteNonQuery();
if (Row > 0)
{
Row = this.ItemID;
}
}
}
catch (Exception e) { e.ToString(); }
finally { dBCon.Con.Close();
if (cmd != null)
{
cmd.Dispose();
}
}
return(Row);
}
public List <HG_Orders> GetAll(int OrgId = 0, int CID = 0, int Status = 0)
{
SqlCommand cmd = null;
SqlDataReader SDR = null;
List <HG_Orders> ListTmp = new List <HG_Orders>();
HG_Orders ObjTmp = null;
DBCon Obj = new DBCon();
try
{
string Query = "SELECT * FROM HG_ORDERS WHERE OrgId=" + OrgId + "";
if (OrgId > 0)
{
Query = "SELECT * FROM HG_ORDERS WHERE OrgId=" + OrgId + "";
}
else if (CID == 0 && OrgId <= 0)
{
Query = "SELECT * FROM HG_ORDERS WHERE OrgId>0";
}
if (CID > 0)
{
Query = "select * from HG_Orders where OID in (select Distinct(OID) from HG_OrderItem where OrdById=" + CID + ") ";
}
if (Status > 0)
{
Query += "and Status=" + Status.ToString() + " ";
}
if (OrgId == 0)
{
Query += " ORDER BY OID DESC";
}
else
{
Query += " ORDER BY Create_Date ASC";
}
cmd = new SqlCommand(Query, Obj.Con);
SDR = cmd.ExecuteReader();
while (SDR.Read())
{
ObjTmp = new HG_Orders
{
OID = SDR.GetInt64(0),
CID = SDR.GetInt64(1),
Status = SDR.GetString(2),
Create_By = SDR.GetInt64(3),
Create_Date = SDR.GetDateTime(4),
Update_By = SDR.GetInt64(5),
Update_Date = SDR.GetDateTime(6),
OrgId = SDR.GetInt32(8),
Table_or_SheatId = SDR.GetInt64(9),
PaymentStatus = SDR.GetInt32(10),
PayReceivedBy = SDR.GetInt32(11),
TableOtp = SDR.GetInt32(12),
DisntChargeIDs = SDR.GetString(13),
OrderApprovlSts = SDR.GetInt32(14),
DeliveryCharge = SDR.GetDouble(15),
ContactId = SDR.GetInt32(16),
OfferDishCBID = SDR.GetInt32(17)
};
ListTmp.Add(ObjTmp);
}
}
catch (Exception e) { e.ToString(); }
finally { cmd.Dispose(); SDR.Close(); Obj.Con.Close(); Obj.Con.Dispose(); Obj.Con = null; }
return(ListTmp);
}
public List <HG_OrderItem> GetAllByOrg(int OrgId, int ChefId = 0, int ItemStatus = 0, bool TodayOnly = false, string Status = null)
{
System.Data.SqlClient.SqlCommand cmd = null;
System.Data.SqlClient.SqlDataReader SDR = null;
List <HG_OrderItem> ListTmp = new List <HG_OrderItem>();
DBCon Obj = new DBCon();
try
{
string Query = "";
if (OrgId > 0)
{
Query = "SELECT * FROM HG_ORDERITEM WHERE OrgId=" + OrgId.ToString() + "";
}
else if (OrgId <= 0)//super admin && postpaid-admin
{
Query = "SELECT * FROM HG_ORDERITEM WHERE OrgId>0";
}
if (ChefId > 0)
{
Query += " and (ChefSeenBy=" + ChefId.ToString() + " or ChefSeenBy=0)";
}
if (ItemStatus > 0)
{
Query += " and Status=" + ItemStatus.ToString();
}
if (TodayOnly)
{
var Formdate = DateTime.Now;
var theDate = new DateTime(Formdate.Year, Formdate.Month, Formdate.Day, 23, 59, 00);
Query = "SELECT * FROM HG_ORDERITEM WHERE OrderDate between '" + Formdate.ToString("MM/dd/yyyy") + "' and '" + theDate.ToString("MM/dd/yyyy HH:mm:ss") + "' and OrgId=" + OrgId.ToString() + "";
}
if (Status != null && ItemStatus == 0)
{
Query += " and " + Status;
}
cmd = new System.Data.SqlClient.SqlCommand(Query, Obj.Con);
SDR = cmd.ExecuteReader();
while (SDR.Read())
{
HG_OrderItem ObjTmp = new HG_OrderItem();
ObjTmp.OIID = SDR.GetInt64(0);
ObjTmp.FID = SDR.GetInt64(1);
ObjTmp.Price = SDR.GetDouble(2);
ObjTmp.Count = SDR.GetInt32(3);
ObjTmp.IsAddon = SDR.GetString(4);
ObjTmp.OID = SDR.GetInt64(5);
ObjTmp.Status = SDR.GetInt32(7);
ObjTmp.OrderDate = SDR.GetDateTime(8);
ObjTmp.UpdatedBy = SDR.GetInt32(9);
ObjTmp.UpdationDate = SDR.GetDateTime(10);
ObjTmp.TickedNo = SDR.GetInt32(11);
ObjTmp.ChefSeenBy = SDR.GetInt32(12);
ObjTmp.OrgId = SDR.GetInt32(13);
ObjTmp.OrdById = SDR.GetInt64(14);
ObjTmp.TaxInItm = SDR.GetDouble(15);
ObjTmp.CostPrice = SDR.GetDouble(16);
ListTmp.Add(ObjTmp);
}
}
catch (Exception e) { e.ToString(); }
finally { cmd.Dispose(); SDR.Close(); Obj.Con.Close(); Obj.Con.Dispose(); Obj.Con = null; }
return(ListTmp);
}