Given a date get Monday and Sunday date

Eric — Fri, 27 Jul 2007 08:48:00 GMT

/// <summary>

/// Gets Monday and Sunday dates

/// </summary>

/// <param name="SeedDate">The seed date.</param>

/// <param name="stDate">The st date.</param>

/// <param name="endDate">The end date.</param>

private void GetDates(DateTime SeedDate, ref System.DateTime stDate, ref System.DateTime endDate)

{

double offset = 0;

switch (SeedDate.DayOfWeek)

{

case DayOfWeek.Monday:

offset = 0;

break;

case DayOfWeek.Tuesday:

offset = -1;

break;

case DayOfWeek.Wednesday:

offset = -2;

break;

case DayOfWeek.Thursday:

offset = -3;

break;

case DayOfWeek.Friday:

offset = -4;

break;

case DayOfWeek.Saturday:

offset = -5;

break;

case DayOfWeek.Sunday:

offset = -6;

break;

}

stDate = SeedDate.AddDays(offset);

endDate = SeedDate.AddDays(6 + offset);

}

private void GetDates(DateTime SeedDate, ref System.DateTime stDate, ref System.DateTime endDate)

{

double offset = 0;

switch (SeedDate.DayOfWeek)

{

case DayOfWeek.Monday:

offset = 0;

break;

case DayOfWeek.Tuesday:

offset = -1;

break;

case DayOfWeek.Wednesday:

offset = -2;

break;

case DayOfWeek.Thursday:

offset = -3;

break;

case DayOfWeek.Friday:

offset = -4;

break;

case DayOfWeek.Saturday:

offset = -5;

break;

case DayOfWeek.Sunday:

offset = -6;

break;

}

stDate = SeedDate.AddDays(offset);

endDate = SeedDate.AddDays(6 + offset);

}

double offset = 0;

switch (SeedDate.DayOfWeek)

{

case DayOfWeek.Monday:

offset = 0;

break;

case DayOfWeek.Tuesday:

offset = -1;

break;

case DayOfWeek.Wednesday:

offset = -2;

break;

case DayOfWeek.Thursday:

offset = -3;

break;

case DayOfWeek.Friday:

offset = -4;

break;

case DayOfWeek.Saturday:

offset = -5;

break;

case DayOfWeek.Sunday:

offset = -6;

break;

}

stDate = SeedDate.AddDays(offset);

endDate = SeedDate.AddDays(6 + offset);

}

switch (SeedDate.DayOfWeek)

{

case DayOfWeek.Monday:

offset = 0;

break;

case DayOfWeek.Tuesday:

offset = -1;

break;

case DayOfWeek.Wednesday:

offset = -2;

break;

case DayOfWeek.Thursday:

offset = -3;

break;

case DayOfWeek.Friday:

offset = -4;

break;

case DayOfWeek.Saturday:

offset = -5;

break;

case DayOfWeek.Sunday:

offset = -6;

break;

}

stDate = SeedDate.AddDays(offset);

endDate = SeedDate.AddDays(6 + offset);

}

case DayOfWeek.Monday:

offset = 0;

break;

case DayOfWeek.Tuesday:

offset = -1;

break;

case DayOfWeek.Wednesday:

offset = -2;

break;

case DayOfWeek.Thursday:

offset = -3;

break;

case DayOfWeek.Friday:

offset = -4;

break;

case DayOfWeek.Saturday:

offset = -5;

break;

case DayOfWeek.Sunday:

offset = -6;

break;

}

stDate = SeedDate.AddDays(offset);

endDate = SeedDate.AddDays(6 + offset);

}

break;

case DayOfWeek.Tuesday:

offset = -1;

break;

case DayOfWeek.Wednesday:

offset = -2;

break;

case DayOfWeek.Thursday:

offset = -3;

break;

case DayOfWeek.Friday:

offset = -4;

break;

case DayOfWeek.Saturday:

offset = -5;

break;

case DayOfWeek.Sunday:

