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 |