Title: Develop Web ERP Software Using VS 2015

web erp book with database programming book

Table of Contents

The objective of this book is to teach the secrets of developing a Web ERP software application using ASP.Net and C#.

Chapter : 1. Introduction to Visual Studio 2015

  1. Understanding .NET 2015 components
    • .Net framework 4.6
    • .Net Core 1.0
    • Core CLR
    • .Net Native
    • Compilers
    • ASP.NET Core 1.0
    • Universal Windows apps
    • ASP.Net 4.6
  2. Introduction to ASP.NET Web Forms
  3. Deciding when to create a Web Forms Application
  4. Advantages of a Web Forms-Based Web Application
  5. Working of ASP.Net Applications
  6. Advantages of an MVC-Based Web Application
  7. ASP.NET 4.5 features
  8. New features in ASP.NET Web Forms in .NET 4.6
  9. Creating ASP.Net 4.6 application in VS 2015
  10. Code behind page model
  11. ASP.NET Page Syntax
  12. Overview of ASP.Net server controls
    • Using Labels and TextBox controls
    • Using Button control, LinkButton and ImageButton
    • How to wire multiple controls in a page to the same event handler
    • Using ListBoxes and DropDown Lists
    • Creating Multiple-Selection List boxes
    • Get the selected Item in the single-selection ListBox control
    • Get the selected Items in the multiple-selection ListBox control
    • SelectedIndexChanged event of ListBox control
    • Creating ListItem objects and adding them to a Control using the Add() method
    • Removing items from a multiple-selection ListBox control
    • Using CheckBoxes and RadioButtons
    • Get the Selection in a RadioButton Control using Radio button click event
      • Check Box control
      • RadioButtonList and CheckBoxList controls
      • Get selected items from the CheckBoxList control
    • Validation Controls
    • RequiredField Validator
    • CompareValidator Control
    • RangeValidator Control
    • Regular Expression Validator Control
    • CustomValidator Control
    • ValidationSummary Control
    • Using Validation Groups

Chapter : 2. Data Access in ASP.Net Application

  1. The SqlDataSource control
  2. How to Connect to a SQL Server Database Using the SqlDataSource Control
  3. Creating a SqlDataSource control declaratively
  4. Storing Connection String in Web.config file
  5. Executing Data Commands with the SqlDataSource Control
  6. Binding a ListBox Control to the SqlDataSource control
  7. Setting DataSouceMode property
  8. SqlDataSource control Events
  9. Using parameters with SqlDataSource control
  10. Properties of ASP.Net parameter objects
  11. SqlDataSource control Collections
  12. How to set SqlDataSource's parameters before the select command is executed
  13. Using the ASP.Net ControlParameter Object
  14. Overview of GridView control
  15. Properties of GridView control
  16. GridView Events
  17. GridView Methods
  18. Display, edit and delete data in the GridView control using SqlDataSource control
  19. Programmatic DataBinding in a GridView Control
  20. Formatting GridView control
  21. Formatting GridView control with CSS
  22. Using fields with the GridView control
  23. Using BoundFields
  24. How to Format date and currency column using DataFormatString property
  25. Using Command Fields
  26. Using Template Fields
  27. How to use Eval() and Bind() method
  28. Display a DropDownList when Editing in the GridView using EditItemTemplate
  29. How to insert new data into the database with GridView control using FooterTemplate
  30. How to restrict an item from being selected using GridView SelectedIndexChanging Event
  31. DetailsView and FormView control
  32. Using Fields in a DetailsView control
  33. Using style elements in a DetailsView control
  34. Creating a DetailsView control
  35. Data Binding with the DetailsView Control
  36. Using DataSourceID property
  37. Using DataSource property
  38. DetailsView Properties
  39. DetailsView Events
  40. Using Command buttons in DetailsView
  41. Using Templates in a DetailsView control
  42. How to create Master - Detail page by using GridView and DetailsView control
  43. FormView control
  44. FormView vs. DetailsView control
  45. How to use FormView control to update and insert data

