Пример #1
0
 public static List<byte> GetDistinctTourDays()
 {
     using (SriLankaToursEntities db = new SriLankaToursEntities())
     {
         return db.TourEntities.Select(x => x.NoOfDays).Distinct().ToList();
     }
 }
Пример #2
0
        internal static bool DeleteTourDay(int tourDayId)
        {
            try
            {
                bool status = false;
                using (SriLankaToursEntities context = new SriLankaToursEntities())
                {
                    TourDayEntity tour = context.TourDayEntities.FirstOrDefault(x => x.TourDayId == tourDayId);

                    if (tour == null)
                        throw new TourDayNotFoundException("Tour day not found");

                    context.TourDayEntities.Remove(tour);
                    context.SaveChanges();

                    DeleteTourDayImages(tour.TourDayImage);

                    status = true;

                }
                return status;

            }
            catch (Exception)
            {

                throw;
            }
        }
Пример #3
0
        internal static TaxiServiceModel CreateTaxiService(TaxiServiceEntity service)
        {
            try
            {
                using (SriLankaToursEntities context = new SriLankaToursEntities())
                {
                    bool isServiceExists = context.TaxiServiceEntities.Any(x => (x.FromId == service.FromId) && (x.ToId == service.ToId) && (x.VehicleId == service.VehicleId));

                    if (isServiceExists)
                        throw new TaxiServiceExistsException("Taxi service already exists");

                    context.TaxiServiceEntities.Add(service);
                    context.SaveChanges();

                    vTaxiService view = context.vTaxiServices.First(x => x.ServiceId == service.ServiceId);

                    Mapper.CreateMap<vTaxiService, TaxiServiceModel>();
                    return Mapper.Map<TaxiServiceModel>(view);

                }

            }
            catch (Exception)
            {

                throw;
            }
        }
Пример #4
0
        internal static bool DeleteTaxiService(int serviceId)
        {
            try
            {
                bool status = false;
                using (SriLankaToursEntities context = new SriLankaToursEntities())
                {
                    TaxiServiceEntity entity = context.TaxiServiceEntities.Find(serviceId);

                    if (entity == null)
                        throw new TaxiServiceNotFoundException("Taxi service not found");

                    context.TaxiServiceEntities.Remove(entity);
                    context.SaveChanges();

                    status = true;

                }
                return status;

            }
            catch (Exception)
            {

                throw;
            }
        }
Пример #5
0
        /// <summary>
        /// Deletes given  tour from database
        /// </summary>
        /// <param name="tourId">Id of the tour to delete</param>
        /// <returns>bool</returns>
        internal static bool DeleteTour(int tourId)
        {
            try
            {
                bool status = false;
                using (SriLankaToursEntities context = new SriLankaToursEntities())
                {
                    TourEntity tour = context.TourEntities.Find(tourId);

                    if (tour == null)
                        throw new TourNotFoundException("Tour not found");

                    context.TourEntities.Remove(tour);
                    context.SaveChanges();

                    DeleteTourImages(tour.TourBannerImage);

                    status = true;

                }
                return status;

            }
            catch (Exception)
            {

                throw;
            }
        }
Пример #6
0
        internal static TourDayModel CreateTourDay(TourDayEntity tourDayEntity)
        {
            try
            {
                using (SriLankaToursEntities context = new SriLankaToursEntities())
                {
                    TourDayEntity tourDay = context.TourDayEntities.Find(tourDayEntity.TourId, tourDayEntity.Day);
                    if (tourDay != null)
                        throw new TourDayExistsException("Tour day you are trying to add already exists");

                    context.TourDayEntities.Add(tourDayEntity);
                    context.SaveChanges();

                    vTourDay view = context.vTourDays.First(x => x.TourDayId == tourDayEntity.TourDayId);

                    Mapper.CreateMap<vTourDay, TourModel>();
                    return Mapper.Map<TourDayModel>(view);

                }
            }
            catch (Exception)
            {

                throw;
            }
        }
Пример #7
0
        internal static TourDayModel GetTourDay(int tourDayId)
        {
            try
            {
                using (SriLankaToursEntities context = new SriLankaToursEntities())
                {
                    vTourDay view = context.vTourDays.FirstOrDefault(x => x.TourDayId == tourDayId);
                    Mapper.CreateMap<vTourDay, TourDayModel>();
                    return Mapper.Map<TourDayModel>(view);
                }
            }
            catch (Exception)
            {

                throw;
            }
        }
Пример #8
0
        internal static TourModel CreateTour(TourEntity tourEntity)
        {
            try
            {
                using (SriLankaToursEntities context = new SriLankaToursEntities())
                {
                    context.TourEntities.Add(tourEntity);
                    context.SaveChanges();

                    return GetTour(tourEntity.TourId);
                }
            }
            catch (Exception)
            {

                throw;
            }
        }
