// Reload all the jokes from the database
private async void Button_All_Jokes_Async(object sender, RoutedEventArgs e)
{
// Mouse cursor changes to wait when loading data
var defaultCursor = Window.Current.CoreWindow.PointerCursor;
Window.Current.CoreWindow.PointerCursor = new CoreCursor(CoreCursorType.Wait, 1);
try
{
CelebrityJokes.Clear();
var result = await httpCelebrityJokesUri.GetAsync(celebrityJokeUri);
var celebrityJokeJson = await result.Content.ReadAsStringAsync();
var celebrityJokes = JsonConvert.DeserializeObject <CelebrityJoke[]>(celebrityJokeJson);
Window.Current.CoreWindow.PointerCursor = defaultCursor;
foreach (CelebrityJoke CJ in celebrityJokes)
{
CelebrityJokes.Add(CJ);
}
}
catch (HttpRequestException ex)
{
Window.Current.CoreWindow.PointerCursor = defaultCursor;
var dialog = new MessageDialog(ex.GetType().Name + ": Database connection error. Please check VPN and network connection.");
await dialog.ShowAsync();
FileLogger.LogExceptions(DateTime.Now + " " + ex.GetType().Name + ex.Message + ex.StackTrace + "\n" + "\n");
}
}
// Creates a new joke
private void Button_NewJoke(object sender, RoutedEventArgs e)
{
CelebrityJokes.Clear();
var newJoke = new CelebrityJoke()
{
Text = "",
CelebrityMentioned = "",
Author = "",
Rate = 0
};
CelebrityJokes.Add(newJoke);
}
// Searching for a celebrity mentioned in the joke and showing the relevant jokes
private async void Button_Search_Async(object sender, RoutedEventArgs e)
{
var input = SearchField.Text;
SqlConnectionStringBuilder connStringBuilder = new SqlConnectionStringBuilder
{
DataSource = "donau.hiof.no",
UserID = "andreot",
InitialCatalog = "andreot",
Password = "******"
};
var inputSearch = SearchField.Text;
try
{
//Initialize the Sql-connection
using (SqlConnection conn = new SqlConnection(connStringBuilder.ToString()))
{
if (inputSearch != "")
{
//Initialize the Sql-command.
//Sql-command : Selects the JokeID from the rows who are matching the search
SqlCommand cmd = new SqlCommand("SELECT JokeID FROM dbo.Jokes WHERE CelebrityMentioned LIKE'%" + inputSearch + "%'", conn);
if (conn.State == ConnectionState.Closed)
{
//Opens the database connection
conn.Open();
// Sends the CommandText to the Connection and builds a SqlDataReader.
var reader = cmd.ExecuteReader();
CelebrityJokes.Clear();
if (reader.HasRows)
{
while (reader.Read())
{
var jokeID = reader.GetInt32(0);
//Gets relevant jokes from database
var result = await httpCelebrityJokesUri.GetAsync(celebrityJokeUri + "//" + jokeID.ToString());
var celebrityJokeJson = await result.Content.ReadAsStringAsync();
var celebrityJokes = JsonConvert.DeserializeObject <CelebrityJoke>(celebrityJokeJson);
// Add relevant jokes to list
CelebrityJokes.Add(celebrityJokes);
}
}
else
{
var dialog = new MessageDialog("Sorry we couldn't find a joke containing \"" + inputSearch + "\"");
await dialog.ShowAsync();
}
}
}
else
{
var dialog = new MessageDialog("Please fill out the search field");
await dialog.ShowAsync();
}
}
}
catch (SqlException ex)
{
var dialog = new MessageDialog("Something went wrong with the SQL connection.");
await dialog.ShowAsync();
FileLogger.LogExceptions(DateTime.Now + " " + ex.GetType().Name + ex.Message + ex.StackTrace + "\n" + "\n");
}
}
//Adds the new joke to the list
private async void Button_Add_Joke_Async(object sender, RoutedEventArgs e)
{
var stringContent = new StringContent(JsonConvert.SerializeObject(SelectedJoke), Encoding.UTF8, "application/json");
try
{
if (SelectedJoke != null)
{
if (SelectedJoke.CelebrityMentioned != "" && SelectedJoke.Author != "" && SelectedJoke.Text != "")
{
// Add the new joke to the database
await httpCelebrityJokesUri.PostAsync(celebrityJokeUri, stringContent).ConfigureAwait(false);
await Windows.ApplicationModel.Core.CoreApplication.MainView.CoreWindow.Dispatcher.RunAsync(CoreDispatcherPriority.Normal,
async() =>
{
var dialog = new MessageDialog("Joke added to the database successfully");
await dialog.ShowAsync();
});
}
else
{
var dialog = new MessageDialog("Please fill in the required fields.");
await dialog.ShowAsync();
}
}
else
{
var dialog = new MessageDialog("Please select a joke.");
await dialog.ShowAsync();
}
}
catch (HttpRequestException ex)
{
var dialog = new MessageDialog(ex.GetType().Name + ": Cannot add joke to database.Please check VPN or network connection.");
await dialog.ShowAsync();
FileLogger.LogExceptions(DateTime.Now + " " + ex.GetType().Name + ex.Message + ex.StackTrace + "\n" + "\n");
}
try
{
await Windows.ApplicationModel.Core.CoreApplication.MainView.CoreWindow.Dispatcher.RunAsync(CoreDispatcherPriority.Normal,
async() =>
{
CelebrityJokes.Clear();
var result = await httpCelebrityJokesUri.GetAsync(celebrityJokeUri);
var celebrityJokeJson = await result.Content.ReadAsStringAsync();
var celebrityJokes = JsonConvert.DeserializeObject <CelebrityJoke[]>(celebrityJokeJson);
foreach (CelebrityJoke CJ in celebrityJokes)
{
CelebrityJokes.Add(CJ);
}
});
}
catch (HttpRequestException ex)
{
var dialog = new MessageDialog(ex.GetType().Name + ": Database connection error. Please check VPN and network connection.");
await dialog.ShowAsync();
FileLogger.LogExceptions(DateTime.Now + " " + ex.GetType().Name + ex.Message + ex.StackTrace + "\n" + "\n");
}
}