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.

Comments

Help

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?

Another Problem

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.

re: Another Problem

Look at the database if the user/password was added successfully.

Yes they are correct. Isnt it

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?

plz help sir ...

sir i m not able to run this project plz tell the steps sir ....

Question

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?

about project

sir,

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

Data Sources (ODBC)

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...

re: Data Sources (ODBC)

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.

HOW TO RUN INTERNET BILLING S/w

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 ..

re: HOW TO RUN INTERNET BILLING S/w

This source code is written in vb 6.0 and not in vb.net.

sir ,,, i hv got the idea how

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 ..

re: sir ,,, i hv got the idea how

Be sure you have the correct IP Address setup in the client program. It can be access using the admin password.

For the password look at the source code.

IP address

for every client is showing the ip address as 127.0.0.1

do i need to configure ..????

re: IP address

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.

now its running ,.....

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..

my project

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]

re: my project

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

Error message from database

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

Developing an internet cafe system

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

re: Developing an internet cafe system

I am willing to help but my limited time will not allow me to spend on your project. Please hire somebody to teach you.

Client Server procedure

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]

re: Client Server procedure

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.

Remote shutdown

Sir, What if i only need the program to use it to shutdown or log out the workstation? I dont need to time the workstations?

SIR TY FOR SHARING THIS PROJECT

umm can i used this project sir? and also if i can improve it? ill give credits/regards to you sir

re: SIR TY FOR SHARING THIS PROJECT

Yah sure. That would be great if you can improve it.

SIR TY FOR SHARING THIS PROJECT

i plan on using this sir, also try to improve it.. if its ok sir thank you

re: help me plz in my THESIS

why the file if damage, , while extracting? help me plz. thank

jan

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

re: jan

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 (%).

Need Sql help

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

re: Need Sql help

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.

re: Need Sql help

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

re: Need Sql help

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.

re: Need Sql help

Thank you sir, hope I can get your help soon :)

re: Need Sql help

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)<=#5/29/2009#) AND ((Table1.TimeOut)>=#12/30/1899 4:30:0#));

re: Need Sql help

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

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 !

re: Hi sir, I managed to create

Check your mail.

re: Hi sir, I managed to create - update

My email to you has bounce back. Please check your mail at this website if it is correct.

I've checked the email and

I've checked the email and its correct! and i even checked my email settings if it blocked any emails from this website but i found none =/

re: Need Sql help

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] =#26/03/2009#) AND ([TimeOut] =#12/30/1899 5:30:0#)))

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 !

pls sir i need a code

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...

re: pls sir i need a code

Let me know if you can't download the file above.

How to use the Internet Management Software?

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.

re: How to use the Internet Management Software?

The server program should run on your computer server and the client program should run on how workstation. Before you connect to the server be sure that the server program is running on your computer server. You should change the IP Address in your client program to the IP Address in your server in order to connect properly.

re: How to use the Internet Management Software?

Thanks for your reply. Could you please let me know how to change the ip address. and also let me know how to connect Server & Client. All of them are systems and can I consider the one in the reception as Server? Please help. Regards, Thomas.

remote shutdown

Sir, What if I only need a program that can remote shutdown at logoff the workstations. without time limit. can you help me? Thanks

re: remote shutdown

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.

6-overflow

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

Add new comment
2271 views