public string Get(string city, string checkind, string checkoutd, string guestscount, string selroom, string seladults, string adultbyroom, string selchilds, string childrenbyroom, string childages, string curcode, string b2c_idn)
{
string ipaddress = "";
string searchid = "";
string cust_idn = string.Empty;
if (Request.Properties.ContainsKey("MS_HttpContext"))
{
var ctx = Request.Properties["MS_HttpContext"] as HttpContextWrapper;
if (ctx != null)
{
var ip = ctx.Request.UserHostAddress;
//do stuff with IP
}
}
searchid = HotelDBLayer.SaveSearch(city, checkind, checkoutd, Convert.ToInt16(selroom), Convert.ToInt16(seladults), adultbyroom, Convert.ToInt16(selchilds), childrenbyroom, childages, ipaddress, curcode, b2c_idn, cust_idn);
HACondition Hac = Utilities.GetSearchConditon(city, checkind, checkoutd, guestscount.ToString(), Convert.ToInt32(selroom), Convert.ToInt32(seladults), adultbyroom, Convert.ToInt32(selchilds), childrenbyroom, childages, curcode);
HotelSearchAj hs = new HotelSearchAj(Hac, searchid, b2c_idn);
DataTable dtHList = hs.dtBPIadd;
DataSet ds = new DataSet();
ds.Tables.Add(dtHList);
string HLFPath = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelXML/" + searchid + "_" + curcode + "6140_USD_hotelsAvail-RS.xml");
ds.WriteXml(HLFPath);
string rvalue = searchid;
return(rvalue);
}
private HACondition GetSearchConditon(string city, string checkin, string checkout, string guestcount, int rooms, int adults, string adultsbyroom, int children, string childbyroom, string childrenages, string currencycode)
{
try
{
HACondition Hac = new HACondition();
if (city != "")
{
if (city.IndexOf('-') > 0)
{
Hac.City = city.Split('-')[0];
Hac.CityType = "CC";
}
else
{
DataTable dtll = HotelDBLayer.GetLatLong(city);
string[] cityparts = city.Split(',');
string CityP = cityparts[0];
//string State = cityparts[1];
string Country = cityparts[1];
Hac.CityName = CityP;
Hac.fullCity = city;
Hac.Latitude = dtll.Rows[0]["Latitude"].ToString();
Hac.Longitude = dtll.Rows[0]["Longitude"].ToString();
if (dtll.Rows[0]["CityCode"] == null || dtll.Rows[0]["CityCode"].ToString().Trim() == "" && CityP == "" || CityP == null)
{
Hac.CityType = "LL";
}
else
{
Hac.CityType = "CN";
}
}
}
Hac.fullCity = city.ToString();
Hac.GuestCount = (adults + children).ToString();
if (!string.IsNullOrEmpty(checkin))
{
Hac.CheckIn = Convert.ToDateTime(checkin).ToString("yyyy-MM-dd");
}
if (!string.IsNullOrEmpty(checkout))
{
Hac.CheckOut = Convert.ToDateTime(checkout).ToString("yyyy-MM-dd");
}
Hac.Rooms = rooms;
Hac.Adults = adults;
Hac.Adultsbyroom = adultsbyroom;
Hac.Children = children;
Hac.Childrenbyroom = childbyroom;
Hac.SortBy = "low_price";
Hac.CurrencyCode = currencycode;
Hac.childrenage = childrenages;
return(Hac);
}
catch (Exception ex)
{
throw ex;
}
}
public string Get(string ipaddress, string Name, string Email, string Phone, string Company, string Message, string b2c_idn)
{
string rvalue = "N";
rvalue = HotelDBLayer.SaveContactUs(ipaddress, Name, Email, Phone, Company, Message);
return(rvalue);
}
public string Get(string ipaddress, string FirstName, string LastName, string Email, string Phone, string Password, string b2c_idn, string b2b_idn)
{
string rvalue = "N";
rvalue = HotelDBLayer.SaveSignUp(ipaddress, FirstName, LastName, Email, Phone, Password, b2c_idn, b2b_idn);
return(rvalue);
}
public HotelImageJson Get(string searchid, string HotelCode, string curcode)
{
string rvalue = "";
string ContextResult = "";
DataTable dtHotelUrl = HotelDBLayer.GetHotelImageUrl(HotelCode);
if (dtHotelUrl.Rows.Count > 0)
{
hij.Image = dtHotelUrl.Rows[0]["ImageUrl"].ToString();
hij.Logo = dtHotelUrl.Rows[0]["Logourl"].ToString();
return(hij);
}
else
{
string filePathContext = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelXML/" + searchid + "_" + curcode + "_ContextChange-RS.xml");
if (File.Exists(filePathContext))
{
ContextResult = File.ReadAllText(filePathContext);
}
else
{
ContextResult = XMLRead.ContextChange(searchid);
}
HotelImageAj hotelimage = new HotelImageAj(HotelCode, "", searchid, ContextResult);
string image = hotelimage.Image;
string logo = hotelimage.logo;
HotelDBLayer.SaveHotelImageUrl(HotelCode, image, logo);
hij.Image = image;
hij.Logo = logo;
return(hij);
}
}
public string Get(string Email, string Password, string b2c_idn, string b2b_idn)
{
string rvalue = "N";
rvalue = HotelDBLayer.Logincheck(Email, Password, b2c_idn, b2b_idn);
return(rvalue);
}
public HPDCondition GetCondition(string searchid, string hotelcode, string CurrencyCode)
{
HPDCondition Hapc = new HPDCondition();
DataTable dssearch = HotelDBLayer.GetSearch(searchid);
int guestcount = Convert.ToInt16(dssearch.Rows[0]["Adults"].ToString()) + Convert.ToInt16(dssearch.Rows[0]["Children"].ToString());
try { Hapc.HotelCode = hotelcode; }
catch { Hapc.HotelCode = ""; }
try { Hapc.rooms = Convert.ToInt32(dssearch.Rows[0]["Rooms"]).ToString(); }
catch { Hapc.checkin = ""; }
try { Hapc.checkin = Convert.ToDateTime(dssearch.Rows[0]["CheckInDt"]).ToString("yyyy-MM-dd"); }
catch { Hapc.checkin = ""; }
try { Hapc.checkout = Convert.ToDateTime(dssearch.Rows[0]["CheckOutDt"]).ToString("yyyy-MM-dd"); }
catch { Hapc.checkout = ""; }
try { Hapc.guestcount = guestcount.ToString(); }
catch { Hapc.guestcount = ""; }
try { Hapc.Adult = dssearch.Rows[0]["Adults"].ToString(); }
catch { }
try { Hapc.children = Convert.ToInt32(dssearch.Rows[0]["Children"].ToString()); }
catch { }
try { Hapc.childrenage = dssearch.Rows[0]["HB_ChildAge"].ToString(); }
catch { }
if (CurrencyCode == "")
{
Hapc.CurrencyCode = "USD";
}
else
{
Hapc.CurrencyCode = CurrencyCode;
}
return(Hapc);
}
private void FillFaiconDictionary()
{
Dtfaicons = HotelDBLayer.GetFaicons();
foreach (DataRow dr in Dtfaicons.Rows)
{
faicons.Add(dr["FaviconDesc"].ToString(), dr["ImageIcon"].ToString());
}
}
public AvailabilityRS GetDataChangedate(string SearchID, string hotelcode, string rooms, string checkin, string checkout, string adult, string children, string childrenage, string gc, string CurrencyCode, string b2c_idn)
{
//HotelPropertyAj hpr = null;
AvailabilityRS objAvailabilityRS = new AvailabilityRS();
//string filePathContext = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelXML/" + SearchID + "_ContextChange-RS.xml");
//if (File.Exists(filePathContext))
//{
// ContextResult = File.ReadAllText(filePathContext);
//}
//else
//{
// ContextResult = XMLRead.ContextChange(searchid);
//}
try
{
searchid = SearchID;
objfavicons = new ClsFevicons();
CultureInfo cultureInfo = Thread.CurrentThread.CurrentCulture;
TextInfo = cultureInfo.TextInfo;
//string filePathRQ = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelXML/" + searchid + "_propertydesc_" + hotelcode + "_" + CurrencyCode + "-RS.xml");
string filePathRQ = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelXML/" + searchid + "_propertydesc_" + hotelcode + "_" + CurrencyCode + "_hotelsAvail-RS.xml");
XmlDataDocument xmldoc = new XmlDataDocument();
if (File.Exists(filePathRQ))
{
FileStream fs = new FileStream(filePathRQ, FileMode.Open, FileAccess.Read);
xmldoc.Load(fs);
fs.Close();
XmlNode xnod = xmldoc.DocumentElement;
XmlSerializer deserializer = new XmlSerializer(typeof(AvailabilityRS));
StreamReader reader = new StreamReader(filePathRQ);
objAvailabilityRS = (AvailabilityRS)deserializer.Deserialize(reader);
}
else
{
DataTable dssearch = HotelDBLayer.GetSearch(searchid);
HPDCondition Hapc = GetCondition(searchid, hotelcode, CurrencyCode);
result = gethdata(Hapc, ContextResult, searchid, CurrencyCode, b2c_idn);
filePathRQ = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelXML/" + searchid + "_propertydesc_" + hotelcode + "_" + CurrencyCode + "_hotelsAvail-RS.xml");
FileStream fs = new FileStream(filePathRQ, FileMode.Open, FileAccess.Read);
xmldoc.Load(fs);
fs.Close();
XmlNode xnod = xmldoc.DocumentElement;
XmlSerializer deserializer = new XmlSerializer(typeof(AvailabilityRS));
StreamReader reader = new StreamReader(filePathRQ);
objAvailabilityRS = (AvailabilityRS)deserializer.Deserialize(reader);
if (!File.Exists(filePathRQ))
{
File.WriteAllText(filePathRQ, objAvailabilityRS.Xmlns);
}
}
}
catch { }
return(objAvailabilityRS);
}
//
// GET: /HotelFilters/
public string GetHFilters(string searchid)
{
string rvalue = "";
DataTable dssearch = HotelDBLayer.GetSearch(searchid);
string HLFPath = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelXML/" + searchid + "_HotelData.xml");
DataSet ds = new DataSet();
ds.ReadXml(HLFPath);
DataTable Hotellist = ds.Tables[0];
return(rvalue);
}
public static string GetDataroom(string SearchID, string hotelcode, string CurrencyCode, string b2c_idn)
{
string filePathRQ = string.Empty;
AvailabilityRS objAvailabilityRS = new AvailabilityRS();
ManageHDetAj objManageHDetAj = new ManageHDetAj();
string result = string.Empty;
try
{
string searchid = SearchID;
ClsFevicons objfavicons;
objfavicons = new ClsFevicons();
CultureInfo cultureInfo = Thread.CurrentThread.CurrentCulture;
// TextInfo = cultureInfo.TextInfo;
//string filePathRQ = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelXML/" + searchid + "_propertydesc_" + hotelcode + "_" + CurrencyCode + "-RS.xml");
filePathRQ = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelXML/" + searchid + "_" + CurrencyCode + "_hotelsAvail-RS.xml");
XmlDataDocument xmldoc = new XmlDataDocument();
if (File.Exists(filePathRQ))
{
FileStream fs = new FileStream(filePathRQ, FileMode.Open, FileAccess.Read);
xmldoc.Load(fs);
fs.Close();
XmlNode xnod = xmldoc.DocumentElement;
XmlSerializer deserializer = new XmlSerializer(typeof(AvailabilityRS));
StreamReader reader = new StreamReader(filePathRQ);
result = File.ReadAllText(filePathRQ);
objAvailabilityRS = (AvailabilityRS)deserializer.Deserialize(reader);
}
else
{
DataTable dssearch = HotelDBLayer.GetSearch(searchid);
HPDCondition Hapc = objManageHDetAj.GetCondition(searchid, hotelcode, CurrencyCode);
result = objManageHDetAj.gethdata(Hapc, ContextResult, searchid, CurrencyCode, b2c_idn);
filePathRQ = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelXML/" + searchid + "_propertydesc_" + hotelcode + "_" + CurrencyCode + "_hotelsAvail-RS.xml");
FileStream fs = new FileStream(filePathRQ, FileMode.Open, FileAccess.Read);
xmldoc.Load(fs);
fs.Close();
XmlNode xnod = xmldoc.DocumentElement;
XmlSerializer deserializer = new XmlSerializer(typeof(AvailabilityRS));
StreamReader reader = new StreamReader(filePathRQ);
objAvailabilityRS = (AvailabilityRS)deserializer.Deserialize(reader);
result = File.ReadAllText(filePathRQ);
if (!File.Exists(filePathRQ))
{
File.WriteAllText(filePathRQ, objAvailabilityRS.Xmlns);
}
}
}
catch { }
return(result);
}
public static HACondition GetSearchConditon(string city, string checkin, string checkout, string guestcount, int rooms, int adults, string adultbyroom, int children, string childrenbyroom, string childages, string currencycode)
{
try
{
HACondition Hac = new HACondition();
if (city != "")
{
if (city.IndexOf('-') > 0)
{
Hac.City = city.Split('-')[0];
Hac.CityType = "CC";
}
else
{
DataTable dtll = HotelDBLayer.GetLatLong(city);
string[] cityparts = city.Split(',');
string CityP = cityparts[0];
//string State = cityparts[1];
string Country = cityparts[1];
Hac.CityName = CityP;
Hac.fullCity = city;
// Hac.City = city.Split(',')[0];
Hac.CityType = "CN";
}
}
Hac.fullCity = city.ToString();
Hac.GuestCount = (adults + children).ToString();
if (checkin != "")
{
Hac.CheckIn = Convert.ToDateTime(checkin).ToString("yyyy-MM-dd");
}
if (checkout != "")
{
Hac.CheckOut = Convert.ToDateTime(checkout).ToString("yyyy-MM-dd");
}
Hac.Rooms = rooms;
Hac.Adults = adults;
Hac.Adultsbyroom = adultbyroom;
Hac.Children = children;
Hac.Childrenbyroom = childrenbyroom;
Hac.childrenage = childages;
Hac.SortBy = "low_price";
Hac.CurrencyCode = currencycode;
return(Hac);
}
catch (Exception ex)
{
throw ex;
}
}
public HotelEndTrans(string resultxml, string bookingid, string filePathRQ)
{
BookingRS objBookingRS = new BookingRS();
string HBReference = string.Empty;
string status = string.Empty;
string vatnumber = string.Empty;
string Reservationum = string.Empty;
string Recordlocator = string.Empty;
string cancellationfrom = string.Empty;
string cancellationamount = string.Empty;
string ratecommentsdt = string.Empty;
string Sup_Name = string.Empty;
if (File.Exists(filePathRQ))
{
XmlDataDocument xmldoc = new XmlDataDocument();
FileStream fs = new FileStream(filePathRQ, FileMode.Open, FileAccess.Read);
xmldoc.Load(fs);
fs.Close();
XmlNode xnod = xmldoc.DocumentElement;
//HotelListGenerate.CreateTables(dtBPIadd);
//HotelListGenerate.FillHStable(xnod, dtBPIadd);
XmlSerializer deserializer = new XmlSerializer(typeof(BookingRS));
StreamReader reader = new StreamReader(filePathRQ);
objBookingRS = (BookingRS)deserializer.Deserialize(reader);
HBReference = objBookingRS.Booking.Reference;
status = objBookingRS.Booking.Hotel.Rooms.Room.Select(k => k.Status).FirstOrDefault();
vatnumber = objBookingRS.Booking.Hotel.Supplier.VatNumber;
Reservationum = objBookingRS.Booking.InvoiceCompany.RegistrationNumber.ToString();
cancellationfrom = objBookingRS.Booking.Hotel.Rooms.Room[0].Rates.Rate.CancellationPolicies.CancellationPolicy.From;
cancellationamount = objBookingRS.Booking.Hotel.Rooms.Room[0].Rates.Rate.CancellationPolicies.CancellationPolicy.Amount;
ratecommentsdt = objBookingRS.Booking.Hotel.Rooms.Room[0].Rates.Rate.RateComments;
Sup_Name = objBookingRS.Booking.Hotel.Supplier.Name.ToString();
HotelDBLayer.UpdateHBbookingRef(bookingid, HBReference, status, vatnumber, Reservationum, cancellationfrom, cancellationamount, ratecommentsdt, Sup_Name);
}
else
{
}
AddXMLxEndTransRs(HBReference, status);
//XmlNode xnod = xmldoc.DocumentElement;
//XmlNode xheader = xnod.ChildNodes[0];
//XmlNode xbody = xnod.ChildNodes[1];
//XmlNode xEndTransRs = xbody.ChildNodes[0];
//XmlNode xAppResult = xEndTransRs.ChildNodes[0];
//string appresult = Utilities.GetValue(xAppResult.Attributes["status"]);
}
public string Get(string searchid, string curcode, string b2c_idn)
{
string rvalue = "N";
try
{
string checkind = "";
string checkoutd = "";
string selroom = "";
string seladults = "";
string selchildren = "";
string seladultsbyroom = "";
string selchildrenbyroom = "";
string city = "";
int guestcount = 1;
string childrenages = "";
DataTable dssearch = HotelDBLayer.GetSearch(searchid);
city = dssearch.Rows[0]["Destination"].ToString();
checkind = Convert.ToDateTime(dssearch.Rows[0]["CheckInDt"]).ToString("yyyy-MM-dd");
checkoutd = Convert.ToDateTime(dssearch.Rows[0]["CheckOutDt"]).ToString("yyyy-MM-dd");
selroom = dssearch.Rows[0]["Rooms"].ToString();
seladults = dssearch.Rows[0]["Adults"].ToString();
seladultsbyroom = dssearch.Rows[0]["HB_AdultsByRoom"].ToString();
selchildren = dssearch.Rows[0]["Children"].ToString();
selchildrenbyroom = dssearch.Rows[0]["HB_ChildrenByRoom"].ToString();
guestcount = Convert.ToInt16(dssearch.Rows[0]["Adults"].ToString()) + Convert.ToInt16(dssearch.Rows[0]["Children"].ToString());
childrenages = dssearch.Rows[0]["HB_ChildAge"].ToString();
HACondition Hac = GetSearchConditon(city, checkind, checkoutd, guestcount.ToString(), Convert.ToInt32(selroom), Convert.ToInt32(seladults), seladultsbyroom, Convert.ToInt32(selchildren), selchildrenbyroom, childrenages, curcode.Trim());
HotelSearchAj hs = new HotelSearchAj(Hac, searchid, b2c_idn);
DataTable dtHList = hs.dtBPIadd;
DataSet ds = new DataSet();
ds.Tables.Add(dtHList);
// string HLFPath = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelAvail/" + searchid + "_" + curcode + "_HotelList.xml");//yogi
//string HLFPath = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelXML/" + searchid + "_" + curcode + "_hotelsAvail-RS");
//ds.WriteXml(HLFPath);
rvalue = "Y";
}
catch (Exception ex)
{
rvalue = "N";
}
return(rvalue);
}
private HPDCondition GetCondition(string hotelcode)
{
HPDCondition Hapc = new HPDCondition();
DataTable dssearch = HotelDBLayer.GetSearch(searchid);
int guestcount = Convert.ToInt16(dssearch.Rows[0]["Adults"].ToString()) + Convert.ToInt16(dssearch.Rows[0]["Children"].ToString());
try { Hapc.HotelCode = hotelcode; }
catch { Hapc.HotelCode = ""; }
try { Hapc.checkin = Convert.ToDateTime(dssearch.Rows[0]["CheckInDt"]).ToString("MM-dd"); }
catch { Hapc.checkin = ""; }
try { Hapc.checkout = Convert.ToDateTime(dssearch.Rows[0]["CheckOutDt"]).ToString("MM-dd"); }
catch { Hapc.checkout = ""; }
try { Hapc.guestcount = guestcount.ToString(); }
catch { Hapc.guestcount = ""; }
return(Hapc);
}
//public HotelProperty GetData(string SearchID,string contextresult,string hotelcode )
public HotelProperty GetData(string SearchID, string hotelcode)
{
HotelProperty hpr = null;
string filePathContext = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelXML/" + SearchID + "_ContextChange-RS.xml");
if (File.Exists(filePathContext))
{
ContextResult = File.ReadAllText(filePathContext);
}
else
{
ContextResult = XMLRead.ContextChange(SearchID);
}
try
{
searchid = SearchID;
objfavicons = new ClsFevicons();
CultureInfo cultureInfo = Thread.CurrentThread.CurrentCulture;
TextInfo = cultureInfo.TextInfo;
// string filePathRQ = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelProperty/" + searchid + "_" + hotelcode + "_PropertyData.xml");
string filePathRQ = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelXML/" + searchid + "_propertydesc_" + hotelcode + "-RS.xml");
if (File.Exists(filePathRQ))
{
string result = File.ReadAllText(filePathRQ);
hpr = new HotelProperty(result, hotelcode, searchid);
}
else
{
DataTable dssearch = HotelDBLayer.GetSearch(searchid);
HPDCondition Hapc = GetCondition(hotelcode);
hpr = new HotelProperty(Hapc, ContextResult, searchid);
if (!File.Exists(filePathRQ))
{
File.WriteAllText(filePathRQ, hpr.PropertyXmlResult);
}
}
}
catch { }
return(hpr);
}
private HPDCondition GetCondition(string hotelcode, string CurrencyCode, string BookinID)
{
HPDCondition Hapc = new HPDCondition();
DataTable dssearch = HotelDBLayer.GetSearchFromBookingID(BookinID);
int guestcount = Convert.ToInt16(dssearch.Rows[0]["Adults"].ToString()) + Convert.ToInt16(dssearch.Rows[0]["Children"].ToString());
try { Hapc.HotelCode = hotelcode; }
catch { Hapc.HotelCode = ""; }
try { Hapc.checkin = Convert.ToDateTime(dssearch.Rows[0]["CheckInDt"]).ToString("MM-dd"); }
catch { Hapc.checkin = ""; }
try { Hapc.checkout = Convert.ToDateTime(dssearch.Rows[0]["CheckOutDt"]).ToString("MM-dd"); }
catch { Hapc.checkout = ""; }
try { Hapc.guestcount = guestcount.ToString(); }
catch { Hapc.guestcount = ""; }
if (CurrencyCode == "")
{
Hapc.CurrencyCode = "USD";
}
else
{
Hapc.CurrencyCode = CurrencyCode;
}
return(Hapc);
}
private string GetRateTable(string RPH, CheckRateRS hpr, List <Rate> lstRate, string hcode, string searchid, string curcode, double admarkup, double clmarkup, double addiscount, double cldiscount, double roomtaxprice, string b2c_idn, int norooms)// DataRow dr,
{
string rvalue = "";
List <Rooms> lstRooms = new List <Rooms>();
Room objRoom = new Room();
double rrate = 0.00;
double adroommarkup = 0.00;
double roombaseamount = 0.00;
double roomamountwithouttax = 0.00;
double adroompercmarkup = 0.00;
double clroompercmarkup = 0.00;
double adroomperdiscount = 0.00;
double clroomperdiscount = 0.00;
double clroommarkup = 0.00;
double finalroommarkup = 0.00;
double finalroomdiscount = 0.00;
double adroomdiscount = 0.00;
double clroomdiscount = 0.00;
DataTable dts = HotelDBLayer.GetSearch(searchid);
DateTime checkindt = Convert.ToDateTime(hpr.Hotel.CheckIn);
DateTime checkoutdt = Convert.ToDateTime(hpr.Hotel.CheckOut);
norooms = Convert.ToInt32(dts.Rows[0]["Rooms"].ToString());
double dc = 0.0;
try
{ dc = (Convert.ToDateTime(checkoutdt.ToString()) - Convert.ToDateTime(checkindt.ToString())).TotalDays; }
catch { }
DateTime startweekdate = checkindt.AddDays(-(int)checkindt.DayOfWeek);
DateTime endweekdate = checkoutdt.AddDays(-(int)checkoutdt.DayOfWeek).AddDays(6);
double noofdays = (endweekdate - startweekdate).TotalDays;
decimal noofweeks = Decimal.Ceiling(Convert.ToDecimal(noofdays) / 7);
string strtable = "<table width='100%' border='0' cellspacing='0' cellpadding='0' class='week-table-main'>";
strtable += "<tbody><tr><td>";
strtable += "<table width='100%' border='0' cellspacing='0' cellpadding='0' class='week-days'>";
strtable += "<tbody><tr><td> </td><td>Sun</td><td>mon</td><td>tue</td><td>wed</td><td>thu</td><td>fri</td> <td>sat</td> </tr></tbody></table>";
strtable += "</td></tr><tr><td> <table width='100%' border='0' cellspacing='0' cellpadding='0' class='price-details'><tbody>";
DataRow[] hpraterangerow = null;
try
{
// hpraterangerow = hpr.HP_RateRange.Select("HotelPricingID='" + hotelpricingrow[0]["HotelPricingID"].ToString() + "'");
}
catch
{
}
DataTable dtr = new DataTable();
dtr.Columns.Add("id");
dtr.Columns.Add("amount");
dtr.Columns.Add("taxes");
dtr.Columns.Add("surcharges");
dtr.Columns.Add("expdate", typeof(DateTime));
dtr.Columns.Add("effedate", typeof(DateTime));
dtr.Columns.Add("hid");
int r = 1;
foreach (var rate in lstRate)
{
double troomspricepernightwithmarkup = 0.00;
// eachroomsprice = Convert.ToDouble(troomsprice / norooms);
rrate = Convert.ToDouble(Convert.ToDouble(Convert.ToDouble(lstRate[r - 1].Net) / dc).ToString("0.00"));
string avgpnignt = Convert.ToDouble(rrate).ToString();
//string avgroompernight = (Convert.ToDouble(avgpnignt) / dc).ToString("0.00");
roombaseamount = Convert.ToDouble(avgpnignt);
DataTable dtwt = new DataTable();
SqlConnection sqlconwt = new SqlConnection(con);
try
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = sqlconwt;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "p_SreTS_HDR";
cmd.Parameters.AddWithValue("@B2C_IDN", b2c_idn);
cmd.Parameters.AddWithValue("@Hotelcode", hcode);
cmd.Parameters.AddWithValue("@GDS", "HB");
cmd.Parameters.AddWithValue("@IsLoginCust", "Y");
SqlDataAdapter sa = new SqlDataAdapter(cmd);
sa.Fill(dtwt);
}
catch
{
}
if (dtwt.Rows.Count > 0)
{
string Ts_mode = string.Empty;
Ts_mode = dtwt.Rows[0]["TS_Mode"].ToString();
if (Ts_mode == "Fixed")
{
adroommarkup = Convert.ToDouble(dtwt.Rows[0]["TS_Markup"].ToString());
adroomdiscount = Convert.ToDouble(dtwt.Rows[0]["TS_Discount"].ToString());
}
else if (Ts_mode == "Percentage")
{
adroompercmarkup = Convert.ToDouble(dtwt.Rows[0]["TS_Markup"].ToString());
adroommarkup = ((roombaseamount / 100.00) * adroompercmarkup);
adroomperdiscount = Convert.ToDouble(dtwt.Rows[0]["TS_Discount"].ToString());
adroomdiscount = (((roombaseamount) / 100.00) * adroomperdiscount);
}
else
{
adroommarkup = 0.00;
adroomdiscount = 0.00;
}
string Cl_Mode = string.Empty;
Cl_Mode = dtwt.Rows[0]["Cl_Mode"].ToString();
if (Cl_Mode == "Fixed")
{
clmarkup = Convert.ToDouble(dtwt.Rows[0]["Cl_Markup"].ToString());
cldiscount = Convert.ToDouble(dtwt.Rows[0]["Cl_Discount"].ToString());
}
else if (Cl_Mode == "Percentage")
{
clroompercmarkup = Convert.ToDouble(dtwt.Rows[0]["Cl_Markup"].ToString());
clroommarkup = (((roombaseamount) / (100)) * clroompercmarkup);
clroomperdiscount = Convert.ToDouble(dtwt.Rows[0]["Cl_Discount"].ToString());
clroomdiscount = ((roombaseamount / 100.00) * clroomperdiscount);
}
else
{
clmarkup = 0.00;
}
finalroommarkup = adroommarkup + clroommarkup;
finalroomdiscount = adroomdiscount + clroomdiscount;
roombaseamount = roombaseamount + (finalroommarkup - finalroomdiscount);
roomamountwithouttax = (Convert.ToDouble(roombaseamount));
// roombaseamount = (Convert.ToDouble(roomamountwithouttax) + Convert.ToDouble(tax));
troomspricepernightwithmarkup = troomspricepernightwithmarkup + (Convert.ToDouble(roomamountwithouttax));
}
DataRow drp = dtr.NewRow();
drp[0] = 0;
drp[1] = troomspricepernightwithmarkup.ToString("0.00"); //roomdescrow[0]["RatePernight"];
drp[2] = 0;
drp[3] = 0;
drp[4] = "2019-" + checkoutdt.ToString("MM-dd");
drp[5] = "2019-" + checkindt.ToString("MM-dd");
drp[6] = 1;
dtr.Rows.Add(drp);
strtable += "<tr><td>Room" + (r) + "</td>";
for (int i = 0; i < noofweeks; i++)
{
strtable += "<tr><td>Week" + (i + 1) + "</td>";
for (int j = 0; j < 7; j++)
{
DateTime chkdate = startweekdate.AddDays((7 * i) + j);
if (checkoutdt == chkdate)
{
strtable += "<td> </td>";
}
else
{
var perDays = rate.Net.ToString();
var perDay = Convert.ToDouble(perDays) / dc;
strtable += "<td>" + "$" + GetDayRate(dtr, r, chkdate.ToString("MM-dd-yyyy")) + "</td>";
}
}
strtable += "</tr>";
}
r++;
}
strtable += "</tbody> </table> </td> </tr> </tbody></table>";
return(strtable);
}
private string GetHotellist(AvailabilityRS dtHList, string searchid, string checkind, string checkoutd, string guestcount, string selaudults, string selchilds, string currencycode, string b2c_idn)
{
double admarkup = 0.00;
double adpercmarkup = 0.00;
double clpercmarkup = 0.00;
double clmarkup = 0.00;
double finalmarkup = 0.00;
double finaldiscount = 0.00;
double adperdiscount = 0.00;
double clperdiscount = 0.00;
double addiscount = 0.00;
double cldiscount = 0.00;
double baseamount = 0.00;
string reviewrate = string.Empty;
string rvalue = "";
string imagecode = "GEN";
int order = 2;
string childage = string.Empty;
// foreach (DataRow drh in dtHList.Rows)
//{
string b2c_idnencript = Encrypt(b2c_idn);
double dc = 0.0;
try
{ dc = (Convert.ToDateTime(checkoutd.ToString()) - Convert.ToDateTime(checkind.ToString())).TotalDays; }
catch { }
DataTable dssearch = HotelDBLayer.GetSearch(searchid);
if (dssearch.Rows.Count > 0)
{
childage = dssearch.Rows[0]["HB_ChildAge"].ToString();
}
HotelDevMTWebapi.Models.Hotel drh = new HotelDevMTWebapi.Models.Hotel();
string agency_name = "";
DataTable dtpccdet = manage_data.getpccdetails(b2c_idn);
if (dtpccdet.Rows.Count > 0)
{
agency_name = dtpccdet.Rows[0]["agency_name"].ToString();
}
string cmdfacility = "";
cmdfacility = "select HB_HotelCodes from hotelsearch where searchidn=" + searchid;
DataTable dthbhotelcds = manage_data.GetDataTable(cmdfacility, manage_data.con);
DataTable dtffbookingfb = null;
DataRow[] drimgpath = null;
if (System.Web.HttpContext.Current.Cache["dtffbookingfb" + searchid] == null)
{
string cmdflbkfb = "select HotelCode,Path,ImageTypeCode from HotelImage where HotelCode in (" + dthbhotelcds.Rows[0]["HB_HotelCodes"].ToString() + ") order by HotelCode,Path asc";
dtffbookingfb = manage_data.GetDataTable(cmdflbkfb, manage_data.flip_conhb);
System.Web.HttpContext.Current.Cache["dtffbookingfb" + searchid] = dtffbookingfb;
}
else
{
dtffbookingfb = (DataTable)System.Web.HttpContext.Current.Cache["dtffbookingfb" + searchid];
}
for (int i = (vpageno - 1) * 20; i < (vpageno * 20); i++)
{
if (i >= dtHList.Hotels.Hotel.Count || i >= 350)
{
break;
}
drh = dtHList.Hotels.Hotel[i];
HotelMaincintent objhtl = new HotelMaincintent();
List <Hdbfacilities> lstHdbfacilities = new List <Hdbfacilities>();
objhtl = HotelListGenerate.GetHotelContent(vpageno, drh.Code);
if (objhtl.Name != null)
{
lstHdbfacilities = HotelListGenerate.Gethotelfacilities(drh.Code);
//string lengt = objfacility.FacilityCode;
string facilitydescr = string.Empty;
facilitydescr = HotelListGenerate.GetFacilityList(lstHdbfacilities);
//foreach (Hdbfacilities obj in objfacility)
//{
// string decrptnlist = "";
// if (!string.IsNullOrEmpty(obj.FacilityCode))
// {
// decrptnlist = HotelListGenerate.getfacidisc(obj.FacilityCode.ToString(), obj.FacilityGroupCode.ToString());
// facilitydescr += "<li>" + decrptnlist + "</li>";
// }
//}
drimgpath = dtffbookingfb.Select("HotelCode='" + dtHList.Hotels.Hotel[i].Code + "' and ImageTypeCode='" + imagecode + "'");
rvalue += "<div class='col-md-12 hotel-details'><div class='row'>";
try
{
rvalue += " <div class='htl-img-blk col-md-4'> <img src='http://photos.hotelbeds.com/giata/" + drimgpath[0]["Path"].ToString() + "' onerror='this.src="../images/No%20Image%20found.png"' class='img-responsive' id='HotelImage_" + dtHList.Hotels.Hotel[i].Code + "' /></div>";
}
catch
{
rvalue += " <div class='htl-img-blk col-md-4'> <img src='../images/No Image found.png' onerror='this.src="../images/No%20Image%20found.png"' class='img-responsive' id='HotelImage_" + dtHList.Hotels.Hotel[i].Code + "' /></div>";
}
rvalue += "<div class='col-md-8 col-sm-8 col-xs-8 htl-content'> <div class='col-md-8 col-sm-8 col-xs-8 htl-cont-left'>";
rvalue += "<div class='htl-header'> <div class='htl-name'>";
double rating = 0.0;
int starRating = 0;
try
{
//rating = Convert.ToDouble("3.0");
string ratingv = drh.CategoryName.ToString();
string[] rativ_split = ratingv.Split(' ');
if (rativ_split[0].ToString() != "1" && rativ_split[0].ToString() != "2" && rativ_split[0].ToString() != "3" && rativ_split[0].ToString() != "4" && rativ_split[0].ToString() != "5")
{
//if (ratingv == "WITHOUT OFFICIAL CATEGORY")
//{
rating = 0.0;
}
else
{
//rativ_split = ratingv.Split(' ');
rating = Convert.ToDouble(rativ_split[0].ToString());
}
starRating = Convert.ToInt32(rating);
//if (drh.Reviews != null)
//{
// rating = Convert.ToDouble(drh.Reviews.Review.Rate.ToString());
// starRating = Convert.ToInt32(rating);
//}
}
catch
{
rating = Convert.ToDouble("0.0");
starRating = Convert.ToInt32(rating);
}
rvalue += "<a target='_blank' href='HotelDetails_load.aspx?id=" + searchid + "&HotelCode=" + drh.Code + "&chkin=" + checkind + "&chkout=" + checkoutd + "&gc=" + selaudults + "&award=" + rating.ToString() + "&childAges=" + childage + "&Totalguest=" + guestcount + "&childrens=" + selchilds + "&clid=" + b2c_idnencript + "'>";
//if(drh["contractnegcode"].ToString()!="")
//{ rvalue += "<h4>" + drh["HotelName"] + "*<span class='star-blk'><img src='../images/" + drh["RatingValue"] + "stars.png' class='img-responsive' /> </span></h4></a>"; }
//else
//{
//}
try
{
if (starRating > 0)
{
rvalue += "<h4>" + drh.Name + "<span class='star-blk'><img src='../images/" + starRating + "stars.png' class='img-responsive' /> </span></h4>";
}
else
{
rvalue += "<h4>" + drh.Name + "</h4>";
}
}
catch
{
}
rvalue += "</a>";
rvalue += "</div></div>";
rvalue += "<div class='htl-adress'> <p><span class='addressrpblck'><i class='fa fa-map-marker' aria-hidden='true'></i>" + HotelListGenerate.Getaddress(drh.Code) + "</span> |<a href='#' id='btnShow1' data-toggle='modal' data-target='#DivMap' onclick=\"showmap(" + drh.Latitude + "," + drh.Longitude + ",'" + drh.Name + "')\"> Show Map </a></span></p> </div>";
rvalue += "<div class='facilities'><ul class='list-inline'>";
rvalue += facilitydescr;
rvalue += "</ul></div>";
//rvalue += " <div class='facilities'>" + facilitydescr + " </div> ";
try
{
if (drh.Reviews != null)
{
rvalue += " <div class='reviws-blk'> <ul class='list-inline'>";
rvalue += "<li class='review-rate'>" + drh.Reviews.Review.Rate + "</li> <li class='reviw-scre'><span>Excellent</span> (" + drh.Reviews.Review.ReviewCount + " reviews)</li> </ul></div>";
}
//else
//{
// rvalue += " <div class='reviws-blk'> <ul class='list-inline'>";
// rvalue += "<li class='review-rate'>3.0</li> <li class='reviw-scre'><span>Excellent</span> (15 reviews)</li> </ul></div>";
//}
}
catch
{
}
rvalue += "</div>";
rvalue += "<div class='col-md-4 col-sm-4 col-xs-4 htl-cont-right'>";
baseamount = (Convert.ToDouble(drh.MinRate) / Convert.ToDouble(dc));
if (drh.Code.ToString() != "")
{
DataTable dt = new DataTable();
SqlConnection sqlcon = new SqlConnection(con);
try
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = sqlcon;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "p_SreTS_HDR";
cmd.Parameters.AddWithValue("@B2C_IDN", b2c_idn);
cmd.Parameters.AddWithValue("@Hotelcode", drh.Code.ToString());
cmd.Parameters.AddWithValue("@GDS", "HB");
cmd.Parameters.AddWithValue("@IsLoginCust", "Y");
SqlDataAdapter sa = new SqlDataAdapter(cmd);
sa.Fill(dt);
}
catch
{
}
if (dt.Rows.Count > 0)
{
string Ts_mode = string.Empty;
Ts_mode = dt.Rows[0]["TS_Mode"].ToString();
if (Ts_mode == "Fixed")
{
admarkup = Convert.ToDouble(dt.Rows[0]["TS_Markup"].ToString());
addiscount = Convert.ToDouble(dt.Rows[0]["TS_Discount"].ToString());
}
else if (Ts_mode == "Percentage")
{
adpercmarkup = Convert.ToDouble(dt.Rows[0]["TS_Markup"].ToString());
adperdiscount = Convert.ToDouble(dt.Rows[0]["TS_Discount"].ToString());
admarkup = (((baseamount) / 100.00) * adpercmarkup);
addiscount = (((baseamount) / 100.00) * adperdiscount);
}
else
{
admarkup = 0.00;
addiscount = 0.00;
}
string Cl_Mode = string.Empty;
Cl_Mode = dt.Rows[0]["Cl_Mode"].ToString();
if (Cl_Mode == "Fixed")
{
clmarkup = Convert.ToDouble(dt.Rows[0]["Cl_Markup"].ToString());
cldiscount = Convert.ToDouble(dt.Rows[0]["Cl_Discount"].ToString());
}
else if (Cl_Mode == "Percentage")
{
clpercmarkup = Convert.ToDouble(dt.Rows[0]["Cl_Markup"].ToString());
clperdiscount = Convert.ToDouble(dt.Rows[0]["Cl_Discount"].ToString());
clmarkup = ((baseamount / 100.00) * clpercmarkup);
cldiscount = ((baseamount / 100.00) * clperdiscount);
}
else
{
clmarkup = 0.00;
cldiscount = 0.00;
}
finalmarkup = admarkup + clmarkup;
finaldiscount = addiscount + cldiscount;
baseamount = baseamount + (finalmarkup - finaldiscount);
}
rvalue += " <h2 class='price-cnt'>" + Utilities.GetRatewithSymbol(currencycode) + Convert.ToDouble(Convert.ToDouble(baseamount)).ToString("0.00") + "*</h2>";//drh.MinRate) / (dc)
}
else
{
rvalue += " <h2 class='price-cnt'>" + Utilities.GetRatewithSymbol(currencycode) + Convert.ToDouble(Convert.ToDouble(baseamount)).ToString("0.00") + "</h2>";//drh.MinRate) / (dc)
}
rvalue += " <p class='srch-pr-nyt'>Per Night</p>";
//if (drh.Reviews != null)
//{
// rating = Convert.ToDouble(drh.Reviews.Review.Rate.ToString());
//}
rvalue += "<a target='_blank' href='HotelDetails_load.aspx?id=" + searchid + "&HotelCode=" + drh.Code + "&chkin=" + checkind + "&chkout=" + checkoutd + "&gc=" + guestcount + "&award=" + rating.ToString() + "&childAges=" + childage + "&Currency=" + currencycode + "&clid=" + b2c_idnencript + "' class='chocse-rm'>Choose Room</a>";
rvalue += " <p class='avail-rms'>";
rvalue += "<a class='lnkviewavrooms' style='cursor:pointer;' onclick=\"RoomDetails('" + drh.Code + "',this,' " + rating.ToString() + "')\">View Available Rooms</a>";
rvalue += " </p></div>";
rvalue += " <div class='discount col-md-12 col-sm-12 col-xs-12 col-sm-12 col-xs-12'>";
rvalue += " <div class='benft'> <p> <span class='hotl-logo'>";
rvalue += " <img src='http://photos.hotelbeds.com/giata/" + HotelListGenerate.getimpagePath(imagecode, drh.Code) + "' onerror='this.src="../images/No%20Image%20found.png"' id='HotelLogo_" + drh.Code + "'/></span>*Special Discounted Rates </p> </div>";
rvalue += "</div></div> </div>";
rvalue += " <div class='availble-rm-blk' id='divavailroom" + drh.Code + "'>";
rvalue += " <div class='loaing-bg_img' style='display:none ;width: 100%; margin-top: 20px; text-align: center;'><img src='../images/loader.gif' /><br /> please wait..</div>";
rvalue += "</div></div>";
}
}
return(rvalue);
}
private string GetRateTable(string RPH, HotelProperty hpr, DataRow dr, string searchid)
{
string rvalue = "";
DataTable dts = HotelDBLayer.GetSearch(searchid);
DateTime checkindt = Convert.ToDateTime(dts.Rows[0]["CheckInDt"]);
DateTime checkoutdt = Convert.ToDateTime(dts.Rows[0]["CheckOutDt"]);
DateTime startweekdate = checkindt.AddDays(-(int)checkindt.DayOfWeek);
DateTime endweekdate = checkoutdt.AddDays(-(int)checkoutdt.DayOfWeek).AddDays(6);;
double noofdays = (endweekdate - startweekdate).TotalDays;
decimal noofweeks = Decimal.Ceiling(Convert.ToDecimal(noofdays) / 7);
string strtable = "<table width='100%' border='0' cellspacing='0' cellpadding='0' class='week-table-main'>";
strtable += "<tbody><tr><td>";
strtable += "<table width='100%' border='0' cellspacing='0' cellpadding='0' class='week-days'>";
strtable += "<tbody><tr><td> </td><td>Sun</td><td>mon</td><td>tue</td><td>wed</td><td>thu</td><td>fri</td> <td>sat</td> </tr></tbody></table>";
strtable += "</td></tr><tr><td> <table width='100%' border='0' cellspacing='0' cellpadding='0' class='price-details'><tbody>";
DataRow[] roomdescrow = hpr.dtRoomInfo.Select("RPH='" + RPH + "'");
DataRow[] roomRaterow = hpr.dtRoomRate.Select("RPH='" + RPH + "'");
DataRow[] hotelpricingrow = hpr.dtHotelPricing.Select("RoomRateID='" + roomRaterow[0]["RoomRateID"].ToString() + "'");
DataRow[] hpraterangerow = hpr.HP_RateRange.Select("HotelPricingID='" + hotelpricingrow[0]["HotelPricingID"].ToString() + "'");
DataTable dtr = new DataTable();
dtr.Columns.Add("id");
dtr.Columns.Add("amount");
dtr.Columns.Add("taxes");
dtr.Columns.Add("surcharges");
dtr.Columns.Add("expdate", typeof(DateTime));
dtr.Columns.Add("effedate", typeof(DateTime));
dtr.Columns.Add("hid");
if (hpraterangerow.Count() > 0)
{
foreach (DataRow drr in hpraterangerow)
{
DataRow drp = dtr.NewRow();
drp[0] = drr[0];
drp[1] = drr[1];
drp[2] = drr[2];
drp[3] = drr[3];
drp[4] = "2018-" + drr[4].ToString();
drp[5] = "2018-" + drr[5].ToString();
drp[6] = drr[6];
dtr.Rows.Add(drp);
}
}
else
{
DataRow drp = dtr.NewRow();
drp[0] = 0;
drp[1] = roomdescrow[0]["RatePernight"];
drp[2] = 0;
drp[3] = 0;
drp[4] = "2018-" + checkoutdt.ToString("MM-dd");
drp[5] = "2018-" + checkindt.ToString("MM-dd");
drp[6] = 1;
dtr.Rows.Add(drp);
}
for (int i = 0; i < noofweeks; i++)
{
strtable += "<tr><td>Week" + (i + 1) + "</td>";
for (int j = 0; j < 7; j++)
{
strtable += "<td>" + GetDayRate(dtr, startweekdate.AddDays((7 * i) + j).ToString("MM-dd-yyyy")) + "</td>";
}
strtable += "</tr>";
}
strtable += "</tbody> </table> </td> </tr> </tbody></table>";
return(strtable);
}
//public string GetContextResult()
//{
// string rvalue = "";
// pcc = "VL5H";
// ipcc = "7A7H"; ;
// username = "******";
// password = "******";
// //getting the contexchangeresult
// string filePathContext = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelAvail/" + searchid + "_Context.xml");
// if (File.Exists(filePathContext))
// {
// ContextResult = File.ReadAllText(filePathContext);
// }
// else
// {
// ContextResult = XMLRead.ContextChange(pcc, ipcc, username, password, searchid);
// }
// return ContextResult;
//}
public int SaveRoom(HotelProperty 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);
}
public List <HotelImageJsonCode> Get(string searchid, string HotelCode, string curcode, string b2c_idn)
{
List <HotelImageJsonCode> HotelImages = new List <HotelImageJsonCode>();
try
{
if (searchid != "" && searchid != null && HotelCode != "" && HotelCode != null)
{
string[] HotelCodes = HotelCode.Trim('*').Split('*');
foreach (string hcode in HotelCodes)
{
HotelImageJsonCode hijc = new HotelImageJsonCode();
DataTable dtHotelUrl = HotelDBLayer.GetHotelImageUrl(hcode);
if (dtHotelUrl.Rows.Count > 0)
{
hijc.Image = dtHotelUrl.Rows[0]["ImageUrl"].ToString();
hijc.Logo = dtHotelUrl.Rows[0]["Logourl"].ToString();
hijc.Hotelcode = hcode;
HotelImages.Add(hijc);
}
else
{
string filePathContext = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelXML/" + searchid + "_" + curcode + "_ImageContextChange-RS.xml");
if (File.Exists(filePathContext))
{
ContextResult = File.ReadAllText(filePathContext);
}
else
{
ContextResult = XMLRead.ContextChange(searchid + "Image");
try
{
File.WriteAllText(filePathContext, ContextResult);
}
catch
{
}
}
HotelImageAj hotelimage = new HotelImageAj(HotelCode, "", searchid, ContextResult);
string image = hotelimage.Image;
string logo = hotelimage.logo;
if (image != "N")
{
HotelDBLayer.SaveHotelImageUrl(hcode, image, logo);
}
hijc.Hotelcode = hcode;
if (image != "N")
{
hijc.Image = image;
}
else
{
hijc.Image = "../images/No Image found.png";
}
if (logo != "N")
{
hijc.Logo = logo;
}
else
{
hijc.Logo = "../images/No Image found.png";
}
HotelImages.Add(hijc);
}
}
//closing the session
if (ContextResult.ToString() != "")
{
DataSet ds = new DataSet();
DataSet dsSession = new DataSet();
StringReader se_stream = new StringReader(ContextResult);
dsSession.ReadXml(se_stream);
string Rq = "";
if (dsSession.Tables["BinarySecurityToken"] != null)
{
DataTable dtBinarySecurityToken = dsSession.Tables["BinarySecurityToken"];
DataTable dtMessageData = dsSession.Tables["MessageData"];
DataTable dtMessageHeader = dsSession.Tables["MessageHeader"];
string timestamp = DateTime.UtcNow.ToString();
string cresult = XMLRead.closession(dtMessageData.Rows[0]["MessageId"].ToString(), timestamp, dtBinarySecurityToken.Rows[0]["BinarySecurityToken_Text"].ToString(), searchid + "Image", XMLRead.pcc, XMLRead.ipcc);
}
}
}
}
catch
{
}
return(HotelImages);
}
public checkresult Get(string searchid, string hcode, string ratekey, string b2c_idn)
{
double admarkup = 0.00;
double adroommarkup = 0.00;
double adpercmarkup = 0.00;
double clpercmarkup = 0.00;
double adperdiscount = 0.00;
double clperdiscount = 0.00;
double clmarkup = 0.00;
double finalmarkup = 0.00;
double finaldiscount = 0.00;
double addiscount = 0.00;
double cldiscount = 0.00;
double baseamount = 0.00;
double roombaseamount = 0.00;
double roomamountwithouttax = 0.00;
double roomamountwithtax = 0.00;
double adroompercmarkup = 0.00;
double clroompercmarkup = 0.00;
double adroomperdiscount = 0.00;
double clroomperdiscount = 0.00;
double clroommarkup = 0.00;
double finalroommarkup = 0.00;
double finalroomdiscount = 0.00;
double adroomdiscount = 0.00;
double clroomdiscount = 0.00;
double rrate;
double roomtaxprice = 0.00;
double eachroomavgtaxprice = 0.00;
double roomcancellationprice = 0.00;
double troomspricepernightwithmarkup = 0.00;
double eachroomspernihgtpricewmrk = 0.00;
string ratetable = string.Empty;
double allroomsprice = 0.00;
string filePathRQ = string.Empty;
ManageHDetAj mhd = new ManageHDetAj();
string Result = string.Empty;
AvailabilityRS objAvailabilityRS = new AvailabilityRS();
CheckRateRS objCheckRateRS = new CheckRateRS();
List <upselling> lstupselling = new List <upselling>();
Rooms objRooms = new Rooms();
Room objupsellingRoom = new Room();
checkresult objchkres = new checkresult();
DataTable dssearch = HotelDBLayer.GetSearch(searchid);
int rooms = Convert.ToInt32(dssearch.Rows[0]["Rooms"]);
checkrates(searchid, hcode, ratekey, b2c_idn);
string[] ratekeys = ratekey.Split(',');
string ratekey_split = ratekeys[0].Substring(ratekeys[0].Length - 4);
try
{
ClsFevicons objfavicons;
objfavicons = new ClsFevicons();
CultureInfo cultureInfo = Thread.CurrentThread.CurrentCulture;
// TextInfo = cultureInfo.TextInfo;
//string filePathRQ = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelXML/" + searchid + "_propertydesc_" + hotelcode + "_" + CurrencyCode + "-RS.xml");
filePathRQ = Path.Combine(HttpRuntime.AppDomainAppPath, "Checkrates_tbluexml/" + searchid + "_" + ratekey_split + "_checkrate-RS.xml");
if (File.Exists(filePathRQ))
{
XmlDataDocument xmldoc = new XmlDataDocument();
FileStream fs = new FileStream(filePathRQ, FileMode.Open, FileAccess.Read);
xmldoc.Load(fs);
fs.Close();
XmlNode xnod = xmldoc.DocumentElement;
XmlSerializer deserializer = new XmlSerializer(typeof(CheckRateRS));
StreamReader reader = new StreamReader(filePathRQ);
objCheckRateRS = (CheckRateRS)deserializer.Deserialize(reader);
if (objCheckRateRS.Error == null)
{
double dc = 0.0;
try
{ dc = (Convert.ToDateTime(objCheckRateRS.Hotel.CheckOut.ToString()) - Convert.ToDateTime(objCheckRateRS.Hotel.CheckIn.ToString())).TotalDays; }
catch { }
string cancleplFrom = "";
string cancleplamount = "";
foreach (Room objrooms in objCheckRateRS.Hotel.Rooms.Room)
{
Rates objrates = new Rates();
objrates = objrooms.Rates;
List <Rate> lstRate = objrates.Rate;
if (lstRate != null && lstRate.Count > 0)
{
for (int r = 0; r < lstRate.Count; r++)
{
// eachroomsprice = Convert.ToDouble(troomsprice / norooms);
rrate = Convert.ToDouble(Convert.ToDouble(Convert.ToDouble(lstRate[r].Net) / dc).ToString("0.00"));
string avgpnignt = Convert.ToDouble(rrate).ToString();
//string avgroompernight = (Convert.ToDouble(avgpnignt) / dc).ToString("0.00");
roombaseamount = Convert.ToDouble(avgpnignt);
DataTable dtwt = new DataTable();
SqlConnection sqlconwt = new SqlConnection(con);
try
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = sqlconwt;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "p_SreTS_HDR";
cmd.Parameters.AddWithValue("@B2C_IDN", b2c_idn);
cmd.Parameters.AddWithValue("@Hotelcode", hcode);
cmd.Parameters.AddWithValue("@GDS", "HB");
cmd.Parameters.AddWithValue("@IsLoginCust", "Y");
SqlDataAdapter sa = new SqlDataAdapter(cmd);
sa.Fill(dtwt);
}
catch
{
}
if (dtwt.Rows.Count > 0)
{
string Ts_mode = string.Empty;
Ts_mode = dtwt.Rows[0]["TS_Mode"].ToString();
if (Ts_mode == "Fixed")
{
adroommarkup = Convert.ToDouble(dtwt.Rows[0]["TS_Markup"].ToString());
adroomdiscount = Convert.ToDouble(dtwt.Rows[0]["TS_Discount"].ToString());
}
else if (Ts_mode == "Percentage")
{
adroompercmarkup = Convert.ToDouble(dtwt.Rows[0]["TS_Markup"].ToString());
adroommarkup = ((roombaseamount / 100.00) * adroompercmarkup);
adroomperdiscount = Convert.ToDouble(dtwt.Rows[0]["TS_Discount"].ToString());
adroomdiscount = (((roombaseamount) / 100.00) * adroomperdiscount);
}
else
{
adroommarkup = 0.00;
adroomdiscount = 0.00;
}
string Cl_Mode = string.Empty;
Cl_Mode = dtwt.Rows[0]["Cl_Mode"].ToString();
if (Cl_Mode == "Fixed")
{
clmarkup = Convert.ToDouble(dtwt.Rows[0]["Cl_Markup"].ToString());
cldiscount = Convert.ToDouble(dtwt.Rows[0]["Cl_Discount"].ToString());
}
else if (Cl_Mode == "Percentage")
{
clroompercmarkup = Convert.ToDouble(dtwt.Rows[0]["Cl_Markup"].ToString());
clroommarkup = (((roombaseamount) / (100)) * clroompercmarkup);
clroomperdiscount = Convert.ToDouble(dtwt.Rows[0]["Cl_Discount"].ToString());
clroomdiscount = ((roombaseamount / 100.00) * clroomperdiscount);
}
else
{
clmarkup = 0.00;
}
finalroommarkup = adroommarkup + clroommarkup;
finalroomdiscount = adroomdiscount + clroomdiscount;
roombaseamount = roombaseamount + (finalroommarkup - finalroomdiscount);
roomamountwithouttax = (Convert.ToDouble(roombaseamount));
// roombaseamount = (Convert.ToDouble(roomamountwithouttax) + Convert.ToDouble(tax));
troomspricepernightwithmarkup = troomspricepernightwithmarkup + (Convert.ToDouble(roomamountwithouttax));
allroomsprice = allroomsprice + Convert.ToDouble(lstRate[r].Net);
}
if (lstRate[r].Taxes != null && lstRate[r].Taxes.Tax.Amount != null)
{
roomtaxprice = roomtaxprice + Convert.ToDouble(lstRate[r].Taxes.Tax.Amount.ToString());
}
try
{
if (lstRate[r].CancellationPolicies != null && lstRate[r].CancellationPolicies.CancellationPolicy.Amount != null)
{
roomcancellationprice = roomcancellationprice + Convert.ToDouble(lstRate[r].CancellationPolicies.CancellationPolicy.Amount.ToString());
}
}
catch
{
//cancleplamount = "NO Cancellation amount";
}
}
eachroomspernihgtpricewmrk = (troomspricepernightwithmarkup / rooms);
eachroomavgtaxprice = Convert.ToDouble(roomtaxprice / rooms);
//lstRate.Add(dr.Rates.Rate.Where(n => n.BoardCode == boardCode && (n.ChildrenAges.Contains(',') ? n.ChildrenAges.Split(',')[0].ToString() : n.ChildrenAges) == (childAges.Contains(',') ? childAges.Split(',')[0].ToString() : childAges)).FirstOrDefault());
//foreach (Rate drrt in lstRate)
//{
//var roomamt = rooms[i].Room[i].Rates.Rate[n].Net;
string ratetype = lstRate[0].RateType;
string ratecommentid = string.Empty;
try
{
ratecommentid = lstRate[0].RateCommentsId;
}
catch
{
}
try
{
cancleplFrom = lstRate[0].CancellationPolicies.CancellationPolicy.From.ToString();
}
catch
{
}
try
{
cancleplamount = roomcancellationprice.ToString("0.00");//roomcancellationprice.ToString();
}
catch
{
//cancleplamount = "NO Cancellation amount";
}
ratetable = GetRateTable(hcode, objCheckRateRS, lstRate, hcode, searchid, "USD", adroommarkup, clroommarkup, adroomdiscount, clroomdiscount, roomtaxprice, b2c_idn, rooms);//HttpUtility.HtmlEncode(
}
}
//objchkres.amount = Convert.ToDouble(Convert.ToDouble(objCheckRateRS.Hotel.Rooms.Room[0].Rates.Rate[0].Net) / dc).ToString("0.00");
objchkres.amount = eachroomspernihgtpricewmrk.ToString("0.00");
objchkres.allroomstamount = allroomsprice.ToString("0.00");
objchkres.cancellationamt = cancleplamount;
objchkres.cancellationfrom = cancleplFrom;
objchkres.roomdetailstable = ratetable;
try
{
//List<Tax> lsttax = new List<Tax>();
//foreach (var lttax in objCheckRateRS.Hotel.Rooms.Room[0].Rates.Rate[0].Taxes.Tax)
//{
if (objCheckRateRS.Hotel.Rooms.Room[0].Rates.Rate[0].Taxes.Tax.Amount != null)
{
objchkres.Tax = eachroomavgtaxprice.ToString();//Convert.ToDouble(Convert.ToDouble(objCheckRateRS.Hotel.Rooms.Room[0].Rates.Rate[0].Taxes.Tax.Amount)).ToString("0.00");
}
else
{
objchkres.Tax = "0.00";
}
//}
}
catch
{
objchkres.Tax = "0.00";
}
//HotelListGenerate.CreateTables(dtBPIadd);
//HotelListGenerate.FillHStable(xnod, dtBPIadd);//yogi
}
else
{
objchkres.Message = "Fare Not Available";
}
}
}
catch
{
objchkres.Message = "Fare Not Available";
}
return(objchkres);
}
private string GetHotelResBodyRQ(string searchid, CustomerInfo ci, string rph, string rooms, string ratekey, string bookingid)
{
int rphl = rph.ToString().Length;
if (rphl == 1)
{
rph = "00" + rph.ToString();
}
if (rphl == 2)
{
rph = "0" + rph.ToString();
}
string expdate = "";
string[] expdatepart = ci.CCExpDate.Split('-');
expdate = expdatepart[1] + "-" + expdatepart[0];
string rq = "";
//rq += "<SOAP-ENV:Body>";
//rq += "<OTA_HotelResRQ xmlns='http://webservices.sabre.com/sabreXML/2011/10' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' ReturnHostCommand='false' TimeStamp='2013-11-22T17:15:00-06:00' Version='2.2.0'>";
//rq += "<Hotel>";
//rq += "<BasicPropertyInfo RPH='" + rph + "' />";
//rq += "<Guarantee Type='G'>";
//rq += "<CC_Info>";
//rq += "<PaymentCard Code='" + ci.PayMethod + "' ExpireDate='" + expdate + "' Number='" + ci.CCNumber + "'/>";
//rq += "<PersonName>";
//rq += "<Surname>" + ci.CCHName + "</Surname>";
//rq += "</PersonName>";
//rq += "</CC_Info>";
//rq += "</Guarantee>";
//rq += "<RoomType NumberOfUnits='" + rooms + "'/>";
//rq += "</Hotel>";
//rq += "</OTA_HotelResRQ>";
//rq += "</SOAP-ENV:Body>";
int adults = 0;
string adultsbyroom = string.Empty;
string ChildrenByRoom = string.Empty;
int childs = 0;
int Roomsdb = 0;
string childages = string.Empty;
string cmdtxtrkey = "select * from HotelSearch where Searchidn=" + searchid + "";
DataTable dtsres = manage_data.GetDataTable(cmdtxtrkey, manage_data.con);
int bid = Convert.ToInt32(bookingid);
DataTable dssearch = HotelDBLayer.GetPaxDet_BOF(bid);
string Name = string.Empty;
//if (dssearch.Rows.Count > 0)
//{
// foreach (DataTable guestdet in dssearch.Rows)
// {
// Name += guestdet.Rows[0]["FirstName"].ToString() + " " + guestdet.Rows[0]["LastName"].ToString()+",";
// }
//}
if (dtsres.Rows.Count > 0)
{
Roomsdb = Convert.ToInt32(dtsres.Rows[0]["Rooms"].ToString());
adults = Convert.ToInt32(dtsres.Rows[0]["Adults"].ToString());
adultsbyroom = dtsres.Rows[0]["HB_AdultsByRoom"].ToString();
childs = Convert.ToInt32(dtsres.Rows[0]["Children"].ToString());
ChildrenByRoom = dtsres.Rows[0]["HB_ChildrenByRoom"].ToString();
childages = dtsres.Rows[0]["HB_ChildAge"].ToString();
//room1-child1-childAge1_4,room1-child2-childAge2_6,room2-child1-childAge1_7
//ratekey = "20190322|20190323|W|235|425919|DBL.ST|FIT1|RO||1~1~2|4~6|N@440CE2A9A5234A11546798860704AAUK0000031001500020924da2";
//20190222|20190223|W|235|168947|DBL.2Q-NM|ID_B2B_26|RO|SF2|1~2~1|5~8|N@665957DF25404AE1546686230830AAUK000000100010001052601b6
}
rq += "<bookingRQ xmlns='http://www.hotelbeds.com/schemas/messages' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'>";
rq += "<holder name='" + ci.Name + "' surname='" + ci.SurName + "'/>";
rq += "<clientReference>IntegrationAgency</clientReference>";
rq += "<rooms>";
int rc = 0;
int cco = 0;
int adco = 0;
string[] ratekey_split = ratekey.Split('|');
string[] chags_split = childages.Split(',');
string[] childbyroom_split = ChildrenByRoom.Split('_');
string[] adtbyroom_split = adultsbyroom.Split('_');
int chagc = 0;
for (int i = 0; i < Roomsdb; i++)
{
int adts = Convert.ToInt32(adtbyroom_split[i].Split('-')[1]);
int chds = Convert.ToInt32(childbyroom_split[i].Split('-')[1]);
if (i == 0)
{
rq += "<room rateKey='" + ratekey + "'>";
chagc = chds;
}
else
{
string ratekey_new = "";
//string[] roominfo = null;
//if (chds > 0)
//{
// roominfo = chags_split[i].Split('_');
//}
string roomcont = "1~" + adts + "~" + chds;
string agscont = "";
for (int a = 0; a < chds; a++)
{
agscont += chags_split[chagc].Split('_')[1] + "~";
chagc++;
}
if (chds > 0)
{
ratekey_split[10] = agscont.Remove(agscont.Length - 1);
ratekey_split[9] = roomcont;
for (int r = 0; r <= 11; r++)
{
ratekey_new += ratekey_split[r] + "|";
}
rq += "<room rateKey='" + ratekey_new.Remove(ratekey_new.Length - 1) + "'>";
}
else
{
ratekey_split[10] = "";
ratekey_split[9] = roomcont;
for (int r = 0; r <= 11; r++)
{
ratekey_new += ratekey_split[r] + "|";
}
rq += "<room rateKey='" + ratekey_new.Remove(ratekey_new.Length - 1) + "'>";
}
}
//rq += "<paxes>";
//rate key splitting
//rq += "<pax roomId='1' type='AD' name='" + ci.Name + "' surname='" + ci.CCHName + "'/>";
//rq += "</paxes>";
int adlbyr = adultsbyroom.Split('_').Count();
//if (Convert.ToInt32(adultsbyroom.Split('_')[(i)].Split('-')[1]) > 0)
//{
rq += "<paxes>";
string stradlts = string.Empty;
stradlts = adults.ToString();
//for (int j = 0; j < Convert.ToInt32(adultsbyroom.Split('_')[(i)].Split('-')[1]); j++)
//{
rq += " <pax roomId='1' type='AD' name='" + dssearch.Rows[i]["FirstName"].ToString() + "' surname='" + dssearch.Rows[i]["LastName"] + "'/>";
adco++;
//}
if (Convert.ToInt32(ChildrenByRoom.Split('_')[(i)].Split('-')[1]) > 0)
{
//string rcage = "room" + i + "-" + "child" + i + "-" + "childAge"+i;
for (int k = 0; k < Convert.ToInt32(ChildrenByRoom.Split('_')[(i)].Split('-')[1]); k++)
{
rq += " <pax roomId='1' type='CH' age='" + childages.Split(',')[cco].Split('_')[1].ToString() + "'/>";
cco++;
}
}
rq += " </paxes>";
//}
rq += "</room>";
}
rq += "</rooms>";
rq += "<remark>Booking remarks are to be written here.</remark>";
rq += "</bookingRQ>";
return(rq);
}
