public List <UserPaginationViewModel> GetUser_Pagination(int Skip) { var result = new List <UserPaginationViewModel>(); var obj = new UserPaginationViewModel(); using (AstonContext dbContext = new AstonContext()) { dbContext.Database.OpenConnection(); DbCommand cmd = dbContext.Database.GetDbConnection().CreateCommand(); cmd.CommandText = "dbo.sp_UserPagination"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Skip", SqlDbType.Int) { Value = Skip }); using (var reader = cmd.ExecuteReader()) { var Userlist = dbContext.DataReaderMapToList <UserPaginationViewModel>(reader); foreach (var User in Userlist) { result.Add(User); } cmd.Connection.Close(); } } return(result); }
public List <UserPaginationViewModel> GetUser_Pagination(int Skip) { var result = new List <UserPaginationViewModel>(); var obj = new UserPaginationViewModel(); using (NpgsqlConnection connection = new NpgsqlConnection(ConfigureSetting.GetConnectionString)) { connection.Open(); string sql = "sp_userpagination"; using (NpgsqlCommand command = new NpgsqlCommand(sql, connection)) { command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@skip", NpgsqlTypes.NpgsqlDbType.Integer, Skip); using (var reader = command.ExecuteReader()) { result = DataReaderMap.DataReaderMapToList <UserPaginationViewModel>(reader); } } connection.Close(); } return(result); }
public IActionResult Index(string searchString, int pageNum = 1, int pageSize = 3) { ViewBag.searchString = searchString; List <UserReadViewModel> users = _context.appUsers.Where(x => !string.IsNullOrEmpty(searchString) ? x.UserName.Contains(searchString) : true) .OrderBy(x => x.Id).Skip((pageNum - 1) * pageSize).Take(pageSize) .Select(n => new UserReadViewModel { Id = n.Id, UserName = n.UserName, Gender = n.Gender }).ToList(); int TotalPage = (int)Math.Ceiling(Decimal.Divide(_context.appUsers.Count(x => !string.IsNullOrEmpty(searchString) ? x.UserName.Contains(searchString) : true), pageSize)); UserPaginationViewModel PageData = new UserPaginationViewModel() { pagination = _paginationService.GetPagination(pageNum, pageSize, TotalPage), users = users }; return(View(PageData)); }