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