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