public static List <HG_Ticket> GetByOID(Int64 OID)
{
List <HG_Ticket> listtemp = new List <HG_Ticket>();
DBCon con = new DBCon();
SqlCommand cmd = new SqlCommand();
string query = "select * from HG_Ticket where OrderId =" + OID.ToString();
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 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);
}
