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