Skip to content

alex-19841/CodeTest-Grid

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

17 Commits
 
 
 
 
 
 

Repository files navigation

Plus Consulting Code Test: Grid

Submission

Fork this Repo, complete your code and submit a Pull Request to complete your submission. If needed, please supply a database backup and/or BACPAC.

For help learning Git, check out the Git tutorial here: https://try.github.io/levels/1/challenges/1

For instructions on how to submit a Pull Request from a Fork: https://help.github.com/articles/creating-a-pull-request-from-a-fork/

Overview

You will create an application for interacting with product data. The system must have CRUD capabilities. For the purposes of this test, you have the option to leverage any database technology you feel comfortable using. You can use any .NET/Client-Side architecture(s) of your choice to complete the requirements outlined below. Our evaluation process places emphasis on clean, well-structured code.

Every feature does not need to be complete.

Configuration

If you do not have a copy of Visual Studio 2013+, you can download Visual Studio 2013 Community Edition here: https://www.visualstudio.com/en-us/news/releasenotes/vs2013-community-vs If you do not have a copy of SQL Server 2012+, you can download SQL Server 2012 Express here: https://www.microsoft.com/en-us/download/details.aspx?id=29062 (Optionally) To hasten your progress, if you’re familiar with SQL server, the AdventureWorks2012 database can be obtained here: http://msftdbprodsamples.codeplex.com/releases/view/93587

Requirements

The following fields will need to be visible on the grid: (Optionally, they can be found in the [Production].[Product] table in the AdventureWorks2012 database)

  • Name
  • ProductNumber
  • Color
  • SafetyStockLevel
  • ReorderPoint
  • StandardCost
  • ListPrice

Overview

Users must be able to view the data in a grid format and include one or more the following capabilities:

  1. View Data within a Grid
  2. Pagination
  3. Sorting
  4. Column Filtering
  5. Data Validation New Rows Users must be able to add a new product to the database and you must ensure each field is valid prior to saving the record.  

Browser Support

The application must function properly in one of the following browsers (specify the browser we should use to run the code test when submitting your completed project):

  • IE 9+
  • Edge
  • Firefox
  • Chrome

User Interface

A clean, appealing user interface is preferable.

Additional Features

Your application is not limited to the features required in this document. Feel free to add additional features you feel apply to the scenario.

About

Plus Consulting Code Test - Creating a Grid

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • JavaScript 82.9%
  • CSS 11.7%
  • PowerShell 4.8%
  • Other 0.6%