public FirewallFiltersModel GetEntries(int page, FirewallArea area)
{
var mode = FirewallMode.Disabled;
var settings = SettingsCache.Instance;
if (area == FirewallArea.BackOffice)
{
mode = settings.BackofficeFirewallMode;
}
else if (area == FirewallArea.FrontEnd)
{
mode = settings.FrontEndFirewallMode;
}
FirewallFiltersModel model = new FirewallFiltersModel();
model.Entries = new List <FirewallFilterModel>();
var entries = CustomDatabase.GetFirewallEntries(page, mode, area);
foreach (var entry in entries.Items)
{
model.Entries.Add(new FirewallFilterModel()
{
ID = entry.Id, IPAddress = entry.IPAddress
});
}
model.CurrentPage = entries.CurrentPage;
model.TotalEntries = entries.TotalItems;
model.TotalPages = entries.TotalPages;
return(model);
}
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);
}
