internal Hotel getDetails(long id) { Hotel hotelRet = new Hotel(); using (AllConection db = new AllConection()) { // idTown = Convert.ToInt32(db.Towns.Where(n => n.name.ToLower().Equals(term.ToLower())).Select(a=>a.pk_idTown)); hotelRet = db.Hotels.Single(v => v.pk_idHotel == id); } return hotelRet; }
internal long getIdTown(string term) { long idTown = 0; try { using (AllConection db = new AllConection()) { // idTown = Convert.ToInt32(db.Towns.Where(n => n.name.ToLower().Equals(term.ToLower())).Select(a=>a.pk_idTown)); idTown = Convert.ToInt32((from c in db.Towns where c.name.ToLower().Equals(term.ToLower()) select c.pk_idTown).Single()); } } catch (Exception) { return -1; } return idTown; }
public IList<Town> getTowns(string term) { IList<Town> townList; using (AllConection db = new AllConection()) { townList = db.Towns.Where(n => n.name.ToLower().StartsWith(term.ToLower())).ToList(); townList = townList.Take(10).ToList(); /*townList = (from c in db.Towns where c.name.ToLower().StartsWith(term.ToLower()) select new Town { pk_idTown = c.pk_idTown, name = c.name }).ToList(); townList = townList.Take(10).ToList();*/ } return townList; }