public string PostOrder(clsOrder prOrder)
{ // insert inventory
try
{
int lcRecCount = clsDbConnection.Execute("INSERT INTO tblOrder " +
"(itemID, priceAtOrder, orderQuantity, orderDateTime, customerName, customerEmail) " +
"VALUES (@itemID, @priceAtOrder, @orderQuantity, @orderDateTime, @customerName, @customerEmail)",
prepareOrderParameters(prOrder));
if (lcRecCount == 1)
{
return("Order confirmed");
}
else
{
return("Unexpected order insert count: " + lcRecCount);
}
}
catch (Exception ex)
{
return(ex.GetBaseException().Message);
}
}
public string PutOrder(clsOrder prOrder)
{ // update order - unfinished
try
{
int lcRecCount = clsDbConnection.Execute("UPDATE tblOrder SET " +
" " +
" " +
"WHERE orderID = @orderID",
prepareOrderParameters(prOrder));
if (lcRecCount == 1)
{
return("One order updated");
}
else
{
return("Unexpected order update count: " + lcRecCount);
}
}
catch (Exception ex)
{
return(ex.GetBaseException().Message);
}
}
