public ActionResult DeleteUsersFromSession(UsersEnrolledBySessionViewModel userEnrolledVM)
{
var filteredCollectionsOfUsersToDelete = userEnrolledVM.Enrollments.Where(x => x.isSelected == true);
bool usersDeleted = false;
using (WSADDbContext context = new WSADDbContext())
{
foreach (var userItems in filteredCollectionsOfUsersToDelete)
{
SessionCart dtoToDelete = context.SessionCartItems.FirstOrDefault(row => row.UserId == userItems.User.UserId && row.SessionId == userEnrolledVM.SessionId);
if (dtoToDelete != null)
{
context.SessionCartItems.Remove(dtoToDelete);
usersDeleted = true;
}
}
context.SaveChanges();
}
if (usersDeleted)
{
TempData["UsersRemoved"] = "Users Removed!";
return(RedirectToAction("GetEnrolledUsers", new { Id = userEnrolledVM.SessionId }));
}
return(RedirectToAction("GetEnrolledUsers", new { Id = userEnrolledVM.SessionId }));
}
public ActionResult GetEnrolledUsers(int?id = null)
{
//select userID from sessionCart where sessionId = id;
//id == sessionID
string sessionId = Session.SessionID;
UsersEnrolledBySessionViewModel userSessionViewModel;
using (WSADDbContext context = new WSADDbContext())
{
//get a list of users according to the session id that has been passed in
//select userID from sessionCart where sessionID = id;
Session sessionDTO;
int sessionID;
if (id.HasValue)
{
sessionDTO = context.Sessions.Find(id.Value);
}
else
{
sessionDTO = context.Sessions.FirstOrDefault(row => row.SessionTitle == sessionId);
}
if (sessionDTO == null)
{
return(Content("Session Invalid"));
}
sessionID = sessionDTO.SessionId;
//Get enrollment users
userSessionViewModel = new UsersEnrolledBySessionViewModel(
sessionID,
context.SessionCartItems.Where(x => x.SessionId == sessionID)
);
}
return(View(userSessionViewModel));
}
