public static void MinusToSearchCount(AggregatorSetting aggregatorSetting)
{
lock (ThisLock)
{
aggregatorSetting.CurrentSearches--;
}
}
public static void AddToSearchCount(AggregatorSetting aggregatorSetting)
{
lock (ThisLock)
{
aggregatorSetting.CurrentSearches++;
}
}
private static string GetH2H(long cityCode, AggregatorSetting aggregatorSetting, Settings settings)
{
if (settings.LookupSettings.H2HToSearch.ContainsKey(cityCode))
{
return(settings.LookupSettings.H2HToSearch[cityCode]);
}
return(aggregatorSetting.H2HDefault);
}
public static List <AggregatorSetting> GetAggregatorAuthentication(Settings settings)
{
var returnData = new List <AggregatorSetting>();
// Create and open the connection in a using block. This
// ensures that all resources will be closed and disposed
// when the code exits.
using (var connection = new SqlConnection(settings.DatabaseSettings.ReadConnectionString))
{
// Create the Command and Parameter objects.
var command = new SqlCommand("dbo.spAuthenticationGetAll", connection)
{
CommandType = CommandType.StoredProcedure
};
// Open the connection in a try/catch block.
try
{
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
var setting = new AggregatorSetting
{
Enabled = (bool)reader["Enabled"],
H2HDefault = (string)reader["H2HDefault"],
UserName = (string)reader["UserName"],
Password = (string)reader["Password"],
Id = (int)reader["Id"],
PtsPassword = (string)reader["PTSPassword"],
PtsUserName = (string)reader["PTSUserName"],
HotelConcurrentSearches = (int)reader["HotelConcurrentSearches"],
Tracker = (string)reader["Tracker"],
PtsNetwork = (string)reader["PtsNetwork"],
PtsTimeOut = (int)reader["PtsTimeOut"],
PtsUrl = (string)reader["PtsUrl"],
};
var featureCode = (string)reader["PtsFeatureCode"];
setting.PtsFeatureCode = featureCode.Contains(",") ? featureCode.Split(',') : new[] { featureCode };
returnData.Add(setting);
}
reader.Close();
}
catch (Exception ex)
{
ErrorHelper.SendErrorEmail(ex, "Error getting GetAggregatorAuthentication", settings);
}
return(returnData);
}
}
public void ConvertSearch(AccommodationSearchRequest request, AggregatorSetting aggregatorSetting)
{
Tracker = aggregatorSetting.Tracker;
NumberOfRooms = request.NumberOfRooms;
NumberOfAdults = request.NumberOfAdults;
NumberOfChildren = request.ChildAge == null ? 0 : request.ChildAge.Count;
NumberOfInfants = request.NumberOfInfants ?? 0;
if (request.ChildAge != null)
{
var isFirst = true;
foreach (var childAge in request.ChildAge)
{
if (isFirst)
{
isFirst = false;
}
else
{
ChildAges += ",";
}
ChildAges += childAge;
}
}
MinStarRating = request.MinStarRating;
CheckIn = request.CheckIn;
CheckOut = request.CheckOut;
CountryCode = request.CountryCode;
CityCode = request.CityCode;
ResortCode = request.ResortCode ?? 0;
if (request.SuperIds != null && request.SuperIds.Count != 0)
{
var isFirst = true;
foreach (var superId in request.SuperIds)
{
if (isFirst)
{
isFirst = false;
}
else
{
SuperIds += ",";
}
SuperIds += superId;
}
}
}
public static bool CheckIfWeAreOkToSearch(AggregatorSetting aggregatorSetting, Settings settings)
{
AddToSearchCount(aggregatorSetting);
lock (ThisLock)
{
if (aggregatorSetting.CurrentSearches > aggregatorSetting.HotelConcurrentSearches)
{
ErrorHelper.SendErrorEmail(new Exception("Speed limit error"), "Too many searches was carried out: <br />Aggregator: " + aggregatorSetting.UserName + "<br />Current Searches: " + GetCurrentSearchCount(aggregatorSetting) + "<br />Maximum Searches: " + aggregatorSetting.HotelConcurrentSearches, settings);
return(false);
}
}
return(true);
}
public static TransfersResponseV3 Search(TransfersRequestV3 request, AggregatorSetting aggregatorSetting)
{
var authSoapHd = new AuthSoapHd
{
strUserName = aggregatorSetting.PtsUserName,
strNetwork = aggregatorSetting.PtsNetwork,
strPassword = aggregatorSetting.PtsPassword,
strUserRef = "",
strCustomerIP = "" //HttpContext.Current == null ? String.Empty : (HttpContext.Current.Request.ServerVariables["HTTP_X_FORWARDED_FOR"] ?? HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"]).Split(',')[0].Trim()
};
var service = new AccommodationService {
Url = aggregatorSetting.PtsUrl, AuthSoapHdValue = authSoapHd, Timeout = aggregatorSetting.PtsTimeOut
};
var stopwatch = new Stopwatch();
stopwatch.Start();
TransfersResponseV3 response = service.GetTransfersV3(request);
stopwatch.Stop();
return(response);
}
/// <summary>
/// </summary>
/// <param name="request"></param>
/// <param name="aggregatorSetting"></param>
/// <param name="settings"></param>
/// <returns></returns>
private static AvailabilityRequest GetRequest(AccommodationSearchRequest request, AggregatorSetting aggregatorSetting, Settings settings)
{
var availabilityRequest = new AvailabilityRequest
{
HotelId = request.SuperIds == null ? null : string.Join(",", request.SuperIds),
H2H = GetH2H(request.CityCode, aggregatorSetting, settings),
FeatureCode = aggregatorSetting.PtsFeatureCode,
DetailLevel = 5,
CityCode = request.CityCode,
ConfirmationLevel = 0
};
TimeSpan ts = request.CheckOut - request.CheckIn;
availabilityRequest.Nites = (sbyte)ts.Days;
availabilityRequest.SvcDate = request.CheckIn;
availabilityRequest.NoOfAdults = (sbyte)request.NumberOfAdults;
availabilityRequest.NoOfChildren = (sbyte)(request.ChildAge == null ? 0 : request.ChildAge.Count + request.NumberOfInfants ?? 0);
if (request.ResortCode.HasValue && request.ResortCode.Value > 0)
{
availabilityRequest.Location = (int)request.ResortCode.Value;
}
var ages = new List <sbyte>();
if (request.ChildAge != null)
{
foreach (var i in request.ChildAge)
{
ages.Add((sbyte)i);
}
}
for (var i = 0; i < request.NumberOfInfants; i++)
{
ages.Add(1);
}
availabilityRequest.ChildAge = ages.ToArray();
availabilityRequest.Units = (sbyte)request.NumberOfRooms;
return(availabilityRequest);
}
public static SuperAvailabilityResponse Search(AccommodationSearchRequest request, Settings settings, AggregatorSetting aggregatorSetting, out int searchTime)
{
var availabilityRequest = GetRequest(request, aggregatorSetting, settings);
var authSoapHd = new AuthSoapHd
{
strUserName = aggregatorSetting.PtsUserName,
strNetwork = aggregatorSetting.PtsNetwork,
strPassword = aggregatorSetting.PtsPassword,
strUserRef = "",
strCustomerIP = "" //HttpContext.Current == null ? String.Empty : (HttpContext.Current.Request.ServerVariables["HTTP_X_FORWARDED_FOR"] ?? HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"]).Split(',')[0].Trim()
};
//"http://172.16.200.174/Tritonroomswsdev/AccommodationServicev2.svc";
var service = new AccommodationService {
Url = aggregatorSetting.PtsUrl, AuthSoapHdValue = authSoapHd, Timeout = aggregatorSetting.PtsTimeOut
};
var stopwatch = new Stopwatch();
stopwatch.Start();
SuperAvailabilityResponse response = service.GetSuperAvailability(availabilityRequest);
stopwatch.Stop();
searchTime = (int)stopwatch.ElapsedMilliseconds;
return(response);
}
public static AccommodationSearchResponse Process(Settings settings, SuperAvailabilityResponse superAvailabilityResponse, AggregatorSetting aggregatorSetting, string rooms)
{
if (superAvailabilityResponse == null)
{
return(new AccommodationSearchResponse
{
Message = new Message
{
Success = false,
Errors = new List <string> {
"There was no Search results returned due to an error"
}
},
Results = null,
SearchResultSetGuid = new Guid()
});
}
var returnHotels = new List <AccommodationSearchResponseHotel>();
var getTheIataFromCity = (settings.LookupSettings.CityAsIata.ContainsKey((int)superAvailabilityResponse.AvailabilityRequest.CityCode) ? settings.LookupSettings.CityAsIata[(int)superAvailabilityResponse.AvailabilityRequest.CityCode] : null) ?? "-1";
var destinationMarkup = (settings.LookupSettings.DestinationMarkup.ContainsKey(getTheIataFromCity) ? settings.LookupSettings.DestinationMarkup[getTheIataFromCity] : null) ?? settings.LookupSettings.DestinationMarkup["-1"];
var transfers = new Dictionary <int, decimal>();
// loop through each hotel
if (superAvailabilityResponse.SuperHotelAvailabilityDetail != null)
{
if (aggregatorSetting.UserName.ToLower() == "tripadvisor")
{
// loop through the hotels and see if there are any compulsory
foreach (var hotel in superAvailabilityResponse.SuperHotelAvailabilityDetail)
{
foreach (var room in hotel.Hotels)
{
if (room.TransferCompulsory && room.HotelLocationID.HasValue && !transfers.ContainsKey(room.HotelLocationID.Value))
{
transfers.Add(room.HotelLocationID.Value, -1);
}
}
}
TransferService.GetTransfers(transfers, superAvailabilityResponse, aggregatorSetting);
}
foreach (var hotel in superAvailabilityResponse.SuperHotelAvailabilityDetail)
{
int star;
if (!string.IsNullOrEmpty(hotel.SuperHotelCategory) && int.TryParse(hotel.SuperHotelCategory.Substring(0, 1), out star))
{
// do nothing
}
else
{
star = 0;
}
// convert the hotel ready
var returnHotel = ConvertService.Convert(hotel, star);
var hotelId = int.Parse(hotel.SuperHotelID);
var hotelMarkups = settings.LookupSettings.HotelMarkup.ContainsKey(hotelId) ? settings.LookupSettings.HotelMarkup[hotelId] : null;
// loop through each room
foreach (var room in hotel.Hotels)
{
// see if we need to find out transfers
// hotel markup rules
if (hotelMarkups != null)
{
if (hotelMarkups.IsPercentageMarkup)
{
room.Price += (room.Price / 100m) * hotelMarkups.Markup;
}
else
{
room.Price += hotelMarkups.Markup;
}
}
else
{
// now apply a destination markup
foreach (var markupDestination in destinationMarkup)
{
if (room.Price > markupDestination.MinPriceTakesEffect)
{
if (markupDestination.IsPercentageMarkup)
{
room.Price += (room.Price / 100m) * markupDestination.Markup;
}
else
{
room.Price += markupDestination.Markup;
}
break;
}
}
}
// apply transfers if needed
//if (room.HotelLocationID.HasValue && room.TransferCompulsory && transfers.ContainsKey(room.HotelLocationID.Value))
//{
// if (transfers[room.HotelLocationID.Value] == -1)
// continue;
// room.MarkupTotals.FixedTotal += transfers[room.HotelLocationID.Value];/}
// round the price off
room.Price = Math.Round(room.Price, 2);
// convert to the object to return
returnHotel.Rooms.Add(ConvertService.Convert(room, aggregatorSetting, hotel.SuperHotelID, rooms));
}
if (returnHotel.Rooms.Any())
{
returnHotels.Add(returnHotel);
}
}
}
var returnResult = new AccommodationSearchResponse
{
Message = new Message
{
Success = true
},
Results = returnHotels,
SearchResultSetGuid = superAvailabilityResponse.ResultID == null ? new Guid() : new Guid(superAvailabilityResponse.ResultID)
};
return(returnResult);
}
public static AccommodationSearchResponseHotelRoom Convert(SuperAvailabilityResponseSuperHotelAvailabilityDetailHotels room, AggregatorSetting aggregatorSetting, string superId, string rooms)
{
// does not like the &
// ReSharper disable StringLiteralsWordIsNotInDictionary
//var url =
// String.Concat("http://www.travelbag.co.uk/Waiting/DisplayAccomResults?",
// "country=", criteria.AccomCountryCode,
// "&city=", criteria.AccomCityCode,
// "&location=", room.HotelLocationID,
// "&startdate=", criteria.HolidayStartDate.ToString("yyyyMMdd"),
// "&enddate=", endDate.ToString("yyyyMMdd"),
// "&rooms=", rooms,
// "&starrating=-1&boardbasis=-1",
// "&ptsid=", superId,
// "&pid=", aggregatorSetting.UserName.ToLower());
// ReSharper restore StringLiteralsWordIsNotInDictionary
var url = "http://www.holidaygems.co.uk";
var returnValue = new AccommodationSearchResponseHotelRoom
{
BoardType = room.Room_Board_Type,
Price = room.Price,
DeepLink = url,
RoomTitle = room.Room_Title,
HotelIdDetails = room.HotelID
};
return(returnValue);
}
public TransferSearch(TransfersRequestV3 request, AggregatorSetting aggregatorSetting)
{
Request = request;
AggregatorSetting = aggregatorSetting;
}
public static void GetTransfers(Dictionary <int, decimal> transfers, SuperAvailabilityResponse superAvailabilityResponse, AggregatorSetting aggregatorSetting)
{
var threads = new List <ThreadWorking>();
foreach (var transfer in transfers)
{
var transfersRequestV3 = new TransfersRequestV3
{
ClientType = 0,
ConfirmationLevel = 0,
ChildAge = superAvailabilityResponse.AvailabilityRequest.ChildAge,
NoOfAdults = superAvailabilityResponse.AvailabilityRequest.NoOfAdults,
NoOfChildren = superAvailabilityResponse.AvailabilityRequest.NoOfChildren,
SvcDateFrom = superAvailabilityResponse.AvailabilityRequest.SvcDate,
SvcDateTo = superAvailabilityResponse.AvailabilityRequest.SvcDate.AddDays(superAvailabilityResponse.AvailabilityRequest.Nites),
LocationID = transfer.Key
};
var thread = new ThreadWorking
{
TransferSearch = new TransferSearch(transfersRequestV3, aggregatorSetting)
};
thread.Thread = new Thread(thread.TransferSearch.Search);
thread.Thread.Start();
threads.Add(thread);
}
// join up all the threads
foreach (var threadWorking in threads)
{
threadWorking.Thread.Join();
transfers[threadWorking.TransferSearch.Request.LocationID] = threadWorking.TransferSearch.CheapestTransferPrice;
}
}
public static int GetCurrentSearchCount(AggregatorSetting aggregatorSetting)
{
return(aggregatorSetting.CurrentSearches);
}