How automatically calculate days then delete files c#?

Abhilash J A

Hello everyone,

I have this table structure.

Then, I am showing these items inside listview if archivedname is exist. After clicking a button, then there should a popup window will show as shown below.

With respect to this pop-up, after add number of days, then want to delete automatically archived name containing each record from listview or database table older than give number days.

For example, if I am giving 90 days then click button, should delete all files after 90days from current date.

How can I set automatic scheduler c# code?

Please help me.

11 Replies

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

Nitin Sontakke9y ago
Accepted answer
Can you not have both == and > that way, if app runs after the expected date the greater than will catch that condition. Simple!
Abhilash J A9y ago
Hello Amit,

Sir ,I have write the code like this. Now all are working fine. But I have doubt, by using this code,
  if (DateTime.Now.Date == calculatedDate.Date)
            {
/*here, then written the code for delete records*/
}
Here, the calculatedDate is the after adding number of day then I get date with respect to no of days using c# adddays code. (eg: if i am giving 10 days from current date then calculatedDate will 23/01/2017)
The problem is if the application not run at calculatedDate
then how can I mange this condition? if (DateTime.Now.Date == calculatedDate.Date)

Please help me.
Amit Gupta9y ago
@Abhilash
Yes, you got the point, below snippet will help you to get totaldays
var totalDays = (startDate.Date - endDate.Date).TotalDays;
Abhilash J A9y ago
Hello Bikesh,

Yes, I am just planing like this

"Then, I think that, have to get date with respect to the given number of days and then save that date to the database. Again, check the date on listview binding page load like if the date equal to the current date. If the apps will not run every day, that is also the data is over, to solve this issue have to write c# code like if the given date is over when the apps run on next day should have to delete records. Is this right way? I don't know how to create scheduler for up windows application also for this situation."

But, also I am thinking about how to do scheduler while installing my apps on any other customer local mechine...
Bikesh Srivastava9y ago
have you tried something ,i think no need to use task scheudlar
Nitin Sontakke9y ago
Abhilash, this is all very simple, if you google you will get everything. Seriously.

First, is it okay for you if the deletion happens after few days? Then you write the code in current app. If this is not acceptable write another windows console app and write code there.

The number entered by use should be stored by you anyway.

Scheduling an exe is very very simple, just google and you will get steps.

Exe will run every day, when to delete and what to delete is your C# and db logic.

Write a sp which will do all the addition of date and days and return the files to be deleted.
Nigel Fernandes9y ago
Scheduled task is the best approach for this.
Abhilash J A9y ago
Hello Nitin Sir,

Then, I think that, have to get date with respect to the given number of days and then save that date to the database. Again, check the date on listview binding page load like if the date equal to the current date. If the apps will not run every day, that is also the data is over, to solve this issue have to write c# code like if the given date is over when the apps run on next day should have to delete records. Is this right way? I don't know how to create scheduler for up windows application also for this situation.

Thanks
Abhilash.J.A
Nitin Sontakke9y ago
In my personal opinion, it is best to have a scheduled task. The reason for that is, it is not guaranteed that your application will run everyday.

For activities such as these it is best to have a separate app. As you will proceed, may be you will find more such things and you can club them all together.
Abhilash J A9y ago
Hello Amit,

Sir, with respect to your advice after add days and save the number days on table and every page load time check the currendays if equal to saved days if it is true then delete records from table or if not show details inside listveiw. Is it currect ?

Thanks,
Abhilash.J.A
Amit Gupta9y ago
Instead of complicating the things like scheduling the task, you may delete the rows at the time of form load on a seperate thread that read your data and days and perform the operation.