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(); Session["transID"] = transID; twall = ret.getTwalletByTransID(transID); if (twall.xid != null) { isw_fields = ret.getISWtransactionByTransactionID(transID); isw_fields.TransactionDate = isw_fields.TransactionDate.Substring(0, 11).Trim(); string xgt = twall.xgt; lt_fdets = ret.getFee_detailsByTwalletID(twall.xid); c_app = ret.getApplicantByID(twall.applicantID); Session["c_app"] = c_app; Session["AgentType"] = twall.xmembertype; Session["transID"] = transID; Session["memberID"] = adminID; Session["transDate"] = twall.xreg_date; if (twall.xmembertype == "Agent") { c_reg = ret.getRegistrationByID(twall.xmemberID); fullname = c_reg.Firstname + " " + c_reg.Surname; coy_name = c_reg.CompanyName; cust_id = c_reg.Sys_ID; email = c_reg.Email; mobile = c_reg.PhoneNumber; Session["coy_name"] = coy_name; Session["fullname"] = fullname; Session["email"] = email; Session["mobile"] = mobile; Session["c_addy"] = c_reg.CompanyAddress; } else { c_sub = ret.getSubAgentByID(twall.xmemberID); fullname = c_sub.Firstname + " " + c_sub.Surname; email = c_sub.Email; mobile = c_sub.Telephone; if (c_sub.xid != null) { c_sub_reg = ret.getRegistrationByID(c_sub.RegistrationID); coy_name = c_sub_reg.CompanyName; cust_id = c_sub_reg.Sys_ID + "_" + c_sub.AssignID; } } c_ai.code = cust_id; c_ai.xname = fullname; c_ai.xemail = email; c_ai.xmobile = mobile; Session["c_ai"] = c_ai; if (xgt == "xpay_bk") { Session["payment_type"] = "Bank"; c_banker = ret.getBankerByID(ret.getPwalletByID(twall.xbankerID).xmemberID); Session["bank_xname"] = c_banker.xname; Session["bank_bankname"] = c_banker.bankname; Session["bank_xposition"] = c_banker.xposition; Session["bank_street"] = ret.getAddressByID(c_banker.addressID).street; Session["bank_telephone"] = ret.getAddressByID(c_banker.addressID).telephone1; Session["bank_email"] = ret.getAddressByID(c_banker.addressID).email1; } else if (xgt == "xpay_isw") { Session["payment_type"] = "Online (Inter Switch)"; } else { Session["payment_type"] = "Online"; } show_inv = 1; if (Session["tm_cnt"] != null) { tm_cnt = Convert.ToInt32(Session["tm_cnt"]); } show_details_grid = 1; } } }
public XObjs.XBanker getBankerByID(string xid) { XObjs.XBanker banker = new XObjs.XBanker(); SqlConnection connection = new SqlConnection(hf.ConnectXpay()); SqlCommand command = new SqlCommand("SELECT * FROM xbanker WHERE xid='" + xid + "' ", connection); connection.Open(); command.CommandTimeout = 0; SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection); while (reader.Read()) { banker.xid = reader["xid"].ToString(); banker.xname = reader["xname"].ToString(); banker.bankname = reader["bankname"].ToString(); banker.xpassword = reader["xpassword"].ToString(); banker.nationality = reader["nationality"].ToString(); banker.addressID = reader["addressID"].ToString(); banker.xposition = reader["xposition"].ToString(); banker.sys_ID = reader["sys_ID"].ToString(); banker.xreg_date = reader["xreg_date"].ToString(); banker.xvisible = reader["xvisible"].ToString(); banker.xsync = reader["xsync"].ToString(); } reader.Close(); return banker; }