// GET api/<controller>/5
public HotelPropertyAj Get(string searchid, string hcode, string CurrencyCode)
{
HotelPropertyAj hpr = null;
string filePathRQ = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelXML/" + searchid + "_propertydesc_" + hcode + "_" + CurrencyCode + "-RS.xml");
if (File.Exists(filePathRQ))
{
string result = File.ReadAllText(filePathRQ);
hpr = new HotelPropertyAj(result, hcode, searchid, CurrencyCode, "");
}
return(hpr);
}
public int SaveRoom(HotelPropertyAj hpr, string srph, string searchid, string viewid, string itinid, string firstname, string lastname, string email, string phone)
{
int rvalue = 0;
#region collectinginfosaving
try
{
DataTable dt = hpr.dtBasicPropInfo;
DataTable dtpricing = hpr.dtHotelPricing;
DataTable dtRateRange = hpr.HP_RateRange;
string rphcond = "";
rphcond = srph;
if (srph.Length == 1)
{
rphcond = "00" + srph;
}
if (srph.Length == 2)
{
rphcond = "0" + srph;
}
DataRow[] roomdescrow = hpr.dtRoomInfo.Select("RPH='" + rphcond + "'");
DataRow[] roomRaterow = hpr.dtRoomRate.Select("RPH='" + rphcond + "'");
DataRow[] hotelpricingrow = hpr.dtHotelPricing.Select("RoomRateID='" + roomRaterow[0]["RoomRateID"].ToString() + "'");
DataRow[] hpraterangerow = hpr.HP_RateRange.Select("HotelPricingID='" + hotelpricingrow[0]["HotelPricingID"].ToString() + "'");
DataRow[] propaddress = hpr.dtAddressLines.Select("BasicPropInfo_ID='" + dt.Rows[0]["BasicPropInfo_ID"].ToString() + "'");
DataRow[] raterow = hpr.dtRate.Select("RoomRateID='" + roomRaterow[0]["RoomRateID"].ToString() + "'");
////property details starts -----------------
string PropertyName = dt.Rows[0]["HotelName"].ToString();
string PropertyCode = dt.Rows[0]["HotelCode"].ToString();
string PropertyCityCode = dt.Rows[0]["HotelCityCode"].ToString();
string ChainCode = dt.Rows[0]["ChainCode"].ToString();
string ChainName = "";
string GDSId = "SB";
string CheckinTime = dt.Rows[0]["CheckInTime"].ToString();
string CheckOutTime = dt.Rows[0]["CheckOutTime"].ToString();
string AddressLine1 = propaddress[0]["Address"].ToString();
string AddressLine2 = propaddress[1]["Address"].ToString();
string Phone = dt.Rows[0]["Phone"].ToString();
string Fax = dt.Rows[0]["Fax"].ToString();
string City = "";
string State = "";
string CountryCode = dt.Rows[0]["CountryCode"].ToString();;
string PostalCode = "";
string Latitude = dt.Rows[0]["Latitude"].ToString();
string Longitude = dt.Rows[0]["Longitude"].ToString();
string Distance = "";
string DistanceUnit = "";
string StarRating = "";
string ReviewRating = "";
////property details ends -----------------
////Rate details starts ---------------------
string BookingStatus = "";
string BookingConfirmation = "";
string NumAdults = "";
string NumChildren = "";
string Amount = roomdescrow[0]["Rate"].ToString();
string TotalAmount = hotelpricingrow[0]["HPTotalAmount"].ToString();
string TotalBaseAmount = "0";
string TotalTaxAmount = hotelpricingrow[0]["TTaxes_Amount"].ToString();
string TotalSurgeAmount = hotelpricingrow[0]["TSurcharges_Amount"].ToString();
string taxpercent = dt.Rows[0]["TaxshortText"].ToString();
string MarkupAmount = "";
string DiscountAmount = "";
string NumExtraAdults = raterow[0]["AddGuestAmt_NumAdults"].ToString();
string NumExtraChildren = raterow[0]["AddGuestAmt_NumChild"].ToString();
string NumExtraCribs = raterow[0]["AddGuestAmt_NumCribs"].ToString();
string NumExtraPersonAllowed = raterow[0]["AddGuestAmt_Max"].ToString();
string ExtraPersonAmount = raterow[0]["AGA_Charges_ExPer"].ToString();
string ExtraCribAmount = raterow[0]["AGA_Charges_Crib"].ToString();
string ChildRollawayAmount = raterow[0]["AGA_Charges_ChildRollAway"].ToString();
string AdultRollAwayAmount = raterow[0]["AGA_Charges_AdultRollAway"].ToString();
string CurrencyCode = roomRaterow[0]["CurrencyCode"].ToString();
string IsSpecialOffer = roomRaterow[0]["SpecialOffer"].ToString();
string IsRateConversion = roomRaterow[0]["RateConversionInd"].ToString();
string IsRateChanges = roomRaterow[0]["RateChangeInd"].ToString();
string RateLevelCode = roomRaterow[0]["RateLevelCode"].ToString();
string ReturnOfRate = roomRaterow[0]["ReturnOfRateInd"].ToString();
string RateCategory = roomRaterow[0]["RateCategory"].ToString();
string RateAccessCode = roomRaterow[0]["RateCategory"].ToString();
string LowInvThreshold = roomRaterow[0]["LowInvThreshold"].ToString();
string ProductIdentif = roomRaterow[0]["IATA_ProdIdent"].ToString();
string Identif = roomRaterow[0]["IATA_ChaIdent"].ToString();
string GTSurgeRequired = roomRaterow[0]["GuaSurchrgReq"].ToString();
string GTRateProgram = roomRaterow[0]["DirectConnect"].ToString();
string DirectConnect = roomRaterow[0]["GuaRateProg"].ToString();
string AdvResPeriod = roomRaterow[0]["AdvResPeriod"].ToString();
string ClientID = roomRaterow[0]["ClientID"].ToString();
string XPM_GTRequired = roomRaterow[0]["XPM_GuaReq"].ToString();
string RoomLocCode = roomRaterow[0]["RoomLocationCode"].ToString();
string RoomTypeCode = raterow[0]["RoomTypeCode"].ToString();
string IsRateConverted = raterow[0]["RateConvIndicator"].ToString();
string IsPackage = raterow[0]["PkgIndicator"].ToString();
string HRDForSell = raterow[0]["HRD_ReqforSell"].ToString();
string CPVal = "";
string CPText = "";
string CommissionAvl = "";
string RateCode = "";
string RuleIdn = "";
string roomdesc = "";
//// rate details ends ------------------------------
//// for rate range starts
string BaseAmount = "0";
string TaxAmount = "0";
string SurchargeAmount = "0";
string ExpireDt = "0";
string EffectiveDt = "0";
//// for rate range starts ends
try
{
roomdesc = roomdescrow[0]["RoomTypedesc"].ToString();
}
catch
{
roomdesc = "";
}
try
{
BookingId = HotelDBLayer.SaveBooking(searchid, viewid, "", firstname, lastname, email, phone);
Propertyid = HotelDBLayer.SaveBookingProperty(BookingId, PropertyName, PropertyCode, PropertyCityCode, ChainCode, ChainName, GDSId, CheckinTime, CheckOutTime, AddressLine1, AddressLine2, Phone, Fax, City, State, PropertyCityCode, CountryCode, PostalCode, Latitude, Longitude, Distance, DistanceUnit, StarRating, ReviewRating);
RateID = HotelDBLayer.SaveBookingRate(BookingId, BookingStatus, BookingConfirmation, NumAdults, NumChildren, Amount, TotalAmount, TotalBaseAmount, TotalTaxAmount, TotalSurgeAmount, MarkupAmount, DiscountAmount, NumExtraAdults, NumExtraChildren, NumExtraCribs, NumExtraPersonAllowed, ExtraPersonAmount, ExtraCribAmount, ChildRollawayAmount, AdultRollAwayAmount, CurrencyCode, IsSpecialOffer, IsRateConversion, IsRateChanges, RateLevelCode, ReturnOfRate, RateCategory, RateAccessCode, LowInvThreshold, ProductIdentif, Identif, GTSurgeRequired, GTRateProgram, DirectConnect, AdvResPeriod, ClientID, XPM_GTRequired, RoomLocCode, RoomTypeCode, IsRateConverted, IsPackage, HRDForSell, CPVal, CPText, CommissionAvl, RateCode, RuleIdn, roomdesc, srph);
foreach (DataRow drrr in hpraterangerow)
{
BaseAmount = drrr["Amount"].ToString();
TaxAmount = drrr["Taxes"].ToString();;
SurchargeAmount = drrr["Surcharges"].ToString();;
ExpireDt = drrr["ExpireDate"].ToString();;
EffectiveDt = drrr["EffectiveDate"].ToString();
RaterangeID = HotelDBLayer.SaveBookingRateRange(BookingId, RateID, BaseAmount, TaxAmount, SurchargeAmount, ExpireDt, EffectiveDt);
}
rvalue = 1;
}
catch (Exception ex)
{
throw ex;
}
}
catch (Exception ex)
{
throw ex;
}
#endregion
return(rvalue);
}
