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