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