/*!
* \brief This handler handles when the user clicks the "Order Submit" button.
* \details This handler handles the newly created order being entered into the database via the users connection string.
* \param sender <b>object</b>
* \param e <b>RoutedEventArgs</b>
*/
private void orderSubmitBTN_Click(object sender, RoutedEventArgs e)
{
if ((string)cityInput.SelectedItem == order.ORIGIN)
{
string conStr = ConfigurationManager.ConnectionStrings[localUser.CONSTR].ConnectionString;
StringBuilder cmdSB = new StringBuilder("INSERT INTO Orders(OrderID, OrderDate, CustomerName, JobType, Quantity, Origin, Destination, Van_Type, MarkedForAction) VALUES (" + order.ORDERID + ", '" + order.getTimeStamp().ToString() + "', '" + order.CUSTOMERNAME + "', " + order.JOBTYPE + ", " + order.QUANTITY + ", '" + order.ORIGIN + "', '" + order.DESTINATION + "', " + order.VANTYPE + ", " + order.MARKEDFORACTION + "); INSERT INTO Customers(CustomerName) VALUES ('" + order.CUSTOMERNAME + "');");
using (MySqlConnection connection = new MySqlConnection(conStr))
{
MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(cmdSB.ToString(), connection);
try
{
connection.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
connection.Close();
}
}
buyer_InitiateOrder buyerOrderMenu = new buyer_InitiateOrder(localUser);
this.NavigationService.Navigate(buyerOrderMenu);
}
else
{
errorMsg.Content = "ERROR: Selected city is not proximal to origin.\n";
}
}
/*!
* \brief This handler handles when the user clicks the "Initiate Order" button.
* \details This handler connects to the "Initiate Order" orders page.
* \param sender <b>object</b>
* \param e <b>RoutedEventArgs</b>
*/
private void InitiateOrderBTN_Click(object sender, RoutedEventArgs e)
{
// Go to initiate order page
buyer_InitiateOrder initiateOrder = new buyer_InitiateOrder(localUser);
this.NavigationService.Navigate(initiateOrder);
}
/*!
* \brief This handler handles when the user clicks the "Create Order" button.
* \details This handler connects to the "Create Order" orders page.
* \param sender <b>object</b>
* \param e <b>RoutedEventArgs</b>
*/
private void createOrderBTN_PreviewMouseLeftButtonDown(object sender, MouseButtonEventArgs e)
{
// Go to initiate order page
buyer_InitiateOrder initiateOrder = new buyer_InitiateOrder(localUser);
theFrame.NavigationService.Navigate(initiateOrder);
createOrderBTN.IsEnabled = false;
reviewCustomersBTN.IsEnabled = true;
reviewOrdersBTN.IsEnabled = true;
}
