private bool SaveOrder()
{
String CmdTxt = "";
MySqlCommand cmd = new MySqlCommand();
bool IsOk = true;
CmdTxt = @"INSERT INTO delivery_orders(OrderID, OrderSubID, Tel, Addresse, UserID, Delivery_Charge, OrderTotal)
VALUES(@ID, @SubID, @tel, @Addr, @User, @DeliveryCharge, @Total);";
cmd.Connection = this.myConn;
cmd.CommandText = CmdTxt;
/* Fill Command attributes */
cmd.Parameters.AddWithValue("@ID", NewOrder.Order_GetOrderID());
cmd.Parameters.AddWithValue("@SubID", NewOrder.Order_GetOrderSubID());
cmd.Parameters.AddWithValue("@tel", NewOrder.Order_GetCustTel());
cmd.Parameters.AddWithValue("@Addr", NewOrder.Order_GetCustAddr());
cmd.Parameters.AddWithValue("@User", this.UserID);
cmd.Parameters.AddWithValue("@DeliveryCharge", NewOrder.Order_GetDeliveryCharge());
cmd.Parameters.AddWithValue("@Total", NewOrder.Order_GetOrderTotal());
try
{
/* Execute Command */
cmd.ExecuteNonQuery();
}
catch (MySqlException ex)
{
MessageBox.Show(ex.Message);
IsOk = false;
}
return(IsOk);
}