public List <GameAttendance> getGameAttendance()
{
//make a list to store Games Attendance
List <GameAttendance> getAttended = new List <GameAttendance>();
//try to populate the list
try
{
using (SqlConnection con = new SqlConnection(Connection))
{
using (SqlCommand command = new SqlCommand("sp_AllAttendance", con))
{
command.CommandType = CommandType.StoredProcedure;
command.CommandTimeout = 10;
con.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
GameAttendance attendance = new GameAttendance();
if (reader["gameID"] != DBNull.Value)
{
attendance.GameID = (int)reader["gameID"];
}
else
{
attendance.GameID = GameAttendance.Null.GameID;
}
if (reader["userID_fk"] != DBNull.Value)
{
attendance.UserID = (int)reader["userID_fk"];
}
else
{
attendance.UserID = GameAttendance.Null.UserID;
}
if (reader["attended"] != DBNull.Value)
{
attendance.Attended = (bool)reader["attended"];
}
else
{
attendance.Attended = GameAttendance.Null.Attended;
}
getAttended.Add(attendance);
}
}
}
}
}
catch (Exception ex)
{
ExeceptionDataAccess exception = new ExeceptionDataAccess();
exception.StoreExceptions(ex);
}
return(getAttended);
}
public ActionResult CreateGameAttendance(GameAttendanceModel model)
{
if (ModelState.IsValid)
{
var user = Session["Users"] as Users;
GameAttendance gameAttendance = new GameAttendance
{
GameID = model.GameID,
UserID = model.UserID,
Attended = model.Attended
};
List <GameAttendance> duplicateCheck = attendance.getGameAttendaned();
bool duplicateEntry = duplicateCheck.Exists(m => m.UserID == model.UserID && m.GameID == model.GameID);
if (duplicateEntry)
{
ViewBag.Message = "User already has attendance recorded";
return(View(model));
}
else
{
attendance.CreateGameAttance(gameAttendance);
}
//check if insert added
List <GameAttendance> check = attendance.getGameAttendaned();
bool verify = check.Exists(m => m.UserID == model.UserID);
if (verify)
{
ViewBag.Message = "Attendance Added";
}
else
{
ViewBag.Message = "Creation Failed";
}
}
else
{
ViewBag.Message = "Model State is not Valid";
return(View(model));
}
return(View(model));
}
public ActionResult ViewGameAttendance()
{
var userInfo = Session["Users"] as Users;
List <GameAttendance> games = attendance.getGameAttendaned();
//get the list of users for only that team
List <Users> users = usersBLL.GetUsers().FindAll(m => m.TeamID == userInfo.TeamID);
//create a new list to store attendance for only that team
List <GameAttendance> viewAttendanceByTeam = new List <GameAttendance>();
//for each user in the coaches team
foreach (Users user in users)
{
//find the users attendance
GameAttendance game = games.Find(m => m.UserID == user.UserID);
//add to list that sorts attendance by team
viewAttendanceByTeam.Add(game);
}
return(View(viewAttendanceByTeam));
}
//Get A List of User who attended or didnt attend practice depending on input provided
public void CreateGameAttance(GameAttendance gameAttended)
{
try
{
using (SqlConnection con = new SqlConnection(Connection))
{
using (SqlCommand command = new SqlCommand("CreateGameAttendance", con))
{
command.CommandType = CommandType.StoredProcedure;
command.CommandTimeout = 10;
command.Parameters.AddWithValue("@gid", gameAttended.GameID);
command.Parameters.AddWithValue("@uid", gameAttended.UserID);
command.Parameters.AddWithValue("@attend", gameAttended.Attended);
con.Open();
command.ExecuteNonQuery();
}
}
}
catch (Exception ex)
{
ExeceptionDataAccess exception = new ExeceptionDataAccess();
exception.StoreExceptions(ex);
}
}
//Inserts a new Game Attendance
public void CreateGameAttance(GameAttendance gameAttended)
{
attendance.CreateGameAttance(gameAttended);
}
