coledixon / csharp_login_utility Goto Github PK

-- login form base

• username field
• password field
• login button (dynamically change to 'logout' on successful login)
• error prompt window

-- data class (SQL trans / data sort)
-- ext class (external methods)
-- props class (get; set; props based around SQL schema)
-- error class (error / validation handling)

(WIP)

-- construct model based on SQL schema
-- get; set; props based on input / return values
-- transact with local SQL db (db_login)

-- set PasswordChar prop (*)
-- set MaxChar prop (20)
-- require alphanumeric with at least 1 symbol

C#:

• loginData.cs DoLogin()
  -- compare SQL ret hash from proc against hashed pw in field

SQL:

• spuserLogin()
  -- query user info based on username
  -- ret pass_hash to C# for compare

-- connect C# app to SQL local db instance (db_login)

-- build default error handling into application base
-- LostFocus() events on all text fields
---- validate user exists on LostFocus() event

-- validate user / pass on login attempt(s)
---- prompt success / fail icons based on SQL retval

-- compare passwords on login attempt
---- parse hash for entered pw
---- compare against returned pw from SQL based on userId

(more to come as project grows)

-- construct SQL schema

• tables
• views
• procs
• triggers

-- build insert/update triggers
-- add insert/update queries in main PROCS [spcreateUser / spcreateUser]

-- build admin WinForm subscreen (called from Login_App.cs)
-- Admin functionality to include CREATE / UPDATE / DELETE
-- make Admin screen accessible only to SYSADMIN users in SQL. (WIP)

-- update logic for hashing / salting varchar passwords
-- pass hash && salt to sql proc spcreateUser
-- DO NOT PASS VARCHAR PW VIA LINQ

-- evaluate session creation with SQL structure [spcreateSession]
-- gen NEWID() as sesstoken val