Skip to content

C# group project. A simple social networking/dating application implementing SQL databases.

Notifications You must be signed in to change notification settings

brianpritt/date-a-base

Repository files navigation

Date-A-Base

Short Description.

_This is a dating app for programmers that allows them to build a dating profile and seek other programmers., December 21, 2016 _

By Lina Shadrach, Brian Pritt, Taylor Loftis-Kim, James Howard

Description

Longer Description

_This app allows users to create a profile that will be used as their "Dating Profile". They will be able to edit multiple parameters of information, as well as add photos to their profile page. The User will be able to search for other profiles that are created, and see specific profiles that acquire matches. The User will be able to send messages to another profile, and that profile will be able to view the message, as well as reply to it. _

SPECS INPUT OUTPUT
Will return an empty Database null null
Will allow User to Create a profile Username: TaylorLoftisKim Password: *****aFirstName: Taylor LastName: Loftis Etc. Profile: TaylorLoftisKim
Will allow User to Log-In to existing profile Username: TaylorLoftisKim Password: ***** Profile Login Successful
Will allow User to update their profile Edit Profile: Username: TaylorLoftisKim Password: ***** FirstName: Taylor LastName: Loftis-Kim Email: [email protected]
Will allow User to delete their profile Delete Profile: Database: null
Will allow User to view all "Daters" View All Profiles: Taylor Loftis Brian Pritt
Will allow "Logged-In" User to edit their specific profile Edit Profile FirstName: Taylor LastName Loftis-Kim Etc.
Will allow User to Log-Out of their profile Log-Out Return to Sign-In Page
Will allow User to Tag their profile with muiltiple tags Edit Profile: Tags: biking cars coffee hiking
Will allow User to search using Tags to locate profiles Search Tags: biking cars coffee hiking TaylorLoftisKim
Will allow User to send a message to a specific profile Send Message: To Taylor: Hey there! Message Sent!
Will allow User to View a unread message that was sent to their profile View Unread Messages: From Brian: From Brian: Hey there!
Will allow User to View all messages sent to them from other profiles View All Messages: From Brian:, From James:, From Lina:. From Brian: Hey there!, From James: How's it going?, From Lina: Hello!
Will allow User to View all messages that they sent to other users. View All Sent Messages: From TaylorLoftisKim: TaylorLoftisKim: To Brian: Yo.
Will allow User to delete specific messages sent from multiple profiles View All Messages: From Brian: Yo --- DELETE View All Messages: null.

Setup/Installation Requirements

  • Download the repository here. Run on Windows with Powershell. In powershell, navigate into the repository directory and use command >dnx kestrel to run. Open up any browser window and enter localhost:5004 into URL search bar. Use command >dnx test to run tests in Test folder.
  • SQL for creating database(MyServerManagement): Create DATABASE date_a_base go USE [date_a_base] GO /****** Object: Table [dbo].[matches] Script Date: 12/21/2016 2:18:19 PM / SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[matches]( [id] [int] IDENTITY(1,1) NOT NULL, [user1_id] [int] NULL, [user2_id] [int] NULL ) ON [PRIMARY] GO / Object: Table [dbo].[messages] Script Date: 12/21/2016 2:18:19 PM / SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[messages]( [id] [int] IDENTITY(1,1) NOT NULL, [sender_id] [int] NULL, [receiver_id] [int] NULL, [body] varchar NULL, [viewed] [bit] NULL ) ON [PRIMARY] GO / Object: Table [dbo].[photos] Script Date: 12/21/2016 2:18:19 PM / SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[photos]( [id] [int] IDENTITY(1,1) NOT NULL, [user_id] [int] NULL, [url] varchar NULL, [profile] [bit] NULL ) ON [PRIMARY] GO / Object: Table [dbo].[state] Script Date: 12/21/2016 2:18:19 PM / SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[state]( [id] [int] IDENTITY(1,1) NOT NULL, [user_id] [int] NULL ) ON [PRIMARY] GO / Object: Table [dbo].[tags] Script Date: 12/21/2016 2:18:19 PM / SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tags]( [id] [int] IDENTITY(1,1) NOT NULL, [name] varchar NULL ) ON [PRIMARY] GO / Object: Table [dbo].[tags_users] Script Date: 12/21/2016 2:18:19 PM / SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tags_users]( [id] [int] IDENTITY(1,1) NOT NULL, [user_id] [int] NULL, [tag_id] [int] NULL ) ON [PRIMARY] GO / Object: Table [dbo].[users] Script Date: 12/21/2016 2:18:19 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[users]( [id] [int] IDENTITY(1,1) NOT NULL, [first_name] varchar NULL, [last_name] varchar NULL, [zip_code] varchar NULL, [email] varchar NULL, [phone_number] varchar NULL, [about_me] varchar NULL, [tag_line] varchar NULL, [user_name] varchar NULL, [password] varchar NULL, [gender_identity] [int] NULL, [seeking_gender] [int] NULL ) ON [PRIMARY] GO

Known Bugs

None known.

Support and contact details

Please contact author through GitHub at username: brianpritt

Technologies and Resources Used

HTML, CSS, C#, Xunit, Nancy, Razor, Git, GitHub, MSSQl

License

MIT

Copyright (c) 2016 Lina Shadrach, Brian Pritt, Taylor Loftis-Kim, James Howard

About

C# group project. A simple social networking/dating application implementing SQL databases.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Contributors 4

  •  
  •  
  •  
  •  

Languages