Click here to Skip to main content
       

.NET Framework

 
AnswerRe: pulling across value from list to display in view PinmemberxnaLearner14-Dec-12 6:49 
AnswerRe: pulling across value from list to display in view Pinmemberfrazzle-me14-Dec-12 17:41 
GeneralRe: pulling across value from list to display in view PinmemberxnaLearner15-Dec-12 8:28 
Questionproblem with relationships PinmemberxnaLearner13-Dec-12 2:45 
AnswerRe: problem with relationships PinmemberRichard Deeming13-Dec-12 3:48 
GeneralRe: problem with relationships PinmemberxnaLearner13-Dec-12 4:37 
Question[VB.NET 2008] DataSet and XML files Pinmembersteve_949661313-Dec-12 0:06 
AnswerRe: [VB.NET 2008] DataSet and XML files PinmemberEddy Vluggen13-Dec-12 4:28 
GeneralRe: [VB.NET 2008] DataSet and XML files Pinmembersteve_949661313-Dec-12 21:21 
GeneralRe: [VB.NET 2008] DataSet and XML files PinmemberEddy Vluggen14-Dec-12 0:34 
QuestionAssembly with different .NET framework versions Pinmembermarca29212-Dec-12 10:05 
AnswerRe: Assembly with different .NET framework versions PinmemberGerry Schmitz12-Dec-12 12:25 
QuestionUse A Cookie To Send PersonID To Different Page PinmemberxnaLearner12-Dec-12 4:33 
Questiondont allow user to select existing date PinmemberxnaLearner10-Dec-12 5:46 
So the user selects holidays (start and end dates) from two calendars, the dates from start to end are then stored in the DB in separate records per date.
 
(thanks to help from a previous question this all works fine)
 
Now, I want some sort of error message which doesnt allow the button to be clicked if the dates the user are selecting already exist in the DB.
 
Im unsure if this is done from the view, or controller?
 
View:
 
<form action ="ListHolidays" id="listHolidays" method="post">
@using (Html.BeginForm()) {
      @Html.ValidationSummary(true)
    <fieldset>
        <legend>Holiday</legend>
 
        <div>
            @Html.LabelFor(model => model.PersonId, "Person")
        </div>
 
        <div>     
            @Html.DropDownListFor(model => model.PersonId,
                                new SelectList(ViewBag.Id, "Value", "Text"),
                                "---Select---"
                                )   
         @Html.ValidationMessageFor(model => model.PersonId)            
        </div>
 
        <div>
            @Html.LabelFor(model => model.HolidayDate)
        </div>
 
        <div>
 
            @Html.TextBoxFor(model => model.HolidayDate)
 
            @Html.TextBoxFor(model => model.endDate)
    <script>
 
//        Date.format = 'dd/m/yyy';
        $("#HolidayDate").addClass('date-pick');
        $("#endDate").addClass('date-pick');
            //$('.date-pick').datePicker//({dateFormat: 'dd-mm-yy'}).val();

//        clickInput: true
 
        $(function () {
        //3 methods below dont allow user to select weekends
            $('.date-pick').datePicker(
               {
                   createButton: false,
                   renderCallback: function ($td, thisDate, month, year) 
                   {
                       if (thisDate.isWeekend()) 
                       {
                           $td.addClass('weekend');
                           $td.addClass('disabled');
                       }
                   }
               }
        )
 
        .bind('click',
            function () 
            {
                $(this).dpDisplay();
                this.blur();
                return false;
            }
        )
 
        .bind('dateSelected',
            function (e, selectedDate, $td) 
            {
                console.log('You selected ' + selectedDate);
            }
        );
 
//        HolidayDate is start date
            $('#HolidayDate').bind('dpClosed',
                    function (e, selectedDates) 
                    {
                        var d = selectedDates[0];
                        if (d) 
                        {
                            d = new Date(d);
                            $('#endDate').dpSetStartDate(d.addDays(1).asString());
                        }
                    }
            );
 
            //end date is end date
            $('#endDate').bind('dpClosed',
                    function (e, selectedDates) 
                    {
                        var d = selectedDates[0];
                        if (d) 
                        {
                            d = new Date(d);
                            $('#HolidayDate').dpSetEndDate(d.addDays(-1).asString());
                        }
                    }
                );
        });
 

 
    </script>
 
     @Html.ValidationMessageFor(model => model.HolidayDate)
        </div>
 
        <p>
            <input type="submit" value="Create"/>
        </p>
 
controller:
 
HttpPost] 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);
            }
 
            return RedirectToAction("Index");
 
