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