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 bool InsertUpdateSchoolRecords(bool insertUpdate, StripeEntities context, SP_SCHOOL_DETAILS_FROM_DIRECTOR_Result schoolDetails)
{
try
{
if (insertUpdate)
{
context.SP_SCHOOL_DETAILS_INSERT(schoolDetails.sch_Name,
schoolDetails.sch_Street,
schoolDetails.sch_City,
schoolDetails.sch_State,
schoolDetails.sch_Zip,
schoolDetails.sch_Logo,
schoolDetails.User_Profile_Director_Profile_ID);
}
else
{
//update queries
context.SP_SCHOOL_DETAILS_UPDATE(schoolDetails.sch_Name,
schoolDetails.sch_Street,
schoolDetails.sch_City,
schoolDetails.sch_State,
schoolDetails.sch_Zip,
schoolDetails.sch_Logo,
schoolDetails.User_Profile_Director_Profile_ID);
}
context.SaveChanges();
return true;
}
catch (Exception exception)
{
Console.Write(exception.Message);
return false;
}
}
public bool UserProfileInsert(StripeEntities context, User_Profile refProfile)
{
try
{
context.SP_USER_PROFILE_INSERT(refProfile.userProfile_ID,
refProfile.userProfile_First_Name,
refProfile.userProfile_Last_Name,
refProfile.userProfile_Email,
refProfile.userProfile_Phone,
refProfile.userProfile_Street,
refProfile.userProfile_City,
refProfile.userProfile_State,
refProfile.userProfile_Zip,
refProfile.userProfile_Photo,
refProfile.userProfile_Background_Description,
refProfile.userProfile_ID);
context.SaveChanges();
return(true);
}
catch (Exception exception)
{
return(false);
}
}
public bool UserProfileInsert(StripeEntities context, User_Profile refProfile)
{
try
{
context.SP_USER_PROFILE_INSERT(refProfile.userProfile_ID,
refProfile.userProfile_First_Name,
refProfile.userProfile_Last_Name,
refProfile.userProfile_Email,
refProfile.userProfile_Phone,
refProfile.userProfile_Street,
refProfile.userProfile_City,
refProfile.userProfile_State,
refProfile.userProfile_Zip,
refProfile.userProfile_Photo,
refProfile.userProfile_Background_Description,
refProfile.userProfile_ID);
context.SaveChanges();
return true;
}
catch (Exception exception)
{
return false;
}
}
public bool InsertUpdateSchoolRecords(bool insertUpdate, StripeEntities context, SP_SCHOOL_DETAILS_FROM_DIRECTOR_Result schoolDetails)
{
try
{
if (insertUpdate)
{
context.SP_SCHOOL_DETAILS_INSERT(schoolDetails.sch_Name,
schoolDetails.sch_Street,
schoolDetails.sch_City,
schoolDetails.sch_State,
schoolDetails.sch_Zip,
schoolDetails.sch_Logo,
schoolDetails.User_Profile_Director_Profile_ID);
}
else
{
//update queries
context.SP_SCHOOL_DETAILS_UPDATE(schoolDetails.sch_Name,
schoolDetails.sch_Street,
schoolDetails.sch_City,
schoolDetails.sch_State,
schoolDetails.sch_Zip,
schoolDetails.sch_Logo,
schoolDetails.User_Profile_Director_Profile_ID);
}
context.SaveChanges();
return(true);
}
catch (Exception exception)
{
Console.Write(exception.Message);
return(false);
}
}
public ActionResult UpdateStatus(int refereeId, int eventId, string status)
{
using (var context = new StripeEntities())
{
context.SP_UPDATE_REFEREE_STATUS_BY_EVENTID(eventId, refereeId, status);
context.SaveChanges();
return RedirectToAction("ViewApplications", "Director", new { eventid = eventId });
}
}
public ActionResult EditEvent(Sport_Event sportDetails)
{
using (var context = new StripeEntities())
{
context.SP_EVENT_DETAILS_UPDATE(sportDetails.event_Date,
sportDetails.event_Time,
sportDetails.event_School_Field_Name,
sportDetails.Sport_Name_spt_Sport_Name_ID,
sportDetails.event_ID);
context.SaveChanges();
return RedirectToAction("ViewEvents", "Director");
}
}
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 SignUp(Login login)
{
using (var context = new StripeEntities())
{
EncryptDecrypt encrypt = new EncryptDecrypt();
login.login_random_string = encrypt.Encrypt(login.login_username, "r0b1nr0y");
context.Logins.Add(login);
context.SaveChanges();
return View("SignUpConfirmation");
}
}
public ActionResult Profile(User_Profile refProfile)
{
using (var context = new StripeEntities())
{
UserProfileExistCheck profileCheck = new UserProfileExistCheck();
UserProfile userProfile = new UserProfile();
if (profileCheck.UserProfileExistence(refProfile.userProfile_ID, context))
{
userProfile.UserProfileUpdate(context, refProfile);
context.SP_USER_PROFILE_REFEREE_UPDATE(refProfile.ref_Game_Specialization_Type,
refProfile.userProfile_ID,
refProfile.Sport_Name_spt_Sport_Name_ID);
context.SaveChanges();
}
else
{
//Inserting Profile
userProfile.UserProfileInsert(context, refProfile);
context.SP_USER_PROFILE_REFEREE_INSERT(refProfile.ref_Game_Specialization_Type,
refProfile.userProfile_ID,
refProfile.Sport_Name_spt_Sport_Name_ID);
context.SaveChanges();
}
return RedirectToAction("Profile");
}
}
