Internet Cafe Billing

Submitted by admin on Sunday, November 16, 2008 - 00:39.

A must have features for internet cafe monitoring system:

  • Allow connection from multiple computer
  • Detailed information about connected computer like computer name, user code, total amount, used amount, left amount, total hour, used hour, left hour, etc.
  • Time plan
  • Member and walk-in customer
  • User's rate information
  • Automatic generation of a coupon/user code and password
  • History report
  • And best of all I did not use any 3rd party controls
  • And a lot more...

Please login to your account to leave a comment. You may use also our online forum to ask question regarding this source code.

For the database password please read FAQ.

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Tags

Comments

Submitted byAnonymous (not verified)on Tue, 03/10/2009 - 09:01

Sir, does this code work in a network which uses a router? I tried downloading the code and running the server code on of course the server and the client on the client, the server cant see the connected workstations, why is this so?

Submitted byAnonymous (not verified)on Tue, 03/10/2009 - 09:44

When i tried to type the username and password of some coupons in the database on the client nothing happens, it doesnt say if it is wrong or anything, literally nothing happens.

Yes they are correct. Isnt it supposed to say like "Invalid User or Password." or "You do not have enough money left in your account." like in the code?

Submitted byAnonymous (not verified)on Tue, 03/10/2009 - 09:48

I noticed some lines in the code which are commented or should i say have these "'" should i remove it in order for the program to run?

Submitted byAnonymous (not verified)on Tue, 03/10/2009 - 17:11

sir,

  how can i know the histroy of user website. i wann to display the history.can u help me

 

Submitted byAnonymous (not verified)on Thu, 03/12/2009 - 08:22

Sir can this program will detect the client if we will network it using the Data Sources (ODBC)?

In the Administrative Tools? Can you help us how to work with it...

You do not need to use ODBC to connect to the database. The database should reside on the server. Nothing else. This is a true client/server architecture.

Submitted byAnonymous (not verified)on Sat, 03/14/2009 - 19:14

sir i hv git the code but i dnt know how to run .

sir plz can u help me .

because its on .net and vb and database is also locked ..plz help sir ..

 

my id is ---->> [email protected]

 

regards ..

sir ,,,

i hv got the idea how to run the project and it is running successfully on one system i.e client and server in one system but there is some problem with client and server in different systems ..

client is not able to connect and it is generating error " winsock error"...

what can i do for it ..????

plz help sir ..

 

Submitted byadminon Tue, 03/24/2009 - 08:47

You can configure the IP Address using the admin username and password. Search the code for the username and password to access the IP Address config.

Submitted byAnonymous (not verified)on Wed, 03/25/2009 - 15:28

sir now the project is running ...

but client can access the task manager and explorer.

can u tel me how to disable task manager and explorer.exe ..???

regards..

Submitted byAnonymous (not verified)on Wed, 03/18/2009 - 01:05

hello sir

i m a 4yr student in delhi college. i m preparing a project on  " online shopping",

i hav developed it nicely but hav to add new features to extend it...

my features are

1. online transaction using dummy bank

2. synchronisation token, that avoids re-submissions wen we keep on clicking on" submit button" in case of low bandwidth connection.....it asks user before re-submission

3. automated mail generation

4. add forum for asking queries

5. categorisation of products on basis of price, alphabetical, namewise

 

kindly help me sir..i m left wid 2 weeks time...

please sir..

waiting for reply on my id :

[email protected] 

Submitted byadminon Wed, 03/18/2009 - 08:45

Just post your unfinish project here so we can look at the source code and see what we can do.

Submitted byAnonymous (not verified)on Sun, 03/22/2009 - 17:42

Hi

Your program looks really interesting, however when attempting to login from the client the message "Unknown data format " appears on the server.

Please help

Thanks

Julian

 

Submitted byAnonymous (not verified)on Mon, 03/23/2009 - 14:00

Hi sir, can do me a favor! I have no experienced before to develop a system like this and this is our school project and my team people can't even figure out. I have tried so hard to search the relates information, however, there is no outcome for my searching. Therefore, i'd appreciate if you might send some relates information about the cafe system to me to my mail >> [email protected] I believe that i can work out with your information and i left 2 months to do it. thanks you

