// 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));
}
}
