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