private DBACL GetAclFromReader(IDataReader dataReader)
{
var item = new DBACL();
item.AclId = NopSqlDataHelper.GetInt(dataReader, "ACLID");
item.CustomerActionId = NopSqlDataHelper.GetInt(dataReader, "CustomerActionID");
item.CustomerRoleId = NopSqlDataHelper.GetInt(dataReader, "CustomerRoleID");
item.Allow = NopSqlDataHelper.GetBoolean(dataReader, "Allow");
return(item);
}
/// <summary>
/// Gets an ACL by identifier
/// </summary>
/// <param name="aclId">ACL identifier</param>
/// <returns>ACL</returns>
public override DBACL GetAclById(int aclId)
{
DBACL item = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ACLLoadByPrimaryKey");
db.AddInParameter(dbCommand, "ACLID", DbType.Int32, aclId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
item = GetAclFromReader(dataReader);
}
}
return(item);
}
/// <summary>
/// Updates the ACL
/// </summary>
/// <param name="aclId">The ACL identifier</param>
/// <param name="customerActionId">The customer action identifier</param>
/// <param name="customerRoleId">The customer role identifier</param>
/// <param name="allow">The value indicating whether action is allowed</param>
/// <returns>An ACL</returns>
public override DBACL UpdateAcl(int aclId, int customerActionId,
int customerRoleId, bool allow)
{
DBACL item = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ACLUpdate");
db.AddInParameter(dbCommand, "ACLID", DbType.Int32, aclId);
db.AddInParameter(dbCommand, "CustomerActionID", DbType.Int32, customerActionId);
db.AddInParameter(dbCommand, "CustomerRoleID", DbType.Int32, customerRoleId);
db.AddInParameter(dbCommand, "Allow", DbType.Boolean, allow);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
item = GetAclById(aclId);
}
return(item);
}
