protected void btnSave_Click(object sender, EventArgs e)
        {
            BookingHandler bookingHandler = new BookingHandler();
            Booking booking = new Booking();

            int bookingID = 0;
            string picturePath = @"\ProofOfPayment\";

            try
            {
                //bookingID = Convert.ToInt32(Request.QueryString["id"]);
                bookingID = 1;
            }
            catch (NullReferenceException)
            {
                Response.Redirect("Default.aspx");
            }

            //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("."));

                            //give file a unique name using bookingID
                            filename = "booking_" + bookingID.ToString();

                            //combine path, file name and extension. phew
                            picturePath += filename + extension;

                            //all checks successfull, upload image and run SQL command
                            fileUploadControl.SaveAs(Server.MapPath(@"~" + picturePath));

                            booking.BookingID = bookingID;
                            booking.ProofOfPayment = picturePath;

                            if (bookingHandler.UpdateProofOfPayment(booking) == false)
                            {

                                //alert of success
                                lblProgress.CssClass = "label label-success";
                                lblProgress.Text = "Room added successfully";

                            }
                        }
                        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";
                }
            }
        }
        public void btnSave_Click(object sender, EventArgs e)
        {
            BookingHandler bookingHandler = new BookingHandler();
            Booking booking = new Booking();

            int bookingID = 0;
            string picturePath = @"/ProofOfPayment/";

            try
            {
                bookingID = Convert.ToInt32(Request.QueryString["id"]);
            }
            catch (NullReferenceException)
            {
                Response.Redirect("Default.aspx");
            }

            //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" || fileUploadControl.PostedFile.ContentType == "application/pdf")
                    {
                            //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("."));

                            //give file a unique name using bookingID
                            filename = "booking_" + bookingID.ToString();

                            //combine path, file name and extension. phew
                            picturePath += filename + extension;

                            //all checks successfull, upload image and run SQL command
                            fileUploadControl.SaveAs(Server.MapPath(@"~" + picturePath));

                            booking.BookingID = bookingID;
                            booking.ProofOfPayment = picturePath;

                            int memberID = (int)Session["MemberID"];
                            if (bookingHandler.UpdateProofOfPayment(booking) == false)
                            {

                                //alert of success
                                lblProgress.CssClass = "label label-success";
                                lblProgress.Text = "Proof of Payment added successfully";

                                //delay redirect to alert user of page change
                                lblRedirect.Text = "Redirecting to booking history in 5 seconds.";
                                Response.Write("<script type=\"text/javascript\">setTimeout(function () { window.location.href = \"BookingHistory.aspx?id=" + memberID.ToString() +"\"; }, 5000);</script>");
                            }

                        else
                            lblProgress.Text = "The file has to be less than 3 megabytes!";

                    }
                    else
                        lblProgress.Text = "Only JPEG, PNG or PDF files are accepted!";

                }
                catch (Exception)
                {
                    lblProgress.Text = "The file failed to upload.";
                }
            }
        }