Solved

MVC4 - Convert Blank Date TextBoxFor Field

Posted on 2014-10-21
10
507 Views
Last Modified: 2014-11-24
Is there a way to format null dates (01-01-1900) in MVC4

Currently, I have:
 
@if (Model.DOB == Convert.ToDateTime("01-01-1900"))
            {
                @Html.TextBoxFor(model => model.DOB, new { @Value = "", @class = "textbox150" })
            }
            else
            {
            @Html.TextBoxFor(model => model.DOB, new { @Value = Model.DOB.ToShortDateString(), @class = "textbox150" })
            }

Open in new window


But to do that for all date fields makes a lot of work.
Is there a way around this.

If so, can someone please provide a detailed example.

thanks.
0
Comment
Question by:elmbrook
  • 5
  • 5
10 Comments
 
LVL 96

Expert Comment

by:Bob Learned
ID: 40397268
You could use Nullable<DateTime> (or DateTime?), and then get the value this way:

var displayDate = model.BirthDate.HasValue ? model.BirthDate.Value.ToString("yyyy-MM-dd") : "";
0
 

Author Comment

by:elmbrook
ID: 40398069
How would that work?

I get an error message when I put in
 @Html.TextBoxFor(model => model.DOB.HasValue ? model.DOB.ToString("yyyy-MM-dd") : "", new {  @class = "textbox150" })

'System.DateTime' does not contain a definition for 'HasValue' and no extension method 'HasValue' accepting a first argument of type 'System.DateTime' could be found (are you missing a using directive or an assembly reference?)
0
 
LVL 96

Expert Comment

by:Bob Learned
ID: 40398115
How is DOB defined in the model?  

You should be able to add a ? to the DateTime declaration:

Example:

public DateTime? DOB { get; set; }

Open in new window


When working with nullable value types (like int or DateTime), it can introduce other issues, but you should be able to check if the property has a value (model.DOB.HasValue).
0
 

Author Comment

by:elmbrook
ID: 40398245
I have put the code in the View, not the controller.

This is how DOB is defined.

  [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)]
        [DataMemberAttribute()]
        public global::System.DateTime DOB
        {
            get
            {
                return _DOB;
            }
            set
            {
                OnDOBChanging(value);
                ReportPropertyChanging("DOB");
                _DOB = StructuralObject.SetValidValue(value);
                ReportPropertyChanged("DOB");
                OnDOBChanged();
            }
        }

Open in new window

0
 
LVL 96

Expert Comment

by:Bob Learned
ID: 40399500
You need to change it to a nullable type:

public global::System.DateTime

         becomes

public global::System.DateTime?
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:elmbrook
ID: 40400497
It won't allow me to do that.

I am in my model designer and when I add a question mark after it, it gives me errors (see screen shot attached).
24-10-2014-9-39-48-a-m-.jpg
0
 
LVL 96

Expert Comment

by:Bob Learned
ID: 40400675
If you are using the Entity Framework designer, then I would have thought that it generated the property type as DateTime?.  If it is not Entity Framework, then what do you use to design the data model?
0
 

Author Comment

by:elmbrook
ID: 40400692
I am using entity framework. My database table fields are all set to not null.
There are no null dates in the database, all I am trying to handle is 01-01-1900 (blank dates).
That was the only way that I could think off on handling blank dates but that means for every date I have to write that code.
I was hoping to find a better solution of handling blank dates.
0
 
LVL 96

Accepted Solution

by:
Bob Learned earned 500 total points
ID: 40402253
1) If you have to use 01-01-1900, then I would suggest changing the database fields to allow null, and use Nullable<DateTime> (DateTime?).

2) If you work in a restrictive environment, where database changes require an act of God, then translation is easy.  I would always suggest using nullable dates, but that is not set in concrete.

@Html.TextBoxFor(model => Utility.FormatDate(model.DOB, "MM/dd/yyyy")), new { @Value = "", @class = "textbox150" })

internal class Utility 
{
    public static string FormatDate(DateTime dateValue, string mask)
    {
            if (dateValue.ToString("yyyy-MM-dd") == "1900-01-01")
                return "";

            return dateValue.ToString(mask);
    }
}

Open in new window


3) Another approach is to use a View Model, and an entity mapper, like AutoMapper, where you can format the dates in all the view models, and then you wouldn't have to do any logic in the view.
0
 

Author Closing Comment

by:elmbrook
ID: 40463692
Bob - The solutions provided are just that, solutions.
I think my original solution is the way to go, it just means I have to process each date manually.

thank you for your time and input.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction Although it is an old technology, serial ports are still being used by many hardware manufacturers. If you develop applications in C#, Microsoft .NET framework has SerialPort class to communicate with the serial ports.  I needed to…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now