public void Update()
{
MeetDisplayModel exists = Meets.Where(x => x.Id == SelectedMeet.Id).FirstOrDefault();
if (exists != null)
{
if (SelectedMeet != null && Meets.Count > 0)
{
isUpdating = true;
MeetModel e = new MeetModel
{
Id = SelectedMeet.Id,
MeetName = _meetName,
StartDate = _startDate,
EndDate = _endDate,
Location = _location
};
SqlDataAccess sql = new SqlDataAccess();
sql.UpdateData <MeetModel>("dbo.spMeet_Update", e, "ADBData");
msg = $"Meet ({SelectedMeet.MeetName}) was successfully updated.";
MessageBox.Show(msg, "Meet Updated");
Meets = new BindingList <MeetDisplayModel>(GetAllMeets());
Clear();
isUpdating = false;
_events.PublishOnUIThread(new MeetChangedEvent());
}
}
}
public void Add()
{
isAdding = true;
MeetDisplayModel e = Meets.Where(x => x.MeetName == MeetName).FirstOrDefault();
if (e == null)
{
SqlDataAccess sql = new SqlDataAccess();
sql.SaveData <dynamic>("dbo.spMeet_Insert",
new
{
MeetName = _meetName,
StartDate = _startDate,
EndDate = _endDate,
Location = _location
}, "ADBData");
Meets = new BindingList <MeetDisplayModel>(GetAllMeets());
NotifyOfPropertyChange(() => Meets);
Clear();
}
else
{
msg = $"Error: An Meet named ({SelectedMeet.MeetName}) already exist!!!";
MessageBox.Show(msg, "Error");
}
isAdding = false;
_events.PublishOnUIThread(new MeetChangedEvent());
}
public void Delete()
{
MeetDisplayModel e = Meets.Where(x => x.Id == SelectedMeet.Id).FirstOrDefault();
if (e != null)
{
SqlDataAccess sql = new SqlDataAccess();
sql.DeleteData <dynamic>("dbo.spMeet_Delete", new { Id = SelectedMeet.Id }, "ADBData");
Meets = new BindingList <MeetDisplayModel>(GetAllMeets());
SelectedMeet = null;
Clear();
_events.PublishOnUIThread(new MeetChangedEvent());
}
}
