protected void Page_Load(object sender, EventArgs e)
    {
        try
        {
            if (Request.QueryString.Get("id") != null)
            {
                int idProduct = Convert.ToInt16(Request.QueryString.Get("id"));

                Products product = new Products();
                DataTable dt;

                dt = product.getProductByID(idProduct);

                if (dt != null && dt.Columns[0].Caption == "Product_Not_Exists")
                {
                    Response.Redirect(webURL + "views/products/viewallproducts.aspx?action=notify&id=3", false);
                }
                else if (dt.Rows.Count == 1)
                {
                    this.productid = dt.Rows[0].ItemArray[0].ToString();
                    this.name = dt.Rows[0].ItemArray[1].ToString();

                    DetailsView1.DataSource = dt;
                    DetailsView1.DataBind();
                }
                else
                {
                    Response.Redirect(webURL + "views/products/viewallproducts.aspx?action=notify&id=3", false);
                }

            }
            else
            {
                Response.Redirect(webURL + "views/products/viewallproducts.aspx");
            }
        }
        catch (Exception ex)
        {
            Response.Redirect(webURL + "views/products/viewallproducts.aspx?action=notify&id=2");
        }
    }
    /// <summary>
    /// Method to loads the form with the data of the selected Product
    /// </summary>
    /// <param name="idCustomer">Int ID of the Product</param>
    protected void loadForm(int idProduct)
    {
        Products product = new Products();
        product.idProduct = idProduct;

        product.getProductByID();

        if (product.idProduct != 0)
        {
            HiddenField1.Value = product.idProduct.ToString();
            TextBox1.Text = product.Name;
            TextBox2.Text = product.Amount.ToString();
            TextBox3.Text = product.Price.ToString() ;
            TextBox4.Text = product.Description;
            DropDownList1.SelectedValue = product.idPresentation.ToString();
            TextBox5.Text = product.ExpirationDate.ToString("dd/MM/yyyy");
        }
        else
        {
            Response.Redirect(webURL + "views/products/viewallproducts.aspx?action=notify&id=3", false);
        }
    }