// placing orders // this populates the menu for the selected restaurant #region Bind Menu GridView private void BindMenuGridView(string restaurant) { DataTable dt = new DataTable(); SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["OrderistaConnectionString"].ConnectionString); try { connection.Open(); SqlCommand cmd = new SqlCommand("SELECT RestaurantName, Name, Price FROM Menu_Items WHERE Visible = 1 AND InStock = 1 AND RestaurantName = @restaurant"); cmd.Parameters.AddWithValue("@restaurant", restaurant); cmd.Connection = connection; SqlDataAdapter sqlData = new SqlDataAdapter(cmd); sqlData.Fill(dt); if (dt.Rows.Count > 0) { MenuGridView.DataSource = dt; MenuGridView.DataBind(); } } catch (SqlException ex) { string msg = "Fetch Error: "; msg += ex.Message; throw new Exception(msg); } finally { connection.Close(); } } // BindMenuGridView
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { MenuController controller = new MenuController(); var stuff = controller.GetRestaurantMenu(); MenuGridView.DataSource = stuff; MenuGridView.DataBind(); MenuRepeter.DataSource = stuff; MenuRepeter.DataBind(); } }