Develop your own Web Accounting Application using ASP.Net

Contents

Part 1:- Introduction

Introduction to ASP.Net
ASP.Net and .Net Framework
Benefits of ASP.Net Controls
Overview of ASP.Net Controls
Server Controls Hierarchy
Basic ASP.Net Web Controls

1. Label Control in ASP.Net
2. TextBox Control in ASP.Net
3. Button Control in ASP.Net
4. Imagebutton Control in ASP.Net

More Basic ASP.Net Web Controls

1. Link Button Control in ASP.Net
2. RadioButton Control in ASP.Net
3. RadioButtonList Control in ASP.Net
4. CheckBox Control in ASP.Net
5. CheckBoxList Control in ASP.Net
6. DropDownList Control in ASP.Net
7. List Box Control in ASP.Net
8. Panel Control in ASP.Net
9. Placeholder Control in ASP.Net
10. Hyper Link Control in ASP.Net

Validation Web Controls

1. RequiredFieldValidator
2. RegularExpressionValidator
3. CompareValidator
4. RangeValidator
5. ValidationSummary
6. CustomValidator

Controlling Page Navigation in ASP.Net
Using HyperLink Control for Page Navigation ASP.Net
Installing and Configuring IIS (Internet Information Services) ASP.Net
Virtual Directory Concept in ASP.Net
Creating a Virtual Directory in ASP.Net
Working of an ASP.Net application
ASP.Net Page Structure

1. Directives in ASP.Net
2. Code declaration blocks in ASP.Net
3. ASP.Net controls in ASP.Net
4. Code render blocks in ASP.Net
5. Server-side comments in ASP.Net
6. Server-side include directives in ASP.Net
7. Literal Text and HTML Tags in ASP.Net

Creating an ASP.Net Application
Views in an ASP.Net Application

1. Design view
2. HTML view
3. Code behind view

Page Events in ASP.Net
ASP.Net built-in objects
Page Class in ASP.Net

Part 2:- Server Side Programming with ASP.Net and Visual Basic.Net

Accessing Data with ADO.NET in ASP.Net Pages
ADO vs ADO.NET
Required Connection String Fields

1. The Provider
2. The Data source
3. The Initial Catalog
4. Security information

Ex 1: Retrieving data using DataReader and displaying in textboxes
Ex 2: Retrieving data using Stored Procedure in an ASP.Net page
Ex 3: Retrieving data using Parameterized Stored Procedures in ASP.Net
Ex 4: Inserting New Records in a database
Ex 5: Updating Database records
Ex 6: Deleting Database records

Using DataSets
Drawbacks of DataReader

Ex 7: Creating a DataSet and binding Datagrid control to a DataSet

DataTables

Ex 8: Creating Tables programmatically
Ex 9: Updating Records in a DataTable

Navigating the DataSet

Ex 10: Navigating all tables and Fields in a DataSet
Ex 11: Caching database data in DataSets and displaying contents of the datasets in ASP.NET pages

Displaying Cached Data
Dataviews

Ex 12: Caching a DataView and finding a row in a cached DataView
Ex 13: Filtering rows in a DataView

Overview of Data Binding
Binding a server Control to a Data Source

Ex 14: Display data into Repeater Control
Ex 15: To change format of the Repeater control using Templates
Ex 16: Display data in DropDownList control
Ex 17: Display data in Listbox control using DataSet

DataGrid Control

1. Bound columns
2. HyperLink Columns
3. Button Columns
4. Template Columns

Ex 18: Creating DataGrid Programmatically in ASP.Net
Ex 19: How to perform custom formatting of DataGrid. Specifying DataGrid Formatting
Ex 20: How to customize formatting and style for each column in DataGrid.
Ex 21: How to associate custom Events with DataGrid
Ex 22: How to determine which row of DataGrid has its button clicked and how to take action based on that information
Ex 23: Sorting columns in a DataGrid Control
Ex 24: ASP.NET Datagrid Paging
Ex 25: Working with Datagrid Templates

Part 3:- Programming Master Entries using ASP.Net

Structure of an Accounting ASP.Net Web Application
Designing the Home Page in ASP.Net
Creating the Dialog form in ASP.Net
Programming the Dialog Form in ASP.Net
Linking Dialog Form (AcdForm.aspx) to Home Page (Default.aspx)
Designing Accounts Form (AcForm.aspx)
Programming Accounts form in ASP.Net
Steps to program the Accounts Form: (AcForm.aspx)

1. Declarations in ASP.Net
2. Programming Page_Load event in ASP.Net
   1. Create Database Connection in ASP.Net
   2. Instantiate the DataAdapter and the DataSet
   3. Populate Accounts DataSet
   4. Populate Group DataSet
   5. Fill ListBox control with Groups data
3. Programming Savebutton_Click event
4. Stored Procedure with OUTPUT Parameter

Using Accounts Master option
The View State Property
Role of a view state property in Accounts master Form (AcForm.aspx)
Disabling View State

Part 4:- Programming Transactions using ASP.Net

Prerequistes
Concept of Transactions

