.NET (Core and Framework)

Re: run through startDate to endDate and add each record to DB

10-Dec-12 2:04

So I am using the JQuery.datePicker example... http://www.kelvinluck.com/assets/jquery/datePicker/v2/demo/datePickerStartEnd.html

I had the Jquery calendar working fine, but it olnly allowed me to enter 1 date at a time and save it to the DB.

I want the user to select a start and a multiple date, run a loop through the dates and each day to the DB.

Slightly lost at the minute and any help would be appreciated....

Here is part of my view for my ActionResult create()//which allows the user to add a new day.

HTML

<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>

    $("#HolidayDate").addClass('date-pick');
    $("#endDate").addClass('date-pick');
        //$('.date-pick').datePicker//({dateFormat: 'dd-mm-yy'}).val();

        $(function () 
        {
            $('.date-pick').datePicker()
            $('#HolidayDate').bind('dpClosed',
                function (e, selectedDates) 
                {
                    var d = selectedDates[0];
                    if (d) 
                    {
                        d = new Date(d);
                        $('#endDate').dpSetStartDate(d.addDays(1).asString());
                    }
                }
        );
            $('#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>

and my post for listHolidays:

[HttpPost]
public ActionResult listHolidays(Holiday holiday, int? PersonId, string HolidayDate, string endDate)
    {
        IList<DateTime> dates = new List<DateTime>();
        dates.Add(DateTime.Parse(HolidayDate));
        dates.Add(DateTime.Parse(endDate));
        List<DateTime> orderedDates = dates.OrderBy(d => d).ToList();

            for (int i = 0; i < orderedDates.Count; i++ )
            //if (ModelState.IsValid)
            {
                db.Holidays.AddObject(holiday);
                db.SaveChanges();
                return View();
            }

            return RedirectToAction("Index");
           // return View();
        }

The problem being in my list Holidays, im not sure how to run through the loop from start to end date, and add a new record to the DB for each one.

Please advise

xnaLearner10-Dec-12 2:35

ASP.NET Post Textbox After Button Click

10-Dec-12 2:35

I've updated my code to:

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

        while (startDates < endDates)
        {
            startDates.AddDays(1);
            db.Holidays.AddObject(holiday);
            db.SaveChanges();
        }

        return RedirectToAction("Index");

however I debugged using breakpoint, it runs through the loop once but on the second attempt it stops at db.Holidays.Addobject(holiday);

and I receive the error: An object with the same key already exists in the ObjecttateManager. the existing objects is in the unchanged state. An ibject can only be added to the objectStateManager again if it is i the added state.

if anyone can help that would be great

xnaLearner9-Dec-12 11:15

Re: ASP.NET Post Textbox After Button Click

9-Dec-12 11:15

So im just using an ASP.NET atm

Iv added 4 textboxes from the toolbox TextBox1, TextBox2, TextBox3, TextBox 4 and a button 'button1'

I want the user to enter data into the textboxs, compare them by .length and produce the output in order.

So before ordering them I am just trying to display them in the order of boxes textbox1, textbox2, textbox3.

protected void Button1_Click(object sender, EventArgs e)
    {
        DatesInOrderTextBox.Text = "Dates in order are" + TextBox1 + ", " + TextBox2 + ", " + TextBox3;
}

After that I intend to do something like the following

        //date 1 is biggest
        if (date1.Length > date2.Length && date1.Length > date3.Length)
        {
            //date 2 is 2nd & date 3 is 3rd
            if (date2.Length > date3.Length)
            {
                FirstDateOrder = date1;
                SecondDateOrder = date2;
                ThirdDateOrder = date3;

              System.Windows.Forms.MessageBox.Show("Order is 1, 2, 3");

             //   System.Windows.Forms.MessageBox.Show("Order is:" + FirstDateOrder + ", " + SecondDateOrder + ", " + ThirdDateOrder);

                ViewBag.DateOrder = "Order is 1,2,3";

                return RedirectToAction("Index");
            }

            //date 3 is 2nd & date 2 is 3rd
            else
            {
                FirstDateOrder = date1;
                SecondDateOrder = date3;
                ThirdDateOrder = date2;

                System.Windows.Forms.MessageBox.Show("Order is 1, 3, 2");

                return RedirectToAction("Index");
            }
}

Although when I click the button textbox4 is displaying

Dates in order areSystem.Web.UI.WebControls.TextBox, System.Web.UI.WebControls.TextBox, System.Web.UI.WebControls.TextBox

prob something simple just dont know how to fix it...thank you guys

Richard MacCutchan9-Dec-12 21:54

Richard MacCutchan

9-Dec-12 21:54

Try

protected void Button1_Click(object sender, EventArgs e)
{
    DatesInOrderTextBox.Text = "Dates in order are: " + TextBox1.Text + ", " + TextBox2.Text + ", " + TextBox3.Text;
}

One of these days I'm going to think of a really clever signature.

Re: ASP.NET Post Textbox After Button Click

xnaLearner10-Dec-12 0:14

10-Dec-12 0:14

ahh thats great thanks for the reply

.netframework

zofi518-Dec-12 4:30

zofi51

8-Dec-12 4:30

how to memorise such a big .netframework?is there any methode?

Dave Kreskowiak8-Dec-12 6:37

Dave Kreskowiak

8-Dec-12 6:37

Yes, it's called "studying". Perhaps you've learned the technique in school??

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Eddy Vluggen8-Dec-12 7:18

Eddy Vluggen

8-Dec-12 7:18

You do not "memorize" it, it's too big - and by the time you know it by heart, there'll be a new version. You'd learn how to use it; once you worked through a C#-book, you should be able to use the documentation[^].

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]
They hate us for our freedom![^]

Kevin Bewley13-Jan-13 23:46

Kevin Bewley

13-Jan-13 23:46

I agree with this.

I'd add that when I started out I invested in a copy of the Base Class Library text (it was c# 2005 at the time). That was a great book for showing me a great, useful slice of the framework, how it works, and what it can do.

Once you get in the 'mindset' of the framework, how it goes about things etc. You can, more often than not, predict where in the documentation you'll need to look to solve your problem.

Enter 3 dates and display order in different VIEW, after click

Jibesh11-Dec-12 10:36

Jibesh

11-Dec-12 10:36

I doubt how much storage capacity you had to memorize the entire .Net framework Confused | :confused:

. Its a bad idea too and save your time doing other interesting stuffs rather running behind memorizing .net framework.

you better store in stack - use it throw it.

Jibesh.V.P
India

xnaLearner7-Dec-12 9:52

[VB.NET 2008] How to detect if a page of a TabControl is selected (Windows CE)

7-Dec-12 9:52

Hey guys so im attempting to throw a project together to increase my knowledge of MVC3 but I have hit a wall...

So from my HolidaysController inside my index 'view' I have created a hyperlink which will navigate the user to the 'create3' ActionResult

HTML

@Html.ActionLink("Select 3 Dates", "Create3")

-------------------
In my create3 page I want the user to enter 3 dates into text boxes and when they click 'create' the user will be returned to the previous HolidaysController/Index page
where the dates will be displayed in order of ascending date....ATM I have this working up until the user enters 3 dates and clicks 'create'...However I only know
how to display a message box displaying the order, it is working I just need help getting the order to be displayed from the index page.

Please see my code:
Code for HolidayController/Index:
--------------

//submit will go to post
   [HttpPost]
   public ViewResult Index(int HolidayDate)
   {
       var holidays = db.Holidays.Include("Person");

       HolidayList model = new HolidayList();

       model.currentPersonID = HolidayDate;
       model.PList4DD = db.People.ToList();
       model.Categories = holidays.Select(x => new SelectListItem
                                       {
                                           Value = x.Id.ToString(),
                                           Text = x.Person.Name
                                       }
                                     );


       int data = HolidayDate;

       model.HList4DD = db.Holidays.Where(h => h.PersonId == HolidayDate).ToList();

       return View(model);

   }

   [HttpGet]
   public ViewResult Index(string sortOrder, int? currentPersonID)
   {
       var holidays = db.Holidays.Include("Person");

       HolidayList model = new HolidayList();

       //not null
       if (currentPersonID.HasValue)
       {
           model.currentPersonID = currentPersonID.Value;

       }
       else
       {
           model.currentPersonID = 0;
       }

       model.PList4DD = db.People.ToList();

       ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "date" : "";
       var dates = from d in db.Holidays
                   where d.PersonId == currentPersonID.Value
                   select d;

       switch (sortOrder)
       {
           case "date":
               dates = dates.OrderBy(p => p.HolidayDate);
               break;
       }

       model.HList4DD = dates.ToList();

       return View(model);
   }

-----------------------

HTML

//View for Index

@*@model IEnumerable<HolidayBookingApp.Models.Holiday>*@
@model HolidayBookingApp.Models.HolidayList
@{
    ViewBag.Title = "Index";
}

<h2>Index</h2>

<p>
    @Html.ActionLink("Create New", "Create")
</p>

<p>
@Html.ActionLink("Select 3 Dates", "Create3")
</p>

<table>
    <tr>
        <th>
            PersonId
        </th>
        <th>
            @*HolidayDate*@
            @Html.ActionLink("HolidayDate", "Index", new { sortOrder = ViewBag.NameSortParm, currentPersonID = Model.currentPersonID })
        </th>
        <th></th>
    </tr>
    <tr>  
    </tr>

@foreach (var item in Model.HList4DD)
{
    <tr>
        <td>
            @Html.DisplayFor(modelItem => item.PersonId)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.HolidayDate)
           
        </td>
        <td>
            @Html.ActionLink("Edit", "Edit", new { id = item.Id }) |
            @Html.ActionLink("Details", "Details", new { id = item.Id }) |
            @Html.ActionLink("Delete", "Delete", new { id = item.Id })
        </td>
    </tr>}
    
    <tr>
      <div class="editor-label">
         @*   @Html.LabelFor(model => model.PList4DD, "Person")*@
        </div>

        <div class="editor-field">           
             <form action ="/Holidays/Index" id="some" method="post"> 

  @Html.DropDownListFor(model => model.HList4DD.First().HolidayDate, new SelectList(Model.PList4DD, "Id", "Name", Model.currentPersonID), "--select--")    
       <script>
           function updateFormEnabled() 
           {
               if (verifyAdSettings()) 
               {
                   $('#sbmt').removeAttr('disabled');
               }
               else 
               {
                   $('#sbmt').attr('disabled', 'disabled');
               }
           }

           function verifyAdSettings() 
           {
               if ($('#HolidayDate').val() != '') 
               {
                   return true;
               }
               else 
               {
                   return false;
               }
           }

           $('#HolidayDate').change(updateFormEnabled);
      
           </script>
           
             <input type="submit" id= "sbmt" name="ViewHolidaysDD" value="View"/>
              </form>
  <script>
      $('#sbmt').attr('disabled', '');
        </script>

        </div>

</table>

<br />
<br />
<table>
    <div>
    Judging by your selection the order of dates are: //HERE IS WHERE I WANT TO DISPLAY THE ORDER OF DATES
    </div>

</table>

Just above is where I want to display my dates in order, ascending
------------

-----------------------------------
//my create 3 Action result


 [HttpGet]
        public ActionResult Create3()
        {
            return View();
        }

        [HttpPost]
        public ActionResult Create3(string date1, string date2, string date3)
        {
            string FirstDateOrder, SecondDateOrder, ThirdDateOrder;
         
            //date 1 is biggest
            if (date1.Length > date2.Length && date1.Length > date3.Length)
            {
                //date 2 is 2nd & date 3 is 3rd
                if (date2.Length > date3.Length)
                {
                    FirstDateOrder = date1;
                    SecondDateOrder = date2;
                    ThirdDateOrder = date3;

                    System.Windows.Forms.MessageBox.Show("Order is 1, 2, 3");

                    return RedirectToAction("Index");
                }

                //date 3 is 2nd & date 2 is 3rd
                else
                {
                    FirstDateOrder = date1;
                    SecondDateOrder = date3;
                    ThirdDateOrder = date2;

                    System.Windows.Forms.MessageBox.Show("Order is 1, 3, 2");

                    return RedirectToAction("Index");
                }
              
            }

            //date 2 is biggest
            if (date2.Length > date1.Length && date2.Length > date3.Length)
            {
                //date 1 is 2nd & date 3 is 3rd
                if (date1.Length > date3.Length)
                {
                    FirstDateOrder = date2;
                    SecondDateOrder = date1;
                    ThirdDateOrder = date3;

                    System.Windows.Forms.MessageBox.Show("Order is 2, 1, 3");

                    return RedirectToAction("Index");
                }

                //date 3 is 2nd & date 1 is 3rd
                else
                {
                    FirstDateOrder = date2;
                    SecondDateOrder = date3;
                    ThirdDateOrder = date1;

                    System.Windows.Forms.MessageBox.Show("Order is 2, 3, 1");

                    return RedirectToAction("Index");
                }

            }

            //date 3 is biggest
            if (date3.Length > date1.Length && date3.Length > date2.Length)
            {
                //date 1 is 2nd & date 2 is 3rd
                if (date1.Length > date2.Length)
                {
                    FirstDateOrder = date3;
                    SecondDateOrder = date1;
                    ThirdDateOrder = date2;

                    System.Windows.Forms.MessageBox.Show("Order is 3, 1, 2");

                    return RedirectToAction("Index");
                }

                //date 2 is 2nd & date 1 is 3rd
                else
                {
                    FirstDateOrder = date3;
                    SecondDateOrder = date2;
                    ThirdDateOrder = date1;

                    System.Windows.Forms.MessageBox.Show("Order is 3, 2, 1");

                    return RedirectToAction("Index");
                }

            }

            
            return RedirectToAction("Index");
        }

-----------------------------

--------------
and my view:

	@model HolidayBookingApp.Models.Dates

@{
    ViewBag.Title = "Create3";
}

<h2>Create3</h2>

<script src="@Url.Content("~/Scripts/jquery.validate.min.js")" type="text/javascript"></script>
<script src="@Url.Content("~/Scripts/jquery.validate.unobtrusive.min.js")" type="text/javascript"></script>

@using (Html.BeginForm()) {
    @Html.ValidationSummary(true)
    <fieldset>
        <legend>Dates</legend>

        <div class="editor-label">
            @Html.LabelFor(model => model.date1)
        </div>
        <div class="editor-field">
            @Html.EditorFor(model => model.date1)
            @Html.ValidationMessageFor(model => model.date1)
        </div>

        <div class="editor-label">
            @Html.LabelFor(model => model.date2)
        </div>
        <div class="editor-field">
            @Html.EditorFor(model => model.date2)
            @Html.ValidationMessageFor(model => model.date2)
        </div>

        <div class="editor-label">
            @Html.LabelFor(model => model.date3)
        </div>
        <div class="editor-field">
            @Html.EditorFor(model => model.date3)
            @Html.ValidationMessageFor(model => model.date3)
        </div>

        <p>
            <input type="submit" value="Create" />
        </p>
    </fieldset>
}

<div>
    @Html.ActionLink("Back to List", "Index")
</div>"Index")


