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