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