private Dictionary <string, object> prepareBookParameters(clsAllBook prBook)
{
Dictionary <string, object> par = new Dictionary <string, object>(10);
par.Add("ISBN", prBook.ISBN);
par.Add("GenreName", prBook.GenreName);
par.Add("Name", prBook.Name);
par.Add("Price", prBook.Price);
par.Add("LastModified", prBook.LastModified);
par.Add("Quantity", prBook.Quantity);
par.Add("BookFormat", prBook.BookFormat);
par.Add("CoverType", prBook.CoverType);
par.Add("SerialKey", prBook.SerialKey);
par.Add("DownloadURL", prBook.DownloadURL);
return(par);
}
public string PutBookQuantity(clsAllBook prBook)
{ // update
try
{
int lcRecCount = clsDbConnection.Execute("UPDATE tblBook SET " +
"Quantity = Quantity -@Quantity WHERE ISBN=@ISBN",
prepareBookParameters(prBook));
if (lcRecCount == 1)
{
return("One book updated");
}
else
{
return("Unexpected book update count: " + lcRecCount);
}
}
catch (Exception ex)
{
return(ex.GetBaseException().Message);
}
}
public string PutBook(clsAllBook prBook)
{ // update
try
{
int lcRecCount = clsDbConnection.Execute("UPDATE tblBook SET " +
"GenreName = @GenreName, Name = @Name, Price = @Price," +
"BookFormat = @BookFormat, LastModified = @LastModified, Quantity = @Quantity, CoverType = @CoverType, SerialKey = @SerialKey, DownloadURL = @DownloadURL WHERE ISBN=@ISBN",
prepareBookParameters(prBook));
if (lcRecCount == 1)
{
return("One book updated");
}
else
{
return("Unexpected book update count: " + lcRecCount);
}
}
catch (Exception ex)
{
return(ex.GetBaseException().Message);
}
}
public string PostBook(clsAllBook prBook)
{ // insert
try
{
int lcRecCount = clsDbConnection.Execute("INSERT INTO tblBook " +
"(ISBN, GenreName, Name, Price, LastModified, Quantity, BookFormat, CoverType, SerialKey, DownloadURL) " +
"VALUES (@ISBN, @GenreName, @Name, @Price, @LastModified, @Quantity, @BookFormat, @CoverType, @SerialKey, @DownloadURL)",
prepareBookParameters(prBook));
if (lcRecCount == 1)
{
return("One book inserted");
}
else
{
return("Unexpected book insert count: " + lcRecCount);
}
}
catch (Exception ex)
{
return(ex.GetBaseException().Message);
}
}
