private async void UpdateDb_Click(object sender, RoutedEventArgs e) { //MessageBox.Show(Unloaded.Value.ToString()); if (Unloaded.Value != 0) { Double loaded = double.Parse(loadedmilk1.Text); Double unloaded = double.Parse(Unloaded.Value.ToString()); Double Deficit = loaded - unloaded; if (Deficit < 3.0) { Deficit = 0; } Connection cn = new Connection(); try{ cn.connect(); cn.cmd.Connection = cn.cnn; cn.cmd.Connection.Open(); cn.cmd.CommandText = "update MilkCreameryDelivery Set Litres_Unloaded='" + unloaded + "', Deficit='" + Deficit + "',Delivered='True' WHERE DATE='" + DateTime.Now.ToShortDateString() + "'"; cn.cmd.ExecuteScalar(); MessageDialogResult x = new MessageDialogResult(); MetroDialogSettings y = new MetroDialogSettings(); y.AffirmativeButtonText = "Quit"; await this.ShowMessageAsync("Delivery Confirmed", "You have updated the Delivery Successfuly.", MessageDialogStyle.Affirmative, y); if (x.ToString() == "Negative") { this.Close(); } //farmerDatagrid.ItemsSource = LoadCollectionData(); //ViewFarmersTab.BringIntoView(); // clearRegFields(); } catch (Exception ex) { displayMetroError(ex); //ShowOverlay(); //MessageBox.Show("Registration has Failed! The following Message was generated to explain why \n \n"+ex.Message+"\n \n"+ex.InnerException,"Registration Failure",MessageBoxButton.OK,MessageBoxImage.Error); //HideOverlay(); } } else { Unloaded.Focus(); } }