/// <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();
}
/// <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();
}
/// <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();
}