public class BooksManagerDAC
{
static string strConnString = "Server=127.0.0.1;Port=5432;Database=Books;User
ID=postgres;Password=Pa$$W0rd";
public static void Create (Book b)
{
string commandText = "Insert into
books(title,isbn,numpages,publishyear,acquired,picture)Values(:title,:isbn,:numpages,:p
ublishyear,:acquired,:picture)";
byte[] bytesFromImage = GetPhotoFromFileName(b.ImagePath);
using(NpgsqlConnection conn = GetConnection())
{
using(NpgsqlCommand cmd = new NpgsqlCommand(commandText,conn))
{
var paramTitle = new NpgsqlParameter("title",
NpgsqlDbType.Varchar);
paramTitle.SourceColumn = "title";
paramTitle.Value = b.Title;
cmd.Parameters.Add(paramTitle);
var paramISBN = new NpgsqlParameter("isbn", NpgsqlDbType.Varchar);
paramISBN.SourceColumn = "isbn";
paramISBN.Value = b.ISBN;
cmd.Parameters.Add(paramISBN);
var paramNumPages = new NpgsqlParameter("numpages", NpgsqlDbType.Smallint);
paramNumPages.SourceColumn = "numpages";
paramNumPages.Value = b.NumPages;
cmd.Parameters.Add(paramNumPages);
var paramPubYear = new NpgsqlParameter("publishyear",
NpgsqlDbType.Smallint);
paramPubYear.SourceColumn = "publishyear";
paramPubYear.Value = b.PublisherYear;
cmd.Parameters.Add(paramPubYear);
var paramAcquired = new NpgsqlParameter("acquired", NpgsqlDbType.Date);
paramAcquired.SourceColumn = "acquired";
paramAcquired.Value = b.Acquired;
cmd.Parameters.Add(paramAcquired);
var pPicture = new NpgsqlParameter("picture", NpgsqlDbType.Bytea);
pPicture.SourceColumn = "picture";
pPicture.Value = bytesFromImage;
cmd.Parameters.Add(pPicture);
int r = cmd.ExecuteNonQuery();
Console.WriteLine("{0} affected",r);
}
}
}
public static Book SelectById(int id){
string commandText = "SELECT
bookid,title,isbn,numpages,publishyear,acquired,picture " +
" FROM Books WHERE bookid = " + id.ToString();
Book b = null;
using(NpgsqlDataReader reader = GetReader(commandText))
{
int colBookId = reader.GetOrdinal("bookid");
int colTitle = reader.GetOrdinal("title");
int colISBN =reader.GetOrdinal("isbn");
int colNumPages = reader.GetOrdinal("numpages");
int colPublishYear = reader.GetOrdinal("publishyear");
int colAcquired = reader.GetOrdinal("acquired");
int colPicture = reader.GetOrdinal("picture");
while(reader.Read()){
b = new Book{
BookId = reader.GetInt32(colBookId),
Title = reader.GetString(colTitle),
atix
spinscale
keithyokoma
moritama1515
yoshidashingo
tsutaj
alexanderbyndyu
yuya4
chmikata
trycycle
kawaguti
washizaki
mitsuaki96
samanthasiow
sugarenia
lynnandtonic
smashingmag
zakiwarfel
danielanewman
searls
ammeep
denniskardys
soudai
tammielis
maltzj