public string Get(string searchid, string city, string checkind, string checkoutd, string guestscount, string selroom, string selaudults, string selchilds, string sortby, string pageno, string starfilter, string amenities, string Hotelname, string Hotelchain, string lprice, string hprice, string curcode, string b2c_idn)
{
AvailabilityRS objAvailabilityRS = new AvailabilityRS();
vcity = city;
vpageno = Convert.ToInt16(pageno);
vcurcode = curcode;
string rvalue = "";
// string HLFPath = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelAvail/" + searchid + "_" + vcurcode + "_HotelList.xml");
// string HLFPath = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelAvail/" + b2c_idn + "_" + searchid + "_" + curcode + "_HotelList.xml");
string HLFPath = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelXML/" + searchid + "_" + curcode + "_hotelsAvail-RS.xml"); //HotelXML/" + searchid + "_" + curcode + "_hotelsAvail-RS.xml
DataSet dsHL = new DataSet();
if (File.Exists(HLFPath))
{
XmlDataDocument xmldoc = new XmlDataDocument();
FileStream fs = new FileStream(HLFPath, 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(AvailabilityRS));
StreamReader reader = new StreamReader(HLFPath);
objAvailabilityRS = (AvailabilityRS)deserializer.Deserialize(reader);
string pricerangecond = HotelListGenerate.GetPricrangecondzero();
//AvailabilityRS dtPricingzero = HotelListGenerate.FilterTable(objAvailabilityRS, pricerangecond);
int totalhotels = 0;
if (objAvailabilityRS.Hotels.Hotel.Count >= 350)
{
totalhotels = 350;
}
else
{
totalhotels = objAvailabilityRS.Hotels.Hotel.Count;
}
vtotpages = Convert.ToInt16(Math.Ceiling(Convert.ToDecimal(totalhotels) / 20));
AvailabilityRS dtFilterHotels = HotelListGenerate.GetFilteredDataList(objAvailabilityRS, Hotelname, Hotelchain, sortby, starfilter, amenities, lprice, hprice);
//DataTable dtSortedHotels = HotelListGenerate.GetSortedData(dtFilterHotels, sortby);
rvalue += GetHotellistPG(dtFilterHotels, searchid, checkind, checkoutd, guestscount, selaudults, selchilds, sortby, totalhotels, curcode, b2c_idn);
}
else
{
}
return(rvalue);
}
public string Get(string searchid, string city, string checkind, string checkoutd, string guestscount, string selroom, string selaudults, string selchilds, string sortby, string pageno, string amenities, string stars, string hotelname, string curcode, string b2c_idn)
{
AvailabilityRS objAvailabilityRS = new AvailabilityRS();
vcity = city;
vpageno = Convert.ToInt16(pageno);
// string HLFPath = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelAvail/" + searchid + "_" + curcode + "_HotelList.xml");
string HLFPath = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelXML/" + searchid + "_" + curcode + "_hotelsAvail-RS.xml");
if (File.Exists(HLFPath))
{
XmlDataDocument xmldoc = new XmlDataDocument();
FileStream fs = new FileStream(HLFPath, FileMode.Open, FileAccess.Read);
xmldoc.Load(fs);
fs.Close();
XmlNode xnod = xmldoc.DocumentElement;
XmlSerializer deserializer = new XmlSerializer(typeof(AvailabilityRS));
StreamReader reader = new StreamReader(HLFPath);
objAvailabilityRS = (AvailabilityRS)deserializer.Deserialize(reader);
//HotelListGenerate.CreateTables(dtBPIadd);
//HotelListGenerate.FillHStable(xnod, dtBPIadd);//yogi
}
else
{
HACondition Hac = GetSearchConditon(city, checkind, checkoutd, guestscount, Convert.ToInt32(selroom), Convert.ToInt32(selaudults), Convert.ToInt32(selchilds), curcode);
HotelSearchAj hs = new HotelSearchAj(Hac, searchid, b2c_idn);
dtBPIadd = hs.dtBPIadd;
DataSet ds = new DataSet();
ds.Tables.Add(dtBPIadd);
ds.WriteXml(HLFPath);
}
string pricerangecond = HotelListGenerate.GetPricrangecondzero();
AvailabilityRS dtPricingzero = HotelListGenerate.FilterTable(objAvailabilityRS, pricerangecond);
objAvailabilityRS.Hotels.Hotel = objAvailabilityRS.Hotels.Hotel.OrderBy(k => Convert.ToDouble(k.MinRate)).ToList();
int totalhotels = 0;
if (objAvailabilityRS.Hotels.Hotel.Count() >= 350)
{
totalhotels = 350;//objAvailabilityRS.Hotels.Hotel.Count();
}
else
{
totalhotels = objAvailabilityRS.Hotels.Hotel.Count();
}
//int totalhotels = dtPricingzero.Rows.Count;
string rvalue = "";
if (totalhotels <= 0)
{
rvalue = "N";
}
else
{
vtotpages = Convert.ToInt16(Math.Ceiling(Convert.ToDecimal(totalhotels) / 20));
AvailabilityRS dtFilterHotels = HotelListGenerate.GetFilteredData(objAvailabilityRS, hotelname, "", sortby, stars, amenities);
//AvailabilityRS dtSortedHotels = HotelListGenerate.GetSortedData(dtFilterHotels, sortby);
rvalue = Generatehtml(dtFilterHotels, dtPricingzero, searchid, checkind, checkoutd, guestscount, hotelname, sortby, curcode, b2c_idn, selaudults, selchilds);
}
return(rvalue);
}
private string Generatehtml(AvailabilityRS objAvailabilityRS, AvailabilityRS MainTable, string searchid, string checkind, string checkoutd, string guestscount, string Hotelname, string sortby, string currencycode, string b2c_idn, string seladults, string selchilds)
{
hsAmentitiesCount = HotelListGenerate.GetPropinfocount(objAvailabilityRS);
string lstHotelCodes = string.Join(",", MainTable.Hotels.Hotel.Select(k => k.Code));
string genstring = "";
genstring = "<div class='inner-col-left col-md-3' id='divleftfilters'>";
genstring += "<div class='inner-col-left-inn'>";
genstring += "<div class='filter-block' id='divfilterblk'>";
genstring += "<div class='filter-title'><h3>filters</h3><a style='cursor: pointer;display:none' id='lnkclearfils' onclick='ClearFilters()'>clear all</a> </div>";
genstring += "<div class='all-fltr-sec' id='divltselfils' style='display:none' ><asp:Literal ID='ltselfilters'></asp:Literal></div>";
genstring += " <div class='shw-mre' id='divshowmorefils'><a style='cursor: pointer;display:none' id='lnkshowmorefils' onclick='showmorefil()' style='display:none'>show more</a></div>";
genstring += "</div>";
genstring += "<div class='filter-block'>";
genstring += "<div class='filter-title'><h4>Price range:</h4> </div>";
genstring += "<div class='filter-label'><label class='pad-Rten'><span class='lbl padding-8'><input type='text' id='amount' class='inputtextbox' readonly onchange='pricerangechange()'></span>";
genstring += "<div id='slider-range'></div></label></div> </div>";
genstring += "<div class='filter-block'>";
genstring += "<div class='filter-title' onclick=\"show_promos('divhotelfil')\">";
genstring += "<h4>Hotel Filters</h4><p><i class='fa fa-angle-down' aria-hidden='true' id='adhotelfil'></i></p> </div>";
genstring += "<div id='divhotelfil'> <div class='hotel-name-blk'>";
if (!string.IsNullOrEmpty(Hotelname))
{
genstring += "<input name='txtHotelname' type='text' id='txthotelname' placeholder='Enter Hotel Name' value='" + Hotelname + "' class='form-control' >";
}
else
{
genstring += "<input name='txtHotelname' type='text' id='txthotelname' placeholder='Enter Hotel Name' class='form-control' >";
}
genstring += "<a id='srhotelname' style='cursor:pointer' onclick='srhotelnameClick()'>go</a></div>";
genstring += "<div class='hotel-chain-blk'>";
genstring += HotelListGenerate.FillHotelChains(objAvailabilityRS);
genstring += "</div></div></div>";
genstring += "<div style='display:none' class='filter-block'><div class='filter-title' onclick=\"show_promos('divstar')\"> <h4>Star rating</h4>";
genstring += "<p><i class='fa fa-angle-down' aria-hidden='true'></i></p></div><div id='divstar'>";
List <Reviews> lstreviews = new List <Reviews>();
lstreviews = objAvailabilityRS.Hotels.Hotel.Select(k => k.Reviews).ToList();
//yogi comented for review checking 07/01/19
//for (int i = 0; i < lstreviews.Count; i++)
//{
// if (lstreviews[i] != null)
// {
// genstring += HotelListGenerate.GetStarrating("chkrt5", 5, MainTable);
// genstring += HotelListGenerate.GetStarrating("chkrt4", 4, MainTable);
// genstring += HotelListGenerate.GetStarrating("chkrt3", 3, MainTable);
// genstring += HotelListGenerate.GetStarrating("chkrt2", 2, MainTable);
// genstring += HotelListGenerate.GetStarrating("chkrt1", 1, MainTable);
// }
//}
genstring += "</div> </div>";
genstring += "<div class='filter-block'> <div class='filter-title' onclick=\"show_promos('divfc')\"> <h4>Amenities</h4> <p><i class='fa fa-angle-down' aria-hidden='true'></i></p> </div>";
genstring += "<div id='divfc'>";
genstring += HotelListGenerate.GetAmenities("chkfitnessfun", "Fitness", "Fitness Center", "Fitness", lstHotelCodes, MainTable.Hotels.Hotel);
genstring += HotelListGenerate.GetAmenities("chkpoolfun", "Indpool", "Indoor Pool", "Indpool", lstHotelCodes, MainTable.Hotels.Hotel);
genstring += HotelListGenerate.GetAmenities("chkinternet", "Internet", "Internet", "Internet", lstHotelCodes, MainTable.Hotels.Hotel);
//genstring += HotelListGenerate.GetAmenities("chkwi-fi", "Wi-fi", "Wi-fi", "Wi-fi", lstHotelCodes, MainTable.Hotels.Hotel);
genstring += HotelListGenerate.GetAmenities("chkbreakfast", "Breakfast", "Breakfast included", "Breakfast", lstHotelCodes, MainTable.Hotels.Hotel);
genstring += HotelListGenerate.GetAmenities("chkfreepark", "Park", "Free Parking", "Park", lstHotelCodes, MainTable.Hotels.Hotel);
genstring += HotelListGenerate.GetAmenities("chknsmk", "Non Smoking", "Non Smoking", "Non Smoking", lstHotelCodes, MainTable.Hotels.Hotel);
genstring += HotelListGenerate.GetAmenities("chksmk", "Smoking Room", "Smoking Room", "Smoking Room", lstHotelCodes, MainTable.Hotels.Hotel);
genstring += HotelListGenerate.GetAmenities("chkAccessible", "Accessible", "Accessible", "Accessible", lstHotelCodes, MainTable.Hotels.Hotel);
genstring += HotelListGenerate.GetAmenities("chkpets", "Pets", "Pets Allowed", "Pets", lstHotelCodes, MainTable.Hotels.Hotel);
genstring += HotelListGenerate.GetAmenities("chkairport", "Airport", "Airport Access", "Airport", lstHotelCodes, MainTable.Hotels.Hotel);
genstring += HotelListGenerate.GetAmenities("chkbusineerec", "Business", "Business Travel", "Business", lstHotelCodes, MainTable.Hotels.Hotel);
genstring += HotelListGenerate.GetAmenities("chkpoolrec", "Outdoor", "The Outdoor Pool", "Outdoor", lstHotelCodes, MainTable.Hotels.Hotel);
genstring += HotelListGenerate.GetAmenities("chkkidsrec", "Kids", "Kid-friendly Travel", "Kids", lstHotelCodes, MainTable.Hotels.Hotel);
genstring += "</div></div>";
genstring += "<div class='clear-fltr-btn'><a href='#' id='clfilter' name='clfilters' onclick='ClearFilters()'>Clear All Filters</a></div>";
genstring += "<div class='close-filter'><a href='#' class='cf-apply' >Apply</a><a href='#' class='cf-close' onclick='CloseMobFilters()'>Close</a></div>";
genstring += "</div></div>";
string cityname = "";
try
{
cityname = vcity.Substring(0, vcity.IndexOf(','));
}
catch
{
cityname = vcity;
}
int htcount = 0;
if (objAvailabilityRS.Hotels.Hotel.Count() >= 350)
{
htcount = 350;
}
else
{
htcount = objAvailabilityRS.Hotels.Hotel.Count();
}
string hcount = htcount.ToString(); //(objAvailabilityRS.Hotels.Hotel.Count()).ToString();
string Maincount = htcount.ToString(); //MainTable.Hotels.Hotel.Count().ToString();
genstring += "<div id='divhotellist'>";
genstring += " <div class='inner-col-right col-md-9'> <div class='row'>";
//genstring += "<div class='bk-selct-bx'><select id='ddlCurrency' onchange='CCchange()'> ";
//if (currencycode == "USD")
//{
// genstring += "<option value='USD' selected='selected'>(USD) US dollar</option>";
//}
//else
//{
// genstring += "<option value='USD'>(USD) US dollar</option>";
//}
//if (currencycode == "CAD")
//{
// genstring += "<option value='CAD' selected='selected'>(CAD) Canadian dollar</option>";
//}
//else
//{
// genstring += "<option value='CAD'>(CAD) Canadian dollar</option>";
//}
//if (currencycode == "EUR")
//{
// genstring += "<option value='EUR' selected='selected'>(EUR) Euro</option>";
//}
//else
//{
// genstring += "<option value='EUR'>(EUR) Euro</option>";
//}
//if (currencycode == "GBP")
//{
// genstring += "<option value='GBP' selected='selected'>(GBP) British pound</option>";
//}
//else
//{
// genstring += "<option value='GBP'>(GBP) British pound</option>";
//}
//genstring += " </select></div>";
genstring += "<div class='inn-rht-menu'><div style='display:none' class='rht-menu-map'><i class='fa fa-map-marker' aria-hidden='true'></i>< a onclick='ShowAllinMap()'> Map</a> </div>";
genstring += "<div class='rht-menu-selctbx'><select id='ddlCurrency' onchange='CCchange()' disabled='disabled'> ";
if (currencycode == "USD")
{
genstring += "<option value='USD' selected='selected'>(USD) US dollar</option>";
}
else
{
genstring += "<option value='USD'>(USD) US dollar</option>";
}
//if (currencycode == "CAD")
//{
// genstring += "<option value='CAD' selected='selected'>(CAD) Canadian dollar</option>";
//}
//else
//{
// genstring += "<option value='CAD'>(CAD) Canadian dollar</option>";
//}
//if (currencycode == "EUR")
//{
// genstring += "<option value='EUR' selected='selected'>(EUR) Euro</option>";
//}
//else
//{
// genstring += "<option value='EUR'>(EUR) Euro</option>";
//}
//if (currencycode == "GBP")
//{
// genstring += "<option value='GBP' selected='selected'>(GBP) British pound</option>";
//}
//else
//{
// genstring += "<option value='GBP'>(GBP) British pound</option>";
//}
genstring += " </select></div></div>";
genstring += "<div class='inn-right-header'> <h2>" + cityname + " - <sapn class='htlcount'>" + hcount + " Hotels Selected of " + Maincount + " Hotels Found </span>" + "</h2></div>";
if (hcount == "0")
{
genstring += "<div class='resultsp-msg'><span>Please Clear the filters or change filters to get hotels list </span></div>";
}
genstring += " <div class='sortpagn'>";
genstring += HotelListGenerate.GetSortBydd(sortby, hcount);
genstring += HotelListGenerate.GetPagingHtmlTop(Convert.ToInt32(hcount), vpageno);
genstring += HotelListGenerate.GetHotellist(objAvailabilityRS, searchid, checkind, checkoutd, guestscount, currencycode, vpageno, b2c_idn, seladults, selchilds);
genstring += HotelListGenerate.GetPagingHtmlBottom(Convert.ToInt32(hcount), vpageno);
genstring += "</div>";
genstring += "<div><div>";
genstring += "<div><div>";
genstring += "<div>";
return(genstring);
}
private string GetHotellistPG(AvailabilityRS dtHList, string searchid, string checkind, string checkoutd, string guestcount, string selaudults, string selchilds, string sortby, int totalhotels, string currencycode, string b2c_idn)
{
string genstring = "";
string cityname = "";
try
{
cityname = vcity.Substring(0, vcity.IndexOf(','));
}
catch
{
cityname = vcity;
}
int htcount = 0;
if (dtHList.Hotels.Hotel.Count() >= 350)
{
htcount = 350;
}
else
{
htcount = dtHList.Hotels.Hotel.Count();
}
string hcount = htcount.ToString();
genstring += "<div id='divhotellist'>";
//genstring += "<div class='bk-selct-bx'><select id='ddlCurrency' onchange='CCchange()'> ";
//if (currencycode == "USD")
//{
// genstring += "<option value='USD' selected='selected'>(USD) US dollar</option>";
//}
//else
//{
// genstring += "<option value='USD'>(USD) US dollar</option>";
//}
//if (currencycode == "CAD")
//{
// genstring += "<option value='CAD' selected='selected'>(CAD) Canadian dollar</option>";
//}
//else
//{
// genstring += "<option value='CAD'>(CAD) Canadian dollar</option>";
//}
//if (currencycode == "EUR")
//{
// genstring += "<option value='EUR' selected='selected'>(EUR) Euro</option>";
//}
//else
//{
// genstring += "<option value='EUR'>(EUR) Euro</option>";
//}
//if (currencycode == "GBP")
//{
// genstring += "<option value='GBP' selected='selected'>(GBP) British pound</option>";
//}
//else
//{
// genstring += "<option value='GBP'>(GBP) British pound</option>";
//}
//genstring += " </select></div>";
genstring += " <div class='inner-col-right col-md-9'>";
genstring += " <div class='row'>";
genstring += "<div class='inn-rht-menu'><div style='display:none' class='rht-menu-map'><i class='fa fa-map-marker' aria-hidden='true'></i><a onclick='ShowAllinMap()'> Map</a> </div>";
genstring += "<div class='rht-menu-selctbx'><select id='ddlCurrency' onchange='CCchange()' disabled='disabled'> ";
if (currencycode == "USD")
{
genstring += "<option value='USD' selected='selected'>(USD) US dollar</option>";
}
else
{
genstring += "<option value='USD'>(USD) US dollar</option>";
}
//if (currencycode == "CAD")
//{
// genstring += "<option value='CAD' selected='selected'>(CAD) Canadian dollar</option>";
//}
//else
//{
// genstring += "<option value='CAD'>(CAD) Canadian dollar</option>";
//}
//if (currencycode == "EUR")
//{
// genstring += "<option value='EUR' selected='selected'>(EUR) Euro</option>";
//}
//else
//{
// genstring += "<option value='EUR'>(EUR) Euro</option>";
//}
//if (currencycode == "GBP")
//{
// genstring += "<option value='GBP' selected='selected'>(GBP) British pound</option>";
//}
//else
//{
// genstring += "<option value='GBP'>(GBP) British pound</option>";
//}
genstring += " </select></div></div>";
genstring += "<div class='inn-right-header'> <h2>" + cityname + " - <sapn class='htlcount'>" + hcount + " Hotels Selected of " + totalhotels + " Hotels Found</span>" + "</h2></div>";
if (hcount == "0")
{
genstring += "<div class='resultsp-msg'><span>Please Clear the filters or change filters to get hotels list </span></div>";
}
genstring += " <div class='sortpagn'>";
genstring += HotelListGenerate.GetSortBydd(sortby, hcount);
genstring += HotelListGenerate.GetPagingHtmlTop(Convert.ToInt32(hcount), vpageno);
genstring += GetHotellist(dtHList, searchid, checkind, checkoutd, guestcount, selaudults, selchilds, currencycode, b2c_idn);
genstring += HotelListGenerate.GetPagingHtmlBottom(Convert.ToInt32(hcount), vpageno);
genstring += "</div>";
genstring += "<div><div>";
genstring += "<div><div>";
genstring += "<div>";
return(genstring);
}
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);
}
