Example #1
0
        public void ConfirmOrder(Order order)
        {
            order.Status = "Payed";
            TourContext db = new TourContext();

            db.Orders.Add(order);
            db.SaveChanges();
        }
Example #2
0
 public void AddTourToDB(Tour tour)//4-5.6 - create
 {
     using (TourContext db = new TourContext())
     {
         db.Tours.Add(tour);
         db.SaveChanges();
     }
 }
Example #3
0
        public void UpdateTourPrice(string country, int price)//4-5.6 - update
        {
            using (TourContext db = new TourContext())
            {
                Tour t1 = db.Tours.FirstOrDefault(t => t.Сountry == country);//5-6.10

                t1.Price = price;
                db.SaveChanges();   // сохраняем изменения
            }
        }
Example #4
0
 public void DeleteTour(string country)//4-5.6 - delete
 {
     using (TourContext db = new TourContext())
     {
         Tour p1 = db.Tours.FirstOrDefault(t => t.Сountry == country);
         if (p1 != null)
         {
             db.Tours.Remove(p1);
             db.SaveChanges();
         }
     }
 }
Example #5
0
        public void ChoosenTour(string choosen_tour)
        {
            TourContext db   = new TourContext();
            Tour        tour = db.Tours.FirstOrDefault(t => t.Сountry == choosen_tour);

            tour.Status = "Reserved";
            db.SaveChanges();
            Form2 f2 = new Form2();

            this.Hide();
            f2.Show();
        }