Chapter : 3. ERP Domain

  1. Introduction
  2. Technologies for ERP software
  3. Platform suited for creating ERP software
  4. ERP software overview
  5. ERP software implementation issues
  6. Resources required for implementing ERP software
  7. Benefits of ERP software
  8. SAAS and ERP
  9. Role of softwares in an ERP system
  10. ERP software and standardization of business processes
  11. Working of the Finance department
  12. Working of the Sale department
  13. Working of the Purchase department
  14. Working of the Manufacturing department
  15. Working of the Inventory department
erp asp application development server controls, web forms, data accesa controls, binding server controls, master detail form

Chapter : 4. ERP Application Architecture

  1. Benefits of Multi-tier Architecture
  2. Purpose of Presentation Layer
  3. Purpose of Business Layer
  4. Purpose of Data Access Layer
  5. Purpose of Data Layer
  6. Creating Web ERP Application Framework using Visual Studio
    • Creating a Class Library for the Data Access Layer
    • Creating a Class Library for the Business Layer
    • Creating a Web Application for the Presentation Layer
  7. Developing Data Access Layer in C#
  8. Creating DataServer Class
  9. Constructor of the DataServer class
  10. DataServer Class Methods
  11. Introduction to Master pages
  12. Creating a Master page for the ERP Web Application
  13. How to place a Menu control on a Master page

Chapter : 5. Developing Finance Module

  1. Business processes in Finance Module
  2. Presentation Layer of Finance Module
  3. Creation of Accounts
  4. Designing and Programming the AccountsDialog.aspx
  5. Managing ASP.Net Navigation using Server.Transfer method
  6. Send a parameter to another page using Server.Transfer method
  7. Designing and Programming the AccountsForm.aspx
  8. Bind the DropDownList control to a ObjectDataSource control
  9. Using SelectMethod property of ObjectDataSource
  10. TypeName property of ObjectDataSource
  11. OnSelecting property of ObjectDataSource
  12. Import the namespace of Business Layer
  13. Retrieve Query String Values in Page_Load() event using Request.QueryString
  14. Set ObjectDataSource's parameters using Selecting event - ObjectDataSource1_Selecting
  15. Save the Account Details
  16. Creating Business Object - Account.cs
  17. Retrieve Groups
  18. Steps to interact with the DataAccessLayer
  19. Save the Account details
  20. Connecting AccountForm to the menu
  21. Creating Customer, Supplier, Bank and General Account using the AccountsForm.aspx
  22. Chart of Accounts
  23. Designing and Programming Chart of Accounts.aspx
  24. Placing a TreeView control on a ChartofAccounts.aspx
  25. Populate the root level nodes in Page_Load() event
  26. Populate the child nodes of a given node
  27. Program the TreeNodePopulate event
  28. Creating Business Object - Group.cs
  29. Return main groups
  30. Return only sub-groups under a particular group
  31. Designing the JournalForm.aspx for the Journal Voucher Transaction
  32. Steps to design the JournalForm.aspx
  33. Create and set important properties and methods of the GridView control
  34. Create Template columns in the GridView control using asp:TemplateField element
    • ItemTemplate
    • EditItemTemplate
    • Footer Template
    • Create a Template column for the AccountName column in the JV
    • Create a Template column for the Debit column in the JV
    • Create a Template column for the Credit column in the JV
  35. Create a Template column for 'Insert' Button
  36. Create a 'Delete' Command button and 'Edit' Command button
  37. Create EmptyDataTemplate to accept first row of data when datasource is empty
  38. How to place the ObjectDatasource control, Transaction number, Date and totals of Credit and Debit column amounts on the form
  39. How to insert multiple accounts in the GridView control
  40. Steps to program the JournalForm.cs
  41. Building the DataTable Structure for the GridView
  42. Program the Page_Load event to bind the DataTable to the GridView control
  43. Program the Add New Record button to add a new row of data to the GridView using EmptyDataTemplate
  44. Access the controls placed in the EmptyDataTemplate
  45. Program the Insert button to add a new row of data to the GridView using FooterTemplate
  46. Retrieve the values of controls (DropDownList and TextBox controls) which are in the Footer Template
  47. Retrieve existing accounts from the Session object and assign to DataTable
  48. Save the DataTable into a session
  49. To get the value from a particular cell, which is a TemplateField
  50. Program the Event handler for the EditCommand event
  51. protected void grdAccounts_RowEditing(object sender, GridViewEditEventArgs e)
  52. Program the Cancel button
  53. protected void grdAccounts_RowCancelingEdit(Object sender, GridViewCancelEditEventArgs e)
  54. Program the Event handler for the DeleteCommand event
  55. protected void grdAccounts_RowDeleting(object sender, GridViewDeleteEventArgs e)
  56. Delete a row from the DataTable
  57. Commit all the changes made to this DataTable
  58. Assign DataTable as DataSource to the GridView and bind the GridView
  59. To clear the selection of a row, we set the SelectedIndex property programmatically to -1
  60. Program the Update button
  61. protected void grdAccounts_RowUpdating(object sender,GridViewUpdateEventArgs e)
  62. Program the function which keeps a running total of the debit amounts of the accounts
  63. Program the procedure for checking Double Entry rule
  64. Program the Save button
  65. Designing and Programming Voucher/ Receipts Transactions
    • Cash Voucher
    • Cash Receipt
    • Check Voucher
    • Check Receipt
  66. Creating Business Object - Transaction.cs
    • Return Cash and Bank Accounts
    • Return Accounts based on menu selection
    • Save transaction details and return boolean value if transaction updation is successful

