public ActionResult CreateEvent(Sport_Event sportEventDetails) { if (ModelState.IsValid) { using (var context = new StripeEntities()) { int id = Convert.ToInt32(Session["loginid"]); SchoolClass schoolRecord = new SchoolClass(context); sportEventDetails.School_Home_sch_ID = schoolRecord.getSchoolDetailsFromDirector(id).sch_ID; if (sportEventDetails.School_Away_sch_ID == sportEventDetails.School_Home_sch_ID) { ModelState.AddModelError("", "Cannot select same away and home team"); return View(); } else { sportEventDetails.event_Completion = "N"; context.Sport_Event.Add(sportEventDetails); context.SaveChanges(); return RedirectToAction("Home"); } } } else { return View("Error"); } }
public ActionResult Apply(FormCollection formCollection) { using (var context = new StripeEntities()) { int eventId = Convert.ToInt32(formCollection["event_ID"]); int refereeType = Convert.ToInt32(formCollection["ref_Game_Specialization_Type"]); int homeSchoolId = Convert.ToInt32(formCollection["School_Home_sch_ID"]); int refereeId = Convert.ToInt32(Session["loginid"]); SchoolClass schoolRecord = new SchoolClass(context); var schoolDetails = schoolRecord.GetDirectorIdFromSchoolId(homeSchoolId); context.SP_EVENT_REFEREE_APPLY(eventId, refereeId, schoolDetails.User_Profile_Director_Profile_ID, "P", refereeType); context.SaveChanges(); return RedirectToAction("AllEvents"); } }
public ActionResult ViewEvents() { using (var context = new StripeEntities()) { int id = Convert.ToInt32(Session["loginid"]); SchoolClass schoolRecord = new SchoolClass(context); var schoolDetails = schoolRecord.getSchoolDetailsFromDirector(id); var eventList = context.SP_GET_EVENT_BY_SCHOOLID(schoolDetails.sch_ID).ToList(); return View(eventList); } }
public ActionResult SchoolDetails(SP_SCHOOL_DETAILS_FROM_DIRECTOR_Result schoolDetails) { using (var context = new StripeEntities()) { SchoolClass schoolClass = new SchoolClass(context); var schoolRecord = schoolClass.getSchoolDetailsFromDirector(schoolDetails.User_Profile_Director_Profile_ID); if (schoolRecord == null) { schoolClass.InsertUpdateSchoolRecords(true, context, schoolDetails); } else { schoolClass.InsertUpdateSchoolRecords(false, context, schoolDetails); } return RedirectToAction("SchoolDetails"); } }
public ActionResult SchoolDetails() { using (var context = new StripeEntities()) { int id = Convert.ToInt32(Session["loginid"]); SchoolClass schoolClass = new SchoolClass(context); var schoolDetails = schoolClass.getSchoolDetailsFromDirector(id); return View("SchoolDetails", schoolDetails); } }