Loading

DVD Sales and Rental System in C# and MySql

Submitted by: 
Language: 
Visitors have accessed this post 28118 times.


Updated 10/12/11

Hello again, Here is my updated DVD Sales and Rental System..there are many changes happen to my system, and most of the bugs and error are now fix.. and as I promise about the cool GUI factor.. here it is you can download my system now...

Features of the system:
* the system has the capabilities to send email to there customer.
* Sales Order, Sales Return, Sales Delivery, Purchase Order, Purchase Order return and etc.
* can import from listview to excel.
* the system has a built -in Scheduler(Calendar scheduler like MS OUTLOOK).
* Charts and Graphs for data interpretation

Note: The status of the system is still ongoing... expect some new features and cool GUI factor on the next update...

May God Bless us all.....




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

Bug and error connection database@@

Your Code gave me any good inspirations for "How to connect to a MS-SQL (not MySQL) database" in C#

regards,

Peter

itachi_philip's picture

your welcome.... if hehehehe if you are interested to provide you a complete system please fell free to contact us.... see the facebook link below... just post your inquiries there..

Philip Cesar B. Garay BSIT
Mindanao State University at Naawan

[email protected]
NIT Software Lab

Your the best.
May i have the inventory system in c#.

Please send info to:
[email protected]

Thanks again. Your a life saver.

Ty

.sir i like this one too. please help me. i want this to make as our thesis. please :) email ko po [email protected]

Hi cutie ... can i ask something ?? hehe
i just want to know if what are different queries that
i'm going to input on my DVD Table using MY SQL .

Hello my friend
I have a problem with some references. How can i found them?
System.Widows.Forms.DataVisualitation
Thank you

HI itachi_philip,

do you have a ms sql script? for your mysql
want to run your app via ms sql db

thnx

itachi_philip's picture

Sorry but i dont have a MS SQL script for that,,,,

Philip Cesar B. Garay BSIT
Mindanao State University at Naawan

[email protected]
NIT Software Lab

hi itachi_philip,

im so confuse with the version of your crystal reports
in the references you had refer to a crystal report version 9
but in your project was in vs2008 how can you have access to old
crystal report components in this project.

coz i have referene problem

tnx

MORE APPS / More Power to u philip

itachi_philip's picture

Hello.....

Yes, I use Crystal Report 9 although it is an old version yet nothing is impossible if you try to incorporate it with Visual Studio 2008.. If you have some problem with crystal report, I add some of its DLL's in the Bin Folder..

Philip Cesar B. Garay BSIT
Mindanao State University at Naawan

[email protected]
NIT Software Lab

hi sir philip,

i notice the cash sales module just a presentation of total sales order,
what function do we have in the cash sales module?

i was thinking its like independent module like in the
vb6 InventorySystem (base/core)

thanks more power again

itachi_philip's picture

By the way,,, Maybe you the downloaded the old one... try to download the new one... coz I been thinking about the cash sales module you have said but when I look again my system.. It only Contains 2 module, the Front Desk Module and the Stock and Inventory Module...

By the way thanks for appreciating my work.. May God Bless you...

Philip Cesar B. Garay BSIT
Mindanao State University at Naawan

[email protected]
NIT Software Lab

Hi. The solution does not load on Visual Studio 2010. Do u know what might be causing the problem, or how I can rectify the issue. I'm new to Visual Studio. Thanks in advance.

itachi_philip's picture

If the solution file does not load... then try to load the project file not the solution file....By the way I use Visual Studio 2008 for that project..Maybe it is due to unknown error during conversion... try to open it again... but use the project file...

Philip Cesar B. Garay BSIT
Mindanao State University at Naawan

[email protected]
NIT Software Lab

hi sir philip,

where will i find the updated scodes for dvdrentals?
did you also update the db structures?

thanks more power/ more codes

itachi_philip's picture

The source code will be updated soon... maybe it takes time for me to update... i need to reconstruct the system's design and make it more efficient..

Anyway here's my new uploaded system

Scheduling and Timetabling System

thank you again...

Philip Cesar B. Garay BSIT
Mindanao State University at Naawan

