private Dictionary <string, object> prepareProductParameters(clsProducts prProducts)
{
Dictionary <string, object> par = new Dictionary <string, object>(10);
par.Add("Category", prProducts.Category);
par.Add("DVDName", prProducts.DVDName);
par.Add("Description", prProducts.Description);
par.Add("DVDCondition", prProducts.DVDCondition);
par.Add("DVDType", prProducts.DVDType);
par.Add("Price", prProducts.Price);
//par.Add("LastModified", prProducts.LastModified);
par.Add("QuanityInStock", prProducts.QuanityInStock);
return(par);
}
[HttpPut] public string UpdateQuanityInStock(clsProducts prProduct)
{
try
{
int lcRecCount = clsDBConnection.Execute(
"UPDATE Products SET QuanityInStock = @QuanityInStock WHERE DVDName = @DVDName",
prepareProductParameters(prProduct));
if (lcRecCount == 1)
{
return("Order Updated");
}
else
{
return("Unexpected order update count: " + lcRecCount);
}
}
catch (Exception ex)
{
return(ex.GetBaseException().Message);
}
}
public string PutProduct(clsProducts prProduct)
{
try
{
int lcRecCount = clsDBConnection.Execute(
"UPDATE Products SET Description = @Description, Price = @Price, LastModified = Now(), QuanityInStock = @QuanityInStock, DVDCondition = @DVDCondition WHERE DVDName = @DVDName",
prepareProductParameters(prProduct));
if (lcRecCount == 1)
{
return("One Product Updated");
}
else
{
return("Unexpected Product Update Count: " + lcRecCount);
}
}
catch (Exception ex)
{
return(ex.GetBaseException().Message);
}
}
public string DeleteProduct(clsProducts prProduct)
{
try
{
int lcRecCount = clsDBConnection.Execute(
"DELETE FROM Products WHERE DVDName = @DVDName AND Category = @Category",
prepareProductParameters(prProduct));
if (lcRecCount == 1)
{
return("One Product Deleted");
}
else
{
return("Unexpected Product Delete count: " + lcRecCount);
}
}
catch (Exception ex)
{
return(ex.GetBaseException().Message);
}
}
public string PostProduct(clsProducts prProduct)
{ // insert
try
{
int lcRecCount = clsDBConnection.Execute("INSERT INTO Products " +
"(DVDName, Description, Price, DVDType, LastModified, QuanityInStock, DVDCondition, Category) " +
"VALUES (@DVDName, @Description, @Price, @DVDType, Now(), @QuanityInStock, @DVDCondition, @Category)",
prepareProductParameters(prProduct));
if (lcRecCount == 1)
{
return("One Product Added");
}
else
{
return("Unexpected Product Insert Count: " + lcRecCount);
}
}
catch (Exception ex)
{
return(ex.GetBaseException().Message);
}
}
