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