public bool DeleteSession(int sessionId) { //Check for registrations SessionCartManager sessMgr = new SessionCartManager(); var registrations = sessMgr.GetAllUsersBySession(sessionId); if (registrations == null) { using (wsadDbContext context = new wsadDbContext()) { Session sessionDTO = context.Sessions.Find(sessionId); context.Sessions.Remove(sessionDTO); context.SaveChanges(); } return(true); } else { return(false); } }
public User UpdateUser(User userToUpdate) { using (wsadDbContext context = new wsadDbContext()) { //Get User From Database User currentUserDTO = context.Users.Find(userToUpdate.Id); //Copy Values currentUserDTO.EmailAddress = userToUpdate.EmailAddress; currentUserDTO.EmailOpt = userToUpdate.EmailOpt; currentUserDTO.FirstName = userToUpdate.FirstName; currentUserDTO.LastName = userToUpdate.LastName; currentUserDTO.UserName = userToUpdate.UserName; //Does password need to change? if (string.IsNullOrWhiteSpace(userToUpdate.Password) == false && currentUserDTO.Password != userToUpdate.Password) { currentUserDTO.Password = userToUpdate.Password; } //Save Changes context.SaveChanges(); return(currentUserDTO); } }
public ActionResult Index(ContactEmailViewModel contactMessage) { //Validate contact message input if (contactMessage == null) { ModelState.AddModelError("", "No Message has been provided!"); return(View()); } if (string.IsNullOrWhiteSpace(contactMessage.Name) || string.IsNullOrWhiteSpace(contactMessage.Email) || string.IsNullOrWhiteSpace(contactMessage.Message)) { ModelState.AddModelError("", "All fields are required!"); return(View()); } //Create an email message object System.Net.Mail.MailMessage email = new System.Net.Mail.MailMessage(); //Populate the object email.To.Add("*****@*****.**"); email.From = new System.Net.Mail.MailAddress(contactMessage.Email); email.Subject = "This is our email to you!"; email.Body = string.Format( "Name: {0}\r\nMessage: {1}", contactMessage.Name, contactMessage.Message ); email.IsBodyHtml = false; //Setup an SMTP client to send the messages System.Net.Mail.SmtpClient smptClient = new System.Net.Mail.SmtpClient(); smptClient.Host = "smtp.fuse.net"; //Send the message smptClient.Send(email); //Create an instance on our DbContext using (wsadDbContext context = new wsadDbContext()) { //Create Correspondence DTO Correspondence newCorrespondenceDTO = new Correspondence() { Name = contactMessage.Name, Email = contactMessage.Email, Message = contactMessage.Message }; //Add to DbContext context.Correspondences.Add(newCorrespondenceDTO); //Save Changes context.SaveChanges(); } //Notify the user that the message was sent return(View("emailConfirmation")); }
public void DeleteRegistration(int sessionCartId) { using (wsadDbContext context = new wsadDbContext()) { SessionCart sessionCartDTO = context.SessionCarts.Find(sessionCartId); context.SessionCarts.Remove(sessionCartDTO); context.SaveChanges(); } }
public Session AddSession(Session template) { using (wsadDbContext context = new wsadDbContext()) { Session newSessionObj = context.Sessions.Add(template); context.SaveChanges(); return(newSessionObj); } }
public void DeleteUser(int userId) { using (wsadDbContext context = new wsadDbContext()) { User userDTO = context.Users.Find(userId); context.Users.Remove(userDTO); context.SaveChanges(); } }
public User AddUser(User template) { using (wsadDbContext context = new wsadDbContext()) { User newUserObj = context.Users.Add(template); context.SaveChanges(); return(newUserObj); } }
public ActionResult Edit(EditViewModel editVM) { //Varilables bool needsPasswordReset = false; //Validate the model if (!ModelState.IsValid) { return(View(editVM)); } //Check for a password change if (string.IsNullOrWhiteSpace(editVM.Password)) { //compare password with password confirm if (!editVM.Password.Equals(editVM.PasswordConfirm)) { ModelState.AddModelError("", "Both Passwords must match!"); } else { needsPasswordReset = true; } } //Get user from datbase using (wsadDbContext context = new wsadDbContext()) { //Get DTO User userDTO = context.Users.Find(editVM.Id); if (userDTO == null) { return(Content("Invalid User Id")); } //Set or update values from the view model userDTO.FirstName = editVM.FirstName; userDTO.EmailAddress = editVM.EmailAddress; userDTO.LastName = editVM.LastName; userDTO.UserName = editVM.UserName; userDTO.IsAdmin = editVM.IsAdmin; if (needsPasswordReset) { userDTO.Password = editVM.Password; } //Save changes context.SaveChanges(); } return(RedirectToAction("UserProfile")); }
internal void AddToCart(string username, int sessionId) { //Establish Db Context using (wsadDbContext context = new wsadDbContext()) { //Capture User Id based on Username int?userId = context.Users .Where(row => row.UserName.ToLower() == username.ToLower()) .Select(row => row.Id) .FirstOrDefault(); if (userId.HasValue == false) { throw new ArgumentException("Invalid Username"); } /*Check if a session exists for this user's cart*/ //Does Session Id exist in database? if (context.Sessions.Any(row => row.Id == sessionId) == false) { throw new ArgumentException("Invalid Session Id"); } SessionCart cartItem = context.SessionCarts .Where(row => row.UserId == userId.Value && row.SessionId == sessionId) .FirstOrDefault(); //No session exists -- add new session cartItem = new SessionCart() { UserId = userId.Value, SessionId = sessionId, IsActive = true, DateAdded = DateTime.Now, }; context.SessionCarts.Add(cartItem); //Update Database context.SaveChanges(); } }
public Session UpdateSession(Session sessionToUpdate) { using (wsadDbContext context = new wsadDbContext()) { //Get session From Database Session currentSessionDTO = context.Sessions.Find(sessionToUpdate.Id); //Copy Values currentSessionDTO.Title = sessionToUpdate.Title; currentSessionDTO.Description = sessionToUpdate.Description; currentSessionDTO.Building = sessionToUpdate.Building; currentSessionDTO.Room = sessionToUpdate.Room; currentSessionDTO.DateAndTime = sessionToUpdate.DateAndTime; currentSessionDTO.TotalSeats = sessionToUpdate.TotalSeats; //Save Changes context.SaveChanges(); return(currentSessionDTO); } }
internal void AddToCart(string username, int productId) { //Establish Db Context using (wsadDbContext context = new wsadDbContext()) { //Capture User Id based on Username int?userId = context.Users .Where(row => row.UserName.ToLower() == username.ToLower()) .Select(row => row.Id) .FirstOrDefault(); if (userId.HasValue == false) { throw new ArgumentException("Invalid Username"); } /*Check if a product exists for this user's cart*/ //Does Product Id exist in database? if (context.Products.Any(row => row.Id == productId) == false) { throw new ArgumentException("Invalid Product Id"); } ShoppingCart cartItem = context.ShoppingCarts .Where(row => row.UserId == userId.Value && row.ProductId == productId) .FirstOrDefault(); //If product exists -- add one to the quantity if (cartItem != null) { //Is it Active? if (cartItem.IsActive == false) { cartItem.IsActive = true; cartItem.Quantity = 1; } else { //Existing Active Item cartItem.Quantity++; //Add one to the quantity } } else { //No product exists -- add new product cartItem = new ShoppingCart() { UserId = userId.Value, ProductId = productId, Quantity = 1, IsActive = true, DateAdded = DateTime.Now, }; context.ShoppingCarts.Add(cartItem); } //Update Database context.SaveChanges(); } }
public ActionResult Create(AccountCreateViewModel createdUser) { //Validate the account information if (!ModelState.IsValid) { return(View(createdUser)); } if (createdUser == null) { ModelState.AddModelError("", "No information was given"); } if (string.IsNullOrWhiteSpace(createdUser.FirstName) || string.IsNullOrWhiteSpace(createdUser.LastName) || string.IsNullOrWhiteSpace(createdUser.EmailAddress) || string.IsNullOrWhiteSpace(createdUser.Gender) || string.IsNullOrWhiteSpace(createdUser.UserName) || string.IsNullOrWhiteSpace(createdUser.Password) || string.IsNullOrWhiteSpace(createdUser.ConfirmPassword)) { ModelState.AddModelError("", "All fields are required"); return(View()); } if (!createdUser.Password.Equals(createdUser.ConfirmPassword)) { ModelState.AddModelError("", "Your password does not match"); return(View()); } //Create Database connectoin using (wsadDbContext context = new wsadDbContext()) { if (context.Users.Any( row => row.UserName.Equals(createdUser.UserName) )) { ModelState.AddModelError("", "Username " + createdUser.UserName + " already exists. Please select another."); createdUser.UserName = ""; return(View(createdUser)); } //Setup insert into database Models.DataAccess.User newUserObj; newUserObj = new Models.DataAccess.User() { FirstName = createdUser.FirstName, LastName = createdUser.LastName, EmailAddress = createdUser.EmailAddress, Gender = createdUser.Gender, UserName = createdUser.UserName, Password = createdUser.Password, EmailOpt = createdUser.EmailOpt, IsAdmin = createdUser.IsAdmin }; //Commit the insert newUserObj = context.Users.Add(newUserObj); context.SaveChanges(); } //Show user creation page with inforation they gave TempData["Message"] = "Account Creation Successful"; return(RedirectToAction("Login")); //return View("Confirmation", createdUser); }