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