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;
}
}