bool verification = true; //declare the bool verification, to check if the item is true protected void Page_Load(object sender, EventArgs e) { //check the session country name is null if (Session["countryName"] == null) { Response.Redirect("AHRPage.aspx"); //brings back to the AHR page } else { if (!IsPostBack) { lblNoAttraction.Visible = false; List <Attraction> attractions = AttractionDB.getAttractionByCountry(Session["countryName"].ToString(), verification); //get the attraction list and the item must be approved by an admin -- the verification must be true to show into public website if (attractions.Count != 0) //check whether the attraction is not null { //show the attraction list lvAttraction.DataSource = attractions; lvAttraction.DataBind(); lblCountry.Text = Session["countryName"].ToString(); //show country name in the label Session["attraction"] = attractions; //brings the session for attraction } else { lblNoAttraction.Visible = true; //when there is no attraction, show the error message } } } }
protected void btnARegister_Click(object sender, EventArgs e) { string imagefile = "notavailable.jpg"; if (FileUpload2.HasFile) //checking whether the file upload has the file { imagefile = FileUpload2.FileName; FileUpload2.SaveAs(Server.MapPath("~/images/" + imagefile));//store the file in the images folder } //attraction Attraction a = new Attraction() { OrgEmail = tbxAEmail.Text, Name = tbxAName.Text, RegID = tbxARegID.Text, Address = tbxAddressA.Text, PostalCode = tbxAPostalCode.Text, City = tbxACity.Text, Country = tbxACountry.Text, Password = tbxAPassword.Text, ContactNo = tbxAPhone.Text, Description = "Not Applicable", StarRating = Convert.ToInt32(5), OpeningHours = tbxAHour.Text, Photo = imagefile, Verification = false }; int id = AttractionDB.insertAttraction(a); lblOutput.Text = id + "Registered Successfully!"; }
protected void Page_Load(object sender, EventArgs e) { //if the sessiom is null if (Session["attraction"] == null) { Response.Redirect("AttractionPage.aspx"); //brings back to the attraction page } else { //create a new list for attraction List <Attraction> attList = new List <Attraction>(); //retrieve the attraction id from the session and use it to get a attraction from the database Attraction att = AttractionDB.getAttractionByID(Session["attraction"].ToString()); attList.Add(att); //add a vehicle to attraction list lvAttraction.DataSource = attList; //add the attraction list to a list view data source lvAttraction.DataBind(); //bind the data into listview //get all feedbacks of a vehicle List <Review> rvList = ReviewDB.getAllAttractionReviewByID(Convert.ToInt32(Session["attraction"])); attReviews.DataSource = rvList; attReviews.DataBind(); if (rvList.Count == 0) //checking whether there is no feedback available for attraction { lblOutput.Text = "No feedback available for this attraction"; //show the message } } }
private void getAllAttraction() { //list the gridview from database List <Attraction> attractions = AttractionDB.getAllAttraction(); gvAttraction.DataSource = attractions; gvAttraction.DataBind(); }
protected void gvAttraction_SelectedIndexChanged(object sender, EventArgs e) { List <Attraction> attractions = AttractionDB.getAllAttraction(); Attraction a = attractions[gvAttraction.SelectedIndex]; Session["emailA"] = a; Session["attraction"] = a.Name; Session["countryName"] = a.Country; Response.Redirect("AAdetails.aspx"); }
protected void btnSearch_Click(object sender, EventArgs e) { string userinput = tbxInput.Text; using (WebClient wc = new WebClient()) { var json = wc.DownloadString("https://maps.googleapis.com/maps/api/place/textsearch/json?query=" + tbxInput.Text + "&key=AIzaSyA-Brzltyb6U-xbPlQyCUM2n4F_c130xl0"); //tbxOutput.Text = json; JObject jt = JObject.Parse(json); JToken c = jt.GetValue("results"); String output = ""; foreach (var result in c) { output += result.Value <string>("formatted_address").ToString() + Environment.NewLine; output += result.Value <string>("name").ToString() + Environment.NewLine; output += result.Value <int>("rating") + Environment.NewLine; Attraction a = new Attraction() { OrgEmail = "", Name = result.Value <string>("name").ToString(), RegID = "", Address = result.Value <string>("formatted_address").ToString(), PostalCode = "", City = "", Country = "", Password = "******", ContactNo = "", Description = "Not Applicable", StarRating = Convert.ToInt32(5), OpeningHours = "", Photo = "", Verification = true }; int id = AttractionDB.insertAttraction(a); lblOutput.Text = id + "Registered Successfully!"; } tbxOutput.Text = output; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { GetWeatherInfo(); //get the weather informatio } bool verification = true; //initialize the verification is true if (Session["countryName"] != null) //if the session for countryName is not null { //show the top 4 of attraction into gridview List <Attraction> attractions = AttractionDB.getTOP4AttractionByCountry(Session["countryName"].ToString(), verification); dlAttraction.DataSource = attractions; dlAttraction.DataBind(); } else { Response.Redirect("AHRPage.aspx"); } //show the top 4 of hotel into gridview List <Hotel> hotels = HotelDB.getTOP4HotelByCountry(Session["countryName"].ToString(), verification); dlHotel.DataSource = hotels; dlHotel.DataBind(); //show the top 4 of restaurant into gridview List <Restaurant> restaurants = RestaurantDB.getTOP4RestaurantByCountry(Session["countryName"].ToString(), verification); dlRestaurant.DataSource = restaurants; dlRestaurant.DataBind(); //if the session of countryName is not null if (Session["countryName"] != null) { //show the country name in label lblCountry.Text = Session["countryName"].ToString(); } }
protected void btnLogin_Click(object sender, EventArgs e) { //get admin from database Admin d = AdminDB.getAdminbyID(tbxEmail.Text, tbxPassword.Text); if (d != null) //if admin is not null { if (d.AdminID == tbxEmail.Text) //check the admin id from database, matched or not { if (d.Password == tbxPassword.Text) //check the admin password from database, matched or not { //create a session for admin Session["admin"] = d; //redirect to AdminView page Server.Transfer("AdminView.aspx"); } } } else { lblOutput.Text = "sorry admin cannot login!"; //to show error message } if (ddlCustOrg.SelectedItem.Text == "Customer") //user selected on customer { Customer c = CustomerDB.getCustomerByEmail(tbxEmail.Text, tbxPassword.Text); //get the customer details from database if (c != null) //if customer is not null { //customer email and password must matched from the databse if (c.CustEmail == tbxEmail.Text) { if (c.Password == tbxPassword.Text) { //create session for user Session["user"] = c; Session["emailUser"] = c.CustEmail; //redirect to the default page Server.Transfer("Default.aspx"); } else { lblOutput.Text = "Incorrect password"; //show error message } } } else { lblOutput.Text = "Incorrect email/password"; //show error message } } else if (ddlCustOrg.SelectedItem.Text == "Hotel Owner") //user selected on hotel owner { Hotel h = HotelDB.getHotelByEmail(tbxEmail.Text, tbxPassword.Text); //get the data from database //check the data is not null if (h != null) { //email and password must matched into the database if (h.OrgEmail == tbxEmail.Text) { if (h.Password == tbxPassword.Text) { //create session for user Session["userHotel"] = h; Session["hotelEmail"] = h.OrgEmail; Session["hotelID"] = h.HotelID; //redirect to the default page Server.Transfer("Default.aspx"); } else { lblOutput.Text = "Incorrect password"; //show error message } } } else { lblOutput.Text = "Incorrect email/password"; //show error message } } else if (ddlCustOrg.SelectedItem.Text == "Restaurant Owner") //user selected on the restaurant owner { //get the data from database Restaurant r = RestaurantDB.getRestaurantByEmail(tbxEmail.Text, tbxPassword.Text); //check the data is not null if (r != null) { //email and password must matched into database if (r.OrgEmail == tbxEmail.Text) { if (r.Password == tbxPassword.Text) { //create session for user Session["userRestaurant"] = r; Session["restaurantEmail"] = r.OrgEmail; Session["restaurantID"] = r.RestaurantID; //redirect to the default page Server.Transfer("Default.aspx"); } else { lblOutput.Text = "Incorrect password"; //show error message } } } else { lblOutput.Text = "Incorrect email/password"; //show error message } } else if (ddlCustOrg.SelectedItem.Text == "Attraction Owner") //user selected on the attraction owner { //get the data from database Attraction a = AttractionDB.getAttractionByEmail(tbxEmail.Text, tbxPassword.Text); //check the data if not null if (a != null) { //email and password must matched into our database if (a.OrgEmail == tbxEmail.Text) { if (a.Password == tbxPassword.Text) { //create session for user Session["userAttraction"] = a; Session["attractionEmail"] = a.OrgEmail; Session["attractionID"] = a.AttractionID; //redirect to the default page Server.Transfer("Default.aspx"); } else { lblOutput.Text = "Incorrect password"; //show error message } } } else { lblOutput.Text = "Incorrect email/password"; //show error message } } }
protected void btnSubmit_Click(object sender, EventArgs e) { //initialize the random number generator Random r = new Random(); //set the new password from random number generator int newPw = r.Next(1, 100000); int result = 0; //initialze the result bool found = true; //initialize the boolean is true if (ddlCustOrg.SelectedItem.Text == "Customer") //when user choose to reset password for customer { //get the customer from database Customer c = CustomerDB.getACustomerByEmail(tbxEmail.Text); if (c != null) //if the customer is not null { c.Password = newPw.ToString(); //set the new password result = CustomerDB.updateCustomer(c); //update into customer database } else { found = false; //cannot find the customer from the database } } else if (ddlCustOrg.SelectedItem.Text == "Hotel Owner") //when user choose to reset password for hotel owner { Hotel h = HotelDB.getAHotelByEmail(tbxEmail.Text); //get the hotel owner from database if (h != null) //if the hotel is not null { h.Password = newPw.ToString(); //set the new password result = HotelDB.updateHotel(h); //update into hotel database } else { found = false; //cannot find the hotel owner from the database } } else if (ddlCustOrg.SelectedItem.Text == "Attraction Owner") //when user choose to reset password for attraction { Attraction a = AttractionDB.getAAttractionByEmail(tbxEmail.Text); //get the attraction owner from database if (a != null) //if the attraction is not null { //set the new password a.Password = newPw.ToString(); //update into attraction database result = AttractionDB.updateAttraction(a); } else { found = false; //canoot find the attraction from the database } } else if (ddlCustOrg.SelectedItem.Text == "Restaurant Owner") //when user choose to reset password for restaurant owner { Restaurant ra = RestaurantDB.getARestaurantByEmail(tbxEmail.Text); //get the restaurant owner from database if (ra != null) //if the restaurant is not null { //set the new password ra.Password = newPw.ToString(); //update into restaurant database result = RestaurantDB.updateRestaurant(ra); } else { found = false; //cannot find the restaurant from the database } } if (found) //if found { if (result > 0) //result cannot be zero { try //use try and catch to send an email to the organization and customer { SmtpClient client = new SmtpClient("smtp.gmail.com"); client.EnableSsl = true; client.Credentials = new NetworkCredential("*****@*****.**", "smart-travel1005"); MailMessage msg = new MailMessage("*****@*****.**", tbxEmail.Text); msg.Subject = "New Password"; msg.Body = "Your new password is: " + newPw.ToString() + "\r\n Please change your password again"; client.Send(msg); //send an email lblOutput.Text = "New Password has been sent to your email"; return; } catch (Exception ex) { lblOutput.Text = "Active internet connection needed!"; //show error message when user do not have internet connection return; } } else { lblOutput.Text = "Fails to update the password"; //show error message when user cannot update the password return; } } lblOutput.Text = "Account with this email address does not exist. Sign up for the account"; //if the account is not exist with our website }
protected void btnUpdate_Click(object sender, EventArgs e) { if (Session["user"] != null) { //calling member class to the session of user Customer c = (Customer)Session["user"]; c.Name = tbxName.Text; c.Gender = tbxGender.Text; c.DateOfBirth = Convert.ToDateTime(tbxDOB.Text); c.Address = tbxAddress.Text; c.PostalCode = tbxPostalCode.Text; c.PersonalID = tbxPID.Text; c.Nationality = tbxNationality.Text; c.PhoneNumber = Convert.ToInt32(tbxPhone.Text); c.CustEmail = tbxEmail.Text; c.Password = tbxPassword.Text; Session["user"] = c; int row = CustomerDB.updateCustomer(c); //display an output lblOutput.Text = "Update successfully!"; databindedCust(); } else if (Session["userAttraction"] != null) { Attraction a = (Attraction)Session["userAttraction"]; a.Name = tbxCName.Text; a.RegID = tbxRID.Text; a.Address = tbxCAddress.Text; a.PostalCode = tbxCPostalCode.Text; a.City = tbxCCity.Text; a.Country = tbxCCountry.Text; a.Password = tbxCpass.Text; a.ContactNo = tbxCPhone.Text; a.OrgEmail = tbxCEmail.Text; a.Password = tbxCPassword.Text; a.Description = tbxDesc.Text; a.OpeningHours = tbxOHour.Text; string imagefile = "notavailable"; if (FileUpload1.HasFile) { imagefile = FileUpload1.FileName; FileUpload1.SaveAs(Server.MapPath("../images/" + imagefile)); a.Photo = FileUpload1.FileName; imgProfile.ImageUrl = "../images/" + a.Photo; } Session["userAttraction"] = a; lblOutput.Text = "Update successfully!"; int row = AttractionDB.updateAttraction(a); databindedOrg(); } else if (Session["userRestaurant"] != null) { Restaurant r = (Restaurant)Session["userRestaurant"]; r.Name = tbxCName.Text; r.RegID = tbxRID.Text; r.Address = tbxCAddress.Text; r.PostalCode = tbxCPostalCode.Text; r.City = tbxCCity.Text; r.Country = tbxCCountry.Text; r.Password = tbxCpass.Text; r.ContactNo = tbxCPhone.Text; r.OrgEmail = tbxCEmail.Text; r.Password = tbxCPassword.Text; r.Description = tbxDesc.Text; r.OpeningHours = tbxOHour.Text; string imagefile = "notavailable"; if (FileUpload1.HasFile) { imagefile = FileUpload1.FileName; FileUpload1.SaveAs(Server.MapPath("../images/" + imagefile)); r.Photo = FileUpload1.FileName; imgProfile.ImageUrl = "../images/" + r.Photo; } r.License = tbxLicenseNo.Text; Session["userRestaurant"] = r; lblOutput.Text = "Update successfully!"; int row = RestaurantDB.updateRestaurant(r); databindedROrg(); } else if (Session["userHotel"] != null) { Hotel h = (Hotel)Session["userHotel"]; h.Name = tbxCName.Text; h.RegID = tbxRID.Text; h.Address = tbxCAddress.Text; h.PostalCode = tbxCPostalCode.Text; h.City = tbxCCity.Text; h.Country = tbxCCountry.Text; h.Password = tbxCpass.Text; h.ContactNo = tbxCPhone.Text; h.OrgEmail = tbxCEmail.Text; h.Password = tbxCPassword.Text; h.Description = tbxDesc.Text; string imagefile = "notavailable"; if (FileUpload1.HasFile) { imagefile = FileUpload1.FileName; FileUpload1.SaveAs(Server.MapPath("../images/" + imagefile)); h.Photo = FileUpload1.FileName; imgProfile.ImageUrl = "../images/" + h.Photo; } h.License = tbxOHour.Text; Session["userHotel"] = h; lblOutput.Text = "Update successfully!"; int row = HotelDB.updateHotel(h); databindedHOrg(); } }