/// <summary>
/// Gets an IP network from a data reader
/// </summary>
/// <param name="dataReader">IDataReader</param>
/// <returns>DBBannedIpNetwork</returns>
private DBBannedIpNetwork GetIpNetworkFromReader(IDataReader dataReader)
{
DBBannedIpNetwork ipNetwork = new DBBannedIpNetwork();
ipNetwork.BannedIpNetworkID = NopSqlDataHelper.GetInt(dataReader, "BannedIpNetworkID");
ipNetwork.StartAddress = NopSqlDataHelper.GetString(dataReader, "StartAddress");
ipNetwork.EndAddress = NopSqlDataHelper.GetString(dataReader, "EndAddress");
ipNetwork.Comment = NopSqlDataHelper.GetString(dataReader, "Comment");
ipNetwork.IpException = NopSqlDataHelper.GetString(dataReader, "IpException");
ipNetwork.CreatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "CreatedOn");
ipNetwork.UpdatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "UpdatedOn");
return(ipNetwork);
}
/// <summary>
/// Gets an IP Network by its ID
/// </summary>
/// <param name="bannedIpNetworkID">IP network unique identifier</param>
/// <returns>IP network</returns>
public override DBBannedIpNetwork GetIpNetworkByID(int bannedIpNetworkID)
{
DBBannedIpNetwork ipNetwork = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_BannedIpNetworkLoadByPrimaryKey");
db.AddInParameter(dbCommand, "BannedIpNetworkID", DbType.Int32, bannedIpNetworkID);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
ipNetwork = GetIpNetworkFromReader(dataReader);
}
}
return(ipNetwork);
}
/// <summary>
/// Gets all IP networks
/// </summary>
/// <returns>IP network collection</returns>
public override DBBannedIpNetworkCollection GetIpNetworkAll()
{
DBBannedIpNetworkCollection ipCollection = new DBBannedIpNetworkCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_BannedIpNetworkLoadAll");
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBBannedIpNetwork ipNetwork = GetIpNetworkFromReader(dataReader);
ipCollection.Add(ipNetwork);
}
}
return(ipCollection);
}
/// <summary>
/// Updates an IP network
/// </summary>
/// <param name="bannedIpNetworkID">IP network unique identifier</param>
/// <param name="startAddress">First IP address in the range</param>
/// <param name="endAddress">Last IP address in the range</param>
/// <param name="comment">Reason why the IP network was banned</param>
/// <param name="ipException">Exceptions within the range</param>
/// <param name="createdOn">When the record was inserted</param>
/// <param name="updatedOn">When the record was last updated</param>
/// <returns>IP network</returns>
public override DBBannedIpNetwork UpdateBannedIpNetwork(int bannedIpNetworkID, string startAddress, string endAddress, string comment, string ipException, DateTime createdOn, DateTime updatedOn)
{
DBBannedIpNetwork ipNetwork = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_BannedIpNetworkUpdate");
db.AddInParameter(dbCommand, "BannedIpNetworkID", DbType.Int32, bannedIpNetworkID);
db.AddInParameter(dbCommand, "StartAddress", DbType.String, startAddress);
db.AddInParameter(dbCommand, "EndAddress", DbType.String, endAddress);
db.AddInParameter(dbCommand, "Comment", DbType.String, comment);
db.AddInParameter(dbCommand, "IpException", DbType.String, ipException);
db.AddInParameter(dbCommand, "CreatedOn", DbType.DateTime, createdOn);
db.AddInParameter(dbCommand, "UpdatedOn", DbType.DateTime, updatedOn);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
ipNetwork = GetIpNetworkByID(bannedIpNetworkID);
}
return(ipNetwork);
}
/// <summary>
/// Inserts an IP network
/// </summary>
/// <param name="startAddress">First IP address in the range</param>
/// <param name="endAddress">Last IP address in the range</param>
/// <param name="comment">Reason why the IP network was banned</param>
/// <param name="ipException">Exceptions in the range</param>
/// <param name="createdOn">When the record was inserted</param>
/// <param name="updatedOn">When the record was last updated</param>
/// <returns>IP network</returns>
public override DBBannedIpNetwork InsertBannedIpNetwork(string startAddress,
string endAddress, string comment, string ipException,
DateTime createdOn, DateTime updatedOn)
{
DBBannedIpNetwork item = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_BannedIpNetworkInsert");
db.AddOutParameter(dbCommand, "BannedIpNetworkID", DbType.Int32, 0);
db.AddInParameter(dbCommand, "StartAddress", DbType.String, startAddress);
db.AddInParameter(dbCommand, "EndAddress", DbType.String, endAddress);
db.AddInParameter(dbCommand, "Comment", DbType.String, comment);
db.AddInParameter(dbCommand, "IpException", DbType.String, ipException);
db.AddInParameter(dbCommand, "CreatedOn", DbType.DateTime, createdOn);
db.AddInParameter(dbCommand, "UpdatedOn", DbType.DateTime, updatedOn);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
int ipNetworkId = Convert.ToInt32(db.GetParameterValue(dbCommand, "@BannedIpNetworkID"));
item = GetIpNetworkById(ipNetworkId);
}
return(item);
}