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