public XObjs.Fee_details getFee_detailsByID(string xid, string cat, string xmemberID) { XObjs.Fee_details x = new XObjs.Fee_details(); SqlConnection connection = new SqlConnection(this.ConnectXpay()); SqlCommand command = new SqlCommand("select fee_details.*,fee_list.* from fee_list INNER JOIN fee_details ON fee_details.fee_listID=fee_list.xid INNER JOIN twallet ON twallet.xid=fee_details.twalletID where fee_list.xcategory='" + cat + "' AND twallet.xmemberID='" + xmemberID + "' AND twallet.xpay_status='1' AND xid='" + xid + "' ", connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection); while (reader.Read()) { x.xid = reader["xid"].ToString(); x.fee_listID = reader["fee_listID"].ToString(); x.twalletID = reader["twalletID"].ToString(); x.xqty = reader["xqty"].ToString(); x.xused = reader["xused"].ToString(); x.tot_amt = reader["tot_amt"].ToString(); x.init_amt = reader["init_amt"].ToString(); x.tech_amt = reader["tech_amt"].ToString(); x.xreg_date = reader["xlogstaff"].ToString(); x.xreg_date = reader["xreg_date"].ToString(); x.xsync = reader["xsync"].ToString(); x.xvisible = reader["xvisible"].ToString(); } reader.Close(); return x; }
public List<XObjs.Fee_details> getFee_detailsByTwalletID(string twalletID) { List<XObjs.Fee_details> xlist = new List<XObjs.Fee_details>(); SqlConnection connection = new SqlConnection(this.ConnectXpay()); SqlCommand command = new SqlCommand("SELECT * from fee_details where twalletID='" + twalletID + "' ", connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection); while (reader.Read()) { XObjs.Fee_details x = new XObjs.Fee_details(); x.xid = reader["xid"].ToString(); x.fee_listID = reader["fee_listID"].ToString(); x.twalletID = reader["twalletID"].ToString(); x.xqty = reader["xqty"].ToString(); x.xused = reader["xused"].ToString(); x.tot_amt = reader["tot_amt"].ToString(); x.init_amt = reader["init_amt"].ToString(); x.tech_amt = reader["tech_amt"].ToString(); x.xreg_date = reader["xlogstaff"].ToString(); x.xreg_date = reader["xreg_date"].ToString(); x.xsync = reader["xsync"].ToString(); x.xvisible = reader["xvisible"].ToString(); xlist.Add(x); } reader.Close(); return xlist; }
public XObjs.Fee_details getFee_detailsByID(string xid) { XObjs.Fee_details x = new XObjs.Fee_details(); SqlConnection connection = new SqlConnection(this.ConnectXpay()); SqlCommand command = new SqlCommand("select * from fee_details where xid='" + xid + "' ", connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection); while (reader.Read()) { x.xid = reader["xid"].ToString(); x.fee_listID = reader["fee_listID"].ToString(); x.twalletID = reader["twalletID"].ToString(); x.xqty = reader["xqty"].ToString(); x.xused = reader["xused"].ToString(); x.tot_amt = reader["tot_amt"].ToString(); x.init_amt = reader["init_amt"].ToString(); x.tech_amt = reader["tech_amt"].ToString(); x.xreg_date = reader["xlogstaff"].ToString(); x.xreg_date = reader["xreg_date"].ToString(); x.xsync = reader["xsync"].ToString(); x.xvisible = reader["xvisible"].ToString(); } reader.Close(); return x; }