Database Programming using C# 2015, Visual Basic 2015 and SQL Server
(Secrets of Developing an Accounting Package using C#, Visual Basic 2015 revealed )Prev Book Contents » Next Book Contents » Price »
Detailed Comparision with SAP Business One »»
Special Offer, Learner Pack = 8 Books + Software
Free, 6 Books + Software
Pay only for 2
Table of Contents
The objective of this book is to teach the secrets of developing an accounting software package for the .Net platform using Visual Basic, C# , ADO .Net, SQL Server and Crystal Reports. Techniques of developing a complete accounting software package are taught using business logics, programs, flow charts and this makes learning easier.You will also learn how to create stored procedures and triggers, program the transactions of an Accounting Software, program reports using Crystal Reports, about disconnected architecture, MDI applications and how to use T-SQL.
Chapter : 1. Get started with Visual Studio 2015
- Introduction to Visual Studio 2015
- Understanding .NET 2015 components
- Components of the .NET Framework 4.6
- Visual Studio 2015 Integrated Development Environment
- Creating a new Project in Visual Studio 2015
- User Interface Elements of Visual Studio 2015 IDE
- Design Window
- WPF Designer
- Web Forms Designer
- Solution Explorer Window
- Properties Window
- Toolbox
- Output Window
- Task list window
- Server Explorer Window
- Code Editor Window
- Windows Forms
- Windows Form Properties
- Windows Forms Events, Handles keyword
- Windows Form Methods
- Windows Form Controls
- Text box Control
- Label Control
- ListBox Control
- Selecting Items in ListBox Control
- CheckBox Control
- ComboBox Control
- RadioButton Control
- GroupBox Control
- Button Control
- Control Events
- Keyboard Events
- Mouse events
- Control - specific events
- Working with Windows Form Controls and Events
- Visual Basic 2015 Language Features
- Data Types in VB 2015
- Variables
- Declaring Variables
- Variable Naming Conventions
- Variable Initialization
- Variable Scope
- Block Scope
- Procedure Scope
- Module Scope
- Namespace Scop
- Life time of a variable
- Constants
- Arrays
- Declaring an array
- Multidimensional Arrays
- Assigning values to array elements
- Dynamic Arrays
- Preserve Keyword
- Operators
- Arithmetic Operators
- Comparison Operators
- Logical Operators
- Concatenation Operators
- Control flow constructs
- Decision structures
- If - Then - Else
- Select Case Construct
- Loop structures
- While - End While Loop Structure
- Do-Loop Structure
- For-Next Loop Structure
- Nested Control Statements
- Procedures in Visual Basic 2015
- Sub Procedures
- Access Modifiers used with Sub Procedures
- Argument Declaration in a Sub Procedure
- Passing arguments to a Sub Procedure
- Calling a Sub Procedure
- Types of Sub procedures
- General procedures
- Event-handling procedures
- Function procedures
- Return Values of a Function Procedure
- Calling a Function Procedure
- Property Procedures
- Procedure Overloading
- How to create Parameter Array
- Rules to be followed while using a Paramter Array
- Passing arguments of a Parameter Array
Chapter : 2. C# Fundamentals with VS 2015
- Data Types in C# 2015
- Variables
- Rules to create an identifier
- Initialization of Variables
- Variable Scope
- Constants
- Arrays
- Assigning values to Arrays
- Two Dimentional Arrays
- MultiDimensional Arrays
- Jagged Arrays
- Operators
- Arithmetic Operators
- Relational Operators
- Logical Operators
- Assignment Operators
- Increment and Decrement Operators
- Ternary Operators
- Control flow constructs
- Conditional Statements
- if..else
- switch..case statement
- Loops
- while loop
- do...while loop
- for loop
- Collections
- Non-Generic Collections
- Generic Collections
- Working with ArrayList
- Adding items to the ArrayList using an Add Method
- Iterating through items
- Using Indexers
- Using Enumerators
- Using ForEach loop
- Inserting items to the ArrayList using Insert and InsertRange method
- Adding items to the ArrayList using AddRange Method
- Removing items from ArrayList
- IndexOf Method
- Problems with ArrayList
- Generics
- When to use a Collection?
- Performance issues when working with collectins -List and Dictionary
- Adding Data into List
- Collection initializers
- Interating through the Customer List
- Sorting in Lists
- Usageof IComparable and IComparer and interafce to sort Lists of objects on custom classes
Chapter : 3. Object Oriented Programming in Visual Basic 2015 & C# 2015
- Namespaces
- Creating a Namespace in VB & C#
- Creating Nested Namepsaces in VB & C#
- Creation of aliases for namespaces in VB and C#
- How to access members of a namespace in VB and C#
- Structures
- Declaring a Structure
- Access Modifiers
- Similarities between Classes and Structures
- Differences between Classes and Structures
- Create a Structure in Visual Basic 2015
- Structures and Property Procedures
- Initialization in Structures
- Structure and Constructors
- Create a Structure in C# and use it in Windows Forms Application
- Writing a Constructor to initialize Structure member variables in C#
- Using Classes in Visual Basic 2015 & C# 2015
- Advantages of using Classes and Objects
- Creating a Class in Visual Basic 2015
- Property Procedures
- Property Declaration in VB 2015
- Property Declaration in C# 2015
- Using C# Language Feature: Automatic Properties for defining Property Procedures
- Constructors
- Instance Constructor in VB 2015
- Instance Constructor in C# 2015
- Write the code to instantiate the class
- Run the application
- Shared constructor in VB 2015
- Static constructor in C# 2015
- Destructors
- Finalize() Destructor
- Dispose() method
- Inheritance
- Declaration of Account Class
- Constructor overloading in vb.net
- Creating a derived class - PartyAccount
- Creating a constructor in derived class with parameters
- Creating a derived class - BankAccount
- Polymorphism
- Compile time Polymorphism/ Method OverLoading
- Implementing runtime Polymorphism / Overriding
- Example of runtime Polymorphism in VB 2015 and C#
- Abstract Classes
- Creating Abstract Classes
- Creating Abstract Members in Abstract Class
- Implementing Abstract Class
- Testing - Abstract class
- Testing - Abstract class and Polymorphism
- Polymorphism through Inheritance
- Creating An Abstract Class in C# 2015
- Implementing An Abstract Class in C#
- Testing - Abstract class and Polymorphism in C#
- Interfaces
- Difference between interfaces and abstract classes
- Why use interfaces
- Declare an Interface in VB 2015
- Create Invoice class which implements IPayableHandler Interface
- Create Employee class which implements IPayableHandler Interface
- Testing - Interface and Polymorphism in VB 2015
- Declare an Interface in C# 2015
- Create Invoice class which implements IPayableHandler Interface
- Create Employee class which implements IPayableHandler Interface
- Testing - Interface and Polymorphism in C# 2015
- Implementing Visual Inheritance
Chapter : 4. Working with SQL Server 2012
- SQL Server Management Studio
- Authentication Modes in SQL Server 2012
- Understanding Windows Authentication mode
- Understanding SQL Server Authentication mode
- Changing SQL Server Authentication mode
- SQL Server Object Explorer
- Securing the Database
- Create Logins
- Add Logins to Server Roles
- Fixed Roles
- Grant access to Databases
- Implementing Physical Database Schema
- Creating the Database Files
- Configuring the File Growth
- Using Multiple Files
- Multiple File Groups
- Creating a Database with File Groups
- Creating schemas
- Tables with SQL Server Management Studio
- Creating Tables with SQL Server Script
- Creating Primary Keys
- Using Identity Columns and GUIDS
- Declarative referential integrity
- Creating Indexes
- Structured Query Language
- T-SQL
- Triggers
- Transactions
Chapter : 5. How to use ADO.Net in VB 2015 & C# 2015
- An introduction to ADO.Net
- The ADO.Net Object Model
- Dot Net Data Providers
- Connection Object
- Command Object
- DataReader
- Retrieving data using DataReader and Displaying in Textboxes
- DataAdapter Properties and Methods
- DataSet
- Typed vs Untyped Datasets
- Navigating through Datasets
- Updating the Database using Dataset and DataAdapter
- Detecting & Handling changes to Data in a Dataset
Chapter : 6. Accounting for Developers
- Business Transactions
- Financial Position and Accounting Equation
- Accounts
- Commonly used Accounts
- Chart of Accounts
- Groups
- Double Entry System
- Analysis of Transactions
- The Voucher System
- Typcial Transactions
- Financial Statements
Chapter : 7. Developing the Financial Accounting Application in VB 2015 & C# 2015
- Developing the Masters
- Creating the Project
- Writing Standard Modules
- Creating the FinAccounting Database
- Exploring the FinAccounting Database
- Populating the Group Table with Chart of Accounts
- Designing & Programming the Accounts Form to enter Customer Accounts, Supplier, Cash Accounts, Bank Accounts and General Ledger accounts like Asset A/cs and Liability Accounts
- Programming the AccountsForm
- Writing a Constructor
- Programming the AccountsForm_Load() event procedure
- Steps:
- Establish a Connection with the SQL Server Database
- Populate the listbox with Groups (Chart of Accounts)
- Instantiate the Commands
- Instantiate the DataAdapter
- Set the DataAdapter command properties
- Add parameters to the sqlCommand
- Instantiate the DataSets
- Populate the DataSet
- Traverse the DataSet, filter the Dataset and populate the listbox with Accounts
- Add Insert Command parameters
- Add Update Command parameters
- Add Delete Command parameters
- Achieve error free/rapid data entry by enable/disable controls
- Saving Account details into the DataSet
- Program the New button of Accounts Form
- Program the Edit button of Accounts Form
- Program the Delete button of Accounts Form
- Moving to a particular row in the DataSet
- Program the Update button of Accounts Form to Save the account details to the SQL server database
- Connecting the Accounts Form to the Menu
- Enter Customer Accounts, Supplier, Cash Accounts, Bank Accounts and General Ledger accounts like Asset a/cs and Liability Accounts using the Accounts Form
- Developing Financial Accounting Transactions
- Cash Voucher Transaction
- Cash Receipt Transaction
- Cheque Voucher Transaction
- Cheque Receipt Transaction
- Purchase Transaction
- Sale Transaction
- Journal Voucher Transaction
- Debit Note
- Credit Note
- Understand the Validations to be implemented to maintain Double Entry in Financial Accounting Transactions
- Developing the Tran Class
- Add a class to the project.
- Declare the member variables
- Class constructor
- Writing property procedures
- Writing a class method to retrieve Accounts data from database using Stored Procedure and filling the DataSet
- Class method to retrieve only Cash and Bank Accounts
- Writing a class method to Save the complete transaction data which contain multiple accounts into the TranTable
- Designing and Programming the Journal Voucher Form - User Interface
- Placing DataGridView for accepting multiple Accounts in JounalForm
- Programming the JournalForm_Load() event procedure
- Create a Table Structure using DataTable for programming the DataGridView control to accept multiple rows of data in the Journal Form
- Bind DataGridView control to the DataTable
- Write a Procedure GetAccounts() to call TranClass method to retrieve accounts and Fills the Accounts Combobox Control
- Write a Procedure CheckSavebutton() to enable Save button only if Debit Amount total is equal to Credit Amount total in a Transaction
- Program the Add button of Journal Voucher Form
- Program the Edit button of Journal Voucher Form
- Program the Delete button of Journal Voucher Form
- Program the Save button of Journal Voucher Form
- Designing and Programming the Voucher Form
- Designing and Programming the Receipt Form
- Designing and Programming the Purchase Form
- Designing and Programming the Sale Form
- Designing and Programming the Credit Note Form
- Designing and Programming the Debit Note Form
- Connecting Trasnsaction forms to the Menu and enter Finacial Accounting Transactions - Journal Entries, Cash Voucher, Cheq Voucher, Bank Voucher and Bank Receipts
Chapter : 8. Creating Reports in Crystal Reports using Visual Basic and C#
- Introduction
- Designing and Programming the Trial Balance
- Designing and Programming the DayBook
- Designing and Programming the Registers
This book adopts an object oriented approach to develop an Visual Basic 2015 and C# 2015 and SQL Server Accounting application. You will appreciate why an object oriented approach is used in application development. The programs which come with source code reveal the benefits of OOPs. The reports and transactions dealt with in this book are unique to an Accounting application. This book lays a good foundation for developing a client/server accounting application.
Unlike most other books, erp software development books cover all the end to end issues of developing database applications.