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