Online Booking system (again)

Stinky

Stinky

Stinky

Soldato
Joined
28 Mar 2005
Posts
9,236
trying to do this for my IT assinment this year.

it will involve a website which will have an online system where users can book there room for there stay. so they dont need to ring up. it will need to be a system that the receptionist can use and that will be offline but linked to the online system which is required for the users to book online.

I will also be trying to integrate a automatic feedback system into this. Where on the date of departure an email will automatically be sent out to the guest. Ready for when they return home.

Would it be easiest to do Microsoft Access backend (Receptionist use) and ASP as the online side of it??

either way it will need to link to the same database so that rooms aernt double booked etc...
 
MS Access isn't really suited for web apps and i believe ASP is more or less being replaced with ASP.net.

If i were you take a look at using PHP + mySQL. Easy to learn and should allow you to do everything you want to. I dont think theres any need to have an online and offline system though. You may be making it harder than it needs to be, when it comes to merging/updating/maintaing the 2 databases.
 
Do you know Access and ASP already? If so its fine to use, if not its up to you what you want to learn.

Server technologies to choose from: ASP/ASP.NET/PHP
DBs to choose from: Access/SQL Server/MySQL

Would it be part of your assignment to weigh up the pros and cons and make a decision? Are you at uni/college? If so what technologies are supported?
 
basically. there is 1 mark available out of 120 for a working system. so its not got to be working 100% but it needs to be working on some scale for me to complete the testing part.

i am in college. i know access but not really ASP it would be something i would need to learn.

however i do it, it needs to be running off 1 database. io really am usless at this stuff lol
 
if you do go down the php route, i'd definately recommend getting "PHP and mySQL Web Development" by Luke Welling and Laura Thomson. ISBn:0-672-32525-x .

I've found it very useful and there are lots of good examples in there.
 
you'd need a webserver running PHP. Basically it runs your scripts for you and outputs HTML which it sends to your browser. If your in college you may be able to get a bit of webspace and it all setup for you. I know thats what we did when some of the kids at the school i worked at wanted to use PHP for their project.
 
If this is a college project and you already know how to use Access and only 1 of the marks is for a fully working project I'd put my time into making a good Access database and a couple of forms for the offline part. If you still have time then learn some ASP and you'll be able to interface with your database through a browser.

If you intend to learn PHP/MySQL from scratch then I'd get started pronto.

By the way, you can use Access to generate your SQL queries for when you get round to the ASP part. Won't be great code but might speed things up a little.
 
the .net CLR is a free download for windows, IIS is free, SQL Server expreess edition id free and you can get Visual Studio .net express edition as a free downlaod from MS at the moment. I'd say go for C# .net it's a great laguage to learn and the skilld look great on your CV. look at building a web service to get / add / edit bookings and retrive data about available bookings and a ASP based web front end.

PHP / MySQL is an axcelent alternative as would be Java and J2EE with either an Oracle or MySQL backend. The actual choice is up to you with each approach having it's own set of advantages and disadvatages.

The PHP / MySql aproach will get you going faster but imho C# and ASP.net with SOAP web services is a a very fast and good way to build web applications

HT
 
happytechie said:
the .net CLR is a free download for windows, IIS is free, SQL Server expreess edition id free and you can get Visual Studio .net express edition as a free downlaod from MS at the moment. I'd say go for C# .net it's a great laguage to learn and the skilld look great on your CV. look at building a web service to get / add / edit bookings and retrive data about available bookings and a ASP based web front end.

PHP / MySQL is an axcelent alternative as would be Java and J2EE with either an Oracle or MySQL backend. The actual choice is up to you with each approach having it's own set of advantages and disadvatages.

The PHP / MySql aproach will get you going faster but imho C# and ASP.net with SOAP web services is a a very fast and good way to build web applications

HT
Click to expand...

sounds good. do you have msn or anything?? can i add you later have a quick chat?
 
msn link above (just the left of this post), I'd rather offer advice via the forum so that others can offer comment and read the info here. The power of the internet is getting the best advice from all that can be offered.

EDIT: MSN won't let me sign in, try my yahoo addie

HT
 
Last edited:
Are you getting marked on development of this thing or what? I think learning C#, .NET and SQL Server is a hell of a learning curve lot for a project with so little marks on a working project although I would agree the best suited developement scenario - not to mention the future benefits of learning those technologies.

What is the spread of marks for?
 
there is 120 marks in total.

only 1 for a working project. BUT... i would like to get this all completed in my own time even if its not 100% for the project. reason being that the hotel would be interested in buying it off me if i get it working 100%
 
I take it all of the marks are for the analysis of the requirements, design of the system and choice of implementation methods and supporting technology?

This is about designing the solution a=in an abstract way, choosing the best methodology for implementing the solution and then shoeing the marker that you know how to implementit in said technology. Have you done all the early stuff or are you planning on wasting all you time building a solution and then flogging it to the hotel while reverse engineering your design docs for the project hand in? Do it propperly and get the requirements / analysis / system design done first then choose the BEST emthod of implementing it. I'd go and reserch n tier architetures, web services and dynamic web applications. why not have a look at AJAX applications while you're at it ;)
 
You must log in or register to reply here.
Back
Top Bottom