public static Boolean Delete(int CopyNumber)
{
SqlCommand cmd = new SqlCommand("delete CirculatedCopy where copyNumber=@c");
cmd.Parameters.AddWithValue("@c", CopyNumber);
return(DAO.UpdateTable(cmd));
}
public static bool Update(Copy c)
{
SqlCommand cmd = new SqlCommand("update Copy set type=@t, price = @p where copyNumber = @c ");
cmd.Parameters.AddWithValue("@t", c.Type);
cmd.Parameters.AddWithValue("@p", c.Price);
cmd.Parameters.AddWithValue("@c", c.CopyNumber);
return(DAO.UpdateTable(cmd));
}
public static bool Update(Reservation r)
{
SqlCommand cmd = new SqlCommand("update Reservation set status = @s where ID = @i");
cmd.Parameters.AddWithValue("@s", r.Status);
cmd.Parameters.AddWithValue("@i", r.Id);
return(DAO.UpdateTable(cmd));
}
public static bool Update(CirculatedCopy c)
{
SqlCommand cmd = new SqlCommand("Update CirculatedCopy set returnedDate = @r , fineAmount = @f where ID = @i");
cmd.Parameters.AddWithValue("@r", c.ReturnedDate);
cmd.Parameters.AddWithValue("@f", c.FineAmount);
cmd.Parameters.AddWithValue("@i", c.Id);
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("@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(Reservation cc)
{
SqlCommand cmd = new SqlCommand("INSERT INTO [Reservation]([borrowerNumber],[bookNumber],[date],[status])" +
" VALUES(@borrowerNumber,@bookNumber,@date,@status)");
cmd.Parameters.AddWithValue("@borrowerNumber", cc.BorrowerNumber);
cmd.Parameters.AddWithValue("@bookNumber", cc.BookNumber);
cmd.Parameters.AddWithValue("@date", cc.Date);
cmd.Parameters.AddWithValue("@status", cc.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("@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 bool Insert(Borrower b)
{
SqlCommand cmd = new SqlCommand("insert into Borrower(name, sex, address, telephone, email)" +
"values(@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(Copy c)
{
if (CirculatedCopyDAO.Delete(c.CopyNumber))
{
SqlCommand cmd = new SqlCommand("delete Copy where copyNumber=@c");
cmd.Parameters.AddWithValue("@c", c.CopyNumber);
return(DAO.UpdateTable(cmd));
}
else
{
return(false);
}
}
public static bool Insert(Copy c)
{
SqlCommand cmd = new SqlCommand("insert into Copy(bookNumber,sequenceNumber,type, price)" +
"values (@a, @b, @c, @d)");
//cmd.Parameters.AddWithValue("@bookNumber", b.BookNumber);
cmd.Parameters.AddWithValue("@a", c.BookNumber);
cmd.Parameters.AddWithValue("@b", c.SequenceNumber);
cmd.Parameters.AddWithValue("@c", c.Type);
cmd.Parameters.AddWithValue("@d", c.Price);
return(DAO.UpdateTable(cmd));
}
public static bool Insert(CirculatedCopy cc)
{
SqlCommand cmd = new SqlCommand("insert into CirculatedCopy(copyNumber, borrowerNumber, borrowedDate, dueDate, fineAmount)" +
"values(@copyNumber, @borrowerNumber, @borrowedDate , @dueDate, @fineAmount)");
cmd.Parameters.AddWithValue("@copyNumber", cc.CopyNumber);
cmd.Parameters.AddWithValue("@borrowerNumber", cc.BorrowerNumber);
cmd.Parameters.AddWithValue("@borrowedDate", cc.BorrowedDate);
cmd.Parameters.AddWithValue("@dueDate", cc.DueDate);
cmd.Parameters.AddWithValue("@fineAmount", cc.FineAmount);
return(DAO.UpdateTable(cmd));
}
public static Boolean Delete(Book b)
{
SqlConnection conn = new SqlConnection(strConn);
SqlCommand cmd1 = new SqlCommand("Delete Reservation where bookNumber=@b", conn);
cmd1.Parameters.AddWithValue("@b", b.BookNumber);
conn.Open();
cmd1.ExecuteNonQuery();
conn.Close();
DeleteAllCopiesByBookId(b);
SqlCommand cmd = new SqlCommand("delete Book where bookNumber=@bookNumber");
cmd.Parameters.AddWithValue("@bookNumber", b.BookNumber);
return(DAO.UpdateTable(cmd));
}