Пример #9
0
        internal static UserModel GetUser(int userId)
        {
            try
            {
                using (SriLankaToursEntities context = new SriLankaToursEntities())
                {
                    vUser view = context.vUsers.First(x => x.UserId == userId);
                    Mapper.CreateMap<vUser, UserModel>();
                    UserModel user = Mapper.Map<vUser, UserModel>(view);
                    return user;
                }

            }
            catch (Exception)
            {

                throw;
            }
        }
Пример #10
0
        internal static TaxiServiceModel GetTaxiService(int serviceId)
        {
            try
            {
                using (SriLankaToursEntities context = new SriLankaToursEntities())
                {
                    vTaxiService view = context.vTaxiServices.FirstOrDefault(x => x.ServiceId == serviceId);

                    if (view == null)
                        throw new TaxiServiceNotFoundException();

                    Mapper.CreateMap<vTaxiService, TaxiServiceModel>();
                    return Mapper.Map<TaxiServiceModel>(view);
                }

            }
            catch (Exception)
            {

                throw;
            }
        }
Пример #11
0
        internal static bool AddTourCharges(IList<TourChargeEntity> entities)
        {
            try
            {
                bool isSuccess = false;

                using (SriLankaToursEntities context = new SriLankaToursEntities())
                {
                    foreach (var entity in entities)
                    {
                        context.TourChargeEntities.Add(entity);
                    }

                    context.SaveChanges();
                    isSuccess = true;
                }
                return isSuccess;
            }
            catch (Exception)
            {

                throw;
            }
        }
Пример #12
0
        internal static IEnumerable<TaxiServiceModel> GetTaxiServices(bool includeHidden)
        {
            try
            {
                using (SriLankaToursEntities context = new SriLankaToursEntities())
                {
                    IEnumerable<vTaxiService> views = context.vTaxiServices.Where(x => (includeHidden == false ? x.Visible == true : x.Visible != null)).ToList();

                    Mapper.CreateMap<vTaxiService, TaxiServiceModel>();
                    return Mapper.Map<IEnumerable<TaxiServiceModel>>(views);
                }

            }
            catch (Exception)
            {

                throw;
            }
        }
Пример #13
0
        internal static ICollection<TourChargeModel> GetTourCharges(int tourId)
        {
            try
            {
                using (SriLankaToursEntities context = new SriLankaToursEntities())
                {

                    IEnumerable<vTourCharge> tourCharges = context.vTourCharges.Where(x => x.TourId == tourId);

                    Mapper.CreateMap<vTourCharge, TourChargeModel>();
                    return Mapper.Map<ICollection<TourChargeModel>>(tourCharges);

                }

            }
            catch (Exception)
            {

                throw;
            }
        }
Пример #14
0
        internal static TaxiServiceModel UpdateTaxiService(TaxiServiceEntity service)
        {
            try
            {
                using (SriLankaToursEntities context = new SriLankaToursEntities())
                {

                    bool isServiceExists = context.TaxiServiceEntities.Any(x => (x.FromId == service.FromId) && (x.ToId == service.ToId) &&
                        (x.VehicleId == service.VehicleId) && (x.ServiceId != service.ServiceId));

                    if (isServiceExists)
                        throw new TaxiServiceExistsException("Taxi service already exists");

                    TaxiServiceEntity entity = context.TaxiServiceEntities.Find(service.ServiceId);

                    entity.Price = service.Price;
                    entity.Visible = service.Visible;
                    entity.FromId = service.FromId;
                    entity.ToId = service.ToId;
                    entity.UpdatedBy = service.UpdatedBy;
                    entity.UpdatedOn = service.UpdatedOn;

                    context.SaveChanges();

                    return GetTaxiService(entity.ServiceId);

                }

            }
            catch (Exception)
            {

                throw;
            }
        }
Пример #15
0
        internal static IEnumerable<TourModel> GetToursByTourDays(bool includeInvisible, byte? noOfTourDays)
        {
            IEnumerable<vTour> view;
            using (SriLankaToursEntities context = new SriLankaToursEntities())
            {
                view = (from t in context.vTours
                        where (includeInvisible == false ? t.Visible == true : t.Visible != null) &&
                        (noOfTourDays.HasValue ? t.NoOfDays == noOfTourDays : t.NoOfDays != null)
                        orderby t.TourId
                        select t).ToList();

                //view = context.vTours.Where(x => (includeInvisible == false ? x.Visible == false : x.Visible != null));

                Mapper.CreateMap<vTour, TourModel>();
                IEnumerable<TourModel> tours = Mapper.Map<IEnumerable<TourModel>>(view);
                return tours;
            }
        }
Пример #16
0
 internal static IEnumerable<FromPlaceEntity> GetFromPlaces(bool includeHidden)
 {
     using (SriLankaToursEntities context = new SriLankaToursEntities())
     {
         return context.FromPlaceEntities
                       .Where(x => includeHidden == false ? x.Visible == true : x.Visible != null).ToList();
     }
 }
