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