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() + " đ";
}
