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