public ActionResult Round(Guid id) { ScorekeeperDBEntities s = new ScorekeeperDBEntities(); Round r = new Round(); r = s.Rounds.Where(x => x.RoundId == id).FirstOrDefault(); return View("Round", r); }
public ScorecardModel() { message = ""; string name = ((System.Web.HttpContext.Current.User).Identity).Name; User = new User(); ScorekeeperDBEntities userContext = new ScorekeeperDBEntities(); User = userContext.Users.Where(x => x.Username == name).FirstOrDefault(); CourseList = new List<Course>(); CourseList = userContext.Courses.ToList(); }
public ActionResult ScorecardDetail(FormCollection collection, ScorecardModel model) { ScorecardModel m = new ScorecardModel(); ScorekeeperDBEntities s = new ScorekeeperDBEntities(); m.SelectedCourseValue = model.SelectedCourseValue; m.SelectedCourse = s.Courses.Where(x => x.CourseId == model.SelectedCourseValue).FirstOrDefault(); int? highestRoundNum = 0; if (s.Rounds.Where(x => x.UserId == m.User.UserId).Count() > 0) highestRoundNum = s.Rounds.Where(x => x.UserId == m.User.UserId).OrderByDescending(x => x.RoundNumber).FirstOrDefault().RoundNumber; Round round = new Round(); round.RoundId = Guid.NewGuid(); round.CourseId = m.SelectedCourse.CourseId; round.UserId = m.User.UserId; round.RoundNumber = highestRoundNum + 1; round.PlayedDate = DateTime.Now; s.AddToRounds(round); for (int i = 0; i < m.SelectedCourse.Hole.Count(); i++) { RoundScore rs = new RoundScore(); rs.RoundScoreId = Guid.NewGuid(); rs.RoundId = round.RoundId; var g = (from h in s.Hole where h.HoleNumber == i+1 && h.CourseId == m.SelectedCourse.CourseId select h.HoleId); rs.HoleId = g.FirstOrDefault(); string holeNum = "Hole" + (i+1).ToString(); rs.Strokes = Int32.Parse(collection[holeNum]); s.AddToRoundScore(rs); } s.SaveChanges(); m.message = "Round Saved Successfully"; m.SelectedCourse = null; return View("Scorecard", m); }
public ActionResult JsonRegister(RegisterModel model) { if (ModelState.IsValid) { // Attempt to register the user MembershipCreateStatus createStatus; ScorekeeperDBEntities userContext = new ScorekeeperDBEntities(); if (userContext.Users.Where(x => x.Username == model.UserName).Count() == 0) { User u = new Scorekeeper.User(); u.Username = model.UserName; u.Password = model.Password; u.UserId = Guid.NewGuid(); u.FirstName = model.FirstName; u.LastName = model.LastName; userContext.AddToUsers(u); userContext.SaveChanges(); FormsAuthentication.SetAuthCookie(model.UserName, createPersistentCookie: false); createStatus = MembershipCreateStatus.Success; } else { createStatus = MembershipCreateStatus.DuplicateUserName; } if (createStatus == MembershipCreateStatus.Success) { return Json(new { success = true }); } else { ModelState.AddModelError("", ErrorCodeToString(createStatus)); } } // If we got this far, something failed return Json(new { errors = GetErrorsFromModelState() }); }
public bool ValidateUser(string userName, string password) { ScorekeeperDBEntities userContext = new ScorekeeperDBEntities(); var userQuery = from u in userContext.Users where u.Username == userName && u.Password == password select u; if (userQuery != null && userQuery.Count() > 0) { return true; } return false; }
public ActionResult Scorecard(FormCollection collection, ScorecardModel model) { ScorekeeperDBEntities s = new ScorekeeperDBEntities(); model.SelectedCourse = s.Courses.Where(x => x.CourseId == model.SelectedCourseValue).FirstOrDefault(); return PartialView("_ScorecardDetail", model); }