public int Create(ArchiveTokenResourcePermission permission)
{
var dbCommand = _dbHelper.GetStoredProcCommand(SP_Create);
_dbHelper.AddInParameter(dbCommand, "@ArchiveDate", System.Data.DbType.DateTime, permission.ArchiveDate);
_dbHelper.AddInParameter(dbCommand, "@Id", System.Data.DbType.Int32, permission.Id);
_dbHelper.AddInParameter(dbCommand, "@Token", System.Data.DbType.Int32, permission.Token);
_dbHelper.AddInParameter(dbCommand, "@TokenType", System.Data.DbType.Int32, (int)permission.TokenType);
_dbHelper.AddInParameter(dbCommand, "@ResourceId", System.Data.DbType.Int32, permission.ResourceId);
_dbHelper.AddInParameter(dbCommand, "@ResourceType", System.Data.DbType.Int32, (int)permission.ResourceType);
_dbHelper.AddInParameter(dbCommand, "@Permission", System.Data.DbType.Int32, permission.Permission);
_dbHelper.AddReturnParameter(dbCommand, "@return", System.Data.DbType.Int32);
int ret = _dbHelper.ExecuteNonQuery(dbCommand);
int id = -1;
if (ret > 0)
{
id = (int)dbCommand.Parameters["@return"].Value;
}
return(id);
}
public ArchiveTokenResourcePermission GetSingle(int archiveId)
{
var dbCommand = _dbHelper.GetStoredProcCommand(SP_Select);
_dbHelper.AddInParameter(dbCommand, "@ArchiveId", System.Data.DbType.Int32, archiveId);
var reader = _dbHelper.ExecuteReader(dbCommand);
ArchiveTokenResourcePermission item = new ArchiveTokenResourcePermission();
if (reader.HasRows)
{
if (reader.Read())
{
item.ArchiveId = (int)reader["ArchiveId"];
item.ArchiveDate = (DateTime)reader["ArchiveDate"];
item.Id = (int)reader["Id"];
item.Token = (int)reader["Token"];
item.TokenType = (TokenType)reader["TokenType"];
item.ResourceId = (int)reader["ResourceId"];
item.ResourceType = (ResourceType)reader["ResourceType"];
item.Permission = (int)reader["Permission"];
}
}
reader.Close();
_dbHelper.Close(dbCommand);
return(item);
}
public int Create(List <TokenResourcePermission> items)
{
List <ArchiveTokenResourcePermission> archiveItems = new List <ArchiveTokenResourcePermission>();
items.ForEach(p =>
{
var archiveItem = new ArchiveTokenResourcePermission(p);
archiveItems.Add(archiveItem);
});
return(_archivetokenresourcepermissiondao.Create(archiveItems));
}
public int Create(TokenResourcePermission item)
{
ArchiveTokenResourcePermission archiveItem = new ArchiveTokenResourcePermission(item);
return(_archivetokenresourcepermissiondao.Create(archiveItem));
}
