I want related data when i select star rating

This is my Controller code

using Newtonsoft.Json;

using Newtonsoft.Json.Linq;

using System;

using System.Collections.Generic;

using System.ComponentModel.DataAnnotations;

using System.IO;

using System.IO.Compression;

using System.Linq;

using System.Net;

using System.Net.Http;

using System.Net.Http.Headers;

using System.Runtime.Serialization.Json;

using System.Text;

using System.Web;

using System.Web.Mvc;

using System.Xml.Linq;

using HotelServices;

using HotelApiServices;

using System.Configuration;

using System.Threading.Tasks;

using System.Web.Helpers;

using HotelApIResult.Models;

namespace HotelApIResult.Controllers

{

public class HomeController : Controller

{

private HotelDBEntities2 hotelCity = new HotelDBEntities2();

private HotelDBEntities7 hotel = new HotelDBEntities7();

private string BaseUriUpToCityData = ConfigurationManager.AppSettings["BaseuriUpToCity"];

private string BaseUriFormHotelSearch = ConfigurationManager.AppSettings["BaseuriFormHotelSearch"];

private string ClientId= ConfigurationManager.AppSettings["ClientId"];

private string Username = ConfigurationManager.AppSettings["UserName"];

private string Password = ConfigurationManager.AppSettings["Password"];

ApiLogics apiServices = new ApiLogics();

SearchApI.Generate GsearchApI = new SearchApI.Generate();

SearchApI searchApI = new SearchApI();

static GetIp g = new GetIp();

private string ip = g.GettingIP();

public HotelAuthDbClass hadc = new HotelAuthDbClass();

public LogicsforRooms logicsfor = new LogicsforRooms();

public ActionResult Index()

{

return View();

}

public ActionResult Filter()

{

return View();

}

public ActionResult Filter123()

{

return View();

}

[HttpPost]

public ActionResult Index(SearchModel sm)

{

if (sm.CheckinDate != null & sm.CheckoutDate != null & sm.CityName != null & sm.NoOfAdults > 0 & sm.NoOfRooms > 0)

{

TempData["Search"] = sm;

string url = string.Format("/Home/HotelResults?Search={0}",JsonConvert.SerializeObject(sm));

return Redirect(url);

}

return View();

}

public ActionResult ToAuthenticaTE()

{

HotelAuth ha = new HotelAuth();

string date =Convert.ToString(DateTime.Now.ToUniversalTime());

string fer = GetAthu();

JObject jObject=(JObject) JsonConvert.DeserializeObject(fer);

JObject member = (JObject)jObject["Member"];

ha = member.ToObject();

ha.TokenId =(string) jObject["TokenId"];

if(ha.LoginDeatails==null)

{

ha.LoginDeatails = date;

}

bool result = hadc.SaveAuth(ha);

return View();

}

public ActionResult About()

{

ViewBag.Message = "Your application description page.";

return View();

}

public ActionResult Contact(string RoomIndexs)

{

if (RoomIndexs == null)

{

return RedirectToAction("Error");

}

HotelRoomsDetails hd = JsonConvert.DeserializeObject(RoomIndexs);

//int i =Convert.ToInt32(Request.QueryString["RoomIndexs"]);

return View(hd);

}

[HttpPost]

public JsonResult auto(string prefix)

{

var CityList = (from N in hotel.DestinationList1

where N.CityName.StartsWith(prefix)

select new { N.CityName });

return Json(CityList, JsonRequestBehavior.AllowGet);

}

public ActionResult Error()

{ return View(); }

public ActionResult CancelationPolicy()

{

string matter = Request.QueryString["matter"].ToString();

return PartialView();

}

public ActionResult HotelResults(string Search)

{

SearchModel sm = JsonConvert.DeserializeObject(Search);

SearchModel search = TempData["Search"] as SearchModel;

if(sm.CityName==null)

{ return RedirectToAction("Index", "Home"); }

var ges=hotel.DestinationList1.Where(s => s.CityName == sm.CityName).FirstOrDefault();

ViewBag.CityName = ges.CityName;

var res = GetHotelSearch(sm,ges.CityId,ges.CountryCode).ToList();

ViewBag.Count = res.Count;

if(res==null)

{

ViewBag.Message = "No Results Found";

}

return View(res);

}

public ActionResult HotelInfos()

{

var fer = getHotelInfo();

ViewBag.Msg = GetHotelRooms();

return View(fer);

}

[HttpPost]

public JsonResult Rating(string Ger)

{

var Af = Ger;

ViewBag.message();

return Json(Af, JsonRequestBehavior.AllowGet);

}

public string GetAthu()

{

Authenticate at = new Authenticate();

at.ClientId = ClientId;

at.UserName = Username;

at.Password = Password;

at.EndUserIp = ip.Replace(" ", "");

string str = JsonConvert.SerializeObject(at);

string st = apiServices.GetApiAuthenticate(str,BaseUriUpToCityData);

return st;

}

public string GetCountryList()

{

string stringData = null;

string tid = hadc.GetTokenId();

var response1 = string.Empty;

CountryRequest cf = new CountryRequest();

cf.ClientId = ClientId;

cf.TokenId = tid;

cf.EndUserIp = ip.Replace(" ", "");

try

{

HttpClient client = new HttpClient();

client.BaseAddress = new Uri(BaseUriUpToCityData);

MediaTypeWithQualityHeaderValue contentType = new MediaTypeWithQualityHeaderValue("application/json");

client.DefaultRequestHeaders.Accept.Add(contentType);

var contentData = new StringContent(JsonConvert.SerializeObject(cf), System.Text.Encoding.UTF8, "application/json");

HttpResponseMessage response = client.PostAsync("rest/CountryList", contentData).Result;

stringData = response.Content.ReadAsStringAsync().Result;

string str = stringData;

var obj = JsonConvert.DeserializeObject(str);

Console.WriteLine(obj.Countrylist);

int status = obj.Status;

if (status == 1)

{

string countryListData = obj.Countrylist;

XDocument doc = XDocument.Parse(countryListData);

var CountryCodes = from service in doc.Descendants("Country")

select (string)service.Element("Code");

var CountryNames = from service in doc.Descendants("Country")

select (string)service.Element("Name");

CountryList ct = new CountryList();

foreach (var item in CountryCodes.Zip(CountryNames, (a, b) => new { A = a, B = b }))

{

var a = item.A;

var b = item.B;

ct.Code = a;

ct.Name = b;

hotelCity.CountryLists.Add(ct);

hotelCity.SaveChanges();

}

catch(WebException ex)

{

ViewBag.Ex = ex;

}

return stringData;

}

public string GetDestinationList()

{

string str = null;

var has = hotel.DestinationList1.Select(b => b.CityId).ToList();

var response1 = string.Empty;

DestinationRequest cf = new DestinationRequest();

cf.ClientId = ClientId;

cf.TokenId = hadc.GetTokenId();

cf.EndUserIp = ip.Replace(" ", "");

DestinationList1 cd = new DestinationList1();

try

{

if (has != null)

{

foreach (string st in has)

{

cf.CountryCode = st;

HttpClient client = new HttpClient();

client.BaseAddress = new Uri(BaseUriUpToCityData);

MediaTypeWithQualityHeaderValue contentType = new MediaTypeWithQualityHeaderValue("application/json");

client.DefaultRequestHeaders.Accept.Add(contentType);

var contentData = new StringContent(JsonConvert.SerializeObject(cf), System.Text.Encoding.UTF8, "application/json");

HttpResponseMessage response = client.PostAsync("rest/DestinationCityList", contentData).Result;

string stringData = response.Content.ReadAsStringAsync().Result;

str = stringData;

var de = JsonConvert.DeserializeObject(str);

int Status = de.Status;

string dsl = de.DestinationCityList;

if (de.DestinationCityList != "No City Found for the same combination.")

{

XDocument sda = XDocument.Parse(dsl);

if (Status == 1)

{

var Citycode = from service in sda.Descendants("City") select (string)service.Element("CityId");

var CityName = from service in sda.Descendants("City") select (string)service.Element("CityName");

var Countrycodes = from service in sda.Descendants("City") select (string)service.Element("CountryCode");

var ff = Countrycodes.ToList();

var fc = Citycode.ToList();

var fn = CityName.ToList();

foreach (var desn in fc.Zip(fn, Tuple.Create))

{

cd.CityId = (desn.Item1);

cd.CityName = desn.Item2;

cd.CountryCode = st;

hotel.DestinationList1.Add(cd);

hotel.SaveChanges();

}

catch(WebException ex)

{

ViewBag.csg = ex.Response.ToString();

}

return str;

}

[HttpPost]

public IEnumerable GetHotelSearch(SearchModel se,string CityId,string CountryCode)

{

IEnumerable htl = null;

string date = apiServices.dateChange(se.CheckinDate);

int dt = apiServices.getDays(se.CheckinDate, se.CheckoutDate);

string ge = hadc.GetTokenId();

Hotelsearch htlsr = new Hotelsearch();

htlsr.RoomGuests = logicsfor.RoomDivideLogic(se);

htlsr.CheckInDate = date;

htlsr.NoOfNights = dt;

htlsr.CountryCode = CountryCode;

htlsr.CityId = int.Parse(CityId);

htlsr.ResultCount = 0;

htlsr.PreferredCurrency = "INR";

htlsr.GuestNationality = "IN";

htlsr.NoOfRooms = se.NoOfRooms;

htlsr.PreferredHotel = "";

htlsr.MaxRating = 5;

htlsr.MinRating = 0;

//htlsr.ReviewScore = 0.0;

htlsr.isNearBySearchAllowed = false;

htlsr.EndUserIp = ip.Replace(" ", "");

htlsr.TokenId = ge;

string sr = JsonConvert.SerializeObject(htlsr);

string hotelresult =GsearchApI.GetHotelSearch(BaseUriFormHotelSearch,sr);

JObject jObject = (JObject)JsonConvert.DeserializeObject(hotelresult);

JObject json = (JObject)jObject["HotelSearchResult"];

if (json == null)

{

Response.Write(hotelresult);

}

else

{

string Traceid = (string)json["TraceId"];

Session["TId"] = Traceid;

int ResponseStatus = (Int32)json["ResponseStatus"];

if (ResponseStatus == 1)

{

JArray hotellist = (JArray)json["HotelResults"];

if (hotellist != null)

{

htl = hotellist.ToObject>();

}

else

{ htl = null; }

}

return htl;

}

public HotelInfoResponse getHotelInfo()

{

string hotelinforesponse = null;

HotelInfoRequest hir = new HotelInfoRequest();

hir.EndUserIp = ip.Replace(" ", "");

hir.HotelCode = Request.QueryString["HotelCode"];

hir.ResultIndex = Convert.ToInt32(Request.QueryString["ResultIndex"]);

string tid = hadc.GetTokenId();

hir.TokenId = tid;

hir.TraceId = Session["TId"].ToString();

hir.ResultIndex = Convert.ToInt32(Request.QueryString["ResultIndex"]);

hir.HotelCode = Request.QueryString["Hotel Code"];

string sr = JsonConvert.SerializeObject(hir);

HotelInfoResponse hf = new HotelInfoResponse();

HttpClient hc = new HttpClient();

hc.BaseAddress = new Uri("http://api.tektravels.com/BookingEngineService_Hotel/hotelservice.svc/");

hotelinforesponse = searchApI.GetHotelInfo(BaseUriFormHotelSearch, sr);

JObject jObject = (JObject)JsonConvert.DeserializeObject(hotelinforesponse);

JObject json = (JObject)jObject["HotelInfoResult"];

if (json == null)

{

Response.Write(hotelinforesponse);

//hf = null;

}

else

{

int status = (Int32)json["ResponseStatus"];

if (status == 1)

{

hf = json["HotelDetails"].ToObject();

hf.HotelRoomsDetails = GetHotelRooms() as List;

}

return hf;

}

public IEnumerable GetHotelRooms()

{

IEnumerable hr = null;

HotelInfoRequest hir = new HotelInfoRequest();

hir.EndUserIp = ip.Replace(" ", "");

hir.HotelCode = Request.QueryString["HotelCode"];

hir.ResultIndex = Convert.ToInt32(Request.QueryString["ResultIndex"]);

string tid = hadc.GetTokenId();

hir.TokenId = tid;

hir.TraceId = Session["TId"].ToString();

try

{

HttpClient httpClient = new HttpClient();

httpClient.BaseAddress = new Uri(BaseUriFormHotelSearch);

httpClient.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));

var data = new StringContent(JsonConvert.SerializeObject(hir), Encoding.UTF8, "application/json");

HttpResponseMessage httpResponse = httpClient.PostAsync("rest/GetHotelRoom", data).Result;

string responseData = httpResponse.Content.ReadAsStringAsync().Result;

JObject jObject = (JObject)JsonConvert.DeserializeObject(responseData);

JObject json = (JObject)jObject["GetHotelRoomResult"];

int Status = (Int32)json["ResponseStatus"];

if (Status == 1)

{

hr = json["HotelRoomsDetails"].ToObject>();

}

catch(WebException es)

{

ViewBag.Rsg = es.Response.ToString();

}

return hr;

}

public class countrys

{

public int Status { get; set; }

public string Countrylist { get; set; }

}

public class Hotelsearch

{

public string CheckInDate { get; set; }

public int NoOfNights { get; set; }

public string CountryCode { get; set; }

public int CityId { get; set; }

public int ResultCount { get; set; }

public string PreferredCurrency { get; set; }

public string GuestNationality { get; set; }

public int NoOfRooms { get; set; }

public List RoomGuests { get; set; }

public string PreferredHotel { get; set; }

public int MaxRating { get; set; }

public int MinRating { get; set; }

public decimal ReviewScore { get; set; }

public bool isNearBySearchAllowed { get; set; }

public string EndUserIp { get; set; }

public string TokenId { get; set; }

}

public class RoomGsts

{

public int NoOfAdults { get; set; }

public int NoOfChild { get; set; }

public List ChildAge { get; set; }

}

public class HotelResult

{

public int ResultIndex { get;set;}

public string HotelCode { get; set; }

public string HotelName { get; set; }

public int StarRating { get; set; }

public string HotelCategory { get; set; }

public string HotelDescription { get; set; }

public string HotelPromotion { get; set; }

public string HotelPolicy { get; set; }

public Price Price { get; set; }

public string HotelPicture { get; set; }

public string HotelAddress { get; set; }

public string Latitude { get; set; }

public string Longitude { get; set; }

}

public class Price

{

public string CurrencyCode { get; set; }

public decimal RoomPrice { get; set; }

public decimal Discount { get; set; }

public decimal ServiceTax { get; set; }

public decimal OfferedPriceRoundedOff { get; set; }

}

public class HotelInfoRequest

{

public int ResultIndex { get; set; }

public string HotelCode { get; set; }

public string EndUserIp { get; set; }

public string TokenId { get; set; }

public string TraceId { get; set; }

}

public class HotelInfoResponse

{

public string HotelCode { get; set; }

public string HotelName { get; set; }

public int StarRating { get; set; }

public string Description { get; set; }

public string HotelPolicy { get; set; }

public string HotelPicture { get; set; }

public List Images { get; set; }

public string Address { get; set; }

public string CountryName { get; set; }

public string HotelContactNo { get; set; }

public string FaxNumber { get; set; }

public string PinCode { get; set; }

public string Email { get; set; }

public List HotelRoomsDetails { get; set; }

public RoomCombinations RoomCombinations { get; set; }

public List HotelFacilities { get; set; }

public List Attractions { get; set; }

}

public class Attractions

{

public string Key { get; set; }

public string Value { get; set; }

}

public class RoomCombinations

{

public string InfoSource { get; set; }

public List RoomCombination { get; set; }

}

public class RoomCombination

{

public List RoomIndex { get; set; }

}

public class HotelRoomsDetails

{

public int RoomIndex { get; set; }

public string RatePlanCode { get; set; }

public string RatePlanName { get; set; }

public string RoomTypeName { get; set; }

public string InfoSource { get; set; }

public string SequenceNo { get; set; }

public string RoomPromotion { get; set; }

public List Amenities { get; set; }

public List DayRates { get; set; }

public Price Price { get; set; }

public string SmokingPreference { get; set; }

public string CancellationPolicy { get; set; }

}

public class DayRates

{

public decimal Amount { get; set; }

public string Date { get; set; }

}

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vasanth Kumar8y ago
So please tell me and send me the code for How to get hotels when i give Star Rating using WebApi in mvc.
Vasanth Kumar8y ago
This my View code
@model HotelApIResult.Models.SearchModel
@{
ViewBag.Title = "Index";
List list = new List()
{
new SelectListItem{Value="1",Text="1"},
new SelectListItem{Value="2",Text="2"},
new SelectListItem{Value="3",Text="3"},
new SelectListItem{Value="4",Text="4"},
new SelectListItem{Value="5",Text="5"},
new SelectListItem{Value="6",Text="6"},
new SelectListItem{Value="7",Text="7"},
new SelectListItem{Value="8",Text="8"},
new SelectListItem{Value="9",Text="9"},
new SelectListItem{Value="10",Text="10"},
new SelectListItem{Value="11",Text="11"},
new SelectListItem{Value="12",Text="12"}
};
}

Loading

Close

Hotel

I want related data when i select star rating

4 Replies

Where would you like to go?

Hot Sale Today: Paris, Amsterdam, Saint Petersburg & more

Top Travel Destinations

Travel Magazine

Five festivals to look forward to this year

Five festivals to look forward to this year

Five festivals to look forward to this year

Five festivals to look forward to this year

Thailand by Train with Eastern and Oriental Express

Thailand by Train with Eastern and Oriental Express

Thailand by Train with Eastern and Oriental Express

Thailand by Train with Eastern and Oriental Express

Book with confidence

No booking charges

No cancellation fees

Instant confirmation

Flexible booking

Subscribe to our newsletter

Follow us

I want related data when i select star rating

Where would you like to go?

Modal Window

Hot Sale Today: Paris, Amsterdam, Saint Petersburg & more

Top Travel Destinations

Travel Magazine

Five festivals to look forward to this year

Five festivals to look forward to this year

Five festivals to look forward to this year

Five festivals to look forward to this year

Thailand by Train with Eastern and Oriental Express

Thailand by Train with Eastern and Oriental Express

Thailand by Train with Eastern and Oriental Express

Thailand by Train with Eastern and Oriental Express

Book with confidence

No booking charges

No cancellation fees

Instant confirmation

Flexible booking

Subscribe to our newsletter

Follow us