public void saveDataBase() { using (var db = new SQLiteDBContext()) { foreach (Equipment eq in this.EquipmentDic.Values) { if (eq.StateDB == Equipment.StateBBDD.DELETE) { db.Remove(eq); } if (eq.StateDB == Equipment.StateBBDD.NEW) { db.Add(eq); } } db.SaveChanges(); } }
public bool load() { bool ok = true; this.clear(); try { using (var db = new SQLiteDBContext()) { foreach (Equipment eq in db.Equipment) { this.EquipmentDic.Add(eq.IP, eq); } } if (this.EquipmentDic.Count == 0) { Random rand = new Random(); for (int i = 1; i <= 9; i++) { this.EquipmentDic.Add("10.1.1." + i, new Equipment() { IP = "10.1.1." + i, Name = "EQ" + i, Type = (Equipment.TypeEquipment)rand.Next(1, 3), StateDB = Equipment.StateBBDD.NEW }); } this.saveDataBase(); } } catch (Exception ex) { ok = false; Console.WriteLine("Error: " + ex.Message); } return(ok); }