public string PostOrder(clsOrders prOrder)
{ // insert
try
{
int lcRecCount = clsDbConnection.Execute(
"INSERT INTO Orders VALUES (@InstrumentID, @Quantity, @Price, @Date, @CustomerName, @CustomerCity)",
prepareOrderParameters(prOrder));
if (lcRecCount == 1)
{
return("Your order has been placed");
}
else
{
return("Unexpected order count: " + lcRecCount);
}
}
catch (Exception ex)
{
return(ex.GetBaseException().Message);
}
}
