Welcome to Digitrends Sign in | Join | Help

Given a date get Monday and Sunday date

/// <summary>

/// <summary>

/// Gets Monday and Sunday dates

/// Gets Monday and Sunday dates

/// </summary>

/// </summary>

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

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

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

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

/// <param name="endDate">The end 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);

}
Posted Friday, July 27, 2007 8:48 AM by Eric | 0 Comments
Filed under: ,

Check all in a datagrid

function CheckAllDataGridCheckBoxes(aspCheckBoxID, checkVal) { re = new RegExp(':' + aspCheckBoxID + '$') //generated control name starts with a colon for(i = 0; i < document.forms[0].elements.length; i++) { elm = document.forms[0].elements[i] if (elm.type == 'checkbox') { if (re.test(elm.name)) { elm.checked = checkVal } } } }

 

this is how you use it

INPUT id="chkSelectAll" onclick="CheckAllDataGridCheckBoxes('chkPerBooking', ProduceBookingControl1_chkSelectAll.checked)" type="checkbox" value="Select All" name="chkSelectAll" runat="server"

Posted Friday, July 27, 2007 4:47 AM by Eric | 0 Comments

function to format a date field in a sql server format

Private Function convertToSqlDate(ByVal TheDate As Date) As String

Dim str As String

With TheDate

str = (.Year.ToString.PadLeft(2, Convert.ToChar("0")) & "-" & .Month.ToString.PadLeft(2, Convert.ToChar("0")) & "-" & .Day.ToString.PadLeft(2, Convert.ToChar("0")) & " " & .Hour.ToString.PadLeft(2, Convert.ToChar("0")) & ":" & .Minute.ToString.PadLeft(2, Convert.ToChar("0")) & ":" & .Second.ToString.PadLeft(2, Convert.ToChar("0")) & ":" & .Millisecond.ToString.PadLeft(2, Convert.ToChar("0")))

End With

Return str

End Function

Posted Monday, July 16, 2007 6:03 AM by Eric | 0 Comments