A HANDFULL OF PROJECTS
THOMSON AND ASSOCIATES - ESTATE AGENTS WEBSITE
ASP.NET 2.0, SQL Server 2000, Solution Framework
Visit Thomson and Associates website
Thomson and Associates is a new Estate Agents based in Glasgow.
Thomson required a simple, usable website which would would allow them to upload
their properties for let and for sale.
All properties had to be fully searchable with regards to price,
location, keywords, features, bedrooms and type of property.
After gathering the requirements for the project it soon
became apparent that with minor alterations, the "backend" for this
solution could be provided by the Secret Orange Solution Framework.
The system also allows Thomson to flag chosen properties as "Featured Properties", which appear on
a dedicated page and randomly chosen to appear on the home page.
CHUNK - DOCUMENT SHARING PORTAL
ASP.NET 2.0, SQL Server 2000, Indexing Service, MS Atlas Framework, MS Enterprise Library
Chunk approached Secret Orange with a view of working together to create an online document
sharing portal for a well known brewery.
The purpose of the application was to provide an exciting, user friendly method of sharing information. It had to offer functionality for
self registration but restrict who could register by checking the user's email address against a pool of valid, configurable, domains.
The application is role based, offering varying levels of functionality to different users dependant on access levels. A user with the least
amount of privilages has access to the "frontend" only, whereby they can search for material using keywords and/or drilling
down through categories. Search results are a combination of results returned from Microsoft Indexing Service and an SQL SELECT on
the SQL Server 2000 database. The search results are also filtered dependant on another set of privilages.
The application also offers an administration mode whereby many aspects of the functionality and frontend content can be configured.
All documents which are uploaded to the system are stored on the filesystem in a folder inaccessible through HTTP. Pointers are held in the database and
used to retrieve the documents when needed. The are then sent to the user over a Secure Sockets Layer (SSL/HTTPS) ensuring that information is transferred and stored in a secure manner.
GILDEN PHOTONICS - GILDEN PHOTONICS WEBSITE
ASP.NET 2.0, SQL Server 2000, MS Enterprise Library, Solution Framework, ITextSharp
Visit Gilden Photonics website
Gilden Photonics is a successful new company selling and servicing spectroscopic components and optical instruments.
Gilden required a website to showcase their vast selection of products and services which required the use of
the Secret Orange Solution Framework to provide
content management services.
The solution also makes use of the ITextSharp library which is a port of iText, a free Java-Pdf library.
This was used to create PDF documents on the fly for product specifications. These documents are requested by the user for download, the content and images
are pulled from the database and filesystem respectively and pieced together using the ITextSharp API, then sent back to the client via the HTTP response stream.
EQUATOR - ITC CLASSICS WEBSITE
ASP.NET 1.1, SQL Server 2000, XML, Flash, Illusions property management system
Secret Orange worked with Equator to build an exciting and technically
challenging website for the luxury travel company, ITC Classics.
N-tier methodologies and solid use of OOP tamed the complexity of the site and kept the technical design clean and maintainable.
The site connects to a legacy SQL Server based Property Management System and offers intelligent searches of "Full Text" catalogues.
The data layer adopts an abstract factory design pattern to help assist a predicted future migration to an oracle based solution.