protected void btncnfmBlck_Click(object sender, EventArgs e)
{
string strCon = ConfigurationSettings.AppSettings["conString"].ToString().Trim();
OracleConnection con = new OracleConnection(strCon);
if (txtremark.Text.Trim() == "")
{
PopMsgBoxErr.Show();
lblinfo.Text = "Please enter remark";
return;
}
String AccessString = "";
for (int i = 0; i < grdSTBSwap.Rows.Count; i++)
{
String Status = "";
CheckBox ChkMenu = (CheckBox)grdSTBSwap.Rows[i].Cells[0].FindControl("ChkSTB");
if (ChkMenu.Checked == true)
{
if (grdSTBSwap.Rows.Count == 1)
{
string STB = grdSTBSwap.Rows[i].Cells[1].Text;
string getaccno = "select account_no from reports.hwcas_brm_cust_master@caslive_new where stb='" + STB + "' and rownum=1";
OracleCommand cmdGetAccNo = new OracleCommand(getaccno, con);
OracleDataAdapter DaObjAccNo = new OracleDataAdapter(cmdGetAccNo);
DataTable dtAccNo = new DataTable();
string AccNo = "";
DaObjAccNo.Fill(dtAccNo);
if (dtAccNo.Rows.Count > 0)
{
AccNo = dtAccNo.Rows[0]["account_no"].ToString();
}
else
{
PopMsgBoxErr.Show();
lblinfo.Text = "Account No not found for STB :" + STB;
return;
}
string response_params = Convert.ToString(Session["user_brmpoid"]) + "$" + AccNo + "$SW";
string apiResponse = callAPI(response_params, "12");//
try
{
if (apiResponse != "")
{
List <string> lstResponse = new List <string>();
lstResponse = apiResponse.Split('$').ToList();
ViewState["accountPoid"] = lstResponse[6];
string cust_services = lstResponse[15];
string[] service_arr = cust_services.Split('^');
ViewState["Service_Str"] = null;
ViewState["Service_Str"] = cust_services.ToString();
}
}
catch (Exception ex)
{
}
}
RadioButton RdoAccept = (RadioButton)grdSTBSwap.Rows[i].FindControl("RdoAccept");
RadioButton RdoCancel = (RadioButton)grdSTBSwap.Rows[i].FindControl("RdoCancel");
string msgsubid = ((HiddenField)grdSTBSwap.Rows[i].FindControl("hdntransid")).Value;
if (RdoAccept.Checked == true)
{
Status = "A";
}
else
{
Status = "R";
}
AccessString += msgsubid + "#" + Status + "$";
}
}
if (AccessString != "")
{
AccessString = AccessString.Remove(AccessString.Length - 1);
}
else
{
PopMsgBoxErr.Show();
lblinfo.Text = "Please select atleast one record";
return;
}
Hashtable ht = new Hashtable();
ht.Add("in_username", Session["username"].ToString());
ht.Add("in_AccessString", AccessString);
ht.Add("in_remark", txtremark.Text.Trim());
Cls_BLL_ecafstbtransfer obj = new Cls_BLL_ecafstbtransfer();
string response = obj.InsertAdminTransfer(Session["username"].ToString(), ht);
string[] responseArr = response.Split('$');
PopMsgBoxErr.Show();
lblinfo.Text = responseArr[1].ToString();
ViewState["ErrorInfo"] = "9999";
}
