protected void Upload(object sender, EventArgs e)
 {
     RobotTableAdapters.documents_attachmentTableAdapter robotAttachment = new RobotTableAdapters.documents_attachmentTableAdapter();
     string filename = new FileUploader().uploadFile(FileUpload1); int documentId = 0;
     int collateralId = Convert.ToInt32(Request.QueryString["collateralId"]); 
     int CollateralTypeId = Convert.ToInt32(Request.QueryString["CollateralTypeId"]);
     int CollateralDetailsId = Convert.ToInt32(hiddenDetailsId.Text);
     
     if ((hiddenDocID.Text) != null & (hiddenDocID.Text != ""))
     {
         //return;
         documentId = Convert.ToInt32(hiddenDocID.Text);
         //robotAttachment.Insert(filename, documentId, collateralId);
         robotAttachment.proc_AllocateFileToDocument(filename, documentId, collateralId, CollateralDetailsId, CollateralTypeId,Smart.GetEmployeeID());         
         
         TextBox1.Text = documentId.ToString();
     }
     else
     {
         
         robotAttachment.proc_AllocateFileToDocument(filename, Convert.ToInt32(TextBox1.Text), collateralId, CollateralDetailsId, CollateralTypeId, Smart.GetEmployeeID());
     } 
     UpdateDocumentCategory();
 docGrid.DataBind();
 }
    protected void Upload(object sender, EventArgs e)
    {
		RobotTableAdapters.documents_attachmentTableAdapter robotAttachment = new RobotTableAdapters.documents_attachmentTableAdapter();
        string filename = new FileUploader().uploadFile(FileUpload1); int documentId = 0;
        int collateralId = Convert.ToInt32(Request.QueryString["collateralId"]); 
        if ((hiddenDocID.Text) != null & (hiddenDocID.Text != ""))
        {
            //return;
            documentId = Convert.ToInt32(hiddenDocID.Text);
            robotAttachment.proc_AllocateFileToDocument(filename, documentId, collateralId);
            TextBox1.Text = documentId.ToString();
        }
        else
        {
            robotAttachment.proc_AllocateFileToDocument(filename, Convert.ToInt32(TextBox1.Text), collateralId);         
        } 
    }