private void Delete_Button(object sender, RoutedEventArgs e)
{
string deleteQry = $"DELETE FROM bds.residentinfo WHERE id = '{ResidentId}'";
var count = DBOperation.ExecuteNonQuery(deleteQry);
if (count > 0)
{
Resident.DeleteRecord(ResidentId);
MessageBox.Show("Deleted", "Info", MessageBoxButton.OK, MessageBoxImage.Information);
Close();
}
}
