// Trip Photos public IEnumerable <TripFoto> GetTripFotosByTripId(Guid tripId) { using (TripsDbContext db = new TripsDbContext()) { return(db.TripFotos.Select(t => t).Where(p => p.TripId == tripId && p.IsActive).OrderBy(t => t.Sort).ToList()); } }
public IEnumerable <TypeOfTrip> GetTypesOfTripList() { using (TripsDbContext db = new TripsDbContext()) { return(db.TripTypes.Select(a => a).OrderBy(a => a.Name).ToList()); } }
public TypeOfTrip GetTypeOfTripById(Guid Id) { using (TripsDbContext db = new TripsDbContext()) { return(db.TripTypes.FirstOrDefault(a => a.Id == Id)); } }
public IEnumerable <Destination> GetDestinationsList() { using (TripsDbContext db = new TripsDbContext()) { return(db.Destinations.Select(a => a).OrderBy(a => a.Name).ToList()); } }
public Activity GetActivityById(Guid Id) { using (TripsDbContext db = new TripsDbContext()) { return(db.Activities.FirstOrDefault(a => a.Id == Id)); } }
public Destination GetDestinationById(Guid Id) { using (TripsDbContext db = new TripsDbContext()) { return(db.Destinations.FirstOrDefault(a => a.Id == Id)); } }
public IEnumerable <Activity> GetActivitiesList() { using (TripsDbContext db = new TripsDbContext()) { return(db.Activities.Where(a => a.IsActive).OrderBy(a => a.Name).ToList()); } }
// Program Days public IEnumerable <TripProgram> GetProgramDaysByTripId(Guid tripId) { using (TripsDbContext db = new TripsDbContext()) { var d = db.TripPrograms.Select(t => t).Where(p => p.TripId == tripId && p.IsActive).OrderBy(t => t.DayNumber).ToList(); return(d); } }
public Trip GetTripById(Guid Id) { using (TripsDbContext db = new TripsDbContext()) { return(db.Trips .Include(t => t.Activity) .Include(t => t.Destination) .Include(t => t.TypeOfTrip) .FirstOrDefault(t => t.Id == Id)); } }
public IEnumerable <TypeOfTrip> DeleteTypeOfTrip(Guid Id) { using (TripsDbContext db = new TripsDbContext()) { var currentTypeOfTrip = db.TripTypes.FirstOrDefault(t => t.Id == Id); currentTypeOfTrip.IsActive = false; db.SaveChanges(); return(db.TripTypes.Select(a => a).OrderBy(a => a.Name).ToList()); } }
public TripFoto DeleteTripFoto(Guid Id) { using (TripsDbContext db = new TripsDbContext()) { var currentTripFoto = db.TripFotos.FirstOrDefault(t => t.Id == Id); currentTripFoto.IsActive = false; db.SaveChanges(); return(currentTripFoto); } }
//public Trip ConvertToTripModel(TripRequest tripRequest) //{ // //using (TripsDbContext db = new TripsDbContext()) // //{ // // Guid destinationId = new Guid(); // // var destination = new Destination(); // // if (!string.IsNullOrEmpty(tripRequest.DestinationId)) // // { // // destinationId = Guid.Parse(tripRequest.DestinationId); // // destination = db.Destinations.FirstOrDefault(d => d.Id == destinationId); // // } // // var activity = new Activity(); // // if (!string.IsNullOrEmpty(tripRequest.ActivityId)) // // { // // activity = // // } // // Guid typeOfTripId = new Guid(); // // var typeOfTrip = new TypeOfTrip(); // // if (!string.IsNullOrEmpty(tripRequest.TypeOfTripId)) // // { // // typeOfTripId = Guid.Parse(tripRequest.TypeOfTripId); // // typeOfTrip = db.TripTypes.FirstOrDefault(d => d.Id == typeOfTripId); // // } // // //newTrip.Activities.Add(activity); // // //newTrip.Destinations.Add(destination); // // //newTrip.TypesOfTrip.Add(typeOfTrip); // // return newTrip; // //} //} public IEnumerable <Trip> DeleteTrip(Guid Id) { using (TripsDbContext db = new TripsDbContext()) { var currentTrip = db.Trips.FirstOrDefault(t => t.Id == Id); currentTrip.IsActive = false; db.SaveChanges(); return(db.Trips.Select(t => t).Where(t => t.IsActive).OrderByDescending(t => t.StartDate).ToList()); } }
public IEnumerable <Destination> DeleteDestination(Guid Id) { using (TripsDbContext db = new TripsDbContext()) { var currentDestination = db.Destinations.FirstOrDefault(t => t.Id == Id); currentDestination.IsActive = false; db.SaveChanges(); return(db.Destinations.Select(a => a).OrderBy(a => a.Name).ToList()); } }
public IEnumerable <Activity> DeleteActivity(Guid Id) { using (TripsDbContext db = new TripsDbContext()) { var currentActivity = db.Activities.FirstOrDefault(t => t.Id == Id); currentActivity.IsActive = false; db.SaveChanges(); return(db.Activities.Select(a => a).Where(a => a.IsActive).OrderBy(a => a.Name).ToList()); } }
public TripProgram DeleteProgramDay(Guid Id) { using (TripsDbContext db = new TripsDbContext()) { var currentprogramDay = db.TripPrograms.FirstOrDefault(t => t.Id == Id); currentprogramDay.IsActive = false; db.SaveChanges(); return(currentprogramDay); } }
public Activity CreateActivity(Activity newActivity) { using (TripsDbContext db = new TripsDbContext()) { newActivity.Id = Guid.NewGuid(); newActivity.IsActive = true; db.Activities.Add(newActivity); db.SaveChanges(); return(newActivity); } }
public TripPriceDesc DeleteTripPriceDesc(Guid Id) { using (TripsDbContext db = new TripsDbContext()) { var currentTripPriceDesc = db.TripPriceDescs.FirstOrDefault(t => t.Id == Id); currentTripPriceDesc.IsActive = false; db.SaveChanges(); return(currentTripPriceDesc); } }
public TripFAQ CreateTripFAQ(TripFAQ tripFAQ) { using (TripsDbContext db = new TripsDbContext()) { tripFAQ.Id = Guid.NewGuid(); tripFAQ.IsActive = true; db.TripFAQs.Add(tripFAQ); db.SaveChanges(); return(tripFAQ); } }
public TripFoto CreateTripFoto(TripFoto tripFoto) { using (TripsDbContext db = new TripsDbContext()) { tripFoto.Id = Guid.NewGuid(); tripFoto.IsActive = true; db.TripFotos.Add(tripFoto); db.SaveChanges(); return(tripFoto); } }
public TripProgram CreateProgramDay(TripProgram programDay) { using (TripsDbContext db = new TripsDbContext()) { programDay.Id = Guid.NewGuid(); programDay.IsActive = true; db.TripPrograms.Add(programDay); db.SaveChanges(); return(programDay); } }
public TypeOfTrip CreateTypeOfTrip(TypeOfTrip newTypeOfTrip) { using (TripsDbContext db = new TripsDbContext()) { newTypeOfTrip.Id = Guid.NewGuid(); newTypeOfTrip.IsActive = true; db.TripTypes.Add(newTypeOfTrip); db.SaveChanges(); return(newTypeOfTrip); } }
public IEnumerable <KeyValuePair <Guid, string> > GetKeyValueDestinationsList() { using (TripsDbContext db = new TripsDbContext()) { var entitiesList = db.Destinations .Where(a => a.IsActive) .Select(a => new { a.Id, a.Name }) .OrderBy(a => a.Name).ToDictionary(x => x.Id, x => x.Name).ToList(); return(entitiesList); } }
public TripPriceDesc CreateTripPriceDesc(TripPriceDesc tripPriceDesc) { using (TripsDbContext db = new TripsDbContext()) { tripPriceDesc.Id = Guid.NewGuid(); tripPriceDesc.IsActive = true; db.TripPriceDescs.Add(tripPriceDesc); db.SaveChanges(); return(tripPriceDesc); } }
public Destination CreateDestination(Destination newDestination) { using (TripsDbContext db = new TripsDbContext()) { newDestination.Id = Guid.NewGuid(); newDestination.IsActive = true; db.Destinations.Add(newDestination); db.SaveChanges(); return(newDestination); } }
public TripProgram UpdateProgramDay(TripProgram programDay) { using (TripsDbContext db = new TripsDbContext()) { var currentprogramDay = db.TripPrograms.FirstOrDefault(t => t.Id == programDay.Id); currentprogramDay.DayNumber = programDay.DayNumber; currentprogramDay.Description = programDay.Description; currentprogramDay.Title = programDay.Title; currentprogramDay.TripId = programDay.TripId; currentprogramDay.IsActive = programDay.IsActive; return(currentprogramDay); } }
public TripFAQ UpdateTripFAQ(TripFAQ tripFAQ) { using (TripsDbContext db = new TripsDbContext()) { var currentTripFAQ = db.TripFAQs.FirstOrDefault(t => t.Id == tripFAQ.Id); currentTripFAQ.Description = tripFAQ.Description; currentTripFAQ.Sort = tripFAQ.Sort; currentTripFAQ.Title = tripFAQ.Title; currentTripFAQ.TripId = tripFAQ.TripId; currentTripFAQ.IsActive = tripFAQ.IsActive; return(currentTripFAQ); } }
public TripFoto UpdateTripFoto(TripFoto tripFoto) { using (TripsDbContext db = new TripsDbContext()) { var currentTripFoto = db.TripFotos.FirstOrDefault(t => t.Id == tripFoto.Id); currentTripFoto.Path = tripFoto.Path; currentTripFoto.Sort = tripFoto.Sort; currentTripFoto.Title = tripFoto.Title; currentTripFoto.TripId = tripFoto.TripId; currentTripFoto.IsActive = tripFoto.IsActive; return(currentTripFoto); } }
public TripPriceDesc UpdateTripPriceDesc(TripPriceDesc tripPriceDesc) { using (TripsDbContext db = new TripsDbContext()) { var currentTripPriceDesc = db.TripPriceDescs.FirstOrDefault(t => t.Id == tripPriceDesc.Id); currentTripPriceDesc.Description = tripPriceDesc.Description; currentTripPriceDesc.IsIncluded = tripPriceDesc.IsIncluded; currentTripPriceDesc.Title = tripPriceDesc.Title; currentTripPriceDesc.Sort = tripPriceDesc.Sort; currentTripPriceDesc.TripId = tripPriceDesc.TripId; currentTripPriceDesc.IsActive = tripPriceDesc.IsActive; return(currentTripPriceDesc); } }
public IEnumerable <Trip> GetAllTrips() { using (TripsDbContext db = new TripsDbContext()) { var m = db.Trips.Select(y => y).ToList(); var v = db.Trips .Select(t => t) .Where(t => t.IsActive) .Include(t => t.Activity) .Include(t => t.Destination) .Include(t => t.TypeOfTrip) .OrderByDescending(t => t.StartDate).ToList(); return(v); } }
public Destination UpdateDestination(Destination activity) { using (TripsDbContext db = new TripsDbContext()) { var currentDestination = db.Destinations.FirstOrDefault(t => t.Id == activity.Id); currentDestination.Description = activity.Description; currentDestination.ImagePath = activity.ImagePath; currentDestination.Name = activity.Name; currentDestination.ParentId = activity.ParentId; currentDestination.SeoDescription = activity.SeoDescription; currentDestination.SeoKeywords = activity.SeoKeywords; currentDestination.Url = activity.Url; db.SaveChanges(); return(currentDestination); } }