// // GET: /Game/Edit/5 public ActionResult Edit(int id = 0) { FoxTickerEntities db = new FoxTickerEntities(); spTICK_Games_GetByEntryID_Result Game; //if (id != 0) //{ if (id == 0) { return(View(new Game())); } Game = db.spTICK_Games_GetByEntryID(0, id, 2, false, false).First();; if (Game == null) { return(HttpNotFound()); } ViewData["Games"] = db.spTICK_Games_GetByEntryID(0, id, 2, false, false).First(); //ViewData["Users"] = db.Users.Distinct().Select(a => new { ID = a.UserID, Name = a.FirstName + " " + a.LastName }); //} //else // Game = new Game(); //null team Team newTeam = new Team(); newTeam.ID = -1; newTeam.NickName = "NONE"; List <Team> teams = new List <Team>(); teams.Add(newTeam); //foreach (Note n in db.Notes.Where(n => n.GameID == id)) //{ // int iSport = db.Teams.Where(t => t.ID == n.TeamID).FirstOrDefault().SportID; // if (teams.Where(t => t.SportID == iSport).Count() == 0) // teams.AddRange(db.Teams.Where(tw => tw.SportID == iSport).ToList()); //} teams.AddRange(db.Teams.ToList()); ViewData["Teams"] = teams; //if (Game.TeamID != null) // if (Game.TeamID != -1 && Game.TeamID != 0) // ViewData["SportID"] = db.Teams.Single(s => s.ID == Game.TeamID).SportID; return(View(Game)); }
public void Load(int EntryID, int ClientID, int EntryTypeID, bool onlyFinals, bool onlySorted) { ID = EntryID; clientID = ClientID; entryTypeID = EntryTypeID; bOnlyFinals = onlyFinals; bOnlySorted = onlySorted; Games = db.spTICK_Games_GetByEntryID(clientID, ID, entryTypeID, bOnlyFinals, bOnlySorted).Except(GamesOmitted, new spTICK_Games_GetByEntryID_ResultComparer()).ToList(); if (Games == null) { throw new Exception("No Games available."); } ieGames = Games.GetEnumerator(); }
// // GET: /Game/Details/5 public ActionResult Details(int id = 0) { spTICK_Games_GetByEntryID_Result Game = db.spTICK_Games_GetByEntryID(0, id, 2, false, false).First(); if (Game == null) { return(HttpNotFound()); } return(View(Game)); }
public IEnumerable <dynamic> GetPlaylistItems(int cid, int entryID, int EntryTypeID) { Utilities.LoadClientShares(db, cid); List <dynamic> retGroups = new List <dynamic>(); if (entryID == 0) { switch (EntryTypeID) { case (int)Ticker.Data.Enums.EntryType.Group: //A group. The GroupID is defined in the EntryID field. { foreach (Client c in db.Clients.Single(s => s.ID == cid).Clients) { retGroups = retGroups.Concat(db.Groups.OrderBy(gob => gob.Name).Where(gw => gw.ClientID == c.ID).Select(g => new { // Skip the EntityState and EntityKey properties inherited from EF. It would break model binding. g.ClientID, g.CreatedName, g.Editable, g.GroupAnimationTypeID, g.Header, g.ID, g.LastUpdated, Name = g.Name + " -" + System.Data.Objects.SqlClient.SqlFunctions.StringConvert((double)db.Notes.Where(gn => gn.GroupID == g.ID).Count()), //g.Notes, g.OnAirName, g.TeamID, g.Type , ObjectType = "Group" , hasChildren = db.Notes.Where(gn => gn.GroupID == g.ID).Any() })).ToList(); } return(retGroups.Concat(db.Groups.OrderBy(gob => gob.Name).Where(gw => gw.ClientID == cid).Select(g => new { // Skip the EntityState and EntityKey properties inherited from EF. It would break model binding. g.ClientID, g.CreatedName, g.Editable, g.GroupAnimationTypeID, g.Header, g.ID, g.LastUpdated, Name = g.Name + " -" + System.Data.Objects.SqlClient.SqlFunctions.StringConvert((double)db.Notes.Where(gn => gn.GroupID == g.ID).Count()), //g.Notes, g.OnAirName, g.TeamID, g.Type , ObjectType = "Group" , hasChildren = db.Notes.Where(gn => gn.GroupID == g.ID).Any() }))); } case (int)Ticker.Data.Enums.EntryType.TodaysGames: //All games for a given sport for today. The sport is defined in the EntryID field. { foreach (Client c in db.Clients.Single(s => s.ID == cid).Clients) { retGroups = retGroups.Concat(db.spTICK_Games_GetByEntryID(cid, entryID, entryTypeID: EntryTypeID, onlyFinals: false, onlySorted: false).Select(g => new { g.ID, Name = g.Matchup, ObjectType = "Game", hasChildren = db.spTICK_GameNotes_GetByGameID(gameID: entryID, clientID: c.ID).Any() })).ToList(); } return(retGroups.Concat(db.spTICK_Games_GetByEntryID(cid, entryID, entryTypeID: EntryTypeID, onlyFinals: false, onlySorted: false).Select(g => new { g.ID, Name = g.Matchup, ObjectType = "Game", hasChildren = db.spTICK_GameNotes_GetByGameID(gameID: entryID, clientID: cid).Any() }))); } // return db.PlaylistDetails.Where(pldw => pldw.EntryID == groupID).Select(g => new //{ // // Skip the EntityState and EntityKey properties inherited from EF. It would break model binding. // g.EntryID, // Name = g.OnAirName, // g.EntryTypeID, // g.PlaylistID, // g.SortOrder, // hasChildren = true //}); ; default: return(null); } } else { switch (EntryTypeID) { case (int)Ticker.Data.Enums.EntryType.Group: //A group. The GroupID is defined in the EntryID field. return(db.Groups.Where(gw => gw.ID == entryID).Select(g => new { // Skip the EntityState and EntityKey properties inherited from EF. It would break model binding. g.ClientID, g.CreatedName, g.Editable, g.GroupAnimationTypeID, g.Header, g.ID, g.LastUpdated, Name = g.OnAirName, //g.Notes, g.OnAirName, g.TeamID, g.Type , ObjectType = "Group" , hasChildren = db.Notes.Where(gn => gn.GroupID == entryID).Any() })); default: return(null); case (int)Ticker.Data.Enums.EntryType.TodaysGames: //All games for a given sport for today. The sport is defined in the EntryID field. { foreach (Client c in db.Clients.Single(s => s.ID == cid).Clients) { retGroups = retGroups.Concat(db.spTICK_Games_GetByEntryID(cid, entryID, entryTypeID: EntryTypeID, onlyFinals: false, onlySorted: false).Select(g => new { g.ID, Name = g.Matchup, ObjectType = "Game", hasChildren = db.spTICK_GameNotes_GetByGameID(gameID: entryID, clientID: c.ID).Any() })).ToList(); } return(retGroups.Concat(db.spTICK_Games_GetByEntryID(cid, entryID, entryTypeID: EntryTypeID, onlyFinals: false, onlySorted: false).Select(g => new { g.ID, Name = g.Matchup, ObjectType = "Game", hasChildren = db.spTICK_GameNotes_GetByGameID(gameID: entryID, clientID: cid).Any() }))); } //spTICK_Games_GetByEntryID_Result a = new spTICK_Games_GetByEntryID_Result(); //dynamic a = new PlaylistDetailsType(); //dynamic a = new []{ new {ID = 0}, new {Name = "Today"}, new {ObjectType = "Game"}, new {hasChildren = false} }; //a.ID=0; //a.Name="Today"; //a.ObjectType="Game"; //a.hasChildren=false; //var a = new { ID = 0, Name = "Today", ObjectType = "Game", hasChildren = false }; ////IEnumerable<dynamic> b = a; ////ret.Concat(new []{ new {ID = 0}, new {Name = "Today"}, new {ObjectType = "Game"}, new {hasChildren = false} }); //ret.Concat(Enumerable.Repeat(a, 1)); //ret.Concat(db.spTICK_Games_GetByEntryID(id, entryID, entryTypeID: EntryTypeID, onlyFinals: false, onlySorted: false).Select(g => new //{ // g.ID, // Name = g.Matchup, // ObjectType = "Game", // hasChildren = db.spTICK_GameNotes_GetByGameID(gameID: entryID, clientID: id).Any() //})); //return ret; // return db.PlaylistDetails.Where(pldw => pldw.EntryID == groupID).Select(g => new //{ // // Skip the EntityState and EntityKey properties inherited from EF. It would break model binding. // g.EntryID, // Name = g.OnAirName, // g.EntryTypeID, // g.PlaylistID, // g.SortOrder, // hasChildren = true //}); ; case (int)Ticker.Data.Enums.EntryType.GroupOfGames: return(db.GroupGames.Where(gw => gw.GroupID == entryID) .Select(sg => new { sg.ID, sg.HiveID, sg.GroupID, sg.GameID, sg.SportID, sg.SortOrder }) .AsEnumerable() .OrderBy(o => o.SortOrder) .Select(g => new { // Skip the EntityState and EntityKey properties inherited from EF. It would break model binding. Name = "", Type = "DataHive", Header = g.HiveID, HivePrefix = db.Sports.Single(s => s.ID == g.SportID).HivePrefix, g.ID, g.HiveID, g.GroupID, g.GameID, g.SportID, g.SortOrder })); } } }