Architecture :: Need To Find A Way To Send An Automatic Email To Each Employee When The Current Date Exceeds The Subscription Date By One Year?
Jun 7, 2010
I'm using ASP.Net with VB (Visual Web Developer 2010) and SQL(Management Studio Express 2008) to create a website that keeps track of employee subscriptions.A date is entered into my database whenever an employee makes a subscription.I need to find a way to send an automatic email to each employee when the current date exceeds the subscription date by one year.
I am unable to use an SQL job as I only have SQL MS express.From other posts I have read it seems the best way to do this is to create a webservice to send emails but I am unsure of how to get the email address for each employee from the database to the web service?Do you guys think a web service is the best way to do this?
View 9 Replies
Similar Messages:
Mar 1, 2013
This is House_info table in database
Id
Name
Expiredate
date
in admin.aspx page I have register button
I want when users click on button In Table in Expiredate column insert current date+1year
I mean if today is 2013-1-3Â in Expiredate column insert 2014-1-3
for this what should I wrote in SP?
View 1 Replies
Sep 1, 2010
I would like to achieve the following.
1- if a user goes to a web page in a web application hosted on the Internet and selects a FUTURE date from a "Calendar control" the date selected and the URL for the page are stored in the database (I know how to do this step)
2- when the date selected arrives the URL will be embedded in an email that is sent out AUTOMATICALLY to the user. How can I trigger the email to go out AUTOMATICALLY on the selected date??????
Does the link below help me answer this question?? I just need a high level steps on how to do this. .
http://msdn.microsoft.com/en-us/magazine/cc163821.aspx
View 3 Replies
Jul 23, 2010
I need to find a date 6, months from the current date. How to do it. I use dd/mm/yyyy format. I could use add 6 to mm part, what if it goes beyond 12 ? but it could still be done, I know. I want to know if there is any easy way to do it.
View 2 Replies
Nov 19, 2010
How to create Jobs, I am using SQL 2005, i need a query which should get current date and compare current date with date in table and Send Email according to Job scheduled.
View 4 Replies
Feb 13, 2010
I have a web site in asp.net(C#). And want to add an automatic email sending functionality in it, i.e. an email will be send daily and weekly(both on a particular time) to all the stock holders about the orders details placed by registered users. How can I do this in asp.net(C#)?
View 21 Replies
Aug 5, 2013
I want to display the current month name,date and time like this "August 5, 2013 06:30:58 pm" using ajax.Â
View 1 Replies
Aug 14, 2010
In myapplication i have done a thing like if some one purchase a tool for and if the license provided is for some few days (suppose for a week or an year).. How to send a mail automatically to the ID given by him before a day or a few days .
View 3 Replies
Nov 11, 2010
How can i send an email certain days from now in C# (Win Forms). Say today is January 1 2010. Now i fix an appointment with doctor on January 10 2010. But i wish that a reminder email (regarding appointment) needs to be sent 3 days before (i.e. January 7 2010). I am having an email code with me.
My requirements: Visual Studio 2005, C# (vb would also do), WinForms (Windows based applications)
Let me know if anything from me is needed.
View 2 Replies
Mar 4, 2010
I want to send email on particular Date & Time. How to achieve this? I am using Sql 2005 for storing Date & time for sending emails.
View 3 Replies
Sep 30, 2010
i have made application...that can have numbers of Event on Specified Date, So i want to code tat when time for event is arrived so tat automatically the participant get information about the event..so i want to send email to all participant before a day.
View 3 Replies
Sep 17, 2010
1) How can i display the date only till current date in ajax calendar extender ?
2)How to validate the date in one TextBox with the Date in another TextBox ?
View 2 Replies
Sep 5, 2013
validation to check the date greater and equal to the current date .
View 1 Replies
Jan 17, 2013
in my asp.net_vb code web. there are 9 textboxes whcih is used for entering numerical/dates
first is lve.text in whicj numder is entered
second one is lvefrom.text
thirdone is lveto.text
when user fills (lve.text) 5 and enter 15 Jan 2013 in lvefrom.text then lveto.text should show 19 Jan 2013. i had posted this earlier and got reply which is mentioned below. this code below gives me 20 Jan 2013 instead of 19 Jan 2013.
tw text boxes lve.text (number filled) and lve from.text (date filled). when user enter a numder in lve.text and select a date fro date picker in lvefrom.text then lveto.text should show date selected in lvefrom.text + number of days in lveto.text (eg if number of days is 5 and date selected in lvefrom.text is 15 Jan 2013 then lveto.text should display 19 jan 2013. because the starting day is also counted in my case.
Protected Sub lvefrom_TextChanged1(ByVal sender As Object, ByVal e As System.EventArgs) Handles lvefrom.TextChanged
Dim ObjLocDate As New Date
Dim IntLocDays As Integer
IntLocDays = Convert.ToInt32(lve.Text)
ObjLocDate = lvefrom.Text
ObjLocDate = ObjLocDate.AddDays(IntLocDays)
lveto.Text = ObjLocDate.Date.ToString("dd-MMM-yyyy")
End Sub
fourt tex box is pfx.text, fifth is pfx1.text, sixth is pfx2.text
when use filles pfx.text 3 then pfx1.text should display 12 Jan 2013 and pfx2.text should display 14 Jan 2013. these are the prefix for leave( as 12 to 14 Jan 2013 is prefix.seveth is sfx.text, eighth is sfx1.text and nineth is sfx2.text
when user fills sfx.text 3Â then sfx1.text should display 20 Jan 2013 and sfx2.text should display.
View 1 Replies
Oct 8, 2013
Here what i am trying to accomplish. I want to have a div or panel on the page and have some text on it. The div or panel must hava a specfied time limit and then disaaper from the page. Say i want this text to apper on 10Cotober 10.00 Â and disapper from the page on 11October 18.00.Â
View 1 Replies
Jul 27, 2010
I want the code for calculating birthdate using age and current date in c#.
View 6 Replies
Dec 23, 2015
I have table in database that one column is Expire date that save date like below
2015-11-23
Now I want compare it whit today date like below:
if (_dr["ExpireDate"]<DateTime.Now) {
}
But it makes error can you tell me true code for it?
View 1 Replies
Mar 30, 2013
i wnat to sechdule message on asp.net. Like if i create a messge reminder to registerd members so they recive messge on paricular date time.
View 1 Replies
Jan 19, 2010
This one is probably snap for one for you gurus. I have a SQL table that needs to have every previous date accounted for. The user is not required to submit an entry daily, but is allowed to go back and submit when they have extra time to do so. I would like to display the next day from last date recorded in the SQL Table as a session variable, so when they go to the form to submit, the last necessary date is shown and the user knows where they left off.
View 4 Replies
Aug 10, 2010
Im struggling to find week start and week end date based on week number of the year. I have written this following sql to calculate that but it fails when year is 2012... The logic should count week number starting from first monday of the year. But it gives me wrong start date and end date when year is 2012, 2018....
[Code]....
View 2 Replies
Sep 8, 2010
my web application contain insurance due date field(in TextBox,which is enterd by user),and i need automatic email alert generation for this field 1 month before the date specified in the textbox to specific email address... how can i code my requirement in c#...can any one one suggest altenate option if my concept is wrong.
View 14 Replies
Sep 7, 2010
I need to write a stored procedure to schedule a job that will send automatic email to customers based on some condition as follows:
1. I have two tables. One table is table1 like the following:
Name Date1 Date2 Date3 Rahim, Khan 29'10 30'11 25'08 Karim,Abedin 12'10 28'11 26'09 Fahad, Alam 26'10 12'11 25'10 Another Table is table 2 like the following:
Name Email Rahim,Khan rahim@yahoo.com Karim,Abedin karim@yahoo.com Fahad, Alam falam@yahoo.com In table 1 the date format is in format where 30'11 mean work week is 30 and 11 means last two digits of the year.
2. Now , I need to write a stored procedure that will check :
a) What is current work week and current year?
b) It will then determine the difference between the current work week (now 37) and work week mentioned in date (Date1, Date2 and Date3) columns from table1 and if for current year(it's 2010) at least one difference in each row is>=8 then it should send an automatic email to the corresponding email address of Name column using the relation between Table1 and table2. For example: For first record in Table1 the three difference is: 37-29=8, 37-30=7 and 37-25=12. There are two differences >=8, but only first difference is for year 2010 and third one is not for current year. But, since at least one difference in this row satisfies condition (That means >=8 for year 2010)hence email message should be sent to the address rahim@yahoo.com using relation of table1 and table2.
I know how to set a schedule job in SQL mail but I need this stored procedure to run this job on daily basis.
View 8 Replies
Feb 18, 2014
I have a requirement like, I need to send an emails to all clients at 9:00 pm every day. I have the code for email send. I just want to know how do we schedule program to run at certain time in asp.net application. Do we need to open that website all the time ?
View 1 Replies
Jun 15, 2010
I make one web application where set reminder by user on my application. now i want to send message on mobile or email to particular user to remind the reminder. i got some hint from my friends i can make it in global.asax file. how write a code and fire the mail or sms in global.asax file?
View 17 Replies
Feb 11, 2011
I am developing a project in asp.net using c# coding. I m new to this field.
I need to add day/month/year to a text box in asp.net.
I hv 3 drop-down list. when i m selecting 3 dropdown list, its value must de shown in a text box.
View 1 Replies
