public static string GetResearchTableCSV()
{
List <CheckViewModel> checks = CheckManager.GetChecks();
var csv = new StringBuilder();
// N.B. No spaces between column names in the header row!
string header = "Date,Record ID,Interview Record ID,Name,DOB,Check Number,Service,Disposition";
csv.AppendLine(header);
foreach (CheckViewModel check in checks)
{
string csvrow = string.Format("{0},{1},{2},{3},{4},{5},{6},{7}",
check.Date,
check.RecordID,
check.InterviewRecordID,
string.Format("\"{0}\"", check.Name),
check.DOB.ToString("MM/dd/yyyy"),
check.Num,
check.Service,
check.Disposition);
csv.AppendLine(csvrow);
}
return(csv.ToString());
}
public static string DownloadResearchTable()
{
List <CheckViewModel> checks = CheckManager.GetChecks();
if (checks != null)
{
string fname = Extras.GetResearchTableFileName();
string pathToResearchTableFile = System.Web.HttpContext.Current.Request.MapPath(string.Format("~/Downloads/{0}.csv", fname));
WriteChecksFile(pathToResearchTableFile, checks);
return(fname);
}
return("NoChecks");
}
