public void PROMOTIONALLINK() { StringBuilder sb = new StringBuilder(); string URL = "", region = ""; region = Request.Form["region"]; string conn = System.Configuration.ConfigurationManager.AppSettings["gamingnetAdsenseconn"]; //new code 16/03/2015 if (region == "GB") { sb.Append(string.Format("<option value='{0}'>{1}</option>", "0", "Select GB Promotional Link")); } else { sb.Append(string.Format("<option value='{0}'>{1}</option>", "0", "Select AU Promotional Link")); } try { DataTable dt = new DataTable(); using (newsliveupdatemgmt objpromo = new newsliveupdatemgmt(conn)) { dt = objpromo.GetPromotionalLink(region); } //dt=obj.GetDataTable("SELECT LinkName+' (added '+Convert(varchar(10),Addedon,104)+')' as LinkName,shortenurl,RandomUniqueId as LinkID FROM OfferLinkManager where isactive='Y' and region='"+region+"' Order by LinkName"); if (dt.Rows.Count > 0) { foreach (DataRow r in dt.Rows) { URL = ""; try { if (r["shortenurl"].ToString().Trim().StartsWith("f.ast.bet/go")) { URL = string.Format("http://{0}", r["shortenurl"].ToString().Trim()); } else { URL = string.Format("//www.caledonianmedia.com/promotionalstat.aspx?siteurl={0}&siteid={1}", r["LinkID"].ToString(), Session["liveupdatesiteid"].ToString()); } } catch { URL = ""; } if (URL.Length > 1) { sb.Append(string.Format("<option value='{0}'>{1}</option>", URL, r["LinkName"].ToString())); } } } } catch (Exception ex) { CommonLib.ExceptionHandler.WriteLog(CommonLib.Sections.BLL, "ajaxpost.aspx.cs RefreshCache", ex); } ltresult.Text = sb.ToString(); sb = null; }
public void GetNewsLiveUpdateList() { networkid = Request.QueryString["networkid"]; siteid = Request.QueryString["siteid"]; userid = Request.QueryString["userid"]; DataTable dt = new DataTable(); try { StringBuilder sb = new StringBuilder(); using (newsliveupdatemgmt obj = new newsliveupdatemgmt(networkconn)) { dt = obj.GetNewsLiveUpdateList(Request.QueryString["newsid"], Request.QueryString["siteid"]); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { sb.Append("<tr >"); sb.Append(string.Format("<td align= 'left' bgcolor='#FFFFFF' valign='middle' style='font-family:verdana;font-size:11px;'><input type='checkbox' id='{0}' class='source' value='{0}' name = 'fcheck[]'></div></td>", dr["Id"].ToString())); sb.Append(string.Format("<td align= 'left' bgcolor='#FFFFFF' valign='middle' style='font-family:verdana;font-size:11px;'>{0}</td>", dr["title"].ToString())); sb.Append("<td class='text' align='center' bgcolor='#FFFFFF' valign='middle' style='font-family:verdana;font-size:11px;'><a title='click to manage' class='editlink' href='addnewsliveupdate.aspx?id=" + dr["Id"].ToString() + "&networkid=" + networkid + "&siteid=" + siteid + "&userid=" + dr["UID"].ToString() + "&newsid=" + dr["newsid"].ToString() + "'>Edit</a></td>"); sb.Append(string.Format("<td align= 'left' bgcolor='#FFFFFF' valign='middle' style='font-family:verdana;font-size:11px;'>{0}</td>", Convert.ToDateTime(dr["startdate"]).ToString("dd-MM-yyyy HH:mm tt"))); if (dr["ishighlight"].ToString() == "Y") { sb.Append(string.Format("<td align= 'center' bgcolor='#FFFFFF' valign='middle' style='font-family:verdana;font-size:11px;'>{0}</td>", "<img src='http://www.writersllc.com/images/icon_status_green.gif' />")); } else { sb.Append(string.Format("<td align= 'center' bgcolor='#FFFFFF' valign='middle' style='font-family:verdana;font-size:11px;'>{0}</td>", "<img src='http://www.writersllc.com/images/icon_status_red.gif' />")); } if (dr["ispin"].ToString() == "Y") { sb.Append(string.Format("<td align= 'center' bgcolor='#FFFFFF' valign='middle' style='font-family:verdana;font-size:11px;'>{0}</td>", "<img src='http://www.writersllc.com/images/icon_status_green.gif' />")); } else { sb.Append(string.Format("<td align= 'center' bgcolor='#FFFFFF' valign='middle' style='font-family:verdana;font-size:11px;'>{0}</td>", "<img src='http://www.writersllc.com/images/icon_status_red.gif' />")); } sb.Append(string.Format("<td align= 'left' bgcolor='#FFFFFF' valign='middle' style='font-family:verdana;font-size:11px;'>{0}</td>", Convert.ToDateTime(dr["addedon"]).ToString("dd-MM-yyyy HH:mm tt"))); sb.Append(string.Format("<td align= 'left' bgcolor='#FFFFFF' valign='middle' style='font-family:verdana;font-size:11px;'>{0}</td>", dr["Name"].ToString())); sb.Append("</tr>"); } } else { sb.Append("<tr><td style='color:red' colspan='7'>record not found </td></tr>"); } ltlist.Text = sb.ToString(); } } catch (Exception ex) { CommonLib.ExceptionHandler.WriteLog(CommonLib.Sections.BLL, "addnewliveupdate.aspx.cs GetNewsLiveUpdateList", ex); } }
public void FillPromoLink() { string URL = ""; string strconn = System.Configuration.ConfigurationManager.AppSettings["gamingnetAdsenseconn"]; //new code 16/03/2015 try { DataTable dt = new DataTable(); //dt=obj.GetDataTable("SELECT LinkName+' (added '+Convert(varchar(10),Addedon,104)+')' as LinkName,shortenurl,RandomUniqueId as LinkID FROM OfferLinkManager where isactive='Y' and region='GB' Order by LinkName"); using (newsliveupdatemgmt objpromo = new newsliveupdatemgmt(strconn)) { dt = objpromo.GetPromotionalLink("GB"); } if (dt.Rows.Count > 0) { foreach (DataRow r in dt.Rows) { URL = ""; try { if (r["shortenurl"].ToString().Trim().StartsWith("f.ast.bet/go")) { URL = string.Format("http://{0}", r["shortenurl"].ToString().Trim()); } else { URL = string.Format("//www.caledonianmedia.com/promotionalstat.aspx?siteurl={0}&siteid={1}", r["LinkID"].ToString(), Session["liveupdatesiteid"].ToString()); } } catch { URL = ""; } if (URL.Length > 1) { sellink.Items.Add(new ListItem(r["LinkName"].ToString(), URL)); } } } sellink.Items.Insert(0, new ListItem("--Select--", "0")); } catch (Exception ex) { CommonLib.ExceptionHandler.WriteLog(CommonLib.Sections.BLL, "modelIframepromotiolink.aspx.cs FillPromoLink", ex); } }
public void FillPromoLink(string region) { string URL = ""; try { DataTable dt = new DataTable(); string conn = System.Configuration.ConfigurationManager.AppSettings["gamingnetAdsenseconn"]; using (newsliveupdatemgmt objpromo = new newsliveupdatemgmt(conn)) { dt = objpromo.GetPromotionalLink(region); } if (dt.Rows.Count > 0) { foreach (DataRow r in dt.Rows) { URL = ""; try { if (r["shortenurl"].ToString().Trim().StartsWith("f.ast.bet/go")) { URL = string.Format("http://{0}", r["shortenurl"].ToString().Trim()); } else { URL = string.Format("//www.caledonianmedia.com/promotionalstat.aspx?siteurl={0}&siteid={1}", r["LinkID"].ToString(), Session["liveupdatesiteid"].ToString()); } } catch { URL = ""; } if (URL.Length > 1) { ddlpromolink.Items.Add(new ListItem(r["LinkName"].ToString(), URL)); } } } } catch (Exception ex) { CommonLib.ExceptionHandler.WriteLog(CommonLib.Sections.BLL, "addnewliveupdate.aspx.cs FillPromoLink", ex); } }
public void GetDetails(string id) { try { networkid = Request.QueryString["networkid"]; networkconn = System.Configuration.ConfigurationManager.AppSettings[networkid]; using (newsliveupdatemgmt obj = new newsliveupdatemgmt(networkconn)) { DataTable dt = new DataTable(); dt = obj.GetNewsLiveUpdateDetails(id); if (dt.Rows.Count > 0) { textTitle.Text = dt.Rows[0]["title"].ToString(); ltback3.Text = dt.Rows[0]["description"].ToString(); txtstartdate.Text = Convert.ToDateTime(dt.Rows[0]["startdate"]).ToString("dd/MM/yyyy HH:mm"); ddlregion.SelectedValue = dt.Rows[0]["region"].ToString(); if (dt.Rows[0]["ishighlight"].ToString() == "Y") { chkhighlight.Checked = true; } else { chkhighlight.Checked = false; } txtimgtext.Text = dt.Rows[0]["imagebelowtext"].ToString(); if (dt.Rows[0]["image"].ToString() != "") { string imgpath = Gettyclasses.commonfn._baseURL + "newsliveupdate/" + dt.Rows[0]["image"].ToString(); ltimg.Text = "<img id='imggetty' src='" + imgpath + "' height='50px' width='50px'/>"; ViewState["img"] = dt.Rows[0]["image"].ToString(); } sellink.SelectedValue = dt.Rows[0]["linkid"].ToString(); ddlpromoregion.Value = dt.Rows[0]["promoregion"].ToString(); FillPromoLink(ddlpromoregion.Value); ddlpromolink.Value = dt.Rows[0]["promolink"].ToString(); txtexternallink.Text = dt.Rows[0]["externallink"].ToString(); ddltargetto.SelectedValue = dt.Rows[0]["targetto"].ToString(); } } } catch (Exception ex) { CommonLib.ExceptionHandler.WriteLog(CommonLib.Sections.BLL, "addnewliveupdate.aspx.cs GetDetails", ex); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { ltimg.Text = "<img ID='imggetty' src='' />"; try { autime = DateTime.UtcNow.AddHours(Convert.ToDouble(hdnAU.Value)).ToString("dd/MM/yyyy HH:mm"); uktime = DateTime.Now.ToString("dd/MM/yyyy HH:mm"); txtstartdate.Text = DateTime.Now.ToString("dd/MM/yyyy HH:mm"); siteurl = Request.QueryString["siteurl"]; baseurl = commonfn._baseURL; networkid = Request.QueryString["networkid"]; siteid = Request.QueryString["siteid"]; newsid = Request.QueryString["newsid"]; userid = Request.QueryString["userid"]; newstitle = Request.QueryString["title"]; networkconn = System.Configuration.ConfigurationManager.AppSettings[networkid]; Session["liveupdatesiteid"] = siteid; Session["liveupdateconn"] = networkconn; using (newsliveupdatemgmt obj = new newsliveupdatemgmt(networkconn)) { txtHeader.Text = obj.GetLiveUpdateHeader(newsid); } FillLinks(Session["liveupdatesiteid"].ToString()); if (Request.QueryString["operation"] == "list") { GetNewsLiveUpdateList(); } else { if (Request.QueryString["id"] != null) { GetDetails(Request.QueryString["id"]); } } } catch (Exception ex) { CommonLib.ExceptionHandler.WriteLog(CommonLib.Sections.BLL, "addnewliveupdate.aspx.cs !Page.IsPostBack", ex); } } }
public void FillLinks(string siteid) { DataTable dt = new DataTable(); try { using (newsliveupdatemgmt obj = new newsliveupdatemgmt(Session["liveupdateconn"].ToString())) { dt = obj.GetLinks(siteid); if (dt.Rows.Count > 0) { sellink.DataSource = dt; sellink.DataTextField = "LinkName"; sellink.DataValueField = "LinkID"; sellink.DataBind(); } sellink.Items.Insert(0, new ListItem("-select-", "0")); } } catch (Exception ex) { CommonLib.ExceptionHandler.WriteLog(CommonLib.Sections.BLL, "modelframelink8.aspx.cs FillLinks", ex); } }
protected void btnsave_click(object sender, EventArgs e) { int count = 0; string imagename = ""; try { networkid = Request.QueryString["networkid"]; networkconn = System.Configuration.ConfigurationManager.AppSettings[networkid]; using (newsliveupdatemgmt obj = new newsliveupdatemgmt(networkconn)) { if (file1.HasFile) { imagename = string.Format("{0}{1}", DateTime.Now.ToString("ddMMyyhhmmss"), Path.GetExtension(file1.FileName)); file1.SaveAs(Server.MapPath("~/newsliveupdate/") + imagename); file1.Dispose(); } else { if (ViewState["img"] != null) { imagename = ViewState["img"].ToString(); } } if (!string.IsNullOrEmpty(Request.Form["hdngettyimg"].ToString())) { imagename = Request.Form["hdngettyimg"].ToString(); } if (!string.IsNullOrEmpty(imagename)) { try { string imgpath = MapPath("~/newsliveupdate/" + imagename); int widthAct = System.Drawing.Image.FromFile(imgpath).Width; if (widthAct > 600) { imagename = Function.SaveThumbnailCompress(imagename, HttpContext.Current.Server.MapPath("~/newsliveupdate/"), "TN_", 600, 402); } } catch { } } obj.NewsId = Request.QueryString["newsid"]; obj.Title = textTitle.Text; obj.Description = Request.Form["templateText8"]; obj.Addedby = Request.QueryString["userid"]; obj.SiteId = Request.QueryString["siteid"]; obj.Image = imagename; obj.startdate = GetDate(txtstartdate.Text); obj.region = ddlregion.SelectedValue; if (Request.QueryString["Id"] != null) { obj.Id = Request.QueryString["Id"]; } else { obj.Id = "0"; } if (chkhighlight.Checked == true) { obj.ishighlight = "Y"; } else { obj.ishighlight = "N"; } obj.imagebelowtext = txtimgtext.Text; obj.LinkId = sellink.SelectedValue; obj.Promoregion = ddlpromoregion.Value; obj.PromoLink = Request.Form["ddlpromolink"]; obj.Externallink = txtexternallink.Text; obj.TargetTo = ddltargetto.SelectedValue; count = obj.SaveLiveNewsUpdate(); if (Request.QueryString["siteurl"] != null) { RefreshCache(Request.QueryString["siteurl"] + strgeneratexml); } Page.RegisterStartupScript("onsave", "<script>closePOP('" + count + "','" + obj.NewsId + "');</script>"); } } catch (Exception ex) { CommonLib.ExceptionHandler.WriteLog(CommonLib.Sections.BLL, "addnewliveupdate.aspx.cs btnsave_click", ex); } }