Run through loop for week and dont select weekends

[xnaLearner]

So the user can select 2 different dates, a start date and an end date from 2 calendars, when they click 'add' the dates between&including the dates selected will be added to the DB, each date as a separate record.

This works fine however I dont want weekends to be added to the DB.

Iv updated the UI of datepicker http://www.kelvinluck.com/assets/jquery/datePicker/v2/demo/datePickerCustomCellRender.html but if a user selects fri-mon for example fri,sat,sun and mon will be added to the db Iv tried to only run the code if datyofweek is not saturday or sunday

public ActionResult listHolidays(Holiday holiday, int? PersonId, string HolidayDate, string endDate)
{
DateTime startDates = Convert.ToDateTime(HolidayDate),
endDates = Convert.ToDateTime(endDate);

        while (startDates <= endDates)
        {
            if (startDates.DayOfWeek != DayOfWeek.Saturday || startDates.DayOfWeek != DayOfWeek.Sunday)
            {
                Holiday holiday1 = new Holiday();
                holiday1.PersonId = PersonId.Value;
                holiday1.HolidayDate = startDates;
          
                db.Holidays.AddObject(holiday1);
                db.SaveChanges();

                //say start date is 10. AddDays(1) will make it 11 then return it to startDates in 'startDates' = startdates,
                //but doesnt chage the value of startdates = 'startdates'
               // startDates = startDates.AddDays(1);

                 startDates = startDates.AddDays(1);
            }
        }

        return RedirectToAction("Index");
    }

any help? Thanks

[Pete OHanlon]

xnaLearner wrote:

if (startDates.DayOfWeek != DayOfWeek.Saturday || startDates.DayOfWeek != DayOfWeek.Sunday)

That's an AND condition, not an OR condition. It should read:

if (startDates.DayOfWeek != DayOfWeek.Saturday && startDates.DayOfWeek != DayOfWeek.Sunday)

*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington

"Mind bleach! Send me mind bleach!" - Nagy Vilmos

CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

[xnaLearner]

thanks for the help

[Pete OHanlon]

Not a problem.

*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington

"Mind bleach! Send me mind bleach!" - Nagy Vilmos

CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier