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