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;
}
}
protected void Page_Load(object sender, EventArgs e)
{
int invoiceID = 0;
bool intTest = false;
intTest = int.TryParse(Request.QueryString["id"], out invoiceID);
if (invoiceID == 0)
Response.Redirect("Default.aspx");
litInvoiceNo.Text = invoiceID.ToString();
BusinessHandler businessHandler = new BusinessHandler();
Business business = businessHandler.GetBusinessDetails();
lblCompanyName.Text = business.Name;
lblAddressLine1.Text = business.AddressLine1;
lblAddressLine2.Text = business.AddressLine2;
lblPhoneNo.Text = business.PhoneNo;
lblEmail.Text = business.Email;
lblBankName.Text = business.BankName;
lblBankAccountNo.Text = business.AccountNo;
lblBranchCode.Text = business.BranchCode;
InvoiceHandler invoiceHandler = new InvoiceHandler();
DAL.Invoice invoice = invoiceHandler.GetInvoiceDetails(invoiceID);
int bookingID = 0;
try
{
bookingID = invoice.BookingID;
}
catch (NullReferenceException)
{
Response.Redirect("Default.aspx");
}
BookingHandler bookingHandler = new BookingHandler();
ProvisionalBooking provisionalBooking = bookingHandler.GetProvisionalBookingDetails(bookingID);
lblArriveDate.Text = provisionalBooking.ArriveDate.Year + "-" + provisionalBooking.ArriveDate.Month + "-" + provisionalBooking.ArriveDate.Day;
lblDepartDate.Text = provisionalBooking.DepartDate.Year + "-" + provisionalBooking.DepartDate.Month + "-" + provisionalBooking.DepartDate.Day;
//Get all rooms in booking
double totalPrice = 0;
DateTime startDate = new DateTime();
DateTime endDate = new DateTime();
startDate = provisionalBooking.ArriveDate;
endDate = provisionalBooking.DepartDate;
double noOfDays = (endDate - startDate).TotalDays;
string htmlOutput = "";
string[] rooms = invoice.Rooms.Split(',');
int roomCount = rooms.Count();
RoomAndType roomAndType = null;
AvailabilityHandler availabilityHandler = new AvailabilityHandler();
for (int i = 0; i < roomCount - 1; i++)
{
roomAndType = availabilityHandler.GetAvailableRoomDetails(Convert.ToInt32(rooms[i]));
totalPrice = totalPrice + (roomAndType.Rate * noOfDays);
htmlOutput += "<tr><td>" + roomAndType.RoomNo + "</td><td>" + roomAndType.Name + "</td><td>R " + roomAndType.Rate + "</td><td>R " + (roomAndType.Rate * noOfDays).ToString() + "</td></tr>";
}
//end get all rooms in booking
litSelectedRooms.Text = htmlOutput;
double depositAmount = invoiceHandler.GetDepositAmount(bookingID);
double totalAmount = invoiceHandler.GetTotalAmount(bookingID);
lblDeposit.Text = depositAmount.ToString();
lblTotalAmount.Text = totalAmount.ToString();
}
public void btnAddRoom_Click(object sender, EventArgs e)
{
AvailabilityHandler availabilityHandler = new AvailabilityHandler();
RoomHandler roomHandler = new RoomHandler();
string picturePath = @"\RoomPictures\";
//check if room exists
if (roomHandler.ValidateRoomNo(txtRoomNo.Text) == false)
{
Room room = new Room();
room.RoomNo = txtRoomNo.Text;
room.Description = txtDescription.Text;
room.TypeID = Convert.ToInt32(dlTypeID.SelectedValue);
if (cbWifi.Checked)
room.WifiStatus = "Yes";
else
room.WifiStatus = "No";
if (cbAircon.Checked)
room.AirconStatus = "Yes";
else
room.AirconStatus = "No";
if (cbRoomservice.Checked)
room.RoomserviceStatus = "Yes";
else
room.RoomserviceStatus = "No";
if (cbTelevision.Checked)
room.TelevisionStatus = "Yes";
else
room.TelevisionStatus = "No";
//check if picture is selected
if (fileUploadControl.HasFile)
{
try
{
//only accept .png and .jpg image files
if (fileUploadControl.PostedFile.ContentType == "image/jpeg" || fileUploadControl.PostedFile.ContentType == "image/png")
{
//check file is within maximum size limit
if (fileUploadControl.PostedFile.ContentLength < 3072000)
{
//get file name from the upload control
string filename = Path.GetFileName(fileUploadControl.FileName);
//get the extension name of the file
string extension = filename.Substring(filename.LastIndexOf("."));
//remove the extension from the file name
filename = filename.Substring(0, filename.LastIndexOf("."));
//append room number to the end of the file name
filename += "_" + room.RoomNo;
//combine path, file name and extension. phew
picturePath += filename + extension;
//all checks successfull, upload image and run SQL command
fileUploadControl.SaveAs(Server.MapPath(@"~" + picturePath));
room.Picture = picturePath;
int lastRoomID = 0;
DateTime currentYear = DateTime.Now;
lastRoomID = roomHandler.GetLastRoomID();
if (roomHandler.AddNewRoom(room) == false)
{
//populate availability table
availabilityHandler.AddAvailabilityRecord(lastRoomID, currentYear.Year);
availabilityHandler.AddAvailabilityRecord(lastRoomID, (currentYear.Year + 1));
//alert of success
lblProgress.CssClass = "label label-success";
lblProgress.Text = "Room added successfully";
//delay redirect to alert user of page change
lblRedirect.Text = "Redirecting to room list in 5 seconds.";
Response.Write("<script type=\"text/javascript\">setTimeout(function () { window.location.href = \"RoomList.aspx\"; }, 5000);</script>");
}
}
else
lblProgress.Text = "The picture has to be less than 3 megabytes!";
}
else
lblProgress.Text = "Only JPEG or PNG files are accepted!";
}
catch (Exception)
{
lblProgress.Text = "The picture failed to upload";
}
}
//no picture is selected
else
{
room.Picture = "";
//run SQL insert
if (roomHandler.AddNewRoom(room) == false)
{
//populate availability table
int lastRoomID = 0;
DateTime currentYear = DateTime.Now;
lastRoomID = roomHandler.GetLastRoomID();
availabilityHandler.AddAvailabilityRecord(lastRoomID, currentYear.Year);
availabilityHandler.AddAvailabilityRecord(lastRoomID, (currentYear.Year + 1));
//alert of success
lblProgress.CssClass = "label label-success";
lblProgress.Text = "Room added successfully";
//delay redirect to alert user of page change
lblRedirect.Text = "Redirecting to room list in 5 seconds.";
Response.Write("<script type=\"text/javascript\">setTimeout(function () { window.location.href = \"RoomList.aspx\"; }, 5000);</script>");
}
}
}
else
lblProgress.Text = "This room number already exists!";
}
protected void Page_Load(object sender, EventArgs e)
{
double totalPrice = 0;
string selectedRooms = null;
DateTime startDate = new DateTime();
DateTime endDate = new DateTime();
try
{
selectedRooms = (string)Session["SelectedRooms"];
startDate = (DateTime)Session["StartDate"];
endDate = (DateTime)Session["EndDate"];
}
catch (NullReferenceException)
{
Response.Redirect("Availability.aspx");
}
double noOfDays = (endDate - startDate).TotalDays;
string htmlOutput = "";
string[] rooms = null;
try
{
rooms = selectedRooms.Split(',');
}
catch (NullReferenceException)
{
Response.Redirect("Availability.aspx");
}
int roomCount = rooms.Count();
RoomAndType roomAndType = null;
AvailabilityHandler availabilityHandler = new AvailabilityHandler();
for (int i = 0; i < roomCount -1; i++)
{
roomAndType = availabilityHandler.GetAvailableRoomDetails(Convert.ToInt32(rooms[i]));
totalPrice = totalPrice + (roomAndType.Rate * noOfDays);
htmlOutput += "<tr><td>" + roomAndType.RoomNo + "</td><td>" + roomAndType.Name + "</td><td>" + roomAndType.MaxCapacity + "</td><td>R " + roomAndType.Rate + "</td><td>R " + (roomAndType.Rate * noOfDays).ToString() +"</td></tr>";
}
litAvailableRooms.Text = htmlOutput;
BusinessHandler businessHandler = new BusinessHandler();
Business business = businessHandler.GetBusinessDetails();
double depositPercent = business.DepositPercent;
depositPercent = depositPercent / 100;
lblDeposit.Text = (totalPrice * depositPercent).ToString();
lblTotalCost.Text = totalPrice.ToString();
litDates.Text = startDate.Year + "-" + startDate.Month + "-" + startDate.Day + " to " + endDate.Year + "-" + endDate.Month + "-" + endDate.Day;
}
