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