How to get list of data in Model?

Question

I have ceremony Model and it has id, date.

I want to get ceremonies which are date<= today.

This is my function in service class.

 public virtual IList<Ceremony> GetAllCeremonyByDate(DateTime currentDate)
        {

            var query = from c in _ceremonyRepository.Table
                        where c.ceremony_date >= currentDate
                        select c;
            var countries = query.ToList();
            return countries;

        }

This is my controller.

   public ActionResult DetailForm()
            {

                Ceremony model = new Ceremony();

                var ceremonyDate = _ceremonyService.GetAllCeremonyByDate(DateTime.Now);
                if (ceremonyDate.Count == 0)
                    return Content("No ceremony can be loaded");

                if (ceremonyDate.Count > 0)
                {

                    foreach (var c in ceremonyDate)
                       // My problem


                }

                return View(model);

            }

I don't know how to assign value to model.

Which kind of value you want to assign?

cuongle
– cuongle

2012-10-08 05:38:04 +00:00
Commented Oct 8, 2012 at 5:38 — cuongle
– cuongle, Commented Oct 8, 2012 at 5:38
ceremony_id and ceremony_date.there are int and dateTime.

aruni
– aruni

2012-10-08 05:40:05 +00:00
Commented Oct 8, 2012 at 5:40 — aruni
– aruni, Commented Oct 8, 2012 at 5:40

Andrew Cooper · Accepted Answer · 2012-10-08 05:42:22Z

1

What type is the view expecting?

If it's IEnumerable<Ceremony> (or something similar) then your controller just needs to be:

public ActionResult DetailForm()
{
    var model = _ceremonyService.GetAllCeremonyByDate(DateTime.Now);

    if (model.Count == 0)
    {
        return Content("No ceremony can be loaded");
    }
    else
    {
        return View(model);
    }
}

If the view is expecting a Ceremony then you need to decide which one to send back. If you just want the first valid one then you could do something like:

public ActionResult DetailForm()
{
    var ceremonies = _ceremonyService.GetAllCeremonyByDate(DateTime.Now);

    if (ceremonies.Count == 0)
    {
        return Content("No ceremony can be loaded");
    }
    else
    {
        return View(ceremonies.First());
    }
}

answered Oct 8, 2012 at 5:42

Andrew Cooper

32.7k5 gold badges86 silver badges124 bronze badges

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

Comments

Leniel Maccaferri · Accepted Answer · 2012-10-08 05:42:26Z

1

Since you're returning a IList<Ceremony> your view should accept a model compatible with this type. For example:

Controller

var ceremonies = _ceremonyService.GetAllCeremonyByDate(DateTime.Now);

if (ceremonies.Count == 0)
{
   return Content("No ceremony can be loaded");
}
else
{
    return View(ceremonies);
}

View

@model IEnumerable<Ceremony>

Then you can enumerate your ceremonies in the view like this:

@foreach (var ceremony in Model)
{
  ...
}

I also think you need to correct your logic. Instead of >= use <=.

var query = from c in _ceremonyRepository.Table
            where c.ceremony_date <= currentDate
            select c;

answered Oct 8, 2012 at 5:42

Leniel Maccaferri

103k48 gold badges381 silver badges495 bronze badges

Comments

Ammar · Accepted Answer · 2012-10-08 05:41:58Z

0

You would just assign the values to the model instant inside your foreach loop. For example,

model.id = c.id;
model.date=c.date;

answered Oct 8, 2012 at 5:41

Ammar

1,0682 gold badges13 silver badges22 bronze badges

Collectives™ on Stack Overflow

How to get list of data in Model?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related