public void Create(Equipment equipment) { using (var context = new NinjaStoreDbContext()) { context.Equipment.Add(equipment); context.SaveChanges(); } }
public void Create(Ninja ninja) { using (var context = new NinjaStoreDbContext()) { context.Ninjas.Add(ninja); context.SaveChanges(); } }
public void Update(Equipment equipment) { using (var context = new NinjaStoreDbContext()) { context.Attach(equipment); context.Equipment.Update(equipment); context.SaveChanges(); } }
public void Update(Ninja ninja) { using (var context = new NinjaStoreDbContext()) { context.Attach(ninja); context.Ninjas.Update(ninja); context.SaveChanges(); } }
public bool Delete(int id) { using (var context = new NinjaStoreDbContext()) { var toRemove = context.Equipment.Find(id); if (toRemove != null) { context.Equipment.Remove(toRemove); context.SaveChanges(); return(true); } return(false); } }
public bool SellEquipment(int ninjaId, int equipmentId) { using (var context = new NinjaStoreDbContext()) { var ninja = context.Ninjas.FirstOrDefault(n => n.NinjaId == ninjaId); var equipment = context.Equipment.FirstOrDefault(e => e.EquipmentId == equipmentId); ninja.Gold = ninja.Gold + equipment.Value; NinjaEquipment ninjaEquipment = new NinjaEquipment { Ninja = ninja, Equipment = equipment, NinjaId = ninjaId, EquipmentId = equipmentId }; context.Attach(ninja); context.Ninjas.Update(ninja); context.NinjaEquipment.Remove(ninjaEquipment); context.SaveChanges(); return(true); } }