public RoomTypeRow AddRoomTypeRow(long RMTYPEID, string NAME, string SHORTNAME)
{
RoomTypeRow rowRoomTypeRow = ((RoomTypeRow)(this.NewRow()));
object[] columnValuesArray = new object[] {
RMTYPEID,
NAME,
SHORTNAME
};
rowRoomTypeRow.ItemArray = columnValuesArray;
this.Rows.Add(rowRoomTypeRow);
return(rowRoomTypeRow);
}
private void pgRoomStatus_IsVisibleChanged(object sender, DependencyPropertyChangedEventArgs e)
{
if (App.mainWindow.Visibility == Visibility.Visible)
{
if (Auth.GetLoginStatus() && Auth.GetLoggedInUserTypeIsCustomer() == false)
{
// Disable buttons
btnRoomDetail.IsEnabled = false;
btnSearch.IsEnabled = true;
// Load Hotel info
SqlCommand cmd = new SqlCommand();
cmd.Connection = dbQLKS.dbConnection;
cmd.CommandType = CommandType.Text;
cmd.CommandText = @"select * from KhachSan as KS, NhanVien as NV
where NV.maNV = '" + Auth.GetLoggedInUserId() + "' AND NV.MaKS = KS.maKS";
SqlDataReader dr;
dbQLKS.dbConnection.Open();
dr = cmd.ExecuteReader();
if (dr.Read())
{
lblHotelName.Content = dr["tenKS"].ToString();
lblHotelAddress.Content = dr["soNha"] + ", " + dr["duong"] + ", " + dr["quan"] + ", " + dr["thanhPho"];
MaKS = dr["maKS"].ToString();
// Load RoomType list
cmd.CommandText = "SELECT * FROM LoaiPhong WHERE maKS = '" + MaKS + "'";
List <RoomTypeRow> RoomtTypeList = new List <RoomTypeRow>();
dr.Close();
dr = cmd.ExecuteReader();
while (dr.Read())
{
RoomTypeRow roomTypeRow = new RoomTypeRow();
roomTypeRow.MaLoaiPhong = dr["maLoaiPhong"].ToString();
roomTypeRow.TenLoaiPhong = dr["tenLoaiPhong"].ToString();
RoomtTypeList.Add(roomTypeRow);
}
dgRoomStatus.ItemsSource = RoomtTypeList;
}
else
{
MessageBox.Show("You are not beloing to any Hotel");
Auth.Logout();
App.mainWindow.Hide();
Login x = new Login();
x.Show();
}
dbQLKS.dbConnection.Close();
}
else
{
App.mainWindow.Hide();
Login x = new Login();
x.Show();
}
}
}
private void btnSearch_Click(object sender, RoutedEventArgs e)
{
if (dgRoomStatus.SelectedIndex != -1)
{
bool dataIsValid = true;
// validate
if (dpkDate.SelectedDate == null)
{
MessageBox.Show("Please select a date");
dataIsValid = false;
}
// Query
if (dataIsValid)
{
DateTime selectedDate = (DateTime)dpkDate.SelectedDate;
SqlCommand cmd = new SqlCommand();
cmd.Connection = dbQLKS.dbConnection;
cmd.CommandType = CommandType.Text;
RoomTypeRow row = (RoomTypeRow)dgRoomStatus.Items[dgRoomStatus.SelectedIndex];
cmd.CommandText = @"SELECT *
FROM Phong as PH, LoaiPhong as LP, TrangThaiPhong as TTh
WHERE LP.maLoaiPhong = PH.loaiPHong
AND PH.loaiPhong = '" + row.MaLoaiPhong + "'" +
@"AND TTh.maPhong = PH.maPhong
AND year(TTh.ngay) =" + selectedDate.Year +
"AND month(TTh.ngay) =" + selectedDate.Month +
"AND day(TTh.ngay) =" + selectedDate.Day;
dbQLKS.dbConnection.Open();
SqlDataReader dr = cmd.ExecuteReader();
List <RoomRow> RoomList = new List <RoomRow>();
while (dr.Read())
{
RoomRow r = new RoomRow();
r.LoaiPhong = dr["tenLoaiPhong"].ToString();
r.MaPhong = dr["maPhong"].ToString();
r.SoPhong = dr["soPhong"].ToString();
r.TrangThai = dr["tinhTrang"].ToString();
RoomList.Add(r);
}
dgRoomStatus.ItemsSource = RoomList;
dbQLKS.dbConnection.Close();
// Disable buttons
btnRoomDetail.IsEnabled = true;
btnSearch.IsEnabled = false;
}
}
else
{
MessageBox.Show("Please select a Room Type");
}
}
public RoomTypeRowChangeEvent(RoomTypeRow row, global::System.Data.DataRowAction action)
{
this.eventRow = row;
this.eventAction = action;
}
public void RemoveRoomTypeRow(RoomTypeRow row)
{
this.Rows.Remove(row);
}
public void AddRoomTypeRow(RoomTypeRow row)
{
this.Rows.Add(row);
}
