public override void GenerateCsv()
{
_logger("Starting Search Text CSV creation.");
var courseSearchListItems = _db.up_CourseSearchTextForCsvExport();
using (Stream stream = File.Open(Constants.W_Search_Text_CsvFilename, FileMode.OpenOrCreate, FileAccess.Write, FileShare.Read))
{
using (TextWriter writer = new StreamWriter(stream))
{
var csv = new CsvWriter(writer);
csv.WriteField <string>("COURSE_ID");
csv.WriteField <string>("OPPORTUNITY_ID");
csv.WriteField <string>("STUDY_MODE");
csv.WriteField <string>("ATTENDANCE_MODE");
csv.WriteField <string>("ATTENDANCE_PATTERN");
csv.WriteField <string>("QUAL_TYPE_CODE");
csv.WriteField <string>("XMIN");
csv.WriteField <string>("XMAX");
csv.WriteField <string>("YMIN");
csv.WriteField <string>("YMAX");
csv.WriteField <string>("X_COORD");
csv.WriteField <string>("Y_COORD");
csv.WriteField <string>("SEARCH_TEXT");
csv.WriteField <string>("NO_OF_OPPS");
csv.WriteField <string>("LAST_UPDATE_DATE");
csv.WriteField <string>("PROVIDER_ID");
csv.WriteField <string>("SEARCH_LDCS");
csv.WriteField <string>("PROVIDER_NAME");
csv.WriteField <string>("IES_FLAG");
csv.WriteField <string>("TTG_FLAG");
csv.WriteField <string>("TQS_FLAG");
csv.WriteField <string>("SFL_FLAG");
csv.WriteField <string>("APP_DEADLINE");
csv.WriteField <string>("APP_STATUS");
csv.WriteField <string>("TTG_STATUS");
csv.WriteField <string>("ADULT_LEARNER");
csv.WriteField <string>("OTHER_FUNDING");
csv.WriteField <string>("ILS_FLAG");
csv.WriteField <string>("FLEXIBLE_START_FLAG");
csv.WriteField <string>("SEARCH_REGION");
csv.WriteField <string>("SEARCH_TOWN");
csv.WriteField <string>("SEARCH_POSTCODE");
csv.NextRecord();
foreach (var courseSearchListItem in courseSearchListItems.ToList())
{
csv.WriteField(courseSearchListItem.COURSE_ID);
csv.WriteField(courseSearchListItem.OPPORTUNITY_ID);
csv.WriteField(courseSearchListItem.STUDY_MODE);
csv.WriteField(courseSearchListItem.ATTENDANCE_MODE);
csv.WriteField(courseSearchListItem.ATTENDANCE_PATTERN);
csv.WriteField(courseSearchListItem.QUAL_TYPE_CODE);
csv.WriteField(courseSearchListItem.XMIN);
csv.WriteField(courseSearchListItem.XMAX);
csv.WriteField(courseSearchListItem.YMIN);
csv.WriteField(courseSearchListItem.YMAX);
csv.WriteField(courseSearchListItem.X_COORD);
csv.WriteField(courseSearchListItem.Y_COORD);
csv.WriteField(courseSearchListItem.SEARCH_TEXT);
csv.WriteField(courseSearchListItem.NO_OF_OPPS);
csv.WriteField(courseSearchListItem.LAST_UPDATE_DATE);
csv.WriteField(courseSearchListItem.PROVIDER_ID);
csv.WriteField(courseSearchListItem.SEARCH_LDCS);
csv.WriteField(courseSearchListItem.PROVIDER_NAME);
csv.WriteField(courseSearchListItem.IES_FLAG);
csv.WriteField(courseSearchListItem.TTG_FLAG);
csv.WriteField(courseSearchListItem.TQS_FLAG);
csv.WriteField(courseSearchListItem.SFL_FLAG);
csv.WriteField(courseSearchListItem.APP_DEADLINE);
csv.WriteField(courseSearchListItem.APP_STATUS);
csv.WriteField(courseSearchListItem.TTG_STATUS);
csv.WriteField(courseSearchListItem.ADULT_LEARNER);
csv.WriteField(courseSearchListItem.OTHER_FUNDING);
csv.WriteField(courseSearchListItem.ILS_FLAG);
csv.WriteField(courseSearchListItem.FLEXIBLE_START_FLAG);
csv.WriteField(courseSearchListItem.SEARCH_REGION);
csv.WriteField(courseSearchListItem.SEARCH_TOWN);
csv.WriteField(courseSearchListItem.SEARCH_POSTCODE);
csv.NextRecord();
}
}
}
}