public bool AddTrip(Trip trip)
{
if (trip.From == null || trip.Id == null || trip.To == null || trip.Price == 0 ||
trip.Date.ToTimestamp() < DateTime.Now.ToTimestamp() ||
trip.SeatsCount == 0 || trip.DriverId == null)
{
return(false);
}
db.Add(trip);
db.SaveChanges();
return(true);
}
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 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 <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 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 bool AddRefund(Refund refund)
{
if (refund.Address == null || refund.Amount < 1 || refund.Done != false)
{
return(false);
}
db.Add(refund);
db.SaveChanges();
return(true);
}
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 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 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 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 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 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 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 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 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 TypeOfTrip UpdateTypeOfTrip(TypeOfTrip activity)
{
using (TripsDbContext db = new TripsDbContext())
{
var currentTypeOfTrip = db.TripTypes.FirstOrDefault(t => t.Id == activity.Id);
currentTypeOfTrip.Description = activity.Description;
currentTypeOfTrip.ImagePath = activity.ImagePath;
currentTypeOfTrip.Name = activity.Name;
currentTypeOfTrip.ParentId = activity.ParentId;
currentTypeOfTrip.SeoDescription = activity.SeoDescription;
currentTypeOfTrip.SeoKeywords = activity.SeoKeywords;
currentTypeOfTrip.Url = activity.Url;
db.SaveChanges();
return(currentTypeOfTrip);
}
}
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);
}
}
public Activity UpdateActivity(Activity activity)
{
using (TripsDbContext db = new TripsDbContext())
{
var currentActivity = db.Activities.FirstOrDefault(t => t.Id == activity.Id);
currentActivity.Description = activity.Description;
currentActivity.ImagePath = activity.ImagePath;
currentActivity.Name = activity.Name;
currentActivity.ParentId = activity.ParentId;
currentActivity.SeoDescription = activity.SeoDescription;
currentActivity.SeoKeywords = activity.SeoKeywords;
currentActivity.Url = activity.Url;
db.SaveChanges();
return(currentActivity);
}
}
public Trip CreateTrip(TripRequest tripRequest)
{
using (TripsDbContext db = new TripsDbContext())
{
try
{
Guid?activityId = new Guid();
if (!string.IsNullOrEmpty(tripRequest.ActivityId))
{
activityId = Guid.Parse(tripRequest.ActivityId);
}
else
{
activityId = null;
}
Guid?destinationId = new Guid();
if (!string.IsNullOrEmpty(tripRequest.DestinationId))
{
destinationId = Guid.Parse(tripRequest.DestinationId);
}
else
{
destinationId = null;
}
Guid?typeOfTripId = new Guid();
if (!string.IsNullOrEmpty(tripRequest.TypeOfTripId))
{
typeOfTripId = Guid.Parse(tripRequest.TypeOfTripId);
}
else
{
typeOfTripId = null;
}
var newTrip = new Trip()
{
Id = Guid.NewGuid(),
IsActive = true,
Days = tripRequest.Days,
EndDate = tripRequest.EndDate,
GroupSize = tripRequest.GroupSize,
HasSale = tripRequest.HasSale,
ImagePath = tripRequest.ImagePath,
Map = tripRequest.Map,
Name = tripRequest.Name,
Nights = tripRequest.Nights,
Price = tripRequest.Price,
PriceText = tripRequest.PriceText,
Sale = tripRequest.Sale,
SeoDescription = tripRequest.SeoDescription,
SeoKeywords = tripRequest.SeoKeywords,
StartDate = tripRequest.StartDate,
Content = tripRequest.Content,
TourDates = tripRequest.TourDates,
Url = tripRequest.Url,
Activity = activityId != null?db.Activities.FirstOrDefault(d => d.Id == activityId) : null,
Destination = destinationId != null?db.Destinations.FirstOrDefault(d => d.Id == destinationId) : null,
TypeOfTrip = typeOfTripId != null?db.TripTypes.FirstOrDefault(d => d.Id == typeOfTripId) : null,
};
db.Trips.Add(newTrip);
db.SaveChanges();
return(newTrip);
}
catch (Exception e)
{
return(null);
}
}
}
public Trip UpdateTrip(TripRequest trip)
{
// var trip = ConvertToTripModel(tripRequest);
using (TripsDbContext db = new TripsDbContext())
{
try
{
Guid?activityId = new Guid();
if (trip.ActivityId != null)
{
activityId = Guid.Parse(trip.ActivityId);
}
else
{
activityId = null;
}
Guid?destinationId = new Guid();
if (trip.DestinationId != null)
{
destinationId = Guid.Parse(trip.DestinationId);
}
else
{
destinationId = null;
}
Guid?typeOfTripId = new Guid();
if (trip.TypeOfTripId != null)
{
typeOfTripId = Guid.Parse(trip.TypeOfTripId);
}
else
{
typeOfTripId = null;
}
var currentTrip = db.Trips.FirstOrDefault(t => t.Id == trip.Id);
currentTrip.Days = trip.Days;
currentTrip.EndDate = trip.EndDate;
currentTrip.GroupSize = trip.GroupSize;
currentTrip.HasSale = trip.HasSale;
currentTrip.ImagePath = trip.ImagePath;
currentTrip.Map = trip.Map;
currentTrip.Name = trip.Name;
currentTrip.Nights = trip.Nights;
currentTrip.Price = trip.Price;
currentTrip.PriceText = trip.PriceText;
currentTrip.Sale = trip.Sale;
currentTrip.SeoDescription = trip.SeoDescription;
currentTrip.SeoKeywords = trip.SeoKeywords;
currentTrip.StartDate = trip.StartDate;
currentTrip.Content = trip.Content;
currentTrip.TourDates = trip.TourDates;
currentTrip.Url = trip.Url;
currentTrip.Activity = activityId != null?db.Activities.FirstOrDefault(d => d.Id == activityId) : null;
currentTrip.Destination = destinationId != null?db.Destinations.FirstOrDefault(d => d.Id == destinationId) : null;
currentTrip.TypeOfTrip = typeOfTripId != null?db.TripTypes.FirstOrDefault(d => d.Id == typeOfTripId) : null;
db.SaveChanges();
return(currentTrip);
}
catch (Exception e)
{
return(null);
}
}
}