// Retrieve data from user input
public ActionResult Registration(UserModels user)
{
if (ModelState.IsValid) // Check for valid ModelState
{
try
{
GDbContext db = new GDbContext(); // Establish connection to the database
user.USER_PASSWORD_SALT = GenerateSalt(); // Generate password salt
user.USER_PASSWORD = Hash(Encoding.ASCII.GetBytes(user.USER_PASSWORD),
Encoding.ASCII.GetBytes(user.USER_PASSWORD_SALT)); // Hash password with password salt
db.User.Add(user); // Add user to the datebase
db.SaveChanges(); // Save changes to the database
return(RedirectToAction("Login")); // Redirect to login page
} catch (Exception) // Catch unique constraint violation for email
{
user.USER_PASSWORD = string.Empty; // Clear password
ModelState.AddModelError(string.Empty, "This email is already in use.");
return(View(user));
}
}
else
{
return(View(user));
}
}
public ActionResult UserDelete(int id)
{
GDbContext db = new GDbContext(); // Establish connection to database
// Retrieve user from database
UserModels user = db.User.SingleOrDefault(u => u.USER_ID == id) as UserModels;
if (user == null) // Return error if user isn't found
{
return(HttpNotFound());
}
if (ModelState.IsValid) // Check for valid ModelState
{
user.DELETE_STAT = !user.DELETE_STAT; // Soft delete or undelete based on current status
db.SaveChanges(); // Save changes to datebase
return(RedirectToAction("UserList")); // Return updated user list page
}
return(View(user)); // Returns view, should not occur
}
public ActionResult HotelDelete(int id)
{
GDbContext db = new GDbContext(); // Establish connection to database
// Retrieve hotel from database
Hotels hotel = db.Hotel.SingleOrDefault(h => h.HOTEL_ID == id) as Hotels;
if (hotel == null) // Return error if hotel isn't found
{
return(HttpNotFound());
}
if (ModelState.IsValid) // Check for valid ModelState
{
hotel.DELETE_STAT = !hotel.DELETE_STAT; // Soft delete or undelete based on current status
db.SaveChanges(); // Save changes to datebase
return(RedirectToAction("HotelList")); // Return to hotel list
}
return(View(hotel)); // Returns view, should not occur
}