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 :-))

 

71 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
    Replies
    1. hello did you find how to remove $ symbol

      Delete
  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. can i link with oracle database

    ReplyDelete
  21. Plz Tell Me Sir how To Change Print Preview

    ReplyDelete
  22. where is the database located

    ReplyDelete
  23. 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
  24. how to add new Gst feature in this project please help me and which table are add in this project

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

    ReplyDelete
  26. How to edit datatable in billmasters

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

    ReplyDelete
  28. Excellent work brother

    ReplyDelete
  29. Learned a lot of new things from your post!Good creation ,thanks for good info Dot Net Online Training Hyderabad

    ReplyDelete
  30. Hi Dinesh, it's a nice billing application of yours. After briefly exploring the program, it neatly done, has a fast response. Good job. Thank you so much for sharing with the world (I am in Canada) :)

    ReplyDelete
  31. Hi,

    Thanks for sharing a very interesting article about A Free C# Billing Application with Source Code (.NET). This is very useful information for online blog review readers.

    From,
    Retailmass,
    POS Billing Software

    ReplyDelete
  32. I appreciate this effort. Find the right Billing Software for Mental Health Professionals for your organization.

    ReplyDelete
  33. private static void transferTableData(SqlCeConnection sourceConnection, SqlCeConnection targetConnection, SqlCeTransaction transaction, string tableName)
    {
    using (SqlCeCommand sourceCommand = sourceConnection.CreateCommand())
    {
    sourceCommand.CommandText = "Select * from " + tableName;
    using (SqlCeDataReader sourceReader = sourceCommand.ExecuteReader())
    {
    SqlBulkCopyOptions options = new SqlCeBulkCopyOptions();
    options = options |= SqlCeBulkCopyOptions.KeepNulls;
    string[] tableNames = { "FirmDetails" };
    if (!tableNames.Contains(tableName))
    {
    options |= SqlCeBulkCopyOptions.KeepIdentity;
    }

    using (SqlCeBulkCopy bc = new SqlCeBulkCopy(targetConnection, options, transaction))
    {
    bc.DestinationTableName = tableName;
    bc.WriteToServer((IDataReader)sourceReader);
    }

    if (!tableNames.Contains(tableName))
    {
    using (SqlCeCommand command = targetConnection.CreateCommand())
    {
    command.Transaction = transaction;
    command.CommandText = "SELECT MAX(ID) FROM " + tableName;
    object value = command.ExecuteScalar();
    int id;
    if (value == null || value == DBNull.Value)
    {
    id = 1;
    }
    else
    {
    id = (int)value;
    }
    command.CommandText = "ALTER TABLE " + tableName + " ALTER COLUMN ID IDENTITY (" +
    (id + 1) + ", 1)";
    command.ExecuteNonQuery();
    }
    }
    }
    }
    }


    hi im getting errors from this code:


    Error CS0019 Operator '|=' cannot be applied to operands of type 'SqlBulkCopyOptions' and 'SqlCeBulkCopyOptions' Biller

    Error CS0266 Cannot implicitly convert type 'ErikEJ.SqlCe.SqlCeBulkCopyOptions' to 'System.Data.SqlClient.SqlBulkCopyOptions'. An explicit conversion exists (are you missing a cast?) Biller

    ReplyDelete
  34. Error CS1674 'SqlCeBulkCopy': type used in a using statement must be implicitly convertible to 'System.IDisposable' Biller C:\Users\Softpro.USER\Documents\Biller\Biller\Classes\InterDatabaseDataTransfer.cs




    im getting this error help me to resolve it

    ReplyDelete
  35. This comment has been removed by the author.

    ReplyDelete
  36. haii..Dhiya i can't run source code ??? wat to do???

    ReplyDelete
  37. My spouse and i were absolutely cheerful when Peter could deal with his web research with the ideas he grabbed from your own web pages. It's not at all simplistic to simply continually be giving freely information other people may have been making money from. Therefore we fully understand we've got the post owner to be grateful to because of that. The illustrations you've made, the easy web site menu, the friendships your site make it possible to engender - it is everything incredible, and it is leading our son in addition to our family know that this matter is interesting, and that is extremely mandatory. Thanks for everything! Chiropractic Software

    ReplyDelete
  38. 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. online invoice software.

    ReplyDelete
  39. I read this blog please update more content on hacking, further check it once at .NET Online Course

    ReplyDelete
  40. Nice Blog

    Thanks for sharing information about ERP software

    barcode billing software in India

    ReplyDelete
  41. It has been simply incredibly generous with you to provide openly what exactly many individuals would’ve marketed for an eBook to end up making some cash for their end, primarily given that you could have tried it in the event you wanted.
    Billing Software

    ReplyDelete
  42. Thanks a lot for sharing such a good source with all, i appreciate your efforts taken for the same. I found this worth sharing and must share this with all.




    Dot Net Training in Chennai | Dot Net Training in anna nagar | Dot Net Training in omr | Dot Net Training in porur | Dot Net Training in tambaram | Dot Net Training in velachery

    ReplyDelete
  43. The article is very good and informative. Thank you for the author.
    For Electric Scooter in Bangalore please contact greendrivemotors.

    ReplyDelete
  44. I'm  here to share my testimony of what a good trusted loan company did for me. My name is Nikita Tanya, from Russian and I’m a lovely mother of 3 kids I lost my funds on trying to get a loan it was so hard for me and my children, I went online to seek for a loan assistance  all hope was lost until one fateful day when I met this friend of mine who recently secured a loan from a very honest man Mr, Benjamin. She introduced me to this honest loan officer Mr, Benjamin  who helped me get a loan within 5 working days, I will forever be grateful to Mr Benjamin, for helping me get back on my feet again. You can contact Mr Benjamin via email: 247officedept@gmail.com    they do not know I’m doing this for them, but i just have to do it because a lot of people are out there who are in need of a loan assistance  please come to this honest man  and  you can be save as well .WhatsApp:(+1 989-394-3740)

    ReplyDelete
  45. The article you wrote was very helpful for me. I am looking forward to reading more articles of yours in the future. The visa for Turkey is completely open now and you can take benefits of the Turkish visa facility and Explore the Turkey like a local .


    ReplyDelete
  46. A "biller" typically refers to a company or entity that sends bills or invoices to customers for products or services rendered. How VPN Use They manage billing processes and may provide payment option.

    ReplyDelete