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