// Remove all equipment items and add new ones public void Init() { var db = new EquipDBContext(); // Delete all rows from the Equipments table foreach (Equipment item in db.Equipments) { db.Equipments.Remove(item); } // Add some new ones Equipment equipItem1 = new Equipment() { Name = "iPad", CheckedOut = false }; db.Equipments.Add(equipItem1); Equipment equipItem2 = new Equipment() { Name = "Microphone", CheckedOut = false }; db.Equipments.Add(equipItem2); Equipment equipItem3 = new Equipment() { Name = "Tripod", CheckedOut = false }; db.Equipments.Add(equipItem3); db.SaveChanges(); }
public bool SaveItem(Equipment item) { var db = new EquipDBContext(); // Check to see if an item with this name is in the database if (null == db.Equipments.FirstOrDefault(e => e.Name == item.Name)) { db.Equipments.Add(item); db.SaveChanges(); return(true); } else { return(false); } }
public bool UpdateItem(Equipment item) { var db = new EquipDBContext(); // Find the item we are changing var dbItem = db.Equipments.FirstOrDefault(e => e.EquipmentId == item.EquipmentId); if (null != dbItem) { // Copy properties- this is how we incorporate the changes dbItem.Name = item.Name; dbItem.CheckedOut = item.CheckedOut; // save the changes to the database db.SaveChanges(); return(true); } else { return(false); } }