public IEnumerable <UserManagement> FindAll(int pageNum = 1, int pageSize = 10)
{
try
{
using (var conn = SqlDatabaseConnectionHelper.OpenConnection())
{
var result = conn.Query <UserManagement>("SELECT [Id] ,[Username] ,[Firstname] ,[Lastname] ,[Password] ,[EmailAddress] FROM [application_settings](nolock)");
return(result);
}
}
catch (Exception exception)
{
}
return(null);
}
public IEnumerable <Reports> FindAll(int pageNum = 1, int pageSize = 10)
{
try
{
using (var conn = SqlDatabaseConnectionHelper.OpenConnection())
{
var result = conn.Query <Reports>(sql: "reports_findall",
commandType: CommandType.StoredProcedure);
return(result);
}
}
catch (Exception exception)
{
}
return(null);
}
