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