Chapter : 6. Developing Sales and Purchase Module

  1. Business processes in Sales Module
  2. Design and Program the OrderForm.aspx for creating Sales orders and purchase orders
  3. Place the DropDownList control and bind it to the ObjectDataSource control to display customer names
  4. How to insert multiple items in the orderForm.aspx
  5. Perform Validations in order Form
  6. Save Sales order /Purchase orders
  7. Update Order details
  8. Program the function which calculates the order total
  9. Program the function for calculating order net amount
  10. Designing and Programming ordersGrid.aspx
  11. Pick and Pack Sales orders
  12. Pick Shipping orders
  13. Back orders
  14. Pending Purchase orders
  15. Designing and Programming InvForm.aspx
  16. Program the function which calculates the invoice total
  17. Program the procedure for checking Double Entry rule
  18. Program the Save button
  19. Validate the TextBox control placed in the Footer using TextChanged event
  20. Validate the TextBox control placed in the EmptyDataTemplate using TextChanged event
    • Programming Purchase Invoice
    • Programming Sale Invoice
    • Programming the Cash Sales
    • Programming the Cash Purchase
    • Programming Purchase Returns
    • Programming Sale Returns
  21. Business Object - Trade
    • Retrieve Customer/Vendor Accounts
    • Retrieve Trade Accounts from the database
    • Retrieve Discount, Freight and Tax Accounts
    • Saving the Transaction details

Chapter : 7. Developing Inventory Module

  1. Business processes in Inventory Module
  2. Designing and programming the ItemForm.aspx for creating different types of items - Raw Material, Consumable, Sub Assembly or a Finished Product
  3. Designing and programming the MaterialIssueForm.aspx to issue components to manufacture products
  4. Business Layer of Inventory Module
  5. Business Object - Item.cs
    • Retrieve Stock Groups from database
    • Retrieve Item types
    • Save the Item details
    • Business Object - Issue
      • Return information about single Work order
      • Saving Issue details

Chapter : 8. Developing the Manufacturing Module

  1. Business processes in Manufacturing Module
  2. Designing and Programming BOMForm.aspx for Creating Bill of Materials
  3. Designing and Programming WorkOrderForm.aspx for creating work orders
  4. Business Layer of Manufacturing Module
  5. Business Objects - BOM
    • Return information about all Items
    • Return list of Poducts
    • Return Components for a parent Item
    • Save Product Structure
    • Create product structures using BOMForm.aspx
    • Display product structures using BOMDisplay.aspx
  6. Business Objects - WorkOrder
    • Return names of Products
    • Return Information about Components and their Quantities which are required to manufacture one parent item (product)
    • Save Work Order details