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