Sunday, 23 December 2012

A Free C# Billing Application with Source Code (.NET)

Biller - The Free Billing Application

I am glad to present Biller - a free billing application. This application has been developed keeping small Indian businesses in mind. In India, most of the goods are sold without paying any taxes i.e. tax evasion is done on most of the sales, and hence no tax is added in the invoice. The invoices issued to the customers in general are not the ones that are shown to the Sales Tax officials. This application therefore in keeping in mind its target users don't support the concept of tax. 

Application Screenshots

16 screenshots of the application are available. To view these, please click this link.
Application Screenshots link

Application Download

The application can be downloaded for free. The application download size is less than a MB. 
Application Download link

Application Pre-requisites (Important)

Though the application code itself is quite small, the framework and tools used by it are bulky. To install and run the application, you need to have the following software installed on your computer:

1) .NET Framework 4.0
Full version of .Net Framework 4.0 needs to be installed on your computer. The compact version of .NET Framework better known as the Client Profile version won't suffice for running this application as it uses Crystal Reports.
.NET Framework Download link


If you are using Windows 8, then you are not required to download the .NET Framework as Windows 8 comes bundled with .NET Framework 4.5.

2) Crystal Reports Runtime Engine for .NET Framework 4.0
Though I hated to use it in my application due to its bulkiness, I had no other option but to use it as it is the only professional quality reporting tool available for .NET world for free. Microsoft's ReportViewer infrastructure that comes bundled with Visual Studio is not adequate for professional reporting requirements.
Download link for Crystal Reports Runtime Engine for .NET Framework 4.0


Application Source Code

Full souce code of the application is available for download. The application has been written in C# using Visual Studio 2010. The database used is SQL Server Compact Edition (CE) version 4.0.  

Application Source Code Download link
 

Few people may wonder why I am making available the complete source code of the application available for free. Well, to tell you the truth it was a tough decision and at the same time easy decision for me to take. It was tough because for a developer the source code is a very valued and dear capital. Its value can only be appreciated by those people who have devoted their significant time and energy to acquire the knowledge to write it. And it was a easy decision for me to take because I really wanted to give something back to the world. It is my way of expressing my gratitude and acknowledge indebtedness to the Internet community for their magnanimity and helpfulness. If it were not for the help available to me through numerous articles, tips and tricks, free e-books, code samples & Videos posted on Internet, and also help offered by kind souls available in various forums, I would not even think about writing software.

Feedback Solicited

I would love to receive your feedback about the application - good or bad. You can provide the feedback through the comment section to this blog post. You can also email me on the email address provided in the 'About...' option under the Help menu in the application.

Thank you :-))

 

38 comments:

  1. Nice software but there is some bugs on the dashboard try to solve that out otherwise very fantastic work mate.
    Awesome work keep it up.

    ReplyDelete
  2. Error 2 The type or namespace name 'ErikEJ' could not be found (are you missing a using directive or an assembly reference?)
    I Am getting this error. please give me solution to this.

    ReplyDelete
    Replies
    1. Hi, this error is due to a missing .dll file reference. The file is named " ErikEJ.SqlCe40.dll", and is a part of the SQLCeBulkCopy, a library developed by Sql Server MVP ErikEJ. You can download it from here: http://erikej.blogspot.in/2011/09/sqlcebulkcopy-library-for-fast-sql.html.
      Hope this helps :-)

      Delete
    2. The type or namespace name 'ErikEJ' could not be found (are you missing a using directive or an assembly reference?)

      http://erikej.blogspot.in/2011/09/sqlcebulkcopy-library-for-fast-sql.html. this link is not working

      Delete
    3. NuGet package link for SQLCeBulkCopy library : https://www.nuget.org/packages/ErikEJ.SqlCeBulkCopy/

      Delete
  3. Nice software but how can i change tables in database File (Biller-FY-2015-2016.bcz)
    Please can you tell me how to connect database file with .net

    Niranjan

    ReplyDelete
    Replies
    1. Hi, just change the database file extension to '.sdf' so that the new file name will be like Biller-FY-2015-2016.sdf. This is actually a SQl Server Compact 4.0 file, and it can be opened and edited in Visual Studio using the add-in SQL Server Compact/SQLite Toolbox (https://visualstudiogallery.msdn.microsoft.com/0e313dfd-be80-4afb-b5e9-6e74d369f7a1).

      Delete
    2. it does not work for , same problem i have occurred. missing ErikEJ, so to solve that

      Delete
  4. Hi Dinesh, need help in adding some features. Have sent you mail on id provided in readme file. Please respond...

    ReplyDelete
  5. Hi Dinesh, need help in adding some features. Have sent you mail on id provided in readme file. Please respond...

    ReplyDelete
  6. Replies
    1. Hi, just change the file extension from .bcz to .sdf and open (and optionally edit) it in Visual Studio using the add-in SQL Server Compact/SQLite Toolbox (https://visualstudiogallery.msdn.microsoft.com/0e313dfd-be80-4afb-b5e9-6e74d369f7a1).

      Delete
  7. How to remove $ symbol from billreceipt
    I want to replace with rupee symbol

    ReplyDelete
  8. Hi Dinesh, Nice work.
    but how can i add inventory control in it?

    ReplyDelete
  9. where is database file located.?

    ReplyDelete
  10. Hi.. could not find database file , where is database file located.?

    ReplyDelete
  11. Hi Dinesh Its Wonderful application.I look the source code but its to complicated can u guide me to create this app Its my Humble request

    ReplyDelete
  12. I tried exe file but it gives me crystal report error, can you help me with this error

    ReplyDelete
  13. Cannot find database file. Please Help!

    ReplyDelete
  14. Hi, this error is due to a missing .dll file reference.

    ReplyDelete
  15. Nice work. Thanks for sharing!

    ReplyDelete
  16. Cannot find database file. Please Help!

    ReplyDelete
  17. hi, i need help please reply my mail, i sent you.

    ReplyDelete
  18. Nice Software, but how can i add Free column (Free goods)

    ReplyDelete
  19. This comment has been removed by a blog administrator.

    ReplyDelete
    Replies
    1. I want to some changes in this program ...
      please send your contact no. In my email
      Manishgrapics@gmail.com

      Delete
  20. Plz Tell Me Sir how To Change Print Preview

    ReplyDelete
  21. where is the database located

    ReplyDelete
  22. Hi, this error is due to a missing .dll file reference. The file is named " ErikEJ.SqlCe40.dll", and is a part of the SQLCeBulkCopy, a library developed by Sql Server MVP ErikEJ. You can download it from here: http://erikej.blogspot.in/2011/09/sqlcebulkcopy-library-for-fast-sql.html.

    This site not available any other site

    ReplyDelete
  23. how to add new Gst feature in this project please help me and which table are add in this project

    ReplyDelete
  24. hi, is this crystal report engine is free library ? and can be used any professional software without buying licence ?

    ReplyDelete
  25. How to edit datatable in billmasters

    ReplyDelete
  26. hi when open the database file it asks for the passphrase
    "sql cipher encryption"please provide me that

    ReplyDelete