// GET: RestaruantPrices public ActionResult RestaurantPrices() { var RestaurantPrices = new RestaruantPricesModels() { }; return(View(RestaurantPrices)); }
public ActionResult GetPrices() { using (var sql = new Tools.OurSql()) { List <RestaruantPricesModels> priceList = new List <RestaruantPricesModels>(); var rdr = sql.Query(""); while (rdr.Read()) { var priceData = new RestaruantPricesModels() { FoodName = rdr.GetString(0), FoodCategory = rdr.GetString(1), FoodId = rdr.GetDecimal(2), CostPrice = rdr.GetDecimal(3), ListPrice = rdr.GetDecimal(4) }; priceList.Add(priceData); } return(Json(new { priceList }, JsonRequestBehavior.AllowGet)); } }