public ActionResult Edit(int id)
{
EditViewModel editVM;
using (WSADDbContext context = new WSADDbContext())
{
User userDTO = context.Users.Find(id);
if (userDTO == null)
{
return(Content("Invalid ID"));
}
editVM = new EditViewModel()
{
UserId = userDTO.UserId,
UserFirstName = userDTO.UserFirstName,
UserLastName = userDTO.UserLastName,
UserEmailAddress = userDTO.UserEmailAddress,
UserCompany = userDTO.UserCompany
};
}
return(View(editVM));
}
public ActionResult Index()
{
List <SessionViewModel> sessionVm;
List <SessionCartViewModel> enrollmentList;
SessionIndexViewModel model = new SessionIndexViewModel();
using (WSADDbContext context = new WSADDbContext())
{
sessionVm = context.Sessions
.ToArray()
.Select(x => new SessionViewModel(x))
.ToList();
//Get user info
string emailAddress = User.Identity.Name;
//Get user id from DB
int userId = context.Users
.Where(x => x.UserEmailAddress == emailAddress)
.Select(x => x.UserId)
.FirstOrDefault();
//Get enrollment sessions
//Generate EnrollmentViewModel
enrollmentList = context.SessionCartItems.Where(x => x.UserId == userId)
.ToArray()
.Select(x => new SessionCartViewModel(x))
.ToList();
}
model.Sessions = sessionVm;
model.RegisteredSessions = enrollmentList;
return(View(model));
}
public ActionResult Edit(EditSessionViewModel editSessionVM)
{
if (!ModelState.IsValid)
{
return(View(editSessionVM));
}
using (WSADDbContext context = new WSADDbContext())
{
Session sessionDTO = context.Sessions.Find(editSessionVM.SessionId);
if (sessionDTO == null)
{
return(Content("Inavid Session ID"));
}
sessionDTO.SessionTitle = editSessionVM.SessionTitle;
sessionDTO.SessionDescription = editSessionVM.SessionDescription;
sessionDTO.SessionPresenter = editSessionVM.SessionPresenter;
sessionDTO.SessionAddress = editSessionVM.SessionAddress;
sessionDTO.SessionRoom = editSessionVM.SessionRoom;
sessionDTO.SessionSeatsAvailable = editSessionVM.SessionSeatsAvailable;
context.SaveChanges();
}
// Toast to show the session edited
return(View());
}
public ActionResult Delete(List <ManageSessionViewModel> collectionOfSessionsToDelete)
{
//Filter collection of Sessions, and seperate the isSelected items only
var fileteredCollectionOfSessionsToDelete = collectionOfSessionsToDelete.Where(x => x.isSelected == true);
//Get reference to the database
using (WSADDbContext context = new WSADDbContext())
{
//iterate and delete each object
foreach (var vmItems in fileteredCollectionOfSessionsToDelete)
{
var dtoToDelete = context.Sessions.FirstOrDefault(row => row.SessionId == vmItems.SessionId);
context.Sessions.Remove(dtoToDelete);
//delete the rows in the sessionCart table (null pointer prevented) on user cart GET
var sessionCartDtoToDelete = context.SessionCartItems.FirstOrDefault(row => row.SessionId == vmItems.SessionId);
if (sessionCartDtoToDelete != null)
{
context.SessionCartItems.Remove(sessionCartDtoToDelete);
}
}
context.SaveChanges();
}
return(RedirectToAction("Index"));
}
protected void Application_AuthenticateRequest()
{
if (Context.User == null)
{
return;
} //Exit if the userObj = null
//get the current user reference
string emailAddress = Context.User.Identity.Name;
string[] roles = new string[1];
using (WSADDbContext context = new WSADDbContext())
{
//get the user based on the email address of the current user
User userDTO = context.Users.FirstOrDefault(row => row.UserEmailAddress == emailAddress);
//Add Roles to the IPrinicipal Objecct
if (userDTO != null)
{
roles = context.UserRoles.Where(row => row.UserId == userDTO.UserId)
.Select(row => row.role.Name) //fkRole in tblRole
.ToArray();
}
}
//Build IPrinicpal Object
IIdentity userIdentity = new GenericIdentity(emailAddress);
IPrincipal newUserObj = new System.Security.Principal.GenericPrincipal(userIdentity, roles);
//Update Context.User with IPrinicpal Obj
Context.User = newUserObj;
}
public ActionResult Edit(int id)
{
EditSessionViewModel editSessionVM;
using (WSADDbContext context = new WSADDbContext())
{
Session sessionDTO = context.Sessions.Find(id);
if (sessionDTO == null)
{
return(Content("Invalid Session ID"));
}
editSessionVM = new EditSessionViewModel()
{
SessionId = sessionDTO.SessionId,
SessionTitle = sessionDTO.SessionTitle,
SessionDescription = sessionDTO.SessionDescription,
SessionPresenter = sessionDTO.SessionPresenter,
SessionAddress = sessionDTO.SessionAddress,
SessionRoom = sessionDTO.SessionRoom,
SessionSeatsAvailable = sessionDTO.SessionSeatsAvailable,
};
}
//passing the viewModel data to the view with edit template
return(View(editSessionVM));
}
protected void Application_AuthenticateRequest()
{
if (Context.User == null)
{
return;
}
//get current user username
string username = Context.User.Identity.Name;
//setup a Dbcontext
string[] roles = null;
using (WSADDbContext context = new WSADDbContext())
{
//add our roles to the iprincipal object
User userDTO = context.Users.FirstOrDefault(row => row.Username == username);
if (userDTO != null)
{
roles = context.UserRoles.Where(row => row.UserId == userDTO.Id)
.Select(row => row.Role.Name)
.ToArray();
}
}
//build iprincipal object
IIdentity userIdentity = new GenericIdentity(username);
IPrincipal newUserObj = new System.Security.Principal.GenericPrincipal(userIdentity, roles);
//update the context.user with our Iprincipal
Context.User = newUserObj;
}
public ActionResult GetEnrolledSessions(int id)
{
//id == UserId
List <SessionsEnrolledByUserViewModel> enrollmentList;
using (WSADDbContext context = new WSADDbContext())
{
User userDTO = context.Users.Find(id);
if (userDTO == null)
{
return(Content("Invalid ID"));
}
//SELECT * FROM SesionCart where UserID = x
int userId = context.Users
.Where(x => x.UserEmailAddress == userDTO.UserEmailAddress)
.Select(x => x.UserId)
.FirstOrDefault();
//Get enrollment sessions
enrollmentList = context.SessionCartItems.Where(x => x.UserId == userId)
.ToArray()
.Select(x => new SessionsEnrolledByUserViewModel(x))
.ToList();
}
return(View(enrollmentList));
}
public ActionResult EditUser(EditUserAdminViewModel editUserAdminViewModel)
{
bool passwordChanged = false;
bool emailChanged = false;
if (!ModelState.IsValid)
{
return(View(editUserAdminViewModel));
}
//admin resets the password
if (!string.IsNullOrWhiteSpace(editUserAdminViewModel.UserPassword))
{
if (!editUserAdminViewModel.UserPassword.Equals(editUserAdminViewModel.UserConfirmPassword))
{
ModelState.AddModelError("", "Passwords must match");
return(View(editUserAdminViewModel));
}
else
{
passwordChanged = true;
}
}
using (WSADDbContext context = new WSADDbContext())
{
User userDTO = context.Users.Find(editUserAdminViewModel.UserId);
if (userDTO == null)
{
return(Content("Inavid User ID"));
}
if (!userDTO.UserEmailAddress.Equals(editUserAdminViewModel.UserEmailAddress))
{
userDTO.UserEmailAddress = editUserAdminViewModel.UserEmailAddress;
emailChanged = true;
}
userDTO.UserFirstName = editUserAdminViewModel.UserFirstName;
userDTO.UserLastName = editUserAdminViewModel.UserLastName;
userDTO.UserEmailAddress = editUserAdminViewModel.UserEmailAddress;
userDTO.UserCompany = editUserAdminViewModel.UserCompany;
userDTO.UserIsActive = editUserAdminViewModel.UserIsActive;
userDTO.UserIsAdmin = editUserAdminViewModel.UserIsAdmin;
userDTO.UserDateModified = DateTime.Now;
if (passwordChanged)
{
userDTO.UserPassword = editUserAdminViewModel.UserPassword;
}
context.SaveChanges();
}
if (emailChanged || passwordChanged)
{
TempData["AdminChange"] = "User Credentials Changed";
}
return(View(editUserAdminViewModel));
}
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 Edit(int id)
{
// get user by id
EditViewModel editVM;
using (WSADDbContext context = new WSADDbContext())
{
//get user from DB
User userDTO = context.Users.Find(id);
//create a editviewmodel
if (userDTO == null)
{
return(Content("Invalid Id"));
}
//send viewmodel to the view
editVM = new EditViewModel()
{
EmailAddress = userDTO.EmailAddress,
FirstName = userDTO.FirstName,
LastName = userDTO.LastName,
Id = userDTO.Id,
UserName = userDTO.Username,
Gender = userDTO.Gender
};
}
//send viewmodel to the view
return(View(editVM));
}
public ActionResult Edit(int id)
{
// get user by id
EditSessionViewModel editSessionVM;
using (WSADDbContext context = new WSADDbContext())
{
//get user from DB
Session sessionDTO = context.Sessions.Find(id);
//create a editviewmodel
if (sessionDTO == null)
{
return(Content("Invalid Id"));
}
//send viewmodel to the view
editSessionVM = new EditSessionViewModel()
{
Title = sessionDTO.Title,
Description = sessionDTO.Description,
Presenter = sessionDTO.Presenter,
Id = sessionDTO.Id,
Room = sessionDTO.Room,
Time = sessionDTO.Time,
Occupancy = sessionDTO.Occupancy
};
}
//send viewmodel to the view
return(View(editSessionVM));
}
protected void Application_AuthenticateRequest()
{
if (Context.User == null)
{
return;
} //no user set
//Get Current User Username
string username = Context.User.Identity.Name;
//Setup DbContext
string[] roles = null;
using (WSADDbContext context = new WSADDbContext())
{
//Add roles to IPrincipal Object
User userDTO = context.Users.FirstOrDefault(row => row.Username == username);
if (userDTO != null)
{
roles = context.UserRoles.Where(row => row.UserId == userDTO.Id)
.Select(row => row.Role.Name)
.ToArray();
}
}
//Build IPrincipal Object
IIdentity userIdentity = new GenericIdentity(username);
IPrincipal newUserObj = new System.Security.Principal.GenericPrincipal(userIdentity, roles);
//Update Context.User with Iprincipal
Context.User = newUserObj;
}
public ActionResult UserNavPartial()
{
//capture logged in user
string username;
username = this.User.Identity.Name;
//get user information from database
UserNavPartialViewModel userNavVM;
using (WSADDbContext context = new WSADDbContext())
{
//search for user
Models.Data.User userDTO = context.Users.FirstOrDefault(x => x.Username == username);
if (userDTO == null)
{
return(Content(""));
}
//Build our UserNavPartialViewModel
userNavVM = new UserNavPartialViewModel()
{
FirstName = userDTO.FirstName,
LastName = userDTO.LastName,
id = userDTO.Id
};
}
//send the view model to the partial view
return(PartialView(userNavVM));
}
public ActionResult UserNavPartial()
{
//Capture Logged in User
string username;
username = this.User.Identity.Name;
//Get user info from DB
UserNavPartialViewModel userNavVM;
using (WSADDbContext context = new WSADDbContext())
{
//search for user
Models.Data.User userDTO = context.Users.FirstOrDefault(x => x.Username == username);
if (userDTO == null)
{
return(Content(""));
}
//Build UserNavPartialViewModel
userNavVM = new UserNavPartialViewModel()
{
FirstName = userDTO.FirstName,
LastName = userDTO.LastName,
Id = userDTO.Id
};
}
//Send view model
return(PartialView(userNavVM));
}
// GET api/<controller>
public IEnumerable<SessionSearchViewModel> Get(string query)
{
using (WSADDbContext context = new WSADDbContext())
{
IQueryable<Session> matches;
List<SessionSearchViewModel> ssVM = new List<SessionSearchViewModel>();
if (string.IsNullOrWhiteSpace(query))
{
matches = context.Sessions.AsQueryable();
}
else
{
matches = context.Sessions
.Where(row => row.Title.StartsWith(query));
}
foreach (var sessionDTO in matches)
{
ssVM.Add(new SessionSearchViewModel(sessionDTO));
}
return ssVM;
}
}
public ActionResult Login(LoginUserViewModel loginUser)
{
//Open DB Connection
bool isValid = false;
using (WSADDbContext context = new WSADDbContext())
{
//Hash Password
//Query for user based on Username and Password
if (context.Users.Any(row => row.Username.Equals(loginUser.Username) &&
row.Password.Equals(loginUser.Password)))
{
isValid = true;
}
}
if (!isValid)
{
ModelState.AddModelError("", "Invalid Username or Password");
return(View());
}
else
{
//If valid, redirect to the user profile
FormsAuthentication.SetAuthCookie(loginUser.Username, loginUser.RememberMe);
return(Redirect(FormsAuthentication.GetRedirectUrl(loginUser.Username, loginUser.RememberMe)));
}
}
public ActionResult Edit(int id)
{
//Get User by Id
EditViewModel editVM;
using (WSADDbContext context = new WSADDbContext())
{
//Get user from database
User userDTO = context.Users.Find(id);
if (userDTO == null)
{
return(Content("Invalid Id"));
}
//Create EditViewModel
editVM = new EditViewModel()
{
EmailAddress = userDTO.EmailAddress,
FirstName = userDTO.FirstName,
Id = userDTO.Id,
LastName = userDTO.LastName,
UserName = userDTO.Username,
Gender = userDTO.Gender
};
}
//Send ViewModel to view\
return(View(editVM));
}
// GET: SessionCheckout
public ActionResult Index()
{
List <SessionSignupViewModel> sessionSignupItems;
using (WSADDbContext context = new WSADDbContext())
{
//get user info
string username = User.Identity.Name;
//get user id from db
int userId = context.Users
.Where(x => x.Username == username)
.Select(x => x.Id)
.FirstOrDefault();
//get session signup items
sessionSignupItems =
context.SessionSignup.Where(x => x.UserId == userId)
.ToArray()
.Select(x => new SessionSignupViewModel(x))
.ToList();
//generate session signup view model
}
return(View(sessionSignupItems));
}
// GET: CourseCart
public ActionResult Index()
{
List <EnrolledSessionViewModel> enrolledSessions = new List <EnrolledSessionViewModel>();
using (WSADDbContext context = new WSADDbContext())
{
//Get User info
string username = User.Identity.Name;
//Get user id from DB
var userId = context.Users
.Where(x => x.Username == username)
.Select(x => x.Id)
.FirstOrDefault();
//Get Enrolled sessions
enrolledSessions = context.UserSessions.Where(x => x.User_Id == userId)
.ToArray()
.Select(x => new EnrolledSessionViewModel(x))
.ToList();
//Generated Schedule view model
}
return(View(enrolledSessions));
}
/// <summary>
/// Captures the logged in user
/// </summary>
/// <returns></returns>
public ActionResult UserNavPartial()
{
//capture logged in user
string emailAddress = this.User.Identity.Name; //user name that user uses to login
UserNavPartialViewModel userNavVM;
//get user information from the database
using (WSADDbContext context = new WSADDbContext())
{
//query for the user
User userDTO = context.Users.FirstOrDefault(x => x.UserEmailAddress == emailAddress);
if (userDTO == null)
{
return(Content(""));
}
//build the usernavpartialviewmodel
userNavVM = new UserNavPartialViewModel()
{
UserFirstName = userDTO.UserFirstName,
UserLastName = userDTO.UserLastName,
UserId = userDTO.UserId
};
}
//send the view model to the partial view
return(PartialView(userNavVM));
}
// GET api/<controller>
public IEnumerable <UserSearchViewModel> Get(string term)
{
using (WSADDbContext context = new WSADDbContext())
{
IQueryable <User> matches;
List <UserSearchViewModel> usVM = new List <UserSearchViewModel>();
if (string.IsNullOrWhiteSpace(term))
{
matches = context.Users.AsQueryable();
}
else
{
matches = context.Users
.Where(row => row.UserFirstName.StartsWith(term));
}
foreach (var userDTO in matches)
{
usVM.Add(new UserSearchViewModel(userDTO));
}
return(usVM);
}
}
public ActionResult AddToSession(List <SessionViewModel> sessions)
{
//Verify that sessionToAdd is not null
if (sessions == null)
{
return(RedirectToAction("Index"));
}
//Capture Sessions to Add (filter by isSelected)
sessions = sessions.Where(p => p.isSelected).ToList();
//If there are no sessions to add, then redirect to sessionCart index
if (!(sessions.Count > 0))
{
return(RedirectToAction("Index"));
}
//get user from user.identity.name
string emailAddress = User.Identity.Name;
//get user from the database -- we need their user id
using (WSADDbContext context = new WSADDbContext())
{
//Get user info
//Get user id from DB
int userId = context.Users
.Where(row => row.UserEmailAddress == emailAddress)
.Select(row => row.UserId)
.FirstOrDefault();
foreach (SessionViewModel sessionVM in sessions)
{
//check to see if the user, session combo already exists, then we say already enrolled
//does not make sense to do it here, since we do not have quantity
//create session cart dto
SessionCart sessionCartDTO = new SessionCart()
{
//add product id and user id to dto
UserId = userId,
SessionId = sessionVM.SessionId
};
//add dto to db conetext
context.SessionCartItems.Add(sessionCartDTO);
}
context.SaveChanges();
}
//redirect to shopping cart index
return(RedirectToAction("Index"));
}
public ActionResult Details(int sessionId)
{
SessionViewModel sessionVM = new SessionViewModel();
using (WSADDbContext context = new WSADDbContext())
{
Session session = context.Sessions.FirstOrDefault(row => row.Id == sessionId);
sessionVM = new SessionViewModel(session);
}
return(View(sessionVM));
}
/// <summary>
///
/// </summary>
/// <param name="sessionId"></param>
/// <param name="userId"></param>
/// <returns></returns>
public ActionResult AddUserToSession(int sessionId, int userId)
{
bool userAdded = false;
//Check for valid session and user id's
if (sessionId <= 0 || userId <= 0)
{
return(this.HttpNotFound("Invalid Input Parameters"));
}
using (WSADDbContext context = new WSADDbContext())
{
Session sessionDTO = context.Sessions.FirstOrDefault(x => x.SessionId == sessionId);
User userDTO = context.Users.FirstOrDefault(x => x.UserId == userId);
if (sessionDTO == null || userDTO == null)
{
return(this.HttpNotFound("Invalid Input Parameters"));
}
//Check to see if the user+session Combination already exists, if not add it
SessionCart sessionCartDto =
context.SessionCartItems.FirstOrDefault(row => sessionDTO.SessionId == sessionId && row.UserId == userDTO.UserId);
//if (sessionCartDto == null)
//{
SessionCart sessionCartItemToAdd = new SessionCart()
{
UserId = userId,
SessionId = sessionId
};
context.SessionCartItems.Add(sessionCartItemToAdd);
userAdded = true;
//}
#region MyRegion
//}
//else
//{
// //if (!userAdded)
// //{
// // TempData["NoDuplicates"] = "User Already Registered to this session";
// // return RedirectToAction("GetEnrolledUsers", new { sessionId });
// //}
//}
#endregion
context.SaveChanges();
}
return(RedirectToAction("GetEnrolledUsers", new { Id = sessionId }));
}
public ActionResult Create(CreateUserViewModel newUser)
{
//Check required fields
if (!ModelState.IsValid)
{
return(View(newUser));
}
//Check Password & PasswordConfirm
if (!newUser.Password.Equals(newUser.PasswordConfirm))
{
ModelState.AddModelError("", "Password does not match Password Confirm");
return(View(newUser));
}
//Create DbContext instance
using (WSADDbContext context = new WSADDbContext())
{
//Check username is not a duplicate
if (context.Users.Any(row => row.Username.Equals(newUser.Username)))
{
ModelState.AddModelError("", "Username '" + newUser.Username + "' already exists. Try Again");
newUser.Username = "";
return(View(newUser));
}
//Create User DTO
User newUserDTO = new Models.Data.User()
{
FirstName = newUser.FirstName,
LastName = newUser.LastName,
EmailAddress = newUser.EmailAddress,
IsActive = true,
IsAdmin = false,
Username = newUser.Username,
Password = newUser.Password,
DateCreated = DateTime.Now,
DateModified = DateTime.Now,
Gender = newUser.Gender
};
//Add to DbContext
newUserDTO = context.Users.Add(newUserDTO);
//Save changes
context.SaveChanges();
}
//Redirect to login
return(RedirectToAction("login"));
}
public ActionResult Login(LoginUserViewModel loginUser)
{
//Validate a username and password is passed (no empties)
if (loginUser == null)
{
ModelState.AddModelError("", "Login is required");
return(View());
}
if (string.IsNullOrWhiteSpace(loginUser.Username))
{
ModelState.AddModelError("", "Username is required");
return(View());
}
if (string.IsNullOrWhiteSpace(loginUser.Password))
{
ModelState.AddModelError("", "Password is required");
return(View());
}
// open database connection
bool isValid = false;
using (WSADDbContext context = new WSADDbContext())
{
//hash password
//query for user based on username and password hash
if (context.Users.Any(
row => row.Username.Equals(loginUser.Username) &&
row.Password.Equals(loginUser.Password)
))
{
isValid = true;
}
}
//if invalid, send error
if (!isValid)
{
ModelState.AddModelError("", "Invalid username or password.");
return(View());
}
else
{
//valid, redirect to user profile
System.Web.Security.FormsAuthentication.SetAuthCookie(loginUser.Username, loginUser.RememberMe);
return(Redirect(FormsAuthentication.GetRedirectUrl(loginUser.Username, loginUser.RememberMe)));
}
}
public ActionResult Delete(List <ManageUserViewModel> collectionOfUserVM)
{
var vmItemsToDelete = collectionOfUserVM.Where(x => x.IsSelected == true);
using (WSADDbContext context = new WSADDbContext())
{
foreach (var vmItems in vmItemsToDelete)
{
var dtoToDelete = context.Users.FirstOrDefault(row => row.Id == vmItems.Id);
context.Users.Remove(dtoToDelete);
}
context.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult Delete(List <SessionSignupViewModel> sessionsToAdd)
{
var vmItemsToDelete = sessionsToAdd.Where(x => x.IsSelected == true);
using (WSADDbContext context = new WSADDbContext())
{
foreach (var vmItems in vmItemsToDelete)
{
var dtoToDelete = context.SessionSignup.FirstOrDefault(row => row.Id == vmItems.Id);
context.SessionSignup.Remove(dtoToDelete);
}
context.SaveChanges();
}
return(RedirectToAction("Index"));
}
// GET: Session
public ActionResult Index()
{
List <SessionViewModel> sessionVM;
using (WSADDbContext context = new WSADDbContext())
{
sessionVM = context.Sessions
.ToArray()
.Select(x => new SessionViewModel(x))
.ToList();
}
return(View(sessionVM));
}
