/// <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.EmailsSet = new Vacations.EmailsDataset(); this.EmailsAdapter = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand(); ((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"; // // EmailsSet // this.EmailsSet.DataSetName = "EmailsDataset"; this.EmailsSet.Locale = new System.Globalization.CultureInfo("en-US"); // // EmailsAdapter // this.EmailsAdapter.SelectCommand = this.sqlSelectCommand1; 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") }) }); // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = @"SELECT ID, PropertyID, DateTime, ContactName, ContactEmail, ContactTelephone, ArrivalDate, DepartureDate, Nights, Adults, Children, Telephone, Telephone2, Notes, Email, IfCustom FROM Emails WHERE (PropertyID = @PropertyID) AND (DATEDIFF(dd, DateTime, GETDATE()) < 356) ORDER BY DateTime DESC"; this.sqlSelectCommand1.Connection = CommonFunctions.GetConnection(); this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@PropertyID", System.Data.SqlDbType.Int, 4, "PropertyID")); ((System.ComponentModel.ISupportInitialize)(this.EmailsSet)).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(); }