public ActionResult StatePersistence()
{
MyTestApplicationDBEntities1 db = new MyTestApplicationDBEntities1();
List <tbl_Order> _Orders = db.tbl_Order.ToList();
return(View(_Orders));
}
public List <tbl_country> GetCountryList()
{
MyTestApplicationDBEntities1 db = new MyTestApplicationDBEntities1();
List <tbl_country> countries = db.tbl_country.ToList();
return(countries);
}
public ActionResult GetStateList(int CountryId)
{
MyTestApplicationDBEntities1 db = new MyTestApplicationDBEntities1();
List <tbl_state> stateList = db.tbl_state.Where(x => x.CountryId == CountryId).ToList();
ViewBag.StateOptions = new SelectList(stateList, "StateId", "StateName");
return(PartialView("StateOptionsPartial"));
}
public JsonResult GetSuggestion(string text)
{
MyTestApplicationDBEntities1 db = new MyTestApplicationDBEntities1();
List <string> list = new List <string>();
list = db.tbl_myShop.Where(x => x.ItemName.ToLower().Contains(text.ToLower())).Select(x => x.ItemName).ToList();
return(Json(list, JsonRequestBehavior.AllowGet));
}
