Solved

MVC4 - Convert Blank Date TextBoxFor Field

Posted on 2014-10-21
10
517 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
Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

 

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
 

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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Performance in games development is paramount: every microsecond counts to be able to do everything in less than 33ms (aiming at 16ms). C# foreach statement is one of the worst performance killers, and here I explain why.
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

813 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

17 Experts available now in Live!

Get 1:1 Help Now