public IEnumerable<Game> RetrieveAllGames()
{
IEnumerable<Game> games;
using (var db = new CompJSdbEntities())
{
var results = db.RetrieveAllGames();
games = results.Select(x => TypeAdapter.Adapt<Game>(x)).ToList();
}
return games;
}
public IEnumerable<BhvCompDefinition> RetrieveAllBhvCompDefinitionsForGame(int gameId)
{
IEnumerable<BhvCompDefinition> bhvComponents;
using (var db = new CompJSdbEntities())
{
var result = db.RetrieveAllBhvCompDefinitionsForGame(gameId);
bhvComponents = result.Select(x => TypeAdapter.Adapt<BhvCompDefinition>(x)).ToList();
}
return bhvComponents;
}
public IEnumerable<EntityTypeDefinition> RetrieveAllEntityTypeDefinitionsForGame(int gameId)
{
IEnumerable<EntityTypeDefinition> entityDefinitions;
using (var db = new CompJSdbEntities())
{
var eResults = db.RetrieveAllEntityTypeDefinitionsForGame(gameId);
entityDefinitions = eResults.Select(x => TypeAdapter.Adapt<EntityTypeDefinition>(x)).ToList();
}
return entityDefinitions;
}
public IEnumerable<Audio> RetrieveAllAudioForGame(int gameId)
{
IEnumerable<Audio> audio;
using (var db = new CompJSdbEntities())
{
var results = db.RetrieveAllAudioForGame(gameId);
audio = results.Select(x => TypeAdapter.Adapt<Audio>(x)).ToList();
}
return audio;
}
public IEnumerable<HighScore> CreateHighScoreForGame(string playerName, long score, int count, int gameId)
{
IEnumerable<HighScore> highScores;
using (var db = new CompJSdbEntities())
{
db.CreateHighScoreForGame(playerName, score, gameId);
var hResults = db.RetrieveTopHighScoresForGame(count, gameId);
highScores = hResults.Select(x => TypeAdapter.Adapt<HighScore>(x)).ToList();
}
return highScores;
}
public GfxCompDefinitionCollection RetrieveAllGfxCompDefinitionsForGame(int gameId)
{
IEnumerable<GfxCompDefinition> gfxComponents;
IEnumerable<AnimationStateDefinition> animationStates;
IEnumerable<AnimationFrameDefinition> animationFrames;
IEnumerable<FontTextureDefinition> fonts;
var gfxCompDefinitionCollection = new GfxCompDefinitionCollection();
using (var db = new CompJSdbEntities())
{
var gResults = db.RetrieveAllGfxCompDefinitionsForGame(gameId);
gfxComponents = gResults.Select(x => TypeAdapter.Adapt<GfxCompDefinition>(x)).ToList();
var asResults = gResults.GetNextResult<RetrieveAnimationStateDefinitionsForGfxCompDefinition_Result>();
animationStates = asResults.Select(x => TypeAdapter.Adapt<AnimationStateDefinition>(x)).ToList();
var afResults = asResults.GetNextResult<RetrieveAnimationFrameDefinitionsForAnimationStateDefinition_Result>();
animationFrames = afResults.Select(x => TypeAdapter.Adapt<AnimationFrameDefinition>(x)).ToList();
var fResults = afResults.GetNextResult<RetrieveFontTextureDefinitionsForGfxComp_Result>();
fonts = fResults.Select(x => TypeAdapter.Adapt<FontTextureDefinition>(x)).ToList();
}
foreach (var a in animationStates)
{
a.AnimationFrameDefinitions = animationFrames.Where(x => x.AnimationStateDefinitionId == a.Id).ToList();
}
gfxCompDefinitionCollection.Gfx2DAnimations = (from a in animationStates.Select(x => x.GfxCompDefinitionId).Distinct()
join g in gfxComponents
on a equals g.Id
select new GfxCompDefinition_2DAnimation()
{
Id = g.Id,
EntityTypeId = g.EntityTypeId,
RenderPass = g.RenderPass,
AnimationStateDefinitions = (from aa in animationStates
where aa.GfxCompDefinitionId == g.Id
select aa).ToList()
}).ToList();
gfxCompDefinitionCollection.GfxFonts = (from f in fonts.Select(x => x.GfxCompDefinitionId).Distinct()
join g in gfxComponents
on f equals g.Id
select new GfxCompDefinition_Font()
{
Id = g.Id,
EntityTypeId = g.EntityTypeId,
RenderPass = g.RenderPass,
FontTextureDefinition = (from ff in fonts
where ff.GfxCompDefinitionId == g.Id
select ff).FirstOrDefault()
}).ToList();
return gfxCompDefinitionCollection;
}
public IEnumerable<HighScore> RetrieveTopHighScoresForGame(int count, int gameId)
{
IEnumerable<HighScore> highScores;
using (var db = new CompJSdbEntities())
{
var hResults = db.RetrieveTopHighScoresForGame(count, gameId);
highScores = hResults.Select(x => TypeAdapter.Adapt<HighScore>(x)).ToList();
}
return highScores;
}
public IEnumerable<PhysType> RetrievePhysTypes()
{
IEnumerable<PhysType> physTypes;
using (var db = new CompJSdbEntities())
{
var results = db.RetrievePhysTypes();
physTypes = results.Select(x => TypeAdapter.Adapt<PhysType>(x)).ToList();
}
return physTypes;
}
public LevelStartData RetrieveLevel(int levelId)
{
IEnumerable<LevelPosition> levelPositions;
IEnumerable<EntityType> entities;
using (var db = new CompJSdbEntities())
{
var lResults = db.RetrieveLevelLayoutsForLevel(levelId);
levelPositions = lResults.Select(x => TypeAdapter.Adapt<LevelPosition>(x)).ToList();
var eResults = lResults.GetNextResult<RetrieveEntity_Result>();
entities = eResults.Select(x => TypeAdapter.Adapt<EntityType>(x)).ToList();
}
return
new LevelStartData()
{
LevelPositions = levelPositions,
EntityTypesOnAllLevels = entities
};
}
public PhysCompDefinition RetrievePhysCompForEntity(int entityId)
{
using (var db = new CompJSdbEntities())
{
var result = db.RetrievePhysCompDefinitionForEntity(entityId);
return (result != null) ? TypeAdapter.Adapt<PhysCompDefinition>(result) : null;
}
}
public GfxCompDefinition_2DAnimation RetrieveGfxComp(int id)
{
using (var db = new CompJSdbEntities())
{
var result = db.RetrieveGfxCompDefinition(id);
return (result != null) ? TypeAdapter.Adapt<GfxCompDefinition_2DAnimation>(result) : null;
}
}
public IEnumerable<CollisionType> RetrieveCollisionTypes()
{
IEnumerable<CollisionType> collisionTypes;
using (var db = new CompJSdbEntities())
{
var results = db.RetrieveCollisionTypes();
collisionTypes = results.Select(x => TypeAdapter.Adapt<CollisionType>(x)).ToList();
}
return collisionTypes;
}
public IEnumerable<AudioType> RetrieveAudioTypes()
{
IEnumerable<AudioType> audioTypes;
using (var db = new CompJSdbEntities())
{
var results = db.RetrieveAudioTypes();
audioTypes = results.Select(x => TypeAdapter.Adapt<AudioType>(x)).ToList();
}
return audioTypes;
}
public IEnumerable<Shader> RetrieveAllShadersForGame(int gameId)
{
IEnumerable<Shader> shaders;
using (var db = new CompJSdbEntities())
{
var results = db.RetrieveAllShadersForGame(gameId);
shaders = results.Select(x => TypeAdapter.Adapt<Shader>(x)).ToList();
}
return shaders;
}
public IEnumerable<Level> RetrieveAllLevelsForGame(int gameId)
{
IEnumerable<Level> levels;
using (var db = new CompJSdbEntities())
{
var results = db.RetrieveAllLevelsForGame(gameId);
levels = results.Select(x => TypeAdapter.Adapt<Level>(x)).ToList();
}
return levels;
}
