private void BindData()
 {
     Product prod = new Product();
     prod.GetAllProducts();
     uiGridViewProducts.DataSource = prod.DefaultView;
     uiGridViewProducts.DataBind();
 }
        private void LoadDDLs()
        {
            Users users = new Users();
            users.GetAllUsers();
            uiDropDownListUsers.DataSource = users.DefaultView;
            uiDropDownListUsers.DataTextField = "DisplayName";
            uiDropDownListUsers.DataValueField = "UserID";
            uiDropDownListUsers.DataBind();
            uiDropDownListUsers.Items.Insert(0, new ListItem("Choose user", ""));

            Product product = new Product();
            product.GetAllProducts();
            uiDropDownListProducts.DataSource = product.DefaultView;
            uiDropDownListProducts.DataTextField = "Name";
            uiDropDownListProducts.DataValueField = "ProductID";
            uiDropDownListProducts.DataBind();
            uiDropDownListProducts.Items.Insert(0, new ListItem("Choose product", ""));

            OrderStatus orderStatus = new OrderStatus();
            orderStatus.LoadAll();
            uiDropDownListStatus.DataSource = orderStatus.DefaultView;
            uiDropDownListStatus.DataTextField = "Name";
            uiDropDownListStatus.DataValueField = "OrderStatusID";
            uiDropDownListStatus.DataBind();
            uiDropDownListStatus.Items.Insert(0, new ListItem("Choose status", ""));
        }