/// <summary>
/// Select appropriate database table and download the data to the client
/// </summary>
/// <param name="tool"></param>
/// <param name="context"></param>
protected void downloadContent(BaseCmsAdminTool tool, HttpContext context)
{
string fileName = tool.ToString() + "_" + DateTime.Now.ToString("yyyy-MM-dd") + ".xls";
GridView gridview1 = new GridView();
if (tool.GetType().Name.EndsWith("ListUserFeedback"))
{
gridview1 = new UserFeedbackDb().FetchAllUserFeedbackSubmittedDataAsGrid();
}
else if (tool.GetType().Name.EndsWith("ListRegisteredProjects"))
{
gridview1 = new RegisterProjectDb().fetchAllAsGrid();
}
OutputDataSetToExcelFile.OutputToResponse(gridview1, fileName, "", "", context.Response);
}
/// <summary>
/// List the registered projects in descending order;
/// Provide a download link.
/// </summary>
/// <returns></returns>
public override string Render()
{
RegisterProjectDb db = new RegisterProjectDb();
List <RegisterProjectDb.RegisterProjectData> list = db.fetchAll();
if (list.Count == 0)
{
return("<p><em>No registered project</em></p>");
}
StringBuilder html = new StringBuilder();
html.Append("<p>");
html.Append(TABLE_START_HTML);
html.Append("<caption><h2>Registered Projects <a style=\"font-size: small;\" href=\"" + CmsContext.ApplicationPath + "_system/tools/download.ashx?adminTool=ListRegisteredProjects\">(download Excel file)</a></h2></caption>");
html.Append("<tr>");
html.Append("<th>Name</th><th>Location</th><th>Description</th><th>Contact Person</th><th>Email</th><th>Telephone</th><th>Cellphone</th><th>Website</th><th>Funding Source</th><th>Date/Time Created</th><th>IP Address</th>");
html.Append("</tr>");
foreach (RegisterProjectDb.RegisterProjectData d in list)
{
html.Append("<tr>");
html.Append("<td>" + d.Name + "</td>");
html.Append("<td>" + d.Location + "</td>");
html.Append("<td>" + d.Description + "</td>");
html.Append("<td>" + d.ContactPerson + "</td>");
html.Append("<td><a href=\"mailto:" + d.Email + "\">" + d.Email + "</a></td>");
html.Append("<td>" + d.Telephone + "</td>");
html.Append("<td>" + d.Cellphone + "</td>");
html.Append("<td>" + d.Website + "</td>");
html.Append("<td>" + d.FundingSource + "</td>");
html.Append("<td>" + d.CreatedDateTime.ToString() + "</td>");
html.Append("<td>" + d.ClientIp + "</td>");
html.Append("</tr>");
}
html.Append("</table>");
html.Append("</p>");
return(html.ToString());
}
