Section 1 : Introduction

Lecture 1 Introduction 00:01:27 Duration
Lecture 2 Payroll System Requirement 00:05:33 Duration
Lecture 3 Installation Guide 00:02:11 Duration

Section 2 : Database Design

Lecture 1 Create Database Tables and Relationship 00:10:48 Duration

Section 3 : Employee Form Module

Lecture 1 Employee Form Design 00:17:48 Duration
Lecture 2 Implicit Validation 00:08:57 Duration
Lecture 3 Explicit Validation 00:15:51 Duration
Lecture 4 Regular Expression - Part 1 00:12:11 Duration
Lecture 5 Regular Expression - Part 2 00:13:27 Duration
Lecture 6 Clear Controls 00:04:20 Duration
Lecture 7 PreviewForm - Parameter vs Argument - Part 1 00:12:58 Duration
Lecture 8 PreviewForm - Parameter vs Argument - Part 2 00:11:44 Duration
Lecture 9 Introduction to ADO 00:03:53 Duration
Lecture 10 Add Functionality 00:19:14 Duration
Lecture 11 Update Functionality Part 1 00:06:11 Duration
Lecture 12 Update Functionality Part 2 00:07:31 Duration
Lecture 13 Delete Employee Records 00:05:54 Duration
Lecture 14 Code Review 00:04:07 Duration

Section 4 : Payroll Calculator Module

Lecture 1 Payroll Calculator Form Design Part 1 00:10:33 Duration
Lecture 2 Payroll Calculator Form Design Part 2 00:13:13 Duration
Lecture 3 Retrieve Employee - DataReader 00:14:38 Duration
Lecture 4 Array Vs List Collection 00:16:32 Duration
Lecture 5 For Loop vs Foreach Loop vs ForEach Method 00:05:34 Duration
Lecture 6 Payroll Computation - Part 1 00:15:06 Duration
Lecture 7 Payroll Computation - Part 2 00:10:34 Duration
Lecture 8 Saving PayRecords - using Parameterised Command 00:14:57 Duration
Lecture 9 Pass-By-Value vs Pass-By-Reference
Lecture 10 Out vs Ref Keywords
Lecture 11 Time to Decimal Conversion 00:13:24 Duration
Lecture 12 Linked Label and Digital Timer 00:05:24 Duration
Lecture 13 String vs StringBuider Class

Section 5 : Search Functionality

Lecture 1 Search Functionality 00:11:15 Duration

Section 6 : Printing Functionality

Lecture 1 Printing Functionality - Payslip 00:19:15 Duration

Section 7 : AboutBox MDI and MenuStrip

Lecture 1 AboutBox - Product Information 00:06:04 Duration
Lecture 2 Multiple Document InterfaceMDI and MenuStrip 00:19:48 Duration

Section 8 : Reporting Facilities

Lecture 1 Reporting facilities - Part 1
Lecture 2 Reporting Facilities - Part 2 00:14:29 Duration

Section 9 : Log In and Registration Module - Users Class

Lecture 1 LogIn and RegisterUser Form Design 00:16:22 Duration
Lecture 2 Registered Users Table 00:03:10 Duration
Lecture 3 Complex Password Validation 00:19:47 Duration
Lecture 4 Class Object and Member Variables 00:16:47 Duration
Lecture 5 Constructors 00:06:30 Duration
Lecture 6 Properties Methods - Class Member 00:09:05 Duration

Section 10 : Using Stored Procedure

Lecture 1 Stored Procedure - spInsertCommand 00:18:21 Duration
Lecture 2 Stored Procedure - spUpdateCommand 00:11:28 Duration
Lecture 3 Stored Procedure - spDeleteCommand 00:05:39 Duration
Lecture 4 Stored Procedure - DataReader 00:09:24 Duration
Lecture 5 Stored Procedure - spAuthorisedUsers 00:13:14 Duration

Section 11 : Deployment

Lecture 1 FormClosing - Exiting Application 00:03:47 Duration
Lecture 2 Deployment - using ClickOnce