public ICollection <SamuraiData> GetSamuraisInBattle(int battleId)
{
using (var ctx = new SamuraiAppEntities())
{
var battleSamurais = ctx.BattleSamuraiEntities.Where(bs => bs.BattleId == battleId);
ICollection <SamuraiData> samurais = new List <SamuraiData>();
foreach (BattleSamuraiEntity battleSamurai in battleSamurais)
{
SamuraiEntity samurai = (from s in ctx.SamuraiEntities
where s.SamuraiId == battleSamurai.SamuraiId
select s).FirstOrDefault();
SamuraiData samuraiData = new SamuraiData()
{
SamuraiId = samurai.SamuraiId,
Name = samurai.Name,
Age = samurai.Age,
Picture = samurai.Picture,
Town = samurai.Town,
};
samurais.Add(samuraiData);
}
return(samurais);
}
}
private BattleEntity GetBattleEntity(SamuraiAppEntities context, int id)
{
BattleEntity foundBattle = null;
foundBattle = (from s in context.BattleEntities
where s.BattleId == id
select s).FirstOrDefault();
return(foundBattle);
}
public void AddSamuraiToBattle(int samuraiId, int battleId)
{
using (var context = new SamuraiAppEntities())
{
var samuraiInBattle = new BattleSamuraiEntity
{
SamuraiId = samuraiId,
BattleId = battleId,
}
}
}
public BattleData GetBattleById(int id)
{
BattleData battle = null;
using (var context = new SamuraiAppEntities())
{
var foundBattle = GetBattleEntity(context, id);
if (foundBattle != null)
{
battle = GetBattleFromBattleEntity(foundBattle);
}
}
return(battle);
}
public void UpdateBattle(int id, string name, DateTime dateStarted, string city, string country)
{
using (var context = new SamuraiAppEntities())
{
var battle = context.BattleEntities.First(b => b.BattleId == id);
if (battle == null)
{
return;
}
battle.Name = name;
battle.Date = dateStarted;
battle.City = city;
battle.Country = country;
context.SaveChanges();
}
}
public IEnumerable <BattleData> GetAllBattles()
{
using (var ctx = new SamuraiAppEntities())
{
var battles = from b in ctx.BattleEntities
select new BattleData
{
BattleId = b.BattleId,
Name = b.Name,
City = b.City,
Date = b.Date,
Country = b.Country
};
return(battles.ToList());
}
}
