예제 #1
0
        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;
            }
        }
예제 #2
0
 public ActionResult Login(Login login)
 {
     using (var context = new StripeEntities())
     {
         var loginCheck = context.SP_LOGIN(login.login_username, login.login_password).SingleOrDefault();
         if (loginCheck == null)
         {
             ModelState.AddModelError("", "Log in credentials invalid");
             return View(login);
         }
         else
         {
             FormsAuthentication.SetAuthCookie(loginCheck.login_username, false);
             Session["loginid"] = loginCheck.login_ID;
             switch (loginCheck.User_Type_userType_ID)
             {
                 case "R":
                     return RedirectToAction("Home", "Referee");
                     break;
                 case "S":
                     return RedirectToAction("Home", "Director");
                     break;
                 case "A":
                     return RedirectToAction("Home", "Admin", new { id = loginCheck.login_ID });
                     break;
                 default:
                     return RedirectToAction("Index", "Home");
                     break;
             }
         }
     }
 }
예제 #3
0
 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;
     }
 }
예제 #4
0
        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");
            }
        }
예제 #5
0
 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);
     }
 }
예제 #6
0
        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);
            }
        }
예제 #7
0
 public ActionResult List()
 {
     using (var context = new StripeEntities())
     {
         var eventList = context.Sport_Event.ToList();
         return View(eventList);
     }
 }
예제 #8
0
 public bool UserProfileExistence(int id, StripeEntities context)
 {
     var profile = context.User_Profile.Where(loginid => loginid.userProfile_ID == id).SingleOrDefault();
     if (profile == null)
         return false;
     else
         return true;
 }
예제 #9
0
 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 });
     }
 }
예제 #10
0
 public PartialViewResult GetRefList(int GameCode)
 {
     using (var context = new StripeEntities())
     {
         GetGameList getRefList = new GetGameList(context);
         ViewBag.RefList = getRefList.getRefTypeList(GameCode);
         return PartialView("_RefList");
     }
 }
예제 #11
0
 public ActionResult Index()
 {
     using (var context = new StripeEntities())
     {
         Session["loginid"] = null;
         ViewBag.UserTypeList = getUserTypeList(context);
     }
     return View();
 }
예제 #12
0
 public static List<SelectListItem> getSchoolList(StripeEntities context)
 {
     List<SelectListItem> RefList = new List<SelectListItem>();
     var schoolList = context.Schools.ToList();
     foreach (var schoolDetails in schoolList)
     {
         RefList.Add(new SelectListItem() { Text = schoolDetails.sch_Name, Value = schoolDetails.sch_ID.ToString() });
     }
     return RefList;
 }
예제 #13
0
 public List<SelectListItem> getUserTypeList(StripeEntities context)
 {
     List<SelectListItem> userTypeList = new List<SelectListItem>();
     userTypeList.Add(new SelectListItem() { Text = "Please select User Type", Value = "default" });
     var result = context.User_Type.ToList();
     foreach (var item in result)
     {
         userTypeList.Add(new SelectListItem() { Text = item.userType_Name, Value = item.userType_ID });
     }
     return userTypeList;
 }
예제 #14
0
        public ActionResult MoreDetails(int eventId)
        {
            using (var context = new StripeEntities())
            {
                Event getEventDetails = new Event(context);
                var eventDetails = getEventDetails.GetEventByEventId(eventId)
                    .SingleOrDefault();

                return View(eventDetails);
            }
        }
예제 #15
0
        public ActionResult CreateEvent()
        {
            using (var context = new StripeEntities())
            {

                ViewBag.SchoolList = SchoolClass.getSchoolList(context);
                GetGameList getGameList = new GetGameList(context);
                ViewBag.GameList = getGameList.getGameTypeList();
            }
            return View();
        }
예제 #16
0
        public bool UserProfileExistence(int id, StripeEntities context)
        {
            var profile = context.User_Profile.Where(loginid => loginid.userProfile_ID == id).SingleOrDefault();

            if (profile == null)
            {
                return(false);
            }
            else
            {
                return(true);
            }
        }
예제 #17
0
        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");
            }
        }
예제 #18
0
        public static List <SelectListItem> getSchoolList(StripeEntities context)
        {
            List <SelectListItem> RefList = new List <SelectListItem>();
            var schoolList = context.Schools.ToList();

            foreach (var schoolDetails in schoolList)
            {
                RefList.Add(new SelectListItem()
                {
                    Text = schoolDetails.sch_Name, Value = schoolDetails.sch_ID.ToString()
                });
            }
            return(RefList);
        }
