protected void SubmitCheckedDoc_Click(object sender, EventArgs e)
    {
        //initialize values
        int collateralId = Convert.ToInt32(Request.QueryString["collateralId"]);
        int CollateralTypeId = Convert.ToInt32(Request.QueryString["CollateralTypeId"]);
        int CollateralDetailsId = Convert.ToInt32(hiddenDetailsId.Text);


        RobotTableAdapters.documents_submittedTableAdapter robotDocs = new RobotTableAdapters.documents_submittedTableAdapter();
        RobotTableAdapters.documents_attachmentTableAdapter robotAttachment = new RobotTableAdapters.documents_attachmentTableAdapter();

        //delete should happen before insert, just incase the guy goes back to check or uncheck documents in the checklist tab

        robotDocs.DeleteExistingCheckedDocs(collateralId, CollateralDetailsId, CollateralTypeId);
        foreach (ListItem item in CheckBoxList1.Items)
        {
            if (item.Selected)
            {
                robotDocs.Insert(Convert.ToInt32(item.Value), collateralId, CollateralDetailsId, CollateralTypeId, 1, Smart.GetEmployeeID());
            }
        }

        //popolate the documents for attachment
        //robotAttachment.proc_DeleteAlreadyPopulatedDocsBeforeInsert(collateralId, CollateralDetailsId, CollateralTypeId);
        //robotAttachment.Proc_populateDocumentsAttachment(collateralId.ToString(), CollateralDetailsId.ToString(), CollateralTypeId.ToString());


        ASPxGridView1.DataBind();
       ASPxGridView2.DataBind();

        //enable and move focus to next tab, disable current tab
        ASPxPageControl1.TabPages[2].Enabled = true;
        ASPxPageControl1.TabPages[1].Enabled = true;
        ASPxPageControl1.TabPages[0].Enabled = true;

        ASPxPageControl1.ActiveTabIndex = 2;

    }
    protected void SubmitCheckedDoc_Click(object sender, EventArgs e)
    {
        //initialize values
        int collateralId = Convert.ToInt32(Request.QueryString["collateralId"]);
        int CollateralTypeId = Convert.ToInt32(Request.QueryString["CollateralTypeId"]);
        int CollateralDetailsId = Convert.ToInt32(hiddenDetailsId.Text);


        RobotTableAdapters.documents_submittedTableAdapter robotDocs = new RobotTableAdapters.documents_submittedTableAdapter();

        foreach (ListItem item in CheckBoxList1.Items)
        {
            if (item.Selected)
            {
                robotDocs.Insert(Convert.ToInt32(item.Value), collateralId, CollateralDetailsId, CollateralTypeId, 1, Smart.GetEmployeeID());
            }
        }

           ASPxGridView1.DataBind();
        //enable and move focus to next tab, disable current tab
        ASPxPageControl1.TabPages[2].Enabled = true;
        ASPxPageControl1.TabPages[1].Enabled = true;
        ASPxPageControl1.TabPages[0].Enabled = true;

        ASPxPageControl1.ActiveTabIndex = 2;

    }