selecting number of days from two raddatepicker in a textbox

[Prashanth]

Hi all,

 I am new to telerik controls, I am having two RadDatePickers(FromRadDatePicker and ToRadDatePicker) and a TextBox(TotalTextBox).I want the Number of days from the Two raddatepickers to the Textbox. I am getting it by using this below code

TimeSpan ts = ToRadDatePicker.SelectedDate.Value.Subtract(FromRadDatePicker.SelectedDate.Value);
           TotalTextBox.Text = ts.Days.ToString();

I also want subtracting the saturdays and sundays and custom holiday list if any.

For Example:-

FromRadDatePicker  31-Aug-2012
ToRadDatePiker     05-Sep-2012

The TotalTextBox Should be 2( 1 and 2-Sep is saturday, sunday and 4-sep is a custom created festival Holiday)

How to create Custom Created Holiday List, and Subtracting the Saturday and Sunday?

Any one Please help me out.

[Prashanth]

any one please help me out.........

[Prashanth]

Is there any one who can do this..

[Prashanth]

It would be odd if i reply to my post again and again but the thing is it is urgent for me.

[Princy]

Hi Prashanth,

You can add Custom holidays as special days. Here is the sample code that I tried.

ASPX

<telerik:RadDatePicker ID="FromRadDatePicker" runat="server" onselecteddatechanged="RadDatePicker_SelectedDateChanged" AutoPostBack="true" ></telerik:RadDatePicker>
<telerik:RadDatePicker ID="ToRadDatePicker" runat="server" onselecteddatechanged="RadDatePicker_SelectedDateChanged" AutoPostBack="true" ></telerik:RadDatePicker>
<telerik:RadTextBox ID="TotalTextBox" runat="server"></telerik:RadTextBox>

C#:

protected void Page_Load(object sender, EventArgs e)
{
 if (!IsPostBack)
 {
   // Adding Custom Holidays
  RadCalendarDay calendarDay1 = new RadCalendarDay();
  DateTime dt1 = new DateTime(2012, 06, 20);
  calendarDay1.Date = dt1.Date;
  FromRadDatePicker.Calendar.SpecialDays.Add(calendarDay1);

  FromRadDatePicker.SelectedDate = DateTime.Today;
  ToRadDatePicker.SelectedDate = DateTime.Today;
 }
}

public static int Weekdays(DateTime dtmStart, DateTime dtmEnd)
{
 if (dtmStart >= dtmEnd)
 {
   return 0;
 }
 int dowStart = ((int)dtmStart.DayOfWeek == 0 ? 7 : (int)dtmStart.DayOfWeek);
 int dowEnd = ((int)dtmEnd.DayOfWeek == 0 ? 7 : (int)dtmEnd.DayOfWeek);
 TimeSpan tSpan = dtmEnd - dtmStart;
 if (dowStart <= dowEnd)
 {
  return (((tSpan.Days / 7) * 5) + Math.Max((Math.Min((dowEnd + 1), 6) - dowStart), 0));
 }
 return (((tSpan.Days / 7) * 5) + Math.Min((dowEnd + 6) - Math.Min(dowStart, 6), 5));
}

protected void RadDatePicker_SelectedDateChanged(object sender, Telerik.Web.UI.Calendar.SelectedDateChangedEventArgs e)
{
 int SplDays = 0;
 foreach (RadCalendarDay day in FromRadDatePicker.Calendar.SpecialDays)
 {
  if ((day.Date.CompareTo(FromRadDatePicker.SelectedDate) >= 0) && (day.Date.CompareTo(ToRadDatePicker.SelectedDate) <= 0) && (!day.IsWeekend))
  {
    SplDays ++;
  }
 }
 int weekdays = Weekdays(FromRadDatePicker.SelectedDate.Value, ToRadDatePicker.SelectedDate.Value);
 int Total = weekdays - SplDays;
 TotalTextBox.Text = Total.ToString();
}

Hope this helps.

Thanks,
Princy.