/// <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.PhotosAdapter = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
this.PhotosSet = new Vacations.PhotosDataset();
this.PropertiesAdapter = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand();
this.PropertiesSet = new Vacations.PropertiesDataset();
this.sqlSelectCommand3 = new System.Data.SqlClient.SqlCommand();
((System.ComponentModel.ISupportInitialize)(this.PhotosSet)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.PropertiesSet)).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";
//
// PhotosAdapter
//
this.PhotosAdapter.SelectCommand = this.sqlSelectCommand1;
this.PhotosAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "PropertyPhotos", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("ID", "ID"),
new System.Data.Common.DataColumnMapping("PropertyID", "PropertyID"),
new System.Data.Common.DataColumnMapping("FileName", "FileName"),
new System.Data.Common.DataColumnMapping("Width", "Width"),
new System.Data.Common.DataColumnMapping("Height", "Height"),
new System.Data.Common.DataColumnMapping("OrderNumber", "OrderNumber")
})
});
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT ID, PropertyID, FileName, Width, Height, OrderNumber FROM PropertyPhotos W" +
"HERE (ID = @PhotoID)";
this.sqlSelectCommand1.Connection = CommonFunctions.GetConnection();
this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@PhotoID", System.Data.SqlDbType.Int, 4, "ID"));
//
// PhotosSet
//
this.PhotosSet.DataSetName = "PhotosDataset";
this.PhotosSet.Locale = new System.Globalization.CultureInfo("en-US");
//
// PropertiesAdapter
//
this.PropertiesAdapter.SelectCommand = this.sqlSelectCommand3;
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("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("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("IfApproved", "IfApproved"),
new System.Data.Common.DataColumnMapping("CityID", "CityID"),
new System.Data.Common.DataColumnMapping("IfFinished", "IfFinished"),
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("LastMinuteComments", "LastMinuteComments"),
new System.Data.Common.DataColumnMapping("HomeExchangeCityID1", "HomeExchangeCityID1"),
new System.Data.Common.DataColumnMapping("HomeExchangeCityID2", "HomeExchangeCityID2"),
new System.Data.Common.DataColumnMapping("HomeExchangeCityID3", "HomeExchangeCityID3")
})
});
//
// PropertiesSet
//
this.PropertiesSet.DataSetName = "PropertiesDataset";
this.PropertiesSet.Locale = new System.Globalization.CultureInfo("en-US");
//
// sqlSelectCommand3
//
this.sqlSelectCommand3.CommandText = @"SELECT ID, UserID, Name, TypeID, Address, IfShowAddress, NumBedrooms, NumBaths, NumSleeps, MinimumNightlyRentalID, NumTVs, NumVCRs, NumCDPlayers, Description, Amenities, LocalAttractions, Rates, CancellationPolicy, DepositRequired, IfMoreThan7PhotosAllowed, IfApproved, CityID, IfFinished, DateAdded, DateStartViewed, VirtualTour, RatesTable, PricesCurrency, CheckIn, CheckOut, LodgingTax, TaxIncluded, DateAvailable, IfDiscounted, IfLastMinuteCancellations, LastMinuteComments, HomeExchangeCityID1, HomeExchangeCityID2, HomeExchangeCityID3 FROM Properties WHERE (ID = @PropertyID)";
this.sqlSelectCommand3.Connection = CommonFunctions.GetConnection();
this.sqlSelectCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@PropertyID", System.Data.SqlDbType.Int, 4, "ID"));
((System.ComponentModel.ISupportInitialize)(this.PhotosSet)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.PropertiesSet)).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.PhotosSet = new Vacations.PhotosDataset();
this.PropertiesFullSet = new Vacations.PropertiesFullDataset();
this.PropertiesAdapter = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
this.PhotosAdapter = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand();
this.EmailsAdapter = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand3 = new System.Data.SqlClient.SqlCommand();
this.EmailsSet = new Vacations.EmailsDataset();
((System.ComponentModel.ISupportInitialize)(this.PhotosSet)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.PropertiesFullSet)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.EmailsSet)).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";
//
// PhotosSet
//
this.PhotosSet.DataSetName = "PhotosDataset";
this.PhotosSet.Locale = new System.Globalization.CultureInfo("en-US");
//
// PropertiesFullSet
//
this.PropertiesFullSet.DataSetName = "PropertiesFullDataset";
this.PropertiesFullSet.Locale = new System.Globalization.CultureInfo("en-US");
//
// PropertiesAdapter
//
this.PropertiesAdapter.SelectCommand = this.sqlSelectCommand1;
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("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"),
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")
})
});
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.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, Users.TouristBoard, 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 (Properties.ID = @PropertyID)";
this.sqlSelectCommand1.Connection = CommonFunctions.GetConnection();
this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@PropertyID", System.Data.SqlDbType.Int, 4, "ID"));
//
// PhotosAdapter
//
this.PhotosAdapter.SelectCommand = this.sqlSelectCommand2;
this.PhotosAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "PropertyPhotos", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("ID", "ID"),
new System.Data.Common.DataColumnMapping("PropertyID", "PropertyID"),
new System.Data.Common.DataColumnMapping("FileName", "FileName"),
new System.Data.Common.DataColumnMapping("OrderNumber", "OrderNumber"),
new System.Data.Common.DataColumnMapping("Width", "Width"),
new System.Data.Common.DataColumnMapping("Height", "Height")
})
});
//
// sqlSelectCommand2
//
this.sqlSelectCommand2.CommandText = "SELECT TOP 1 ID, PropertyID, FileName, OrderNumber, Width, Height FROM PropertyPh" +
"otos WHERE (PropertyID = @PropertyID) ORDER BY OrderNumber";
this.sqlSelectCommand2.Connection = CommonFunctions.GetConnection();
this.sqlSelectCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@PropertyID", System.Data.SqlDbType.Int, 4, "PropertyID"));
//
// EmailsAdapter
//
this.EmailsAdapter.SelectCommand = this.sqlSelectCommand3;
this.EmailsAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Emails", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("ID", "ID"),
new System.Data.Common.DataColumnMapping("PropertyID", "PropertyID"),
new System.Data.Common.DataColumnMapping("DateTime", "DateTime"),
new System.Data.Common.DataColumnMapping("ContactName", "ContactName"),
new System.Data.Common.DataColumnMapping("ContactEmail", "ContactEmail"),
new System.Data.Common.DataColumnMapping("ContactTelephone", "ContactTelephone"),
new System.Data.Common.DataColumnMapping("ArrivalDate", "ArrivalDate"),
new System.Data.Common.DataColumnMapping("DepartureDate", "DepartureDate"),
new System.Data.Common.DataColumnMapping("Nights", "Nights"),
new System.Data.Common.DataColumnMapping("Adults", "Adults"),
new System.Data.Common.DataColumnMapping("Children", "Children"),
new System.Data.Common.DataColumnMapping("Telephone", "Telephone"),
new System.Data.Common.DataColumnMapping("Telephone2", "Telephone2"),
new System.Data.Common.DataColumnMapping("Notes", "Notes"),
new System.Data.Common.DataColumnMapping("Email", "Email"),
new System.Data.Common.DataColumnMapping("IfCustom", "IfCustom")
})
});
//
// sqlSelectCommand3
//
this.sqlSelectCommand3.CommandText = "SELECT ID, PropertyID, DateTime, ContactName, ContactEmail, ContactTelephone, Arr" +
"ivalDate, DepartureDate, Nights, Adults, Children, Telephone, Telephone2, Notes," +
" Email, IfCustom FROM Emails";
this.sqlSelectCommand3.Connection = CommonFunctions.GetConnection();
//
// EmailsSet
//
this.EmailsSet.DataSetName = "EmailsDataset";
this.EmailsSet.Locale = new System.Globalization.CultureInfo("en-US");
((System.ComponentModel.ISupportInitialize)(this.PhotosSet)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.PropertiesFullSet)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.EmailsSet)).EndInit();
}
