protected void btnHRegister_Click(object sender, EventArgs e) { string imagefile = "notavailable.jpg"; if (FileUpload3.HasFile) //checking whether the file upload has the file { imagefile = FileUpload3.FileName; FileUpload3.SaveAs(Server.MapPath("~/images/" + imagefile));//store the file in the images folder } //hotel Random rndRandom = new Random(); int newLicNo = rndRandom.Next(1, 1000); Hotel h = new Hotel() { OrgEmail = tbxHEmail.Text, Name = tbxHName.Text, RegID = tbxHRegID.Text, Address = tbxHAddress.Text, PostalCode = tbxHPostalCode.Text, City = tbxHCity.Text, Country = tbxHCountry.Text, Password = tbxHPassword.Text, ContactNo = tbxHPhone.Text, Description = "Not Applicable", License = "SH" + newLicNo, StarRating = Convert.ToInt32(5), Photo = imagefile, Verification = false }; int id = HotelDB.insertHotel(h); lblOutput.Text = id + "Registered Successfully!"; }
private void btn_addHotel_Click(object sender, RoutedEventArgs e) { try { byte[] img = null; FileStream fs = new FileStream(imgLocation, FileMode.Open, FileAccess.Read); BinaryReader br = new BinaryReader(fs); img = br.ReadBytes((int)fs.Length); using (HotelDB db = new HotelDB()) { Hotels hotel = new Hotels(); hotel.Name = txt_Name.Text; hotel.Address = txt_Address.Text; hotel.Description = txt_Description.Text; hotel.Stars = Convert.ToInt32(txt_Stars.Text); hotel.RoomsCount = Convert.ToInt32(txt_RoomsCount.Text); hotel.Photo = img; db.Hotels.Add(hotel); db.SaveChanges(); } this.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["HotelID"] != null) { List <Hotel> hotels = new List <Hotel>(); //get the hotel from the database using hotel id Hotel h = HotelDB.getHotelByID(Session["HotelID"].ToString()); hotels.Add(h); //add the account to the hotel list lvAccommodation.DataSource = hotels; //add the hotel list to list view data source lvAccommodation.DataBind(); //bind the list view data //retrieve all the feedback available for an hotel from the database and store them in a list List <Review> rvList = ReviewDB.getAllHotelReviewByID(Convert.ToInt32(Session["HotelID"])); AcmReviews.DataSource = rvList; //add the datasource to the grid view AcmReviews.DataBind(); // bind the grid view data if (rvList.Count == 0) //checking whether there is a feedback availble for that hotel { lblOutput.Text = "No feedback available for this hotel"; } } else { Response.Redirect("HomePage.aspx"); //transfer the page to view hotel } }
//to accept the attraction information details (update verification from false to true) -- user can show the attraction information into public website protected void btnAccept_Click(object sender, EventArgs e) { Hotel a = (Hotel)Session["emailH"]; a.Verification = true; Session["emailH"] = a; int row = HotelDB.updateHotelVerify(a); //to update the row into database }
private void getAllHotel() { //list the gridview from database List <Hotel> hotels = HotelDB.getAllHotel(); gvHotel.DataSource = hotels; gvHotel.DataBind(); }
protected void btnDelete_Click(object sender, EventArgs e) { Hotel a = (Hotel)Session["emailH"]; string id = a.OrgEmail; int row = HotelDB.deleteHotel(id); //to delete the row from database Response.Redirect("Homepage.aspx"); //to redirect to the homepage }
protected void gvHotel_SelectedIndexChanged(object sender, EventArgs e) { List <Hotel> hotels = HotelDB.getAllHotel(); Hotel h = hotels[gvHotel.SelectedIndex]; Session["emailH"] = h; Session["hotel"] = h.Name; Session["countryName"] = h.Country; Response.Redirect("AHdetails.aspx"); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //to get data from database List <Hotel> hotels = HotelDB.getHotelByCountry(Session["countryName"].ToString(), verification); //check the data is not null if (hotels.Count != 0) { Session["hotel"] = hotels; //create hotel session lblNoAcm.Visible = false; lvHotel.DataSource = hotels; lvHotel.DataBind(); } else { lblNoAcm.Visible = true; //show the error message } } lblCountry.Text = Session["countryName"].ToString(); //show the country name }
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(); } }
public DbManager() { db = new HotelDB(); }
public CustomerRepository() { _context = new HotelDB(); }
public AccountRepository(HotelDB dbcontext) { this.db = dbcontext; }
//Récupère un hotel selon son id public static Hotel GetHotelById(int idHotelDesired) { return(HotelDB.GetHotelById(idHotelDesired)); }
public static List <Hotel> GetHotelsByDateLocationAndNbPerson(DateTime beginDate, DateTime endDate, string location, int nbPerson, int minCategory, int maxCategory, bool?hasWifi = null, bool?hasParking = null) { return(HotelDB.GetHotelsByDateLocationAndNbPerson(beginDate, endDate, location, nbPerson, minCategory, maxCategory, hasWifi, hasParking)); }
public static double GetHotelOccupationAtDateFromId(int IdHotel, DateTime Date) { return(HotelDB.GetHotelOccupationAtDateFromId(IdHotel, Date)); }
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 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 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(); } }
// Appelle la requête qui récupère un hôtel en fonction d'un identifiant en paramètre public static Hotel GetHotel(int idHotel) { return(HotelDB.GetHotel(idHotel)); }
public ServiceRepository(HotelDB dbcontext) { this.db = dbcontext; }
public ModifierRepository(HotelDB dbcontext) { this.db = dbcontext; }
public CheckInRepository(HotelDB dbcontext) { this.db = dbcontext; }
//Récupère tous les hotels dans une liste public static List <Hotel> GetAllHotel() { return(HotelDB.GetAllHotel());//djeéajfékadsfj }
public static List <Hotel> GetAllHotel() { return(HotelDB.GetAllHotel()); }
public BookingController() { //***instantiate the HotelDB object to communicate with the database hotelDB = new HotelDB(); bookings = hotelDB.Bookings; }
public static Hotel GetHotelFromId(int IdHotel) { return(HotelDB.GetHotelFromId(IdHotel)); }
public ReservationRepository() { _context = new HotelDB(); }
public static Hotel GetHotelById(int id) { return(HotelDB.GetHotelfromId(id)); }
public GuestController() { //***instantiate the HotelDB object to communicate with the database hotelDB = new HotelDB(); guests = hotelDB.Guests; }
public RoomTypeRepository(HotelDB dbcontext) { this.db = dbcontext; }