public bool Insert(Borrower b)
{
SqlCommand cmd = new SqlCommand("INSERT INTO [dbo].[Borrower]"
+ "([borrowerNumber]"
+ ",[name]"
+ ",[sex]"
+ ",[address]"
+ ",[telephone]"
+ ",[email])"
+ "VALUES"
+ "(@borrowerNumber"
+ ", @name"
+ ", @sex"
+ ", @address"
+ ", @telephone"
+ ", @email)");
cmd.Parameters.AddWithValue("@borrowerNumber", b.BorrowerNumber);
cmd.Parameters.AddWithValue("@name", b.Name);
cmd.Parameters.AddWithValue("@sex", b.Sex);
cmd.Parameters.AddWithValue("@address", b.Address);
cmd.Parameters.AddWithValue("@telephone", b.Telephone);
cmd.Parameters.AddWithValue("@email", b.Email);
return(DAO.UpdateTable(cmd));
}
public static Boolean Delete(int bookNumber)
{
SqlCommand cmd = new SqlCommand("delete Book where bookNumber=@bookNumber");
cmd.Parameters.AddWithValue("@bookNumber", bookNumber);
return(DAO.UpdateTable(cmd));
}
public bool Delete(int borrowerNumber)
{
SqlCommand cmd = new SqlCommand("delete Borrower where borrowerNumber=@borrowerNumber");
cmd.Parameters.AddWithValue("@borrowerNumber", borrowerNumber);
return(DAO.UpdateTable(cmd));
}
public static Boolean Delete(int copyNumber)
{
SqlCommand cmd = new SqlCommand("delete copy where copyNumber=@copyNumber");
cmd.Parameters.AddWithValue("@copyNumber", copyNumber);
return(DAO.UpdateTable(cmd));
}
public static bool Update(Book b)
{
SqlCommand cmd = new SqlCommand("update Book set title=@title, authors = @authors, publisher = @publisher where bookNumber=@bookNumber");
cmd.Parameters.AddWithValue("@bookNumber", b.BookNumber);
cmd.Parameters.AddWithValue("@title", b.Title);
cmd.Parameters.AddWithValue("@authors", b.Authors);
cmd.Parameters.AddWithValue("@publisher", b.Publisher);
return(DAO.UpdateTable(cmd));
}
public static bool Insert(Book b)
{
SqlCommand cmd = new SqlCommand("insert into book(title, authors, publisher)" +
"values (@title, @authors, @publisher)");
cmd.Parameters.AddWithValue("@title", b.Title);
cmd.Parameters.AddWithValue("@authors", b.Authors);
cmd.Parameters.AddWithValue("@publisher", b.Publisher);
return(DAO.UpdateTable(cmd));
}
public static bool Update1(int b, string type)
{
SqlCommand cmd = new SqlCommand("update copy set " +
" type =@type " +
" where copyNumber =@copyNumber");
cmd.Parameters.AddWithValue("@copyNumber", b);
cmd.Parameters.AddWithValue("@type", type);
MessageBox.Show(b + "");
return(DAO.UpdateTable(cmd));
}
public static bool Update(Copy b)
{
SqlCommand cmd = new SqlCommand("update copy set " +
"type=@type,price=@price " +
"where copyNumber =@copyNumber");
cmd.Parameters.AddWithValue("@copyNumber", b.CopyNumber);
cmd.Parameters.AddWithValue("@type", b.Type);
cmd.Parameters.AddWithValue("@price", b.Price);
return(DAO.UpdateTable(cmd));
}
public static bool Insert(Copy b)
{
SqlCommand cmd = new SqlCommand("insert into copy(copyNumber,bookNumber, sequenceNumber, type, price)" +
"values (@copyNumber, @bookNumber, @sequenceNumber, @type,@price)");
cmd.Parameters.AddWithValue("@copyNumber", b.CopyNumber);
cmd.Parameters.AddWithValue("@bookNumber", b.BookNumber);
cmd.Parameters.AddWithValue("@sequenceNumber", b.SequenceNumber);
cmd.Parameters.AddWithValue("@type", b.Type);
cmd.Parameters.AddWithValue("@price", b.Price);
return(DAO.UpdateTable(cmd));
}
public bool Update(Borrower b)
{
SqlCommand cmd = new SqlCommand("UPDATE [dbo].[Borrower]"
+ "SET[name] = @name "
+ ",[sex] = @sex "
+ ",[address] = @address "
+ ",[telephone] = @telephone "
+ ",[email] = @email "
+ "WHERE [borrowerNumber] = @borrowerNumber");
cmd.Parameters.AddWithValue("@name", b.Name);
cmd.Parameters.AddWithValue("@sex", b.Sex);
cmd.Parameters.AddWithValue("@address", b.Address);
cmd.Parameters.AddWithValue("@telephone", b.Telephone);
cmd.Parameters.AddWithValue("@email", b.Email);
cmd.Parameters.AddWithValue("@borrowerNumber", b.BorrowerNumber);
return(DAO.UpdateTable(cmd));
}
public bool Insert(Reservation b)
{
SqlCommand cmd = new SqlCommand("INSERT INTO [dbo].[Reservation]"
+ "([borrowerNumber]"
+ ",[bookNumber]"
+ ",[date]"
+ ",[status])"
+ "VALUES"
+ "(@borrowerNumber"
+ ", @name"
+ ", @sex"
+ ", @address)");
cmd.Parameters.AddWithValue("@borrowerNumber", b.BorrowerNumber);
cmd.Parameters.AddWithValue("@name", b.BookNumber);
cmd.Parameters.AddWithValue("@sex", b.Date);
cmd.Parameters.AddWithValue("@address", b.Status);
return(DAO.UpdateTable(cmd));
}