using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using MyClassLibrary;

public partial class MyOrder : System.Web.UI.Page
{

    protected void Page_Load(object sender, EventArgs e)
    {
        DataCall();
    }

    private void DataCall()
    {
        //Object gets created for use from the class(clsDataConduit)
        clsDataDictionary AnOrder = new clsDataDictionary();
        //Declaring a new SqlDataSource from the inbuilt class library
        SqlDataSource sqlDS_ItemTable = new SqlDataSource();
        //Using our datasource object being cast onto our objects connectionstring
        sqlDS_ItemTable.ConnectionString = AnOrder.ConnectionString;
        //Our sql statement being passed through to our .SelectCommand method
        sqlDS_ItemTable.SelectCommand = "Select * from tblOrders";
        //Adding controls to our SqlDataSource object
        this.Controls.Add(sqlDS_ItemTable);
        //Declares the DataSource for our gridview !
        grdOrder.DataSource = sqlDS_ItemTable;
        //Binds the data to refresh every time it's used
        grdOrder.DataBind();



    }


    protected void grdOrder_SelectedIndexChanged(object sender, EventArgs e)
    {
        Label bigStore = (Label)grdOrder.SelectedRow.Cells[2].FindControl("OrderId");

        clsStockCollection AnId = new clsStockCollection();

        clsStock TheOrder = new clsStock();
        TheOrder.OrderId = Convert.ToInt32(bigStore);
        AnId.DeleteOrder(TheOrder);
        DataCall();
    }
}