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