public static Boolean 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(Reservation b)
{
SqlCommand cmd = new SqlCommand("update Reservation set status=@status where ID=@id");
cmd.Parameters.AddWithValue("@status", b.Status);
cmd.Parameters.AddWithValue("@id", b.Id);
return(DAO.UpdateTable(cmd));
}
public static bool Update(Copy c)
{
SqlCommand cmd = new SqlCommand("update Copy set type=@type, price = @price where copyNumber=@copyNumber");
cmd.Parameters.AddWithValue("@type", c.Type);
cmd.Parameters.AddWithValue("@price", c.Price);
cmd.Parameters.AddWithValue("@copyNumber", c.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(CirculatedCopy b)
{
SqlCommand cmd = new SqlCommand("insert into CirculatedCopy(copyNumber,borrowerNumber, borrowedDate, dueDate) values(@copyNumber,@borrowerNumber,@borrowedDate,@dueDate)");
cmd.Parameters.AddWithValue("@copyNumber", b.CopyNumber);
cmd.Parameters.AddWithValue("@borrowerNumber", b.BorrowerNumber);
cmd.Parameters.AddWithValue("@borrowedDate", b.BorrowedDate);
cmd.Parameters.AddWithValue("@dueDate", b.DueDate);
return(DAO.UpdateTable(cmd));
}
public static bool Insert(Reservation b)
{
SqlCommand cmd = new SqlCommand("insert into Reservation(borrowerNumber, bookNumber, date, status) " +
"values(@borrowerNumber, @bookNumber, @date, @status)");
cmd.Parameters.AddWithValue("@borrowerNumber", b.BorrowerNumber);
cmd.Parameters.AddWithValue("@bookNumber", b.BookNumber);
cmd.Parameters.AddWithValue("@date", b.Date);
cmd.Parameters.AddWithValue("@status", b.Status);
return(DAO.UpdateTable(cmd));
}
public static bool Update(Borrower b)
{
SqlCommand cmd = new SqlCommand("update 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 static bool Update(CirculatedCopy b)
{
SqlCommand cmd = new SqlCommand("update CirculatedCopy set copyNumber=@copyNumber, borrowerNumber = @borrowerNumber, borrowedDate = @borrowedDate, dueDate = @dueDate, returnedDate = @returnedDate,fineAmount = @fineAmount where ID=@id");
cmd.Parameters.AddWithValue("@copyNumber", b.CopyNumber);
cmd.Parameters.AddWithValue("@borrowerNumber", b.BorrowerNumber);
cmd.Parameters.AddWithValue("@borrowedDate", b.BorrowedDate);
cmd.Parameters.AddWithValue("@dueDate", b.DueDate);
cmd.Parameters.AddWithValue("@returnedDate", b.ReturnedDate);
cmd.Parameters.AddWithValue("@fineAmount", b.FineAmount);
cmd.Parameters.AddWithValue("@ID", b.Id);
return(DAO.UpdateTable(cmd));
}
