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