Develop Web ERP Software using ASP.Net 3.5, C# & SQL Server


another cover image of asp.net book
ISBN: 81-901331-7-9
Price: $44.90
Weight: 1.6 Pounds
Pages: 287

Objective

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

Chapter : 1. Introduction.

  1. The .Net Framework 3.5
  2. Create an ASP.Net 3.5 application
  3. Code models in ASP.Net 3.5
  4. Single-File Page Model
  5. Code behind Page model
  6. Which model is better?
  7. Advantages of Single-File Pages
  8. Advantages of Code-Behind Pages
  9. ASP.NET Page Syntax
  10. Overview of ASP.Net server controls
    • Standard Controls
    • Data Controls
    • Validation Controls
    • Navigation Controls
    • Login Controls
    • HTML Controls
    • ASP.NET AJAX Extensions Controls
    • WebParts
  11. How to wire multiple controls in a page to the same event handler
  12. Using ListBoxes and DropDown Lists
  13. Creating Multiple-Selection List boxes
  14. Get the selected Item in the single-selection ListBox control
  15. Get the selected Items in the multiple-selection ListBox control
  16. SelectedIndexChanged event of ListBox control
  17. Creating ListItem objects and adding them to a Control using the Add() method
  18. Removing Items from a specific location
  19. Removing Items from a multiple-selection ListBox control
  20. Using CheckBoxes and RadioButtons
  21. Get the Selected Item in a RadioButton Control using Radio button click event
  22. Check Box control
  23. RadioButtonList and CheckBoxList controls
  24. Get selected items from the CheckBoxList control
  25. Validation Controls
  26. RequiredField Validator
  27. ErrorMessage Property
  28. Using InitialValue property of RequiredFieldValidator with TextBox control
  29. Using InitialValue property of RequiredFieldValidator with DropDownList control
  30. Display Property
  31. Enabled Property
  32. EnableClientScript Property
  33. The CompareValidator Control
  34. Performing a Data type Check
  35. RangeValidator Control
  36. Regular Expression Validator Control
  37. CustomValidator Control
  38. Client-Side Validation
  39. ValidationSummary Control
  40. Using Validation Groups
  41. How to use a single button to validate multiple validation groups

Chapter : 2. Data Access in ASP.Net 3.5.

  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 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 : 4. 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 : 5. 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 : 6. 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 : 7. 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














.net, sql server, C#, symbols. owned by microsoft.


order