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