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)); }