Action Link Download - count download in another table

arun sahani

Hi Friends,

I have been struggling for couple of days.(ASP MVC 5 )

I have action link download that download file successfully.

I also want when i click on download action link, i should also get the data inserted in the another table specifying download by, datetime and like that so that I could track the download times.

(code and attachment)

Your suggestion and help will be hearty appreciated.

Arun Sahani

ITEM	Name	Details
0023	Online books	Asp.net	Download here
0024	Pdf materials	Asp.net MVC	Download here

When I click to Action link “Download Here” it redirect to

Action for download as

string file = "~/download_dir/" + attachment;

string contentType = "application/octet-stream";

return File(file, contentType, Path.GetFileName(file));

(Download complete)

Works fine up to here

I want also to insert the data into new table when clicked on above

“Download here” action link

Download by (userid)	Download date-time	Details	Download item
Arun1	201704170206	Asp.net	0023
Prina	201704170206	Asp.net MVC	0023

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ramesh Palanivel9y ago
Accepted answer
Hi ArunSahani,

Its simple. Just insert the data(UserId,Datetime.now,DownloadFileName,ItemNo) before you return the file to the user...

Ex :

Public FileResult DownloadFile(string FileName)
{
/*----------------------------------------------------------

Write your insert query in this action sahani..
------------------------------------------------------------------------ */
string file = "~/download_dir/" + attachment;
string contentType = "application/octet-stream";
return File(file, contentType, Path.GetFileName(file));

}
0
arun sahani9y ago
Dear Ramesh,
Many many thanks for sharing the idea, finally I have done as per your suggestion.
just I have put the sql insert query as I was doing in conventional asp.net webform.
and works fine.

Appreciate and Thanks from
Arun Sahani
0
Ramesh Palanivel9y ago
Hi Sahani,

Its simple.. Have you used entity framework? or DBContext method.
0
arun sahani9y ago
Dear Ramesh and Amit !
As you have suggested it is east to just insert insert sql query before the download code for asp.net webform, BUT I am not comfortable same to do in MVC as the controller for one table, difficult to insert in another table. Neither Can I put multiple return action property in the single action. Please support me, as I am beginner in MVC.

Arun Sahani
0
Amit Kumar9y ago
Hi,

string file = "~/download_dir/" + attachment;
string contentType = "application/octet-stream";
--------call a method from business logic for insert download details
InsertForDownloadFile(string downloadedby, string username)
and datetime mange direct form procedure.
return File(file, contentType, Path.GetFileName(file));

0