Query calling batches and sub batches

Question

0.00/5 (No votes)

See more:

Hi was wondering can someone help me with this code below I am trying call the batches and subbatches but sub batches are null . I know I am only returning batches to view but how would I call them both

C#

public ActionResult Index()
        {
            var batchesQuery = db.Batches;

            var Batches = batchesQuery.Select(batch => new BatchInfoView
            {
                BatchID = batch.BatchID,
                BatchName = batch.Name
            }).ToList();

            var SubBatches = batchesQuery.Select(subBatch => new SubBatchInfoView
            {
                SubBatchID = subBatch.SubBatches.Select(sbi => sbi.SubBatchID),
                SubBatchName = subBatch.SubBatches.Select(sbn => sbn.Code),
                SubBatchCount = subBatch.SubBatches.Select(sbc => sbc.SubBatchID).Count()
            }).ToList();

            return View(Batches);
        }

BatchInfoView

XML

namespace SIMCardAdmin.Web.Models.Batch
{
    public class BatchInfoView
    {
        /// <summary>
        /// Flag to determine if this model is new.
        /// </summary>
        public bool IsNew { get; set; }

        /// <summary>
        /// The ID of the Batch.
        /// </summary>
        public int BatchID { get; set; }

        /// <summary>
        /// The name of the Batch, for display purposes.
        /// </summary>
        public string BatchName { get; set; }

        public List<SubBatchInfoView> SubBatches { get; set; }
    }
}

SubBatchInfoView

XML

public class SubBatchInfoView
    {
        /// <summary>
        /// The ID of the SubBatch, use this to jump to a list for this SubBatch.
        /// </summary>
        public IEnumerable<int> SubBatchID { get; set; }

        /// <summary>
        /// The name of the SubBatch, for display purposes.
        /// </summary>
        public IEnumerable<string> SubBatchName { get; set; }

        /// <summary>
        /// The count of the SubBatch, for display purposes.
        /// </summary>
        public int SubBatchCount { get; set; }
    }

Posted 1-Nov-15 23:31pm

Member 11838038

Updated 2-Nov-15 4:04am

v3

Add a Solution

Comments

John C Rayan 2-Nov-15 9:10am

What is the relationship between Batch and SubBatch. When you load db.Batches make sure that you .include(SubBatch) too.

Member 11838038 2-Nov-15 9:11am

Batch has many sub-batches

Member 11838038 2-Nov-15 9:18am

I have tried .include(SubBatch) didnt work still throwing error

Richard Deeming 2-Nov-15 10:02am

Update your question with the definition of both BatchInfoView and SubBatchInfoView.

At the moment, you're loading the SubBatchInfoView list, but not adding them to the corresponding BatchInfoViewList items.

Member 11838038 2-Nov-15 10:05am

I have updated the question

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard Deeming · Accepted Answer · 2015-11-02T04:14:00

Your view models really don't make any sense. Each batch has a list of sub-batches, but then each sub-batch has a list of IDs, a list of names, and a count of the number of sub-batches.

I suspect you want something that looks like this:

C#

public class BatchInfoView
{
    public bool IsNew { get; set; }
    public int BatchID { get; set; }
    public string BatchName { get; set; }
    public List<SubBatchInfoView> SubBatches { get; set; }

    public int SubBatchCount
    {
        get { return SubBatches == null ? 0 : SubBatches.Count; }
    }
}

public class SubBatchInfoView
{
    public int SubBatchID { get; set; }
    public string SubBatchName { get; set; }
}

Then you'll need to load the sub-batches as part of the query to load the batches:

C#

var batches = db.Batches
    .Include(batch => batch.SubBatches)
    .Select(batch => new BatchInfoView
    {
        BatchID = batch.BatchID,
        BatchName = batch.Name,
        SubBatches = batch.SubBatches.Select(sb => new SubBatchInfoView
        {
            SubBatchID = sb.SubBatchID,
            SubBatchName = sb.Code,
        }).ToList()
    })
    .ToList();