How to call datetime column on your controller in asp.net mvc?

Question

Hi Team

I have the code, but my logic needs some improvements meaning i want to find a way to call datetime column from my database not hardcode cz it makes it difficult to do changes. Let me share my logic below;

// Controller.cs
public JsonResult GetAll()
{
return Json(DashboardTimeLine(), JsonRequestBehavior.AllowGet);
}

    public List<Dashboard> DashboardTimeLine()
    {
        List<Dashboard> timeList = new List<Dashboard>();
        timeList.Add(new Dashboard { Incident = 1, FromDateTime = new DateTime(2021, 09, 23, 08, 01, 43), ToDate = new DateTime(2021, 08, 10, 15, 23, 48) });
        timeList.Add(new Dashboard { Incident = 2, FromDateTime = new DateTime(2021, 09, 23, 07, 05, 15), ToDate = new DateTime(2021, 08, 23, 07, 05, 49) });
        timeList.Add(new Dashboard { Incident = 3, FromDateTime = new DateTime(2021, 09, 23, 07, 05, 15), ToDate = new DateTime(2021, 07, 15, 05, 56, 10) });
        return timeList;
    }

// Model.cs
public int Incident { get; set; }

    public DateTime FromDateTime { get; set; }

    public DateTime ToDate { get; set; }


    public string Resources { get; set; }


    public string Description { get; set; }


    public int EndDate { get; set; }
}

Answer 1

Hi @Gcobani Mkontwana ,

i want to find a way to call datetime column from my database not hardcode cz

To access data from the database, you could refer the following article/tutorial to use EF core:

Getting Started With Entity Framework Core - ASP.NET Core

Creating a Model for an Existing Database in Entity Framework Core

Tutorial: Get started with EF Core in an ASP.NET MVC web app

then you can access the data via the DbContext, code like this:

public async Task<IActionResult> Index()  
{  
    return View(await _context.Students.ToListAsync());  
}  

Besides, for the datetime property, if you don't want to hardcode, you could also set the default value, check this article.

If I misunderstand your question or is there any unclear about my reply, please let me know freely.

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Best regards,
Dillion