Пример #17
0
        internal static IEnumerable<TourDayModel> GetTourDays(int tourId)
        {
            try
            {
                using (SriLankaToursEntities context = new SriLankaToursEntities())
                {
                    IEnumerable<vTourDay> view = context.vTourDays.Where(x => x.TourId == tourId);

                    Mapper.CreateMap<vTourDay, TourDayModel>();
                    return Mapper.Map<IEnumerable<vTourDay>, IEnumerable<TourDayModel>>(view);
                }

            }
            catch (Exception)
            {

                throw;
            }
        }
Пример #18
0
        internal static TourModel UpdateTour(TourModel model)
        {
            try
            {
                TourModel tourUpdated = null;
                using (SriLankaToursEntities context = new SriLankaToursEntities())
                {

                    TourEntity entityTour = context.TourEntities.Find(model.TourId);

                    if (entityTour == null)
                        throw new TourNotFoundException();

                    if (string.IsNullOrEmpty(model.TourBannerImage))
                        model.TourBannerImage = entityTour.TourBannerImage;

                    entityTour.NoOfDays = model.NoOfDays;
                    entityTour.TourBannerImage = model.TourBannerImage;
                    entityTour.TourTitle = model.TourTitle;
                    entityTour.UpdatedBy = model.UpdatedBy;
                    entityTour.UpdatedOn = model.UpdatedOn;
                    entityTour.Visible = model.Visible;
                    entityTour.Description = model.Description;

                    context.SaveChanges();

                    return tourUpdated = GetTour(entityTour.TourId);

                }

            }
            catch (Exception)
            {

                throw;
            }
        }
Пример #19
0
        internal static bool UpdateTourCharges(IList<TourChargeEntity> entities)
        {
            try
            {
                bool status = false;
                using (SriLankaToursEntities context = new SriLankaToursEntities())
                {
                    foreach (TourChargeEntity entity in entities)
                    {

                        TourChargeEntity tourcharge = context.TourChargeEntities.Find(entity.TourId, entity.VehicleId);

                        if (tourcharge == null)
                        {
                            //  context.Entry(entity).State = System.Data.EntityState.Added;
                            context.TourChargeEntities.Add(entity);
                            context.SaveChanges();
                        }
                        else
                        {
                            //context.Entry(entity).State = System.Data.EntityState.Modified;
                            //context.entityChargeEntities.Attach(entity);

                            tourcharge.Price = entity.Price;
                            tourcharge.Description = entity.Description;
                            context.SaveChanges();
                        }

                    }
                    status = true;

                }
                return status;
            }
            catch (Exception)
            {

                throw;
            }
        }
Пример #20
0
        internal static TourDetailModel GetTourAndTourDays(int tourId)
        {
            try
            {
                TourDetailModel tourDetail = new TourDetailModel();
                using (SriLankaToursEntities context = new SriLankaToursEntities())
                {
                    IEnumerable<vTourDay> view = context.vTourDays.Where(x => x.TourId == tourId);

                    tourDetail.Tour = (from t in context.vTours
                                       where t.TourId == tourId
                                       select new TourModel
                                       {
                                           TourBannerImage = t.TourBannerImage,
                                           TourTitle = t.TourTitle,
                                           TourId = t.TourId,
                                           NoOfDays = t.NoOfDays,
                                           Description = t.Description

                                       }).First();

                    Mapper.CreateMap<vTourDay, TourDayModel>();
                    tourDetail.TourDays = Mapper.Map<ICollection<TourDayModel>>(view);

                    return tourDetail;

                }

            }
            catch (Exception)
            {

                throw;
            }
        }
Пример #21
0
        internal static TourDayModel UpdateTourDay(TourDayModel model)
        {
            try
            {
                using (SriLankaToursEntities context = new SriLankaToursEntities())
                {

                    TourDayEntity entity = context.TourDayEntities.Find(model.TourId, model.Day);

                    if (entity == null)
                        throw new TourDayNotFoundException();

                    bool foundDuplicates = (from d in context.TourDayEntities
                                            where d.TourId == model.TourId &&
                                            d.Day == model.Day &&
                                            d.TourDayId != model.TourDayId
                                            select d).Any();

                    if(foundDuplicates)
                        throw new TourDayExistsException("Duplicate record found with same day and tour");

                    if (string.IsNullOrEmpty(model.TourDayImage))
                        model.TourDayImage = entity.TourDayImage;

                    entity.Title = model.Title;
                    entity.TourDayImage = model.TourDayImage;
                    entity.Description = model.Description;

                    context.SaveChanges();

                    return GetTourDay(entity.TourDayId);

                }

            }
            catch (Exception)
            {

                throw;
            }
        }