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