private void Click_SubmitButton(object sender, RoutedEventArgs e)
{
//get combobox
var comboBoxState = boxState as ComboBox;
//set selected value to string
string stateSelected = comboBoxState.SelectedItem as string;
try
{
locationModel.NewLocation = new Location()
{
City = txtCity.Text,
CityRating = int.Parse(txtRating.Text),
Notes = txtNotes.Text,
};
var stateID = statesModel.AllStates.Where(x => x.State == stateSelected);
foreach (var item in stateID)
{
locationModel.NewLocation.StateId = item.StateID;
}
}
catch (FormatException)
{
MessageBox.Show("The rating must be a single, valid number", "Error", MessageBoxButton.OK);
return;
}
if (string.IsNullOrEmpty(txtCity.Text) || string.IsNullOrEmpty(txtRating.Text) || stateSelected is null)
{
MessageBox.Show("You must have City, State, and Rating all filled out in order to submit", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
SQLConnections sqlConnection = new SQLConnections();
sqlConnection.AddLocation(locationModel.NewLocation);
MessageBoxResult result = MessageBox.Show("Location added!", "Success", MessageBoxButton.OKCancel, MessageBoxImage.None);
if (result == MessageBoxResult.OK)
{
//clear text boxes
canceledMessage.Visibility = Visibility.Hidden;
txtCity.Clear();
boxState.SelectedItem = null;
txtRating.Clear();
txtNotes.Clear();
boxState.SelectedItem = null;
}
else
{
sqlConnection.DeleteLastLocationRecord();
canceledMessage.Visibility = Visibility.Visible;
}
}
private void Click_SubmitButton(object sender, RoutedEventArgs e)
{
//get combobox
var comboBoxState = boxState as ComboBox;
//set selected value to string
string stateSelected = comboBoxState.SelectedItem as string;
//get int value for stateID
int stateIDValue = GetStateID(stateSelected);
try
{
LocationInfo.City = txtCity.Text;
LocationInfo.StateID = stateIDValue;
LocationInfo.Rating = int.Parse(txtRating.Text);
LocationInfo.Notes = txtNotes.Text;
}
catch (FormatException)
{
MessageBox.Show("Rating must be a number", "Error", MessageBoxButton.OK, MessageBoxImage.None);
return;
}
if (string.IsNullOrEmpty(txtCity.Text) || string.IsNullOrEmpty(txtNotes.Text) || string.IsNullOrEmpty(txtRating.Text) || stateSelected is null)
{
MessageBox.Show("You must have City, State, and Rating all filled out in order to submit", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
SQLConnections sqlConnection = new SQLConnections();
sqlConnection.AddLocation();
MessageBoxResult result = MessageBox.Show("Location added!", "Success", MessageBoxButton.OKCancel, MessageBoxImage.None);
if (result == MessageBoxResult.OK)
{
//clear text boxes
canceledMessage.Visibility = Visibility.Hidden;
txtCity.Clear();
boxState.SelectedItem = null;
txtRating.Clear();
txtNotes.Clear();
boxState.SelectedItem = null;
}
else
{
sqlConnection.DeleteLastLocationRecord();
canceledMessage.Visibility = Visibility.Visible;
}
}