//Add
private void OnAdd(object sender, RoutedEventArgs e)
{
if (ValidateForm())
{
using (DbCarContext _context = new DbCarContext())
{
var car = _context.TblCar.Find((CarDG.SelectedItem as TblCar).Id);
bool carExists = (car != null) ? true : false;
if (!carExists)
{
TblCar tblCar = new TblCar()
{
Brand = Brand.Text,
Model = Model.Text,
Price = int.Parse(Price.Text)
};
_context.TblCar.Add(tblCar);
}
else
{
TblCar EditCar = _context.TblCar.Find((CarDG.SelectedItem as TblCar).Id);
EditCar.Brand = Brand.Text;
EditCar.Model = Model.Text;
EditCar.Price = int.Parse(Price.Text);
_context.TblCar.Update(EditCar);
}
_context.SaveChanges();
}
ResetForm();
LoadData();
}
}
private void LoadData()
{
using (DbCarContext _context = new DbCarContext())
{
var cars = _context.TblCar.ToList();
CarDG.ItemsSource = cars;
}
}
//Edit button clicked
private void OnEdit(object sender, RoutedEventArgs e)
{
int id = (CarDG.SelectedItem as TblCar).Id;
using (DbCarContext _context = new DbCarContext())
{
TblCar car = _context.TblCar.Find(id);
Brand.Text = car.Brand;
Model.Text = car.Model;
Price.Text = car.Price.ToString();
}
}
//Delete button clicked
private void OnDelete(object sender, RoutedEventArgs e)
{
if (MessageBox.Show("Are you sure you want to delete this record?", "Confirm Delete", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
int id = (CarDG.SelectedItem as TblCar).Id;
using (DbCarContext _context = new DbCarContext())
{
TblCar car = new TblCar()
{
Id = id
};
_context.TblCar.Attach(car);
_context.TblCar.Remove(car);
_context.SaveChanges();
}
LoadData();
}
}
