public void DeleteTour(Tables.Tour tour)
        {
            DataServiceCommon dsCommon = new DataServiceCommon();

            dsCommon.DeleteTourInCascade(tour);
            db.tours.DeleteOnSubmit(tour);
            db.SubmitChanges();
        }
 public void DeleteTourInCascade(Tables.Tour tour)
 {
     foreach (Repair repair in dsRepair.LoadRepairs())
     {
         dsRepair.DeleteRepair(repair);
     }
     foreach (NearBy nearBy in dsNearBy.LoadNearBys())
     {
         dsNearBy.DeleteNearBy(nearBy);
     }
     foreach (PictureTour pictureTour in dsPictureTour.LoadPictureTours())
     {
         dsPictureTour.DeletePictureTour(pictureTour);
     }
 }
 public void addTour(Tables.Tour newTour)
 {
     db.tours.InsertOnSubmit(newTour);
     db.SubmitChanges();
 }