protected void gvTm_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "TmDetailsClick") { GridViewRow namingContainer = (GridViewRow)((ImageButton)e.CommandSource).NamingContainer; int rowIndex = namingContainer.RowIndex; string transID = e.CommandArgument.ToString(); this.Session["transID"] = transID; XObjs.Twallet twallet = this.ret.getTwalletByTransID(transID); if (twallet.xid != null) { string xgt = twallet.xgt; this.lt_fdets = this.ret.getFee_detailsByTwalletID(twallet.xid); this.Session["agentType"] = twallet.xmembertype; this.Session["transID"] = transID; this.Session["memberID"] = this.adminID; this.Session["transDate"] = twallet.xreg_date; if (xgt == "xpay_bk") { this.Session["payment_type"] = "Bank"; this.c_banker = this.ret.getBankerByID(this.ret.getPwalletByID(twallet.xbankerID).xmemberID); this.Session["bank_xname"] = this.c_banker.xname; this.Session["bank_bankname"] = this.c_banker.bankname; this.Session["bank_xposition"] = this.c_banker.xposition; this.Session["bank_street"] = this.ret.getAddressByID(this.c_banker.addressID).street; this.Session["bank_telephone"] = this.ret.getAddressByID(this.c_banker.addressID).telephone1; this.Session["bank_email"] = this.ret.getAddressByID(this.c_banker.addressID).email1; } else if (xgt == "xpay_isw") { this.Session["payment_type"] = "Online (Inter Switch)"; } else { this.Session["payment_type"] = "Online"; } this.show_inv = 0; if (this.Session["IpongMemberType"].ToString() == "merchant") { this.show_details_grid = 1; } else { this.show_details_grid_wingman = 1; } } } }
public XObjs.XBanker getBankerByID(string xid) { XObjs.XBanker x = new XObjs.XBanker(); SqlConnection connection = new SqlConnection(this.ConnectXpay()); SqlCommand command = new SqlCommand("SELECT * FROM xbanker WHERE xid='" + xid + "' ", connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection); while (reader.Read()) { x.xid = reader["xid"].ToString(); x.xname = reader["xname"].ToString(); x.bankname = reader["bankname"].ToString(); x.xpassword = reader["xpassword"].ToString(); x.nationality = reader["nationality"].ToString(); x.addressID = reader["addressID"].ToString(); x.xposition = reader["xposition"].ToString(); x.sys_ID = reader["sys_ID"].ToString(); x.xreg_date = reader["xreg_date"].ToString(); x.xvisible = reader["xvisible"].ToString(); x.xsync = reader["xsync"].ToString(); } reader.Close(); return x; }