public ActionResult AutocompleteAsync(string term)
{
List<string> townList = new System.Collections.Generic.List<string>();
using (AllConection tmp = new AllConection())
{
townList = (from a in tmp.Towns where a.name.StartsWith(term) select a.name).Take(10).ToList();
}
var ret = townList;
return Json(ret, JsonRequestBehavior.AllowGet);
}
public JsonResult AutocompleteSuggestions(string term)
{
/* List<string> townList = new System.Collections.Generic.List<string>();
using (DanicoProject.Models.AllConection tmp = new Models.AllConection())
{
var suggestions = from s in tmp.Towns select s.name;
townList = suggestions.Where(n => n.ToLower().StartsWith(term.ToLower())).ToList();
}*/
AllConection db = new AllConection();
var suggestions = from s in db.Towns select s.name;
var namelist = suggestions.Where(n => n.ToLower().StartsWith(term.ToLower())).ToList();
// return namelist.ToList();
return Json(namelist, JsonRequestBehavior.AllowGet);
}
public ActionResult Search(string search, string[] orderNumbers)
{
ViewBag.townFilter = search;
ViewBag.checkList = orderNumbers;
List<long?> serviceIdInDB = varHotel.getServiceID(orderNumbers);
List<Models.Hotel> hotelList = new List<Models.Hotel>();
using (AllConection tmp = new AllConection())
{
//1s filter
if (!String.IsNullOrEmpty(search))
{
hotelList = tmp.Hotels.Select(a => a).ToList();
long idTown = varHotel.getIdTown(search);
//2d filter
if (idTown > -1)
{
hotelList = hotelList.Where(s => s.fk_idTown.Equals(idTown)).ToList();
//3d filter
if (serviceIdInDB.Count > 0)
{
List<long> hotelListIDs = hotelList.ConvertAll(obj => obj.pk_idHotel).ToList();
hotelList =
(from hotel in tmp.Hotels
join service in tmp.HotelServices on hotel.pk_idHotel equals service.idHotel
where hotelListIDs.Contains(hotel.pk_idHotel)
where serviceIdInDB.Contains(service.idService)
select hotel).Distinct().ToList<Models.Hotel>();
}
}
}
}
return View(hotelList);
}