public ObservableCollection <EquipmentViewModel> GetAllFromType(EquipmentTypeViewModel type) { var equipment = new ObservableCollection <EquipmentViewModel>(); using (var ctx = new DatabaseModelContainer()) { var results = ctx.EquipmentSet.ToList(); foreach (var item in results) { if (item.EquipmentType.Id != type.Id) { continue; } equipment.Add(new EquipmentViewModel() { Id = item.Id, Agi = item.Agi, Str = item.Str, Int = item.Int, Gold = item.Gold, Name = item.Name, EquipmentTypeViewModel = new EquipmentTypeViewModel { Id = item.EquipmentType.Id, Name = item.EquipmentType.Name, }, }); } } return(equipment); }
public bool Delete(EquipmentTypeViewModel item) { using (var ctx = new DatabaseModelContainer()) { ctx.EquipmentTypeSet.Remove(ctx.EquipmentTypeSet.First(o => o.Id == item.Id)); ctx.SaveChanges(); return(true); } }
public bool Add(EquipmentTypeViewModel item) { using (var ctx = new DatabaseModelContainer()) { var type = ctx.EquipmentTypeSet.Add(new EquipmentType() { Name = item.Name }); ctx.SaveChanges(); return(type != null); } }
public bool Update(EquipmentTypeViewModel item) { throw new System.NotImplementedException(); }