/// <summary>
/// Gets an IList with page of instances of BannedIPAddresse.
/// </summary>
public static List <BannedIPAddress> GetPage(
int pageNumber,
int pageSize,
out int totalPages)
{
totalPages = 1;
List <BannedIPAddress> bannedIPAddressList
= new List <BannedIPAddress>();
using (IDataReader reader
= DBBannedIP.GetPage(
pageNumber,
pageSize,
out totalPages))
{
while (reader.Read())
{
BannedIPAddress bannedIPAddress = new BannedIPAddress();
bannedIPAddress.rowID = Convert.ToInt32(reader["RowID"]);
bannedIPAddress.bannedIP = reader["BannedIP"].ToString();
bannedIPAddress.bannedUTC = Convert.ToDateTime(reader["BannedUTC"]);
bannedIPAddress.bannedReason = reader["BannedReason"].ToString();
bannedIPAddressList.Add(bannedIPAddress);
}
}
return(bannedIPAddressList);
}
/// <summary>
/// Returns true if the passed in address is banned
/// </summary>
/// <param name="ipAddress"> ipAddress </param>
/// <returns>bool</returns>
public static bool IsBanned(string ipAddress)
{
if (string.IsNullOrEmpty(ipAddress))
{
return(false);
}
return(DBBannedIP.IsBanned(ipAddress));
}
/// <summary>
/// Updates this instance of BannedIPAddress. Returns true on success.
/// </summary>
/// <returns>bool</returns>
private bool Update()
{
return(DBBannedIP.Update(
this.rowID,
this.bannedIP,
this.bannedUTC,
this.bannedReason));
}
/// <summary>
/// Updates this instance of BannedIPAddress. Returns true on success.
/// </summary>
/// <returns>bool</returns>
private bool Update()
{
return(DBBannedIP.Update(
this.RowId,
this.BannedIP,
this.BannedUtc,
this.BannedReason));
}
/// <summary>
/// Updates this instance of BannedIPAddress. Returns true on success.
/// </summary>
/// <returns>bool</returns>
private bool Update()
{
return(DBBannedIP.Update(
RowId,
BannedIP,
BannedUtc,
BannedReason
));
}
/// <summary>
/// Persists a new instance of BannedIPAddress. Returns true on success.
/// </summary>
/// <returns></returns>
private bool Create()
{
RowId = DBBannedIP.Add(
BannedIP,
BannedUtc,
BannedReason
);
return(RowId > 0);
}
/// <summary>
/// Persists a new instance of BannedIPAddress. Returns true on success.
/// </summary>
/// <returns></returns>
private bool Create()
{
int newID = 0;
newID = DBBannedIP.Add(
this.bannedIP,
this.bannedUTC,
this.bannedReason);
this.rowID = newID;
return(newID > 0);
}
/// <summary>
/// Gets an instance of BannedIPAddress.
/// </summary>
/// <param name="rowId"> rowId </param>
private void GetBannedIPAddress(int rowId)
{
using (IDataReader reader = DBBannedIP.GetOne(rowId))
{
if (reader.Read())
{
this.rowID = Convert.ToInt32(reader["RowID"]);
this.bannedIP = reader["BannedIP"].ToString();
this.bannedUTC = Convert.ToDateTime(reader["BannedUTC"]);
this.bannedReason = reader["BannedReason"].ToString();
}
}
}
/// <summary>
/// Persists a new instance of BannedIPAddress. Returns true on success.
/// </summary>
/// <returns></returns>
private bool Create()
{
int newID = 0;
newID = DBBannedIP.Add(
this.BannedIP,
this.BannedUtc,
this.BannedReason);
this.RowId = newID;
return(newID > 0);
}
public static List <string> GetAllBannedIPs()
{
var bannedIPAddressList = new List <string>();
using (IDataReader reader = DBBannedIP.GetAll())
{
while (reader.Read())
{
bannedIPAddressList.Add(reader["BannedIP"].ToString());
}
}
return(bannedIPAddressList);
}
/// <summary>
/// Gets an IList with all instances of BannedIPAddress.
/// </summary>
public static List <BannedIPAddress> GetAll()
{
List <BannedIPAddress> bannedIPAddressList
= new List <BannedIPAddress>();
using (IDataReader reader = DBBannedIP.GetAll())
{
while (reader.Read())
{
BannedIPAddress bannedIPAddress = new BannedIPAddress();
bannedIPAddress.rowID = Convert.ToInt32(reader["RowID"]);
bannedIPAddress.bannedIP = reader["BannedIP"].ToString();
bannedIPAddress.bannedUTC = Convert.ToDateTime(reader["BannedUTC"]);
bannedIPAddress.bannedReason = reader["BannedReason"].ToString();
bannedIPAddressList.Add(bannedIPAddress);
}
}
return(bannedIPAddressList);
}
/// <summary>
/// Gets an IDataReader with rows from the mp_BannedIPAddresses table.
/// </summary>
/// <param name="ipAddress"> ipAddress </param>
public static IDataReader GeByIpAddress(string ipAddress)
{
return(DBBannedIP.GeByIpAddress(ipAddress));
}
/// <summary>
/// Deletes an instance of BannedIPAddress. Returns true on success.
/// </summary>
/// <param name="rowId"> rowId </param>
/// <returns>bool</returns>
public static bool Delete(int rowId)
{
return(DBBannedIP.Delete(rowId));
}