1. Journal Voucher Transaction
2. Cash Voucher Transaction
3. Cash Receipt Transaction
4. Cheque Voucher Transaction
5. Cheque Receipt Transaction
6. Purchase Transaction
7. Sale Transaction

Summary of Transactions
Table of Transactions vs Fields
Functionality Specifications

Designing Journal Voucher Transaction

1. Create the DataGrid
2. Set the Background Color and Font for Header
3. Alternative Item in the Grid and Footer of the Grid
4. Create Columns in a Datagrid Control
   • Create a Template column for the AccountName column in the JV
   • Add a DropDownList Web Control to the Footer
   • Create a Template column for the Debit column in the JV
   • Add a TextBox Control in the Footer
   • Create a Template column for the Credit column in the JV
5. Create a Template column for the DeleteButton
6. Add a Button Control in the DataGrid Footer
7. Add an Edit Command Button Control in the DataGrid
8. Place other remaining controls in the Form

Programming Journal Voucher in ASP.Net

1. Declarations
2. Building the DataTable structure
3. Programming Page_Load event
4. Programming Add button
5. Programming Cancel button
6. Programming Update button
7. Program the function which will retrieve account names and store them into DataSet
8. Program the function which keeps a running total of debit amount of the accounts within DataTable
9. Program the procedure for checking Double Entry rule
10. Programming the Event handler for DeleteCommand event
11. Programming the Event handler for EditCommand event
12. Programming the function which loops through each row in the DataSet and returns the position
13. Programming Save button

Common Steps of a Transaction
Designing and programming the master VouRec form

1. Cash voucher Transaction
2. Check Voucher Transaction
3. Cash Receipt Transaction
4. Check Receipt Transaction

Designing the VouRec form

1. Create the DataGrid
2. Set the Background Color and Font for Header for the Alternative Item in the Grid and Footer of the Grid
3. Create Columns in a Datagrid Control
4. Create a Template column for the AccountName column in the VouRecForm
5. Add a DropDownList Web Control to the Footer
6. Create a Template column for the Debit column in the VouRecForm
7. Add a TextBox Control in the Footer
8. Create a Template column for the Credit column in the VouRecForm
9. Create a Template column for the DeleteButton
10. Add a Button Control in the DataGrid Footer
11. Add an Edit Command Button Control in the DataGrid
12. Place the other remaining controls in the Form

Programming VouRecForm

1. Declarations using ASP.Net
2. Building DataTable Structure using ASP.Net
3. Programming Page_Load event using ASP.Net
4. Programming Add button using ASP.Net
5. Programming Cancel button using ASP.Net
6. Programming Update button using ASP.Net
7. Program the function which will retrieve account names and store them into DataSet
8. Program the function which will retrieve Cash account names and store them into the DataSet
9. Program the function which keeps a running total of the debit amount of the accounts within the DataTable
10. Program the procedure for checking Double Entry rule
11. Programming the Event handler for the DeleteCommand event
12. Programming the Event handler for the EditCommand event
13. This function loops through each row in the DataSet and returns the position in the dataset
14. Programming Save button
15. Linking the Cash Voucher Form (VouRecForm.aspx) to the Home Page (Default.aspx)

Typical Cash Voucher Transaction
Linking the Check Voucher Form (VouRecForm.aspx) to the Home Page (Default.aspx)
Typical Check Voucher Transaction
Linking the Cash Receipt Form (VouRecForm.aspx) to the Home Page (Default.aspx)
Using the Cash Receipt Form
Typical Cash Receipt Transaction
Linking the Ch Receipt Form (VouRecForm.aspx) to the Home Page (Default.aspx)
Using the Cash Receipt Option
Designing and programming the Purchase /Sale Master form

Part 5:- Reports.

Creating Reports in ASP.Net
Crystal Report Data Access models
The Architecture
Creating Trial Balance Report (PULL method) Using ASP.Net
Steps to develop reports

1. The format in which data is to be displayed is decided
2. Create rpt file and design the format
3. Procedure to create a formula field
4. Creating Running Total fields
5. Create a CrystalReportViewer Control
6. Bind the CrystalReportViewer control to the Report
7. Connect the report to the Home Page

Exporting a Report File created using the PULL Model
Creating DayBook Report
Creating Registers Report using Push method

Part 6:- Securing and Deploying an Application.

Securing ASP.Net Applications
Understanding how ASP.NET and IIS Handle Authentication and Authorization
Windows Authentication
Configuring IIS for Windows-Based Authentication

1. Anonymous Authentication
2. Basic Authentication
3. Integrated Windows Authentication
4. Digest Authentication

Configuring Web.config file for Windows Authentication
Forms-Based Authentication

1. Enable anonymous access in IIS
2. Configure section in Web.config file
3. Configure section in Web.config file
4. Create Login Page

Benefits of Forms-Based Authentication
Authenticating Users with a Database Table
Deploying an application

1. Create a deployment project.
2. Add the output of the application to the deployment project
3. Set the properties for the installer and build the solution.
4. Access the web application.