public void Init() { ctx = EFContext.CreateContext(); repo = new BookingRepository(ctx); b = new Booking() { Comment = "I am a comment", DateArrival = DateTime.Now.AddYears(1), DateCreation = DateTime.Now, DateDeparture = DateTime.Now.AddYears(3), DateDesiredPayment = DateTime.Now.AddYears(3).AddMonths(1), DateModification = DateTime.Now, DateValidation = DateTime.Now.AddMonths(4), Home = ctx.HomeSet.FirstOrDefault(x => x.Title == "LaCorderie"), IsOnline = false, IsSatisfactionSended = false, People = new People() { AcceptMailing = true, Addr = "4 place kleber", City = "Strasbourg", Civility = "Mr", Comment = "A mis le feu à la chambre", Country = "FRANCE", DateBirth = DateTime.Now, DateCreation = DateTime.Now, Email = "*****@*****.**", Firstname = "CHAABANE", Home = ctx.HomeSet.FirstOrDefault(x => x.Title == "LaCorderie"), Lastname = "Jalal", Mark = 0, Phone1 = "0600000000", Phone2 = null, State = null, ZipCode = "67000", Hide = false }, TotalPeople = 4 }; }
public BookingController() { repo = new BookingRepository(); }
private void CreateBooking(BookingsModel model) { BookingRepository bookingRepo = new BookingRepository(_sqlConnectionString); Booking booking = new Booking(); booking.Dealer = new Dealer(); booking.Dealer.Id = _userInfo.Id; booking.Dealer.Name = _userInfo.DealerName; IList<BookingItem> items = new List<BookingItem>(); foreach (BookingItemModel modelItem in model.BookingItems) { BookingItem bookingItem = new BookingItem(); bookingItem.Item = new Item() { Id = modelItem.LubeItemId }; bookingItem.Package = new Package() { Id = modelItem.PackageId }; bookingItem.Quantity = modelItem.Quantity; bookingItem.Unit = modelItem.Unit; items.Add(bookingItem); } booking.Items = items; booking.InvoiceDate = model.InvoiceDate; bookingRepo.Create(booking); }
// GET: Bookings public ActionResult Index() { //Get list of bookings viewable by current user BookingRepository bookingRepo = new BookingRepository(_sqlConnectionString); IEnumerable<Booking> model = bookingRepo.GetList(); return View(model); }
public IEnumerable <Booking> BookingGetAllByCriterion(User user, DateTime?date, Cruise cruise, IEnumerable <StatusType> listStatus) { return(BookingRepository.BookingGetAllByCriterion(user, date, cruise, listStatus)); }
public IQueryOver <Booking, Booking> BookingGetByCriterion(DateTime?date, Cruise cruise) { return(BookingRepository.BookingGetByCriterion(date, cruise)); }
public IList <Booking> BookingGetAllBy(DateTime?startDate, int bookingStatus, bool isLimousine) { return(BookingRepository.BookingGetAllBy(startDate, bookingStatus, isLimousine)); }
public IList <Booking> BookingReportBLL_BookingSearchBy(DateTime startDate, int cruiseId, int bookingStatus) { return(BookingRepository.BookingReportBLL_BookingSearchBy(startDate, cruiseId, bookingStatus)); }
public InstantPaymentNotification(HttpRequest request, string accountEmail, NameValueCollection form, BookingRepository repositoryTicket) { this.request = request; this.accountEmail = accountEmail; this.form = form; _bookingRepository = repositoryTicket; }
public BookingReportBLL() { BookingRepository = new BookingRepository(); CruiseRepository = new CruiseRepository(); }
public CreateBookingCommand(BookingRepository bookingRepostiory, UnitOfWork uow) { _bookingRepository = bookingRepostiory; _uow = uow; }
// GET: Room public ActionResult Index(string sortOrder, string option, string searchString, string currentFilter, int?page) { ViewBag.CurrentSort = sortOrder; ViewBag.nameSortParm = String.IsNullOrEmpty(sortOrder) ? "name_desc" : ""; ViewBag.descrSortParm = sortOrder == "descr" ? "descr_desc" : "descr"; ViewBag.capacitySortParm = sortOrder == "capacity" ? "capacity_desc" : "capacity"; if (searchString != null) { page = 1; } else { searchString = currentFilter; } ViewBag.CurrentFilter = searchString; var details = from r in db.Rooms select r; if (!String.IsNullOrEmpty(searchString)) { details = details.Where(r => (r.RoomName.Contains(searchString)) || (r.Description.Contains(searchString))); } switch (sortOrder) { case "name_desc": details = details.OrderByDescending(d => d.RoomName); break; case "descr": details = details.OrderBy(d => d.Description); break; case "descr_desc": details = details.OrderByDescending(d => d.Description); break; case "capacity": details = details.OrderBy(d => d.Capacity); break; case "capacity_desc": details = details.OrderByDescending(d => d.Capacity); break; default: details = details.OrderBy(d => d.RoomName); break; } int pageSize = 5; int pageNumber = (page ?? 1); BookingRepository repository = new BookingRepository(); var userRoles = repository.GetRoles(User.Identity.Name); if (userRoles.Any(ur => ur == "admin")) { ViewBag.IsAdmin = true; } else { ViewBag.IsAdmin = false; } return(View(details.ToPagedList(pageNumber, pageSize))); //return View(db.Rooms.ToList()); }
public IHttpActionResult GetSales(int id) { Dictionary <string, double> keyValuePairs = new Dictionary <string, double>(); BookingRepository bookingRepository = new BookingRepository(); var bookings = bookingRepository.GetAll().Where(b => b.BookingTime <= DateTime.Now && b.Trip.Bus.VendorId == id); foreach (var booking in bookings) { var str = booking.BookingTime.Date.ToShortDateString(); if (keyValuePairs.ContainsKey(str)) { keyValuePairs[str] += booking.Trip.Bus.PerSeatFair; } else { keyValuePairs.Add(str, booking.Trip.Bus.PerSeatFair); } } var dates = keyValuePairs.Keys; var sales = keyValuePairs.Values; keyValuePairs = new Dictionary <string, double>(); bookingRepository = new BookingRepository(); bookings = bookingRepository.GetAll().Where(b => b.Trip.Bus.VendorId == 1); BusRepository busRepository = new BusRepository(); var buses = busRepository.GetAll().Where(b => b.VendorId == 1); List <string> busList = new List <string>(); List <double> earning = new List <double>(); foreach (var bus in buses) { var b = bus.BusName + "[" + bus.BusId.ToString() + "]"; var d = 0.0; var trp = bus.Trips; foreach (var t in trp) { int pti = t.Bookings.Where(x => x.SeatStatus != "reserved").ToList().Count; d += pti * t.Bus.PerSeatFair; } //busList.Add(b); //earning.Add(d); keyValuePairs.Add(b, d); } var ordered = keyValuePairs.OrderByDescending(x => x.Value).Take(10).ToDictionary(x => x.Key, x => x.Value); int n = ordered.Count < 3 ? ordered.Count : 3; for (int i = 0; i < n; i++) { busList.Add(ordered.Keys.ElementAt(i)); earning.Add(ordered.Values.ElementAt(i)); } return(Ok(new { dates, sales, busList, earning })); }
public SeriesManagerBLL() { SeriesRepository = new SeriesRepository(); BookingRepository = new BookingRepository(); }
//Creamos el constructor y desde el mismo detectamos alguna exepcion en la data public BookingController(BookingRepository bookingRepository) { _bookingRepository = bookingRepository ?? throw new ArgumentNullException(nameof(bookingRepository)); }