HTML datepicker value not being saved correclt in controller

Question

HTML datepicker value not being saved correclt in controller

Grant Meyer 0

Hi there

I have an asp.net core web application with a datepicker on my view, I'm using model binding to pass the data to the controller method which creates my data. This all works 100% except for my date value from the datepicker, its saved in the database as "0001-01-01 00:00:00.0000000" and I cant figure out what i'm doing wrong. Below a code snippet from the view and controller method.

@using (Html.BeginForm("PlaceOrder", "CustomerOrders", FormMethod.Post))
{
<div class="container" style="margin-top: 1%;">
    <div class="row">
        <div class="col-md-12 d-flex justify-content-between align-items-center">
            <h3 class="custom-header">New Order</h3>
                <div id="deliveryDateContainer" class="d-flex align-items-center" style="white-space: nowrap;">
                    <label for="DateRequired" class="me-2">Date Required:</label>
                    <input type="date" id="DateRequired" asp-for="OrderHeaderModel.DateRequired" asp-format="{0:yyyy-MM-ddTHH:mm}" class="form-control" style="padding-right: 50px">
                </div>
        </div>
    </div>
</div>

            var orderHeader = new CustomerOrderHeaderModel
            {
                OrderId = Guid.NewGuid(),
                OrderDate = DateTime.Now,   
                CustomerId = customerId,
                OrderNumber = newOrderNumber.ToString(),
                OrderStatus = "Placed",
                TotalAmount = orderModel.OrderLinesModels.Sum(l => l.UnitPrice * l.OrderQty),
                DateRequired = orderModel.OrderHeaderModel.DateRequired,
                Notes = orderModel.OrderHeaderModel.Notes,  
            };

Thank you in advance

AgaveJoe 1,510 Reputation points

2023-07-20T13:50:42.31+00:00

0001-01-01 00:00:00.0000000 is basically zero, the default for a date when a date is not populated or the model binder cannot match the payload arguments to the action parameters. I assume the issue if the input name "OrderHeaderModel.DateRequired" does not match the model parameter name.

Can you share the model passed to the View or the Action parameters?

2 answers

Your answer

AgaveJoe 1,510 Reputation points

2023-07-20T13:50:42.31+00:00

0001-01-01 00:00:00.0000000 is basically zero, the default for a date when a date is not populated or the model binder cannot match the payload arguments to the action parameters. I assume the issue if the input name "OrderHeaderModel.DateRequired" does not match the model parameter name.

Can you share the model passed to the View or the Action parameters?

Answer 1

Thank you for your feedback AgaveJoe
I've made 100% sure to select a date from the datepicker before placing the order. Below is my customerOrderHeaderModel and my full controller method and service. Please let me know if you need any further info, i'm stumped on this one.

public partial class CustomerOrderHeaderModel
{
    [Key]
    [DisplayName("Order Id:")]
    public Guid OrderId { get; set; }

    [DisplayName("Order Date:")]
    public DateTime OrderDate { get; set; }

    [DisplayName("Customer Id:")]
    public Guid CustomerId { get; set; }

    [DisplayName("Order No:")]
    public string OrderNumber { get; set; } = null!;

    [DisplayName("Order Status:")]
    public string OrderStatus { get; set; } = null!;

    [DisplayName("Total Amount:")]
    public decimal TotalAmount { get; set; }

    [DisplayName("Notes:")]
    public string? Notes { get; set; }

    [DisplayName("Date Required:")]
    [BindProperty, DataType(DataType.Date)]
    public DateTime DateRequired { get; set; }

    [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public int TempOrderId { get; set; }    
}

        [HttpPost]
        public async Task<IActionResult> PlaceOrder(CustomerOrderViewModel orderModel)
        {
            var orderNumber = await _customerOrdersService.PlaceOrder(orderModel.OrderHeaderModel.CustomerId, orderModel);

            TempData["NotificationType"] = "success";
            TempData["Notification"] = $"Order placed successfully. Your order number is: {orderNumber}.";

            return RedirectToAction("NewCustomerOrderProductList", "CustomerProducts");   
        }

        public async Task<string> PlaceOrder(Guid customerId, CustomerOrderViewModel orderModel)
        {
            var newOrderNumber = await GenerateOrderNumber();

            var orderHeader = new CustomerOrderHeaderModel
            {
                OrderId = Guid.NewGuid(),
                OrderDate = DateTime.Now,   
                CustomerId = customerId,
                OrderNumber = newOrderNumber.ToString(),
                OrderStatus = "Placed",
                TotalAmount = orderModel.OrderLinesModels.Sum(l => l.UnitPrice * l.OrderQty),
                DateRequired = orderModel.OrderHeaderModel.DateRequired,
                Notes = orderModel.OrderHeaderModel.Notes,  
            };

            await _orderHeaderRepository.CreateOrderHeaderAsync(orderHeader);

AgaveJoe 1,510 Reputation points

2023-07-20T15:17:36.0766667+00:00

The input is named in the view is OrderHeaderModel.DateRequired. You did not share the View but it must be defined as a complex type of OrderHeaderModel where OrderHeaderModel has a member named DateRequired. The model binder is not able to map the action's parameter property name CustomerOrderViewModel.DateRequired to OrderHeaderModel.DateRequired.
Grant Meyer 0 Reputation points

2023-07-20T15:32:30.1866667+00:00

When I inspected my datepicker element I saw that there was an error with the format, so I initialized the DateRequired in my ViewModel as below and that fixed the problem. Thanks AgavaJoe I wouldnt have gotten there without your help.

public class CustomerOrderViewModel { public CustomerOrderViewModel() { OrderHeaderModel = new CustomerOrderHeaderModel { DateRequired = DateTime.Today }; } public CustomerOrderHeaderModel OrderHeaderModel { get; set; } public List<CustomerOrderLinesModel> OrderLinesModels { get; set; } public List<CustomerProductsModel> ProductsModels { get; set; } } }
AgaveJoe 1,510 Reputation points

2023-07-20T15:39:13.8633333+00:00

I'm not sure how this fixes the original problem.
Grant Meyer 0 Reputation points

2023-07-20T15:50:13.3033333+00:00

The date value was being passed to the methods correctly from the view, the issue was the actual format of the date, no matter what date i selected it would default to "0001-01-01 00:00:00.0000000" and that is what was being sent from the view and saved.
AgaveJoe 1,510 Reputation points

2023-07-20T15:56:02.4333333+00:00

The date value was being passed to the methods correctly from the view,

How do you know when the date always defaults to DateTime.Today?

Answer 2

Bruce (SqlWork.com) 77,926 Volunteer Moderator

You don’t have code to check if the postback model is valid. If you did and displayed the error, you would probably see that the date was not a valid format.

Grant Meyer 0 Reputation points

2023-07-20T15:33:48.8733333+00:00

Thanks Bruce, I was scratching all over the place and missed the obvious lol

Share via

HTML datepicker value not being saved correclt in controller

2 answers

Your answer