private void InsertData(int index)
{
ConnectData.Connect();
//
//string user = "******";
string user = usernamelink.Text;
//
string numRoom = danhsachphongtrong.Rows[index].Cells[5].Value.ToString();
int num;
int.TryParse(numRoom, out num);
DateTime dateIn = DateTime.Parse(ngaynhanphongdt.Text);
DateTime dateOut = dateIn.AddDays(int.Parse(ngayolai.Text));
string sql = "sp_booking";
int result;
//+ user +"," + numRoom + "," + checkIn + "," + checkOut + "," + result
result = ConnectData.ExcuteProcedure(sql, user, num, dateIn, dateOut);
ConnectData.DisConnect();
if (result == 1)
{
MessageBox.Show("Xin lỗi quý khách !! \nPhòng này đã có người sử dụng !", "Error");
danhsachphongtrong.CancelEdit();
}
else
{
MessageBox.Show("Đặt phòng thành công !!");
}
}
private void LoadData()
{
ConnectData.Connect();
string sql = "SELECT ks.maKS,ks.tenKS,ks.thanhPho,ks.soSao,ks.giaTB,tt.maPhong,tt.tinhTrang FROM ((KhachSan ks JOIN LoaiPhong lp ON ks.maKS = lp.maKS) JOIN Phong p ON lp.maLoaiPhong = p.LoaiPhong) JOIN TrangThaiPhong tt ON p.maPhong = tt.maPhong WHERE tt.ngay = (select max(tt1.ngay) from TrangThaiPhong tt1 where tt1.maPhong = tt.maPhong) AND tt.tinhTrang = 0";
DataTable dsKS = new DataTable();
dsKS = ConnectData.LoadData(string.Format(sql));
for (int i = 0; i < dsKS.Rows.Count; i++)
{
danhsachphongtrong.Rows.Add(dsKS.Rows[i][0], dsKS.Rows[i][1], dsKS.Rows[i][2], dsKS.Rows[i][3], dsKS.Rows[i][4], dsKS.Rows[i][5], dsKS.Rows[i][6]);
}
ConnectData.DisConnect();
}