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