public void Update() { ParentDisplayModel exists = Parents.Where(x => x.Id == SelectedParent.Id).FirstOrDefault(); if (exists != null) { if (SelectedParent != null && Parents.Count > 0) { isUpdating = true; ParentModel e = new ParentModel { Id = SelectedParent.Id, FirstName = _firstName, LastName = _lastName, Phone = _phone, Email = _email }; SqlDataAccess sql = new SqlDataAccess(); sql.UpdateData <ParentModel>("dbo.spParent_Update", e, "ADBData"); msg = $"Parent ({SelectedParent.FullName}) was successfully updated."; MessageBox.Show(msg, "Parent Updated"); Parents = new BindingList <ParentDisplayModel>(GetAllParents()); Clear(); isUpdating = false; } } _events.PublishOnUIThread(new ParentChangedEvent()); }
public void Add() { isAdding = true; ParentDisplayModel e = Parents.Where(x => x.FirstName == FirstName && x.LastName == LastName).FirstOrDefault(); if (e == null) { SqlDataAccess sql = new SqlDataAccess(); sql.SaveData <dynamic>("dbo.spParent_Insert", new { FirstName = _firstName, LastName = _lastName, Phone = _phone, Email = _email }, "ADBData"); _parents = new BindingList <ParentDisplayModel>(GetAllParents()); NotifyOfPropertyChange(() => Parents); Clear(); _events.PublishOnUIThread(new ParentChangedEvent()); } else { msg = $"Error: An Event named ({SelectedParent.FullName}) already exist!!!"; MessageBox.Show(msg, "Error"); } isAdding = false; }
public void Delete() { ParentDisplayModel e = Parents.Where(x => x.Id == SelectedParent.Id).FirstOrDefault(); if (e != null) { SqlDataAccess sql = new SqlDataAccess(); sql.DeleteData <dynamic>("dbo.spParent_Delete", new { Id = SelectedParent.Id }, "ADBData"); Parents = new BindingList <ParentDisplayModel>(GetAllParents()); SelectedParent = null; Clear(); _events.PublishOnUIThread(new ParentChangedEvent()); } }