Okay, let's start by setting up the database scripts and the core project structure. First, the database scripts: -- SQL Server Script for Session1 Database -- Create Database if it doesn't exist IF NOT EXISTS (SELECT * FROM sys.databases WHERE name = 'Session1') BEGIN CREATE DATABASE Session1; END GO USE Session1; GO -- Drop existing tables in reverse order of dependency IF OBJECT_ID('dbo.ItemAttractions', 'U') IS NOT NULL DROP TABLE dbo.ItemAttractions; IF OBJECT_ID('dbo.ItemAmenities', 'U') IS NOT NULL DROP TABLE dbo.ItemAmenities; IF OBJECT_ID('dbo.Amenities', 'U') IS NOT NULL DROP TABLE dbo.Amenities; IF OBJECT_ID('dbo.Attractions', 'U') IS NOT NULL DROP TABLE dbo.Attractions; IF OBJECT_ID('dbo.Items', 'U') IS NOT NULL DROP TABLE dbo.Items; IF OBJECT_ID('dbo.ItemTypes', 'U') IS NOT NULL DROP TABLE dbo.ItemTypes; IF OBJECT_ID('dbo.Areas', 'U') IS NOT NULL DROP TABLE dbo.Areas; IF OBJECT_ID('dbo.Users', 'U') IS NOT NULL DROP TABLE dbo.Users; IF OBJECT_ID('dbo.UserTypes', 'U') IS NOT NULL DROP TABLE dbo.UserTypes; GO -- Create UserTypes Table CREATE TABLE UserTypes ( ID INT PRIMARY KEY IDENTITY(1,1), Name NVARCHAR(50) NOT NULL UNIQUE ); GO -- Create Users Table CREATE TABLE Users ( ID INT PRIMARY KEY IDENTITY(1,1), GUID UNIQUEIDENTIFIER NOT NULL DEFAULT NEWID(), Username NVARCHAR(100) NOT NULL UNIQUE, Password NVARCHAR(255) NOT NULL, -- Store hashed passwords in a real application FullName NVARCHAR(150) NOT NULL, BirthDate DATE NOT NULL, Gender BIT NOT NULL, -- 0 for Male, 1 for Female, or adjust as needed Email NVARCHAR(150) NULL UNIQUE, Phone NVARCHAR(20) NULL, UserTypeID INT NOT NULL, FOREIGN KEY (UserTypeID) REFERENCES UserTypes(ID) ); GO -- Create Areas Table CREATE TABLE Areas ( ID INT PRIMARY KEY IDENTITY(1,1), Name NVARCHAR(100) NOT NULL UNIQUE ); GO -- Create ItemTypes Table CREATE TABLE ItemTypes ( ID INT PRIMARY KEY IDENTITY(1,1), Name NVARCHAR(50) NOT NULL UNIQUE ); GO -- Create Items Table CREATE TABLE Items ( ID INT PRIMARY KEY IDENTITY(1,1), GUID UNIQUEIDENTIFIER NOT NULL DEFAULT NEWID(), UserID INT NOT NULL, ItemTypeID INT NOT NULL, AreaID INT NOT NULL, Title NVARCHAR(255) NOT NULL, Capacity INT NOT NULL, NumberOfBeds INT NOT NULL, NumberOfBedrooms INT NOT NULL, NumberOfBathrooms INT NOT NULL, ExactAddress NVARCHAR(500) NULL, ApproximateAddress NVARCHAR(255) NULL, Description NVARCHAR(MAX) NULL, HostRules NVARCHAR(MAX) NULL, MinimumNights INT NOT NULL DEFAULT 1, MaximumNights INT NOT NULL DEFAULT 0, -- 0 might mean no maximum Price DECIMAL(10, 2) NOT NULL, Latitude DECIMAL(9, 6) NULL, Longitude DECIMAL(9, 6) NULL, CheckInTime TIME NULL DEFAULT '14:00:00', CheckOutTime TIME NULL DEFAULT '12:00:00', ReservationCount INT NOT NULL DEFAULT 0, FOREIGN KEY (UserID) REFERENCES Users(ID), FOREIGN KEY (ItemTypeID) REFERENCES ItemTypes(ID), FOREIGN KEY (AreaID) REFERENCES Areas(ID) ); GO -- Create Amenities Table CREATE TABLE Amenities ( ID INT PRIMARY KEY IDENTITY(1,1), Name NVARCHAR(100) NOT NULL UNIQUE, IconPath NVARCHAR(255) NULL -- Optional path to an icon file ); GO -- Create ItemAmenities Junction Table CREATE TABLE ItemAmenities ( ID INT PRIMARY KEY IDENTITY(1,1), ItemID INT NOT NULL, AmenityID INT NOT NULL, FOREIGN KEY (ItemID) REFERENCES Items(ID) ON DELETE CASCADE, FOREIGN KEY (AmenityID) REFERENCES Amenities(ID) ON DELETE CASCADE, UNIQUE (ItemID, AmenityID) -- Ensure no duplicate amenities per item ); GO -- Create Attractions Table CREATE TABLE Attractions ( ID INT PRIMARY KEY IDENTITY(1,1), Name NVARCHAR(150) NOT NULL UNIQUE, AreaID INT NOT NULL, Description NVARCHAR(MAX) NULL, Latitude DECIMAL(9, 6) NULL, Longitude DECIMAL(9, 6) NULL, FOREIGN KEY (AreaID) REFERENCES Areas(ID) ); GO -- Create ItemAttractions Junction Table CREATE TABLE ItemAttractions ( ID INT PRIMARY KEY IDENTITY(1,1), ItemID INT NOT NULL, AttractionID INT NOT NULL, Distance DECIMAL(6, 2) NOT NULL, -- Distance in KM DurationOnFoot INT NULL, -- Duration in minutes DurationByCar INT NULL, -- Duration in minutes FOREIGN KEY (ItemID) REFERENCES Items(ID) ON DELETE CASCADE, FOREIGN KEY (AttractionID) REFERENCES Attractions(ID) ON DELETE CASCADE, UNIQUE (ItemID, AttractionID) -- Ensure no duplicate attractions per item ); GO -- Insert Sample Data (Optional but Recommended) -- User Types INSERT INTO UserTypes (Name) VALUES ('Traveler'), ('Owner'), ('Manager'), ('Administrator'); GO -- Sample Users (Passwords should be hashed in reality) INSERT INTO Users (Username, Password, FullName, BirthDate, Gender, UserTypeID) VALUES ('traveler1', 'pass123', 'Alice Wonderland', '1995-03-15', 1, (SELECT ID FROM UserTypes WHERE Name = 'Traveler')), ('owner1', 'pass456', 'Bob The Builder', '1980-07-21', 0, (SELECT ID FROM UserTypes WHERE Name = 'Owner')), ('manager1', 'pass789', 'Charlie Chaplin', '1975-11-01', 0, (SELECT ID FROM UserTypes WHERE Name = 'Manager')); GO -- Sample Areas INSERT INTO Areas (Name) VALUES ('Gangnam'), ('Hongdae'), ('Myeongdong'), ('Itaewon'), ('Jongno'); GO -- Sample Item Types INSERT INTO ItemTypes (Name) VALUES ('Apartment'), ('House'), ('Studio'), ('Guesthouse'), ('Hotel Room'); GO -- Sample Amenities INSERT INTO Amenities (Name) VALUES ('Wi-Fi'), ('Kitchen'), ('Air Conditioning'), ('Heating'), ('Washer'), ('Dryer'), ('TV'), ('Free Parking'), ('Gym'), ('Pool'); GO -- Sample Attractions INSERT INTO Attractions (Name, AreaID) VALUES ('COEX Aquarium', (SELECT ID FROM Areas WHERE Name = 'Gangnam')), ('Gangnam Style Horse Dance Stage', (SELECT ID FROM Areas WHERE Name = 'Gangnam')), ('Hongik University Street', (SELECT ID FROM Areas WHERE Name = 'Hongdae')), ('Trickeye Museum Seoul', (SELECT ID FROM Areas WHERE Name = 'Hongdae')), ('Myeongdong Shopping Street', (SELECT ID FROM Areas WHERE Name = 'Myeongdong')), ('N Seoul Tower', (SELECT ID FROM Areas WHERE Name = 'Myeongdong')), -- Technically closer to Myeongdong/Itaewon border ('Itaewon Antique Furniture Street', (SELECT ID FROM Areas WHERE Name = 'Itaewon')), ('Gyeongbokgung Palace', (SELECT ID FROM Areas WHERE Name = 'Jongno')), ('Bukchon Hanok Village', (SELECT ID FROM Areas WHERE Name = 'Jongno')); GO -- Sample Items (Associate with owner1) DECLARE @OwnerUserID INT = (SELECT ID FROM Users WHERE Username = 'owner1'); DECLARE @ApartmentTypeID INT = (SELECT ID FROM ItemTypes WHERE Name = 'Apartment'); DECLARE @HouseTypeID INT = (SELECT ID FROM ItemTypes WHERE Name = 'House'); DECLARE @GangnamAreaID INT = (SELECT ID FROM Areas WHERE Name = 'Gangnam'); DECLARE @HongdaeAreaID INT = (SELECT ID FROM Areas WHERE Name = 'Hongdae'); INSERT INTO Items (UserID, ItemTypeID, AreaID, Title, Capacity, NumberOfBeds, NumberOfBedrooms, NumberOfBathrooms, MinimumNights, MaximumNights, Price) VALUES (@OwnerUserID, @ApartmentTypeID, @GangnamAreaID, 'Luxury Gangnam Apt near COEX', 4, 2, 2, 1, 3, 30, 150.00), (@OwnerUserID, @HouseTypeID, @HongdaeAreaID, 'Cozy House near Hongdae Station', 6, 4, 3, 2, 2, 0, 120.50); GO -- Sample Item Amenities DECLARE @Item1ID INT = (SELECT ID FROM Items WHERE Title = 'Luxury Gangnam Apt near COEX'); DECLARE @Item2ID INT = (SELECT ID FROM Items WHERE Title = 'Cozy House near Hongdae Station'); DECLARE @WifiID INT = (SELECT ID FROM Amenities WHERE Name = 'Wi-Fi'); DECLARE @KitchenID INT = (SELECT ID FROM Amenities WHERE Name = 'Kitchen'); DECLARE @ACID INT = (SELECT ID FROM Amenities WHERE Name = 'Air Conditioning'); DECLARE @ParkingID INT = (SELECT ID FROM Amenities WHERE Name = 'Free Parking'); INSERT INTO ItemAmenities (ItemID, AmenityID) VALUES (@Item1ID, @WifiID), (@Item1ID, @KitchenID), (@Item1ID, @ACID), (@Item1ID, @ParkingID), (@Item2ID, @WifiID), (@Item2ID, @KitchenID), (@Item2ID, @ACID); GO -- Sample Item Attractions DECLARE @COEXAttractionID INT = (SELECT ID FROM Attractions WHERE Name = 'COEX Aquarium'); DECLARE @GangnamStageAttractionID INT = (SELECT ID FROM Attractions WHERE Name = 'Gangnam Style Horse Dance Stage'); DECLARE @HongdaeStreetAttractionID INT = (SELECT ID FROM Attractions WHERE Name = 'Hongik University Street'); DECLARE @TrickeyeAttractionID INT = (SELECT ID FROM Attractions WHERE Name = 'Trickeye Museum Seoul'); INSERT INTO ItemAttractions (ItemID, AttractionID, Distance, DurationOnFoot, DurationByCar) VALUES (@Item1ID, @COEXAttractionID, 0.8, 10, 5), (@Item1ID, @GangnamStageAttractionID, 1.5, 20, 8), (@Item2ID, @HongdaeStreetAttractionID, 0.5, 7, 3), (@Item2ID, @TrickeyeAttractionID, 0.7, 9, 4); GO PRINT 'Session1 Database for SQL Server created and populated successfully.'; -- MySQL Script for Session1 Database -- Create Database if it doesn't exist CREATE DATABASE IF NOT EXISTS Session1 CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; USE Session1; -- Drop existing tables in reverse order of dependency SET FOREIGN_KEY_CHECKS = 0; -- Disable foreign key checks temporarily DROP TABLE IF EXISTS ItemAttractions; DROP TABLE IF EXISTS ItemAmenities; DROP TABLE IF EXISTS Amenities; DROP TABLE IF EXISTS Attractions; DROP TABLE IF EXISTS Items; DROP TABLE IF EXISTS ItemTypes; DROP TABLE IF EXISTS Areas; DROP TABLE IF EXISTS Users; DROP TABLE IF EXISTS UserTypes; SET FOREIGN_KEY_CHECKS = 1; -- Re-enable foreign key checks -- Create UserTypes Table CREATE TABLE UserTypes ( ID INT AUTO_INCREMENT PRIMARY KEY, Name VARCHAR(50) NOT NULL UNIQUE ); -- Create Users Table CREATE TABLE Users ( ID INT AUTO_INCREMENT PRIMARY KEY, GUID CHAR(36) NOT NULL DEFAULT (UUID()), Username VARCHAR(100) NOT NULL UNIQUE, Password VARCHAR(255) NOT NULL, -- Store hashed passwords in a real application FullName VARCHAR(150) NOT NULL, BirthDate DATE NOT NULL, Gender BOOLEAN NOT NULL, -- 0 for Male, 1 for Female, or adjust as needed Email VARCHAR(150) NULL UNIQUE, Phone VARCHAR(20) NULL, UserTypeID INT NOT NULL, FOREIGN KEY (UserTypeID) REFERENCES UserTypes(ID) ); -- Create Areas Table CREATE TABLE Areas ( ID INT AUTO_INCREMENT PRIMARY KEY, Name VARCHAR(100) NOT NULL UNIQUE ); -- Create ItemTypes Table CREATE TABLE ItemTypes ( ID INT AUTO_INCREMENT PRIMARY KEY, Name VARCHAR(50) NOT NULL UNIQUE ); -- Create Items Table CREATE TABLE Items ( ID INT AUTO_INCREMENT PRIMARY KEY, GUID CHAR(36) NOT NULL DEFAULT (UUID()), UserID INT NOT NULL, ItemTypeID INT NOT NULL, AreaID INT NOT NULL, Title VARCHAR(255) NOT NULL, Capacity INT NOT NULL, NumberOfBeds INT NOT NULL, NumberOfBedrooms INT NOT NULL, NumberOfBathrooms INT NOT NULL, ExactAddress VARCHAR(500) NULL, ApproximateAddress VARCHAR(255) NULL, Description TEXT NULL, HostRules TEXT NULL, MinimumNights INT NOT NULL DEFAULT 1, MaximumNights INT NOT NULL DEFAULT 0, -- 0 might mean no maximum Price DECIMAL(10, 2) NOT NULL, Latitude DECIMAL(9, 6) NULL, Longitude DECIMAL(9, 6) NULL, CheckInTime TIME NULL DEFAULT '14:00:00', CheckOutTime TIME NULL DEFAULT '12:00:00', ReservationCount INT NOT NULL DEFAULT 0, FOREIGN KEY (UserID) REFERENCES Users(ID), FOREIGN KEY (ItemTypeID) REFERENCES ItemTypes(ID), FOREIGN KEY (AreaID) REFERENCES Areas(ID) ); -- Create Amenities Table CREATE TABLE Amenities ( ID INT AUTO_INCREMENT PRIMARY KEY, Name VARCHAR(100) NOT NULL UNIQUE, IconPath VARCHAR(255) NULL -- Optional path to an icon file ); -- Create ItemAmenities Junction Table CREATE TABLE ItemAmenities ( ID INT AUTO_INCREMENT PRIMARY KEY, ItemID INT NOT NULL, AmenityID INT NOT NULL, FOREIGN KEY (ItemID) REFERENCES Items(ID) ON DELETE CASCADE, FOREIGN KEY (AmenityID) REFERENCES Amenities(ID) ON DELETE CASCADE, UNIQUE KEY `UQ_Item_Amenity` (ItemID, AmenityID) -- Ensure no duplicate amenities per item ); -- Create Attractions Table CREATE TABLE Attractions ( ID INT AUTO_INCREMENT PRIMARY KEY, Name VARCHAR(150) NOT NULL UNIQUE, AreaID INT NOT NULL, Description TEXT NULL, Latitude DECIMAL(9, 6) NULL, Longitude DECIMAL(9, 6) NULL, FOREIGN KEY (AreaID) REFERENCES Areas(ID) ); -- Create ItemAttractions Junction Table CREATE TABLE ItemAttractions ( ID INT AUTO_INCREMENT PRIMARY KEY, ItemID INT NOT NULL, AttractionID INT NOT NULL, Distance DECIMAL(6, 2) NOT NULL, -- Distance in KM DurationOnFoot INT NULL, -- Duration in minutes DurationByCar INT NULL, -- Duration in minutes FOREIGN KEY (ItemID) REFERENCES Items(ID) ON DELETE CASCADE, FOREIGN KEY (AttractionID) REFERENCES Attractions(ID) ON DELETE CASCADE, UNIQUE KEY `UQ_Item_Attraction` (ItemID, AttractionID) -- Ensure no duplicate attractions per item ); -- Insert Sample Data (Optional but Recommended) -- User Types INSERT INTO UserTypes (Name) VALUES ('Traveler'), ('Owner'), ('Manager'), ('Administrator'); -- Sample Users (Passwords should be hashed in reality) INSERT INTO Users (Username, Password, FullName, BirthDate, Gender, UserTypeID) VALUES ('traveler1', 'pass123', 'Alice Wonderland', '1995-03-15', 1, (SELECT ID FROM UserTypes WHERE Name = 'Traveler')), ('owner1', 'pass456', 'Bob The Builder', '1980-07-21', 0, (SELECT ID FROM UserTypes WHERE Name = 'Owner')), ('manager1', 'pass789', 'Charlie Chaplin', '1975-11-01', 0, (SELECT ID FROM UserTypes WHERE Name = 'Manager')); -- Sample Areas INSERT INTO Areas (Name) VALUES ('Gangnam'), ('Hongdae'), ('Myeongdong'), ('Itaewon'), ('Jongno'); -- Sample Item Types INSERT INTO ItemTypes (Name) VALUES ('Apartment'), ('House'), ('Studio'), ('Guesthouse'), ('Hotel Room'); -- Sample Amenities INSERT INTO Amenities (Name) VALUES ('Wi-Fi'), ('Kitchen'), ('Air Conditioning'), ('Heating'), ('Washer'), ('Dryer'), ('TV'), ('Free Parking'), ('Gym'), ('Pool'); -- Sample Attractions INSERT INTO Attractions (Name, AreaID) VALUES ('COEX Aquarium', (SELECT ID FROM Areas WHERE Name = 'Gangnam')), ('Gangnam Style Horse Dance Stage', (SELECT ID FROM Areas WHERE Name = 'Gangnam')), ('Hongik University Street', (SELECT ID FROM Areas WHERE Name = 'Hongdae')), ('Trickeye Museum Seoul', (SELECT ID FROM Areas WHERE Name = 'Hongdae')), ('Myeongdong Shopping Street', (SELECT ID FROM Areas WHERE Name = 'Myeongdong')), ('N Seoul Tower', (SELECT ID FROM Areas WHERE Name = 'Myeongdong')), -- Technically closer to Myeongdong/Itaewon border ('Itaewon Antique Furniture Street', (SELECT ID FROM Areas WHERE Name = 'Itaewon')), ('Gyeongbokgung Palace', (SELECT ID FROM Areas WHERE Name = 'Jongno')), ('Bukchon Hanok Village', (SELECT ID FROM Areas WHERE Name = 'Jongno')); -- Sample Items (Associate with owner1) SET @OwnerUserID = (SELECT ID FROM Users WHERE Username = 'owner1'); SET @ApartmentTypeID = (SELECT ID FROM ItemTypes WHERE Name = 'Apartment'); SET @HouseTypeID = (SELECT ID FROM ItemTypes WHERE Name = 'House'); SET @GangnamAreaID = (SELECT ID FROM Areas WHERE Name = 'Gangnam'); SET @HongdaeAreaID = (SELECT ID FROM Areas WHERE Name = 'Hongdae'); INSERT INTO Items (UserID, ItemTypeID, AreaID, Title, Capacity, NumberOfBeds, NumberOfBedrooms, NumberOfBathrooms, MinimumNights, MaximumNights, Price) VALUES (@OwnerUserID, @ApartmentTypeID, @GangnamAreaID, 'Luxury Gangnam Apt near COEX', 4, 2, 2, 1, 3, 30, 150.00), (@OwnerUserID, @HouseTypeID, @HongdaeAreaID, 'Cozy House near Hongdae Station', 6, 4, 3, 2, 2, 0, 120.50); -- Sample Item Amenities SET @Item1ID = (SELECT ID FROM Items WHERE Title = 'Luxury Gangnam Apt near COEX'); SET @Item2ID = (SELECT ID FROM Items WHERE Title = 'Cozy House near Hongdae Station'); SET @WifiID = (SELECT ID FROM Amenities WHERE Name = 'Wi-Fi'); SET @KitchenID = (SELECT ID FROM Amenities WHERE Name = 'Kitchen'); SET @ACID = (SELECT ID FROM Amenities WHERE Name = 'Air Conditioning'); SET @ParkingID = (SELECT ID FROM Amenities WHERE Name = 'Free Parking'); INSERT INTO ItemAmenities (ItemID, AmenityID) VALUES (@Item1ID, @WifiID), (@Item1ID, @KitchenID), (@Item1ID, @ACID), (@Item1ID, @ParkingID), (@Item2ID, @WifiID), (@Item2ID, @KitchenID), (@Item2ID, @ACID); -- Sample Item Attractions SET @COEXAttractionID = (SELECT ID FROM Attractions WHERE Name = 'COEX Aquarium'); SET @GangnamStageAttractionID = (SELECT ID FROM Attractions WHERE Name = 'Gangnam Style Horse Dance Stage'); SET @HongdaeStreetAttractionID = (SELECT ID FROM Attractions WHERE Name = 'Hongik University Street'); SET @TrickeyeAttractionID = (SELECT ID FROM Attractions WHERE Name = 'Trickeye Museum Seoul'); INSERT INTO ItemAttractions (ItemID, AttractionID, Distance, DurationOnFoot, DurationByCar) VALUES (@Item1ID, @COEXAttractionID, 0.8, 10, 5), (@Item1ID, @GangnamStageAttractionID, 1.5, 20, 8), (@Item2ID, @HongdaeStreetAttractionID, 0.5, 7, 3), (@Item2ID, @TrickeyeAttractionID, 0.7, 9, 4); SELECT 'Session1 Database for MySQL created and populated successfully.' AS Status; Seoul Stay Platform - Terms and Conditions Welcome to Seoul Stay! By creating an account and using our platform, you agree to comply with and be bound by the following terms and conditions of use. Please review these terms carefully. If you do not agree to these terms, you should not use this platform. 1. Account Registration: You must provide accurate and complete information during registration. You are responsible for maintaining the confidentiality of your account password and for all activities that occur under your account. You agree to notify us immediately of any unauthorized use of your account. Users must be 18 years or older. 2. User Conduct: You agree to use the platform only for lawful purposes. You are prohibited from posting on or transmitting through the platform any unlawful, harmful, threatening, abusive, harassing, defamatory, vulgar, obscene, sexually explicit, profane, hateful, fraudulent, racially, ethnically, or otherwise objectionable material of any kind. 3. Listings: Owners and Managers are responsible for the accuracy and content of their listings. All listed properties must comply with local laws and regulations. Misleading information or fraudulent listings are strictly prohibited. 4. Bookings and Payments: Travelers agree to pay all fees associated with their bookings. Owners/Managers agree to honor confirmed bookings. Cancellation policies are set by the Owner/Manager and must be clearly stated in the listing. 5. Privacy: Your use of the platform is also governed by our Privacy Policy (link to be provided). We are committed to protecting your privacy. 6. Disclaimers: The platform is provided "as is". We make no warranties, expressed or implied, regarding the operation of the platform or the information, content, materials, or products included. We disclaim all warranties to the full extent permissible by applicable law. 7. Limitation of Liability: Seoul Stay will not be liable for any damages of any kind arising from the use of this platform, including, but not limited to direct, indirect, incidental, punitive, and consequential damages. 8. Intellectual Property: All content included on this site, such as text, graphics, logos, button icons, images, audio clips, digital downloads, data compilations, and software, is the property of Seoul Stay or its content suppliers and protected by international copyright laws. 9. Modifications to Terms: We reserve the right to make changes to the platform, policies, and these Terms and Conditions at any time. Your continued use of the platform following the posting of changes will mean you accept those changes. 10. Governing Law: These terms and conditions are governed by and construed in accordance with the laws of the Republic of Korea. By checking the "I agree to the Terms and Conditions" box during registration, you acknowledge that you have read, understood, and agree to be bound by these terms. Last Updated: [Current Date] Now, let's set up the initial C# project structure and define the core entities. We'll use WPF and EF Core (targeting SQL Server initially, but adaptable to MySQL). Microsoft Visual Studio Solution File, Format Version 12.00 # Visual Studio Version 17 VisualStudioVersion = 17.0.0.0 MinimumVisualStudioVersion = 10.0.0.0 Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "SeoulStayCallCenter.Core", "SeoulStayCallCenter.Core\SeoulStayCallCenter.Core.csproj", "{A1B2C3D4-E5F6-7890-ABCD-1234567890AB}" EndProject Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "SeoulStayCallCenter.Data", "SeoulStayCallCenter.Data\SeoulStayCallCenter.Data.csproj", "{B2C3D4E5-F6A7-8901-BCDE-2345678901BC}" EndProject Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "SeoulStayCallCenter.Services", "SeoulStayCallCenter.Services\SeoulStayCallCenter.Services.csproj", "{C3D4E5F6-A7B8-9012-CDEF-3456789012CD}" EndProject Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "SeoulStayCallCenter.Wpf", "SeoulStayCallCenter.Wpf\SeoulStayCallCenter.Wpf.csproj", "{D4E5F6A7-B8C9-0123-DEFG-4567890123DE}" EndProject Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "SeoulStayCallCenter.Tests", "SeoulStayCallCenter.Tests\SeoulStayCallCenter.Tests.csproj", "{E5F6A7B8-C9D0-1234-EFGH-5678901234EF}" EndProject Global GlobalSection(SolutionConfigurationPlatforms) = preSolution Debug|Any CPU = Debug|Any CPU Release|Any CPU = Release|Any CPU EndGlobalSection GlobalSection(ProjectConfigurationPlatforms) = postSolution {A1B2C3D4-E5F6-7890-ABCD-1234567890AB}.Debug|Any CPU.ActiveCfg = Debug|Any CPU {A1B2C3D4-E5F6-7890-ABCD-1234567890AB}.Debug|Any CPU.Build.0 = Debug|Any CPU {A1B2C3D4-E5F6-7890-ABCD-1234567890AB}.Release|Any CPU.ActiveCfg = Release|Any CPU {A1B2C3D4-E5F6-7890-ABCD-1234567890AB}.Release|Any CPU.Build.0 = Release|Any CPU {B2C3D4E5-F6A7-8901-BCDE-2345678901BC}.Debug|Any CPU.ActiveCfg = Debug|Any CPU {B2C3D4E5-F6A7-8901-BCDE-2345678901BC}.Debug|Any CPU.Build.0 = Debug|Any CPU {B2C3D4E5-F6A7-8901-BCDE-2345678901BC}.Release|Any CPU.ActiveCfg = Release|Any CPU {B2C3D4E5-F6A7-8901-BCDE-2345678901BC}.Release|Any CPU.Build.0 = Release|Any CPU {C3D4E5F6-A7B8-9012-CDEF-3456789012CD}.Debug|Any CPU.ActiveCfg = Debug|Any CPU {C3D4E5F6-A7B8-9012-CDEF-3456789012CD}.Debug|Any CPU.Build.0 = Debug|Any CPU {C3D4E5F6-A7B8-9012-CDEF-3456789012CD}.Release|Any CPU.ActiveCfg = Release|Any CPU {C3D4E5F6-A7B8-9012-CDEF-3456789012CD}.Release|Any CPU.Build.0 = Release|Any CPU {D4E5F6A7-B8C9-0123-DEFG-4567890123DE}.Debug|Any CPU.ActiveCfg = Debug|Any CPU {D4E5F6A7-B8C9-0123-DEFG-4567890123DE}.Debug|Any CPU.Build.0 = Debug|Any CPU {D4E5F6A7-B8C9-0123-DEFG-4567890123DE}.Release|Any CPU.ActiveCfg = Release|Any CPU {D4E5F6A7-B8C9-0123-DEFG-4567890123DE}.Release|Any CPU.Build.0 = Release|Any CPU {E5F6A7B8-C9D0-1234-EFGH-5678901234EF}.Debug|Any CPU.ActiveCfg = Debug|Any CPU {E5F6A7B8-C9D0-1234-EFGH-5678901234EF}.Debug|Any CPU.Build.0 = Debug|Any CPU {E5F6A7B8-C9D0-1234-EFGH-5678901234EF}.Release|Any CPU.ActiveCfg = Release|Any CPU {E5F6A7B8-C9D0-1234-EFGH-5678901234EF}.Release|Any CPU.Build.0 = Release|Any CPU EndGlobalSection GlobalSection(SolutionProperties) = preSolution HideSolutionNode = FALSE EndGlobalSection EndGlobal net7.0 enable enable using System.ComponentModel.DataAnnotations; using System.ComponentModel.DataAnnotations.Schema; namespace SeoulStayCallCenter.Core.Models { [Table("UserTypes")] public class UserType { [Key] [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public int ID { get; set; } [Required] [StringLength(50)] public string Name { get; set; } = null!; // Navigation property public virtual ICollection Users { get; set; } = new List(); } } using System; using System.Collections.Generic; using System.ComponentModel.DataAnnotations; using System.ComponentModel.DataAnnotations.Schema; namespace SeoulStayCallCenter.Core.Models { [Table("Users")] public class User { [Key] [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public int ID { get; set; } [Required] public Guid GUID { get; set; } [Required] [StringLength(100)] public string Username { get; set; } = null!; [Required] [StringLength(255)] // Length depends on hashing algorithm output public string Password { get; set; } = null!; // Store HASHED passwords only [Required] [StringLength(150)] public string FullName { get; set; } = null!; [Required] [Column(TypeName = "date")] public DateTime BirthDate { get; set; } [Required] public bool Gender { get; set; } // Consider enum or string if more options needed [StringLength(150)] [EmailAddress] public string? Email { get; set; } [StringLength(20)] public string? Phone { get; set; } [Required] public int UserTypeID { get; set; } // Navigation properties [ForeignKey("UserTypeID")] public virtual UserType UserType { get; set; } = null!; public virtual ICollection Items { get; set; } = new List(); } } using System.ComponentModel.DataAnnotations; using System.ComponentModel.DataAnnotations.Schema; namespace SeoulStayCallCenter.Core.Models { [Table("Areas")] public class Area { [Key] [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public int ID { get; set; } [Required] [StringLength(100)] public string Name { get; set; } = null!; // Navigation properties public virtual ICollection Items { get; set; } = new List(); public virtual ICollection Attractions { get; set; } = new List(); } } using System.ComponentModel.DataAnnotations; using System.ComponentModel.DataAnnotations.Schema; namespace SeoulStayCallCenter.Core.Models { [Table("ItemTypes")] public class ItemType { [Key] [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public int ID { get; set; } [Required] [StringLength(50)] public string Name { get; set; } = null!; // Navigation property public virtual ICollection Items { get; set; } = new List(); } } using System; using System.Collections.Generic; using System.ComponentModel.DataAnnotations; using System.ComponentModel.DataAnnotations.Schema; namespace SeoulStayCallCenter.Core.Models { [Table("Items")] public class Item { [Key] [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public int ID { get; set; } [Required] public Guid GUID { get; set; } [Required] public int UserID { get; set; } [Required] public int ItemTypeID { get; set; } [Required] public int AreaID { get; set; } [Required] [StringLength(255)] public string Title { get; set; } = null!; [Required] public int Capacity { get; set; } [Required] public int NumberOfBeds { get; set; } [Required] public int NumberOfBedrooms { get; set; } [Required] public int NumberOfBathrooms { get; set; } [StringLength(500)] public string? ExactAddress { get; set; } [StringLength(255)] public string? ApproximateAddress { get; set; } public string? Description { get; set; } public string? HostRules { get; set; } [Required] public int MinimumNights { get; set; } = 1; [Required] public int MaximumNights { get; set; } = 0; // 0 might mean indefinite [Required] [Column(TypeName = "decimal(10, 2)")] public decimal Price { get; set; } [Column(TypeName = "decimal(9, 6)")] public decimal? Latitude { get; set; } [Column(TypeName = "decimal(9, 6)")] public decimal? Longitude { get; set; } public TimeSpan? CheckInTime { get; set; } public TimeSpan? CheckOutTime { get; set; } [Required] public int ReservationCount { get; set; } = 0; // Navigation properties [ForeignKey("UserID")] public virtual User User { get; set; } = null!; [ForeignKey("ItemTypeID")] public virtual ItemType ItemType { get; set; } = null!; [ForeignKey("AreaID")] public virtual Area Area { get; set; } = null!; public virtual ICollection ItemAmenities { get; set; } = new List(); public virtual ICollection ItemAttractions { get; set; } = new List(); } } using System.ComponentModel.DataAnnotations; using System.ComponentModel.DataAnnotations.Schema; namespace SeoulStayCallCenter.Core.Models { [Table("Amenities")] public class Amenity { [Key] [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public int ID { get; set; } [Required] [StringLength(100)] public string Name { get; set; } = null!; [StringLength(255)] public string? IconPath { get; set; } // Navigation property public virtual ICollection ItemAmenities { get; set; } = new List(); } } using System.ComponentModel.DataAnnotations; using System.ComponentModel.DataAnnotations.Schema; namespace SeoulStayCallCenter.Core.Models { [Table("ItemAmenities")] public class ItemAmenity { [Key] [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public int ID { get; set; } [Required] public int ItemID { get; set; } [Required] public int AmenityID { get; set; } // Navigation properties [ForeignKey("ItemID")] public virtual Item Item { get; set; } = null!; [ForeignKey("AmenityID")] public virtual Amenity Amenity { get; set; } = null!; } } using System.ComponentModel.DataAnnotations; using System.ComponentModel.DataAnnotations.Schema; namespace SeoulStayCallCenter.Core.Models { [Table("Attractions")] public class Attraction { [Key] [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public int ID { get; set; } [Required] [StringLength(150)] public string Name { get; set; } = null!; [Required] public int AreaID { get; set; } public string? Description { get; set; } [Column(TypeName = "decimal(9, 6)")] public decimal? Latitude { get; set; } [Column(TypeName = "decimal(9, 6)")] public decimal? Longitude { get; set; } // Navigation properties [ForeignKey("AreaID")] public virtual Area Area { get; set; } = null!; public virtual ICollection ItemAttractions { get; set; } = new List(); } } using System.ComponentModel.DataAnnotations; using System.ComponentModel.DataAnnotations.Schema; namespace SeoulStayCallCenter.Core.Models { [Table("ItemAttractions")] public class ItemAttraction { [Key] [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public int ID { get; set; } [Required] public int ItemID { get; set; } [Required] public int AttractionID { get; set; } [Required] [Column(TypeName = "decimal(6, 2)")] public decimal Distance { get; set; } // In KM public int? DurationOnFoot { get; set; } // In minutes public int? DurationByCar { get; set; } // In minutes // Navigation properties [ForeignKey("ItemID")] public virtual Item Item { get; set; } = null!; [ForeignKey("AttractionID")] public virtual Attraction Attraction { get; set; } = null!; } } net7.0 enable enable all runtime; build; native; contentfiles; analyzers; buildtransitive PreserveNewest using Microsoft.EntityFrameworkCore; using Microsoft.Extensions.Configuration; using SeoulStayCallCenter.Core.Models; using System.IO; namespace SeoulStayCallCenter.Data { public class AppDbContext : DbContext { public DbSet UserTypes { get; set; } = null!; public DbSet Users { get; set; } = null!; public DbSet Areas { get; set; } = null!; public DbSet ItemTypes { get; set; } = null!; public DbSet Items { get; set; } = null!; public DbSet Amenities { get; set; } = null!; public DbSet ItemAmenities { get; set; } = null!; public DbSet Attractions { get; set; } = null!; public DbSet ItemAttractions { get; set; } = null!; public AppDbContext() { } // Needed for migrations public AppDbContext(DbContextOptions options) : base(options) { } protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { if (!optionsBuilder.IsConfigured) { // Load configuration from appsettings.json // Ensure appsettings.json is copied to output directory var configuration = new ConfigurationBuilder() .SetBasePath(Directory.GetCurrentDirectory()) .AddJsonFile("appsettings.json", optional: false, reloadOnChange: true) .Build(); // Get the connection string // Defaulting to MsSQL, change "MsSQLConnection" or add logic for MySQL string connectionString = configuration.GetConnectionString("MsSQLConnection") ?? throw new InvalidOperationException("Connection string 'MsSQLConnection' not found."); // Configure the DbContext to use SQL Server optionsBuilder.UseSqlServer(connectionString); // Or uncomment to use MySQL (ensure Pomelo package is added) // string mysqlConnectionString = configuration.GetConnectionString("MySQLConnection") // ?? throw new InvalidOperationException("Connection string 'MySQLConnection' not found."); // optionsBuilder.UseMySql(mysqlConnectionString, ServerVersion.AutoDetect(mysqlConnectionString)); } } protected override void OnModelCreating(ModelBuilder modelBuilder) { base.OnModelCreating(modelBuilder); // Configure unique constraints explicitly if needed (though handled by annotations/SQL) modelBuilder.Entity() .HasIndex(u => u.Username) .IsUnique(); modelBuilder.Entity() .HasIndex(u => u.Email) .IsUnique() .HasFilter("[Email] IS NOT NULL"); // SQL Server specific filter for nullable unique modelBuilder.Entity() .HasIndex(ut => ut.Name) .IsUnique(); modelBuilder.Entity() .HasIndex(a => a.Name) .IsUnique(); modelBuilder.Entity() .HasIndex(it => it.Name) .IsUnique(); modelBuilder.Entity() .HasIndex(am => am.Name) .IsUnique(); modelBuilder.Entity() .HasIndex(at => at.Name) .IsUnique(); // Configure composite unique keys for junction tables modelBuilder.Entity() .HasIndex(ia => new { ia.ItemID, ia.AmenityID }) .IsUnique(); modelBuilder.Entity() .HasIndex(ia => new { ia.ItemID, ia.AttractionID }) .IsUnique(); // Configure relationships and cascade delete behavior if needed // Example: Prevent cascade delete from UserType to User if required // modelBuilder.Entity() // .HasOne(u => u.UserType) // .WithMany(ut => ut.Users) // .HasForeignKey(u => u.UserTypeID) // .OnDelete(DeleteBehavior.Restrict); // Or NoAction // Configure cascade delete for ItemAmenities and ItemAttractions (already set in SQL) modelBuilder.Entity() .HasOne(ia => ia.Item) .WithMany(i => i.ItemAmenities) .HasForeignKey(ia => ia.ItemID) .OnDelete(DeleteBehavior.Cascade); modelBuilder.Entity() .HasOne(ia => ia.Amenity) .WithMany(a => a.ItemAmenities) .HasForeignKey(ia => ia.AmenityID) .OnDelete(DeleteBehavior.Cascade); // Or Restrict if Amenities shouldn't be deleted if used modelBuilder.Entity() .HasOne(ia => ia.Item) .WithMany(i => i.ItemAttractions) .HasForeignKey(ia => ia.ItemID) .OnDelete(DeleteBehavior.Cascade); modelBuilder.Entity() .HasOne(ia => ia.Attraction) .WithMany(a => a.ItemAttractions) .HasForeignKey(ia => ia.AttractionID) .OnDelete(DeleteBehavior.Cascade); // Or Restrict if Attractions shouldn't be deleted if used } } } { "ConnectionStrings": { // Replace with your actual SQL Server connection string "MsSQLConnection": "Server=(localdb)\\mssqllocaldb;Database=Session1;Trusted_Connection=True;MultipleActiveResultSets=true", // Replace with your actual MySQL connection string if using MySQL "MySQLConnection": "Server=your_mysql_server;Port=3306;Database=Session1;Uid=your_user;Pwd=your_password;" }, "Logging": { "LogLevel": { "Default": "Information", "Microsoft.AspNetCore": "Warning" // Adjust if needed, though this is a desktop app } }, "AllowedHosts": "*" // Not typically used in desktop apps } net7.0 enable enable WinExe net7.0-windows enable enable true PreserveNewest using System.Configuration; using System.Data; using System.Windows; namespace SeoulStayCallCenter.Wpf { ///

/// Interaction logic for App.xaml ///

public partial class App : Application { protected override void OnStartup(StartupEventArgs e) { base.OnStartup(e); // Dependency Injection setup would go here in a larger application // For simplicity now, windows will create their dependencies or pass them. // Example: Initialize database context factory or services // var dbContextFactory = new DbContextFactory(...); // var authService = new AuthService(dbContextFactory); // etc. } } }