public JsonResult AutoCompleteGetSearch(string term) { LinqRestaurant linqRestaurant = new LinqRestaurant(); LinqVille linqVille = new LinqVille(); var resultVille = linqVille.GetVilleByValue(term.ToLower()); var resultRestaurant = linqRestaurant.Search(term.ToLower()); var result = resultVille.Union<object>(resultRestaurant); return Json(result, JsonRequestBehavior.AllowGet); }
public JsonResult AutoCompleteGetVille(string term) { LinqVille linqVille = new LinqVille(); var result = linqVille.GetVilleByValue(term); return Json(result, JsonRequestBehavior.AllowGet); }
public ActionResult Proposer(ViewModelAddRestaurant model, bool EmptyVille) { LinqCuisine linqCuisine = new LinqCuisine(); if (ModelState.IsValid) { Restaurants view_newRestaurant = model.m_restaurant; Ville view_ville = model.m_ville; Adresse view_addresse = model.m_adresse; Notation view_notation = model.m_notation; view_newRestaurant.lb_nom = System.Globalization.CultureInfo.CurrentCulture.TextInfo.ToTitleCase(view_newRestaurant.lb_nom); LinqRestaurant linqRestautant = new LinqRestaurant(); int result = linqRestautant.ExistRestaurant(view_newRestaurant.lb_nom, view_addresse.lb_rue, view_addresse.lb_codepostal, view_ville.lb_ville); if (result>0) return RedirectToAction("Index", "Home"); LinqVille linqVille = new LinqVille(); var existingCity = linqVille.GetVilleFirst(view_ville.lb_ville.ToLower()); using(var db = new RestaurantDbContext()) { if ((EmptyVille) && existingCity == null) { view_ville.lb_ville = char.ToUpper(view_ville.lb_ville[0]) + view_ville.lb_ville.Substring(1); view_addresse.lb_rue = view_addresse.lb_rue.Replace(",", ""); db.db_ville.Add(view_ville); db.db_addresse.Add(view_addresse); } else { view_addresse.lb_rue = view_addresse.lb_rue.Replace(",", ""); db.db_ville.Attach(existingCity); existingCity.Adresses.Add(view_addresse); } foreach (string typeCuisine in model.SelectedItemsCuisine) { TypeCuisine existingCuisine = linqCuisine.GetCuisineFirst(int.Parse(typeCuisine)); db.db_typecuisine.Attach(existingCuisine); existingCuisine.Restaurants.Add(view_newRestaurant); } view_newRestaurant.Notations.Add(view_notation); db.SaveChanges(); } return RedirectToAction("Index", "Home"); } model.ItemsCuisine = linqCuisine.GetAllCuisine(); return View(model); }