Beispiel #1
0
        protected void Page_Load(object sender, EventArgs e)
        {
            string paymentConfirmation = "received";
            int    n = Convert.ToInt32(Session["numberOfAdults"]) + Convert.ToInt32(Session["numberOfChildren"]);

            if (paymentConfirmation.Equals("received"))
            {
                BookFlightDLL book = new BookFlightDLL();
                book.ConfirmBooking(Session["referenceId"].ToString(), "Confirm", "Success",
                                    Session["selectedFlightId"].ToString(), Session["dateOfJourney"].ToString(),
                                    Session["travelClass"].ToString(), n);

                if (Session["tripType"].ToString().Equals("Round Trip"))
                {
                    BookFlightDLL bookRoundTrip = new BookFlightDLL();
                    book.ConfirmBooking(Session["referenceIdRoundTrip"].ToString(), "Confirm", "Success",
                                        Session["selectedFlightIdRoundTrip"].ToString(), Session["dateOfReturn"].ToString(),
                                        Session["travelClass"].ToString(), n);
                }
            }
            else
            {
                BookFlightDLL book = new BookFlightDLL();
                book.ConfirmBooking(Session["referenceId"].ToString(), "Failed", "Failed",
                                    Session["selectedFlightId"].ToString(), Session["dateOfJourney"].ToString(),
                                    Session["travelClass"].ToString(), n);

                if (Session["tripType"].ToString().Equals("Round Trip"))
                {
                    BookFlightDLL bookRoundTrip = new BookFlightDLL();
                    book.ConfirmBooking(Session["referenceIdRoundTrip"].ToString(), "Failed", "Failed",
                                        Session["selectedFlightIdRoundTrip"].ToString(), Session["dateOfReturn"].ToString(),
                                        Session["travelClass"].ToString(), n);
                }
            }

            Response.Redirect("ViewBookedTicket.aspx");
        }
        protected void btnProceedToPay_Click(object sender, EventArgs e)
        {
            string allTextBoxValues  = "";
            string allDropDownValues = "";

            foreach (Control c in phRecords.Controls)
            {
                if (c is TextBox)
                {
                    allTextBoxValues += ((TextBox)c).Text + ",";
                }
                if (c is DropDownList)
                {
                    allDropDownValues += ((DropDownList)c).SelectedItem.Text + ",";
                }
            }


            string[] allPassengersNameAndAge = allTextBoxValues.Split(',');
            string[] allPassengersGender     = allDropDownValues.Split(',');
            int      n = Convert.ToInt32(Session["numberOfAdults"]) + Convert.ToInt32(Session["numberOfChildren"]) + Convert.ToInt32(Session["numberOfInfants"]);

            string[] PassengerName   = new string[n];
            string[] PassengerAge    = new string[n];
            string[] PassengerGender = new string[n];
            int      count1          = 0;
            int      count2          = 0;

            for (int i = 0; i < allPassengersNameAndAge.Length - 1; i++)
            {
                if (i % 2 == 0)
                {
                    PassengerName[count1] = allPassengersNameAndAge[i];
                    count1 = count1++;
                }
                else
                {
                    PassengerAge[count2] = allPassengersNameAndAge[i];
                    count2 = count2++;
                }
            }

            for (int i = 0; i < allPassengersGender.Length - 1; i++)
            {
                PassengerGender[i] = allPassengersGender[i];
            }


            //Session["PassengerName"] = PassengerName;
            //Session["PassengerAge"] = PassengerAge;
            //Session["PassengerGender"] = PassengerGender;

            string referenceId = DateTime.Now.ToString();

            referenceId            = "O" + referenceId + "101";
            Session["referenceId"] = referenceId;


            BookFlightDLL book = new BookFlightDLL();



            int rowsAffected = book.updateBookedTicketBeforePayment
                               (
                Session["selectedFlightId"].ToString(),
                Session["travelClass"].ToString(),
                Session["dateOfJourney"].ToString(),
                DateTime.Now.ToString("yyyy-MM-dd"),
                Convert.ToInt32(Session["numberOfAdults"]),
                Convert.ToInt32(Session["numberOfChildren"]),
                Session["Fare"].ToString(),
                "101",
                referenceId,
                "Pending",
                "Pending",
                Convert.ToInt32(Session["AdultPrice"]),
                Convert.ToInt32(Session["ChildPrice"]));

            for (int i = 0; i < PassengerName.Length; i++)
            {
                rowsAffected = book.updatePassengersBeforePayment(i + 1, referenceId, PassengerName[i],
                                                                  Convert.ToInt32(PassengerAge[i]),
                                                                  Convert.ToChar(PassengerGender[i]),
                                                                  "Pending");
            }


            if (Session["tripType"].ToString().Equals("Round Trip"))
            {
                string referenceIdRoundTrip = DateTime.Now.ToString();
                referenceIdRoundTrip            = "R" + referenceId + (Session["user"].ToString());
                Session["referenceIdRoundTrip"] = referenceId;


                BookFlightDLL bookRoundTrip = new BookFlightDLL();



                rowsAffected = bookRoundTrip.updateBookedTicketBeforePayment
                               (
                    Session["selectedFlightIdRoundTrip"].ToString(),
                    Session["travelClass"].ToString(),
                    Session["dateOfReturn"].ToString(),
                    DateTime.Now.ToString("yyyy-MM-dd"),
                    Convert.ToInt32(Session["numberOfAdults"]),
                    Convert.ToInt32(Session["numberOfChildren"]),
                    Session["Fare"].ToString(),
                    "101",
                    referenceId,
                    "Pending",
                    "Pending",
                    Convert.ToInt32(Session["AdultPriceRoundTrip"]),
                    Convert.ToInt32(Session["ChildPriceRoundTrip"]));

                for (int i = 0; i < PassengerName.Length; i++)
                {
                    rowsAffected = book.updatePassengersBeforePayment(i + 1, referenceIdRoundTrip, PassengerName[i],
                                                                      Convert.ToInt32(PassengerAge[i]),
                                                                      Convert.ToChar(PassengerGender[i]),
                                                                      "Pending");
                }
            }

            Response.Redirect("Payment.aspx");
        }