[Solved] Attachment column - show only record related attachment links

[Felice]

I have an attachment column that, in edit mode, allow to upload and save attachment in a folder named "Allegati".

<telerik:GridAttachmentColumn FileName="attachment" FilterControlAltText="Filter columnAllegati column" HeaderText="Allegati" UniqueName="columnAllegati" Visible="False">
               </telerik:GridAttachmentColumn>

With this snippet (thanks to Princy for it), when a file is uploaded a link is generated and it is visible inside the record when it is in edit mode. See picture attached.

protected void RadGrid1_ItemCreated(object sender, GridItemEventArgs e)
    {
        //Generate links of attachments inside folder "Allegati" visible when in edit mode
        if (e.Item is GridEditableItem && e.Item.IsInEditMode)// Check if the Grid is in EditMode
        {
            GridEditableItem edit = (GridEditableItem)e.Item;
            DirectoryInfo dir = new DirectoryInfo(@"C:\Users\Pink\Documents\Visual Studio 2012\Projects\ManagDoc_Framework\Test1_managDoc\Test1_managDoc\Allegati");// path of the target folder where your  files are stored

            DirectoryInfo[] subDirs = dir.GetDirectories();
            FileInfo[] files = dir.GetFiles(); //Getting the files inside the Directory
            foreach (FileInfo fi in files) //To loop through all files for setting each file as HyperLink
            {
                HyperLink lktest = new HyperLink(); //Add HyperLink Column
                lktest.ID = "lnk" + Guid.NewGuid(); //Setting Unique IDs
                lktest.Text = fi.Name.ToString(); //Get the File name
                lktest.NavigateUrl = "#";
                lktest.Attributes.Add("Onclick", "ViewCheck('" + fi.Name + "')"); // Calling the JS event
                //Adding the HyperLink to EditForm
                edit["columnAllegati"].Controls.Add(lktest);
                edit["columnAllegati"].Controls.Add(new LiteralControl("<br>"));
            }
        }
    }

The above feature works very well and I am happy of the result I got thanks to the help of this forum members.
Now what I would like to achieve is to show for each record only the links of the uploaded files relevant that particular record.
I mean If I load an attachment named "Mickey Mouse" from record A, and an attachment named "Donald duck" from record B, when I open record A I would like to see only the link to Mickey Mouse and when I open record B I would like to see only the link to Donald Duck.
Like in this forum, each thread shows links to the own attachments.
How can I achieve that?

[Princy]

Hi Felice,

In-order to achieve the desired functionality, you need to save the entire FilePath of the file in corresponding row of the DataBase in a data column. Here is a sample code snippet I tried.

C#:

protected void RadGrid1_UpdateCommand(object sender, GridCommandEventArgs e)

{

    GridEditableItem edit = (GridEditableItem)e.Item;

    RadUpload uplo = (RadUpload)edit["Attachment"].Controls[0]; //accessing the RadUpload

    string fullPath = Path.Combine(Server.MapPath("target"), uplo.UploadedFiles[0].FileName);//getting the fullpath of the file going to be uploaded

    string Id = edit.OwnerTableView.DataKeyValues[edit.ItemIndex]["DataKeyName"].ToString(); //getting the datakeyvalue of the row, to uniquely identify a row

    string updateQuery = "Update TableName set ColumnFileName='" + fullPath + "' where DataKeyFieldName='" + Id + "'"; //adding the filename of the uploaded file to db

    conn.Open();

    SqlCommand.CommandText = updateQuery;

    SqlCommand.Connection = conn;

    SqlCommand.ExecuteNonQuery();

    conn.Close();   

}

protected void RadGrid1_ItemCreated(object sender, GridItemEventArgs e)

{

    if (e.Item is GridEditableItem && e.Item.IsInEditMode) //in edit mode to show the uploaded file


    {

             

        GridEditableItem edit = (GridEditableItem)e.Item;

        string Id = edit.OwnerTableView.DataKeyValues[edit.ItemIndex]["DataKeyName"].ToString();// getting the datakeyvalue of the row

        string selectFilterQuery = "select ColumnFileName from [TableName ] where DataKeyFieldName='" + Id + "'"; //query for retrieving the upoaded file path of the row

        SqlCommand.CommandText = selectFilterQuery;

        SqlDataAdapter adapter = new SqlDataAdapter(selectFilterQuery, conn);

        DataTable dt = new DataTable();

        conn.Open();

        adapter.Fill(dt);

        conn.Close();

        HyperLink lktest = new HyperLink(); //adding hyperlink

        lktest.ID = "lnk" + Guid.NewGuid();  

        string dbf_File = System.IO.Path.GetFileName( dt.Rows[0].ItemArray[0].ToString()); //retieving only the file name from the full path

        lktest.Text = dbf_File;

        lktest.NavigateUrl = "#";

        lktest.Attributes.Add("Onclick", "ViewCheck('" + dbf_File + "')");

        edit["Attachment"].Controls.Add(lktest);

        edit["Attachment"].Controls.Add(new LiteralControl("<br>"));     

    }

}

Javascript:

<script type="text/javascript">
        function ViewCheck(filename) {
            var targetfile = "target/" + filename;
            var openWnd = radopen(targetfile, "RadWindowDetails");
        }
</script>

Let me know if you have any concern.

Thanks,
Princy.

[Felice]

Thanks a lot Princy.
I slightly changed the dynamic but along your indication it is now working fine.
Thanks for the great and professional support.
Felice