private void RabbitsListBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (RabbitsListBox.SelectedIndex > -1)
{
Rabbit foundRabbit = null;
using (var db = new RabbitDbEntities())
{
int ID = rabbits[RabbitsListBox.SelectedIndex].RabbitId;
//var selectedRabbit = new Rabbit
//{
// RabbitId = ID
//};
foundRabbit = db.Rabbits.Find(ID);
//db.Rabbits.Where(b => b.RabbitId == ID)
// .First();
}
if (foundRabbit != null)
{
showRabbit(foundRabbit);
currentRabbitID = foundRabbit.RabbitId;
}
else
{
ClearDisplay();
AddNewGridTextBlock(0, 1, 1, 2, "Rabbit could not be found");
}
}
}
//static string printRabbits(List<Rabbit> rabbits)
//{
// string rabbitsList = $"{"ID",-5}" + $"{"Name",-12}{"Age"}\n";
// rabbits.ForEach(rabbit => rabbitsList += $"{rabbit.RabbitId,-5}" +
// $"{rabbit.Name,-12}{rabbit.Age}\n");
// return rabbitsList;
//}
static List <Rabbit> updateRabbitList()
{
using (var db = new RabbitDbEntities())
{
return(db.Rabbits.ToList());
}
}
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);
}
}
