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