public List<Store> GetAllStore() { string cs = CocBook.Properties.Settings.Default.connectionString; SqlConnection con = new SqlConnection(cs); SqlCommand cmd = new SqlCommand("Select * from BookStore", con); con.Open(); SqlDataReader sdr = cmd.ExecuteReader(); List<Store> list = new List<Store>(); while (sdr.Read()) { Store store = new Store(); store.ISBNBook = sdr["ISBN"].ToString(); string ISBN = store.ISBNBook; store.Quantity = (int)sdr["Quantity"]; Book book = new Book(); BookDAL bookDAL = new BookDAL(); book = bookDAL.GetBookbyISBN(ISBN); store.BookName = book.BookName; store.Publisher = book.PublisherName; store.Unit = book.Unit; store.Price = book.Price; list.Add(store); } con.Close(); return list; }
private void btnSearch_Click(object sender, EventArgs e) { try { if (txtSearch.Text != "") { string search = txtSearch.Text; // Search by ISBN if (rdISBN.Checked) { Store store = new Store(); BookStoreDAL bookstoreDAL = new BookStoreDAL(); if (bookstoreDAL.GetBookStorebyISBN(search) != null) { store = bookstoreDAL.GetBookStorebyISBN(search); List<Store> list = new List<Store>(); list.Add(store); BookGridView.DataSource = list; BookGridView.Refresh(); } else { MessageBox.Show("Không tìm thấy kết quả. Vui lòng nhập chính xác ISBN!"); } } else { // search by BookName if (rdBookName.Checked) { BookStoreDAL bookstoreDAL = new BookStoreDAL(); if (bookstoreDAL.GetBookStorebyName(search) != null) { List<Store> list = bookstoreDAL.GetBookStorebyName(search); BookGridView.DataSource = list; BookGridView.Refresh(); } else { MessageBox.Show("Không tìm thấy kết quả. Vui lòng nhập chính xác tên sách!"); } } if (rdISBN.Checked == false && rdBookName.Checked == false) { MessageBox.Show("Hãy chọn mục tìm kiếm !"); } } } else { MessageBox.Show("Vui lòng nhập giá trị tìm kiếm !"); } } catch (Exception ex) { logger.MyLogFile(DateTime.Now.ToString(), "' Error '" + ex.Message + "'"); } }
//Use in ViewStore public Store GetBookStorebyISBN(string ISBNBookStore) { string cs = CocBook.Properties.Settings.Default.connectionString; SqlConnection con = new SqlConnection(cs); SqlCommand cmd = new SqlCommand("Select * from BookStore where ISBN = @ISBN", con); cmd.Parameters.AddWithValue("ISBN", ISBNBookStore); con.Open(); SqlDataReader sdr = cmd.ExecuteReader(); Store store = new Store(); if (sdr.HasRows) { sdr.Read(); store.ISBNBook = sdr["ISBN"].ToString(); string ISBN = store.ISBNBook; store.Quantity = (int)sdr["Quantity"]; BookDAL bookDAL = new BookDAL(); Book book = new Book(); book = bookDAL.GetBookbyISBN(ISBN); store.BookName = book.BookName; store.Publisher = book.PublisherName; store.Unit = book.Unit; store.Price = book.Price; return store; } con.Close(); return null; }
public List<Store> GetBookStorebyPublisher(string publisher) { List<Store> list = new List<Store>(); List<Book> listBook = new List<Book>(); BookDAL bookDAL = new BookDAL(); listBook = bookDAL.GetBookbyPublisherName(publisher); foreach (var book in listBook) { Store store = new Store(); store.ISBNBook = book.ISBNBook; store.BookName = book.BookName; store.Publisher = book.PublisherName; store.Unit = book.Unit; store.Price = book.Price; string ISBN = book.ISBNBook; string cs = CocBook.Properties.Settings.Default.connectionString; SqlConnection con = new SqlConnection(cs); SqlCommand cmd = new SqlCommand("Select * from BookStore where ISBN = @ISBN", con); cmd.Parameters.AddWithValue("ISBN", ISBN); con.Open(); SqlDataReader sdr = cmd.ExecuteReader(); if (sdr.HasRows) { sdr.Read(); store.Quantity = (int)sdr["Quantity"]; } con.Close(); list.Add(store); } return list; }