public void User_UserAttractionUpdate(UserAttractionEntity userAttractionEntity) { try { SqlHelper.QuerySP("User_UserAttractionUpdate", new { UserAttractionId = userAttractionEntity.UserAttractionId, UserId = userAttractionEntity.UserId, TourName = userAttractionEntity.TourName, TotalExpenditure = userAttractionEntity.TotalExpenditure, TotalDistance = userAttractionEntity.TotalDistance, NoOfHours = userAttractionEntity.NoOfHours, NoOfNights = userAttractionEntity.NoOfNights, CreatedBy = userAttractionEntity.CreatedBy, NoOfLunchSlots = userAttractionEntity.NoOfLunchSlots, NoOfBreakFeastSlots = userAttractionEntity.NoOfBreakFeastSlots, NoOfDinnerSlots = userAttractionEntity.NoOfDinnerSlots, NoOfHotelsVisited = userAttractionEntity.NoOfHotelsVisited, TravelDate = userAttractionEntity.TravelDate, StartLocationId = userAttractionEntity.StartLocationId, EndLocationId = userAttractionEntity.EndLocationId, AttractionInformation = DataTableFun.ToDataTable <userTable_OrderAttraction>(userAttractionEntity.userTable_OrderAttraction) }); } catch (Exception ex) { throw ex; } }
public void Scheduler_InsertAttractionInfo(SchedulerInsertPlaceDetails schedulerInsertPlaceDetails, int countryId, AttractionsDTO attractionsDTO) { try { if (schedulerInsertPlaceDetails.WeekDaysOpenClose == null) { schedulerInsertPlaceDetails.WeekDaysOpenClose = new List <WeekDaysOpenClose>(); } if (schedulerInsertPlaceDetails.GooglePhotos == null) { schedulerInsertPlaceDetails.GooglePhotos = new List <GooglePhotos>(); } if (schedulerInsertPlaceDetails.GoogleReview == null) { schedulerInsertPlaceDetails.GoogleReview = new List <GoogleReview>(); } SqlHelper.countryId = countryId; SqlHelper.QuerySP("Scheduler_InsertAttractionInfo", new { AttractionsId = schedulerInsertPlaceDetails.AttractionsId, CategoryDt = ConvertArrayToDataTable.GetDataTableCateogry(schedulerInsertPlaceDetails.Category), GoogleWebSite = schedulerInsertPlaceDetails.GoogleWebSite, GoogleICon = schedulerInsertPlaceDetails.GoogleICon, GoogleInternational_phone_number = schedulerInsertPlaceDetails.GoogleInternational_phone_number, Googleadr_address = schedulerInsertPlaceDetails.Googleadr_address, GoogleName = schedulerInsertPlaceDetails.GoogleName, GoogleRating = schedulerInsertPlaceDetails.GoogleRating, WeekDaysOpenClose = DataTableFun.ToDataTable <WeekDaysOpenClose>(schedulerInsertPlaceDetails.WeekDaysOpenClose), GooglePhotos = DataTableFun.ToDataTable <GooglePhotos>(schedulerInsertPlaceDetails.GooglePhotos), GoogleReview = DataTableFun.ToDataTable <GoogleReview>(schedulerInsertPlaceDetails.GoogleReview), Pricelevel = schedulerInsertPlaceDetails.Pricelevel, Latitude = attractionsDTO.Latitude, AddressOne = attractionsDTO.AddressOne, AddressTwo = attractionsDTO.AddressTwo, CityName = attractionsDTO.CityName, CreatedBy = attractionsDTO.CreatedBy, Longitude = attractionsDTO.Longitude, PlaceId = attractionsDTO.PlaceId, StateName = attractionsDTO.StateName, CountryId = attractionsDTO.CountryId, StateShortName = attractionsDTO.StateShortName, CityShortName = attractionsDTO.CityShortName, Utc_offset = schedulerInsertPlaceDetails.Utc_offset, AttractionName = attractionsDTO.AttractionName }); } catch (Exception ex) { throw ex; } }
public void Service_TravelDistance(List <user_AttractionTravelTimeDistance> attractionTravelTimeDistance) { try { SqlHelper.QuerySP("user_AttractionTravelTimeDistance", new { AttractionTravelTimeDistanceInfo = DataTableFun.ToDataTable <user_AttractionTravelTimeDistance>(attractionTravelTimeDistance) }); } catch (Exception ex) { throw ex; } }
public List <AttractionsDTO> Services_GetPlaceDetails(List <userTable_OnlyId> attractionIds, int SourceAttractionId) { try { List <AttractionsDTO> _returnResult = SqlHelper.QuerySP <AttractionsDTO>("Services_GetPlaceDetails", new { AttractionId = DataTableFun.ToDataTable <userTable_OnlyId>(attractionIds), SourceAttractionId = SourceAttractionId }).ToList(); return(_returnResult); } catch (Exception ex) { throw ex; } }
public void Scheduler_InsertNearBy(List <NearByPlaceSearchEntity> nearByPlaceSearchEntity, int countryId, int attractionId, int attractionTravelStepsId, int mapsId) { try { SqlHelper.countryId = countryId; SqlHelper.QuerySP("Scheduler_InsertNearBy", new { NearBySearchData = DataTableFun.ToDataTable <NearByPlaceSearchEntity>(nearByPlaceSearchEntity) , AttractionsId = attractionId , AttractionTravelStepsId = attractionTravelStepsId , MapsId = mapsId }); } catch (Exception ex) { throw ex; } }
public void Scheduler_InsertAttractionTravelTimeDistance(BusinessEntites.Common.AttractionTravelTimeDistanceDTO attractionTravelTimeDistanceDTO, int countryId, List <StepsConsolidated> stepsConsolidated) { try { SqlHelper.countryId = countryId; SqlHelper.QuerySP("Scheduler_InsertAttractionTravelTimeDistance", new { SourceAttractionId = attractionTravelTimeDistanceDTO.SourceAttractionId, DestinationAttractionId = attractionTravelTimeDistanceDTO.DestinationAttractionId, TravelModeId = attractionTravelTimeDistanceDTO.TravelModeId, TravelTime = attractionTravelTimeDistanceDTO.TravelTime, Distance = attractionTravelTimeDistanceDTO.Distance, StepsConsolidated = DataTableFun.ToDataTable <StepsConsolidated>(stepsConsolidated), }); } catch (Exception ex) { throw ex; } }
public int Services_AddAttraction(AttractionsDTO attractionDTO, List <userTable_Category> Category, List <user_AttractionsActiveStatus> attractionsActiveStatus) { try { var _returnResult = SqlHelper.QuerySP <int>("Services_AddAttraction", new { AttractionName = attractionDTO.AttractionName , AddressOne = attractionDTO.AddressOne , AddressTwo = attractionDTO.AddressTwo , CityId = attractionDTO.CityId , CategoryId = attractionDTO.CategoryId , Longitude = attractionDTO.Longitude , Latitude = attractionDTO.Longitude , PlaceId = attractionDTO.PlaceId , RankId = attractionDTO.RankId , CreatedBy = attractionDTO.CreatedBy , GoogleSearchText = attractionDTO.GoogleSearchText , GoogleWebSite = attractionDTO.GoogleWebSite , GoogleICon = attractionDTO.GoogleICon , GoogleInternational_phone_number = attractionDTO.GoogleInternational_phone_number , Googleadr_address = attractionDTO.Googleadr_address , GoogleName = attractionDTO.GoogleName , GoogleRating = attractionDTO.GoogleRating , GoogleUser_ratings_total = attractionDTO.GoogleUser_ratings_total , IsUserPersonalRequest = attractionDTO.IsUserPersonalRequest , AttractionTimeExisted = attractionDTO.AttractionTimeExisted , AttractionsActiveStatusInfo = DataTableFun.ToDataTable <user_AttractionsActiveStatus>(attractionsActiveStatus) , CategoryList = DataTableFun.ToDataTable <userTable_Category>(Category) }).ToList(); return(_returnResult.FirstOrDefault()); } catch (Exception ex) { throw ex; } }