In My application , i have different plans1)Free2)Personal(Monthly, Yearly)Now my problem is 1)Want to send email to all the customers in which plan is going to be expired in one week , on the day of expiration andafter expiration to re2)After expiration i have to set the record status to deactive
View 3 RepliesIm 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]....
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.
I want to select all the customers from "customers" table from a specific country. I write the following query but it is not working. why?
select *
From customers
where country = @country;[code]....
I am learning jQuery. Here I have a requirement i.e I have to add Week number and Week ranges of a year to Drop-down List in ASP.NET3.5. And I have to pass selected week range to database. I am using c#.net. This should be done automatically for every year.
How can I do this using jQuery?
How to show current date along with six days as a week in html header with navigation bar for next week and previous week?
View 1 RepliesI have a working timesheet which displays on a webpage, what I was also wanting was to display the previous week and the following also on the same page. I will attach both the .aspx page and the aspx.cs page. I have hardcoded the date into the webpage just for ease of reference at the moment.
[Code]....
[Code]....
how to get the start and end dates of the week by passing in a week number? I have a dropdownlist that needs to show 2010-05-17 - 2010-05-23 and I need to determine this date by passing in a week number.
Ex: if I pass the number 20, it will return 2010-05-10 - 2010-05-16 etc...
My dropdownlist will always only show one week and it will always be the previous week from the currect week.
how can i get the actual date through that date's datepart and calendar week? Its means that , i have Calendar week = 1 and datepart is Friday, so i will the actual date is 01-JAN-2010?
View 2 RepliesI Need to insert a row in a excel plan.It's ready filled with some data... I just want to put a new blank row in the plan and fill four columns with a kind of title to that collum.
View 1 RepliesI'm trying to write a code to make a DB from an excel plan. I make a code but I have the error: Compiler Error Message: BC30506: Handles clause requires a WithEvents variable defined in the containing type or one of its base types.The code of data.aspx.vb is:
[Code]....
and the data.aspx is:
[Code]....
when I use 'RowNumber' = ROW_NUMBER() OVER(ORDER BY ColumnName) then due to orderby Column name consume 76% usage in execution plan . in such case what I have to do? I can see sorting taking much time in execution plan.
View 9 RepliesThis is a question for who works with both PHP and ASP.NET/C#/VB.I plan on learning both languages over time, but I am curious in the order you learned both technologies? And Why?Maybe you just chose by time/ease to become good in the language or you just prefer one language over the other.I want to learn both technologies so, if for some reason my projects don't workout, I have a backup plan as a web developer for clients. I would really like to service both sides of the isle, Windows and LAMP
View 10 RepliesI'm sending automatically emails when customers buy products on my ecommerce portal.
But, send pages by emails, at least in my server, using asp.net is too slow.
So, I want to send emails automattically, but using SERVER PROCESSING (Server Side). Did you get my point?
The customer won't see the sending process. But in background, directly on the server, the email is being sending.
I have 1 textbox where user is entering date. Depending on entered date, I would like to calculate week start date and week end date for entered date thru programming without javascript. My working days are monday to friday
View 5 RepliesWhat is the best practice to apply different themes to different customers with asp.net.
View 4 RepliesI have one problem to display date for a week in textbox.
let say:
textbox1=date ----> select one date ,
if tuesday is select example:11/3/2012
then ..
date will appear in textbox in column tuesday(here)
_______________________________________________________________
monday tuesday wednesday thursday friday saturday sunday
here 11/3/2012 here here here here here
11/3/2012
_______________________________________________________________
*here=textbox
then
date before tuesday and after tuesday also appear in textbox for a week ...
Just looking for recommendations, we have a need to supply a chat-room for our customers. It will be small-mid scale usage, has anyone purchased any products recently that they recommend? Open to bundled, open-source, or SaaS implementations.
View 2 RepliesMy timeIn and Timeout values are like this 17:00,2:00.similarly i have 1 week Timein and timeout.I am calcuating the Totaltime for each day and storing it in string.
I want to calcuate Totaltime for a week.Since it is stored in string i am unable to add.I cannot store it in Integer because value is like 17:00.Tell what datatype i can use in database and also infront end with simple example.
I need to select complete week on selection of a day in calendar control.
View 1 RepliesI want to select a day of the week say .. Tuesday. I want all Tuesdays of that month (or between two selected dates) to get selected automatically. I am ready to use Calendar control or DropDownList whichever would do the trick.
View 1 RepliesI've written a ASP.NET app that I hope to sell to businesses, I could host the trial but it's designed to connect to the customers data so customers will certainly want to install it to do a successful evaluation.
I've never produced anything commercial before so I'm looking for advice on how best to limit the trial, a 30 day trial seems most common, do you simply rely on the clock of the PC/Server they install it on? keep in mind this is ASP.NET app so will be installed on their web server.
how best to allow a user to create their own URL? Say I have a domain like, www.mydomain.com, and I want the user to be able to create a custom ending to the URL like www.mydomain.com/companyname . Then when the URL is hit it will load the data for that company. Is this done via ASP.NET MVC routing? Any other ideas? I don't want to have to do any manual setup of site after user names it - like IIS changes or routing config file changes.
View 2 RepliesAny sample of codes that would generate a list of week end dates of a year in asp.net c#?
End date is Sat.
I have a chart where I am showing the date on x axis. I show one date a week. By default it shows Sunday's date. How can I change it to Monday's?
<AxisX Title="Week Beginning (Mon)" IntervalType="Days" IntervalOffsetType="Weeks">