// GET: Events/Create public ActionResult Create(NFLGameSchedule nFLGameSchedule) { Event newEvent = new Event(); newEvent.NFLGameScheduleId = nFLGameSchedule.Id; return(View(newEvent)); }
public ActionResult Create([Bind(Include = "Id,gameId,gameWeek,gameDate,awayTeam,homeTeam,gameTimeET,tvStation,winner")] NFLGameSchedule nFLGameSchedule) { //if (ModelState.IsValid) //{ // db.NFLGameSchedulesDb.Add(nFLGameSchedule); // db.SaveChanges(); // return RedirectToAction("Index"); //} //return View(nFLGameSchedule); NFLGameSchedule tempSchedule = new NFLGameSchedule(); List <List <string> > scheduleList = new List <List <string> >(); scheduleList = NFL_API.GET_NFL.RunAsyncSchedule(); for (int i = 0; i < scheduleList.Count; i++) { tempSchedule.gameId = scheduleList[i][0]; tempSchedule.gameWeek = scheduleList[i][1]; tempSchedule.gameDate = scheduleList[i][2]; tempSchedule.awayTeam = scheduleList[i][3]; tempSchedule.homeTeam = scheduleList[i][4]; tempSchedule.gameTimeET = scheduleList[i][5]; tempSchedule.tvStation = scheduleList[i][6]; tempSchedule.winner = scheduleList[i][7]; db.NFLGameSchedulesDb.Add(tempSchedule); db.SaveChanges(); } if (ModelState.IsValid) { return(RedirectToAction("Index")); } return(View(nFLGameSchedule)); }
public ActionResult DeleteConfirmed(int id) { NFLGameSchedule nFLGameSchedule = db.NFLGameSchedulesDb.Find(id); db.NFLGameSchedulesDb.Remove(nFLGameSchedule); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,gameId,gameWeek,gameDate,awayTeam,homeTeam,gameTimeET,tvStation,winner")] NFLGameSchedule nFLGameSchedule) { if (ModelState.IsValid) { db.Entry(nFLGameSchedule).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(nFLGameSchedule)); }
// GET: NFLGameSchedules/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } NFLGameSchedule nFLGameSchedule = db.NFLGameSchedulesDb.Find(id); if (nFLGameSchedule == null) { return(HttpNotFound()); } return(View(nFLGameSchedule)); }
public ActionResult ViewEvents(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } NFLGameSchedule nFLGameSchedule = db.NFLGameSchedulesDb.Find(id); if (nFLGameSchedule == null) { return(HttpNotFound()); } return(RedirectToAction("Index", "Events", nFLGameSchedule)); }
public ActionResult CommentSearch(int EventId) { Event newEvent = new Event(); newEvent = db.EventDb.Where(x => x.Id == EventId).FirstOrDefault(); NFLGameSchedule game = new NFLGameSchedule(); game = db.NFLGameSchedulesDb.Where(x => x.Id == newEvent.NFLGameScheduleId).FirstOrDefault(); string[] weather = NFL_API.GET_NFL.GetWeather(game.homeTeam); CommentSearchModel model = new CommentSearchModel() { EventId = EventId }; var PeopleComments = db.Comments.Where(y => y.EventId == model.EventId).ToList(); PeopleComments.Reverse(); model.List_Commments = PeopleComments; foreach (var item in PeopleComments) { var userId = db.Comments.FirstOrDefault(a => a.Comments == item.Comments); User commentUser = db.UserProfile.FirstOrDefault(b => b.Id == userId.UserId); model.UserName = commentUser.UserName; } Event eventDetail = db.EventDb.FirstOrDefault(y => y.Id == model.EventId); model.EventTitle = eventDetail.EventTitle; NFLGameSchedule eventSchedule = db.NFLGameSchedulesDb.FirstOrDefault(z => z.Id == eventDetail.NFLGameScheduleId); model.gameDate = eventSchedule.gameDate; model.gameWeek = eventSchedule.gameWeek; model.gameTimeET = eventSchedule.gameTimeET; model.homeTeam = eventSchedule.homeTeam; model.awayTeam = eventSchedule.awayTeam; model.EventComments = eventDetail.EventComments; model.stadium = weather[8]; model.isDome = weather[9]; model.geoLat = weather[10]; model.geoLong = weather[11]; model.low = weather[12]; model.high = weather[13]; model.forecast = weather[14]; model.windChill = weather[15]; model.windSpeed = weather[16]; model.domeImg = weather[17]; model.smallImg = weather[18]; model.mediumImg = weather[19]; model.largeImg = weather[20]; return(View(model)); }
// GET: Events public ActionResult Index(NFLGameSchedule nFLGameSchedule) { return(View(db.EventDb.Where(x => x.NFLGameScheduleId == nFLGameSchedule.Id).ToList())); }