public static Amenity GetById(int id)
{
using (CozySmartContext _db = new CozySmartContext())
{
return(_db.Amenities.Where(a => a.Id == id).Single());
}
}
public static List <Amenity> GetForAccommodation(int?id)
{
using (CozySmartContext _db = new CozySmartContext())
{
return(_db.Accommodations.Where(a => a.Id == id).Single().Amenities.OrderBy(am => am.Description).ToList());
}
}
public static List <Availability> GetForAccommodation(int?id)
{
using (CozySmartContext _db = new CozySmartContext())
{
return(_db.Accommodations.Where(a => a.Id == id).Include(a => a.Availabilities).Single().Availabilities.ToList());
}
}
public static List <Amenity> GetAll()
{
using (CozySmartContext _db = new CozySmartContext())
{
return(_db.Amenities.OrderBy(a => a.Description).ToList());
}
}
public static void AvailabilityDivision(AvailabilityFormViewModel availabilityModel, Availability availability)
{
using (CozySmartContext _db = new CozySmartContext())
{
var firstPart = new Availability()
{
AvailabilityStart = availability.AvailabilityStart,
AvailabilityEnd = availabilityModel.OccupationStart,
AccommodationId = availabilityModel.AccommodationId
};
var secondPart = new Availability()
{
AvailabilityStart = availabilityModel.OccupationEnd,
AvailabilityEnd = availability.AvailabilityEnd,
AccommodationId = availabilityModel.AccommodationId
};
var currentAccommodation = _db.Accommodations.Include(a => a.Availabilities).Where(a => a.Id == availabilityModel.AccommodationId).Single();
var pastAvailability = _db.Availabilities.Find(availability.Id);
_db.Availabilities.Remove(pastAvailability);
currentAccommodation.Availabilities.Add(firstPart);
currentAccommodation.Availabilities.Add(secondPart);
_db.SaveChanges();
}
}
public static void Update(AccommodationFormViewModel accommodationModel)
{
using (CozySmartContext _db = new CozySmartContext())
{
var selectedAmenities = accommodationModel.Amenities.Where(a => a.IsChecked).Select(a => a.Id).ToList();
var savingAccommodation = _db.Accommodations.Single(a => a.Id == accommodationModel.Id);
savingAccommodation.Title = accommodationModel.Title;
savingAccommodation.Location = accommodationModel.Location;
savingAccommodation.Adress = accommodationModel.Adress;
savingAccommodation.Thumbnail = accommodationModel.Thumbnail;
savingAccommodation.Bedrooms = accommodationModel.Bedrooms;
savingAccommodation.Baths = accommodationModel.Baths;
savingAccommodation.Description = accommodationModel.Description;
savingAccommodation.Price = accommodationModel.Price;
savingAccommodation.CategoryId = accommodationModel.CategoryId;
savingAccommodation.Amenities.Clear();
foreach (var amenityId in selectedAmenities)
{
var amenity = _db.Amenities.Find(amenityId);
savingAccommodation.Amenities.Add(amenity);
}
_db.SaveChanges();
}
}
public static void Add(AccommodationFormViewModel accommodationModel, string userId)
{
using (CozySmartContext _db = new CozySmartContext())
{
var defaultAvailability = new Availability(accommodationModel.Id);
var selectedAmenities = accommodationModel.Amenities.Where(a => a.IsChecked).Select(a => a.Id).ToList();
var accommodation = new Accommodation()
{
Id = accommodationModel.Id,
Title = accommodationModel.Title,
Location = accommodationModel.Location,
Adress = accommodationModel.Adress,
Thumbnail = accommodationModel.Thumbnail,
Description = accommodationModel.Description,
Occupancy = accommodationModel.Occupancy,
Bedrooms = accommodationModel.Bedrooms,
Baths = accommodationModel.Baths,
Price = accommodationModel.Price,
CategoryId = accommodationModel.CategoryId,
ApplicationUserId = userId
};
accommodation.Availabilities.Add(defaultAvailability);
foreach (var amenityId in selectedAmenities)
{
var amenity = _db.Amenities.Find(amenityId);
accommodation.Amenities.Add(amenity);
}
_db.Accommodations.Add(accommodation);
_db.SaveChanges();
}
}
private void createRolesandUsers()
{
CozySmartContext context = new CozySmartContext();
var roleManager = new RoleManager <IdentityRole>(new RoleStore <IdentityRole>(context));
var UserManager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(context));
// In Startup iam creating first Admin Role and creating a default Admin User
if (!roleManager.RoleExists("Admin"))
{
// first we create Admin rool
var role = new Microsoft.AspNet.Identity.EntityFramework.IdentityRole();
role.Name = "Admin";
roleManager.Create(role);
//Here we create a Admin super user who will maintain the website
var user = new ApplicationUser();
user.FirstName = "Admin";
user.LastName = "Admin";
user.Email = "*****@*****.**";
string userPWD = "Vasilis1992!";
user.DateJoined = DateTime.Today;
user.UserName = user.Email;
var chkUser = UserManager.Create(user, userPWD);
if (chkUser.Succeeded)
{
var result1 = UserManager.AddToRole(user.Id, "Admin");
}
}
// creating Creating Host role
if (!roleManager.RoleExists("Host"))
{
var role = new Microsoft.AspNet.Identity.EntityFramework.IdentityRole();
role.Name = "Host";
roleManager.Create(role);
}
// creating Creating Tenant role
if (!roleManager.RoleExists("Tenant"))
{
var role = new Microsoft.AspNet.Identity.EntityFramework.IdentityRole();
role.Name = "Tenant";
roleManager.Create(role);
}
}
public AvailabilityController()
{
_db = new CozySmartContext();
}
public BookingsController()
{
_db = new CozySmartContext();
}
public AccommodationsController()
{
_db = new CozySmartContext();
}
public HomeController()
{
_db = new CozySmartContext();
}
public RolesController()
{
_db = new CozySmartContext();
}