so...? if holidayDate = db.exisitng date?
 
Unsure how to go about this.
 
Please advise.
 
thanks
AnswerRe: dont allow user to select existing date PinprotectorPete O'Hanlon10-Dec-12 5:53 
GeneralRe: dont allow user to select existing date PinmemberxnaLearner10-Dec-12 6:23 
GeneralRe: dont allow user to select existing date PinmemberxnaLearner10-Dec-12 23:26 
GeneralRe: dont allow user to select existing date PinprotectorPete O'Hanlon10-Dec-12 23:32 
GeneralRe: dont allow user to select existing date PinmemberxnaLearner10-Dec-12 23:46 
GeneralRe: dont allow user to select existing date PinprotectorPete O'Hanlon10-Dec-12 23:51 
GeneralRe: dont allow user to select existing date PinmemberxnaLearner11-Dec-12 0:21 
GeneralRe: dont allow user to select existing date PinprotectorPete O'Hanlon11-Dec-12 1:02 
QuestionRun through loop for week and dont select weekends PinmemberxnaLearner10-Dec-12 4:13 
AnswerRe: Run through loop for week and dont select weekends PinprotectorPete O'Hanlon10-Dec-12 4:31 
GeneralRe: Run through loop for week and dont select weekends PinmemberxnaLearner10-Dec-12 4:52 
GeneralRe: Run through loop for week and dont select weekends PinprotectorPete O'Hanlon10-Dec-12 4:53 
QuestionDeploying a Windows Service Pinmemberindian14310-Dec-12 4:09 
AnswerRe: Deploying a Windows Service PinprotectorPete O'Hanlon10-Dec-12 5:04 
GeneralRe: Deploying a Windows Service Pinmemberindian14310-Dec-12 5:08 
GeneralRe: Deploying a Windows Service PinprotectorPete O'Hanlon10-Dec-12 5:20 
Questionrun through startDate to endDate and add each record to DB PinmemberxnaLearner10-Dec-12 2:04 
AnswerRe: run through startDate to endDate and add each record to DB PinmemberxnaLearner10-Dec-12 2:35 
QuestionASP.NET Post Textbox After Button Click PinmemberxnaLearner9-Dec-12 11:15 
AnswerRe: ASP.NET Post Textbox After Button Click PinmvpRichard MacCutchan9-Dec-12 21:54 
GeneralRe: ASP.NET Post Textbox After Button Click PinmemberxnaLearner10-Dec-12 0:14 
Question.netframework Pinmemberzofi518-Dec-12 4:30 
AnswerRe: .netframework PinmvpDave Kreskowiak8-Dec-12 6:37 
AnswerRe: .netframework PinmemberEddy Vluggen8-Dec-12 7:18 
GeneralRe: .netframework PinmemberKevin Bewley13-Jan-13 23:46 
AnswerRe: .netframework Pinmemberjibesh11-Dec-12 10:36 
QuestionEnter 3 dates and display order in different VIEW, after click PinmemberxnaLearner7-Dec-12 9:52 
Question[VB.NET 2008] How to detect if a page of a TabControl is selected (Windows CE) Pinmembersteve_94966136-Dec-12 21:37 
AnswerRe: [VB.NET 2008] How to detect if a page of a TabControl is selected (Windows CE) PinmemberZaf Khan10-Dec-12 17:57 
GeneralRe: [VB.NET 2008] How to detect if a page of a TabControl is selected (Windows CE) Pinmembersteve_949661311-Dec-12 21:20 
GeneralRe: [VB.NET 2008] How to detect if a page of a TabControl is selected (Windows CE) PinmemberZaf Khan12-Dec-12 2:13 
Question[VB.NET 2008] How to get control on objects created at runtime Pinmembersteve_94966135-Dec-12 4:54 
AnswerRe: [VB.NET 2008] How to get control on objects created at runtime PinmemberEddy Vluggen5-Dec-12 5:40 
GeneralRe: [VB.NET 2008] How to get control on objects created at runtime Pinmembersteve_94966135-Dec-12 20:59 
GeneralRe: [VB.NET 2008] How to get control on objects created at runtime PinmemberEddy Vluggen6-Dec-12 2:27 
GeneralRe: [VB.NET 2008] How to get control on objects created at runtime Pinmembersteve_94966136-Dec-12 3:26 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web01 | 2.8.140718.1 | Last Updated 21 Jul 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid