public string AddTraveller(TravellerModel travellerModel) { string result = string.Empty; using (HotelDBContext travellerEntities = new HotelDBContext()) { try { Traveller traveller = new Traveller(); traveller.FirstName = travellerModel.FirstName; traveller.MiddleName = travellerModel.MiddleName; traveller.LastName = travellerModel.LastName; traveller.MobileNo = travellerModel.MobileNo; traveller.EmailId = travellerModel.EmailId; traveller.Gender = travellerModel.Gender; traveller.Address = travellerModel.Address; traveller.FirstName_2 = travellerModel.FirstName_2; traveller.MiddleName_2 = travellerModel.MiddleName_2; traveller.LastName_2 = travellerModel.LastName_2; traveller.CreatedOn = System.DateTime.Now.ToShortDateString(); travellerEntities.Entry(traveller).State = System.Data.Entity.EntityState.Added; travellerEntities.SaveChanges(); result = "Record Inserted"; } catch (Exception ex) { Log.Error("Failed To Insert", ex); result = "Failed To Insert"; } return(result); } }
public string AddPayment(PaymentModel model) { string result = string.Empty; using (HotelDBContext dBEntities = new HotelDBContext()) { try { Payment paymentTbl = new Payment(); paymentTbl.BookingId = model.BookingId; paymentTbl.CardNumber = model.CardNumber; paymentTbl.NameOnCard = model.NameOnCard; paymentTbl.ExpiryDate = model.ExpiryDate; paymentTbl.Status = model.Status; paymentTbl.CreatedOn = System.DateTime.Now.ToShortDateString(); dBEntities.Entry(paymentTbl).State = System.Data.Entity.EntityState.Added; dBEntities.SaveChanges(); result = "Record Inserted"; } catch (Exception) { result = "Failed To Insert"; } return(result); } }
public string UpdateRoom(RoomTypeModel roomType) { string result = string.Empty; using (HotelDBContext _hotelEntities = new HotelDBContext()) { try { RoomType roomTbl = new RoomType(); roomTbl.Id = roomType.Id; roomTbl.RoomName = roomType.RoomName; roomTbl.Amenities = roomType.Amenities; roomTbl.ImagePath = roomType.ImagePath; roomTbl.ModifiedOn = System.DateTime.Now.ToShortDateString(); _hotelEntities.RoomTypes.Add(roomTbl); _hotelEntities.Entry(roomTbl).State = System.Data.Entity.EntityState.Modified; _hotelEntities.SaveChanges(); result = "Record Updated"; } catch (Exception) { result = "Failed To Upadate"; } return(result); } }
public IEnumerable <BookingViewModel> GetAllBookings() { using (HotelDBContext _hotelEntities = new HotelDBContext()) { var data = _hotelEntities.Bookings.ToList(); List <BookingViewModel> bookingList = new List <BookingViewModel>(); for (var i = 0; i < data.Count; i++) { BookingViewModel bookingView = new BookingViewModel(); bookingView.Id = data[i].Id; bookingView.InvoiceNumber = data[i].InvoiceNumber; bookingView.HotelId = Convert.ToInt32(data[i].HotelId); bookingView.RoomId = Convert.ToInt32(data[i].RoomId); RoomTypeModel roomModel = GetAllRoomType().SingleOrDefault(x => x.Id == bookingView.RoomId); bookingView.FromDate = roomModel.RoomName; bookingView.ToDate = roomModel.RoomName; bookingView.BookingDate = roomModel.RoomName; bookingView.Adult = data[i].Adult; bookingView.Children = data[i].Children; bookingView.BuyingPrice = data[i].BuyingPrice; bookingList.Add(bookingView); } return(bookingList); } }
public HotelModel GetHotelById(int hotelID) { using (HotelDBContext _hotelEntities = new HotelDBContext()) { var data = _hotelEntities.Hotels.ToList(); List <HotelModel> hotelList = new List <HotelModel>(); for (var i = 0; i < data.Count; i++) { HotelModel model = new HotelModel(); model.Id = data[i].Id; model.HotelName = data[i].HotelName; model.Address = data[i].Address; model.CityId = data[i].CityId; model.CountryId = data[i].CountryId; model.PhoneNumber = data[i].PhoneNumber; model.CancellationPolicy = data[i].CancellationPolicy; model.Description = data[i].Description; model.DefaultCurrency = data[i].DefaultCurrency; model.PricePerNight = data[i].PricePerNight; hotelList.Add(model); } HotelModel getHotelData = hotelList.SingleOrDefault(x => x.Id == hotelID); return(getHotelData); } }
// GET: BookNow public ActionResult Information(List <RoomSelected> model) { HotelDBContext db = new HotelDBContext(); TypeRoomModel tpm = new TypeRoomModel(); OrderModel om = new OrderModel(); double TotalPrice = 0; List <RoomSelected> list = new List <RoomSelected>(); for (int i = 0; i < model.Count; i++) { if (model.ElementAt(i).Checked) { model.ElementAt(i).Price = tpm.FindPrice(model.ElementAt(i).RoomID); double TotalDate = (model.ElementAt(i).ToDate - model.ElementAt(i).FromDate).TotalDays; model.ElementAt(i).TotalPrice = TotalDate * model.ElementAt(i).Price; TotalPrice += model.ElementAt(i).TotalPrice; list.Add(model.ElementAt(i)); } } SearchInput search = (SearchInput)Session["Search"]; if (list.Count != search.NumberOfRoom) { ModelState.AddModelError("NumberOfRoom", $"Please choose {search.NumberOfRoom} room(s)"); ViewBag.TypeRoom = db.TypeRooms.Find(search.TypeRoomID); return(View("~/Views/Home/Search.cshtml", model)); } Bill bill = new Bill(); bill.Total = TotalPrice; bill.Rooms = list; Session["FinalBill"] = bill; return(View(bill)); }
public void TestMethod1() { //__MigrationHistory这个表为ef中Code first的编程方式 //如果通过code first自动生成的数据库,就会存在这个表,这个表存在代码自动生成数据库 //后续程序启动程序就会判断该表是否存在,如果存在就代码使用的是code first代码创建的数据库 //如果不存在代表使用的是code first数据库优先的方式 //两种模式不可混用 //以下代码在数据库不存在的情况下,可自动创建数据库表 //一旦数据实体更改增加字段,那么就需要采用ef数据迁移的方式更新数据库 //就算手动更新了数据库,增加了字段,保证了与实体的一致也达不到效果,也将报错 //可以删除__MigrationHistory表,代表采用的是code first中的数据库优先,这时保证数据库接口与实体的结构一直就可以保存成功 try { UserInfo u = new UserInfo() { Id = "2", UserCode = "1", UserName = "******", PassWord = "******", PassWord3 = "2", PassWord4 = "2" }; using (HotelDBContext contenxt = new HotelDBContext()) { contenxt.customer.Add(u); contenxt.SaveChanges(); } } catch (Exception e) { } }
public IEnumerable <HotelViewModel> GetAllHotels() { using (HotelDBContext _hotelEntities = new HotelDBContext()) { var data = _hotelEntities.Hotels.ToList(); List <HotelViewModel> hotelList = new List <HotelViewModel>(); for (var i = 0; i < data.Count; i++) { HotelViewModel hotelView = new HotelViewModel(); hotelView.Id = data[i].Id; hotelView.HotelName = data[i].HotelName; hotelView.Address = data[i].Address; hotelView.PhoneNumber = data[i].PhoneNumber; hotelView.CancellationPolicy = data[i].CancellationPolicy; hotelView.Description = data[i].Description; hotelView.CountryId = Convert.ToInt32(data[i].CountryId); CountryModel countryModel = GetAllCountry().SingleOrDefault(x => x.Id == hotelView.CountryId); hotelView.CountryName = countryModel.CountryName; hotelView.CityId = Convert.ToInt32(data[i].CityId); CityModel cityModel = GetAllCity().SingleOrDefault(x => x.Id == hotelView.CityId); hotelView.CityName = cityModel.CityName; hotelView.PricePerNight = Convert.ToDecimal(data[i].PricePerNight); hotelView.DefaultCurrency = data[i].DefaultCurrency; hotelList.Add(hotelView); } return(hotelList); } }
public string AddBooking(BookingModel model) { string result = string.Empty; using (HotelDBContext _hotelEntities = new HotelDBContext()) { try { Booking bookingTbl = new Booking(); bookingTbl.InvoiceNumber = model.InvoiceNumber; bookingTbl.HotelId = model.HotelId; bookingTbl.RoomId = model.RoomId; bookingTbl.FromDate = model.FromDate; bookingTbl.ToDate = model.ToDate; bookingTbl.BookingDate = model.BookingDate; bookingTbl.BuyingPrice = model.BuyingPrice; bookingTbl.BuyingCurrency = model.BuyingCurrency; bookingTbl.CreatedOn = System.DateTime.Now.ToShortDateString(); _hotelEntities.Entry(bookingTbl).State = System.Data.Entity.EntityState.Added; _hotelEntities.SaveChanges(); result = "Record Inserted"; } catch (Exception) { result = "Failed To Insert"; } return(result); } }
public string AddHotel(HotelModel model) { string result = string.Empty; using (HotelDBContext _hotelEntities = new HotelDBContext()) { try { Hotel hotel = new Hotel(); hotel.HotelName = model.HotelName; hotel.Address = model.Address; hotel.CityId = model.CityId; hotel.CountryId = model.CountryId; hotel.PhoneNumber = model.PhoneNumber; hotel.Description = model.Description; hotel.CancellationPolicy = model.CancellationPolicy; hotel.DefaultCurrency = model.DefaultCurrency; hotel.PricePerNight = model.PricePerNight; hotel.CreatedOn = System.DateTime.Now.ToShortDateString(); _hotelEntities.Entry(hotel).State = System.Data.Entity.EntityState.Added; _hotelEntities.SaveChanges(); result = "Record Inserted"; } catch (Exception) { result = "Failed To Insert"; } return(result); } }
public User Login(string username, string password) { var context = new HotelDBContext(); var _user = context.User.Where(x => x.UserName == username && x.Password == password).SingleOrDefault(); return(_user); }
public List <HotelComment> GetHotelComment(int id) { var context = new HotelDBContext(); var comments = context.HotelComment.Where(x => x.HotelId == id).ToList(); return(comments); }
public List <HotelsViewModel> GetAll() { var context = new HotelDBContext(); var _hotels = (from h in context.Hotel join hs in context.HotelScore on h.Id equals hs.HotelId join hi in context.HotelImage on h.Id equals hi.HotelId select new HotelsViewModel { Id = h.Id, Name = h.Name, Description = h.Description, ScoreValue = hs.ScoreValue, ImagePath = hi.ImagePath }); List <HotelsViewModel> _hotellist = _hotels.ToList(); return(_hotellist); }
public HotelsViewModel GetHotelDetail(int id) { var context = new HotelDBContext(); var balance = (from h in context.Hotel join ha in context.HotelAddress on h.Id equals ha.HotelId join hs in context.HotelScore on h.Id equals hs.HotelId join hi in context.HotelImage on h.Id equals hi.HotelId where h.Id == id select new HotelsViewModel { Id = h.Id, Name = h.Name, Description = h.Description, AddressText = ha.AddressText, ScoreValue = hs.ScoreValue, ImagePath = hi.ImagePath }).SingleOrDefault(); return(balance); }
public IEnumerable <RoomTypeModel> GetAllRoomType() { using (HotelDBContext _hotelEntities = new HotelDBContext()) { var data = _hotelEntities.RoomTypes.ToList(); List <RoomTypeModel> roomList = new List <RoomTypeModel>(); for (var i = 0; i < data.Count; i++) { RoomTypeModel room = new RoomTypeModel(); room.Id = data[i].Id; room.RoomName = data[i].RoomName; roomList.Add(room); } return(roomList); } }
public List <HotelsViewModel> GetSelectedHotels(string searchString) { var context = new HotelDBContext(); var searchResult = (from h in context.Hotel join hs in context.HotelScore on h.Id equals hs.HotelId join hi in context.HotelImage on h.Id equals hi.HotelId join ha in context.HotelAddress on h.Id equals ha.HotelId select new HotelsViewModel { Id = h.Id, Name = h.Name, Description = h.Description, AddressText = ha.AddressText, ScoreValue = hs.ScoreValue, ImagePath = hi.ImagePath }). Where(x => x.Name.Contains(searchString) || x.AddressText.Contains((searchString))); List <HotelsViewModel> searchHotels = searchResult.ToList(); return(searchHotels); }
public IEnumerable <CountryModel> GetAllCountry() { using (HotelDBContext _hotelEntities = new HotelDBContext()) { var data = _hotelEntities.Countries.ToList(); List <CountryModel> countryList = new List <CountryModel>(); for (var i = 0; i < data.Count; i++) { CountryModel country = new CountryModel(); country.Id = data[i].Id; country.CountryName = data[i].CountryName; countryList.Add(country); } return(countryList); } }
public IEnumerable <AmenitiesModel> GetAllAmenities() { using (HotelDBContext _hotelEntities = new HotelDBContext()) { var data = _hotelEntities.Amenities.ToList(); List <AmenitiesModel> amenityList = new List <AmenitiesModel>(); for (var i = 0; i < data.Count; i++) { AmenitiesModel amenities = new AmenitiesModel(); amenities.Id = data[i].Id; amenities.AmenityName = data[i].AmenityName; amenityList.Add(amenities); } return(amenityList); } }
public HotelComment AddHotelComment(HotelComment hotelcomment) { var context = new HotelDBContext(); try { if (hotelcomment.Id == 0) { context.HotelComment.Add(hotelcomment); } context.SaveChanges(); } catch (Exception e) { Console.WriteLine(e); } return(hotelcomment); }
public RoomTypeModel GetRoomById(int roomID) { using (HotelDBContext _hotelEntities = new HotelDBContext()) { var data = _hotelEntities.RoomTypes.ToList(); List <RoomTypeModel> roomList = new List <RoomTypeModel>(); for (var i = 0; i < data.Count; i++) { RoomTypeModel model = new RoomTypeModel(); model.Id = data[i].Id; model.RoomName = data[i].RoomName; model.Amenities = data[i].Amenities; roomList.Add(model); } RoomTypeModel getRoomData = roomList.SingleOrDefault(x => x.Id == roomID); return(getRoomData); } }
public ActionResult Search(SearchInput model) { HotelDBContext db = new HotelDBContext(); if (ModelState.IsValid) { if ((model.ToDate.Date <= model.FromDate.Date) || (model.FromDate.Date < DateTime.Now.Date)) { ModelState.AddModelError("DateError", "Date is illegal, choose again"); TypeRoomModel TrModel = new TypeRoomModel(); List <TypeRoom> ListTypeRoom = TrModel.ListAll(); ViewBag.ListTypeRoom = new SelectList(ListTypeRoom, "TypeRoomID", "NameRoom"); return(View("Index", model)); } Session["Search"] = model; RoomModel room = new RoomModel(); var ListRoom = room.AvailableRoom(model.TypeRoomID, model.FromDate, model.ToDate); if (ListRoom.Count >= model.NumberOfRoom) { List <RoomSelected> list = new List <RoomSelected>(); foreach (var item in ListRoom) { list.Add(new RoomSelected { RoomID = item.RoomID, FromDate = model.FromDate, ToDate = model.ToDate, Checked = false }); } ViewBag.TypeRoom = db.TypeRooms.Find(model.TypeRoomID); return(View(list)); } else { ViewBag.Message = "There is no room available"; return(View()); } } else { TypeRoomModel TrModel = new TypeRoomModel(); List <TypeRoom> ListTypeRoom = TrModel.ListAll(); ViewBag.ListTypeRoom = new SelectList(ListTypeRoom, "TypeRoomID", "NameRoom"); return(View("Index", model)); } }
public IEnumerable <BookingModel> GetAllBooking() { using (HotelDBContext _hotelEntities = new HotelDBContext()) { var data = _hotelEntities.Bookings.ToList(); List <BookingModel> bookingList = new List <BookingModel>(); for (var i = 0; i < data.Count; i++) { BookingModel booking = new BookingModel(); booking.Id = data[i].Id; booking.InvoiceNumber = data[i].InvoiceNumber; booking.BuyingPrice = data[i].BuyingPrice; booking.BuyingCurrency = data[i].BuyingCurrency; bookingList.Add(booking); } return(bookingList); } }
public IEnumerable <PaymentViewModel> GetPaymentDetails() { using (HotelDBContext _hotelEntities = new HotelDBContext()) { var data = _hotelEntities.Payments.ToList(); List <PaymentViewModel> paymentList = new List <PaymentViewModel>(); for (var i = 0; i < data.Count; i++) { PaymentViewModel paymentView = new PaymentViewModel(); paymentView.Id = data[i].Id; paymentView.Status = data[i].Status; paymentView.BookingId = Convert.ToInt32(data[i].BookingId); BookingModel bookingModel = GetAllBooking().SingleOrDefault(x => x.Id == paymentView.BookingId); paymentView.InvoiceNumber = bookingModel.InvoiceNumber; paymentView.BuyingPrice = bookingModel.BuyingPrice; paymentView.BuyingCurrency = bookingModel.BuyingCurrency; paymentList.Add(paymentView); } return(paymentList); } }
public string DeleteHotel(int id) { string result = string.Empty; using (HotelDBContext _hotelEntities = new HotelDBContext()) { try { Hotel hotel = _hotelEntities.Hotels.Where(x => x.Id == id).FirstOrDefault <Hotel>(); _hotelEntities.Hotels.Remove(hotel); _hotelEntities.SaveChanges(); result = "Record deleted"; } catch (Exception) { result = "Record failed to delete"; } return(result); } }
public ActionResult Check(Entity.AccountAdmin admin) { if (ModelState.IsValid) { Encode ec = new Encode(); admin.Password = ec.EncodeSHA(admin.Password); using (HotelDBContext db = new HotelDBContext()) { var UserDetail = db.AccountAdmins.Where(x => x.Username == admin.Username && x.Password == admin.Password).FirstOrDefault(); if (UserDetail == null) { ViewBag.Error = "Username or password incorrect !"; return(View("Index", admin)); } else { Session["UserID"] = admin.Username; return(RedirectToAction("Index", "Home")); } } } ViewBag.Error = "Username or password incorrect !"; return(View("Index", admin)); }
public TypeRoomModel() { db = new HotelDBContext(); }
public ClientRepository(HotelDBContext hotelDBContext) { this._hotelDBContext = hotelDBContext; }
public RoomRepository(HotelDBContext context) { this._context = context; }
public OrderModel() { db = new HotelDBContext(); }
public UnitOfWorkEF(HotelDBContext dbContext) { this.dbContext = dbContext; }