public bool SaveBookings(Bookings obj)
{
Bookings booking;
using (var _context = new HMSvContext())
{
if (obj.ID == 0)
{
booking = _context.Booking.Add(obj);
}
else
{
var bookingToEdit = _context.Booking.Single(c => c.ID == obj.ID);
bookingToEdit.Duration = obj.Duration;
bookingToEdit.FromDate = obj.FromDate;
bookingToEdit.ToDate = obj.ToDate;
bookingToEdit.NumberOfAdults = obj.NumberOfAdults;
bookingToEdit.NumberOfChildren = obj.NumberOfChildren;
bookingToEdit.BookingStatusID = obj.BookingStatusID;
bookingToEdit.UserID = obj.UserID;
bookingToEdit.ID = obj.ID;
bookingToEdit.BookedRooms = obj.BookedRooms;
_context.BookedRoom.AddRange(bookingToEdit.BookedRooms);
}
return(_context.SaveChanges() > 0);
}
}
public IList <AccomodationTypes> GetAllAccomodationTypes()
{
using (var _context = new HMSvContext())
{
return(_context.AccomodationType.ToList());
}
}
public ICollection <Accomodations> GetAccomodationsbyId(List <long> roomIDs)
{
using (var _context = new HMSvContext())
{
return(roomIDs.Select(x => _context.Accomodation.Find(x)).ToList());
}
}
public ICollection <Pictures> GetPicturesbyId(List <int> pictureIDs)
{
using (var _context = new HMSvContext())
{
return(pictureIDs.Select(x => _context.Picture.Find(x)).ToList());
}
}
public IList <Bookings> GetAllBookings()
{
using (var _context = new HMSvContext())
{
var result = _context.Booking.Include(b => b.BookedRooms).Include(b => b.BookingStatus).Include(u => u.ApplicationUser).ToList();
return(result);
}
}
public bool SavePicture(Pictures picture)
{
using (var _context = new HMSvContext())
{
_context.Picture.Add(picture);
return(_context.SaveChanges() > 0);
}
}
public List <BookingStatus> GetAllBookingStatuses()
{
using (var _context = new HMSvContext())
{
var result = _context.BookingStatus.Include(bs => bs.Bookings).ToList();
return(result);
}
}
public IList <Accomodations> GetAllAccomodations()
{
using (var _context = new HMSvContext())
{
var result = _context.Accomodation.Include(a => a.AccomodationPackage).Include(a => a.BookedRooms.Select(b => b.Booking)).ToList();
return(result);
}
}
public IList<AccomodationPackages> GetAllAccomodationPackages()
{
using (var _context = new HMSvContext())
{
var result = _context.AccomodationPackage.Include(a => a.AccomodationType).Include(x=>x.AccomodationPackagePictures.Select(y=>y.Picture)).ToList();
return result;
}
}
public ICollection<AccomodationPackagePictures> GetPicturesbyAccomodationPackageId(int accomodationPackageId)
{
if(context==null)
context = new HMSvContext();
var pictures = context.AccomodationPackage.Find(accomodationPackageId).AccomodationPackagePictures;
return pictures;
}
public bool DeleteBooking(int Id)
{
using (var _context = new HMSvContext())
{
var obj = _context.BookingStatus.FirstOrDefault(p => p.ID == Id);
if (obj != null)
{
_context.BookingStatus.Remove(obj);
}
return(_context.SaveChanges() > 0);
}
}
public bool DeleteAccomodationType(int Id)
{
using (var _context = new HMSvContext())
{
var obj = _context.AccomodationType.FirstOrDefault(p => p.ID == Id);
if (obj != null)
{
_context.AccomodationType.Remove(obj);
}
return(_context.SaveChanges() > 0);
}
}
public bool DeleteAccomodation(long Id)
{
using (var _context = new HMSvContext())
{
var obj = _context.Accomodation.FirstOrDefault(p => p.ID == Id);
if (obj != null)
{
obj.IsActive = false;
//_context.Accomodation.Remove(obj);
}
return(_context.SaveChanges() > 0);
}
}
public bool DeleteAccomodationPackage(int Id)
{
using (var _context = new HMSvContext())
{
var obj = _context.AccomodationPackage.Include(x=>x.AccomodationPackagePictures).SingleOrDefault(p => p.ID == Id);
if (obj != null)
{
_context.AccomodationPackage.Remove(obj);
}
return _context.SaveChanges() > 0;
}
}
public BookingStatus GetBookingStatusById(int Id)
{
using (var _context = new HMSvContext())
{
var bookingStatus = _context.BookingStatus.Include(bs => bs.Bookings).SingleOrDefault(a => a.ID == Id);
if (bookingStatus == null)
{
return(null);
}
else
{
return(bookingStatus);
}
}
}
public Accomodations GetAccomodationById(long Id)
{
using (var _context = new HMSvContext())
{
var accomodation = _context.Accomodation.Include(ap => ap.AccomodationPackage).SingleOrDefault(a => a.ID == Id);
if (accomodation == null)
{
return(null);
}
else
{
return(accomodation);
}
}
}
public Bookings GetBookingById(int Id)
{
using (var _context = new HMSvContext())
{
var booking = _context.Booking.Include(b => b.BookedRooms).Include(bs => bs.BookingStatus).Include(u => u.ApplicationUser).Single(a => a.ID == Id);
if (booking == null)
{
return(null);
}
else
{
return(booking);
}
}
}
public AccomodationPackages GetAccomodationPackageById(int Id)
{
using (var _context = new HMSvContext())
{
var accomodationPackage = _context.AccomodationPackage.Include(ap => ap.AccomodationType).Include(x=>x.AccomodationPackagePictures.Select(p=>p.Picture)).SingleOrDefault(a => a.ID == Id);
if (accomodationPackage == null)
{
return null;
}
else
{
return accomodationPackage;
}
}
}
public AccomodationTypes GetAccomodationTypeById(int Id)
{
using (var _context = new HMSvContext())
{
var accomodationType = _context.AccomodationType.SingleOrDefault(a => a.ID == Id);
if (accomodationType == null)
{
return(null);
}
else
{
return(accomodationType);
}
}
}
public bool SaveAccomodationTypes(AccomodationTypes obj)
{
using (var _context = new HMSvContext())
{
if (obj.ID == 0)
{
_context.AccomodationType.Add(obj);
}
else
{
var product = _context.AccomodationType.Single(c => c.ID == obj.ID);
product.Name = obj.Name;
}
return(_context.SaveChanges() > 0);
}
}
public bool SaveBookingStatus(BookingStatus obj)
{
using (var _context = new HMSvContext())
{
if (obj.ID == 0)
{
_context.BookingStatus.Add(obj);
}
else
{
var booking = _context.BookingStatus.Single(c => c.ID == obj.ID);
booking.Title = obj.Title;
}
return(_context.SaveChanges() > 0);
}
}
public bool SaveAccomodations(Accomodations obj)
{
using (var _context = new HMSvContext())
{
if (obj.ID == 0)
{
obj.IsActive = true;
_context.Accomodation.Add(obj);
}
else
{
var accomodation = _context.Accomodation.Single(c => c.ID == obj.ID);
accomodation.Name = obj.Name;
accomodation.Description = obj.Description;
accomodation.IsActive = true;
accomodation.AccomodationPackageID = obj.AccomodationPackageID;
}
return(_context.SaveChanges() > 0);
}
}
public bool SaveAccomodationPackages(AccomodationPackages obj)
{
using (var _context = new HMSvContext())
{
if (obj.ID == 0)
{
_context.AccomodationPackage.Add(obj);
}
else
{
var accomodationPackage = _context.AccomodationPackage.Include(x=>x.AccomodationPackagePictures).Single(c => c.ID == obj.ID);
_context.AccomodationPackagePicture.RemoveRange(accomodationPackage.AccomodationPackagePictures);
accomodationPackage.Name = obj.Name;
accomodationPackage.FeePerNight = obj.FeePerNight;
accomodationPackage.NoOfRooms = obj.NoOfRooms;
accomodationPackage.AccomodationTypeID = obj.AccomodationTypeID;
accomodationPackage.Description = obj.Description;
accomodationPackage.AccomodationPackagePictures = obj.AccomodationPackagePictures;
_context.AccomodationPackagePicture.AddRange(accomodationPackage.AccomodationPackagePictures);
}
return _context.SaveChanges() > 0;
}
}
