public List <RolePaginationViewModel> GetRole_Pagination(int Skip)
{
var result = new List <RolePaginationViewModel>();
var obj = new RolePaginationViewModel();
using (NpgsqlConnection connection =
new NpgsqlConnection(ConfigureSetting.GetConnectionString))
{
connection.Open();
string sql = "sp_rolepagination";
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 <RolePaginationViewModel>(reader);
}
}
connection.Close();
}
return(result);
}
public List <RolePaginationViewModel> GetRole_Pagination(int Skip)
{
var result = new List <RolePaginationViewModel>();
var obj = new RolePaginationViewModel();
using (AstonContext dbContext = new AstonContext())
{
dbContext.Database.OpenConnection();
DbCommand cmd = dbContext.Database.GetDbConnection().CreateCommand();
cmd.CommandText = "dbo.sp_RolePagination";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Skip", SqlDbType.Int)
{
Value = Skip
});
using (var reader = cmd.ExecuteReader())
{
var Rolelist = dbContext.DataReaderMapToList <RolePaginationViewModel>(reader);
foreach (var Role in Rolelist)
{
result.Add(Role);
}
cmd.Connection.Close();
}
}
return(result);
}
