public List <String> GetAllFirewallEntries(FirewallMode firewallMode, FirewallArea area)
{
var query = new Sql().Select("IPAddress").From(FortressConstants.TableNames.FortressFirewallEntry);
query.Append(" WHERE Area =@0", area.ToString());
query.Append(" AND FirewallMode =@0", firewallMode.ToString());
var db = ApplicationContext.Current.DatabaseContext.Database;
var pageDetails = db.Fetch <string>(query);
return(pageDetails);
}
public Page <FortressFirewallEntry> GetFirewallEntries(int page, FirewallMode firewallMode, FirewallArea area)
{
var query = new Sql().Select("*").From(FortressConstants.TableNames.FortressFirewallEntry);
query.Append(" WHERE Area =@0", area.ToString());
query.Append(" AND FirewallMode =@0", firewallMode.ToString());
query.OrderBy("Id asc");
var db = ApplicationContext.Current.DatabaseContext.Database;
var pageDetails = db.Page <FortressFirewallEntry>(page, 50, query);
return(pageDetails);
}
