protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { #region "MSISDN" try { if (string.IsNullOrEmpty(oUAProfile.GetMSISDN()) || oUAProfile.GetMSISDN().StartsWith("Error")) { throw new Exception(); } else { sMsisdn = oUAProfile.GetMSISDN(); subSmsisdn = sMsisdn.Substring(0, 5); ViewState["msisdn"] = sMsisdn; } } catch //(Exception ex) { sMsisdn = string.Empty; subSmsisdn = string.Empty; } //sMsisdn = "8801955279938"; #endregion "MSISDN" string UAPROF_URL = Request.UserAgent; try { HSProfiling.Service test = new HSProfiling.Service(); UAProfile ua = new UAProfile(); var HSProfiling = test.HansetDetection(UAPROF_URL, ua.GetUAProfileXWap()); HS_MANUFAC = HSProfiling.Manufacturer; HS_MOD = HSProfiling.Model; HS_DIM = HSProfiling.Dimension; HS_OS = HSProfiling.OS; UAPROF_URL = HSProfiling.UAXML; Session["HSOS"] = HS_OS; } catch { } string scriptForBl = @" $(document).ready(function() { $('.robititle').css('background-color','#F16521'); });"; string scriptForTT = @" $(document).ready(function() { $('.robititle').css('background-color','#71BD44'); });"; if (sMsisdn.StartsWith("88015")) { cssTemplate.Attributes.Add("href", "~/Css/StyleSheetTT.css"); ScriptManager.RegisterStartupScript(this, this.GetType(), "myScriptName", scriptForTT, true); } else if (sMsisdn.StartsWith("88019")) { cssTemplate.Attributes.Add("href", "~/Css/StyleSheetBL.css"); ScriptManager.RegisterStartupScript(this, this.GetType(), "myScriptName", scriptForBl, true); if (isSubscribe(sMsisdn)) { cancelSubscriptionBlink.Visible = true; } } else if (sMsisdn.StartsWith("88016")) { cssTemplate.Attributes.Add("href", "~/Css/StyleSheet.css"); // ScriptManager.RegisterStartupScript(this, this.GetType(), "myScriptName", scriptForBl, true); } else if (sMsisdn.StartsWith("88018")) { Response.Redirect("Restricted.aspx"); } else { cssTemplate.Attributes.Add("href", "~/Css/StyleSheetBL.css"); ScriptManager.RegisterStartupScript(this, this.GetType(), "myScriptName", scriptForBl, true); } string key = String.Empty; if (Request.Params["key"] != null) { key = Request.Params["key"].ToString(); Session["KEY"] = key; } string flagAccess = "0"; if (Session["flagAccess"] != null) { flagAccess = Session["flagAccess"].ToString(); } CA.ExecuteNonQuery("EXEC [Partner_Basket].[dbo].[sp_SetPortalAccess]'" + SOURCE_URL + "','" + sMsisdn + "','" + HS_MANUFAC + "','" + HS_MOD + "','" + HS_DIM + "','" + APN + "','VDOPortal','','" + oUAProfile.GetUserIP() + "','" + HS_OS + "'", "WAPDB"); if (!String.IsNullOrEmpty(key) && flagAccess == "0") { string accessKey = CA.getSingleValue("Exec spGET_OA_ACCESS'" + SOURCE_URL + "','BDTube','" + sMsisdn + "','" + HS_MANUFAC + "','" + HS_MOD + "','" + HS_DIM + "','" + APN + "','VDOPortal','" + key + "','" + oUAProfile.GetUserIP() + "','" + HS_OS + "'", "WAPDB").ToString(); Session["Accesskey"] = accessKey; Session["flagAccess"] = "1"; } Slider(); Fullvideo(); Shortvideo(); Fullmovie(); Newvideo(); BanglaNatok(); if (string.IsNullOrEmpty((sMsisdn))) { Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", " function callFunction() { $('#myModal').modal('hide');$('#myModal2').modal('hide'); $('#myModal3').modal('show'); }", true); } if (!string.IsNullOrEmpty((sMsisdn))) { lblNumber.Text = sMsisdn; lblNumber.Visible = true; lblNumber2.Visible = true; lblNumber2.Text = sMsisdn; } } //Session.Clear(); // Session.RemoveAll(); //Session.Abandon(); }
protected void Page_Load(object sender, EventArgs e) { // Year.Text = DateTime.Now.Year.ToString(); if (!IsPostBack) { #region UAProfile_AND_Banner #region "MSISDN" try { if (string.IsNullOrEmpty(oUAProfile.GetMSISDN()) || oUAProfile.GetMSISDN().StartsWith("Error")) { throw new Exception(); } else { sMsisdn = oUAProfile.GetMSISDN(); } } catch //(Exception ex) { sMsisdn = string.Empty; } #endregion "MSISDN" string UAPROF_URL = oUAProfile.GetUserAgent(); try { HSProfiling.Service Profile = new HSProfiling.Service(); //HSProfiling. Profile = new HS_Profiling.ServiceSoapClient(); var HSProfiling = Profile.HansetDetection(UAPROF_URL, oUAProfile.GetUAProfileXWap()); HS_MANUFAC = HSProfiling.Manufacturer; HS_MOD = HSProfiling.Model; HS_DIM = HSProfiling.Dimension; HS_OS = HSProfiling.OS; UAPROF_URL = HSProfiling.UAXML; } catch { } lblHandset.Text = " " + HS_MANUFAC + " " + HS_MOD; //hlHome.NavigateUrl = "~/Default.aspx"; //hlSupport.NavigateUrl = "~/Support.aspx"; string scriptForBl = @" $(document).ready(function() { $('.robititle').css('background-color','#58C1E6'); });"; cssTemplate.Attributes.Add("href", "~/Css/StyleSheetBL.css"); ScriptManager.RegisterStartupScript(this, this.GetType(), "myScriptName", scriptForBl, true); #region "TopHeader" try { if (string.IsNullOrEmpty(HS_DIM)) { throw new Exception(); } else { FOLDER = "D" + HS_DIM; } } catch //(Exception ex) { FOLDER = "D320x240"; } #endregion "TopHeader" object dim = oCDA.getSingleValue("EXEC spGetDimensionByCategoryCode'" + "3F0996CC-94DB-4C87-8EEE-790D79C42593" + "','" + FOLDER + "'", "WAPDB"); if (dim != null) { if (dim.ToString() == "Y") { sPath = "http://wap.shabox.mobi/CMS/UIHeader/" + FOLDER + "/"; } else if (dim.ToString() == "N") { string bestfitCat = oUAProfile.ClosestMinimumFinder(HS_DIM, "Wallpaper"); sPath = "http://wap.shabox.mobi/CMS/UIHeader/" + bestfitCat + "/"; } } else { sPath = "~http://wap.shabox.mobi/CMS/UIHeader/D320x240/"; } if (sMsisdn.StartsWith("88015")) { lnkHeader.ImageUrl = sPath + "BD_Tub_Header_TT.jpg"; cssTemplate.Attributes.Add("href", "~/StyleSheet/StyleSheetTT.css"); } else if (sMsisdn.StartsWith("88018")) { lnkHeader.ImageUrl = sPath + "Robi_bdtube_header.jpg"; cssTemplate.Attributes.Add("href", "~/StyleSheet/StyleSheetRobi.css"); } else if (sMsisdn.StartsWith("88016")) { lnkHeader.ImageUrl = sPath + "Robi_bdtube_header.jpg"; cssTemplate.Attributes.Add("href", "~/StyleSheet/StyleSheetRobi.css"); } else if (sMsisdn.StartsWith("88017")) { lnkHeader.ImageUrl = sPath + "BD_Tub_Header_GP.jpg"; //scrollBanner.ImageUrl = sPath + "BD_Tub_Header_Header.jpg"; cssTemplate.Attributes.Add("href", "~/StyleSheet/StyleSheetGP.css"); } else if (sMsisdn.StartsWith("88019")) { lnkHeader.ImageUrl = sPath + "BDtube.jpg"; } else { lnkHeader.ImageUrl = sPath + "BDtube.jpg"; } //lnkHeader.ImageUrl = sPath + "BDtube.jpg"; //lnkHeader.NavigateUrl = "~/Default.aspx"; //lnkFooter.ImageUrl = sPath + "Shabox_Buddy_Footer.jpg"; //lnkFooter.NavigateUrl = "~/Default.aspx"; #endregion UAProfile_AND_Banner DataSet dsWord = oCDA.GetDataSet("SELECT TOP (20) MSISDN, CONTENT_TITLE, CONTENT_TYPE_SHORT, CAST (TIME_STAMP AS datetime) AS Date, ChargingReply FROM tbl_Success_BDTUBE WHERE (MSISDN = '" + sMsisdn + "') ORDER BY TIME_STAMP DESC", "BDTUBE"); if (dsWord != null) { RptTopScore.DataSource = dsWord.Tables[0].Rows; RptTopScore.DataBind(); } //DataSet subStatusData = oCDA.GetDataSet("SELECT MSISDN, RegDate, ReActivationDate, DeactivationDate FROM tbl_Subscriber_BDTUBE WHERE (MSISDN = '" + sMsisdn + "') ORDER BY TimeStamp DESC", "BDTUBE"); DataSet subStatusData = oCDA.GetDataSet("EXEC[Partner_Basket].[dbo].[spSubStatus] '" + sMsisdn + "'", "BDTUBE"); if (subStatusData != null) { subStatus.DataSource = subStatusData.Tables[0].Rows; subStatus.DataBind(); } } if ((sMsisdn.StartsWith("88019") || sMsisdn.StartsWith("88018")) && isSubscribe(sMsisdn)) { //cancelSubscription.Visible = true; } }
private string SubscriberStatus(string MSISDN) { MSISDN = oUAProfile.Decode(MSISDN); string Status = string.Empty; //STEP2: Subscriber Exist or not object IsUser = CA.getSingleValue("Select RegDate from [DPDP].[dbo].[tblBase] where MSISDN= '" + MSISDN + "' AND RegStatus!=0 AND serviceID=13", "DPDP"); if (IsUser != null) //If Subscriber Exist { DateTime LastChg_dt = Convert.ToDateTime(IsUser); DateTime CurrentDate = System.DateTime.Now.Date; DateTime NextDate = CurrentDate.AddHours(-24); if (LastChg_dt.Date < NextDate) //Chk 48 Hr Charging Status { //IF:NO CHARGING STAUS FOUND:Charging Here Then Display the Content //string ReplyCGW = CGW(MSISDN); //STEP3: CHARGING; MACHANISM string ReplyCGW = "SUCCESSFUL"; //STEP3: CHARGING; MACHANISM if (ReplyCGW == "SUCCESSFUL") { Status = "Y"; if (sMsisdn.StartsWith("88017")) { CA.ExecuteNonQuery("EXEC [Partner_API].[dbo].[spProcessRequestOnlineAdvertisement] '" + sMsisdn + "','SB'", "WAPDB"); } else { CA.ExecuteNonQuery("EXEC Sp_UPDATE_SUBSCRIBER_STATUS_BY_ONLINE_CHARGING '" + MSISDN + "'", "SBDB"); } } else { Status = "Y"; //lblMsg.ForeColor = Color.Red; //lblMsg.Text = "Your registration is temporayly block.Please top up your account & visit again."; } } else //SUBSCRIPTION CHARGING OCCURED & SUBSCRIBER LIVE FOR GET CONTENT { Status = "Y"; } } else //FOR NEW SUBSCRIBER { if (MSISDN.StartsWith("88017")) { Status = "Y"; } try { string GPBC = Request.QueryString["source"].ToString(); if (GPBC == "GP") { GPURL = "&source=GP"; } } catch { } //string ReplyCGW = CGW(MSISDN); //if (ReplyCGW == "SUCCESSFUL") //{ // Status = "Y"; // oCDA.ExecuteNonQuery("EXEC ShaboxBuddy.dbo.spInsertSubscriberBuddy 1"+",'"+sMsisdn+"','"+HS_MANUFAC+"','"+HS_MOD+"','"+ "WAP"+"','1','"+"1"+"','"+System.DateTime.Now+"'", "SBDB"); //} //else // ENTRY SUBSCRIBER WHITHOUT CHARGING BUT WILL TRY TO CHARGE NEXT DAY / NEXT VISIT //{ // Status = "N"; // oCDA.ExecuteNonQuery("EXEC ShaboxBuddy.dbo.spInsertSubscriberBuddy 1" + ",'" + sMsisdn + "','" + HS_MANUFAC + "','" + HS_MOD + "','" + "WAP" + "','-1','" + "0" + "','" + System.DateTime.Now + "'", "SBDB"); //} // Charging & Insert Into Subscriber Table. } return(Status); }