public void GetSiteWiseTrackingDetails(string referrerid)
{
try
{
string day1 = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd");
string day2 = DateTime.Now.ToString("yyyy-MM-dd");
string strconn = ConfigurationManager.AppSettings["Iframaddsense"];
DataTable dt = new DataTable();
StringBuilder sb = new StringBuilder();
string data = "";
using (PromotionalLinkReportMgmt obj = new PromotionalLinkReportMgmt(strconn))
{
dt = obj.GetSiteWiseTrackingDetails(day1, day2);
if (dt.Rows.Count > 0)
{
data = "<table bgcolor='#eeeeee' style='width:100%;'><tr bgcolor='#eeeeee'><td class='headings'>Site Exit Click</td><td class='headings' align='center'>Today Click</td><td class='headings' align='center'>Yesterday Click</td><td class='headings' align='center'>Total Click</td></tr>{0}</table>";
foreach (DataRow dr in dt.Rows)
{
int today = obj.GetPromotionalLinkCountDayWise_Site(0, 3, dr["SiteID"].ToString());
int yesterday = obj.GetPromotionalLinkCountDayWise_Site(1, 3, dr["SiteID"].ToString());
sb.Append(string.Format("<tr bgcolor='#eeeeee' height='20'><td class='text' align='left' style='padding-left:5px;' bgcolor='#FFFFFF' valign='middle'>{0}</td><td class='text' style='padding-left:5px;text-align:center;width: 200px;' bgcolor='#FFFFFF' valign='middle'>{1}</td><td class='text' style='padding-left:5px;text-align:center;width:203px;' bgcolor='#FFFFFF' valign='middle'>{2}</td><td class='text' style='padding-left:5px;text-align:center;width: 135px;' bgcolor='#FFFFFF' valign='middle'>{3}</td></tr>", dr["SiteAlias"].ToString(), today, yesterday, dr["Exitclick"].ToString()));
}
}
ltresult.Text = string.Format(data, sb.ToString());
}
}
catch (Exception ex)
{
CommonLib.ExceptionHandler.WriteLog(CommonLib.Sections.Admin, "NewGamingnetAdmin/AjaxOfferLink.aspx.cs GetTrackingDetails", ex);
}
}
/// <summary>
/// promotional link report List
/// </summary>
/// <param name="day1"></param>
/// <param name="day2"></param>
private void PromotinalLinkReportList(string day1, string day2)
{
string txt = "";
int i = 0;
string showlink = "";
try
{
DataTable dt = new DataTable();
using (PromotionalLinkReportMgmt obj = new PromotionalLinkReportMgmt(strconn))
{
dt = obj.GetPromotionalExitClickList(day1, day2);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
i++;
if (dr["Referrerid"].ToString() == "3")
{
showlink = "<a href='javascript:void(0);' class='showdata' id='" + dr["Referrerid"].ToString() + "' style='vertical-align:sub;'> <img src='../images/expand.png'/ title='view website'></a> <a href='javascript:void(0);'><img src='../images/minimize.png'/ title='minimize website' class='minimize' style='position:fixed;'></a></br>";
}
else
{
showlink = "";
}
txt += "<tr height='30' valign='top'>";
txt += "<td class='text' align= 'center' bgcolor='#FFFFFF' valign='middle' style='font-family:verdana;font-size:11px;'>" + i.ToString() + "</td>";
txt += "<td class='text' align='left' style='padding-left:5px;' bgcolor='#FFFFFF' valign='middle'><a class='link' href='PromotionalLinkReportDetails.aspx?referrerid=" + dr["Referrerid"].ToString() + "'>" + dr["ReferrerName"].ToString() + showlink + "</td>";
txt += "<td class='text' align='left' style='padding-left:5px;text-align: center;' bgcolor='#FFFFFF' valign='middle' >" + obj.GetPromotionalLinkCountDayWise(0, Convert.ToInt32(dr["Referrerid"])) + "</td>";
txt += "<td class='text' align='left' style='padding-left:5px;text-align: center;' bgcolor='#FFFFFF' valign='middle' >" + obj.GetPromotionalLinkCountDayWise(1, Convert.ToInt32(dr["Referrerid"])) + "</td>";
txt += "<td class='text' align='left' style='padding-left:5px;text-align: center;' bgcolor='#FFFFFF' valign='middle' >" + dr["Exitclicktotal"].ToString() + "</td>";
txt += "</tr>";
if (dr["Referrerid"].ToString() == "3")
{
txt += "<tr id='trsitetrack' style='display:none;' height='30' valign='top'><td class='text' bgcolor='#FFFFFF'></td><td class='text' bgcolor='#FFFFFF' colspan='4'><div id='ref_3'></div></td></tr>";
}
}
// txt += "<tr id='trsitetrack' style='display:none;' height='30' valign='top'><td class='text' bgcolor='#FFFFFF'></td><td class='text' bgcolor='#FFFFFF' colspan='4'><div id='ref_3'></div></td></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;
}
}
catch (Exception ex)
{
CommonLib.ExceptionHandler.WriteLog(CommonLib.Sections.Admin, "OfferLink/List_PromotionalLinkReport.aspx.cs PromotinalLinkReportList", ex);
}
}
private void PromotionalLinkHourswise(string startdate)
{
try
{
using (PromotionalLinkReportMgmt obj = new PromotionalLinkReportMgmt(strconn))
{
ltlist.Text = obj.GetExitClikHourswise(startdate);
}
}
catch (Exception ex)
{
CommonLib.ExceptionHandler.WriteLog(CommonLib.Sections.Admin, "OfferLink/PromotionalLinkHourswise.aspx.cs Page_Load", ex);
}
}
/// <summary>
/// List
/// </summary>
/// <param name="fromdate"></param>
/// <param name="todate"></param>
/// <param name="referrerid"></param>
/// <param name="pagesize"></param>
/// <param name="currentpageno"></param>
private void PromotinalLinkReportList(string fromdate, string todate, string referrerid, int pagesize, int currentpageno)
{
string txt = "";
int i = 0;
try
{
DataTable dt = new DataTable();
using (PromotionalLinkReportMgmt obj = new PromotionalLinkReportMgmt(strconn))
{
dt = obj.GetPromotionalExitClickListDetails(fromdate, todate, referrerid, pagesize, currentpageno);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
i++;
txt += "<tr height='30' valign='top'>";
txt += "<td class='text' align= 'center' bgcolor='#FFFFFF' valign='middle' style='font-family:verdana;font-size:11px;text-align: center;'>" + i.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["ReferrerUrl"].ToString() + "</td>";
txt += "<td class='text' align='left' style='padding-left:5px;' bgcolor='#FFFFFF' valign='middle' >" + Convert.ToDateTime(dr["HitDate"]).ToString("dd/MM/yyyy HH:mm") + "</td>";
txt += "<td class='text' align='center' style='padding-left:5px;text-align:center;' bgcolor='#FFFFFF' valign='middle' >" + dr["Exitclick"].ToString() + "</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/PromotionalLinkReportDetails.aspx.cs PromotinalLinkReportList", ex);
}
}
private void Page_Load(object sender, System.EventArgs e)
{
try
{
BaseUrl = ConfigurationManager.AppSettings["BaseURL"];
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)
{
string day1 = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd");
string day2 = DateTime.Now.ToString("yyyy-MM-dd");
if (null != Request.QueryString["p"])
{
pagenumber = Convert.ToInt32(Request.QueryString["p"].ToString());
}
else
{
pagenumber = 1;
}
PromotinalLinkReportList(day1, day2);
}
else
{
string day1 = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd");
string day2 = DateTime.Now.ToString("yyyy-MM-dd");
disp_labels();
if (Request.QueryString["excel"] != null)
{
if (Request.QueryString["excel"] == "excel")
{
using (PromotionalLinkReportMgmt obj = new PromotionalLinkReportMgmt(strconn))
{
DataTable dtexcel = obj.GetPromotionalExitClickList(day1, day2);
ExcelMgmt objexcel = new ExcelMgmt();
string excelfilename = "promotionlink_" + DateTime.Now.ToString("ddMMyyyyHHmmsss") + ".csv";
objexcel.WriteToCSV(dtexcel, excelfilename);
}
}
}
if (null != Request.QueryString["p"])
{
pagenumber = Convert.ToInt32(Request.QueryString["p"].ToString());
}
else
{
pagenumber = 1;
}
PromotinalLinkReportList(day1, day2);
}
}
catch (Exception ex)
{
CommonLib.ExceptionHandler.WriteLog(CommonLib.Sections.Admin, "OfferLink/List_PromotionalLinkReport.aspx.cs Page_Load", ex);
}
}
private void Page_Load(object sender, System.EventArgs e)
{
try
{
BaseUrl = ConfigurationManager.AppSettings["BaseURL"];
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["day1"] = txtstartdate.Text;
Session["day2"] = txtenddate.Text;
if (null != Request.QueryString["p"])
{
pagenumber = Convert.ToInt32(Request.QueryString["p"].ToString());
}
else
{
pagenumber = 1;
}
PromotinalLinkReportList(GetDate(txtstartdate.Text), GetDate(txtenddate.Text), Request.QueryString["referrerid"], pagesize, pagenumber);
}
else
{
if (null != Request.QueryString["p"])
{
pagenumber = Convert.ToInt32(Request.QueryString["p"].ToString());
}
else
{
pagenumber = 1;
}
disp_labels();
if (Request.QueryString["clear"] != null)
{
txtstartdate.Text = DateTime.Now.AddDays(-1).ToString("dd/MM/yyyy");
txtenddate.Text = DateTime.Now.ToString("dd/MM/yyyy");
Session["day1"] = txtstartdate.Text;
Session["day2"] = txtenddate.Text;
}
if (Request.QueryString["excel"] != null)
{
if (Request.QueryString["excel"] == "excel")
{
if (Session["day1"] == null && Session["day2"] == null)
{
Session["day1"] = DateTime.Now.AddDays(-1).ToString("dd/MM/yyyy");
Session["day2"] = DateTime.Now.ToString("dd/MM/yyyy");
}
using (PromotionalLinkReportMgmt obj = new PromotionalLinkReportMgmt(strconn))
{
DataTable dtexcel = obj.GetPromotionalExitClickListDetails(GetDate(Session["day1"].ToString()), GetDate(Session["day2"].ToString()), Request.QueryString["referrerid"], pagesize, pagenumber);
ExcelMgmt objexcel = new ExcelMgmt();
string excelfilename = "promotionlinkdetails_" + DateTime.Now.ToString("ddMMyyyyHHmmsss") + ".csv";
objexcel.WriteToCSV(dtexcel, excelfilename);
}
}
}
if (Request.QueryString["referrerid"] != null)
{
txtstartdate.Text = DateTime.Now.AddDays(-1).ToString("dd/MM/yyyy");
txtenddate.Text = DateTime.Now.ToString("dd/MM/yyyy");
PromotinalLinkReportList(GetDate(txtstartdate.Text), GetDate(txtenddate.Text), Request.QueryString["referrerid"], pagesize, pagenumber);
}
}
}
catch (Exception ex)
{
CommonLib.ExceptionHandler.WriteLog(CommonLib.Sections.Admin, "OfferLink/PromotionalLinkReportDetails.aspx.cs Page_Load", ex);
}
}
