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