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