private void ChangeLocationButton_Click(object sender, RoutedEventArgs e) { try { var dialog = new MyDialog(); if (dialog.ShowDialog() == true) { var currentSituation = new Situation().Get(); currentSituation.CurrentLocation = dialog.ResponseText; currentSituation.Update(); boardJobViewSource.Source = GenerateBoardJobs(currentSituation.CurrentLocation); var currentBase = AirportDatabaseFile.FindAirportInfo(currentSituation.CurrentLocation); CurrentLocationLabel.Content = "You are in: " + currentBase.AirportName + " (" + currentBase.ICAO + ") - " + currentBase.Country; } } catch (Exception ex) { MessageBox.Show(this, ex.Message, "ERROR", MessageBoxButton.OK, MessageBoxImage.Error); } }
private void Window_Loaded(object sender, RoutedEventArgs e) { try { boardJobViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("boardJobViewSource"))); // Load data by setting the CollectionViewSource.Source property: // boardJobViewSource.Source = [generic data source] var currentSituation = new Situation().Get(); Base currentBase = AirportDatabaseFile.FindAirportInfo(currentSituation.CurrentLocation); MoneyLabel.Content = "Your companny cash is: " + currentSituation.CompanyCash.ToString("C", CultureInfo.GetCultureInfo("en-US")); CurrentLocationLabel.Content = "You are in: " + currentBase.AirportName + " (" + currentBase.ICAO + ") - " + currentBase.Country; } catch (Exception ex) { MessageBox.Show(this, ex.Message, "ERROR", MessageBoxButton.OK, MessageBoxImage.Error); } }
private void RunJoButton_Click(object sender, RoutedEventArgs e) { try { var job = (BoardJob)boardJobDataGrid.SelectedItem; if (new JobRuning(job).ShowDialog() == true) { var currentSituation = new Situation().Get(); currentSituation.CurrentLocation = job.Arrival; currentSituation.CompanyCash += job.Profit; currentSituation.Update(); boardJobViewSource.Source = GenerateBoardJobs(currentSituation.CurrentLocation); var currentBase = AirportDatabaseFile.FindAirportInfo(currentSituation.CurrentLocation); MoneyLabel.Content = "Your companny cash is: " + currentSituation.CompanyCash.ToString("C", CultureInfo.GetCultureInfo("en-US")); CurrentLocationLabel.Content = "You are in: " + currentBase.AirportName + " (" + currentBase.ICAO + ") - " + currentBase.Country; } } catch (Exception ex) { MessageBox.Show(this, ex.Message, "ERROR", MessageBoxButton.OK, MessageBoxImage.Error); } }
private void ReGenJobsButton_Click(object sender, RoutedEventArgs e) { try { var currentSituation = new Situation().Get(); if (currentSituation == null || string.IsNullOrEmpty(currentSituation.CurrentLocation)) { var dialog = new MyDialog(); if (dialog.ShowDialog() == true) { var newSituation = new Situation() { CurrentLocation = dialog.ResponseText }; newSituation.Insert(); Base currentBase = AirportDatabaseFile.FindAirportInfo(newSituation.CurrentLocation); CurrentLocationLabel.Content = "You are in: " + currentBase.AirportName + " (" + currentBase.ICAO + ") - " + currentBase.Country; } } else { boardJobViewSource.Source = GenerateBoardJobs(currentSituation.CurrentLocation); } } catch (Exception ex) { MessageBox.Show(this, ex.Message, "ERROR", MessageBoxButton.OK, MessageBoxImage.Error); } }
internal void UpdateSituation(Situation situation) { try { using (var conn = new SQLiteConnection(connString)) { conn.Open(); var cmdSql = new SQLiteCommand("Update Situation SET CurrentLocationICAO = @currentLocationICAO, CompanyCash = @companyCash WHERE id = @id", conn); cmdSql.Parameters.AddWithValue("@currentLocationICAO", situation.CurrentLocation); cmdSql.Parameters.AddWithValue("@companyCash", situation.CompanyCash); cmdSql.Parameters.AddWithValue("@id", situation.Id); int result = cmdSql.ExecuteNonQuery(); conn.Close(); } } catch (Exception ex) { Console.WriteLine(ex); throw ex; } }
internal Situation SelectSituation() { try { using (var conn = new SQLiteConnection(connString)) { var cmdSql = new SQLiteCommand("SELECT * FROM [Situation]", conn); conn.Open(); var reader = cmdSql.ExecuteReader(); var situation = new Situation(); while (reader.Read()) { situation.Id = Convert.ToInt64(reader["id"].ToString()); situation.CurrentLocation = reader["CurrentLocationICAO"].ToString().Trim(); situation.CompanyCash = Convert.ToDecimal(reader["CompanyCash"].ToString().Trim()); break; } reader.Dispose(); conn.Close(); return situation; } } catch (Exception ex) { Console.WriteLine(ex); throw ex; } }
internal void InsertSituation(Situation situation) { try { using (var conn = new SQLiteConnection(connString)) { var cmdSql = new SQLiteCommand("INSERT INTO [Situation] (CurrentLocationICAO, CompanyCash) VALUES (@currentLocationICAO, @companyCash)", conn); conn.Open(); cmdSql.Parameters.AddWithValue("@currentLocationICAO", situation.CurrentLocation); cmdSql.Parameters.AddWithValue("@companyCash", situation.CompanyCash); cmdSql.ExecuteNonQuery(); conn.Close(); } } catch (Exception ex) { Console.WriteLine(ex); throw ex; } }