// GET: SchoolYear
public async System.Threading.Tasks.Task<ActionResult> SchoolYear()
{
SchoolYearCollection coll = new SchoolYearCollection();
using (var connection = new MySqlConnection(ConfigurationManager.ConnectionStrings[Constants.ConnectionStringName].ConnectionString))
{
await connection.OpenAsync();
var result = new SchoolYearRepository(connection).GetSchoolYears();
coll.allSchoolYears = (IEnumerable<Models.SchoolYear>)result.Result.ToArray();
}
return View(coll);
}
public System.Web.Mvc.RedirectResult SetSchoolYear(string allSchoolYears)
{
using (var connection = new MySqlConnection(ConfigurationManager.ConnectionStrings[Constants.ConnectionStringName].ConnectionString))
{
var result = new SchoolYearRepository(connection).SetSchoolYear(allSchoolYears);
if (result == "success")
{
return Redirect("SchoolYear/?error=fileloaded");
}
else
{
//do something else here.
return Redirect("SchoolYear/?error=invalidfile");
}
}
}
