Read Data from table with no relationship

Question

I have some global information (Company name, street, phone, …) stored in a table "CompInfo". This table has only one entry and has no relationship to other tables.

Now I need this information in a view to generate, i.e. offers. I tried to add this data in the controller, but I don't know how I can send this info to my view.

Here is my controller:

public async Task<IActionResult> Offer(int qry_offer)
{
    ViewData["Message"] = "Offer";


    var x412Context = _context.Offer
        .Where(m => m.Id == qry_offer);


    x412Context = x412Context
        .Include(o => o.Kunde)
        .Include(o => o.Mandant)
        .Include(m => m.OfferPos)
            .ThenInclude(m => m.Ust)
        ;
    return View(await x412Context.ToListAsync());
}

First I add the following code

var Comp_Info = _context.CompInfo
    .Where(m => m.Id == 1);

With breakpoints and debugging I see that Comp_Info has the information I require. But I don´t know how to get this info to my view.

I tried

ViewData["street"] = Comp_Info.street;

But this doesn't work.

Does anyone have an idea how I can transmit the data to the view?

Answer 1

You can return a viewmodel in your Offer method that looks like this :

public class FooVM
{
  public List<Offer> Offers {get; set;}
  public CompInfo CompInfo{get; set;}
}

and in your controller initilize the FooVm like this:

var vm = new FooVM 
{
  Offers = await x412Context.ToListAsync(),
  CompInfo =  Comp_Info 
};

and then in your Offer Method you return View(vm);

then your Offer.cshtml will look something like :

@model FooVm;
// some html code 
@foreach (var offer in Model.Offers)
{
// Do something
}
<span>@Model.CompInfo.Street</span>

Answer 2

you can implement another class which should have members as the list (of the same type x412Context.ToListAsync()) and another member which will have the same datatype as Comp_Info.street.

then you can return the same class object to the view like return View(newClassObj);, you can access it as we do to access model class members in view.