how to use repeated get data from table from one place by using general function take

[engbarbary]

How to use repeated get data from table from one place by using general function take table name or any solution .

I get data from table reference but there different on table name selected from this table . so that i will use same get data statement on more controller so that to prevent repeated get data i think to put this on one place by general function or any concept prevent repeated but i cannot do that .

on controller actione of employeecontroller

var result = await _context.ReferenceFiles.Where(r => r.TableName == "Employees").ToListAsync();
            ViewBag.RefList = result;

on controller actione of Itemcontroller

var result = await _context.ReferenceFiles.Where(r => r.TableName == "Items").ToListAsync();
            ViewBag.RefList = result;

on view

 @foreach (var itemes in ViewBag.RefList)

{
    <thead>

            @itemes.FieldName

</thead>
}

Table Reference have 3 fields

code

FieldName

TableName

[jmcilhinney]

In my office, we pretty much always create our own base class for our controllers because we pretty much always have common functionality to put there. You can do the same and declare in it a method that takes the TableName` value as an argument and returns the result. You then call that method in each controller class that inherits that base class.

[jmcilhinney]

Your base class might look something like this:

public class ControllerBase : Controller
{
    protected async List<ReferenceFile> GetReferenceFilesAsync(string tableName)
    {
        return await _context.ReferenceFiles.Where(r => r.TableName == tableName).ToListAsync();
    }
}

Note that that code as is would require '_context' to be declared in the base class too, rather than in each individual controller. If you don't want to do that, you'd have to pass the context in as an argument too.

[engbarbary]

Thank you for reply
can you tell me which base class i will define function

[engbarbary]

Thank you for reply
can you tell me which base class i will define function

[jmcilhinney]

By default, all your controllers inherit the Controller class. Instead, you declare your own class that inherits Controller (in my example, I have named that class ControllerBase) and then you make all your controllers inherit that class instead. E.g. instead of this:

public class ThingController : Controller
{
    // Your actions here.
}

you would have this:

public class ControllerBase : Controller
{
    // Common functionality here.
}

and this:

public class ThingController : ControllerBase
{
    // Your actions here.
}

If you don't understand base classes and inheritance, you should do some reading on the subject.

[engbarbary]

thank you for reply
this is good thing
but if i need to load automatically with every controller without call it what i do

[engbarbary]

and context from which place i will define it
are context also will defined on controller