public void Update() { CoachDisplayModel exists = Coaches.Where(x => x.Id == SelectedCoach.Id).FirstOrDefault(); if (exists != null) { if (SelectedCoach != null && Coaches.Count > 0) { isUpdating = true; CoachModel e = new CoachModel { Id = SelectedCoach.Id, FirstName = _firstName, LastName = _lastName, Phone = _phone, Email = _email }; SqlDataAccess sql = new SqlDataAccess(); sql.UpdateData <CoachModel>("dbo.spCoach_Update", e, "ADBData"); msg = $"Coach ({SelectedCoach.FullName}) was successfully updated."; MessageBox.Show(msg, "Coach Updated"); Coaches = new BindingList <CoachDisplayModel>(GetAllCoaches()); Clear(); isUpdating = false; _events.PublishOnUIThread(new CoachChangedEvent()); } } }
public void Add() { isAdding = true; CoachDisplayModel e = Coaches.Where(x => x.FirstName == FirstName && x.LastName == LastName).FirstOrDefault(); if (e == null) { SqlDataAccess sql = new SqlDataAccess(); sql.SaveData <dynamic>("dbo.spCoach_Insert", new { FirstName = _firstName, LastName = _lastName, Phone = _phone, Email = _email }, "ADBData"); Coaches = new BindingList <CoachDisplayModel>(GetAllCoaches()); NotifyOfPropertyChange(() => Coaches); Clear(); _events.PublishOnUIThread(new CoachChangedEvent()); } else { msg = $"Error: An Coach named ({SelectedCoach.FullName}) already exist!!!"; MessageBox.Show(msg, "Error"); } isAdding = false; }
public void Delete() { CoachDisplayModel e = Coaches.Where(x => x.Id == SelectedCoach.Id).FirstOrDefault(); if (e != null) { SqlDataAccess sql = new SqlDataAccess(); sql.DeleteData <dynamic>("dbo.spCoach_Delete", new { Id = SelectedCoach.Id }, "ADBData"); Coaches = new BindingList <CoachDisplayModel>(GetAllCoaches()); SelectedCoach = null; Clear(); _events.PublishOnUIThread(new CoachChangedEvent()); } }