Esempio n. 1
0
    /// <summary>
    /// Required method for Designer support - do not modify
    /// the contents of this method with the code editor.
    /// </summary>
    private void InitializeComponent()
    {
        //CommonFunctions.Connection = new System.Data.SqlClient.SqlConnection();
        this.RegionsSet            = new Vacations.RegionsDataset();
        this.StateProvincesSet     = new Vacations.StateProvincesDataset();
        this.AmenitiesSet          = new Vacations.AmenitiesDataset();
        this.CountriesAdapter      = new System.Data.SqlClient.SqlDataAdapter();
        this.sqlSelectCommand4     = new System.Data.SqlClient.SqlCommand();
        this.AmenitiesAdapter      = new System.Data.SqlClient.SqlDataAdapter();
        this.sqlInsertCommand5     = new System.Data.SqlClient.SqlCommand();
        this.sqlSelectCommand3     = new System.Data.SqlClient.SqlCommand();
        this.RegionsAdapter        = new System.Data.SqlClient.SqlDataAdapter();
        this.sqlInsertCommand6     = new System.Data.SqlClient.SqlCommand();
        this.sqlSelectCommand5     = new System.Data.SqlClient.SqlCommand();
        this.AttractionsAdapter    = new System.Data.SqlClient.SqlDataAdapter();
        this.sqlInsertCommand4     = new System.Data.SqlClient.SqlCommand();
        this.sqlSelectCommand1     = new System.Data.SqlClient.SqlCommand();
        this.CitiesSet             = new Vacations.CitiesDataset();
        this.CountriesSet          = new Vacations.CountriesDataset();
        this.StateProvincesAdapter = new System.Data.SqlClient.SqlDataAdapter();
        this.sqlInsertCommand3     = new System.Data.SqlClient.SqlCommand();
        this.sqlSelectCommand2     = new System.Data.SqlClient.SqlCommand();
        this.AttractionsSet        = new Vacations.AttractionsDataset();
        this.CitiesAdapter         = new System.Data.SqlClient.SqlDataAdapter();
        this.sqlInsertCommand1     = new System.Data.SqlClient.SqlCommand();
        this.sqlSelectCommand7     = new System.Data.SqlClient.SqlCommand();
        this.PropertiesFullSet     = new Vacations.PropertiesFullDataset();
        this.PropertiesAdapter     = new System.Data.SqlClient.SqlDataAdapter();
        this.sqlSelectCommand6     = new System.Data.SqlClient.SqlCommand();
        this.CountriesSet2         = new Vacations.CountriesDataset();
        ((System.ComponentModel.ISupportInitialize)(this.RegionsSet)).BeginInit();
        ((System.ComponentModel.ISupportInitialize)(this.StateProvincesSet)).BeginInit();
        ((System.ComponentModel.ISupportInitialize)(this.AmenitiesSet)).BeginInit();
        ((System.ComponentModel.ISupportInitialize)(this.CitiesSet)).BeginInit();
        ((System.ComponentModel.ISupportInitialize)(this.CountriesSet)).BeginInit();
        ((System.ComponentModel.ISupportInitialize)(this.AttractionsSet)).BeginInit();
        ((System.ComponentModel.ISupportInitialize)(this.PropertiesFullSet)).BeginInit();
        ((System.ComponentModel.ISupportInitialize)(this.CountriesSet2)).BeginInit();
        //
        // CommonFunctions.Connection
        //
        //CommonFunctions.Connection.ConnectionString = "workstation id=MAIN;packet size=4096;integrated security=SSPI;data source=MAIN;pe" +
        //"rsist security info=False;initial catalog=Vacations";
        //
        // RegionsSet
        //
        this.RegionsSet.DataSetName = "RegionsDataset";
        this.RegionsSet.Locale      = new System.Globalization.CultureInfo("en-US");
        //
        // StateProvincesSet
        //
        this.StateProvincesSet.DataSetName = "StateProvincesDataset";
        this.StateProvincesSet.Locale      = new System.Globalization.CultureInfo("en-US");
        //
        // AmenitiesSet
        //
        this.AmenitiesSet.DataSetName = "AmenitiesDataset";
        this.AmenitiesSet.Locale      = new System.Globalization.CultureInfo("en-US");
        //
        // CountriesAdapter
        //
        this.CountriesAdapter.SelectCommand = this.sqlSelectCommand4;
        this.CountriesAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "Countries", new System.Data.Common.DataColumnMapping[] {
                new System.Data.Common.DataColumnMapping("ID", "ID"),
                new System.Data.Common.DataColumnMapping("RegionID", "RegionID"),
                new System.Data.Common.DataColumnMapping("Country", "Country")
            })
        });
        //
        // sqlSelectCommand4
        //
        this.sqlSelectCommand4.CommandText = "CountryDistinctList";
        this.sqlSelectCommand4.CommandType = CommandType.StoredProcedure;
        this.sqlSelectCommand4.Connection  = CommonFunctions.GetConnection();
        //
        // AmenitiesAdapter
        //
        this.AmenitiesAdapter.InsertCommand = this.sqlInsertCommand5;
        this.AmenitiesAdapter.SelectCommand = this.sqlSelectCommand3;
        this.AmenitiesAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "Amenities", new System.Data.Common.DataColumnMapping[] {
                new System.Data.Common.DataColumnMapping("ID", "ID"),
                new System.Data.Common.DataColumnMapping("Amenity", "Amenity")
            })
        });
        //
        // sqlInsertCommand5
        //
        this.sqlInsertCommand5.CommandText = "INSERT INTO Amenities(ID, Amenity) VALUES (@ID, @Amenity)";
        this.sqlInsertCommand5.Connection  = CommonFunctions.GetConnection();
        this.sqlInsertCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ID", System.Data.SqlDbType.Int, 4, "ID"));
        this.sqlInsertCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Amenity", System.Data.SqlDbType.NVarChar, 300, "Amenity"));
        //
        // sqlSelectCommand3
        //
        this.sqlSelectCommand3.CommandText = "AmenityDistinctList";
        this.sqlSelectCommand3.Connection  = CommonFunctions.GetConnection();
        this.sqlSelectCommand3.CommandType = CommandType.StoredProcedure;
        //
        // RegionsAdapter
        //
        this.RegionsAdapter.InsertCommand = this.sqlInsertCommand6;
        this.RegionsAdapter.SelectCommand = this.sqlSelectCommand5;
        this.RegionsAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "Regions", new System.Data.Common.DataColumnMapping[] {
                new System.Data.Common.DataColumnMapping("ID", "ID"),
                new System.Data.Common.DataColumnMapping("Region", "Region")
            })
        });
        //
        // sqlInsertCommand6
        //
        this.sqlInsertCommand6.CommandText = "INSERT INTO Regions(Region) VALUES (@Region)";
        this.sqlInsertCommand6.Connection  = CommonFunctions.GetConnection();
        this.sqlInsertCommand6.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Region", System.Data.SqlDbType.NVarChar, 300, "Region"));
        //
        // sqlSelectCommand5
        //
        this.sqlSelectCommand5.CommandText = "RegionDistinctList";
        this.sqlSelectCommand5.Connection  = CommonFunctions.GetConnection();
        this.sqlSelectCommand5.CommandType = CommandType.StoredProcedure;
        //
        // AttractionsAdapter
        //
        this.AttractionsAdapter.InsertCommand = this.sqlInsertCommand4;
        this.AttractionsAdapter.SelectCommand = this.sqlSelectCommand1;
        this.AttractionsAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "Attractions", new System.Data.Common.DataColumnMapping[] {
                new System.Data.Common.DataColumnMapping("ID", "ID"),
                new System.Data.Common.DataColumnMapping("Attraction", "Attraction")
            })
        });
        //
        // sqlInsertCommand4
        //
        this.sqlInsertCommand4.CommandText = "INSERT INTO Attractions(ID, Attraction) VALUES (@ID, @Attraction)";
        this.sqlInsertCommand4.Connection  = CommonFunctions.GetConnection();
        this.sqlInsertCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ID", System.Data.SqlDbType.Int, 4, "ID"));
        this.sqlInsertCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Attraction", System.Data.SqlDbType.NVarChar, 300, "Attraction"));
        //
        // sqlSelectCommand1
        //
        this.sqlSelectCommand1.CommandText = "AttractionsDistinctList";
        this.sqlSelectCommand1.Connection  = CommonFunctions.GetConnection();
        this.sqlInsertCommand1.CommandType = CommandType.StoredProcedure;
        //
        // CitiesSet
        //
        this.CitiesSet.DataSetName = "CitiesDataset";
        this.CitiesSet.Locale      = new System.Globalization.CultureInfo("en-US");
        //
        // CountriesSet
        //
        this.CountriesSet.DataSetName = "CountriesDataset";
        this.CountriesSet.Locale      = new System.Globalization.CultureInfo("en-US");
        //
        // StateProvincesAdapter
        //
        this.StateProvincesAdapter.InsertCommand = this.sqlInsertCommand3;
        this.StateProvincesAdapter.SelectCommand = this.sqlSelectCommand2;
        this.StateProvincesAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "StateProvinces", new System.Data.Common.DataColumnMapping[] {
                new System.Data.Common.DataColumnMapping("ID", "ID"),
                new System.Data.Common.DataColumnMapping("CountryID", "CountryID"),
                new System.Data.Common.DataColumnMapping("StateProvince", "StateProvince")
            })
        });
        //
        // sqlInsertCommand3
        //
        this.sqlInsertCommand3.CommandText = "INSERT INTO StateProvinces(CountryID, StateProvince) VALUES (@CountryID, @StateProvince)";
        this.sqlInsertCommand3.Connection  = CommonFunctions.GetConnection();
        this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CountryID", System.Data.SqlDbType.Int, 4, "CountryID"));
        this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@StateProvince", System.Data.SqlDbType.NVarChar, 300, "StateProvince"));
        //
        // sqlSelectCommand2
        //
        this.sqlSelectCommand2.CommandText = "StateProvinceDistinctList";
        this.sqlSelectCommand2.Connection  = CommonFunctions.GetConnection();
        this.sqlSelectCommand2.CommandType = CommandType.StoredProcedure;
        //
        // AttractionsSet
        //
        this.AttractionsSet.DataSetName = "AttractionsDataset";
        this.AttractionsSet.Locale      = new System.Globalization.CultureInfo("en-US");
        //
        // CitiesAdapter
        //
        this.CitiesAdapter.InsertCommand = this.sqlInsertCommand1;
        this.CitiesAdapter.SelectCommand = this.sqlSelectCommand7;
        this.CitiesAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "Cities", new System.Data.Common.DataColumnMapping[] {
                new System.Data.Common.DataColumnMapping("ID", "ID"),
                new System.Data.Common.DataColumnMapping("StateProvinceID", "StateProvinceID"),
                new System.Data.Common.DataColumnMapping("City", "City")
            })
        });
        //
        // sqlInsertCommand1
        //
        this.sqlInsertCommand1.CommandText = "INSERT INTO Cities(StateProvinceID, City) VALUES (@StateProvinceID, @City)";
        this.sqlInsertCommand1.Connection  = CommonFunctions.GetConnection();
        this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@StateProvinceID", System.Data.SqlDbType.Int, 4, "StateProvinceID"));
        this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@City", System.Data.SqlDbType.NVarChar, 300, "City"));
        //
        // sqlSelectCommand7
        //
        this.sqlSelectCommand7.CommandText = @"SELECT DISTINCT Cities.ID, Cities.StateProvinceID, Cities.City FROM Cities INNER JOIN Properties ON Cities.ID=Properties.CityID WHERE (Properties.IfFinished = 1) AND (Properties.IfApproved = 1) UNION SELECT -1, -1, ' Include All' ORDER BY City";
        this.sqlSelectCommand7.Connection  = CommonFunctions.GetConnection();
        //
        // PropertiesFullSet
        //
        this.PropertiesFullSet.DataSetName = "PropertiesFullDataset";
        this.PropertiesFullSet.Locale      = new System.Globalization.CultureInfo("en-US");
        //
        // PropertiesAdapter
        //
        this.PropertiesAdapter.SelectCommand = this.sqlSelectCommand6;
        this.PropertiesAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "Properties", new System.Data.Common.DataColumnMapping[] {
                new System.Data.Common.DataColumnMapping("MinimumNightlyRental", "MinimumNightlyRental"),
                new System.Data.Common.DataColumnMapping("TaxIncluded", "TaxIncluded")
            })
        });
        //
        // sqlSelectCommand6
        //
        this.sqlSelectCommand6.CommandText = "TopThreePropertiesList";
        this.sqlSelectCommand6.Connection  = CommonFunctions.GetConnection();
        this.sqlSelectCommand6.CommandType = CommandType.StoredProcedure;
        //
        // CountriesSet2
        //
        this.CountriesSet2.DataSetName = "CountriesDataset";
        this.CountriesSet2.Locale      = new System.Globalization.CultureInfo("en-US");
        this.CountriesStates           = new Vacations.CountriesStates();
        this.GetStateProvinces         = new System.Data.SqlClient.SqlDataAdapter();
        this.GetCountries      = new System.Data.SqlClient.SqlDataAdapter();
        this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand();
        this.CountriesStates   = new Vacations.CountriesStates();
        this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
        ((System.ComponentModel.ISupportInitialize)(this.CountriesStates)).BeginInit();
        //
        // CommonFunctions.Connection
        //
        //CommonFunctions.Connection.ConnectionString = "workstation id=MAIN;packet size=4096;integrated security=SSPI;data source=MAIN;pe" +
        //"rsist security info=False;initial catalog=Vacations";
        //
        // GetStateProvinces
        //
        this.GetStateProvinces.SelectCommand = this.sqlSelectCommand1;
        this.GetStateProvinces.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "StateProvinces", new System.Data.Common.DataColumnMapping[] {
                new System.Data.Common.DataColumnMapping("ID", "ID"),
                new System.Data.Common.DataColumnMapping("CountryID", "CountryID"),
                new System.Data.Common.DataColumnMapping("StateProvince", "StateProvince"),
                new System.Data.Common.DataColumnMapping("Country", "Country")
            })
        });
        //
        // GetCountries
        //
        this.GetCountries.SelectCommand = this.sqlSelectCommand2;
        this.GetCountries.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "Countries", new System.Data.Common.DataColumnMapping[] {
                new System.Data.Common.DataColumnMapping("ID", "ID"),
                new System.Data.Common.DataColumnMapping("RegionID", "RegionID"),
                new System.Data.Common.DataColumnMapping("Country", "Country")
            })
        });
        //
        // sqlSelectCommand2
        //
        //this.sqlSelectCommand2.CommandText = @"SELECT ID, RegionID, Country FROM Countries WHERE (RegionID = @RegionID) AND EXISTS (SELECT * FROM (Properties INNER JOIN Cities ON Properties.CityID = Cities.ID) INNER JOIN StateProvinces ON Cities.StateProvinceID = StateProvinces.ID WHERE (StateProvinces.CountryID = Countries.ID) AND (Properties.IfFinished = 1) AND (Properties.IfApproved = 1) AND NOT EXISTS (SELECT * FROM Auctions WHERE PropertyID = Properties.ID)) ORDER BY Country";
        this.sqlSelectCommand2.CommandText = @"SELECT ID, RegionID, Country FROM Countries WHERE (RegionID = @RegionID) AND EXISTS (SELECT * FROM (Properties INNER JOIN Cities ON Properties.CityID = Cities.ID) INNER JOIN StateProvinces ON Cities.StateProvinceID = StateProvinces.ID WHERE (StateProvinces.CountryID = Countries.ID) AND (Properties.IfFinished = 1) AND (Properties.IfApproved = 1) ) ORDER BY Country";
        this.sqlSelectCommand2.Connection  = CommonFunctions.GetConnection();
        this.sqlSelectCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RegionID", System.Data.SqlDbType.Int, 4, "RegionID"));
        this.sqlSelectCommand1.CommandText = @"SELECT StateProvinces.ID, StateProvinces.CountryID, StateProvinces.StateProvince, Countries.Country FROM StateProvinces INNER JOIN Countries ON StateProvinces.CountryID = Countries.ID WHERE (Countries.RegionID = @RegionID) AND EXISTS (SELECT * FROM Properties INNER JOIN Cities ON Properties.CityID = Cities.ID WHERE (Cities.StateProvinceID = StateProvinces.ID) AND (Properties.IfFinished = 1) AND (Properties.IfApproved = 1)) ORDER BY StateProvinces.StateProvince";
        this.sqlSelectCommand1.Connection  = CommonFunctions.GetConnection();
        this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RegionID", System.Data.SqlDbType.Int, 4, "RegionID"));
        //


        // CountriesStates
        //
        this.CountriesStates.DataSetName = "CountriesStates";
        this.CountriesStates.Locale      = new System.Globalization.CultureInfo("en-US");

        //GetStateProvinces = new System.Data.SqlClient.SqlDataAdapter();
        //System.Data.SqlClient.SqlDataAdapter GetCountries= new System.Data.SqlClient.SqlDataAdapter();

        this.GetCountries.SelectCommand.Parameters["@RegionID"].Value      = 6;
        this.GetStateProvinces.SelectCommand.Parameters["@RegionID"].Value = 6;

        ////lock (CommonFunctions.Connection)
        this.GetCountries.Fill(this.CountriesStates);
        ////lock (CommonFunctions.Connection)
        this.GetStateProvinces.Fill(this.CountriesStates);

        this.CountriesStates.Relations.Add("CountriesStates", this.CountriesStates.Tables["Countries"].Columns["ID"],
                                           this.CountriesStates.Tables["StateProvinces"].Columns["CountryID"]);
        //ltlAsia.Text = ds.Tables[0].Rows[1]["RegionTextValue"].ToString();
        //ltlEurope.Text = ds.Tables[0].Rows[2]["RegionTextValue"].ToString();
        //ltlNorthAmerica.Text = ds.Tables[0].Rows[3]["RegionTextValue"].ToString();
        //ltlSouthAmerica.Text = ds.Tables[0].Rows[4]["RegionTextValue"].ToString();
        //ltlOceania.Text = ds.Tables[0].Rows[5]["RegionTextValue"].ToString();
        //ltlAsiaList.Text = GenerateCountryLinks("2");
        //ltlOceaniaList.Text = GenerateCountryLinks("3");
        //ltlSouthAmericaList.Text = GenerateCountryLinks("9");
        //ltlEuropeList.Text = GenerateCountryLinks("6");
        //ltlNorthAmericaList.Text = GenerateCountryLinks("8");

        ((System.ComponentModel.ISupportInitialize)(this.RegionsSet)).EndInit();
        ((System.ComponentModel.ISupportInitialize)(this.StateProvincesSet)).EndInit();
        ((System.ComponentModel.ISupportInitialize)(this.AmenitiesSet)).EndInit();
        ((System.ComponentModel.ISupportInitialize)(this.CitiesSet)).EndInit();
        ((System.ComponentModel.ISupportInitialize)(this.CountriesSet)).EndInit();
        ((System.ComponentModel.ISupportInitialize)(this.AttractionsSet)).EndInit();
        ((System.ComponentModel.ISupportInitialize)(this.PropertiesFullSet)).EndInit();
        ((System.ComponentModel.ISupportInitialize)(this.CountriesSet2)).EndInit();
    }
