reminder in c# compare with current date

Question

0.00/5 (No votes)

See more:

Hi guys,

I have to create one REMINDER in my project,

the scenario is: my project is related to chemical inventory, where i have to create a reminder for the chemicals which are about to expire.

Can anyone plz suggest me, how can i create a reminder for '5days before the expiry of chemical' comparing with current date/expiry date...

Regards,

Posted 11-Jan-14 23:01pm

abdul subhan mohammed

Add a Solution

Comments

Kornfeld Eliyahu Peter 12-Jan-14 5:09am

Not clear...
1. do you want to show some alert on login or
2. add alert to existing list of inventory

Torakami 12-Jan-14 5:10am

Did you mean you have to send any email or something like that .

If thats the answer you can either create one windows service for that or you can create SQL reminders which will automatically send you an email

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2014-01-11T23:11:00

Solution 1

Try:

C#

DateTime expiryDate = new DateTime(2014, 1, 17);
if (DateTime.Now.AddDays(5) >= expiryDate)
    {
    Console.WriteLine("Expired");
    }

Posted 11-Jan-14 23:11pm

OriginalGriff

Andreas Gieriet · Answer 2 · 2014-01-12T01:17:00

You may do something like this (pseudo code):

C#

class Chemical
{
  ...
}
...
void ReportExpiredChemicals(int leadTimeInDays, Action<Chemical> report)
{
    var cutoff = Today + leadTimeInDays; // some magic Today property
    DataContext dc = ...                 // some data context that provices that data table for chemicals
    var query = from c in dc.GetTable<Chemical>
                where c.ExpireDate < cutoff
                select c;
    foreach(var c in query) report(c);
}
...
void SendEmailForExpiredChemical(Chemical chemical) { ... }
...
const int twoWeeks = 14; // days;
ReportExpiredChemicals(twoWeeks, SendEmailForExpiredChemical);

Cheers
Andi