How do I create a reminder for a renewal?

Question

0.00/5 (No votes)

See more:

I need an alert function in c#, when the employee logs into the system, he gets an alert message saying he has a renewal due in a week?

IM new to c#, and coding is not my specialty. This is an assignment submission.

This is a windows form app.

Renewal details are in a renewal table and employee/user details are in another table; I can use queries to join them / link it.

Static alert; just reminder the employee of the renewal

kindly help me.. Thanks

What I have tried:

Im clueless, and coding is not my field of specialty

I made the db, and other parts of the assignment, such as creating the renewal , editing and viewing.

I was thinking of geting the user ID and connecting to the user profile table and then connecting that to the renewal ID , and displaying the alert or reminder..

but im not sure how to code it..

Posted 30-Aug-16 23:25pm

Member 12712655

Updated 30-Aug-16 23:39pm

v2

Add a Solution

Comments

Andy Lanng 31-Aug-16 5:33am

So many questions, so few answers.
It's hard to answer such an open question without any detail. There are so many options.
First off, please edit the question with the green "Improve question" button and answer the following:
Are you using a web form or windows form?
Can you get the renewal from the userid / username
do you need a functional alert (click here to blah blah) or a static one.

Depending on the answers I may have some follow up questions, but these'll do for now ^_^

1 solution

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 · 2016-08-30T23:30:00

Add a column to your Users table which is a RenewalDate - when the user logs in, check the value against the current date less the "reminder period"
That's almost trivial in C#:

C#

DateTime renewOn = ... get your renew date value from your DB ...
if (renewOn <= DateTime.Now.AddDays(7).Date)
   {
   ... renewal needed

Then all you have to do is show the alert to the user - which again is pretty trivial, but depends on what kind of system you are coding for, and exactly how you want to display it.