// GET: CourseMains/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CourseMain courseMain = db.CourseMains.Find(id); if (courseMain == null) { return(HttpNotFound()); } return(View(courseMain)); }
// GET: CourseMains/Details/5 public ActionResult Details(int id) { CourseMain courseMain = db.CourseMains.Find(id); if (courseMain == null) { return(HttpNotFound()); } // Get Course Details (Card of Course) var CourseDetail = from cd in db.CourseDetails where cd.CourseID == id select cd; ViewBag.ClubName = courseMain.ClubName; // Get 9 Holes Total and Store in ViewBag variables // Front 9 ViewBag.FrontWhiteYrds = cInfo.GetCourseTotal(1, 9, id, "WhiteYrds"); ViewBag.FrontYellowYrds = cInfo.GetCourseTotal(1, 9, id, "YellowYrds"); ViewBag.FrontMensPar = cInfo.GetCourseTotal(1, 9, id, "MensPar"); ViewBag.FrontRedYrds = cInfo.GetCourseTotal(1, 9, id, "RedYrds"); ViewBag.FrontLadiesPar = cInfo.GetCourseTotal(1, 9, id, "LadiesPar"); //Back 9 ViewBag.BackWhiteYrds = cInfo.GetCourseTotal(10, 18, id, "WhiteYrds"); ViewBag.BackYellowYrds = cInfo.GetCourseTotal(10, 18, id, "YellowYrds"); ViewBag.BackMensPar = cInfo.GetCourseTotal(10, 18, id, "MensPar"); ViewBag.BackRedYrds = cInfo.GetCourseTotal(10, 18, id, "RedYrds"); ViewBag.BackLadiesPar = cInfo.GetCourseTotal(10, 18, id, "LadiesPar"); // Totals ViewBag.TotalWhiteYrds = Convert.ToInt32(ViewBag.FrontWhiteYrds + Convert.ToInt32(ViewBag.BackWhiteYrds)); ViewBag.TotalYellowYrds = Convert.ToInt32(ViewBag.FrontYellowYrds + Convert.ToInt32(ViewBag.BackYellowYrds)); ViewBag.TotalMensPar = Convert.ToInt32(ViewBag.FrontMensPar + Convert.ToInt32(ViewBag.BackMensPar)); ViewBag.TotalRedYrds = Convert.ToInt32(ViewBag.FrontRedYrds + Convert.ToInt32(ViewBag.BackRedYrds)); ViewBag.TotalLadiesPar = Convert.ToInt32(ViewBag.FrontLadiesPar + Convert.ToInt32(ViewBag.BackLadiesPar)); return(View(CourseDetail.ToList())); }
public ActionResult Create([Bind(Include = "CourseID,ClubName,WhiteSSS,YellowSSS,RedSSS")] CourseMain courseMain) { if (ModelState.IsValid) { db.CourseMains.Add(courseMain); db.SaveChanges(); // Create 18 Hole Details for Main Course Record for (int i = 1; i < 19; i++) { var cDetail = new Models.CourseDetail(); cDetail.CourseID = courseMain.CourseID; cDetail.HoleNumber = i; db.CourseDetails.Add(cDetail); } db.SaveChanges(); return(RedirectToAction("Index")); } return(View(courseMain)); }
public ActionResult PlayerScoreCard(int?compScoreID, int rndNumber) { ScoreInfo scoreInfo = new ScoreInfo(); if (compScoreID == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CompScore compScore = db.CompScores.Find(compScoreID); int NumberofRnds = pStats.NumberRndsPlayed(Convert.ToInt32(compScore.CompID), compScore.CompPlayerID); if (NumberofRnds < rndNumber) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } // Get Course Logo using a stored procedure using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(Helper.CnnValue("TigerLineScoresDB"))) { List <String> courseLogo = connection.Query <string>("dbo.spGetLogoImagePath @CourseID", new { CourseID = compScore.CourseID }).ToList(); ViewBag.CourseLogo = courseLogo[0]; } ViewBag.PHcap = compScore.PlayerHcap; ViewBag.PlayerName = pStats.GetPlayerName(compScore.CompPlayerID); ViewBag.PlayerPhoto = pStats.GetPlayerPhoto(compScore.CompPlayerID); ViewBag.PlayerHomeID = pStats.HomeClubID(compScore.CompPlayerID); ViewBag.RndDate = compScore.RndDate; ViewBag.RndNumber = rndNumber; // Score Card Image ViewBag.CardImage = compInfo.GetScoreCardImage(compScore.CompScoreID); CourseMain courseM = db.CourseMains.Find(compScore.CourseID); ViewBag.CourseName = courseM.ClubName; CompMain cMain = db.CompMains.Find(compScore.CompID); ViewBag.CompName = cMain.CompName; // Get the Course Par ViewBag.CoursePar = cInfo.GetCoursePar(compScore.CourseID, compScore.TeeColour); // Get the NET Points (Gross Points - (CoursePar - SSS)) ViewBag.NetPoints = compScore.TotalPoints - (ViewBag.CoursePar - compScore.SSS); if (compScore == null) { return(HttpNotFound()); } // Get Course Details depending on course and tee colour selected int courseID = compScore.CourseID; string teeColour = compScore.TeeColour; decimal?PHcap = compScore.PlayerHcap; ViewBag.scoreCard = cInfo.GetCourseDetails(Convert.ToInt32(courseID), teeColour); // Get Hole Scores ViewBag.CurrentScore = compScore; // Front 9 Total Score ViewBag.FrontScore = scoreInfo.FrontScore(compScore.CompScoreID); // Back 9 Total Score ViewBag.BackScore = scoreInfo.BackScore(compScore.CompScoreID); // Total Score ViewBag.TotalScore = ViewBag.FrontScore + ViewBag.BackScore; // Blank Points CompPoints compPoints = pScore.GetCompPoints(compScore); ViewBag.RndPoints = compPoints; // Get Course Totals depending on course and tee colour - Store totals in View bag variables CourseTotals cTotals = cInfo.GetCourseTotals(Convert.ToInt32(courseID), teeColour); ViewBag.TeeColour = cTotals.teeColour; ViewBag.FrontYrds = cTotals.frontYrds; ViewBag.BackYrds = cTotals.backYrds; ViewBag.TotalYrds = cTotals.totalYrds; ViewBag.FrontPar = cTotals.frontPar; ViewBag.BackPar = cTotals.backPar; ViewBag.TotalPar = cTotals.totalPar; // Store the playing handicap in the ViewBag var playingHCap = 0; if (PHcap != null) { playingHCap = Convert.ToInt32(PHcap); } ViewBag.PHcap = playingHCap; return(PartialView("_ScoreCard", compScore)); }