public ActionResult EventSignup(string firstName, string lastName, string email, int eventId)
{
var db = new HockeySignupsDb(_connectionString);
var e = db.GetEventById(eventId);
var status = db.GetEventStatus(e);
if (status == EventStatus.InThePast)
{
TempData["Error"] = "You cannot sign up to a game in the past. Jerk.";
return RedirectToAction("Index");
}
else if (status == EventStatus.Full)
{
TempData["Error"] = "Nice try sucker....";
return RedirectToAction("Index");
}
EventSignup s = new EventSignup
{
Email = email,
FirstName = firstName,
LastName = lastName,
EventId = eventId
};
db.AddEventSignup(s);
TempData["Message"] =
"You have succesfully signed up for this weeks game, looking forward to checking you into the boards!";
return RedirectToAction("Index");
}
public void AddEventSignup(EventSignup es)
{
using (SqlConnection connection = new SqlConnection(_connectionString))
using (SqlCommand cmd = connection.CreateCommand())
{
cmd.CommandText =
"INSERT INTO EventSignups (Email, FirstName, LastName, EventId) VALUES (@email, @firstName, @lastName, @eventId)";
cmd.Parameters.AddWithValue("@email", es.Email);
cmd.Parameters.AddWithValue("@firstName", es.FirstName);
cmd.Parameters.AddWithValue("@lastName", es.LastName);
cmd.Parameters.AddWithValue("@eventId", es.EventId);
connection.Open();
cmd.ExecuteNonQuery();
}
}
public IEnumerable<EventSignup> GetEventSignups(int eventId)
{
var result = new List<EventSignup>();
InitiateDbAction(cmd =>
{
cmd.CommandText = "SELECT * FROM EventSignups WHERE EventId = @eventId";
cmd.Parameters.AddWithValue("@eventId", eventId);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
EventSignup es = new EventSignup
{
Id = (int)reader["Id"],
Email = (string)reader["Email"],
EventId = (int)reader["EventId"],
FirstName = (string)reader["FirstName"],
LastName = (string)reader["LastName"]
};
result.Add(es);
}
});
return result;
}
public void AddEventSignup(EventSignup es)
{
InitiateDbAction(cmd =>
{
cmd.CommandText =
"INSERT INTO EventSignups (Email, FirstName, LastName, EventId) VALUES (@email, @firstName, @lastName, @eventId)";
cmd.Parameters.AddWithValue("@email", es.Email);
cmd.Parameters.AddWithValue("@firstName", es.FirstName);
cmd.Parameters.AddWithValue("@lastName", es.LastName);
cmd.Parameters.AddWithValue("@eventId", es.EventId);
cmd.ExecuteNonQuery();
});
}