Esempio n. 2
0
 /// <summary>
 /// Required method for Designer support - do not modify
 /// the contents of this method with the code editor.
 /// </summary>
 private void InitializeComponent()
 {
     //CommonFunctions.Connection = new System.Data.SqlClient.SqlConnection();
     this.RegionsSet            = new Vacations.RegionsDataset();
     this.StateProvincesSet     = new Vacations.StateProvincesDataset();
     this.AmenitiesSet          = new Vacations.AmenitiesDataset();
     this.CountriesAdapter      = new System.Data.SqlClient.SqlDataAdapter();
     this.sqlSelectCommand4     = new System.Data.SqlClient.SqlCommand();
     this.AmenitiesAdapter      = new System.Data.SqlClient.SqlDataAdapter();
     this.sqlInsertCommand5     = new System.Data.SqlClient.SqlCommand();
     this.sqlSelectCommand3     = new System.Data.SqlClient.SqlCommand();
     this.RegionsAdapter        = new System.Data.SqlClient.SqlDataAdapter();
     this.sqlInsertCommand6     = new System.Data.SqlClient.SqlCommand();
     this.sqlSelectCommand5     = new System.Data.SqlClient.SqlCommand();
     this.AttractionsAdapter    = new System.Data.SqlClient.SqlDataAdapter();
     this.sqlInsertCommand4     = new System.Data.SqlClient.SqlCommand();
     this.sqlSelectCommand1     = new System.Data.SqlClient.SqlCommand();
     this.CitiesSet             = new Vacations.CitiesDataset();
     this.CountriesSet          = new Vacations.CountriesDataset();
     this.StateProvincesAdapter = new System.Data.SqlClient.SqlDataAdapter();
     this.sqlInsertCommand3     = new System.Data.SqlClient.SqlCommand();
     this.sqlSelectCommand2     = new System.Data.SqlClient.SqlCommand();
     this.AttractionsSet        = new Vacations.AttractionsDataset();
     this.CitiesAdapter         = new System.Data.SqlClient.SqlDataAdapter();
     this.sqlInsertCommand1     = new System.Data.SqlClient.SqlCommand();
     this.sqlSelectCommand7     = new System.Data.SqlClient.SqlCommand();
     this.PropertiesFullSet     = new Vacations.PropertiesFullDataset();
     this.PropertiesAdapter     = new System.Data.SqlClient.SqlDataAdapter();
     this.sqlSelectCommand6     = new System.Data.SqlClient.SqlCommand();
     this.CountriesSet2         = new Vacations.CountriesDataset();
     ((System.ComponentModel.ISupportInitialize)(this.RegionsSet)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.StateProvincesSet)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.AmenitiesSet)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.CitiesSet)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.CountriesSet)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.AttractionsSet)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.PropertiesFullSet)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.CountriesSet2)).BeginInit();
     //
     // CommonFunctions.Connection
     //
     //CommonFunctions.Connection.ConnectionString = "workstation id=MAIN;packet size=4096;integrated security=SSPI;data source=MAIN;pe" +
     //"rsist security info=False;initial catalog=Vacations";
     //
     // RegionsSet
     //
     this.RegionsSet.DataSetName = "RegionsDataset";
     this.RegionsSet.Locale      = new System.Globalization.CultureInfo("en-US");
     //
     // StateProvincesSet
     //
     this.StateProvincesSet.DataSetName = "StateProvincesDataset";
     this.StateProvincesSet.Locale      = new System.Globalization.CultureInfo("en-US");
     //
     // AmenitiesSet
     //
     this.AmenitiesSet.DataSetName = "AmenitiesDataset";
     this.AmenitiesSet.Locale      = new System.Globalization.CultureInfo("en-US");
     //
     // CountriesAdapter
     //
     this.CountriesAdapter.SelectCommand = this.sqlSelectCommand4;
     this.CountriesAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
         new System.Data.Common.DataTableMapping("Table", "Countries", new System.Data.Common.DataColumnMapping[] {
             new System.Data.Common.DataColumnMapping("ID", "ID"),
             new System.Data.Common.DataColumnMapping("RegionID", "RegionID"),
             new System.Data.Common.DataColumnMapping("Country", "Country")
         })
     });
     //
     // sqlSelectCommand4
     //
     this.sqlSelectCommand4.CommandText = "CountryDistinctList";
     this.sqlSelectCommand4.CommandType = CommandType.StoredProcedure;
     this.sqlSelectCommand4.Connection  = CommonFunctions.GetConnection();
     //
     // AmenitiesAdapter
     //
     this.AmenitiesAdapter.InsertCommand = this.sqlInsertCommand5;
     this.AmenitiesAdapter.SelectCommand = this.sqlSelectCommand3;
     this.AmenitiesAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
         new System.Data.Common.DataTableMapping("Table", "Amenities", new System.Data.Common.DataColumnMapping[] {
             new System.Data.Common.DataColumnMapping("ID", "ID"),
             new System.Data.Common.DataColumnMapping("Amenity", "Amenity")
         })
     });
     //
     // sqlInsertCommand5
     //
     this.sqlInsertCommand5.CommandText = "INSERT INTO Amenities(ID, Amenity) VALUES (@ID, @Amenity)";
     this.sqlInsertCommand5.Connection  = CommonFunctions.GetConnection();
     this.sqlInsertCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ID", System.Data.SqlDbType.Int, 4, "ID"));
     this.sqlInsertCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Amenity", System.Data.SqlDbType.NVarChar, 300, "Amenity"));
     //
     // sqlSelectCommand3
     //
     this.sqlSelectCommand3.CommandText = "AmenityDistinctList";
     this.sqlSelectCommand3.Connection  = CommonFunctions.GetConnection();
     this.sqlSelectCommand3.CommandType = CommandType.StoredProcedure;
     //
     // RegionsAdapter
     //
     this.RegionsAdapter.InsertCommand = this.sqlInsertCommand6;
     this.RegionsAdapter.SelectCommand = this.sqlSelectCommand5;
     this.RegionsAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
         new System.Data.Common.DataTableMapping("Table", "Regions", new System.Data.Common.DataColumnMapping[] {
             new System.Data.Common.DataColumnMapping("ID", "ID"),
             new System.Data.Common.DataColumnMapping("Region", "Region")
         })
     });
     //
     // sqlInsertCommand6
     //
     this.sqlInsertCommand6.CommandText = "INSERT INTO Regions(Region) VALUES (@Region)";
     this.sqlInsertCommand6.Connection  = CommonFunctions.GetConnection();
     this.sqlInsertCommand6.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Region", System.Data.SqlDbType.NVarChar, 300, "Region"));
     //
     // sqlSelectCommand5
     //
     this.sqlSelectCommand5.CommandText = "RegionDistinctList";
     this.sqlSelectCommand5.Connection  = CommonFunctions.GetConnection();
     this.sqlSelectCommand5.CommandType = CommandType.StoredProcedure;
     //
     // AttractionsAdapter
     //
     this.AttractionsAdapter.InsertCommand = this.sqlInsertCommand4;
     this.AttractionsAdapter.SelectCommand = this.sqlSelectCommand1;
     this.AttractionsAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
         new System.Data.Common.DataTableMapping("Table", "Attractions", new System.Data.Common.DataColumnMapping[] {
             new System.Data.Common.DataColumnMapping("ID", "ID"),
             new System.Data.Common.DataColumnMapping("Attraction", "Attraction")
         })
     });
     //
     // sqlInsertCommand4
     //
     this.sqlInsertCommand4.CommandText = "INSERT INTO Attractions(ID, Attraction) VALUES (@ID, @Attraction)";
     this.sqlInsertCommand4.Connection  = CommonFunctions.GetConnection();
     this.sqlInsertCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ID", System.Data.SqlDbType.Int, 4, "ID"));
     this.sqlInsertCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Attraction", System.Data.SqlDbType.NVarChar, 300, "Attraction"));
     //
     // sqlSelectCommand1
     //
     this.sqlSelectCommand1.CommandText = "AttractionsDistinctList";
     this.sqlSelectCommand1.Connection  = CommonFunctions.GetConnection();
     this.sqlInsertCommand1.CommandType = CommandType.StoredProcedure;
     //
     // CitiesSet
     //
     this.CitiesSet.DataSetName = "CitiesDataset";
     this.CitiesSet.Locale      = new System.Globalization.CultureInfo("en-US");
     //
     // CountriesSet
     //
     this.CountriesSet.DataSetName = "CountriesDataset";
     this.CountriesSet.Locale      = new System.Globalization.CultureInfo("en-US");
     //
     // StateProvincesAdapter
     //
     this.StateProvincesAdapter.InsertCommand = this.sqlInsertCommand3;
     this.StateProvincesAdapter.SelectCommand = this.sqlSelectCommand2;
     this.StateProvincesAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
         new System.Data.Common.DataTableMapping("Table", "StateProvinces", new System.Data.Common.DataColumnMapping[] {
             new System.Data.Common.DataColumnMapping("ID", "ID"),
             new System.Data.Common.DataColumnMapping("CountryID", "CountryID"),
             new System.Data.Common.DataColumnMapping("StateProvince", "StateProvince")
         })
     });
     //
     // sqlInsertCommand3
     //
     this.sqlInsertCommand3.CommandText = "INSERT INTO StateProvinces(CountryID, StateProvince) VALUES (@CountryID, @StateProvince)";
     this.sqlInsertCommand3.Connection  = CommonFunctions.GetConnection();
     this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CountryID", System.Data.SqlDbType.Int, 4, "CountryID"));
     this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@StateProvince", System.Data.SqlDbType.NVarChar, 300, "StateProvince"));
     //
     // sqlSelectCommand2
     //
     this.sqlSelectCommand2.CommandText = "StateProvinceDistinctList";
     this.sqlSelectCommand2.Connection  = CommonFunctions.GetConnection();
     this.sqlSelectCommand2.CommandType = CommandType.StoredProcedure;
     //
     // AttractionsSet
     //
     this.AttractionsSet.DataSetName = "AttractionsDataset";
     this.AttractionsSet.Locale      = new System.Globalization.CultureInfo("en-US");
     //
     // CitiesAdapter
     //
     this.CitiesAdapter.InsertCommand = this.sqlInsertCommand1;
     this.CitiesAdapter.SelectCommand = this.sqlSelectCommand7;
     this.CitiesAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
         new System.Data.Common.DataTableMapping("Table", "Cities", new System.Data.Common.DataColumnMapping[] {
             new System.Data.Common.DataColumnMapping("ID", "ID"),
             new System.Data.Common.DataColumnMapping("StateProvinceID", "StateProvinceID"),
             new System.Data.Common.DataColumnMapping("City", "City")
         })
     });
     //
     // sqlInsertCommand1
     //
     this.sqlInsertCommand1.CommandText = "INSERT INTO Cities(StateProvinceID, City) VALUES (@StateProvinceID, @City)";
     this.sqlInsertCommand1.Connection  = CommonFunctions.GetConnection();
     this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@StateProvinceID", System.Data.SqlDbType.Int, 4, "StateProvinceID"));
     this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@City", System.Data.SqlDbType.NVarChar, 300, "City"));
     //
     // sqlSelectCommand7
     //
     this.sqlSelectCommand7.CommandText = @"SELECT DISTINCT Cities.ID, Cities.StateProvinceID, Cities.City FROM Cities INNER JOIN Properties ON Cities.ID=Properties.CityID WHERE (Properties.IfFinished = 1) AND (Properties.IfApproved = 1) UNION SELECT -1, -1, ' Include All' ORDER BY City";
     this.sqlSelectCommand7.Connection  = CommonFunctions.GetConnection();
     //
     // PropertiesFullSet
     //
     this.PropertiesFullSet.DataSetName = "PropertiesFullDataset";
     this.PropertiesFullSet.Locale      = new System.Globalization.CultureInfo("en-US");
     //
     // PropertiesAdapter
     //
     this.PropertiesAdapter.SelectCommand = this.sqlSelectCommand6;
     this.PropertiesAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
         new System.Data.Common.DataTableMapping("Table", "Properties", new System.Data.Common.DataColumnMapping[] {
             new System.Data.Common.DataColumnMapping("MinimumNightlyRental", "MinimumNightlyRental"),
             new System.Data.Common.DataColumnMapping("Type", "Type"),
             new System.Data.Common.DataColumnMapping("FirstName", "FirstName"),
             new System.Data.Common.DataColumnMapping("LastName", "LastName"),
             new System.Data.Common.DataColumnMapping("PrimaryTelephone", "PrimaryTelephone"),
             new System.Data.Common.DataColumnMapping("OwnerCountry", "OwnerCountry"),
             new System.Data.Common.DataColumnMapping("Email", "Email"),
             new System.Data.Common.DataColumnMapping("Username", "Username"),
             new System.Data.Common.DataColumnMapping("OwnerAddress", "OwnerAddress"),
             new System.Data.Common.DataColumnMapping("EveningTelephone", "EveningTelephone"),
             new System.Data.Common.DataColumnMapping("DaytimeTelephone", "DaytimeTelephone"),
             new System.Data.Common.DataColumnMapping("MobileTelephone", "MobileTelephone"),
             new System.Data.Common.DataColumnMapping("Website", "Website"),
             new System.Data.Common.DataColumnMapping("OwnerCity", "OwnerCity"),
             new System.Data.Common.DataColumnMapping("OwnerState", "OwnerState"),
             new System.Data.Common.DataColumnMapping("OwnerZip", "OwnerZip"),
             new System.Data.Common.DataColumnMapping("City", "City"),
             new System.Data.Common.DataColumnMapping("StateProvince", "StateProvince"),
             new System.Data.Common.DataColumnMapping("Country", "Country"),
             new System.Data.Common.DataColumnMapping("Region", "Region"),
             new System.Data.Common.DataColumnMapping("Smoking", "Smoking"),
             new System.Data.Common.DataColumnMapping("PetFriendly", "PetFriendly"),
             new System.Data.Common.DataColumnMapping("ID", "ID"),
             new System.Data.Common.DataColumnMapping("UserID", "UserID"),
             new System.Data.Common.DataColumnMapping("Name", "Name"),
             new System.Data.Common.DataColumnMapping("TypeID", "TypeID"),
             new System.Data.Common.DataColumnMapping("Address", "Address"),
             new System.Data.Common.DataColumnMapping("CityID", "CityID"),
             new System.Data.Common.DataColumnMapping("IfShowAddress", "IfShowAddress"),
             new System.Data.Common.DataColumnMapping("NumBedrooms", "NumBedrooms"),
             new System.Data.Common.DataColumnMapping("NumBaths", "NumBaths"),
             new System.Data.Common.DataColumnMapping("NumSleeps", "NumSleeps"),
             new System.Data.Common.DataColumnMapping("MinimumNightlyRentalID", "MinimumNightlyRentalID"),
             new System.Data.Common.DataColumnMapping("NumTVs", "NumTVs"),
             new System.Data.Common.DataColumnMapping("NumVCRs", "NumVCRs"),
             new System.Data.Common.DataColumnMapping("NumCDPlayers", "NumCDPlayers"),
             new System.Data.Common.DataColumnMapping("Description", "Description"),
             new System.Data.Common.DataColumnMapping("Amenities", "Amenities"),
             new System.Data.Common.DataColumnMapping("LocalAttractions", "LocalAttractions"),
             new System.Data.Common.DataColumnMapping("Rates", "Rates"),
             new System.Data.Common.DataColumnMapping("CancellationPolicy", "CancellationPolicy"),
             new System.Data.Common.DataColumnMapping("DepositRequired", "DepositRequired"),
             new System.Data.Common.DataColumnMapping("IfMoreThan7PhotosAllowed", "IfMoreThan7PhotosAllowed"),
             new System.Data.Common.DataColumnMapping("IfFinished", "IfFinished"),
             new System.Data.Common.DataColumnMapping("IfApproved", "IfApproved"),
             new System.Data.Common.DataColumnMapping("IfPaid", "IfPaid"),
             new System.Data.Common.DataColumnMapping("DateAdded", "DateAdded"),
             new System.Data.Common.DataColumnMapping("DateStartViewed", "DateStartViewed"),
             new System.Data.Common.DataColumnMapping("VirtualTour", "VirtualTour"),
             new System.Data.Common.DataColumnMapping("RatesTable", "RatesTable"),
             new System.Data.Common.DataColumnMapping("PricesCurrency", "PricesCurrency"),
             new System.Data.Common.DataColumnMapping("CheckIn", "CheckIn"),
             new System.Data.Common.DataColumnMapping("CheckOut", "CheckOut"),
             new System.Data.Common.DataColumnMapping("LodgingTax", "LodgingTax"),
             new System.Data.Common.DataColumnMapping("TaxIncluded", "TaxIncluded")
         })
     });
     //
     // sqlSelectCommand6
     //
     this.sqlSelectCommand6.CommandText = "TopThreePropertiesList";
     this.sqlSelectCommand6.Connection  = CommonFunctions.GetConnection();
     this.sqlSelectCommand6.CommandType = CommandType.StoredProcedure;
     //
     // CountriesSet2
     //
     this.CountriesSet2.DataSetName = "CountriesDataset";
     this.CountriesSet2.Locale      = new System.Globalization.CultureInfo("en-US");
     ((System.ComponentModel.ISupportInitialize)(this.RegionsSet)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.StateProvincesSet)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.AmenitiesSet)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.CitiesSet)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.CountriesSet)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.AttractionsSet)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.PropertiesFullSet)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.CountriesSet2)).EndInit();
 }
