public IEnumerable <AccommodationPackage> SearchAccommodationPackages(string searchTerm, int?accommodationTypeID, int page, int recordSize)
{
var context = new HotelManagementContext();
var accommodationPackages = context.AccommodationPackages.AsQueryable();
if (!string.IsNullOrEmpty(searchTerm))
{
accommodationPackages = accommodationPackages.Where(a => a.Name.ToLower().Contains(searchTerm.ToLower()));
}
if (accommodationTypeID.HasValue && accommodationTypeID.Value > 0)
{
accommodationPackages = accommodationPackages.Where(a => a.AccommodationTypeID == accommodationTypeID.Value);
}
// my pagination:
var skip = (page - 1) * recordSize;
// skip = (1-1) = 0*3=0
// skip = (2-1) = 1*3=3
// skip = (3-1) = 2*3=6
return(accommodationPackages.OrderBy(x => x.AccommodationTypeID).Skip(skip).Take(recordSize).ToList());
}
public Guest Validate(string username, string password)
{
using (var context = new HotelManagementContext())
{
return(context.Guests.First(x => x.Username.ToLower() == username && SecurePasswordHasher.Verify(password, x.PasswordHash)));
}
}
public Accommodation GetAccommodationById(int ID)
{
using (var context = new HotelManagementContext())
{
return(context.Accommodations.Find(ID));
}
}
public bool DeleteAccommodationType(AccommodationType accommodationType)
{
var context = new HotelManagementContext();
context.Entry(accommodationType).State = System.Data.Entity.EntityState.Deleted;
return(context.SaveChanges() > 0);
}
public bool SaveAccommodationType(AccommodationType accommodationType)
{
var context = new HotelManagementContext();
context.AccommodationTypes.Add(accommodationType);
return(context.SaveChanges() > 0);
}
public bool UpdateAccommodation(Accommodation accommodation)
{
var context = new HotelManagementContext();
context.Entry(accommodation).State = System.Data.Entity.EntityState.Modified;
return(context.SaveChanges() > 0);
}
public bool SavePicture(Picture picture)
{
var context = new HotelManagementContext();
context.Pictures.Add(picture);
return(context.SaveChanges() > 0);
}
public bool DeleteAccommodationPackage(AccommodationPackage accommodationPackage)
{
var context = new HotelManagementContext();
var existingAccommodationPackage = context.AccommodationPackages.Find(accommodationPackage.ID);
context.AccommodationPackagePictures.RemoveRange(existingAccommodationPackage.AccommodationPackagePictures);
context.Entry(existingAccommodationPackage).State = System.Data.Entity.EntityState.Deleted;
return(context.SaveChanges() > 0);
}
public IEnumerable <AccommodationType> SearchAccommodationTypes(string searchTerm)
{
var context = new HotelManagementContext();
var accommodationTypes = context.AccommodationTypes.AsQueryable();
if (!string.IsNullOrEmpty(searchTerm))
{
accommodationTypes = accommodationTypes.Where(a => a.Name.ToLower().Contains(searchTerm.ToLower()));
}
return(accommodationTypes.ToList());
}
public bool UpdateAccommodationPackage(AccommodationPackage accommodationPackage)
{
var context = new HotelManagementContext();
var existingAccommodationPackage = context.AccommodationPackages.Find(accommodationPackage.ID);
context.AccommodationPackagePictures.RemoveRange(existingAccommodationPackage.AccommodationPackagePictures);
context.Entry(existingAccommodationPackage).CurrentValues.SetValues(accommodationPackage);
context.AccommodationPackagePictures.AddRange(accommodationPackage.AccommodationPackagePictures);
return(context.SaveChanges() > 0);
}
public int SearchAccommodationPackagesCount(string searchTerm, int?accommodationTypeID)
{
var context = new HotelManagementContext();
var accommodationPackages = context.AccommodationPackages.AsQueryable();
if (!string.IsNullOrEmpty(searchTerm))
{
accommodationPackages = accommodationPackages.Where(a => a.Name.ToLower().Contains(searchTerm.ToLower()));
}
if (accommodationTypeID.HasValue && accommodationTypeID.Value > 0)
{
accommodationPackages = accommodationPackages.Where(a => a.AccommodationTypeID == accommodationTypeID.Value);
}
return(accommodationPackages.Count());
}
public AccommodationType GetAccommodationTypeById(int ID)
{
var context = new HotelManagementContext();
return(context.AccommodationTypes.Find(ID));
}
public IEnumerable <AccommodationType> GetAllAccommodationTypes()
{
var context = new HotelManagementContext();
return(context.AccommodationTypes.ToList());
}
public IEnumerable <AccommodationPackage> GetAllAccommodationPackagesByAccommodationType(int accommodationTypeID)
{
var context = new HotelManagementContext();
return(context.AccommodationPackages.Where(x => x.AccommodationTypeID == accommodationTypeID).ToList());
}
public List <AccommodationPackagePicture> GetPicturesByAccommodationPackageID(int accommodationPackageID)
{
var context = new HotelManagementContext();
return(context.AccommodationPackages.Find(accommodationPackageID).AccommodationPackagePictures.ToList());
}
public IEnumerable <Picture> GetPicturesByIDs(List <int> pictureIDs)
{
var context = new HotelManagementContext();
return(pictureIDs.Select(x => context.Pictures.Find(x)).ToList());
}