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