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