public StudentPaymentHistoryGUI(String user) { InitializeComponent(); Student s = StudentDAO.getStudentByUsername(user); DataTable dt = HistoryPaymentDAO.GetDataTableByStuId(s.StuID); dataGridView1.DataSource = dt; }
private void btnAccept_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count == 0) { MessageBox.Show("please select one row"); } else { int bookID = int.Parse(dataGridView1.SelectedRows[0].Cells["bookID"].Value.ToString()); HistoryBook his = HistoryBookDAO.GetHistoryBooksByBookID(bookID); his.Status = 2; HistoryBookDAO.Update(his); string roomName = dataGridView1.SelectedRows[0].Cells["roomName"].Value.ToString(); int bedNo = int.Parse(dataGridView1.SelectedRows[0].Cells["bedNo"].Value.ToString()); Room r = RoomDAO.getRoomBedByRoomNameBedNoPrice(roomName, bedNo); r.BedStatus = 1; RoomDAO.Update(r); Student stu = StudentDAO.getStudentByStuID(dataGridView1.SelectedRows[0].Cells["stuID"].Value.ToString()); stu.RoomName = roomName; stu.BedNo = bedNo; stu.BookingDate = DateTime.Now; stu.MoneyAccount = stu.MoneyAccount - r.Price; StudentDAO.Update(stu); HistoryPayment hp = new HistoryPayment(1, stu.StuID, DateTime.Now, "tiền phòng", r.Price, roomName); HistoryPaymentDAO.Insert(hp); List <HistoryBook> list = HistoryBookDAO.GetHistoryBooksByRoomNameStatus(dataGridView1.SelectedRows[0].Cells["roomName"].Value.ToString(), int.Parse(dataGridView1.SelectedRows[0].Cells["bedNo"].Value.ToString())); for (int i = 0; i < list.Count; i++) { HistoryBook h = list[i]; h.Status = 0; HistoryBookDAO.Update(h); } view(); } }