public bool UpdateTourBooking(TourBooking booking)
        {
            try
            {
                var t = (from TourBooking in data.TourBookings
                         where TourBooking.MaDatTour == booking.MaDatTour
                         select TourBooking).Single();
                t.MaDatTour    = booking.MaDatTour;
                t.MaKH         = booking.MaKH;
                t.MaTour       = booking.MaTour;
                t.DonGia       = booking.DonGia;
                t.SoLuong      = booking.SoLuong;
                t.ThanhTien    = booking.ThanhTien;
                t.DatThanhToan = booking.DatThanhToan;
                t.Tour         = booking.Tour;
                t.Customer     = booking.Customer;

                data.SubmitChanges();
                return(true);
            }
            catch
            {
                return(false);
            }
        }
        public ActionResult DeleteConfirmed(int id)
        {
            TourBooking tourBooking = db.TourBookings.Find(id);

            db.TourBookings.Remove(tourBooking);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
 public ActionResult Edit([Bind(Include = "MaDatTour,MaKH,MaTour,Dongia,SoLuong,ThanhTien,TrangThai")] TourBooking tourBooking)
 {
     if (ModelState.IsValid)
     {
         db.Entry(tourBooking).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.MaKH   = new SelectList(db.Customers, "MaKH", "TenKH", tourBooking.MaKH);
     ViewBag.MaTour = new SelectList(db.Tours, "MaTour", "TenTour", tourBooking.MaTour);
     return(View(tourBooking));
 }
 public bool AddTourBooking(TourBooking booking)
 {
     try
     {
         data.TourBookings.InsertOnSubmit(booking);
         data.SubmitChanges();
         return(true);
     }
     catch
     {
         return(false);
     }
 }
        // GET: TourBookings/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            TourBooking tourBooking = db.TourBookings.Find(id);

            if (tourBooking == null)
            {
                return(HttpNotFound());
            }
            return(View(tourBooking));
        }
        public bool DeleteTourBooking(int id)
        {
            try
            {
                TourBooking tourB = (from TourBooking in data.TourBookings
                                     where TourBooking.MaDatTour == id
                                     select TourBooking).Single();

                data.TourBookings.DeleteOnSubmit(tourB);
                return(true);
            }
            catch
            {
                return(false);
            }
        }
        // GET: TourBookings/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            TourBooking tourBooking = db.TourBookings.Find(id);

            if (tourBooking == null)
            {
                return(HttpNotFound());
            }
            ViewBag.MaKH   = new SelectList(db.Customers, "MaKH", "TenKH", tourBooking.MaKH);
            ViewBag.MaTour = new SelectList(db.Tours, "MaTour", "TenTour", tourBooking.MaTour);
            return(View(tourBooking));
        }
Esempio n. 8
0
        //TourOrderService в конструкторе принимает объект IUnitOfWork, через который идет взаимодействие с уровнем DAL.

        public void MakeOrder(TourOrderDTO orderDTO)
        {
            Tour tour = Database.Tours.GetByID(orderDTO.TourId);

            if (tour == null)
            {
                throw new ValidationException("Выбраный тур не найден", "");
            }
            TourBooking order = new TourBooking
            {
                TourId = orderDTO.TourId,
                Date   = DateTime.Now,
                Email  = orderDTO.Email,
                Sum    = tour.Price
            };

            Database.TourOrders.Insert(order);
            Database.Save();
        }
        public ActionResult BookTour(int?eventId)
        {
            if (eventId != null)
            {
                //Create Viewmodel
                TourBooking booking = new TourBooking();
                booking.RegularTickets = 1;
                booking.Events         = historicRepository.GetAllTours();
                booking.TourName       = historicRepository.GetTour((int)eventId).EventName;

                //Pass ID value of tour:
                booking.EventId = (int)eventId;
                return(PartialView("BookTour", booking));
            }
            else
            {
                return(RedirectToAction("Index"));
            }
        }
        public ActionResult BookTour(TourBooking booking)
        {
            // The 'booking'-parameter is filled up only with data that is being entered in the form

            HistoricEvent historicEvent = historicRepository.GetTour(booking.EventId);

            if (ModelState.IsValid)
            {
                List <Ticket> tickets = new List <Ticket>();
                Ticket        ticket  = new Ticket();

                //Checks Input Tickets against database Current Tickets
                int ticketsLeft       = historicEvent.CurrentTickets - booking.RegularTickets;
                int ticketsLeftFamily = historicEvent.CurrentTickets - (booking.RegularTickets * 4);

                // Fills ticket if its not a family ticket and you have a correct value that isnt more than the available tickets for event
                if ((!booking.FamilyTicket) && (booking.RegularTickets > 0) && (ticketsLeft >= 0))
                {
                    ticket.Amount  = booking.RegularTickets;
                    ticket.EventId = booking.EventId;
                    ticket.Event   = eventRepository.GetEvent(ticket.EventId);
                    ticket.Price   = (booking.RegularTickets * historicEvent.Price);
                }

                // Redirects back to index page if ticket input is 0 or less
                else if ((!booking.FamilyTicket) && (booking.RegularTickets < 1))
                {
                    return(RedirectToAction("Index"));
                }

                // Redirects back to index page if ticket input is 0 or less
                else if ((booking.FamilyTicket) && (booking.RegularTickets < 1))
                {
                    return(RedirectToAction("Index"));
                }

                // Fills ticket if its a family ticket and you have a correct value that isnt more than the available tickets for event
                else if ((booking.FamilyTicket) && (booking.RegularTickets > 0) && (ticketsLeftFamily >= 0))
                {
                    ticket.Amount  = (booking.RegularTickets * 4);
                    ticket.EventId = booking.EventId;
                    ticket.Event   = eventRepository.GetEvent(ticket.EventId);
                    ticket.Price   = (ticket.Amount * historicEvent.FamilyPrice);
                }

                // Redirects to index page if ticket input is more than available tickets for event
                else if ((ticketsLeft < 0) || (ticketsLeftFamily < 0))
                {
                    return(RedirectToAction("Index"));
                }

                // Create session if it doesn't exist or add ticket to existing session
                if (Session["currentTickets"] == null)
                {
                    tickets.Add(ticket);
                    Session["CurrentTickets"] = tickets;
                }
                else
                {
                    List <Ticket> sessionTickets = (List <Ticket>)Session["currentTickets"];
                    sessionTickets.Add(ticket);
                }
                return(RedirectToAction("Index", "Ticket"));
            }
            // Post booking
            return(PartialView("BookTour", booking));
        }