/// <summary> /// offer link history list /// </summary> /// <param name="pagesize"></param> /// <param name="currentpageno"></param> /// <param name="linkid"></param> private void OfferLinkHistoryList(int pagesize, int currentpageno, string linkid) { string txt = ""; try { DataTable dt = new DataTable(); using (OfferLinkMgmt obj = new OfferLinkMgmt(strconn)) { dt = obj.GetOfferLinkHistoryList(pagesize, currentpageno, linkid); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { txt += "<tr height='30' valign='top'>"; txt += "<td align= 'center' bgcolor='#FFFFFF' valign='middle' style='font-family:verdana;font-size:11px;'>" + dr["rownumber"].ToString() + "</td>"; txt += "<td class='text' align='left' style='padding-left:5px;' bgcolor='#FFFFFF' valign='middle' >" + dr["LinkName"].ToString() + " </td>"; txt += "<td class='text' align='left' style='padding-left:5px;' bgcolor='#FFFFFF' valign='middle' >" + dr["oldvalues"].ToString() + "</td>"; txt += "<td class='text' align='left' style='padding-left:5px;' bgcolor='#FFFFFF' valign='middle' >" + dr["newvalues"].ToString() + "</td>"; txt += "<td class='text' align='left' style='padding-left:5px;' bgcolor='#FFFFFF' valign='middle' >" + dr["action"].ToString() + "</td>"; txt += "<td class='text' align='left' style='padding-left:5px;' bgcolor='#FFFFFF' valign='middle' >" + dr["FullName"].ToString() + "</td>"; txt += "<td align= 'center' bgcolor='#FFFFFF' valign='middle' style='font-family:verdana;font-size:11px;' >" + DateTime.Parse(dr["actiondate"].ToString()).ToString("dd/MM/yyyy HH:mm") + "</td>"; txt += "</tr>"; } } else { txt = "<tr height='30' valign='top'><td class='error' align='center' bgcolor='#FFFFFF' valign='middle' style='padding-right:3px;' colspan='12'> No Records Found! </td></tr>"; } ltlist.Text = txt; if (Convert.ToInt32(obj.TotalCount) > 0) { ltpaging.Text = "<span class='error'>Page " + pagenumber + " of " + GetPages(Convert.ToInt32(obj.TotalCount)) + " </span> : " + getNavigationHTML(Convert.ToInt32(pagenumber), obj.TotalCount); } else { ltpaging.Text = ""; } } } catch (Exception ex) { CommonLib.ExceptionHandler.WriteLog(CommonLib.Sections.Admin, "OfferLink/ListOfferLinkHistory.aspx.cs OfferLinkHistoryList", ex); } }
public void GetAddedByuser(string userid) { StringBuilder sb = new StringBuilder(); string strconn = ConfigurationManager.AppSettings["Network1"]; string data = ""; try { using (OfferLinkMgmt obj = new OfferLinkMgmt(strconn)) { data = obj.Getusersname(userid); ltresult.Text = data; } } catch (Exception ex) { CommonLib.ExceptionHandler.WriteLog(CommonLib.Sections.Admin, "NewGamingnetAdmin/AjaxOfferLink.aspx.cs GetAssignedFreebetAddedByuser", ex); } }
public void UpdateOfferLink(string linkid, string linkname, string linkref, string cookieuri, string shortenurl, string oldvalue, string bitlyrel) { try { string strconn = ConfigurationManager.AppSettings["Iframaddsense"]; using (OfferLinkMgmt objlink = new OfferLinkMgmt(strconn)) { objlink.EditOfferLink(linkid, linkname.Trim(), linkref.Trim(), cookieuri, shortenurl, bitlyrel); objlink.NewValues = linkref; objlink.OldValues = oldvalue; objlink.Action = "Update"; objlink.Linkid = linkid; objlink.SaveOfferLinkHistory(); } } catch (Exception ex) { CommonLib.ExceptionHandler.WriteLog(CommonLib.Sections.Admin, "NewGamingnetAdmin/AjaxOfferLink.aspx.cs UpdateOfferLink", ex); } }
private void Page_Load(object sender, System.EventArgs e) { try { BaseUrl = ConfigurationManager.AppSettings["BaseURL"]; ltbaseurl.Text = BaseUrl.ToString(); ltbaseurl1.Text = BaseUrl.ToString(); ltbaseurl2.Text = BaseUrl.ToString(); strconn = ConfigurationManager.AppSettings["Iframaddsense"]; try { if (string.IsNullOrEmpty(BLL.LoginInfo.Userid)) { Response.Redirect(BLL.Constants.OldAdminUrl + "login.aspx", false); } } catch { Response.Redirect(BLL.Constants.OldAdminUrl + "login.aspx", false); } if (IsPostBack) { Session["txtsearch"] = txtsearch.Text; Session["datesort"] = ddlsort.SelectedValue; if (null != Request.QueryString["p"]) { pagenumber = Convert.ToInt32(Request.QueryString["p"].ToString()); } else { pagenumber = 1; } Session["region"] = ddlregion.SelectedValue; OfferLinkList(pagesize, pagenumber, Session["txtsearch"].ToString(), Session["region"].ToString(), Session["datesort"].ToString()); } else { if (Session["datesort"] == null) { ddlsort.SelectedValue = "adddesc"; Session["datesort"] = "adddesc"; } if (Session["txtsearch"] != null) { txtsearch.Text = Session["txtsearch"].ToString(); } else { Session["txtsearch"] = ""; } if (Session["region"] != null) { ddlregion.SelectedValue = Session["region"].ToString(); } else { Session["region"] = "0"; } if (Request.QueryString["clear"] != null) { txtsearch.Text = ""; Session["txtsearch"] = ""; Session["region"] = "0"; ddlregion.SelectedValue = "0"; } if (null != Request.QueryString["aprids"] && null != Request.QueryString["re"]) { using (OfferLinkMgmt obj = new OfferLinkMgmt(strconn)) { obj.ChangeOfferLinkStatus(Request.QueryString["aprids"].ToString(), Request.QueryString["re"].ToString()); if (Request.QueryString["re"] == "D") { obj.AddDeletedBy(Request.QueryString["aprids"]); } switch (Request.QueryString["re"]) { case "Y": obj.Action = "Activate"; break; case "N": obj.Action = "Deactivate"; break; case "D": obj.Action = "Delete"; break; } string strids = Request.QueryString["aprids"].ToString(); string[] strarray = strids.Split(','); if (strarray.Length > 0) { for (int i = 0; i < strarray.Length; i++) { obj.Linkid = strarray[i]; obj.SaveOfferLinkHistory(); } } Response.Redirect("ListOfferLinks.aspx"); } } disp_labels(); Session["txtsearch"] = txtsearch.Text; if (null != Request.QueryString["p"]) { pagenumber = Convert.ToInt32(Request.QueryString["p"].ToString()); } else { pagenumber = 1; } OfferLinkList(pagesize, pagenumber, Session["txtsearch"].ToString(), Session["region"].ToString(), Session["datesort"].ToString()); } } catch (Exception ex) { CommonLib.ExceptionHandler.WriteLog(CommonLib.Sections.Admin, "OfferLink/ListOfferLinks.aspx.cs Page_Load", ex); } }
/// <summary> /// Offer Link & william hill link List /// </summary> /// <param name="pagesize"></param> /// <param name="currentpageno"></param> /// <param name="search"></param> /// <param name="region"></param> /// <param name="datesort"></param> private void OfferLinkList(int pagesize, int currentpageno, string search, string region, string datesort) { string txt = ""; string tmp = ""; string str = ""; string lid = "0"; string urlhttp = ""; string color = ""; try { DataTable dt = new DataTable(); using (OfferLinkMgmt obj = new OfferLinkMgmt(strconn)) { dt = obj.GetOfferLinkList(pagesize, currentpageno, search, region, datesort); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { if (Convert.ToDateTime(dr["ExpireDate"].ToString()) <= DateTime.Now) { color = "#e1e1e1"; } else { color = "#FFFFFF"; } txt += "<tr height='30' valign='top'>"; txt += "<td bgcolor='" + color + "' style='text-align:center;font-family:verdana;font-size:11px;' align='center' valign='middle' style='padding-top:5px;'><input type ='checkbox' onclick='disselect()' name = 'fcheck[]' value='" + dr["linkID"].ToString() + "'></td>"; str = dr["linkname"].ToString(); lid = dr["LinkID"].ToString(); if (dr["linktype"].ToString().ToLower() == "w") { txt += "<td width='250px' align='left' style='padding-left:5px;color:#000000;font-family:verdana;font-size:11px;' bgcolor='" + color + "' valign='middle' nowrap title='" + dr["LinkName"].ToString() + "'><a href='AddEditWHLink.aspx?linkid=" + dr["LinkID"].ToString() + "' class='link'>" + str + "</a></br><span class='thread'>William Hill</span></td>"; } else { txt += "<td width='250px' align='left' style='padding-left:5px;color:#000000;font-family:verdana;font-size:11px;' bgcolor='" + color + "' valign='middle' nowrap title='" + dr["LinkName"].ToString() + "'><a href='AddEditOfferLink.aspx?linkid=" + dr["LinkID"].ToString() + "' class='link'>" + str + "</a></td>"; } txt += "<td align='center' style='padding-left:5px;color:#000000;font-family:verdana;font-size:11px;' bgcolor='" + color + "' valign='middle' nowrap>" + dr["LinkID"].ToString() + "</td>"; str = dr["linkreference"].ToString(); txt += "<td align='left' style='padding-left:5px;color:#000000;font-family:verdana;font-size:11px;' bgcolor='" + color + "' valign='middle'><a class='publink' href='" + dr["linkreference"].ToString() + "' target='_blank' id='" + lid + "_a' > " + str + " </a></td>"; if (dr["IsBetSlip"].ToString() == "Y") { urlhttp = "http://"; } else { urlhttp = ""; } txt += "<td align='left' style='padding-left:5px;color:#000000;font-family:verdana;font-size:11px;' bgcolor='" + color + "' valign='middle' nowrap><a class='publink' href='" + urlhttp + dr["shortenurl"].ToString().Trim() + "' target='_blank' id='" + lid + "_divbita'> " + dr["shortenurl"].ToString() + " </a></td>"; txt += "<td align='left' style='padding-left:5px;color:#000000;font-family:verdana;font-size:11px;' bgcolor='" + color + "' valign='middle'> " + dr["bitlyrelation"].ToString() + "</td>"; txt += "<td class='linktd' bgcolor='" + color + "' align= 'center' valign='middle' style='font-family:verdana;font-size:11px;color:#000000;'><span class='added' id='user_" + dr["LinkID"].ToString() + "' data-id='" + dr["addedby"].ToString() + "," + dr["modifiedby"].ToString() + "'></span></br><span id='deluser_" + dr["LinkID"].ToString() + "' class='thread' data-id='" + dr["LinkID"].ToString() + "_" + dr["deletedby"].ToString() + "'></span></td>"; txt += "<td align='left' style='padding-left:5px;color:#000000;font-family:verdana;font-size:11px;' bgcolor='" + color + "' valign='middle' nowrap>" + Convert.ToDateTime(dr["addedon"].ToString()).ToString("dd/MM/yyyy") + "</br>" + Convert.ToDateTime(dr["modifiedon"].ToString()).ToString("dd/MM/yyyy") + "</td>"; if (dr["IsExpire"].ToString() == "Y") { txt += "<td align='left' style='padding-left:5px;color:#000000;font-family:verdana;font-size:11px;' bgcolor='" + color + "' valign='middle' nowrap>" + Convert.ToDateTime(dr["ExpireDate"].ToString()).ToString("dd/MM/yyyy HH:mm") + "</td>"; } else { txt += "<td align='left' style='padding-left:5px;color:#000000;font-family:verdana;font-size:11px;' bgcolor='" + color + "' valign='middle' nowrap></td>"; } if (dr["IsActive"].ToString() == "N") { tmp = "<img src='../images/icon_status_red.gif' border='0'>"; } else { if (dr["IsActive"].ToString() == "D") { tmp = "<img src='../images/icon_status_blue.gif' border='0'>"; } else { tmp = "<img src='../images/icon_status_green.gif' border='0'>"; } } txt += "<td style='text-align:center;color:#000000;font-family:verdana;font-size:11px;' bgcolor='" + color + "' valign='middle'>" + tmp + "</td>"; txt += "<td align='center' style='color:#000000;font-family:verdana;font-size:11px;' bgcolor='" + color + "' valign='middle'><a title='click to view history' class='editlink' href='#' data-linkid='" + dr["LinkID"].ToString() + "'>View</a></td>"; txt += "</tr>"; } } else { txt = "<tr height='30' valign='top'><td class='error' align='center' bgcolor='#FFFFFF' valign='middle' style='padding-right:3px;' colspan='13'> No Records Found! </td></tr>"; } ltlist.Text = txt; if (Convert.ToInt32(obj.TotalCount) > 0) { ltpaging.Text = "<span class='error'>Page " + pagenumber + " of " + GetPages(Convert.ToInt32(obj.TotalCount)) + " </span> : " + getNavigationHTML(Convert.ToInt32(pagenumber), obj.TotalCount); } else { ltpaging.Text = ""; } } } catch (Exception ex) { CommonLib.ExceptionHandler.WriteLog(CommonLib.Sections.Admin, "OfferLink/ListOfferLinks.aspx.cs OfferLinkList", ex); } }
private void Page_Load(object sender, System.EventArgs e) { try { BaseUrl = ConfigurationManager.AppSettings["BaseURL"]; adsenseconn = ConfigurationManager.AppSettings["Iframaddsense"]; try { if (BLL.LoginInfo.Userid == null) { Response.Redirect(BLL.Constants.OldAdminUrl + "login.aspx", false); } } catch { Response.Redirect(BLL.Constants.OldAdminUrl + "login.aspx", false); } if (Request.QueryString["linkid"] != null) { ltheader.Text = "Edit William Hill - Your Odds"; lttop.Text = " Edit William Hill - Your Odds"; } else { ltheader.Text = "Add William Hill - Your Odds"; lttop.Text = " Add William Hill - Your Odds"; } validPage.Visible = false; dupli.Visible = false; Tr2.Visible = false; } catch (Exception ex) { CommonLib.ExceptionHandler.WriteLog(CommonLib.Sections.Admin, "OfferLink/AddEditWHLink.aspx.cs Page_Load", ex); } if (IsPostBack) { try { Page.Validate(); if (IsValid) { using (OfferLinkMgmt objlink = new OfferLinkMgmt(adsenseconn)) { string whurl = string.Format("{0}&sel={1}&stake={2}&url={3}", txtWhUrl.Text.Trim(), txtSel.Text.Trim(), txtStake.Text.Trim(), txtUrl.Text.Trim()); objlink.LinkName = txtLinkName.Text.Trim(); objlink.LinkReference = whurl; objlink.Region = rdoregion.SelectedValue; objlink.IsBetSlip = "Y"; objlink.IsExpire = ddlexpire.SelectedValue; objlink.ExpireDate = GetDate(txtexpiredate.Text); objlink.FastBetName = txtfastbetname.Text.Trim(); objlink.Shortenurl = BLL.Constants.Fastbeturl + CommonLib.StringHandler.ToTitle(txtfastbetname.Text.Trim()); objlink.FastBetTotitle = CommonLib.StringHandler.ToTitle(txtfastbetname.Text.Trim()); objlink.Sel = txtSel.Text.Trim(); objlink.Stake = txtStake.Text.Trim(); objlink.Whurl = txtUrl.Text.Trim(); if (Request.QueryString["linkid"] != null) { objlink.Linkid = Request.QueryString["linkid"].ToString(); objlink.Action = "Update"; } else { objlink.Linkid = "0"; } int _linkid = 0; objlink.RandomId = GenerateUniqueID(); int fastbetcount = objlink.CheckDuplicateFastbetForWHUrl(objlink.Shortenurl, objlink.Linkid, objlink.Region); int promolinkcount = objlink.CheckDuplicateWHLinkName(objlink.LinkName, objlink.Linkid, objlink.Region); if (fastbetcount == 0 && promolinkcount == 0) { _linkid = objlink.WHLink_Save(); Session["region"] = rdoregion.SelectedValue; if (ViewState["oldvalue"] != null) { objlink.OldValues = ViewState["oldvalue"].ToString(); objlink.NewValues = whurl; objlink.SaveOfferLinkHistory(); } Response.Redirect("ListOfferLinks.aspx", false); } else { dupli.Visible = true; if (fastbetcount > 0) { ltdupsub.Text = "This FastBet Name already exists. Please choose another."; } if (promolinkcount > 0) { ltdupsub.Text = "This link name already exists. Please choose another."; } objlink.SaveDuplicatePromoLink(); } } } else { validPage.Visible = true; } } catch (Exception ex) { CommonLib.ExceptionHandler.WriteLog(CommonLib.Sections.Admin, "OfferLink/AddEditWHLink.aspx.cs IsPostBack", ex); } } else { try { if (Request.QueryString["linkid"] != null) { using (OfferLinkMgmt obj = new OfferLinkMgmt(adsenseconn)) { DataTable dt = new DataTable(); dt = obj.GetWHLinkDetails(Request.QueryString["linkid"].ToString()); if (dt.Rows.Count > 0) { txtLinkName.Text = dt.Rows[0]["LinkName"].ToString(); txtSel.Text = dt.Rows[0]["sel"].ToString(); txtStake.Text = dt.Rows[0]["stake"].ToString(); txtUrl.Text = dt.Rows[0]["whurl"].ToString(); string whurl = string.Format("{0}&sel={1}&stake={2}&url={3}", txtWhUrl.Text.Trim(), txtSel.Text.Trim(), txtStake.Text.Trim(), txtUrl.Text.Trim()); ViewState["oldvalue"] = whurl; rdoregion.SelectedValue = dt.Rows[0]["region"].ToString(); ddlexpire.SelectedValue = dt.Rows[0]["IsExpire"].ToString(); txtexpiredate.Text = Convert.ToDateTime(dt.Rows[0]["ExpireDate"]).ToString("dd/MM/yyyy HH:mm"); txtfastbetname.Text = dt.Rows[0]["FastBetName"].ToString(); if (dt.Rows[0]["IsBetSlip"].ToString() == "Y") { txtfastbetname.ReadOnly = true; } } } } } catch (Exception ex) { CommonLib.ExceptionHandler.WriteLog(CommonLib.Sections.Admin, "OfferLink/AddEditWHLink.aspx.cs IsNotPostBack", ex); } } }