protected void btnsubmit_Click(object sender, EventArgs e)
{
if (rblType.SelectedValue == "S")
{
if (txtstbno.Text.Trim() == "")
{
PopMsgBoxErr.Show();
lblInformation.Text = "Please enter STB No.";
return;
}
}
if (rblType.SelectedValue == "B")
{
if (FileUpload1.HasFile == false)
{
PopMsgBoxErr.Show();
lblInformation.Text = "Please Upload File";
return;
}
}
if (ViewState["STBrate"] == null)
{
ViewState["STBrate"] = "0";
}
popMsgBox.Show();
lblMsg.Text = "Are You Sure, Total STB Rate :" + ViewState["STBrate"].ToString();
}
protected void BtnSubmit_Click(object sender, EventArgs e)
{
if (txtremark.Text.Trim() == "")
{
PopMsgBoxErr.Show();
lblerror.Text = "Please enter remark";
return;
}
popMsgBox.Show();
btncnfmBlck.Visible = true;
lblResponseMsg.Text = "Are You Sure?";
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Master.PageHeading = "STB Transfer Admin Approval";
if (Session["username"] != null)
{
string strCon = ConfigurationSettings.AppSettings["conString"].ToString().Trim();
OracleConnection con = new OracleConnection(strCon);
string query = "";
query += " select num_stbtransfer_id transid, var_stbtransfer_stbno stbno,var_stbtransfer_lcocode lco,num_stbtransfer_stbamount amount,var_stbtransfer_adminlevel,";
query += " date_stbtransfer_insdate insdate from AOUP_LCOPRE_STBTRANSFER_MST where var_stbtransfer_translcocode='" + Session["username"].ToString() + "' and var_stbtransfer_status is null ";
query += " and (var_stbtransfer_adminlevel='Y' and var_stbtransfer_adminstatus is null)";
OracleCommand cmd = new OracleCommand(query, con);
OracleDataAdapter DaObj = new OracleDataAdapter(cmd);
DataTable dt = new DataTable();
DaObj.Fill(dt);
if (dt.Rows.Count > 0)
{
pnllcoconformation.Visible = true;
grdSTBSwap.DataSource = dt;
grdSTBSwap.DataBind();
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");
RdoAccept.Checked = true;
RdoAccept.GroupName = "Group" + i.ToString();
RdoCancel.GroupName = "Group" + i.ToString();
}
}
else
{
pnllcoconformation.Visible = false;
ViewState["ErrorInfo"] = "9999";
PopMsgBoxErr.Show();
lblinfo.Text = "No record found";
}
}
}
}
//
protected void btnOK_Click(object sender, EventArgs e)
{
if (ViewState["Erorcode"] != null)
{
if (ViewState["Erorcode"].ToString() == "9999")
{
Response.Redirect("../Reports/EcafPages.aspx");
}
else
{
PopMsgBoxErr.Hide();
}
}
else
{
PopMsgBoxErr.Hide();
}
}
protected void btncnfmBlck_Click(object sender, EventArgs e)
{
try
{
string strCon = ConfigurationSettings.AppSettings["conString"].ToString().Trim();
OracleConnection con = new OracleConnection(strCon);
if (lblstbrate.Text == "0")
{
PopMsgBoxErr.Show();
lblInformation.Text = "STB Rate can not be 0";
return;
}
if (rblType.SelectedValue == "S")
{
string cur_time = DateTime.Now.ToString("dd-MMM-yyyy_hhmmss");
Random random = new Random();
string RefId = "REF" + "_" + cur_time + "_" + random.Next(1000, 9999);
if (txtstbno.Text == "")
{
PopMsgBoxErr.Show();
lblInformation.Text = "Please enter STB No.";
return;
}
string Getstb = "select account_no,lco_code from VIEW_HWCAS_BRM_CUST_MASTER where stb='" + txtstbno.Text.Trim() + "' and connection_type='CHILD' ";
OracleCommand cmd = new OracleCommand(Getstb, con);
OracleDataAdapter DaObj = new OracleDataAdapter(cmd);
DataTable dt = new DataTable();
DaObj.Fill(dt);
if (dt.Rows.Count == 0)
{
PopMsgBoxErr.Show();
lblInformation.Text = "No data found";
return;
}
string in_translcoCode = dt.Rows[0]["lco_code"].ToString();
if (in_translcoCode == Session["username"].ToString())
{
PopMsgBoxErr.Show();
lblInformation.Text = "STb belongs to same LCO";
return;
}
string in_translcocity = "";
string in_translcoDAS = "";
Hashtable ht = new Hashtable();
ht.Add("in_stb", txtstbno.Text.Trim());
ht.Add("in_lcoCode", Session["username"].ToString());
ht.Add("in_translcoCode", in_translcoCode);
ht.Add("in_translcocity", in_translcocity);
ht.Add("in_translcoDAS", in_translcoDAS);
ht.Add("in_amount", lblstbrate.Text);
ht.Add("in_RefId", RefId);
ht.Add("in_operid", Session["operator_id"].ToString());
Cls_BLL_ecafstbtransfer obj = new Cls_BLL_ecafstbtransfer();
string response = obj.InsertDetails(Session["username"].ToString(), ht);
string[] responseArr = response.Split('$');
if (responseArr[0].ToString() == "9999")
{
ViewState["Erorcode"] = "9999";
}
PopMsgBoxErr.Show();
lblInformation.Text = responseArr[1].ToString();
return;
}
else
{
string cur_time = DateTime.Now.ToString("dd-MMM-yyyy_hhmmss");
Random random = new Random();
string RefId = "REF" + "_" + cur_time + "_" + random.Next(1000, 9999);
if (FileUpload1.HasFile == true)
{
DateTime dd = DateTime.Now;
string datetime = dd.Day + "" + dd.Month + "" + dd.Year + "" + dd.Hour + "" + dd.Minute + "" + dd.Second;
String Path = Server.MapPath("~//ImageGarbage") + "\\" + datetime + "STbTransfer";
if (FileUpload1.HasFile)
{
FileUpload1.SaveAs(Path + ".txt");
}
string[] lines = System.IO.File.ReadAllLines(Path + ".txt");
if (lines.Length > 1000)
{
lblResponseMsg.Text = "Records should not be greater than 1000";
return;
}
DataTable dtResponse = new DataTable();
foreach (string STBNo in lines)
{
if (dtResponse.Columns.Contains("STBNo"))
{
}
else
{
dtResponse.Columns.Add("STBNo");
}
dtResponse.Rows.Add(STBNo);
}
if (dtResponse.Rows.Count > 0)
{
DataTable distinct = dtResponse.DefaultView.ToTable(true, "STBNo");
if (distinct.Rows.Count == dtResponse.Rows.Count)
{
//there are no duplicates
}
else
{
PopMsgBoxErr.Show();
lblInformation.Text = "Duplicate STB not allowed";
return;
}
}
foreach (string STBNo in lines)
{
string Getstb = " select account_no,lco_code from VIEW_HWCAS_BRM_CUST_MASTER where stb='" + STBNo + "'";
OracleCommand cmd = new OracleCommand(Getstb, con);
OracleDataAdapter DaObj = new OracleDataAdapter(cmd);
DataTable dt = new DataTable();
DaObj.Fill(dt);
if (dt.Rows.Count == 0)
{
PopMsgBoxErr.Show();
lblInformation.Text = "No data found";
return;
}
else
{
string in_translcoCode = dt.Rows[0]["lco_code"].ToString();
if (in_translcoCode == Session["username"].ToString())
{
PopMsgBoxErr.Show();
lblInformation.Text = "LCO belongs to same City";
return;
}
string in_translcocity = "";
string in_translcoDAS = "";
Hashtable ht = new Hashtable();
ht.Add("in_stb", STBNo);
ht.Add("in_lcoCode", Session["username"].ToString());
ht.Add("in_translcoCode", in_translcoCode);
ht.Add("in_translcocity", in_translcocity);
ht.Add("in_translcoDAS", in_translcoDAS);
ht.Add("in_amount", lblstbrate.Text);
ht.Add("in_RefId", RefId);
ht.Add("in_operid", Session["operator_id"].ToString());
Cls_BLL_ecafstbtransfer obj = new Cls_BLL_ecafstbtransfer();
string response = obj.InsertDetails(Session["username"].ToString(), ht);
string[] responseArr = response.Split('$');
PopMsgBoxErr.Show();
lblInformation.Text = responseArr[1].ToString();
}
}
}
else
{
PopMsgBoxErr.Show();
lblInformation.Text = "Please Upload File";
return;
}
}
}
catch (Exception ex)
{
lblResponseMsg.Text = ex.Message;
}
}
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";
}
