C#.Net ERP Software Tutorial A to Z Part One

Introduction

According to Aspiring Minds National Employ-ability Report, which is based on a study of more than 1, 50,000 engineering students who graduated in 2015 from over 650 colleges, 80% of them are unemployable.

Over 1.5 million engineering students graduate every year in India. This is difficult to get job for everyone. I think self-employment is a good solution for this crisis. Creation of useful applications for mobile, web and desktop is a good choice for earnings.

In this article series, I am intended to disclose my windows desktop ERP software creation experience before you.

To know more about the accounting application I have made please click on the link

Requirement

1	Basic Computer Knowledge
2	Windows PC(Desktop or Laptop)
3	Visual Studio (VS 2010 or above)

1.        

Topics Covering In this Series

1	Accounting Basics
2	C# programing language
3	Visual Studio
4	Windows Form Application
5	T-SQL
6	SQL Server
7	Ado.net
8	Linq
9	Storing data in XML
10	DataGridview in details
11	Printing Technics
12	Publishing the Application (Setup Creation with Database)
13	ASMX web service
14	Security (Prevention of Reverse Engineering)

Accounting Basics

To create an accounting application we want to know something about accounting.

The foundation of accounting is Debit and Credit. As debit is comes in and credit is goes out.

For example we are purchasing a furniture for our company office with paying cash of Rs. 500. Debit Rs. 500 in furniture account and credit the same in cash account.  As the value of furniture is increased by addition of Rs. 500 and at the same time amount of cash in hand is decreased by paying Rs. 500.    

In accounting application, all transaction are in voucher type. In a voucher table normally there are followings Columns. 

1	VoucherId
2	VoucherType
3	VoucherNumber
4	VoucherDate
5	AccountingID
6	OppositeAccountingId
7	DebitAmount
8	CreditAmount
9	Narration
10	EntryDate
11	EnteredBy

In here, we want to create two voucher entries. Please note that every accounting transaction there will be two accounts. So we want two entries.

		A	B
1	VoucherId	1	2
2	VocherType	PurchaseOfFixedAsset	PurchaseOfFixedAsset
3	VoucherNumber	1	1
4	VoucherDate	15/03/2018	15/03/2018
5	AccountId	FurnitureAccountID	CashAccountID
6	OppsiteAccountId	CashAccountID	FurnitureAccountID
7	DebitAmount	500	0.00
8	CrditAmount	0.00	500
9	Narration	A chair Purchased	A chair Purchased
10	EntryDate	04/03/2018	04/03/2018
11	EnteredBy	EnteredPersonID	EnteredPersonID

This is the basic. But we have to mention in details about ledger group, ledger account, Trading Account, Profit and Loss Account and Balance Sheet etc.  In the coming chapters we will cover occasionally about all these accounting aspects. Also we have to mention about Inventory.

Inventory

In accounting, Maintaining Inventory is an important part. Dealings of products and services is Inventory.

There are two types of products. Manufacturing products and purchased products. We want to make an entry to maintain the stock of the product. That is, when we sell one product to a person there are two types of entries.

1	Accounting entries
2	Inventory Entry

As besides the accounting entry we want to make an Inventory entry. Earlier we have seen that in accounting, all transactions are in voucher type. Normally there will be following columns for Inventory Transaction Table

1	TransactionId
2	VoucherID
3	ProductId
4	UnitId
5	QuantityIn
6	QuantityOut

By giving the format of table, I think you could understand about an inventory type transaction. As in the case of inventory happening goods is coming or goods is goes out. As in details, in the case of purchase the stock of that particular product is increasing. At the same time in the case of sale the stock of such product is decreasing.

For example I am a local dealer of Chairs. I am selling a Chair to a person. Then the following entry will happen.

1	TransactionId	1
2	VoucherID	1
3	ProductId	ChairID
4	UnitId	UnitID
5	QuantityIn	0.00
6	QuantityOut	1.00

We mentioned two types of table for understanding the basics of accounting entries. In an accounting application we have to create twenty five plus tables.

Now we have discussed something about accounting, then we can go to the development section.

Firstly we want to download the Visual Studio.

Downloading Visual Studio

I am using visual studio 2010. But the latest visual studio version is the Visual Studio 2017. You can download Community edition for free.

Let us type ‘Visual Studio Community’ in Google search bar and then double click on the first link.

Then we can see the download page. Click the download button.

Now the download of Visual Studio Community Installer will start. You can save the file on Download folder or somewhere you want.

If the download process is completed, you can see the file in download file. To start installation, double click on the file.

The installed will start. For that press on Continue button.

Then The Visual Studio Installer window will open. There are many options for installation. If you are a cross platform mobile developer you can put tick on Xamarin. And for web developer can select Asp.net development option.

Here for us, have to select two categories. One is “.Net Desktop Development” and second is “Data Storage and Processing”.

We select .Net Desktop Development for Windows Form Application development purpose. In this platform we will develop our Accounting Application with C# programing language.

We want to store our data in SQL Server. So we also select Data Storage and Processing option.

Some minutes will take to complete the installation process. After finishing the installation, click on startmenu icon. Then will start the visual studio. We can see the Start Page. For creating new project click on the link named “Create new project”

Now project window will open.

Select C# programming language, then Windows Classic Desktop and finally select Windows Forms App. In the name section you can type any name you want. And then press ‘OK’ button.

Now we can see the window, here all the application development process is happening. I have marked five areas. All are important in visual studio.

1. Solution Explorer

In here, we can see the files in our project

2. Graphic User Interface

This is the interface of our application. Here we create our application.

3. Tool Boxes.

From here we can drag and drop controls like button label and textboxes to the GUI to crate the application.

4.Properties

From here, we can change properties of controls in the Graphic User Interface.

5. Server Explorer

In here we can see the server and databases we using in the application.

Conclusion

We have to mention about all topics. In c# language, will discuss about variables, arrays, operators, list, methods, classes, properties and different types of statements etc.  At the same, this will be difficult to cover all parts in details. So referring the projects I have made will help you to understand the lessons completely. If you want the same please mail to me in ashpro2013@gmail.com.

Thank you for reading this blog post.