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