public void Post(StudentFactTemplate template)
{
using (var db = new StudentFactTemplateContext())
{
//create fact template from model
var studentFactTemplate = new StudentFactTemplate {
ID = 1, SubmittingAUN = template.SubmittingAUN,
SchoolYearDate = template.SchoolYearDate, PASecureID = template.PASecureID,
ReportingDate = template.ReportingDate, Collection = template.Collection, MeasureType = template.MeasureType,
ACT16FundCategory = template.ACT16FundCategory
};
//add to database
db.StudentFactTemplates.Add(studentFactTemplate);
db.SaveChanges();
//var query = from x in db.StudentFactTemplates
// orderby x.ACT16FundCategory
// select x;
//List<int> test = new List<int>();
//foreach (var item in query)
//{
// test.Add(item.SubmittingAUN);
//}
//int y = test[1];
}
}
public IActionResult ExportAction()
{
using (var db = new StudentFactTemplateContext())
{
//get data from database
var query = from x in db.StudentFactTemplates
select x;
List <StudentFactTemplate> templateList = new List <StudentFactTemplate>();
foreach (var item in query)
{
templateList.Add(item);
}
//convert to csv
MemoryStream memoryStream = new MemoryStream();
StreamWriter streamWriter = new StreamWriter(memoryStream, System.Text.Encoding.UTF8, 1024, true);
using (CsvWriter csvWriter = new CsvWriter(streamWriter))
{
csvWriter.Configuration.RegisterClassMap <StudentFactTemplateMap>();
csvWriter.WriteRecords(templateList);
streamWriter.Flush();
memoryStream.Position = 0;
return(File(memoryStream.ToArray(), "text/csv", "studentFactTemplates.csv"));
}
}
}