Dear Admin, I have connected both 2 database according to your database video tutorial. but now I'm unable to establish connection between client and server application. I had try to run client application in one machine while running server application in another machine. but i got error on client saying "disconnected Server " kindly let me know how to setup client-server work station and help me out to run this application Regards skc [email protected]

The concept is very simple. Setup the IP Address correctly in the client program. Make sure that the port is listening in the server program and it is not block by your firewall.
Submitted byAnonymous (not verified)on Sat, 05/16/2009 - 10:17

hi sir.... can u teach me or share to me searching method using the "like" statement/operator,,, for example i hav to search all name which have an "jan" then display: jan francis jan michieal jan israel jan joseph alexjan XXXXjanXXXX XXXXXXXjan plz teach me.... this is for my thesis ... e mail me... [email protected] or in ym pm me [email protected] or txt me 09203148822 ty... plz response
Submitted byadminon Sun, 05/17/2009 - 19:12

To search for record using the "Like" operator use this SQL Statement: SELECT * FROM Employees WHERE Firstname like "%jan%" This will work only with ADO. To search using DAO use the following statement: SELECT * FROM Employees WHERE Firstname like "*jan*" The only difference here is the arterisk (*) and perscent (%).
Submitted byAnonymous (not verified)on Thu, 05/28/2009 - 20:58

Dear Sir, I'm working on a project that only need the last touch which is the report generation code, I'm using MS Visual Studio vb.net 2005 this project is about automated system to calculate the usage of some kind of snooker club, there are 2 shift hours from 10:00:00 to 18:30:00 and from 18:30:00 till 4:30:00 the problem is when i try to generate report for the day or a shift it only shows me for the current day, without adding the usage after 0:00:00 , so if i want to generate report of today it should be like this "28/5/2009 - 10:00:00 - 29/5/2009- 9:59:59 " could u help me plz? i have the time field and date field seperated in my ms access database.. could u help me with the Sql where command
Submitted byadminon Fri, 05/29/2009 - 08:45

Can you show me the field you have? It's hard to guess but I think you have this kind of field in your table: DateIn TimeIn DateOut TimeOut Let me know if this is correct.

