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