</div>

---------------
Not sure where to go from here something like create a paramter in the Index View which pulls across the order?

Any help would be great thanks guys and sorry about the essay

steve_94966136-Dec-12 21:37

Re: [VB.NET 2008] How to detect if a page of a TabControl is selected (Windows CE)

6-Dec-12 21:37

Hi,
I'm developing an application that runs in a Windows CE 5.0 environment and I'm using VB.NET in Visual Studio 2008 Pro.
In a Form I have a TabControl with some pages.
My problem is to understand when a page of the TabControl is selected to perform some actions in that page automatically.
In the Compact Framework there isn't the event Control.Enter so I can't use it, that would be the right one...

Does anyone have any idea?

Thanks

Zaf Khan10-Dec-12 17:57

Zaf Khan

10-Dec-12 17:57

Taking a look at the documentation....
Documentation
Shows us that the Tab Control notifies the PARENT object using WM_Notify messaging.

So you need to look into WM_Notfication messages.
A little more can be found here
Look under Notification section

Re: [VB.NET 2008] How to detect if a page of a TabControl is selected (Windows CE)

steve_949661311-Dec-12 21:20

Re: [VB.NET 2008] How to detect if a page of a TabControl is selected (Windows CE)

11-Dec-12 21:20

Thank you Zaf.
You gave me some useful information.
I honestly do not know well how to use the WM_NOTIFY messages but looking on google I found various information about it, maybe something like this:

