public void Delete()
{
AthleteDisplayModel e = Athletes.Where(x => x.Id == SelectedAthlete.Id).FirstOrDefault();
if (e != null)
{
SqlDataAccess sql = new SqlDataAccess();
sql.DeleteData <dynamic>("dbo.spAthlete_Delete", new { Id = SelectedAthlete.Id }, "ADBData");
Athletes = new BindingList <AthleteDisplayModel>(GetAllAthletes());
SelectedAthlete = null;
Clear();
_events.PublishOnUIThread(new AthleteChangedEvent());
}
}
public void Update()
{
AthleteDisplayModel exists = Athletes.Where(x => x.Id == SelectedAthlete.Id).FirstOrDefault();
if (exists != null)
{
if (SelectedAthlete != null && Athletes.Count > 0)
{
isUpdating = true;
AthleteModel e = new AthleteModel
{
Id = SelectedAthlete.Id,
FirstName = _firstName,
LastName = _lastName,
BirthDate = _birthDate,
IsMale = _isMale,
Phone = _phone,
Email = _email,
AddressId = SelectedAddress.Id,
ParentId = SelectedParent.Id,
SchoolId = SelectedSchool.Id,
CoachId = SelectedCoach.Id
};
SqlDataAccess sql = new SqlDataAccess();
sql.UpdateData <AthleteModel>("dbo.spAthlete_Update", e, "ADBData");
msg = $"Athlete ({SelectedAthlete.FullName}) was successfully updated.";
MessageBox.Show(msg, "Athlete Updated");
Athletes = new BindingList <AthleteDisplayModel>(GetAllAthletes());
Clear();
isUpdating = false;
_events.PublishOnUIThread(new AthleteChangedEvent());
}
}
}
public void Add()
{
isAdding = true;
AthleteDisplayModel e = Athletes.Where(x => x.FirstName == FirstName && x.LastName == LastName).FirstOrDefault();
if (e == null)
{
SqlDataAccess sql = new SqlDataAccess();
sql.SaveData <dynamic>("dbo.spAthlete_Insert",
new
{
FirstName = _firstName,
LastName = _lastName,
BirthDate = _birthDate,
IsMale = _isMale,
Phone = _phone,
Email = _email,
AddressId = _selectedAddress.Id,
ParentId = SelectedParent.Id,
SchoolId = SelectedSchool.Id,
CoachId = _selectedCoach.Id
}, "ADBData");
Athletes = new BindingList <AthleteDisplayModel>(GetAllAthletes());
NotifyOfPropertyChange(() => Athletes);
Clear();
_events.PublishOnUIThread(new AthleteChangedEvent());
}
else
{
msg = $"Error: An Event named ({SelectedAthlete.FullName}) already exist!!!";
MessageBox.Show(msg, "Error");
}
isAdding = false;
}