[email protected]
NIT Software Lab

I can run frontDesk Solution only,
When I used "New Sales Entry"
an Error occurs When I click Save button
please explain me what wrong to this solution ,
i think it may be "printing error" .

itachi_philip's picture

the error occurs when you never create an ODBC connection for the crystal reports.. to fix this one.

*Windows XP-
->Goto Control Panel -> Administrative Tools-> Data Source(ODBC)-> Add-> Select "MySQL ODBC Driver" -> Click Finish -> Fill all the required fields in MySQL Connector/ ODBC ->

TCP/IP: localhost
Port: 3306
User: root

Database: DVDSales

-> Test -> OK

thats it.....that fix the errors... for the windows7 user... the procedure in fixing the error using windows xp is closely related to windows7...

Anyway here's my new uploaded system

Scheduling and Timetabling System

Thanks again....

Philip Cesar B. Garay BSIT
Mindanao State University at Naawan

[email protected]
NIT Software Lab

Pwint Wah Soe's picture

thanks so much for your answer.

but I do as you have told, Error occurs again.

The error message is "Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)). error"
at line ((System.ComponentModel.ISupportInitialize)(this.CR)).EndInit();
of fromPrintPreview.Designer.cs .

Let me know how to solve this problem

Thanks in advance

itachi_philip's picture

This error occur on the crystal report viewer attached on the frmPrintPreview.cs... the error started when Crystal Report activeX controls are not properly registered or no Crystal Report install in your pc.... to solve this problem... download Crystal Report 9 or later version,, install it in your pc and thats it... it fix the problem

Philip Cesar B. Garay BSIT
Mindanao State University at Naawan

[email protected]
NIT Software Lab

Pwint Wah Soe's picture

Although i search to download Crystal Report 9 or later ,it is not work.
sorry,i cannot download Crystal Report 9 or later ,Could you like to tell me where I can get to download
Crystal Report 9 or later.pls tell me the link .
Thanks in advance.

itachi_philip's picture

Philip Cesar B. Garay BSIT
Mindanao State University at Naawan

[email protected]
NIT Software Lab

I can' t run StockandInventory Module of solution because of connnection and missing dll.
Although I can run FrontDesk of solution But i can't report because of missing dll.
Let me know where i can get missing dll.
AxCRVIEWER9Lib
CRAXDRT
CRVIEWER9Lib
Excel
Microsoft.Office.Core
Although i try with above dll from searching at internet,
Unfortunately it is not work.
Thanks in advance

itachi_philip's picture

you need to download the Crystal Report 9 in order for those missing dll's are fixed
AxCRVIEWER9Lib
CRAXDRT
CRVIEWER9Lib

while the
Excel
Microsoft.Office.Core

these are the dll's found in the Microsoft Excel... if you have Microsoft Excel installed in your pc then you can run this system properly by adding referrences like Microsoft Excel Interop..

Philip Cesar B. Garay BSIT
Mindanao State University at Naawan

[email protected]
NIT Software Lab

Hi, I'm Erick and still a newbie in programming . I've a project then I come to search for an example , that's what I find yours is very interesting. But when I try to Import the database to mysql it sho no database selected although I've select the dvd rental.sql
can anyone tell what to do ?
thanks

hello kuya Philip. pwede mo po ako matulungan? O.O hm kung pwede po sana makahingi ng rental system na simple lang. pang remedial ko po :((

Visual Studio 2012 (+ update 1) give errors and wargins
Please update your source

PLZ send me a sales ana rental system project in c#...................... plz email id [email protected]

Hi I have downloded your code . And trying to run it . But getting error .
Error 19 Could not copy the file "D:\Dvd Rental Systems\FrontDesk\FrontDesk\CalendarSample.exe" because it was not found. FrontDesk
Please Help
THanks In Advance

Add new comment

(If you're a human, don't change the following field)
Your first name.
(If you're a human, don't change the following field)
Your first name.
(If you're a human, don't change the following field)
Your first name.

Filtered HTML

  • You may insert videos with [video:URL]
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <html4strict>, <java>, <javascript>, <mysql>, <php>, <python>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.