offset = -6;

break;

}

stDate = SeedDate.AddDays(offset);

endDate = SeedDate.AddDays(6 + offset);

}

case DayOfWeek.Tuesday:

offset = -1;

break;

case DayOfWeek.Wednesday:

offset = -2;

break;

case DayOfWeek.Thursday:

offset = -3;

break;

case DayOfWeek.Friday:

offset = -4;

break;

case DayOfWeek.Saturday:

offset = -5;

break;

case DayOfWeek.Sunday:

offset = -6;

break;

}

stDate = SeedDate.AddDays(offset);

endDate = SeedDate.AddDays(6 + offset);

}

break;

case DayOfWeek.Wednesday:

offset = -2;

break;

case DayOfWeek.Thursday:

offset = -3;

break;

case DayOfWeek.Friday:

offset = -4;

break;

case DayOfWeek.Saturday:

offset = -5;

break;

case DayOfWeek.Sunday:

offset = -6;

break;

}

stDate = SeedDate.AddDays(offset);

endDate = SeedDate.AddDays(6 + offset);

}

case DayOfWeek.Wednesday:

offset = -2;

break;

case DayOfWeek.Thursday:

offset = -3;

break;

case DayOfWeek.Friday:

offset = -4;

break;

case DayOfWeek.Saturday:

offset = -5;

break;

case DayOfWeek.Sunday:

offset = -6;

break;

}

stDate = SeedDate.AddDays(offset);

endDate = SeedDate.AddDays(6 + offset);

}

break;

case DayOfWeek.Thursday:

offset = -3;

break;

case DayOfWeek.Friday:

offset = -4;

break;

case DayOfWeek.Saturday:

offset = -5;

break;

case DayOfWeek.Sunday:

offset = -6;

break;

}

stDate = SeedDate.AddDays(offset);

endDate = SeedDate.AddDays(6 + offset);

}

case DayOfWeek.Thursday:

offset = -3;

break;

case DayOfWeek.Friday:

offset = -4;

break;

case DayOfWeek.Saturday:

offset = -5;

break;

case DayOfWeek.Sunday:

offset = -6;

break;

}

stDate = SeedDate.AddDays(offset);

endDate = SeedDate.AddDays(6 + offset);

}

break;

case DayOfWeek.Friday:

offset = -4;

break;

case DayOfWeek.Saturday:

offset = -5;

break;

case DayOfWeek.Sunday:

offset = -6;

break;

}

stDate = SeedDate.AddDays(offset);

endDate = SeedDate.AddDays(6 + offset);

}

case DayOfWeek.Friday:

offset = -4;

break;

case DayOfWeek.Saturday:

offset = -5;

break;

case DayOfWeek.Sunday:

offset = -6;

break;

}

stDate = SeedDate.AddDays(offset);

endDate = SeedDate.AddDays(6 + offset);

}

break;

case DayOfWeek.Saturday:

offset = -5;

break;

case DayOfWeek.Sunday:

offset = -6;

break;

}

stDate = SeedDate.AddDays(offset);

endDate = SeedDate.AddDays(6 + offset);

}

case DayOfWeek.Saturday:

offset = -5;

break;

case DayOfWeek.Sunday:

offset = -6;

break;

}

stDate = SeedDate.AddDays(offset);

endDate = SeedDate.AddDays(6 + offset);

}

break;

case DayOfWeek.Sunday:

offset = -6;

break;

}

stDate = SeedDate.AddDays(offset);

endDate = SeedDate.AddDays(6 + offset);

}

case DayOfWeek.Sunday:

offset = -6;

break;

}

stDate = SeedDate.AddDays(offset);

endDate = SeedDate.AddDays(6 + offset);

}

break;

}

stDate = SeedDate.AddDays(offset);

endDate = SeedDate.AddDays(6 + offset);

}

Code Library

Given a date get Monday and Sunday date

Check all in a datagrid

function to format a date field in a sql server format