public ActionResult ApplicationForm(StudentInformationTable studentinfo)
{
if (ModelState.IsValid && studentinfo.Measure_type == "COUNT" && studentinfo.Category_Set_code == "ACT16")
{
PIMSdbEntities pimsEntities = new PIMSdbEntities();
pimsEntities.StudentInformationTables.Add(studentinfo);
pimsEntities.SaveChanges();
ViewBag.message = "Entry added to the database successfully";
return(View());
}
else
{
ModelState.Clear();
ViewBag.message = "Something went wrong. Measure type has to be 'COUNT' and Category set code has to be 'ACT16' ";
return(View(studentinfo));
}
}
public ActionResult DisplayFormat(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
using (var context = new PIMSdbEntities())
{
//getting records of one district
var districtRecord = context.StudentInformationTables
.Where(x => x.District_Code == id);
//getting first record of a district for settign filename
var districtOneRecord = context.StudentInformationTables
.Where(x => x.District_Code == id)
.First();
string filename;
DateTime todaydate = DateTime.Now;
//Setting timestamp for filename
string DateTimeString = todaydate.ToString("yyyyMMddHHmm");
filename = districtOneRecord.District_Code + "_" + "student_" + DateTimeString;
var result = WriteCsvToMemory(districtRecord.ToList());
var memoryStream = new MemoryStream(result);
// return View(oneRecord);
return(new FileStreamResult(memoryStream, "text/csv")
{
FileDownloadName = filename + ".csv"
});
}
}
public ActionResult ShowEntries()
{
PIMSdbEntities pimsEntities = new PIMSdbEntities();
return(View(pimsEntities.StudentInformationTables.ToList()));
}
