public ActionResult Restoran(string id)
{
MenuAndProducts menuAndProducts = new MenuAndProducts();
int _id = 0;
if (int.TryParse(id, out _id))
{
menuAndProducts.RestoranID = _id;
menuAndProducts = _restoranBusiness.GetMenuAndProducts(_id);
}
return(View(menuAndProducts));
}
public MenuAndProducts GetMenuAndProducts(int restoranId)
{
MenuAndProducts menuAndProducts = new MenuAndProducts();
string conString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
using (SqlConnection con = new SqlConnection(conString))
{
using (SqlCommand com = new SqlCommand("spGetMenuDetails", con))
{
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@id", restoranId);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
if (con.State == ConnectionState.Open)
{
using (SqlDataAdapter adapter = new SqlDataAdapter(com))
{
DataSet ds = new DataSet();
adapter.Fill(ds);
foreach (DataRow r in ds.Tables[1].Rows)
{
Menu menu = new Menu();
menu.ID = Convert.ToInt32(r["ID"]);
menu.MenuName = Convert.ToString(r["Menu"]);
menu.RestoranId = Convert.ToInt32(r["RestoranId"]);
menuAndProducts.menus.Add(menu);
}
foreach (DataRow productRow in ds.Tables[0].Rows)
{
Proizvod proizvod = new Proizvod();
proizvod.ID = Convert.ToInt32(productRow["ID"]);
proizvod.ProizvodIme = Convert.ToString(productRow["Proizvod"]);
proizvod.Cena = Convert.ToDecimal(productRow["Cena"]);
proizvod.Opis = Convert.ToString(productRow["Opis"]);
proizvod.MenuId = Convert.ToInt32(productRow["MenuId"]);
menuAndProducts.proizvods.Add(proizvod);
}
}
}
}
}
return(menuAndProducts);
}
