protected void btncnfmBlck_Click(object sender, EventArgs e)
{
string strCon = ConfigurationSettings.AppSettings["conString"].ToString().Trim();
OracleConnection con = new OracleConnection(strCon);
String AccessString = "";
for (int i = 0; i < grdSTBSwap.Rows.Count; i++)
{
RadioButton RdoAccept = (RadioButton)grdSTBSwap.Rows[i].FindControl("RdoAccept");
RadioButton RdoCancel = (RadioButton)grdSTBSwap.Rows[i].FindControl("RdoCancel");
String Status = "";
CheckBox ChkMenu = (CheckBox)grdSTBSwap.Rows[i].Cells[0].FindControl("ChkSTB");
if (ChkMenu.Checked == true)
{
if (grdSTBSwap.Rows.Count == 1)
{
if (RdoAccept.Checked == true)
{
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();
lblResponseMsg.Text = "Account No not found for STB :" + STB;
return;
}
string ServiceObj = "";
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('^');
foreach (string service in service_arr)
{
string stb_no = service.Split('!')[1];
if (stb_no == STB)
{
ServiceObj = service.Split('!')[0];
}
}
}
else
{
PopMsgBoxErr.Show();
lblerror.Text = "Failed From OBRM";
return;
}
string response_paramsSTBTransfer = Session["username"].ToString() + "$" + ViewState["accountPoid"].ToString() + "$" + STB + "$" + AccNo;
string apiResponseSTBTransfer = callAPI(response_paramsSTBTransfer, "37");//
string[] apiResponseSTBTransferArr = apiResponseSTBTransfer.Split('$');
if (apiResponseSTBTransferArr[0].ToString() == "0")
{
}
else
{
PopMsgBoxErr.Show();
lblerror.Text = "Failed From OBRM : " + apiResponseSTBTransferArr[1].ToString();
return;
}
}
catch (Exception ex)
{
PopMsgBoxErr.Show();
lblerror.Text = "Failed From OBRM" + ex.Message;
return;
}
}
}
string msgsubid = ((HiddenField)grdSTBSwap.Rows[i].FindControl("hdntransid")).Value;
if (RdoAccept.Checked == true)
{
Status = "A";
}
else
{
Status = "C";
}
AccessString += msgsubid + "#" + Status + "$";
}
}
if (AccessString != "")
{
AccessString = AccessString.Remove(AccessString.Length - 1);
}
else
{
PopMsgBoxErr.Show();
lblerror.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.InsertLCOTransfer(Session["username"].ToString(), ht);
string[] responseArr = response.Split('$');
popMsgBox.Show();
lblResponseMsg.Text = responseArr[1].ToString();
btncnfmBlck.Visible = false;
ViewState["ErrorInfo"] = "9999";
}
