/// <summary>
/// Delete the ownership record
/// </summary>
private void DeleteOwnership()
{
ownerID = Convert.ToInt32(cmbOwners.SelectedValue);
dogID = Convert.ToInt32(lstOwnership.SelectedValue.ToString().Split(':')[1]);
startDate = lstOwnership.SelectedValue.ToString().Split(':')[0];
string dogName = DatabaseHelper.ExecuteScaler($"SELECT Name FROM Dogs WHERE DogID = {dogID}").ToString();
string ownerName = DatabaseHelper.ExecuteScaler
(
$@"
SELECT FirstName + ' ' + COALESCE(MiddleName + ' ', '') + LastName
FROM Owners
WHERE OwnerID = {ownerID}"
).ToString();
if (UIMethods.ConfirmationPrompt($"Are you sure you wish to delete the ownership record for {ownerName} starting owning {dogName} on {startDate}"))
{
string sql = $@"
DELETE DogOwnership
WHERE OwnerID = {ownerID}
AND DogID = {dogID}
AND StartOfOwnership = '{startDate}';
";
int rowsAffected = DatabaseHelper.SendData(sql);
UIMethods.DisplayStatusMessage(((frmMDIParent)MdiParent).GetStatusLabel(), $"{rowsAffected} row(s) deleted");
((frmMDIParent)MdiParent).ReloadAllChildForms();
}
}
/// <summary>
/// Validate the deletion data
/// </summary>
/// <returns></returns>
private bool ValidateDeletion()
{
GetUserData();
errorProvider.Clear();
string sqlDogName = $"SELECT [Name] FROM Dogs WHERE DogID = {currentDogID}";
string dogName = DatabaseHelper.ExecuteScaler(sqlDogName).ToString();
string dogShowName = cmbDogShow.Text.Split('\u2014')[1];
DateTime dogShowDate = DateTime.Parse(cmbDogShow.Text.Split('\u2014')[0]);
return(lstDogs.SelectedIndex != -1 &&
UIMethods.ConfirmationPrompt($"Are you sure you want to remove {dogName} from the " +
$"{dogShowDate.ToString("yyyy MMMM d")}{dogShowName} dog show?"));
}
/// <summary>
/// Delete the breed from the database
/// </summary>
private void DeleteBreed()
{
int id = Convert.ToInt32(lstBreeds.SelectedValue);
if (DatabaseHelper.ValueExists("Breed", id.ToString(), "Dogs"))
{
MessageBox.Show("Cannot delete breed that is referenced by a dog", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
string sqlBreedName = $"SELECT [Breed] FROM Breeds WHERE BreedID = {id}";
string breedName = DatabaseHelper.ExecuteScaler(sqlBreedName).ToString();
string sql = $"DELETE Breeds WHERE BreedID = {id};";
if (UIMethods.ConfirmationPrompt($"Are you sure you want to delete {breedName} breed?"))
{
int rowsAffected = DatabaseHelper.SendData(sql);
UIMethods.DisplayStatusMessage(((frmMDIParent)MdiParent).GetStatusLabel(), $"{rowsAffected} row(s) deleted");
((frmMDIParent)MdiParent).ReloadAllChildForms();
}
}
/// <summary>
/// Delete the class
/// </summary>
private void DeleteClass()
{
int id = Convert.ToInt32(lstClasses.SelectedValue);
if (DatabaseHelper.ValueExists("Classification", id.ToString(), "Breeds"))
{
MessageBox.Show("Cannot delete class that is referenced by a breed", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
string sql = $"DELETE Classes WHERE ClassID = {id}";
string sqlClassName = $"SELECT [Class] FROM Classes WHERE ClassID = {id}";
string className = DatabaseHelper.ExecuteScaler(sqlClassName).ToString();
if (UIMethods.ConfirmationPrompt($"Are you sure you want to delete {className} class?"))
{
int rowsAffected = DatabaseHelper.SendData(sql);
UIMethods.DisplayStatusMessage(((frmMDIParent)MdiParent).GetStatusLabel(), $"{rowsAffected} row(s) deleted");
((frmMDIParent)MdiParent).ReloadAllChildForms();
}
}
