Click here to Skip to main content
15,881,757 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more: , +
==========Problem==========

Cannot add functions to Next previous last first for create action using repository

pattern based on EmployeeId field

==========Example==========

Employee Id : 5 as last record

IF create action view get loaded it must show max+1 for Employee Id meaning it will show 6
IF Click NextButton become 6

IF Click previousButton become 4 and get another data related as name age,etc...

IF Click LastButton become 5 and get another data related as name age,etc...

IF Click FirstButton become 1 and get another data related as name age,etc...

=======technology Used============
I work in visual studio 2017 asp.net core 2.1 sql server 2012 using repository pattern generic

What I have tried:

===========Employee Controller Have Create Action=====

public class EmployeesController : Controller
    {
        private readonly IEmployees _context;

        public EmployeesController(IEmployees context)
        {
            _context = context;
        }

        
        // GET: Employees/Create
        public IActionResult Create()
        {
How to call functions below
         //   var maxId =   maxid+1;
getNext()
getprevious()
getlast()
getfirst()
            return View();
        }
===============Generic Repository Pattern(required function I dont know======
 
 public class EFRepository<T> : IRepository<T> where T : class
    {
        protected TabDbContext _context { get; set; }
        public EFRepository(TabDbContext context)
        {
            _context = context;
        }
getNext(){
what implementation write
}
getprevious()
{
what implementation write
}
getlast()
{
what implementation write
}
getfirst()
{
what implementation write
}
public IQueryable<T> GetAll()
        {
            return _context.Set<T>();
        }

        public virtual async Task<ICollection<T>> GetAllAsyn()
        {

            return await _context.Set<T>().ToListAsync();
        }

        public virtual T Get(int id)
        {
            return _context.Set<T>().Find(id);
        }

        public virtual async Task<T> GetAsync(int id)
        {
            return await _context.Set<T>().FindAsync(id);
        }

       
        public virtual T Find(Expression<Func<T, bool>> match)
        {
            return _context.Set<T>().SingleOrDefault(match);
        }

        public virtual async Task<T> FindAsync(Expression<Func<T, bool>> match)
        {
            return await _context.Set<T>().SingleOrDefaultAsync(match);
        }

        public ICollection<T> FindAll(Expression<Func<T, bool>> match)
        {
            return _context.Set<T>().Where(match).ToList();
        }

        public async Task<ICollection<T>> FindAllAsync(Expression<Func<T, bool>> match)
        {
            return await _context.Set<T>().Where(match).ToListAsync();
        }

}
=====Buttons Navigation on Create View Of Employee Controller====
<div class="title_of_div">
    <button id="BtnFirst" style="display:inline">First</button>
    <button id="BtnNext" style="display:inline">Next</button>
    <button id="BtnPrevious" style="display: inline">Previous</button>
    <button id="BtnLast" style="display: inline">Last</button>
</div>
view create controlls
===========Create Action Get==========
 <form asp-action="Create">

            <div asp-validation-summary="ModelOnly" class="text-danger"></div>
            <div class="form-group">
                <label asp-for="EmployeeId" class="control-label"></label>
                <input asp-for="EmployeeId" class="form-control" />
                <span asp-validation-for="EmployeeId" class="text-danger"></span>
            </div>
            <div class="form-group">
                <label asp-for="BranchCode" class="control-label"></label>
                <input asp-for="BranchCode" class="form-control" />
                <span asp-validation-for="BranchCode" class="text-danger"></span>
            </div>
            <div class="form-group">
                <label asp-for="EmployeeName" class="control-label"></label>
                <input asp-for="EmployeeName" class="form-control" />
                <span asp-validation-for="EmployeeName" class="text-danger"></span>
            </div>
            
        </form>
    </div>
</div>
============Model related data=============
public class Employee
    {
        [Key]
        public int EmployeeId { get; set; }
        public int BranchCode { get; set; }
        public string EmployeeName { get; set; }
   
    }
Posted
Updated 31-Jul-22 5:41am

1 solution

1) "Create" doesn't require an id; the id is assigned by EF for any IDENTITY / [Key] field / attribute.

2) Next: ..Where( e => e.Id > 5 ).Orderby( e => e.Id ).FirstOrDefault()

3) Prev: ..Where( e => e.Id < 5 ).Orderby( e => e.Id ).LastOrDefault()

4) First: ..Orderby( e => e.Id ).FirstOrDefault()

5) Last: ..Orderby( e => e.Id ).LastOrDefault()
 
Share this answer
 
Comments
ahmed_sa 6-Jan-19 15:18pm    
thank you for reply
this is meaning make action for every next,prev,first,last

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900