Code Monkey home page Code Monkey logo

codereviews.console.flashcards's Introduction

CodingTracker

  • Console based CRUD application to create and study flashcards
  • Developed using C# and MSSQL

Given Requirements:

  • When application starts, it creates a MSSQL database if one is not present
  • Creates a database where flashcard stacks are made and studied
  • Shows a menu of options
  • Allows user to Add and delete a stack, add and delete a flashcard, do a study session, view all study sessions, and get a report on study sessions for the last year.
  • Handles all errors so application doesn't crash
  • Only exits when user selects Exit

Features

  • MSSQL database connection
  • The program uses a MSSQL db conneciton to store and read information.
  • If no database exists, or the correct table does not exist, they will be created when the program starts.
  • A console based UI using Spectre Console where users can navigate with selecting with their keyboard

DB functions

Main Menu

  • Users can add and delete a stack, add and delete a flashcard, do a study session, view study sessions by stack, and get an average score yearly report.

    image

Add a stack

  • Stack name is entered, with a way to exit to the main menu by entering 0.

    image

  • If a stack name already exists, you receive an error message and can press any key to try again.

    image

  • Informs you the stack has been added and prompts to press any key to continue image

Delete a stack

  • Users select a stack to delete from the available stacks

    image

  • Users get a message on screen telling them that the stack has been deleted, and they can press any key to continue.

  • When a stack is deleted, the associated flashcards and study sessions for that stack are also deleted from the database.

    image

Add a flashcard

  • Users will be prompted if the flashcard will be for a new stack. If yes, the user will be prompted to create a new stack.

  • If no, they will select the stack that the flashcard will be added to.

    image

  • Users will be prompted to enter the front and back of the flashcard, they can also press 0 to return to the main menu.

    image image

  • Empty values are not allowed, this is handled by prompting the user again, they can also press 0 to return to the main menu.

    image

  • The front of flashcards MUST be unique, or users will get an error message and will need to try again.

    image

Delete a flashcard

  • Users will be prompted to select a stack to delete the flashcard from.

    image

  • Users will then be prompted to select the flash card to delete, these are sorted by the front of the flashcards image

  • Users will get a message that the flashcard has been deleted, and that the indexes have been updated.

  • When a flash card is deleted, all flashcard Id's will adjust to get rid of any gaps. image

Study Session

  • Users will be prompted to select a stack to study from.

    image

  • Users will shown the Id of the flashcard and the front of the flashcard, and will be prompted to provide an answer

  • If a blank answer is provided, the user will be presented with an error message and be prompted to provide an answer

    image

  • Once an answer is provided, the flashscard Id and back of the card will be shown to the user

  • If the answer is correct, they will get a point and be prompted to press any key to continue

  • If the answer is incorrect, they will not receive a point and will be informed that their answer was incorrect.

    image image

  • After all flashcards have been answered, the user will get their final score and to press any key to continue.

  • User will be shown that the study session has been added, and to press any key to continue.

    image image

View Study Sessions by Stack

  • Users will be prompted to select a stack to view all the sessions of.

    image

  • Users will then be presented with a table with the name of the stack, the session dates, and the scores.

  • At the bottom will show the average study session score for all their sessions for that stack.

  • Pressing any key will return user to the main menu.

    image

Average Score Yearly Report

  • Users will be prompted to enter the year for the report.

  • If the format is incorrect or blank, the user will receive an error message and be prompted to enter in the correct format.

    image

  • After the year is entered, users will be presented with a table with the average study sessions for the year they entered.

  • If no sessions exist, they will be presented with an error message asking if they'd like to try agian.

  • Selecting yes will prompt them for the year, selecting no will return them to the main menu. image image

codereviews.console.flashcards's People

Stargazers

 avatar  avatar  avatar  avatar

Watchers

 avatar  avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.