public ActionResult JoinGame()
{
HockeyDb db = new HockeyDb(Properties.Settings.Default.ConStr);
JoinGameView jgv = new JoinGameView();
jgv.game = db.GetUpcomingGame();
jgv.PlayersJoined = db.PlayersJoined(jgv.game.Id);
jgv.player = new Player();
HttpCookie FirstName = Request.Cookies["FirstName"];
HttpCookie LastName = Request.Cookies["LastName"];
HttpCookie Email = Request.Cookies["Email"];
if (FirstName != null)
{
jgv.player.FirstName = FirstName.Value;
}
if (LastName != null)
{
jgv.player.LastName = LastName.Value;
}
if (Email != null)
{
jgv.player.Email = Email.Value;
}
return(View(jgv));
}
public ActionResult AddSignUp(string firstName, string lastname, string email, int eventid)
{
HockeyDb db = new HockeyDb(conn);
Event e = new Event();
e = db.GetLatestEvent();
ViewModel vm = new ViewModel();
vm.Event = e;
vm.Status = db.GetEventStatus(e);
if (vm.Status == EventStatus.Open)
// if (db.GetNumberofSignUps(eventid) < db.GetMaxPlayersForEvent(eventid) && e.Dt > DateTime.Now)
{
SignUp s = new SignUp();
s.FirstName = firstName;
s.LastName = lastname;
s.Email = email;
s.EventId = eventid;
db.CreateSignUps(s);
TempData["Message"] = "You're successfully signed up!!";
}
else
{
TempData["Message"] = "YOU are NOT signed up!";
}
return(RedirectToAction("index"));
}
public ActionResult Edit()
{
HockeyDb db = new HockeyDb(_conn);
var allCurrentSignUps = db.GetCurrentSignUps(db.GetLatestEvent().EventId);
return(View(allCurrentSignUps));
}
public ActionResult AddEmail(string email)
{
HockeyDb db = new HockeyDb(conn);
db.AddToEmailList(email);
TempData["Message"] = "Email-Added!";
return(RedirectToAction("index"));
}
public ActionResult SeeHistory()
{
SeeHistoryModel shm = new SeeHistoryModel();
HockeyDb db = new HockeyDb(Properties.Settings.Default.ConStr);
shm.Games = db.GetGamesWithPlayerCount();
return(View(shm));
}
public ActionResult SeePlayers(int Id)
{
SeePlayerView spv = new SeePlayerView();
HockeyDb db = new HockeyDb(Properties.Settings.Default.ConStr);
spv.Players = db.GetPlayers(Id);
spv.GameId = Id;
return(View(spv));
}
public ActionResult AddSignUp()
{
HockeyDb db = new HockeyDb(conn);
Event e = new Event();
e = db.GetLatestEvent();
ViewModel vm = new ViewModel();
vm.Event = e;
vm.Status = db.GetEventStatus(e);
return(View(vm));
}
public ActionResult AddPlayer(Player player)
{
HttpCookie FirstName = new HttpCookie("FirstName", player.FirstName);
HttpCookie LastName = new HttpCookie("LastName", player.LastName);
HttpCookie Email = new HttpCookie("Email", player.Email);
Response.Cookies.Add(FirstName);
Response.Cookies.Add(LastName);
Response.Cookies.Add(Email);
HockeyDb db = new HockeyDb(Properties.Settings.Default.ConStr);
db.AddPlayer(player);
return(Redirect("/"));
}
public ActionResult AddGame(Game game)
{
HockeyDb db = new HockeyDb(Properties.Settings.Default.ConStr);
db.AddGame(game);
IEnumerable <Player> signUps = db.GetSignUps();
Email sendEmails = new Email();
foreach (Player signUp in signUps)
{
string emailBody = $"Hi {signUp.FirstName} {signUp.LastName}, \n \t Great news.... We've posted a new upcoming game scheduled for {game.Date.ToShortDateString()}. SignUp as long as there's still room. Hope to see you!!";
sendEmails.SendEmail(signUp.Email, "New Game Posted!!", emailBody);
}
return(Redirect("/"));
}
public ActionResult AddSignUP(Player signUp)
{
HttpCookie FirstName = new HttpCookie("FirstName", signUp.FirstName);
HttpCookie LastName = new HttpCookie("LastName", signUp.LastName);
HttpCookie Email = new HttpCookie("Email", signUp.Email);
Response.Cookies.Add(FirstName);
Response.Cookies.Add(LastName);
Response.Cookies.Add(Email);
HockeyDb db = new HockeyDb(Properties.Settings.Default.ConStr);
db.AddSignUp(signUp);
Email email = new Email();
email.SendEmail(signUp.Email, "Sign Up confirmation email", $"Welcome {signUp.FirstName} {signUp.LastName} to our Games. You've been signed up for weekly notifications");
return(Redirect("/"));
}
public ActionResult CreateGame(int players, DateTime dateTime, bool email)
{
HockeyDb db = new HockeyDb(_conn);
Event e = new Event();
e.Players = players;
e.Dt = dateTime;
//TempData["Updated"] = true;
e.EventId = db.CreateEvent(e);
if (email)
{
db.SendEmail("The next game will be on" + e.Dt.ToLongDateString() + " at " + e.Dt.ToShortTimeString());
}
//{
// IEnumerable<Notifications> elist = db.GetEmailList();
// foreach (Notifications n in elist)
// {
// db.SendEmail("*****@*****.**", "Hockey", "The next game will be on" + e.Dt.ToLongDateString() + " at " + e.Dt.ToShortTimeString());
// }
//}
return(RedirectToAction("index", "home"));
}
public ActionResult Index()
{
HockeyDb db = new HockeyDb(_conn);
return(View());
}
