Wednesday, February 19, 2014

Find total week no and dates between two dates in asp.net c#

//============  Week No & Date Handling for Week No Dropdownbox ==================//
       
DateTime start = DateTime.Today;// Adjust to your start date

//------ Total week no of Current Year
int w = (DateTime.IsLeapYear(System.DateTime.Now.Year) ? 366 : 365) / 7;


//------ Week No of Current Date
CultureInfo ciCurr = CultureInfo.CurrentCulture;
int weekNum = ciCurr.Calendar.GetWeekOfYear(start, CalendarWeekRule.FirstFullWeek, DayOfWeek.Monday);


// Get date of first day of a current week.
DateTime dt = GetFirstDayOfWeek(start, ciCurr);
for (int x = weekNum; x <= w; x++)
{
dropWeekNo.Items.Add(string.Format("Week: {0} ({1} - {2})", weekNum, dt.ToString("dd/MM/yyyy").Replace('-', '/'), dt.AddDays(6).ToString("dd/MM/yyyy").Replace('-', '/')));
dt = dt.AddDays(7);
weekNum++;
}


 public DateTime GetFirstDayOfWeek(DateTime dayInWeek, CultureInfo cultureInfo)
    {
        DayOfWeek firstDay = cultureInfo.DateTimeFormat.FirstDayOfWeek;
        DateTime firstDayInWeek = dayInWeek.Date;
        while (firstDayInWeek.DayOfWeek != firstDay)
            firstDayInWeek = firstDayInWeek.AddDays(-1);

        return firstDayInWeek;

    }

No comments:

Post a Comment

Generate All Database Backup From Sql Server Using Query

DECLARE   @name   VARCHAR ( 50 )   -- database name DECLARE   @path   VARCHAR ( 256 )   -- path for backup files DECLARE   @fileName  ...