Thanks for replying on my comment that fast, well, my table contains 10 fields: ID - TableNumber - TimeIn - TimeOut - Date - HoursUsed - Discount - Tamount - SuperVisor - Shift I dont have any DateOut, do i have to add it to make this work? - The [shift] field has two variable "1 and 2" 1 means morning shift which is from 10 till 18:30 pm, and 2 means night shift from 18:30pm till 4:00 AM Thank u and i hope i get the solution for this :(

You don't need the dateout since you'll get it in the current date. I just include it so we have an example. It's late in the evening now I will study your problem tomorow.
Submitted byadminon Sat, 05/30/2009 - 11:52

You need to add the DateOut field for this. I have provided you a copy of this code in MS Access database. Please login to your account so I can grab your email address. Do not publish your email here to prevent from spamming. SELECT Table1.ID, Table1.TableNumber, Table1.Tamount, Table1.DateIn, Table1.TimeIn, Table1.DateOut, Table1.TimeOut FROM Table1 WHERE (((Table1.DateIn)>=#5/28/2009#) AND ((Table1.TimeIn)>=#12/30/1899 10:0:0#) AND ((Table1.DateOut)=#12/30/1899 4:30:0#));

Thank you sir for replying again on my question, and I'll apply the code you posted now,however; the data in the TimeIn and Timeout fields type are short (eg 14:15:00) without the date figure. Because in the application there is a textbox the request the timein and timeout for the supervisor to monitor, and the date is useless at that process, unless it is a report generation. If you need me to send you my current database then i'd be happy to! however, the code i was using was : Public Sub Preview_Report_Runtime_withcondition() On Error GoTo ErrorHandler Dim oAccess As Access.Application Dim oForm As Access.Form Dim sDBPath As String Dim sReport As String sReport = "BilliardR" sDBPath = Application.StartupPath & "\myaccount.mdb" oAccess = ShellGetDB(sDBPath, "/runtime") If Not oAccess.Visible Then oAccess.Visible = True For Each oForm In oAccess.Forms oAccess.DoCmd.Close(ObjectType:=Access.AcObjectType.acForm, _ ObjectName:=oForm.Name, _ Save:=Access.AcCloseSave.acSaveNo) Next If Not oForm Is Nothing Then System.Runtime.InteropServices.Marshal.ReleaseComObject(oForm) End If oForm = Nothing oAccess.DoCmd.SelectObject(ObjectType:=Access.AcObjectType.acReport, _ ObjectName:=sReport, InDatabaseWindow:=True) oAccess.RunCommand(Command:=Access.AcCommand.acCmdAppMaximize) oAccess.DoCmd.OpenReport(ReportName:=sReport, _ View:=Access.AcView.acViewPreview, WhereCondition:=WhereCase) oAccess.DoCmd.Maximize() oAccess.CommandBars("Menu Bar").Enabled = False If Not oAccess.UserControl Then oAccess.UserControl = True System.Runtime.InteropServices.Marshal.ReleaseComObject(oAccess) oAccess = Nothing Exit Sub ErrorCleanup: On Error Resume Next System.Runtime.InteropServices.Marshal.ReleaseComObject(oForm) oForm = Nothing oAccess.Quit(Option:=Access.AcQuitOption.acQuitSaveNone) System.Runtime.InteropServices.Marshal.ReleaseComObject(oAccess) oAccess = Nothing Exit Sub ErrorHandler: MsgBox(Err.Number & ": " & Err.Description, _ MsgBoxStyle.MsgBoxSetForeground, "Error Handler") Resume ErrorCleanup End Sub "Wherecase" is retrieved from another function that assign a specific string (the 1 which i was asking you to help me with). And "BilliardR" is a Report in MsAccess database with the whole data in Query "BilliardALL"

Hi sir, I managed to create an account in this website as you can see, and i'd appreciate if you send me the sample of the database you created for my issue.. thank you !

Hi again sir, I've tried the code you gave me but I kept getting error in the report fields, This is the code i've tried: Where ((([DateIn] >=#25/03/2009#) AND ([TimeIn] >=#12/30/1899 10:0:0#))) AND ((([DateOut] I even tried it without the brackets around the fields' name.. However, I tried separating both sides like this : (([DateIn] >=#25/03/2009#) AND ([TimeIn] >=#12/30/1899 10:0:0#)) And the report worked fine, everytime I include the DateOut field in the where statement i keep getting errors! I've added dateout field and added values in it for testing the code but yet i kept getting the errors, The concept of my report is that when I hit the button in vb.net application, it will load the report I made in MsAccess and only show the range I've chosen to view only.. If you could plz try to help me with this, and also resend me the MsAccess database you tried to send before. thank you !
Submitted byAnonymous (not verified)on Fri, 05/29/2009 - 02:04

thanks for this site i would like to know if you can help me with my final yr project. i'm designing and implementing a billing software system for a cyber cafe using vb and ms access as database but i don't have a code to work with. pls i would appreciate it if you can kindly send me a source code for the named topic above to my e-mail:[email protected] would be looking forward hearing from you soonest, i have two weeks to submission of my project and i have done anything. thanks...
Submitted bytomamirton Thu, 06/04/2009 - 00:07

Dear Sir, Could you please let me know how to use this software? I have installed VB6 in my system. And opened this file. And also changed the link in the Internet Record Front.MDB. When I clicked on F5 it shows me the 3JNET Cafe Manager Window. I do not know how to use the links. Could you please brief me? Thanks with Regards, Thomas.
Submitted byadminon Mon, 06/15/2009 - 17:49

Do you know hot to edit visual basic source code? If yes, I think it's better if you do it yourself so that your knowledge in programming will improve. In the internet cafe billing source code you can remove all other function except the remote shutdown.
Submitted byAnonymous (not verified)on Wed, 06/17/2009 - 14:12

Sir, I've run the server and the client and everything goes great, but it gives me overflow when it comes to the ChargePerHour thing. how can i fix this, please help.

Add new comment

About text formats