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