• sql server authentication or azure ad authentication

Considering: MySQL, Microsoft SQL Server

• sql query in event repo

• appropriate business logic in repo

• connect controller to repo

• build corresponding DTOs

• unit test api call

User Story

• As a guest or registered user, I want to browse all events within a few miles of my current location on a virtual map, so that I can become aware of events in my area and find an event near me to attend.

Business Goal

• Satisfaction- This is the driving feature of the app.

Use Cases

• Name: Browse Events
• Description: Browse through a list of events that are taking place within a reasonable distance from your location and within a reasonable time frame
• Preconditions: the user must allow CampusNow to access the device's location
• Happy path:
  • If user consents to share location, queries database for existing events within 3 miles of location and displays the results on the map.
• Post-Conditions:
  • The user will be able to view markers locating any events that are taking place within 3 miles
• Alternate Paths
  • If CampusNow does not have access to a devices location, it not show any event markers and instead display a message notifying the user of the problem.

Acceptance Tests

• Ensure that a user is only receiving markers for events within a 3 mile radius that have not yet occurred.
• Ensure that if a user has not given CampusNow their location, they are instead given an appropriate error message and no events are shown.

• build page

• api calls to registration controller

What constraints does your team have?

Week 3

Blocked?

• No

This week:

• Looked into potential front end frameworks to use. Considering Vue.js or Svelte (#15).

Next week:

• Decide on what maps API to use (#17). Implement MVP layout.

• create login controller

• message handler

• appropriate DTOs

• test

https://github.com/seanonline/Webapi_JWT_Authentication/blob/master/WEBAPI_JWT_Authentication/WEBAPI_JWT_Authentication/Models/Models.cs

http://www.decatechlabs.com/secure-webapi-using-jwt

what are the 2 main features for your project? What will those features do for users?

Who are your competitors? What's your plan to compete against them?

• sql query in event repo

• appropriate business logic in repo

• connect controller to repo

• build corresponding DTOs

• unit test api call

• build page

• api calls to login controller

Task

Design sql tables for users and events, with appropriate references and constraints.

Conditions of Satisfaction

Draw a diagram with appropriate table names, attributes, data types, constraints and translate this to sql queries.

List of clarifying questions (and your answers)

• sql query in event repo

• appropriate business logic in repo

• connect controller to repo

• build corresponding DTOs

• unit test api call

who are your 3 types of users? What features will they use?

https://docs.microsoft.com/en-gb/aspnet/web-api/overview/web-api-routing-and-actions/create-a-rest-api-with-attribute-routing

Week 3

What went well last week?

• We were able to come up with a plan to split up the work and research possible technologies.

What didn't go well last week?

• We didn't have too much time to discuss what we found.

What experiment (or change) we'll make next week to improve as a team?

• Start discussing our findings with each other so that we can move forward.

User Story

• As a user of Campus Now I would like to make a user profile so that I can keep track of events I share and interact with other users.

Business goal

• Adoption

Use Case

• Name: Register
• Description: An anonymous user creates an account and logs in as a now verified member
• Preconditions: None
• Happy Path:
  • User selects button to create a new account
  • User enters a unique & valid username, a valid password
  • User receives message confirming the account has been creating
  • User signs into account using correct username and password
• Post-Conditions:
  • User is now signed into their account and can post/edit their own events
• Alternate Paths:
  • If an invalid username, password is given on account creation, display an error message
  • If the user does not enter a matching username and password, display an error message

Acceptance Tests

• Ensure that a given username can be verified as unique and does not contain invalid characters
• Ensure that a username & password is valid when logging in
• Ensure that an error message is sent when one of the above conditions are not met

Project Name: CampusNow

Students or organizations on campus can post times and locations of their club events. Other students can browse current and upcoming events on a map.

Brainstorming:

• PolyRatings but better
• Live map for club/campus events/classes/parking
• Rate campus food items
• Share study notes

#20
using token based authentication. accounts are stored in sql server db

https://docs.microsoft.com/en-us/aspnet/web-api/overview/security/individual-accounts-in-web-api

https://dotnettutorials.net/lesson/token-based-authentication-web-api/

https://www.c-sharpcorner.com/article/how-to-create-login-page-in-asp-net-web-application-using-c-sharp-and-sql-server/

Two things to correct:

• Your use cases must follow the template. Make sure you understand preconditions, post conditions, and alternative paths for your midterm. (10 points)
• Did you create Spikes and close them out by the end of the week (by Sunday EOD)? You still have open Spikes, which isn't a timeboxed investigation. (10 points)

Your feature titles looked good. No dev speak.

total score: 80

Considering:
.NET Web API, vanilla JavaScript fetch() API

parametrized sql update statement for events table

add all DTOs for event crud operations

Task

Build a landing page of some sort.

Conditions of Satisfaction

Rough draft of landing page, with map, navbar, title...

User Story

• As a registered member of CampusNow, I want to post information about upcoming events, so other users can discover these events and spread awareness.

Business Goal

• Satisfaction

Use Case

• Name: Share Information
• Description: Make a post about about an upcoming event to spread awareness.
• Preconditions: User must be signed into an account
• Happy Path:
• User (signed in) clicks button to create a new event
• User fills in information on title, description, location, and time
• User confirms information and event is posted
• Post-conditions:
  • User receives a confirmation message
  • Other others (including anonymous) are able to view event details.
• Alternate paths:
  • Non-registered member attempts to post information
    • Send message telling use to register in order to post events
  • User enters invalid event name (empty or invalid characters)
    • Deny post request and send error message

Acceptance tests

• Verify that a member is able to create an account
  • Ensure username is unique and does not contain any invalid characters, otherwise display an error message
• Verify that a member can sign into their account by providing the correct credentials
  • If credentials are incorrect, an error message should be displayed
• Verify that the event is not posted and an error message is sent if an event title contains invalid characters
• Verify that the event posting is tied to the account and saved properly

transformers for various DTOs

I am not blocked

Weekly tasks:

• Ran a spike on back-end database, planning out what information would need to be stored and what structures I would use to keep track of information

Next week

• I hope to begin setting up the tables and relations on our group's mysql database that we will later use to keep track of user activity.

Task

start visual studio code project for asp.net backend

Conditions of Satisfaction

Project builds and runs on IIS. Sample webpage displays. Controllers work.

Week 3

• Am I blocked? No
• What I did: Setup SQL Server database and gave access.
• What I plan to do next week: Start working on asp.net backend.

Considering: .NET

• correct methods

• correct route attributes

How will you define and measure success?

write parameterized sql insert statement to insert event record into events table and insert a sample event

Considering:

• Apple Maps
• OpenStreetMap
• Google Maps
• Mapbox
• Leaflet.js

• sql query in event repo

• appropriate business logic in repo

• connect controller to repo

• build corresponding DTOs

• unit test api call

Considering: Vue.js, Svelte

• sql query in event repo

• appropriate business logic in repo

• connect controller to repo

• build corresponding DTOs

• unit test api call

Considering: schedules.calpoly.edu