public void addListBook(string date) { string sql = "Select * from PhieuMuonSach"; int idPhieuMuon = SingletonDataProvider.Ins.DataBase.truyvan(sql).Rows.Count + 1; string sql2 = "Select * from PhieuMuon_Sach"; int id = SingletonDataProvider.Ins.DataBase.truyvan(sql2).Rows.Count + 1; var listBook = CartBook.GetList(); decimal totalMoney = 0; for (int i = 0; i < listBook.Count(); i++) { totalMoney += listBook[i].Gia; } string sql3 = "Insert Into PhieuMuonSach Values (" + idPhieuMuon + "," + User.getUserID() + ",null,'" + DateTime.UtcNow.Date.ToString().Split()[0] + "'," + "'binh thuong','" + date + "'," + totalMoney + " )"; SingletonDataProvider.Ins.DataBase.truyvan(sql3); for (int i = 0; i < listBook.Count(); i++) { string sql4 = "Insert Into PhieuMuon_Sach Values (" + id + "," + idPhieuMuon + "," + listBook[i].idSach + " )"; id++; SingletonDataProvider.Ins.DataBase.truyvan(sql4); } }
private void Button_Click_1(object sender, RoutedEventArgs e) { Button button = sender as Button; var book = (DataRowView)button.DataContext; //MessageBox.Show(int.Parse(book.Row[0].ToString()) + book.Row[1].ToString() + int.Parse(book.Row[2].ToString()) + int.Parse(book.Row[3].ToString()) +decimal.Parse(book.Row[4].ToString())+ int.Parse(book.Row[5].ToString()) + book.Row[6].ToString() + book.Row[7].ToString()); BookMgr bookmgr = new BookMgr(int.Parse(book.Row[0].ToString()), book.Row[1].ToString(), int.Parse(book.Row[2].ToString()), int.Parse(book.Row[3].ToString()), decimal.Parse(book.Row[4].ToString()), int.Parse(book.Row[5].ToString()), book.Row[6].ToString(), book.Row[7].ToString()); if (CartBook.GetList().Count() == Regulations.SoLuongSachToiDa) { MessageBox.Show("Số Sách Mượn Đã Tối Đa"); return; } CartBook.AddBook(bookmgr); //DataRowView librarian = ListBook.SelectedItem as DataRowView; //DataRowView librarian = ListBook.SelectedItem as DataRowView; // MessageBox.Show(book.Row[0].ToString()); //Game game = button.DataContext as Game; //int id = game.ID; }
public borrowBook() { InitializeComponent(); txtUserName.Content = User.getUserName(); dateTimePicker1.Text = DateTime.Today.ToString(); listBook = CartBook.GetList(); ListBook.ItemsSource = listBook; //for(int i=0;i<CartBook.GetList().Count();i++) //{ // //bookDAO.FindBookbyId(CartBook.getList()[i]); //} //MessageBox.Show(listId.ToString()); for (int i = 0; i < listBook.Count(); i++) { totalMoney += listBook[i].Gia; } txtTotalMoney.Content = totalMoney.ToString() + " đ"; }