Const WM_MESSAGE_TO_MANAGE As Integer = ... 'integer value of the message

Protected Overrides Sub WndProc(ByRef m As System.Windows.Forms.Message)
    If m.Msg = WM_MESSAGE_TO_MANAGE Then
        'things to do
    End If
    MyBase.WndProc(m)
End Sub

In the specific situation I solved my problem in an alternative way (I don't use more different pages of the TabControl but on a single page I add N UserControl and step from one to another with buttons and I use the Click event to do what it takes) but surely this method can be useful to me on other occasions so I will look into the subject.

Thank you very much.

Zaf Khan12-Dec-12 2:13

Zaf Khan

12-Dec-12 2:13

Hello Steve,

I came across the WM_NOTIFY message and (inter?) windows messaging in the REBAR control (ribbon/taskbar) manipulation code sample on the microsoft website which also provided me with a sample implementation that i found understandable, during the time when i was learning microsoft VB5 CCE.

[VB.NET 2008] How to get control on objects created at runtime

steve_94966135-Dec-12 4:54

Re: [VB.NET 2008] How to get control on objects created at runtime

5-Dec-12 4:54

Hi,
perhaps the subject is not so explanatory but now I try to explain with an example that well represents my problem.
I have a UserControl with two NumericUpDown and a button, then I have a Form1 with a TabControl1 with just one page.
Loading the form I add some pages to the TabControl and I put in every page my UserControl (called "base") in this way:

Public Class Form1

  Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
    Dim mypag As TabPage
    Dim myuc As base

    For i As Int32 = 0 To 10
      mypag = New TabPage
      myuc = New base
      myuc.Parent = mypag
      mypag.Text = "Pag" & i.ToString
      mypag.Name = "Pag" & i.ToString
      TabControl1.TabPages.Insert(1 + i, mypag)
    Next

  End Sub

End Class

Than with the button on the page of the TabControl I pass to the next page of the TabControl (and this is done) but I also want to put in the first NumericUpDown of the "next page" the sum of the value of the two NumericUpDown in the current page (the one with the button just pressed) and I don't know how to do this.
The code in the button is:

Public Class base

  Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
    Dim tmp, id As Int32

    'sum value
    tmp = NUD1.Value + NUD2.Value  'NUD1 and NUD2 are two NumericUpDown
    'index of the current page
    id = CType(Parent.Parent, TabControl).SelectedIndex
    'go to next page
    CType(Parent.Parent, TabControl).SelectedIndex += 1

  End Sub

End Class

I don't know how to "poit" to the NumericUpDown of a page different from the one in witch I am, even if I can get the index of that page (I think...)
I tryed something like this:

'this should be the next page
CType(Parent.Parent, TabControl).TabPages(id + 1)
'but this doesn't work:
CType(Parent.Parent, TabControl).TabPages(id + 1).NUD1.Value
'NUD1 is not a member of System.Windows.Forms.TabPage

Can someone give me some advice?

Thanks in advance

Eddy Vluggen5-Dec-12 5:40

Eddy Vluggen

5-Dec-12 5:40

Where are you creating the NumericUpDown controls? At that point, you'd like to keep a reference to it, at class-level.

Public Class Form1: Form
  Private n1 as NumericUpDown

  Sub New()
    n1 = new NumericUpDown
    Controls.Add(n1)
  End Sub
End Class

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]
They hate us for our freedom![^]

