public static List <HistoryPayment> getHistoryPaymentsByStuID(string stuId)
{
List <HistoryPayment> list = new List <HistoryPayment>();
SqlConnection conn = DAO.getConnections();
string cmd1 = "select * from HistoryPayment where stuID = '" + stuId + "'";
SqlCommand cmd = new SqlCommand(cmd1);
cmd.Connection = conn;
conn.Open();
SqlDataReader da = cmd.ExecuteReader();
while (da.Read())
{
int id = int.Parse(da.GetValue(0).ToString());
string stuId1 = da.GetValue(1).ToString();
DateTime datePay = DateTime.Parse(da.GetValue(2).ToString());
string type = da.GetValue(3).ToString();
int moneyPay = int.Parse(da.GetValue(4).ToString());
string roomName = da.GetValue(5).ToString();
HistoryPayment hp = new HistoryPayment(id, stuId1, datePay, type, moneyPay, roomName);
list.Add(hp);
}
conn.Close();
return(list);
}
public static bool Update(HistoryPayment b)
{
SqlCommand cmd = new SqlCommand("update HistoryPayment set datePay=@datePay, type = @type, moneyPay = @moneyPay,roomName = @roomName where id=@id");
cmd.Parameters.AddWithValue("@datePay", b.DatePay);
cmd.Parameters.AddWithValue("@type", b.Type);
cmd.Parameters.AddWithValue("@moneyPay", b.MoneyPay);
cmd.Parameters.AddWithValue("@roomName", b.RoomName);
cmd.Parameters.AddWithValue("@id", b.Id);
return(DAO.UpdateTable(cmd));
}
public static bool Insert(HistoryPayment b)
{
SqlConnection conn = DAO.getConnections();
SqlCommand cmd = new SqlCommand("insert into HistoryPayment(stuId,datePay, type,moneyPay,roomName) values(@stuId, @datePay, @type, @moneyPay,@roomName)");
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@stuId", b.StuID);
cmd.Parameters.AddWithValue("@datePay", b.DatePay);
cmd.Parameters.AddWithValue("@type", b.Type);
cmd.Parameters.AddWithValue("@moneyPay", b.MoneyPay);
cmd.Parameters.AddWithValue("@roomName", b.RoomName);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
return(true);
}
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();
}
}
