protected void ddlRoomType_SelectedIndexChanged(object sender, EventArgs e) { if (ddlRoomType.SelectedValue != "NA") { ddlRoomType.Items[0].Text = "Show All Rooms"; //This selected index changed event will load rooms selected only from a specific room type DateTime startDate = new DateTime(); DateTime endDate = new DateTime(); try { startDate = (DateTime)Session["StartDate"]; endDate = (DateTime)Session["EndDate"]; } catch (NullReferenceException) { Response.Redirect("Availability.aspx"); } litHeader.Text = "<h3>Rooms available between " + startDate.Year + "-" + startDate.Month + "-" + startDate.Day + " and " + endDate.Year + "-" + endDate.Month + "-" + endDate.Day + "</h3>"; int roomID = 0; string htmlOutput = ""; string picture = ""; int typeID; typeID = Convert.ToInt32(ddlRoomType.SelectedValue); AvailabilityHandler availabilityHandler = new AvailabilityHandler(); List<RoomAndType> listRoomAvailability = availabilityHandler.GetListOfSpecificRooms(typeID); //Check to make sure there is rooms in the system if (listRoomAvailability == null) litHeader.Text = "<h3 style=\"color:red\">There are currently no rooms available in the category you selected</h3>"; else { for (int i = 0; i < listRoomAvailability.Count; i++) { roomID = listRoomAvailability[i].RoomID; if (listRoomAvailability[i].Picture != null && listRoomAvailability[i].Picture != "") picture = "<a href=\"" + "." + listRoomAvailability[i].Picture.Replace('\\', '/') + "\" data-lightbox=\"image" + i.ToString() + "\">View Picture</a>"; else picture = "No Picture Available"; if (availabilityHandler.CheckAvailability(roomID, startDate, endDate) == true) htmlOutput += "<tr><td>" + listRoomAvailability[i].RoomNo.ToString() + "</td><td>" + listRoomAvailability[i].Name + "</td><td>" + picture + "</td><td>" + listRoomAvailability[i].MaxCapacity.ToString() + "</td><td>R " + listRoomAvailability[i].Rate.ToString() + "</td><td><input type=\"button\" value=\"View\" onclick=\"window.open('RoomDetails.aspx?id=" + listRoomAvailability[i].RoomID + "', 'name', 'height=270,width=270')\" /></td><td><input type=\"checkbox\" onclick=\"AddRoomToBooking(" + listRoomAvailability[i].RoomID + ")\" />" + "</td></tr>\n"; } litAvailableRooms.Text = htmlOutput; } }//End of if statement }
protected void Page_Load(object sender, EventArgs e) { //Populate room type drop down list if (!IsPostBack) { RoomTypeHandler roomTypeHandler = new RoomTypeHandler(); List<RoomType> listRoomTypes = roomTypeHandler.GetRoomTypeList(); ddlRoomType.DataSource = listRoomTypes; ddlRoomType.DataValueField = "TypeID"; ddlRoomType.DataTextField = "Name"; ddlRoomType.DataBind(); ddlRoomType.Items.Insert(0, new ListItem("Select Room Type", "NA")); } DateTime startDate = new DateTime(); DateTime endDate = new DateTime(); try { startDate = (DateTime)Session["StartDate"]; endDate = (DateTime)Session["EndDate"]; } catch (NullReferenceException) { Response.Redirect("Availability.aspx"); } litHeader.Text = "<h3>Rooms available between " + startDate.Year + "-" + startDate.Month + "-" + startDate.Day + " and " + endDate.Year + "-" + endDate.Month + "-" + endDate.Day + "</h3>"; int roomID = 0; string htmlOutput = ""; string picture = ""; AvailabilityHandler availabilityHandler = new AvailabilityHandler(); List<RoomAndType> listRoomAvailability = availabilityHandler.GetListOfAllRooms(); //Check to make sure there is rooms in the system if (listRoomAvailability == null) litHeader.Text = "<h3>There are currently no rooms added to the system</h3>"; else { for (int i = 0; i < listRoomAvailability.Count; i++) { roomID = listRoomAvailability[i].RoomID; if (listRoomAvailability[i].Picture != null && listRoomAvailability[i].Picture != "") picture = "<a href=\"" + "." + listRoomAvailability[i].Picture.Replace('\\', '/') + "\" data-lightbox=\"image" + i.ToString() + "\">View Picture</a>"; else picture = "No Picture Available"; if (availabilityHandler.CheckAvailability(roomID, startDate, endDate) == true) htmlOutput += "<tr><td>" + listRoomAvailability[i].RoomNo.ToString() + "</td><td>" + listRoomAvailability[i].Name + "</td><td>" + picture + "</td><td>" + listRoomAvailability[i].MaxCapacity.ToString() + "</td><td>R " + listRoomAvailability[i].Rate.ToString() + "</td><td><input type=\"button\" value=\"View\" onclick=\"window.open('RoomDetails.aspx?id=" + listRoomAvailability[i].RoomID + "', 'name', 'height=270,width=270')\" /></td><td><input type=\"checkbox\" onclick=\"AddRoomToBooking(" + listRoomAvailability[i].RoomID + ")\" />" + "</td></tr>\n"; } litAvailableRooms.Text = htmlOutput; } }