public bool BookRoom(int roomId, DateTime date)
{
using (HotelmanagementEntities db = new HotelmanagementEntities())
{
bool status = false;
try
{
booking temp = db.bookings.Where(x => x.roomid == roomId && x.bookingdate == date).FirstOrDefault();
if (temp != null)
{
return(status);
}
booking booking = new booking {
roomid = roomId, bookingdate = date, bookingstatus = "optional"
};
db.bookings.Add(booking);
if (db.SaveChanges() > 0)
{
status = true;
}
return(status);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(false);
}
}
}
public HotelViewModel EditHotel(int id, HotelViewModel hvmodel)
{
using (HotelmanagementEntities db = new HotelmanagementEntities())
{
var h = db.hotels.FirstOrDefault(p => p.hotelid == id);
if (h == null)
{
return(null);
}
else
{
h.hotelname = hvmodel.hotelname;
h.address = hvmodel.address;
h.city = hvmodel.city;
h.pincode = hvmodel.pincode;
h.contactnumber = hvmodel.contactnumber;
h.contactperson = hvmodel.contactperson;
h.website = hvmodel.website;
h.facebook = hvmodel.facebook;
h.twitter = hvmodel.twitter;
h.isactive = hvmodel.isactive;
h.isdelete = hvmodel.isdelete;
h.createddate = hvmodel.createddate;
h.createdby = hvmodel.createdby;
db.SaveChanges();
return(hvmodel);
}
}
}
public void DeleteHotel(int id)
{
using (HotelmanagementEntities db = new HotelmanagementEntities())
{
hotel h = db.hotels.Where(p => p.hotelid == id).FirstOrDefault();
db.Entry(h).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
}
}
public IEnumerable <BookingViewModel> GetBookings()
{
using (HotelmanagementEntities db = new HotelmanagementEntities())
{
List <BookingViewModel> bvmodel = new List <BookingViewModel>();
List <booking> bdata = db.bookings.ToList();
var config = new MapperConfiguration(cfg =>
{
cfg.CreateMap <booking, BookingViewModel>();
});
IMapper mapper = config.CreateMapper();
bvmodel = mapper.Map <List <booking>, List <BookingViewModel> >(bdata);
return(bvmodel);
}
}
public RoomsViewModel AddRooms(RoomsViewModel rvmodel)
{
using (HotelmanagementEntities db = new HotelmanagementEntities())
{
room r = new room();
var config = new MapperConfiguration(cfg =>
{
cfg.CreateMap <RoomsViewModel, room>();
});
IMapper mapper = config.CreateMapper();
r = mapper.Map <RoomsViewModel, room>(rvmodel);
db.rooms.Add(r);
db.SaveChanges();
return(rvmodel);
}
}
public HotelViewModel AddHotel(HotelViewModel hvmodel)
{
using (HotelmanagementEntities db = new HotelmanagementEntities())
{
hotel h = new hotel();
var config = new MapperConfiguration(cfg =>
{
cfg.CreateMap <HotelViewModel, hotel>();
});
IMapper mapper = config.CreateMapper();
h = mapper.Map <HotelViewModel, hotel>(hvmodel);
db.hotels.Add(h);
db.SaveChanges();
return(hvmodel);
}
}
public HotelViewModel GetById(int id)
{
using (HotelmanagementEntities db = new HotelmanagementEntities())
{
HotelViewModel model = new HotelViewModel();
hotel h = db.hotels.Where(p => p.hotelid == id).FirstOrDefault();
var config = new MapperConfiguration(cfg =>
{
cfg.CreateMap <hotel, HotelViewModel>();
});
IMapper mapper = config.CreateMapper();
model = mapper.Map <hotel, HotelViewModel>(h);
return(model);
}
}
public IEnumerable <HotelViewModel> GetHotels()
{
using (HotelmanagementEntities db = new HotelmanagementEntities())
{
List <HotelViewModel> hlist = new List <HotelViewModel>();
List <hotel> hotellist = db.hotels.OrderBy(h => h.hotelname).ToList();
var config = new MapperConfiguration(cfg =>
{
cfg.CreateMap <hotel, HotelViewModel>();
});
IMapper mapper = config.CreateMapper();
hlist = mapper.Map <List <hotel>, List <HotelViewModel> >(hotellist);
return(hlist);
}
}
public List <RoomsViewModel> GetRoomByCategory(string category)
{
using (HotelmanagementEntities db = new HotelmanagementEntities())
{
List <room> rlist = db.rooms.Where(x => x.roomcategory == category).ToList();
List <RoomsViewModel> rvmodel = new List <RoomsViewModel>();
var config = new MapperConfiguration(cfg =>
{
cfg.CreateMap <room, RoomsViewModel>().ForMember(d => d.hotel, o => o.MapFrom(s => s.hotel));
cfg.CreateMap <hotel, HotelViewModel>();
});
IMapper mapper = config.CreateMapper();
rvmodel = mapper.Map <List <room>, List <RoomsViewModel> >(rlist);
return(rvmodel);
}
}
public bool GetRoomAvailability(int roomId, DateTime date)
{
using (HotelmanagementEntities db = new HotelmanagementEntities())
{
bool status = false;
try
{
List <booking> bookings = db.bookings.Where(x => x.roomid == roomId && x.bookingdate.Equals(date) && (x.bookingstatus == "Optional" || x.bookingstatus == "Definitive")).ToList();
if (bookings.Count <= 0)
{
status = true;
}
return(status);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(false);
}
}
}
public IEnumerable <RoomsViewModel> GetRooms()
{
using (HotelmanagementEntities db = new HotelmanagementEntities())
{
List <RoomsViewModel> rvmodel = new List <RoomsViewModel>();
List <room> list = db.rooms.OrderBy(p => p.roomprice).ToList();
var config = new MapperConfiguration(cfg =>
{
cfg.CreateMap <room, RoomsViewModel>().ForMember(d => d.hotel, o => o.MapFrom(s => s.hotel));
cfg.CreateMap <hotel, HotelViewModel>();
});
IMapper mapper = config.CreateMapper();
foreach (room item in list)
{
var room = mapper.Map <room, RoomsViewModel>(item);
rvmodel.Add(room);
}
return(rvmodel);
}
}
public bool DeleteBooking(int bookingId)
{
using (HotelmanagementEntities db = new HotelmanagementEntities())
{
bool status = false;
try
{
booking booking = db.bookings.Where(x => x.bookingid == bookingId).AsNoTracking().FirstOrDefault();
booking.bookingstatus = "Deleted";
db.Entry(booking).State = EntityState.Modified;
if (db.SaveChanges() > 0)
{
status = true;
}
return(status);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(false);
}
}
}
public bool UpdateBookingStatus(int id, string status)
{
using (HotelmanagementEntities db = new HotelmanagementEntities())
{
bool updated = false;
try
{
booking booking = db.bookings.AsNoTracking().Where(x => x.bookingid == id).FirstOrDefault();
booking.bookingstatus = status;
db.Entry(booking).State = EntityState.Modified;
if (db.SaveChanges() > 0)
{
updated = true;
}
return(updated);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(false);
}
}
}
