public List<XObjs.Hwallet> getHwalletByTransID(string transID) { List<XObjs.Hwallet> xlist = new List<XObjs.Hwallet>(); SqlConnection connection = new SqlConnection(this.ConnectXpay()); SqlCommand command = new SqlCommand("SELECT * FROM hwallet WHERE transID='" + transID + "' ", connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection); while (reader.Read()) { XObjs.Hwallet x = new XObjs.Hwallet(); x.xid = reader["xid"].ToString(); x.transID = reader["transID"].ToString(); x.fee_detailsID = reader["fee_detailsID"].ToString(); x.used_status = reader["used_status"].ToString(); x.xreg_date = reader["xreg_date"].ToString(); xlist.Add(x); } reader.Close(); return xlist; }
public XObjs.Hwallet getHwalletByID(string xid) { XObjs.Hwallet x = new XObjs.Hwallet(); SqlConnection connection = new SqlConnection(this.ConnectXpay()); SqlCommand command = new SqlCommand("SELECT * FROM hwallet WHERE xid='" + xid + "' ", connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection); while (reader.Read()) { x.xid = reader["xid"].ToString(); x.transID = reader["transID"].ToString(); x.fee_detailsID = reader["fee_detailsID"].ToString(); x.used_status = reader["used_status"].ToString(); x.xreg_date = reader["xreg_date"].ToString(); } reader.Close(); return x; }