Re: [VB.NET 2008] How to get control on objects created at runtime

steve_94966135-Dec-12 20:59

Re: [VB.NET 2008] How to get control on objects created at runtime

5-Dec-12 20:59

The NumericUpDown controls are in the UserControl I called "base" (together with the button), not in Form1, and I created them in the design mode, not writing the code as in your example.
In Form1 there is the TabControl in witch at runtime I put 10 pages, each one with a copy of "base" inside.
I did this because I needed a series of screens all the same and this was the most convenient way because I had to design only one screen (and also the build is faster).
The final result should be a series of tabbed pages all the same, the user begins to fill in the first, then the second and at that moment some fields on the page are automatically filled with the data entered on the previous page, and so on page after page.
All the controls are in the UserControl so I think I have to manage this mechanism inside the UserControl (perhaps the button to pass to the next page is not the better place to put the code in because the user can go to the next page also by clicking the tab of the page but in the real page there are also other controls I can use like a CheckBox that must be checked to enable the other controls).
My problem is that when the user is in the page N, I don't know how to reach the controls in page N-1 or N+1.
If I simply design 10 pages in the TabControl, all the same, there is no problem because each control on each page is a single object with a unique name so I have no problem to address it, but this is not the most elegant solution..

Eddy Vluggen6-Dec-12 2:27

Eddy Vluggen

6-Dec-12 2:27

steve_9496613 wrote:
and I created them in the design mode

Topic title says "created at runtime", not the designer. If you're using the designer then you can give the controls a unique name indeed, and use that - which is the elegant solution; they'd have a reference on the form-level. There's no need to look them up through the "current" tabpage, as far as the form is concerned, all pages exist.

steve_9496613 wrote:
My problem is that when the user is in the page N, I don't know how to reach the controls in page N-1 or N+1.

The same as you reach the tabpage;

NumericUpDown1.Value = 1

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]
They hate us for our freedom![^]

Re: [VB.NET 2008] How to get control on objects created at runtime

steve_94966136-Dec-12 3:26