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());
}
}
