public IActionResult Games(Account account) { //List<Guid> iamgeIds = _Context.Image.Select(m => m.Id).ToList(); //return View(iamgeIds); var test = _Context.GameSchedule.ToList(); var model = new List <GameSchedule>(); foreach (var i in test) { var s = new GameSchedule(); { s.Tournament = i.Tournament; s.TourGameNo = i.TourGameNo; s.GameTime = i.GameTime; s.FirstTeam = i.FirstTeam; s.SecondTeam = i.SecondTeam; model.Add(s); } } return(View(model)); }
public IActionResult NewGame(GameSchedule gameSchedule) { _Context.GameSchedule.Add(gameSchedule); _Context.SaveChanges(); return(RedirectToAction("Games")); }
public async Task <ActionResult <GameSchedule> > PostGameSchedule(GameSchedule item) { _context.GameSchedule.Add(item); // Add a single object to the database await _context.SaveChangesAsync(); // Save the added object to the database return(CreatedAtAction(nameof(GetGameSchedule), item)); // Return the object details to the api user }
public IActionResult Delete(GameSchedule gameSchedule) { var data = _Context.GameSchedule.Where(u => u.GameNo == gameSchedule.GameNo).FirstOrDefault(); var model = _Context.GameSchedule.ToList(); _Context.Remove(data); _Context.SaveChanges(); return(RedirectToAction("SetSChedule")); }
public async Task <ActionResult <GameSchedule> > GetGameScheduleItem(long id) { GameSchedule item = await _context.GameSchedule.FindAsync(id); // Check if the id is in the database if (item == null) { return(NotFound()); } return(item); // If the id exists then return that object which is a single instance }
public async Task <IActionResult> PutGameScheduleItem(string Id, GameSchedule item) { if (Id != item.Id) // Check if the id argument exists in the database { return(BadRequest()); // Cancel the request if it doesn't } _context.Entry(item).State = EntityState.Modified; // If so, EntitySate uses the Modified property to flag any changes await _context.SaveChangesAsync(); // Update & save the data return(Content("MODEL has been updated!")); }
public async Task <IActionResult> DeleteGameScheduleItem(short id) { GameSchedule model = await _context.GameSchedule.FindAsync(id); if (model == null) { return(NotFound()); } _context.GameSchedule.Remove(model); // Remove the record if it is found await _context.SaveChangesAsync(); return(Content("Model has been removed ~")); }
public IActionResult SetSChedule(Account account) { var test = _Context.GameSchedule.ToList(); var model = new List <GameSchedule>(); foreach (var i in test) { var s = new GameSchedule(); { s.GameNo = i.GameNo; s.Tournament = i.Tournament; s.TourGameNo = i.TourGameNo; s.GameTime = i.GameTime; s.FirstTeam = i.FirstTeam; s.SecondTeam = i.SecondTeam; model.Add(s); } } return(View(model)); }
//[HttpPost] //public IActionResult NewGame(IList<IFormFile> files, GameSchedule gameSchedule) //{ // IFormFile uploadedImage = files.FirstOrDefault(); // if (uploadedImage == null || uploadedImage.ContentType.ToLower().StartsWith("image/")) // { // MemoryStream ms = new MemoryStream(); // uploadedImage.OpenReadStream().CopyTo(ms); // System.Drawing.Image image = System.Drawing.Image.FromStream(ms); // Models.Image imageEntity = new Models.Image() // { // Id = Guid.NewGuid(), // Name = uploadedImage.Name, // Data = ms.ToArray(), // Width = image.Width, // Height = image.Height, // ContentType = uploadedImage.ContentType // }; // _Context.Image.Add(imageEntity); // _Context.SaveChanges(); // } // return RedirectToAction("Games"); //} public IActionResult Delete(GameSchedule gameSchedule) { var data = _Context.GameSchedule.Where(u => u.GameNo == gameSchedule.GameNo).FirstOrDefault(); var model = _Context.GameSchedule.ToList(); //var dateAsString = DateTime.Now; //foreach (var x in model) //{ // int result = DateTime.Compare(dateAsString, x.GameTime); // if(result>0) // { // _Context.GameSchedule.Remove(x); // _Context.SaveChanges(); // } //} _Context.Remove(data); _Context.SaveChanges(); return(RedirectToAction("SetSChedule")); }
public ActionResult ManageResults( int seasonid, int id, DateTime date, int? gameid ) { var season = new Season(); var games = new List<GameSchedule>(); var game = new GameSchedule(); var homeTeam = new Team(); var awayTeam = new Team(); var awayTeamPlayers = new List<Player>(); var homeTeamPlayers = new List<Player>(); var homeGoalies = new List<Player>(); var awayGoalies = new List<Player>(); var playerScoring = new List<GameScoring>(); var awayGoalieScoring = new GameGoaltending(); var homeGoalieScoring = new GameGoaltending(); var gameDetails = new GameDetail(); var selectedHomeGoalie = 0; var selectedAwayGoalie = 0; if ( seasonid > 0 ) { season = ( from s in db.Seasons where s.Id == seasonid select s ).SingleOrDefault<Season>(); games = ( from g in db.GameSchedules where g.SeasonId == season.Id && g.GameDate == date orderby g.GameTime ascending select g ).ToList<GameSchedule>(); if ( games.Count == 0 ) Response.Redirect( "/LeagueManager/" + season.Id.ToString() + "/Result?error=nogames" ); if ( gameid == null || gameid <= 0 ) gameid = games.First().Id; game = ( from g in db.GameSchedules where g.Id == gameid select g ).SingleOrDefault<GameSchedule>(); homeTeam = ( from t in db.Teams where t.Id == game.HomeTeamId select t ).SingleOrDefault<Team>(); awayTeam = ( from t in db.Teams where t.Id == game.AwayTeamId select t ).SingleOrDefault<Team>(); awayTeamPlayers = ( from tp in db.TeamPlayers from p in db.Players where tp.PlayerId == p.Id && tp.TeamId == awayTeam.Id && p.Position1 != "Goalie" && tp.SeasonId == seasonid orderby p.LastName ascending, p.FirstName ascending select p ).ToList<Player>(); awayTeamPlayers.Add( GetPlayerSub() ); homeTeamPlayers = ( from tp in db.TeamPlayers from p in db.Players where tp.PlayerId == p.Id && tp.TeamId == homeTeam.Id && p.Position1 != "Goalie" && tp.SeasonId == seasonid orderby p.LastName ascending, p.FirstName ascending select p ).ToList<Player>(); homeTeamPlayers.Add( GetPlayerSub() ); awayGoalies = ( from tp in db.TeamPlayers from p in db.Players where tp.TeamId == awayTeam.Id && p.Id == tp.PlayerId && tp.IsGoalie == true && tp.SeasonId == seasonid orderby p.LastName ascending select p ).ToList<Player>(); if ( awayGoalies.Count == 1 ) selectedAwayGoalie = awayGoalies.First().Id; awayGoalies.Add( GetGoalieSub() ); homeGoalies = ( from tp in db.TeamPlayers from p in db.Players where tp.TeamId == homeTeam.Id && p.Id == tp.PlayerId && tp.IsGoalie == true && tp.SeasonId == seasonid orderby p.LastName ascending select p ).ToList<Player>(); if ( homeGoalies.Count == 1 ) selectedHomeGoalie = homeGoalies.First().Id; homeGoalies.Add( GetGoalieSub() ); playerScoring = ( from gs in db.GameScorings where gs.GameScheduleId == game.Id select gs ).ToList<GameScoring>(); homeGoalieScoring = ( from gt2 in db.GameGoaltendings from p in db.Players where gt2.GameScheduleId == game.Id && gt2.TeamId == homeTeam.Id && ( p.Id == gt2.PlayerId ) select gt2 ).SingleOrDefault<GameGoaltending>(); awayGoalieScoring = ( from gt3 in db.GameGoaltendings from p in db.Players where gt3.GameScheduleId == game.Id && gt3.TeamId == awayTeam.Id && ( p.Id == gt3.PlayerId ) select gt3 ).SingleOrDefault<GameGoaltending>(); gameDetails = ( from gd in db.GameDetails where gd.GameScheduleId == game.Id select gd ).SingleOrDefault<GameDetail>(); } else throw new Exception( "SeasonId value is invalid: 0" ); return View( "ManageGameResult", new GameResultModel { Season = season, Date = date, SelectedGame = ( gameid > 0 ) ? game : games.First(), Games = new SelectList( games, "Id", "GameTime", ( game.Id > 0 ) ? game.Id : games.First().Id ), AwayTeam = awayTeam, HomeTeam = homeTeam, AwayTeamPlayers = awayTeamPlayers, AwayTeamGoalies = new SelectList( awayGoalies, "Id", "LastName", ( awayGoalieScoring != null ) ? awayGoalieScoring.PlayerId : selectedAwayGoalie ), HomeTeamPlayers = homeTeamPlayers, HomeTeamGoalies = new SelectList( homeGoalies, "Id", "LastName", ( homeGoalieScoring != null ) ? homeGoalieScoring.PlayerId : selectedHomeGoalie ), PlayerScoring = playerScoring, HomeGoalieScoring = homeGoalieScoring, AwayGoalieScoring = awayGoalieScoring, GameDetails = gameDetails, Ref1 = new SelectList( GetRefs(), "Id", "LastName", ( gameDetails != null ) ? gameDetails.Referee1 : 0 ), Ref2 = new SelectList( GetRefs(), "Id", "LastName", ( gameDetails != null ) ? gameDetails.Referee2 : 0 ) } ); }
public JsonResult AddOrUpdateGameSchedule( int gameid, int seasonid, int awayteamid, int hometeamid, string gamedate, string gametime, bool playoffs ) { var timeDate = DateTime.Parse( gamedate ).ToShortDateString(); GameSchedule game = new GameSchedule(); game.Id = gameid; game.SeasonId = seasonid; game.AwayTeamId = awayteamid; game.HomeTeamId = hometeamid; game.GameDate = DateTime.Parse( gamedate ); game.GameTime = DateTime.Parse( timeDate + " " + gametime ); game.Playoffs = playoffs; var addedgameId = gameid; if ( game.Id > 0 ) gameRepository.Update( game ); else addedgameId = int.Parse( gameRepository.Add( game ).ToString() ); game.Id = addedgameId; game = ( from g in db.GameSchedules where g.Id == game.Id select g ).SingleOrDefault<GameSchedule>(); var homeTeamName = ( from h in db.Teams where h.Id == game.HomeTeamId select h.Name ).SingleOrDefault(); var awayTeamName = ( from a in db.Teams where a.Id == game.AwayTeamId select a.Name ).SingleOrDefault(); return ( game != null ) ? Json( new { id = game.Id.ToString(), seasonid = game.SeasonId.ToString(), hometeamid = game.HomeTeamId.ToString(), hometeamname = homeTeamName.ToString(), awayteamid = game.AwayTeamId.ToString(), awayteamname = awayTeamName.ToString(), gamedate = game.GameDate.ToShortDateString(), gametime = game.GameTime.ToShortTimeString(), playoffs = game.Playoffs.ToString().ToLower() } ) : null; }
public static void CreateAccountsIfNeccesary(string connString) { var sqlcontrols = new SqlControls(connString); var userRoles = sqlcontrols.MultiSelectData <UserRole>("Select * From UserRoles"); if (userRoles.Count == 0) { var admin = new UserRole() { Name = "Admin" }; var agent = new UserRole() { Name = "Agent" }; sqlcontrols.Add("UserRoles", admin); sqlcontrols.Add("UserRoles", agent); } var cities = sqlcontrols.MultiSelectData <City>("Select * From Cities"); if (cities.Count == 0) { var city = new City() { Name = "Olongapo City" }; sqlcontrols.Add("Cities", city); } var workLocations = sqlcontrols.MultiSelectData <WorkLocation>("Select * From WorkLocations"); if (workLocations.Count == 0) { var workLocation = new WorkLocation() { Name = "Head Quarter", Barangay = "Sample Barangay", CityId = 1 }; sqlcontrols.Add("WorkLocations", workLocation); } var employees = sqlcontrols.MultiSelectData <Employee>("Select * From Employees"); if (employees.Count == 0) { var adminEmployee = new Employee() { NickName = "System Generated Super Admin", FirstName = "Super", LastName = "Admin", MiddleName = "Pre Generated", Address = "Olongapo City (System Generated)", ContactNumber = "N/A (Edit Upon Official Use)", EmailAddress = "N/A (Edit Upon Official Use)", WorkLocationId = 1, DateTimeCreated = DateTime.Now }; var agentEmployee = new Employee() { NickName = "System Generated Agent", FirstName = "Agent", LastName = "Employee", MiddleName = "Pre Generated", Address = "Olongapo City (System Generated)", ContactNumber = "N/A (Edit Upon Official Use)", EmailAddress = "N/A (Edit Upon Official Use)", WorkLocationId = 1, DateTimeCreated = DateTime.Now }; sqlcontrols.Add("Employees", adminEmployee); sqlcontrols.Add("Employees", agentEmployee); } var users = sqlcontrols.MultiSelectData <User>("Select * From Users"); if (users.Count == 0) { var adminUser = new User() { UserName = "******", Password = AES.Encrypt(_defaultPassword), UserRoleId = 1, EmployeeId = 1, DateTimeCreated = DateTime.Now }; var agentUser = new User() { UserName = "******", Password = AES.Encrypt(_defaultPassword), UserRoleId = 2, EmployeeId = 2, DateTimeCreated = DateTime.Now }; sqlcontrols.Add("Users", adminUser); sqlcontrols.Add("Users", agentUser); } var gameModes = sqlcontrols.MultiSelectData <GameMode>("Select * From GameModes"); if (gameModes.Count == 0) { var straightGame = new GameMode() { Name = "Straight" }; var mixedGame = new GameMode() { Name = "Straight" }; sqlcontrols.Add("GameModes", straightGame); sqlcontrols.Add("GameModes", mixedGame); } var gameSchedules = sqlcontrols.MultiSelectData <GameSchedule>("Select * From GameSchedules"); if (gameModes.Count == 0) { var morningGame = new GameSchedule() { Name = "Moring Session", EntryStart = TimeSpan.Parse("7:00"), EntryEnd = TimeSpan.Parse("8:30"), DrawTime = TimeSpan.Parse("9:00"), IsActive = true, DateTimeCreated = DateTime.Now }; sqlcontrols.Add("GameSchedules", morningGame); } }