ASP.NET MVC Passing DataTime to View a

Question

I have a asp.net MVC4 web project it shows a list of production data for that day. I have added a datetime picker which allows the user to select a date that they want to show information for.

The problem i am having is i am not sure how to go about passing the information back to the view from the method i have inside the controller.

I have the date passing back to the controller. Inside the controller i am doing a LINQ statement that allows me to select only the production data for that day.

  [HttpPost]
    public ActionResult GetProductionDateInfo(string dp)
    {
        DateTime SelectedDate = Convert.ToDateTime(dp);
        DateTime SelectedDateDayShiftStart = SelectedDate.AddHours(7);
        DateTime SelectedDateDayShiftEnd = SelectedDate.AddHours(19);

        var ProductionData =

            from n in db.tbl_dppITHr
            where n.ProductionHour >= SelectedDateDayShiftStart
            where n.ProductionHour <= SelectedDateDayShiftEnd
            select n;


        return View();

I am looking to get the Var ProductionData passed back to the view so that display it inside a table.

Darren · Accepted Answer · 2013-09-23 08:57:33Z

2

You can return ProductionData directly to your View.

 return View(productionData)

And then in your View you could have @model IEnumerable<Type>

However, a better practice would be to create a strongly typed ViewModel to hold the ProductionData and then return the following:

 var model = new ProductionDataViewModel();
 model.Load();

 return View(model);

Where model a definition as follows:

public class ProductionDataViewModel { 

   public List<ProductionDataType> ProductionData { get; set; }
   public void Load() {
       ProductionData = from n in db.tbl_dppITHr
        where n.ProductionHour >= SelectedDateDayShiftStart
        where n.ProductionHour <= SelectedDateDayShiftEnd
        select n;
   }
}

Then in your view use the new strongly typed ViewModel:

 @model ProductionDataViewModel

edited Sep 23, 2013 at 8:57

answered Sep 23, 2013 at 8:49

Darren

71.2k24 gold badges141 silver badges146 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mathew Thompson · Accepted Answer · 2013-09-23 08:49:18Z

0

Use a model, something like:

public class ProductionDataModel
{
    //put your properties in here

    public List<ProductionData> Data { get; set; }
}

Then create/return it in your ActionResult:

var ProductionData =
    from n in db.tbl_dppITHr
    where n.ProductionHour >= SelectedDateDayShiftStart
    where n.ProductionHour <= SelectedDateDayShiftEnd
    select new ProductionData
    {
        //set properties here
    };

var model = new ProductionDataModel
{
    Data = ProductionData
};


return View(model);

Then in your view, set your model at the top:

@model ProductionDataModel

answered Sep 23, 2013 at 8:49

Mathew Thompson

56.5k15 gold badges131 silver badges151 bronze badges

Comments

Connell · Accepted Answer · 2013-09-23 08:50:08Z

0

Your ProductionData variable should now be of type IEnumerbable<tbl_dppITHrRow>.

You can pass in the model from your controller using this code at the bottom of your action:

return View(ProductionData);

In your view, you can make this your model type by placing the following Razor code in your view's .cshtml file:

@model IEnumerbable<tbl_dppITHrRow>

Then, you can use your model in your view code:

@foreach(var row in Model) {
    <div>@row.Value</div>
}

answered Sep 23, 2013 at 8:50

Connell♦

14.4k11 gold badges62 silver badges98 bronze badges

Comments

Vinay Pratap Singh Bhadauria · Accepted Answer · 2013-09-23 08:53:08Z

0

The problem here is that you are returning nothing to your view here return View(); this view just render view and no data will be passed to it.

if ProductionData is getting values then

return return View(ProductionData);

You can then use the values passed in the view.

edited Sep 23, 2013 at 8:53

answered Sep 23, 2013 at 8:47

Vinay Pratap Singh Bhadauria

9,9873 gold badges30 silver badges50 bronze badges

Collectives™ on Stack Overflow

ASP.NET MVC Passing DataTime to View a

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related