protected void btnEventSearchByActivity_Click(object sender, EventArgs e) { EventServiceRef.Activity activities = new EventServiceRef.Activity(); activities.type = ddlEventType.SelectedValue; activities.time = ddlEventTime.SelectedValue; activities.day = ddlEventDay.SelectedValue; EventServiceRef.EventService pxy = new EventServiceRef.EventService(); DataSet myDS = pxy.FindEvents(activities, txtEventCity.Text, ddlEventState.SelectedValue); rptEvents.DataSource = myDS; rptEvents.DataBind(); divEventForm.Visible = false; divEventResults.Visible = true; }
protected void btnEventSearchByAgency_Click(object sender, EventArgs e) { EventServiceRef.EventService eventService = new EventServiceRef.EventService(); DataSet agencies = eventService.GetEventAgencies(txtEventCity.Text, ddlEventState.SelectedValue); EventServiceRef.Agency agency = new EventServiceRef.Agency(); agency.ID = (int)agencies.Tables[0].Rows[ddlEventAgencies.SelectedIndex]["agencyID"]; agency.name = ddlEventAgencies.SelectedValue; agency.phone = (string)agencies.Tables[0].Rows[ddlEventAgencies.SelectedIndex]["agencyPhone"]; agency.email = (string)agencies.Tables[0].Rows[ddlEventAgencies.SelectedIndex]["agencyEmail"]; agency.city = (string)agencies.Tables[0].Rows[ddlEventAgencies.SelectedIndex]["agencyCity"]; agency.state = (string)agencies.Tables[0].Rows[ddlEventAgencies.SelectedIndex]["agencyState"]; DataSet myDS = eventService.GetEvents(agency, txtEventCity.Text, ddlEventState.SelectedValue); rptEvents.DataSource = myDS; rptEvents.DataBind(); divEventForm.Visible = false; divEventResults.Visible = true; }
protected void btnEventSelectCity_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(txtEventCity.Text)) { Page.ClientScript.RegisterClientScriptBlock(GetType(), "Alert", "alert('Please enter a valid city.')", true); return; } if (ddlEventState.SelectedValue == "Select state") { Page.ClientScript.RegisterClientScriptBlock(GetType(), "Alert", "alert('Please select a state.')", true); return; } EventServiceRef.EventService eventService = new EventServiceRef.EventService(); DataSet agencies = eventService.GetEventAgencies(txtEventCity.Text, ddlEventState.SelectedValue); ddlEventAgencies.DataSource = agencies; ddlEventAgencies.DataTextField = "agencyName"; ddlEventAgencies.DataValueField = "agencyName"; ddlEventAgencies.DataBind(); divEventDetails.Visible = true; }
protected void btnCheckout_Click(object sender, EventArgs e) { if (Session["VacationPackage"] != null) { VacationPackage vacation = (VacationPackage)Session["VacationPackage"]; SqlCommand objCommand = new SqlCommand(); objCommand.CommandType = CommandType.StoredProcedure; objCommand.CommandText = "GetUser"; objCommand.Parameters.AddWithValue("@email", Session["UserName"]); DBConnect objDB = new DBConnect(); DataSet myDS = objDB.GetDataSetUsingCmdObj(objCommand); DataRow user = myDS.Tables[0].Rows[0]; CarServiceRef.Customer carCustomer = new CarServiceRef.Customer(); carCustomer.customerID = (int)user["UserID"]; carCustomer.firstName = (string)user["firstName"]; carCustomer.lastName = (string)user["lastName"]; carCustomer.email = (string)user["email"]; carCustomer.address = ""; carCustomer.age = 0; carCustomer.phoneNumber = ""; EventServiceRef.Customer eventCustomer = new EventServiceRef.Customer(); eventCustomer.ID = (int)user["UserID"]; eventCustomer.CustomerFirstName = (string)user["firstName"]; eventCustomer.CustomerLastName = (string)user["lastName"]; eventCustomer.CustomerEmail = (string)user["email"]; eventCustomer.CustomerPhone = ""; HotelServiceRef.Customer hotelCustomer = new HotelServiceRef.Customer(); hotelCustomer.CustID = (int)user["UserID"]; hotelCustomer.FirstName = (string)user["firstName"]; hotelCustomer.LastName = (string)user["lastName"]; hotelCustomer.Address = (string)user["email"]; CarServiceRef.CarService carService = new CarServiceRef.CarService(); EventServiceRef.EventService eventService = new EventServiceRef.EventService(); HotelServiceRef.HotelService hotelService = new HotelServiceRef.HotelService(); AirServiceRef.AirService airService = new AirServiceRef.AirService(); string emailBody = "<h1>You have reserved</h1>"; emailBody += "<h2>Cars</h2>"; bool reservedCars = true; for (int i = 0; i < vacation.cars.Count; i++) { CarServiceRef.Car currCar = vacation.cars[i]; if (!carService.Reserve(carCustomer, currCar)) { reservedCars = false; } else { emailBody += "<p>" + currCar.year + " " + currCar.make + " " + currCar.model + " ($" + currCar.price + ")</p>"; } } emailBody += "<h2>Events</h2>"; bool reservedEvents = true; for (int i = 0; i < vacation.events.Count; i++) { EventServiceRef.Event currEvent = vacation.events[i]; if (!eventService.Reserve(currEvent, eventCustomer)) { reservedEvents = false; } else { emailBody += "<p>" + currEvent.Name + " ($" + currEvent.Price + ")</p>"; } } emailBody += "<h2>Hotels</h2>"; bool reservedHotels = true; for (int i = 0; i < vacation.rooms.Count; i++) { HotelServiceRef.Room currRoom = vacation.rooms[i]; if (!hotelService.Reserve(currRoom, hotelCustomer)) { reservedHotels = false; } else { emailBody += "<p>" + currRoom.RoomNumber + " ($" + currRoom.Price + ")</p>"; } } emailBody += "<h2>Flights</h2>"; bool reservedFlights = true; for (int i = 0; i < vacation.flights.Count; i++) { Flight currFlight = vacation.flights[i]; emailBody += "<p>" + currFlight.carrierName + " ($" + currFlight.price + ") could not be reserved because the AirService does not accept reservations</p>"; } emailBody += "<br><br><p>Thank you,<br>Vacation-O-City Team</p>"; if (reservedCars) { vacation.cars.Clear(); vacation.carsQuantity.Clear(); } if (reservedEvents) { vacation.events.Clear(); vacation.eventsQuantity.Clear(); } if (reservedHotels) { vacation.events.Clear(); vacation.roomsQuantity.Clear(); } if (reservedFlights) { vacation.flights.Clear(); vacation.flightsQuantity.Clear(); } Email emailSender = new Email(); emailSender.SendMail((string)Session["UserName"], "*****@*****.**", "Reservation Confirmation", emailBody, "*****@*****.**"); clearCartCount(); Session["VacationPackage"] = vacation; vacation = (VacationPackage)Session["VacationPackage"]; Serialize objSerialize = new Serialize(); objSerialize.WriteCartToDB(vacation, Session["UserName"]); } displayCart(); }