DateOnly input for asp .net

user_13891980 0
Viewed 1049

I'm using ASP.NET Core 6 MVC to create an app linked to a database and I have an issue :

I scaffolded a controller and its views (create, edit...) but when I try to create an object to send to db with Entity Framework, the DateOnly typed fields won't work and put in this date for all dates I try to write : 292269055-12-03 (it seems to be the max value ?).

I need to use DateOnly type for compatibility reasons because the database has date columns (I found this information here https://www.npgsql.org/doc/types/datetime.html) and if I try to use datetime, it doesn't work.

There is my code :

View :

<div class="form-group">
      <label asp-for="BirthDay" class="control-label"></label>
      <input asp-for="BirthDayUI" class="form-control" type="date"/>
      <span asp-validation-for="BirthDay" class="text-danger"></span>
</div>

Controller (autogenerated) :

[HttpPost]
[ValidateAntiForgeryToken]
public async Task<IActionResult> Create([Bind("Id,Name,FirstName,BirthDay,Email,MobilePhone,LandLinePhone,PostalCity,PostalCode,PostalAdress,Gender,MedicalCertificate,MedicalCertificateStart,MedicalCertificateEnd,ProfilePicture")] Member member)
{
    if (ModelState.IsValid)
    {
        _context.Add(member);
        await _context.SaveChangesAsync();
        return RedirectToAction(nameof(Index));
    }

    return View(member);
}

And finally, the model where I try to fiddle this :

[Required]
public DateOnly BirthDay { get; set; }
[NotMapped]
public DateTime BirthDayUI
{
   get => BirthDay.ToDateTime(new TimeOnly());
   set => BirthDay = DateOnly.FromDateTime(value);
}

The getter works perfectly but not the setter and I don't know what I must change.

Thank you for helping me

.net-6.0 asp.net-core-mvc entity-framework c#
2 Answers

I finally found a solution : I created a UI version of my member model which use DateTime properties and bind my member controller on it (instead of member type) and i use a little function to cast it in my original member type. I named it memberviewmodel (but im not sure the name is pertinent).

        [HttpPost]
        [ValidateAntiForgeryToken]

            public async Task<IActionResult> Create([Bind("Id,Name,FirstName,BirthDay,Email,MobilePhone,LandLinePhone,PostalCity,PostalCode,PostalAdress,Gender,MedicalCertificate,MedicalCertificateStart,MedicalCertificateEnd,ProfilePicture")] **MemberViewmodel membervm**)
            {
                Member member = ModelViewmodelConverter.MemberViewmodelToMember(membervm);
                if (ModelState.IsValid)
                {
                    _context.Add(member);

                    await _context.SaveChangesAsync();
                    return RedirectToAction(nameof(Index));
                }
                return View(member);
            }

the function :

 public static Member MemberViewmodelToMember(MemberViewmodel vm)
        {
            Member result = new Member()
            {
                ...
                BirthDay = DateOnly.FromDateTime(vm.BirthDay),
                ...
            }
            return result;
        }
user_138919800

I have no experience yet with .NET 6, but I did some research about this. https://devblogs.microsoft.com/dotnet/date-time-and-time-zone-enhancements-in-net-6/

And I found next line

DateOnly d3 = DateOnly.ParseExact("31 Dec 1980", "dd MMM yyyy", CultureInfo.InvariantCulture);  // Custom format

Try to use this on your setter, like this:

set => BirthDay =  DateOnly.ParseExact(value.ToShortDateString(), "dd MMM yyyy", CultureInfo.InvariantCulture);

Don't forget to specify the format and cultureinfo

Let me known if this works!

user_165620880
Related