public void addRabbitToDataBase(string Name, string Age) { var newRabbit = new Rabbit() { Age = int.Parse(Age), Name = Name }; using (var db = new RabbitDbEntities()) { db.Rabbits.Add(newRabbit); db.SaveChanges(); } }
private void updateRabbitDataBase(int ID, string name, string age) { //update rabbit using (var db = new RabbitDbEntities()) { Rabbit rabbitUpdate = db.Rabbits.Single(a => a.RabbitId == ID); if (rabbitUpdate != null) { rabbitUpdate.Name = name; rabbitUpdate.Age = int.Parse(age); db.SaveChanges(); } } }
private void BtnDeleteSelection_Click(object sender, RoutedEventArgs e) { if (RabbitsListBox.SelectedIndex > -1) { int ID = rabbits[RabbitsListBox.SelectedIndex].RabbitId; using (var db = new RabbitDbEntities()) { db.Rabbits.Remove(db.Rabbits.Single(a => a.RabbitId == ID)); db.SaveChanges(); } if (currentRabbitID == ID) { ClearDisplay(); } rabbits = updateRabbitList(); RefreshData(RabbitsListBox); RefreshData(DisplayRabbit); } }