public string PutOrder(clsOrder prOrder) { try { int lcRecCount = clsDbConnection.Execute( "UPDATE Orders SET ProductCode = @ProductCode, ProductName = @ProductName, Quantity = @Quantity, PriceAtTimeOfOrder = @PriceAtTimeOfOrder, TimeOfOrder = @TimeOfOrder, CustomerDetails = @CustomerDetails, DeviceTypeName = @DeviceTypeName 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); } }
public string PostOrder(clsOrder prOrder) { // insert try { int lcRecCount = clsDbConnection.Execute("INSERT INTO Orders " + "(OrderID, ProductCode, ProductName, Quantity, PriceAtTimeOfOrder, TimeOfOrder, CustomerDetails, DeviceTypeName) " + "VALUES (@OrderID, @ProductCode, @ProductName, @Quantity, @PriceAtTimeOfOrder, @TimeOfOrder, @CustomerDetails, @DeviceTypeName)", prepareOrderParameters(prOrder)); if (lcRecCount == 1) { return("Order Succesfully Made"); } else { return("Unexpected Order insert count: " + lcRecCount); } } catch (Exception ex) { return(ex.GetBaseException().Message); } }