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); } }