protected void Page_Load(object sender, EventArgs e)
    {
        IIdentity id = User.Identity;

        headcode = Convert.ToInt32(User.Identity.Name);
        if (!IsPostBack)
        {
            List <Requisition> r     = d.DHgetRequisitionItems(headcode);
            List <dynamic>     item  = new List <dynamic>();
            List <dynamic>     items = new List <dynamic>();
            if (r.Count > 0)
            {
                foreach (Requisition i in r)
                {
                    item = d.getItems(i.requisitionid).ToList();
                    items.AddRange(item);
                }

                //if (items != null)
                //{
                GridView1.DataSource = items;
                GridView1.DataBind();
                GenerateUniqueData(0);
            }
            else
            {
                GridView1.Visible = false;
                Label1.Text       = "No requests exist currently";
            }
            //}
            //else
            //{
            //    GridView1.DataSource = null;
            //    GridView1.DataBind();
            //    Label1.Text = "No requests exist currently";
            //}
        }
    }