// 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()));
}
