private void button1_Click(object sender, EventArgs e)
{
ArrayList list = RoomDBManager.GetAllRoom();
ArrayList list1 = BookingDBManager.GetAllBooking();
Room rm = new Room();
rm = RoomDBManager.GetRoomByDate(dtpStartDate.Text);
Book bk = new Book();
bk = BookingDBManager.GetbookingByID(rm.bookingid);
string output = "";
int roomcount = 0;
int occupiedroomcount = 0;
decimal total = 0;
DateTime StartDate = dtpStartDate.Value;
DateTime EndDate = StartDate.AddDays(7);
foreach (Book booking in list1)
{
foreach (Room room in list)
{
char[] dateFmt = booking.check_in_date.ToCharArray();
string fmtYear = dateFmt[4].ToString() + dateFmt[5].ToString() + dateFmt[6].ToString() + dateFmt[7].ToString();
string fmtMonth = dateFmt[2].ToString() + dateFmt[3].ToString();
string fmtDay = dateFmt[0].ToString() + dateFmt[1].ToString();
DateTime dd = new DateTime(Convert.ToInt32(fmtYear), Convert.ToInt32(fmtMonth), Convert.ToInt32(fmtDay));
char[] dateFmt1 = booking.check_out_date.ToCharArray();
string fmtYear1 = dateFmt1[4].ToString() + dateFmt1[5].ToString() + dateFmt1[6].ToString() + dateFmt1[7].ToString();
string fmtMonth1 = dateFmt1[2].ToString() + dateFmt1[3].ToString();
string fmtDay1 = dateFmt1[0].ToString() + dateFmt1[1].ToString();
DateTime dd1 = new DateTime(Convert.ToInt32(fmtYear1), Convert.ToInt32(fmtMonth1), Convert.ToInt32(fmtDay1));
if (StartDate >= dd)
{
roomcount = +booking.no_of_rooms;
}
if (room.status == "Occupied")
{
occupiedroomcount++;
}
total = +(occupiedroomcount / roomcount) * 100;
}
}
output += "Statistics: " + Environment.NewLine;
output += "Percentage of the rooms that are occupied over the total number of rooms: " + total + Environment.NewLine;
rt.overrideHTML(output);
wbOutput.DocumentText = rt.generateHTML(false);
}
private void button1_Click(object sender, EventArgs e)
{
ArrayList list = BookingDBManager.GetAllBooking();
string output = "";
int adultcount = 0;
int childrencount = 0;
int totalcount = 0;
DateTime StartDate = dtpStartDate.Value;
int totalNumberOfGuestInHotel = 0;
int totalNumberOfChild = 0;
int totalNumberOfAdult = 0;
foreach (Book booking in list)
{
char[] dateFmt = booking.check_in_date.ToCharArray();
string fmtYear = dateFmt[4].ToString() + dateFmt[5].ToString() + dateFmt[6].ToString() + dateFmt[7].ToString();
string fmtMonth = dateFmt[2].ToString() + dateFmt[3].ToString();
string fmtDay = dateFmt[0].ToString() + dateFmt[1].ToString();
DateTime dd = new DateTime(Convert.ToInt32(fmtYear), Convert.ToInt32(fmtMonth), Convert.ToInt32(fmtDay));
char[] dateFmt1 = booking.check_out_date.ToCharArray();
string fmtYear1 = dateFmt1[4].ToString() + dateFmt1[5].ToString() + dateFmt1[6].ToString() + dateFmt1[7].ToString();
string fmtMonth1 = dateFmt1[2].ToString() + dateFmt1[3].ToString();
string fmtDay1 = dateFmt1[0].ToString() + dateFmt1[1].ToString();
DateTime dd1 = new DateTime(Convert.ToInt32(fmtYear1), Convert.ToInt32(fmtMonth1), Convert.ToInt32(fmtDay1));
if (StartDate >= dd)
{
adultcount = +booking.no_of_adults;
childrencount = +booking.no_of_children;
totalcount = +booking.no_of_adults + booking.no_of_children;
totalNumberOfGuestInHotel += totalcount;
totalNumberOfChild += childrencount;
totalNumberOfAdult += adultcount;
output += "Guest ID: " + booking.guestid + Environment.NewLine;
output += "Number of adults: " + adultcount + Environment.NewLine;
output += "Number of children: " + childrencount + Environment.NewLine + Environment.NewLine;
}
}
output += "In Summary: " + Environment.NewLine;
output += "Total number of adults in hotel: " + totalNumberOfAdult + Environment.NewLine;
output += "Total number of children in hotel: " + totalNumberOfChild + Environment.NewLine;
output += "Total number of guests in hotel: " + totalNumberOfGuestInHotel + Environment.NewLine;
rt.overrideHTML(output);
wbOutput.DocumentText = rt.generateHTML(false);
}