예제 #19
0
 public ActionResult AllEvents()
 {
     using (var context = new StripeEntities())
     {
         UserProfile userProfile = new UserProfile();
         int id = Convert.ToInt32(Session["loginid"]);
         var refereeProfile = userProfile.getUserProfile(id, context);
         Event allEvents = new Event(context);
         var allEventsList = allEvents.GetAllEvents("N")
             .Where(sptId => sptId.Sport_Name_spt_Sport_Name_ID == refereeProfile.Sport_Name_spt_Sport_Name_ID)
             .ToList();
         return View(allEventsList);
     }
 }
예제 #20
0
        public ActionResult EditEvent(int eventId)
        {
            using (var context = new StripeEntities())
            {
                Event getEventDetails = new Event(context);
                var eventDetails = getEventDetails.GetEventByEventId(eventId)
                    .SingleOrDefault();

                ViewBag.SchoolList = SchoolClass.getSchoolList(context);
                GetGameList getGameList = new GetGameList(context);
                ViewBag.GameList = getGameList.getGameTypeList();

                return View(eventDetails);
            }
        }
예제 #21
0
 public ActionResult UpdateScores(SP_GET_EVENT_BY_EVENTID_Result eventScores)
 {
     using (var context = new StripeEntities())
     {
         Event updateEventScores = new Event(context);
         if (updateEventScores.UpdateEventScores(eventScores))
         {
             return RedirectToAction("ViewEvents", "Director");
         }
         else
         {
             return View("Error");
         }
     }
 }
예제 #22
0
        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");
            }
        }
예제 #23
0
 public ActionResult Profile()
 {
     using (var context = new StripeEntities())
     {
         try
         {
             int id = Convert.ToInt32(Session["loginid"]);
             var refereeProfile = context.User_Profile.Where(userid => userid.userProfile_ID == id).SingleOrDefault();
             return View(refereeProfile);
         }
         catch (Exception exception)
         {
             Console.Write(exception.Message);
             ViewBag.ErrorMessage = "There is something wrong with the account. Please contact admin";
             return View("Error");
         }
     }
 }
예제 #24
0
 public ActionResult Apply(int eventId)
 {
     using (var context = new StripeEntities())
     {
         int refereeId = Convert.ToInt32(Session["loginid"]);
         EventReferee eventReferee = new EventReferee(context);
         if (eventReferee.CheckRefereeEligibilityForApplication(eventId, refereeId))
         {
             Event allEvents = new Event(context);
             var eventDetails = allEvents.GetEventByEventId(eventId).SingleOrDefault();
             GetGameList getRefList = new GetGameList(context);
             ViewBag.RefereeList = getRefList.getRefTypeList(eventDetails.Sport_Name_spt_Sport_Name_ID);
             return View(eventDetails);
         }
         else
         {
             ViewBag.ErrorMessage = "You've already applied for this event. Please wait for any further notification.";
             return View("Error");
         }
     }
 }
예제 #25
0
        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);
            }
        }
예제 #26
0
 public Event(StripeEntities context)
 {
     this.context = context;
 }
예제 #27
0
 public GetGameList(StripeEntities context)
 {
     this.context = context;
 }
예제 #28
0
        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");
            }
        }
예제 #29
0
 public SP_USER_PROFILE_GET_Result getUserProfile(int id, StripeEntities context)
 {
     return context.SP_USER_PROFILE_GET(id).SingleOrDefault();
 }
예제 #30
0
 public SchoolClass(StripeEntities context)
 {
     this.context = context;
 }
예제 #31
0
 public SP_USER_PROFILE_GET_Result getUserProfile(int id, StripeEntities context)
 {
     return(context.SP_USER_PROFILE_GET(id).SingleOrDefault());
 }
예제 #32
0
 public EventReferee(StripeEntities context)
 {
     this.context = context;
 }
예제 #33
0
 public EventReferee(StripeEntities context)
 {
     this.context = context;
 }
예제 #34
0
 public SchoolClass(StripeEntities context)
 {
     this.context = context;
 }
예제 #35
0
        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");
            }
        }
예제 #36
0
        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);
            }
        }
예제 #37
0
        public ActionResult ViewApplications(int eventId)
        {
            using (var context = new StripeEntities())
            {
                var eventDetails = context.SP_GET_APPLICATION_STATUS_BY_EVENTID(eventId).ToList();

                return View(eventDetails);
            }
        }
예제 #38
0
 public GetGameList(StripeEntities context)
 {
     this.context = context;
 }
예제 #39
0
        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);
                }
                else
                {
                    //Inserting Profile
                    userProfile.UserProfileInsert(context, refProfile);
                }

                return RedirectToAction("Profile");
            }
        }