Esempio n. 3
0
	/// <summary>
	/// Required method for Designer support - do not modify
	/// the contents of this method with the code editor.
	/// </summary>
	private void InitializeComponent()
	{    
		//CommonFunctions.Connection = new System.Data.SqlClient.SqlConnection();
		this.RegionsSet = new Vacations.RegionsDataset();
		this.StateProvincesSet = new Vacations.StateProvincesDataset();
		this.AmenitiesSet = new Vacations.AmenitiesDataset();
		this.CitiesSet = new Vacations.CitiesDataset();
		this.CountriesSet = new Vacations.CountriesDataset();
		this.AttractionsSet = new Vacations.AttractionsDataset();
		this.AttractionsAdapter = new System.Data.SqlClient.SqlDataAdapter();
		this.sqlInsertCommand4 = new System.Data.SqlClient.SqlCommand();
		this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
		this.AmenitiesAdapter = new System.Data.SqlClient.SqlDataAdapter();
		this.sqlInsertCommand5 = new System.Data.SqlClient.SqlCommand();
		this.sqlSelectCommand3 = new System.Data.SqlClient.SqlCommand();
		this.RegionsAdapter = new System.Data.SqlClient.SqlDataAdapter();
		this.sqlInsertCommand6 = new System.Data.SqlClient.SqlCommand();
		this.sqlSelectCommand5 = new System.Data.SqlClient.SqlCommand();
		this.CitiesAdapter = new System.Data.SqlClient.SqlDataAdapter();
		this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand();
		this.sqlSelectCommand7 = new System.Data.SqlClient.SqlCommand();
		this.StateProvincesAdapter = new System.Data.SqlClient.SqlDataAdapter();
		this.sqlInsertCommand3 = new System.Data.SqlClient.SqlCommand();
		this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand();
		this.CountriesAdapter = new System.Data.SqlClient.SqlDataAdapter();
		this.sqlInsertCommand2 = new System.Data.SqlClient.SqlCommand();
		this.sqlSelectCommand4 = new System.Data.SqlClient.SqlCommand();
		this.PropertiesAdapter = new System.Data.SqlClient.SqlDataAdapter();
		this.sqlSelectCommand6 = new System.Data.SqlClient.SqlCommand();
		this.PropertiesFullSet = new Vacations.PropertiesFullDataset();
		((System.ComponentModel.ISupportInitialize)(this.RegionsSet)).BeginInit();
		((System.ComponentModel.ISupportInitialize)(this.StateProvincesSet)).BeginInit();
		((System.ComponentModel.ISupportInitialize)(this.AmenitiesSet)).BeginInit();
		((System.ComponentModel.ISupportInitialize)(this.CitiesSet)).BeginInit();
		((System.ComponentModel.ISupportInitialize)(this.CountriesSet)).BeginInit();
		((System.ComponentModel.ISupportInitialize)(this.AttractionsSet)).BeginInit();
		((System.ComponentModel.ISupportInitialize)(this.PropertiesFullSet)).BeginInit();
		// 
		// CommonFunctions.Connection
		// 
		//CommonFunctions.Connection.ConnectionString = "workstation id=MAIN;packet size=4096;integrated security=SSPI;data source=MAIN;pe" +
			//"rsist security info=False;initial catalog=Vacations";
		// 
		// RegionsSet
		// 
		this.RegionsSet.DataSetName = "RegionsDataset";
		this.RegionsSet.Locale = new System.Globalization.CultureInfo("en-US");
		// 
		// StateProvincesSet
		// 
		this.StateProvincesSet.DataSetName = "StateProvincesDataset";
		this.StateProvincesSet.Locale = new System.Globalization.CultureInfo("en-US");
		// 
		// AmenitiesSet
		// 
		this.AmenitiesSet.DataSetName = "AmenitiesDataset";
		this.AmenitiesSet.Locale = new System.Globalization.CultureInfo("en-US");
		// 
		// CitiesSet
		// 
		this.CitiesSet.DataSetName = "CitiesDataset";
		this.CitiesSet.Locale = new System.Globalization.CultureInfo("en-US");
		// 
		// CountriesSet
		// 
		this.CountriesSet.DataSetName = "CountriesDataset";
		this.CountriesSet.Locale = new System.Globalization.CultureInfo("en-US");
		// 
		// AttractionsSet
		// 
		this.AttractionsSet.DataSetName = "AttractionsDataset";
		this.AttractionsSet.Locale = new System.Globalization.CultureInfo("en-US");
		// 
		// AttractionsAdapter
		// 
		this.AttractionsAdapter.InsertCommand = this.sqlInsertCommand4;
		this.AttractionsAdapter.SelectCommand = this.sqlSelectCommand1;
		this.AttractionsAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																									 new System.Data.Common.DataTableMapping("Table", "Attractions", new System.Data.Common.DataColumnMapping[] {
																																																					new System.Data.Common.DataColumnMapping("ID", "ID"),
																																																					new System.Data.Common.DataColumnMapping("Attraction", "Attraction")})});
		// 
		// sqlInsertCommand4
		// 
		this.sqlInsertCommand4.CommandText = "INSERT INTO Attractions(ID, Attraction) VALUES (@ID, @Attraction)";
        this.sqlInsertCommand4.Connection = CommonFunctions.GetConnection();
		this.sqlInsertCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ID", System.Data.SqlDbType.Int, 4, "ID"));
		this.sqlInsertCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Attraction", System.Data.SqlDbType.NVarChar, 300, "Attraction"));
		// 
		// sqlSelectCommand1
		// 
		this.sqlSelectCommand1.CommandText = @"SELECT DISTINCT Attractions.ID, Attractions.Attraction FROM Attractions INNER JOIN PropertiesAttractions ON PropertiesAttractions.AttractionID = Attractions.ID INNER JOIN Properties ON PropertiesAttractions.PropertyID = Properties.ID WHERE (Properties.IfFinished = 1) AND (Properties.IfApproved = 1) UNION SELECT 0, 'All Attractions'";
        this.sqlSelectCommand1.Connection = CommonFunctions.GetConnection();
		// 
		// AmenitiesAdapter
		// 
		this.AmenitiesAdapter.InsertCommand = this.sqlInsertCommand5;
		this.AmenitiesAdapter.SelectCommand = this.sqlSelectCommand3;
		this.AmenitiesAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																								   new System.Data.Common.DataTableMapping("Table", "Amenities", new System.Data.Common.DataColumnMapping[] {
																																																				new System.Data.Common.DataColumnMapping("ID", "ID"),
																																																				new System.Data.Common.DataColumnMapping("Amenity", "Amenity")})});
		// 
		// sqlInsertCommand5
		// 
		this.sqlInsertCommand5.CommandText = "INSERT INTO Amenities(ID, Amenity) VALUES (@ID, @Amenity)";
        this.sqlInsertCommand5.Connection = CommonFunctions.GetConnection();
		this.sqlInsertCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ID", System.Data.SqlDbType.Int, 4, "ID"));
		this.sqlInsertCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Amenity", System.Data.SqlDbType.NVarChar, 300, "Amenity"));
		// 
		// sqlSelectCommand3
		// 
		this.sqlSelectCommand3.CommandText = @"SELECT DISTINCT Amenities.ID, Amenities.Amenity FROM Amenities INNER JOIN PropertiesAmenities ON PropertiesAmenities.AmenityID = Amenities.ID INNER JOIN Properties ON PropertiesAmenities.PropertyID = Properties.ID WHERE (Properties.IfFinished = 1) AND (Properties.IfApproved = 1) UNION SELECT 0, 'All Amenities'";
        this.sqlSelectCommand3.Connection = CommonFunctions.GetConnection();
		// 
		// RegionsAdapter
		// 
		this.RegionsAdapter.InsertCommand = this.sqlInsertCommand6;
		this.RegionsAdapter.SelectCommand = this.sqlSelectCommand5;
		this.RegionsAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																								 new System.Data.Common.DataTableMapping("Table", "Regions", new System.Data.Common.DataColumnMapping[] {
																																																			new System.Data.Common.DataColumnMapping("ID", "ID"),
																																																			new System.Data.Common.DataColumnMapping("Region", "Region")})});
		// 
		// sqlInsertCommand6
		// 
		this.sqlInsertCommand6.CommandText = "INSERT INTO Regions(Region) VALUES (@Region)";
        this.sqlInsertCommand6.Connection = CommonFunctions.GetConnection();
		this.sqlInsertCommand6.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Region", System.Data.SqlDbType.NVarChar, 300, "Region"));
		// 
		// sqlSelectCommand5
		// 
		this.sqlSelectCommand5.CommandText = @"SELECT DISTINCT Regions.ID, Regions.Region FROM Regions INNER JOIN Countries ON Regions.ID = Countries.RegionID INNER JOIN StateProvinces ON Countries.ID = StateProvinces.CountryID INNER JOIN Cities ON StateProvinces.ID = Cities.StateProvinceID INNER JOIN Properties ON Cities.ID = Properties.CityID WHERE (Properties.IfFinished = 1) AND (Properties.IfApproved = 1) ORDER BY Region";
        this.sqlSelectCommand5.Connection = CommonFunctions.GetConnection();
		// 
		// CitiesAdapter
		// 
		this.CitiesAdapter.InsertCommand = this.sqlInsertCommand1;
		this.CitiesAdapter.SelectCommand = this.sqlSelectCommand7;
		this.CitiesAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																								new System.Data.Common.DataTableMapping("Table", "Cities", new System.Data.Common.DataColumnMapping[] {
																																																		  new System.Data.Common.DataColumnMapping("ID", "ID"),
																																																		  new System.Data.Common.DataColumnMapping("StateProvinceID", "StateProvinceID"),
																																																		  new System.Data.Common.DataColumnMapping("City", "City")})});
		// 
		// sqlInsertCommand1
		// 
		this.sqlInsertCommand1.CommandText = "INSERT INTO Cities(StateProvinceID, City) VALUES (@StateProvinceID, @City)";
        this.sqlInsertCommand1.Connection = CommonFunctions.GetConnection();
		this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@StateProvinceID", System.Data.SqlDbType.Int, 4, "StateProvinceID"));
		this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@City", System.Data.SqlDbType.NVarChar, 300, "City"));
		// 
		// sqlSelectCommand7
		// 
		this.sqlSelectCommand7.CommandText = @"SELECT DISTINCT Cities.ID, Cities.StateProvinceID, Cities.City FROM Cities INNER JOIN Properties ON Cities.ID=Properties.CityID WHERE (Properties.IfFinished = 1) AND (Properties.IfApproved = 1) AND (StateProvinceID = @StateProvinceID) UNION SELECT 0, 0, ' Include All' ORDER BY City";
        this.sqlSelectCommand7.Connection = CommonFunctions.GetConnection();
		this.sqlSelectCommand7.Parameters.Add(new System.Data.SqlClient.SqlParameter("@StateProvinceID", System.Data.SqlDbType.Int, 4, "StateProvinceID"));
		// 
		// StateProvincesAdapter
		// 
		this.StateProvincesAdapter.InsertCommand = this.sqlInsertCommand3;
		this.StateProvincesAdapter.SelectCommand = this.sqlSelectCommand2;
		this.StateProvincesAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																										new System.Data.Common.DataTableMapping("Table", "StateProvinces", new System.Data.Common.DataColumnMapping[] {
																																																						  new System.Data.Common.DataColumnMapping("ID", "ID"),
																																																						  new System.Data.Common.DataColumnMapping("CountryID", "CountryID"),
																																																						  new System.Data.Common.DataColumnMapping("StateProvince", "StateProvince")})});
		// 
		// sqlInsertCommand3
		// 
		this.sqlInsertCommand3.CommandText = "INSERT INTO StateProvinces(CountryID, StateProvince) VALUES (@CountryID, @StatePr" +
			"ovince)";
        this.sqlInsertCommand3.Connection = CommonFunctions.GetConnection();
		this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CountryID", System.Data.SqlDbType.Int, 4, "CountryID"));
		this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@StateProvince", System.Data.SqlDbType.NVarChar, 300, "StateProvince"));
		// 
		// sqlSelectCommand2
		// 
		this.sqlSelectCommand2.CommandText = @"SELECT DISTINCT StateProvinces.ID, StateProvinces.CountryID, StateProvinces.StateProvince FROM StateProvinces INNER JOIN Cities ON StateProvinces.ID = Cities.StateProvinceID INNER JOIN Properties ON Cities.ID = Properties.CityID WHERE (Properties.IfFinished = 1) AND (Properties.IfApproved = 1) AND (StateProvinces.CountryID = @CountryID) ORDER BY StateProvince";
        this.sqlSelectCommand2.Connection = CommonFunctions.GetConnection();
		this.sqlSelectCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CountryID", System.Data.SqlDbType.Int, 4, "CountryID"));
		// 
		// CountriesAdapter
		// 
		this.CountriesAdapter.InsertCommand = this.sqlInsertCommand2;
		this.CountriesAdapter.SelectCommand = this.sqlSelectCommand4;
		this.CountriesAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																								   new System.Data.Common.DataTableMapping("Table", "Countries", new System.Data.Common.DataColumnMapping[] {
																																																				new System.Data.Common.DataColumnMapping("ID", "ID"),
																																																				new System.Data.Common.DataColumnMapping("RegionID", "RegionID"),
																																																				new System.Data.Common.DataColumnMapping("Country", "Country")})});
		// 
		// sqlInsertCommand2
		// 
		this.sqlInsertCommand2.CommandText = "INSERT INTO Countries(RegionID, Country) VALUES (@RegionID, @Country)";
        this.sqlInsertCommand2.Connection = CommonFunctions.GetConnection();
		this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RegionID", System.Data.SqlDbType.Int, 4, "RegionID"));
		this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Country", System.Data.SqlDbType.NVarChar, 300, "Country"));
		// 
		// sqlSelectCommand4
		// 
		this.sqlSelectCommand4.CommandText = @"SELECT DISTINCT Countries.ID, Countries.RegionID, Countries.Country FROM Countries INNER JOIN StateProvinces ON Countries.ID = StateProvinces.CountryID INNER JOIN Cities ON StateProvinces.ID = Cities.StateProvinceID INNER JOIN Properties ON Cities.ID = Properties.CityID WHERE (Properties.IfFinished = 1) AND (Properties.IfApproved = 1) AND (Countries.RegionID = @RegionID) ORDER By Country";
        this.sqlSelectCommand4.Connection = CommonFunctions.GetConnection();
		this.sqlSelectCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RegionID", System.Data.SqlDbType.Int, 4, "RegionID"));
		// 
		// PropertiesAdapter
		// 
		this.PropertiesAdapter.SelectCommand = this.sqlSelectCommand6;
		this.PropertiesAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																									new System.Data.Common.DataTableMapping("Table", "Properties", new System.Data.Common.DataColumnMapping[] {
																																																				  new System.Data.Common.DataColumnMapping("MinimumNightlyRental", "MinimumNightlyRental"),
																																																				  new System.Data.Common.DataColumnMapping("Type", "Type"),
																																																				  new System.Data.Common.DataColumnMapping("FirstName", "FirstName"),
																																																				  new System.Data.Common.DataColumnMapping("LastName", "LastName"),
																																																				  new System.Data.Common.DataColumnMapping("PrimaryTelephone", "PrimaryTelephone"),
																																																				  new System.Data.Common.DataColumnMapping("OwnerCountry", "OwnerCountry"),
																																																				  new System.Data.Common.DataColumnMapping("Email", "Email"),
																																																				  new System.Data.Common.DataColumnMapping("Username", "Username"),
																																																				  new System.Data.Common.DataColumnMapping("OwnerAddress", "OwnerAddress"),
																																																				  new System.Data.Common.DataColumnMapping("EveningTelephone", "EveningTelephone"),
																																																				  new System.Data.Common.DataColumnMapping("DaytimeTelephone", "DaytimeTelephone"),
																																																				  new System.Data.Common.DataColumnMapping("MobileTelephone", "MobileTelephone"),
																																																				  new System.Data.Common.DataColumnMapping("Website", "Website"),
																																																				  new System.Data.Common.DataColumnMapping("OwnerCity", "OwnerCity"),
																																																				  new System.Data.Common.DataColumnMapping("OwnerState", "OwnerState"),
																																																				  new System.Data.Common.DataColumnMapping("OwnerZip", "OwnerZip"),
																																																				  new System.Data.Common.DataColumnMapping("Registered", "Registered"),
																																																				  new System.Data.Common.DataColumnMapping("IfPayTravelAgents", "IfPayTravelAgents"),
																																																				  new System.Data.Common.DataColumnMapping("City", "City"),
																																																				  new System.Data.Common.DataColumnMapping("StateProvince", "StateProvince"),
																																																				  new System.Data.Common.DataColumnMapping("Country", "Country"),
																																																				  new System.Data.Common.DataColumnMapping("Region", "Region"),
																																																				  new System.Data.Common.DataColumnMapping("Smoking", "Smoking"),
																																																				  new System.Data.Common.DataColumnMapping("PetFriendly", "PetFriendly"),
																																																				  new System.Data.Common.DataColumnMapping("ID", "ID"),
																																																				  new System.Data.Common.DataColumnMapping("UserID", "UserID"),
																																																				  new System.Data.Common.DataColumnMapping("Name", "Name"),
																																																				  new System.Data.Common.DataColumnMapping("TypeID", "TypeID"),
																																																				  new System.Data.Common.DataColumnMapping("Address", "Address"),
																																																				  new System.Data.Common.DataColumnMapping("CityID", "CityID"),
																																																				  new System.Data.Common.DataColumnMapping("IfShowAddress", "IfShowAddress"),
																																																				  new System.Data.Common.DataColumnMapping("NumBedrooms", "NumBedrooms"),
																																																				  new System.Data.Common.DataColumnMapping("NumBaths", "NumBaths"),
																																																				  new System.Data.Common.DataColumnMapping("NumSleeps", "NumSleeps"),
																																																				  new System.Data.Common.DataColumnMapping("MinimumNightlyRentalID", "MinimumNightlyRentalID"),
																																																				  new System.Data.Common.DataColumnMapping("NumTVs", "NumTVs"),
																																																				  new System.Data.Common.DataColumnMapping("NumVCRs", "NumVCRs"),
																																																				  new System.Data.Common.DataColumnMapping("NumCDPlayers", "NumCDPlayers"),
																																																				  new System.Data.Common.DataColumnMapping("IfMoreThan7PhotosAllowed", "IfMoreThan7PhotosAllowed"),
																																																				  new System.Data.Common.DataColumnMapping("IfFinished", "IfFinished"),
																																																				  new System.Data.Common.DataColumnMapping("IfApproved", "IfApproved"),
																																																				  new System.Data.Common.DataColumnMapping("IfPaid", "IfPaid"),
																																																				  new System.Data.Common.DataColumnMapping("DateAdded", "DateAdded"),
																																																				  new System.Data.Common.DataColumnMapping("DateStartViewed", "DateStartViewed"),
																																																				  new System.Data.Common.DataColumnMapping("VirtualTour", "VirtualTour"),
																																																				  new System.Data.Common.DataColumnMapping("RatesTable", "RatesTable"),
																																																				  new System.Data.Common.DataColumnMapping("PricesCurrency", "PricesCurrency"),
																																																				  new System.Data.Common.DataColumnMapping("CheckIn", "CheckIn"),
																																																				  new System.Data.Common.DataColumnMapping("CheckOut", "CheckOut"),
																																																				  new System.Data.Common.DataColumnMapping("LodgingTax", "LodgingTax"),
																																																				  new System.Data.Common.DataColumnMapping("TaxIncluded", "TaxIncluded"),
																																																				  new System.Data.Common.DataColumnMapping("DateAvailable", "DateAvailable"),
																																																				  new System.Data.Common.DataColumnMapping("IfDiscounted", "IfDiscounted"),
																																																				  new System.Data.Common.DataColumnMapping("IfLastMinuteCancellations", "IfLastMinuteCancellations"),
																																																				  new System.Data.Common.DataColumnMapping("HomeExchangeCityID1", "HomeExchangeCityID1"),
																																																				  new System.Data.Common.DataColumnMapping("HomeExchangeCityID2", "HomeExchangeCityID2"),
																																																				  new System.Data.Common.DataColumnMapping("HomeExchangeCityID3", "HomeExchangeCityID3")})});
		// 
		// sqlSelectCommand6
		// 
		this.sqlSelectCommand6.CommandText = "SELECT MinimumNightlyRentalTypes.Name AS MinimumNightlyRental, PropertyTypes.Name" +
			" AS Type, Users.FirstName, Users.LastName, Users.PrimaryTelephone, Users.Country" +
			" AS OwnerCountry, Users.Email, Users.Username, Users.Address AS OwnerAddress, Us" +
			"ers.EveningTelephone, Users.DaytimeTelephone, Users.MobileTelephone, Users.Websi" +
			"te, Users.City AS OwnerCity, Users.State AS OwnerState, Users.Zip AS OwnerZip, U" +
			"sers.Registered, Users.IfPayTravelAgents, Cities.City, StateProvinces.StateProvi" +
			"nce, Countries.Country, Regions.Region, CASE WHEN EXISTS (SELECT * FROM Properti" +
			"esAmenities INNER JOIN Amenities ON PropertiesAmenities.AmenityID = Amenities.ID" +
			" WHERE (PropertiesAmenities.PropertyID = Properties.ID) AND (Amenities.Amenity =" +
			" \'Smoking Permitted\')) THEN \'Yes\' ELSE \'No\' END AS Smoking, CASE WHEN EXISTS (SE" +
			"LECT * FROM PropertiesAmenities INNER JOIN Amenities ON PropertiesAmenities.Amen" +
			"ityID = Amenities.ID WHERE (PropertiesAmenities.PropertyID = Properties.ID) AND " +
			"(Amenities.Amenity = \'Pet Friendly\')) THEN \'Yes\' ELSE \'No\' END AS PetFriendly, P" +
			"roperties.ID, Properties.UserID, Properties.Name, Properties.TypeID, Properties." +
			"Address, Properties.CityID, Properties.IfShowAddress, Properties.NumBedrooms, Pr" +
			"operties.NumBaths, Properties.NumSleeps, Properties.MinimumNightlyRentalID, Prop" +
			"erties.NumTVs, Properties.NumVCRs, Properties.NumCDPlayers, Properties.IfMoreTha" +
			"n7PhotosAllowed, Properties.IfFinished, Properties.IfApproved, CASE WHEN EXISTS " +
			"(SELECT * FROM Invoices WHERE (Invoices.PropertyID = Properties.ID) AND (PaymentAmount >= InvoiceAmount) AND (GETDATE() <= RenewalDate)" +
			") THEN 1 ELSE 0 END AS IfPaid, Properties.DateAdded, Properties.DateStartViewed," +
			" Properties.VirtualTour, Properties.RatesTable, Properties.PricesCurrency, Prope" +
			"rties.CheckIn, Properties.CheckOut, Properties.LodgingTax, Properties.TaxInclude" +
			"d, Properties.DateAvailable, Properties.IfDiscounted, Properties.IfLastMinuteCan" +
			"cellations, Properties.HomeExchangeCityID1, Properties.HomeExchangeCityID2, Prop" +
			"erties.HomeExchangeCityID3 FROM Properties INNER JOIN Cities ON Properties.CityI" +
			"D = Cities.ID INNER JOIN StateProvinces ON StateProvinces.ID = Cities.StateProvi" +
			"nceID INNER JOIN Countries ON StateProvinces.CountryID = Countries.ID INNER JOIN" +
			" Regions ON Countries.RegionID = Regions.ID INNER JOIN Users ON Properties.UserI" +
			"D = Users.ID LEFT OUTER JOIN MinimumNightlyRentalTypes ON Properties.MinimumNigh" +
			"tlyRentalID = MinimumNightlyRentalTypes.ID LEFT OUTER JOIN PropertyTypes ON Prop" +
			"erties.TypeID = PropertyTypes.ID WHERE (Properties.IfFinished = 1) AND (Properti" +
			"es.IfApproved = 1) AND (@RegionID = - 1 OR Regions.ID = @RegionID) AND (@Country" +
			"ID = - 1 OR Countries.ID = @CountryID) AND (@StateProvinceID = - 1 OR StateProvi" +
			"nces.ID = @StateProvinceID) AND (@CityID = - 1 OR Cities.ID = @CityID) AND (@Min" +
			"Bedrooms = - 1 OR Properties.NumBedrooms >= @MinBedrooms) AND (@MaxBedrooms = - " +
			"1 OR Properties.NumBedrooms <= @MaxBedrooms) AND (@MinSleeps = - 1 OR Properties" +
			".NumSleeps >= @MinSleeps) AND (@MaxSleeps = - 1 OR Properties.NumSleeps <= @MaxS" +
			"leeps)";
        this.sqlSelectCommand6.Connection = CommonFunctions.GetConnection();
		this.sqlSelectCommand6.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RegionID", System.Data.SqlDbType.Int, 4, "ID"));
		this.sqlSelectCommand6.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CountryID", System.Data.SqlDbType.Int, 4, "ID"));
		this.sqlSelectCommand6.Parameters.Add(new System.Data.SqlClient.SqlParameter("@StateProvinceID", System.Data.SqlDbType.Int, 4, "ID"));
		this.sqlSelectCommand6.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CityID", System.Data.SqlDbType.Int, 4, "ID"));
		this.sqlSelectCommand6.Parameters.Add(new System.Data.SqlClient.SqlParameter("@MinBedrooms", System.Data.SqlDbType.Int, 4, "NumBedrooms"));
		this.sqlSelectCommand6.Parameters.Add(new System.Data.SqlClient.SqlParameter("@MaxBedrooms", System.Data.SqlDbType.Int, 4, "NumBedrooms"));
		this.sqlSelectCommand6.Parameters.Add(new System.Data.SqlClient.SqlParameter("@MinSleeps", System.Data.SqlDbType.Int, 4, "NumSleeps"));
		this.sqlSelectCommand6.Parameters.Add(new System.Data.SqlClient.SqlParameter("@MaxSleeps", System.Data.SqlDbType.Int, 4, "NumSleeps"));
		// 
		// PropertiesFullSet
		// 
		this.PropertiesFullSet.DataSetName = "PropertiesFullDataset";
		this.PropertiesFullSet.Locale = new System.Globalization.CultureInfo("en-US");
		((System.ComponentModel.ISupportInitialize)(this.RegionsSet)).EndInit();
		((System.ComponentModel.ISupportInitialize)(this.StateProvincesSet)).EndInit();
		((System.ComponentModel.ISupportInitialize)(this.AmenitiesSet)).EndInit();
		((System.ComponentModel.ISupportInitialize)(this.CitiesSet)).EndInit();
		((System.ComponentModel.ISupportInitialize)(this.CountriesSet)).EndInit();
		((System.ComponentModel.ISupportInitialize)(this.AttractionsSet)).EndInit();
		((System.ComponentModel.ISupportInitialize)(this.PropertiesFullSet)).EndInit();

	}