private void loadDatasource()
{
DateTime dDate = DateTime.Now;
if (dDate.Hour < 12)
{
dDate.AddDays(-1);
}
this.checkInsTableAdapter.FillCheckIng(this.apartmentDataSet.CheckIns);
this.customerTypesTableAdapter.Fill(this.apartmentDataSet.CustomerTypes);
RoomsTableAdapter roomsTableAdapter = new RoomsTableAdapter();
int roomCount = Convert.ToInt32(roomsTableAdapter.GetRoomCount());
int roomUserCount = Convert.ToInt32(checkInsTableAdapter.GetCheckInRoomCount(dDate));
int roomType1 = Convert.ToInt32(checkInsTableAdapter.GetCkeckInRoomTypeCount(1, dDate));
int roomType2 = Convert.ToInt32(checkInsTableAdapter.GetCkeckInRoomTypeCount(2, dDate));
lblTotalRoom.Text = roomCount + "";
lblUseRoom.Text = roomUserCount + "";
lblRoomEmtry.Text = roomCount - roomUserCount + "";
lblUse1.Text = roomType1 + "";
lblUse2.Text = roomType2 + "";
}
