SITE 80% COMPLETE:

Finally added a page to show the services that we offer, imaginatively named services.

Created four panels, these panels break our services down into four sections:

• COMPUTER SERVICES
• NETWORK SERVICES
• SERVER SERVICES
• MISCELLANEOUS SERVICES

Each section is made up of two ASP.NET panels, one for the heading and one for the content section, which is the part that expands and collapses. The ASP.NET panels are extended with the AJAX collapsible panel extender.

The content panel contains a table with two columns, left-hand column holds images relating to the service being provided and a description of the service is provided in the right-hand column.

Only the first panel is expanded on page load (collapsed="false"), the other sections are collapsed on page load (collapsed="true"), these can then be expanded/collapsed at users content.

Each panel has a height attibute of zero in the style sheet (height: 0px;), this prevents the panel from being displayed before it is collapsed by the extender as the css attributes are fired first. If this attribute was not set this way, you would get a flash of the panels on page load, which is very annoying.

SITE 75% COMPLETE:

Modified the accounts page and database some what, mainly to include a VAT calculator, the tax can then be broken out and stored in the database.

• Added transaction type drop down list; this enables the user to select either debit or refund, on selection some code-beind determines the selected value and determines "r" for refund, "d" for debit which are the values that get strored.
• Changed the type of the transaction type column in the database from integer to a single character (for "r" or "d"). This table will also be used for credits so the transaction type for credits will be "c" imaginitively.
• I wanted to be able to rationalise credits, debits, and refunds in the table, so i added a further column called multiplier which is populated with "-1" for debits and "1" for refunds and credits, i can use this value later when displaying accounts in reports.
• Removed the VAT text box as VAT will now be calculated in the code-behind section.
• Added the VAT calculation which produces the following output:
• Cost before VAT.
• Cost after VAT.
• Cost of VAT.
• Total cost before VAT.
• Total cost after VAT.
• Added the new columns to the accounting transactions table.

Completed adding controls, code-behind, and database table for the cases component type, the details of which follow:

• Added Ajax update panel to ther case tab panel to enable asynchronous postbacks.
• Added controls to case update panel for selection of case attributes.
• Added updateProgress Ajax control extender to case update panels, to indicate sql transactions.
• Added label to case tab panel to show status of sql transactions.
• Finalised case database table schema.
• Completed code-behind to write case tsb panel controls attributes to the case database table.
• Added updateProgress Ajax control extender to case update panel, to indicate sql transactions.
• Added label to expenditure tab panels to show status of sql transactions.

Added a column to all product tables and set the Computed Column Specification, this will automatically calculate the sale price from the price column multiplied by the markup percentage (which varies for different components). This means that the sale price does not have to be calculated in the code, reducing the need to modify code, instead you can just modify the formula in the Computed Column Specification in sql for each of the required tables.

SITE 70% COMPLETE:

Thought it might be a good idea to start logging my accounts, so i built a sql table and an input page on the website to enable us to account for company expenditures. Due to this slight deviation from my project plan i set myself back a whole day on the progress of the overall website, so only 1% closer to completion :(.

• Created new accounts page from the masterpage.
• Locked the accounts page down for access by admins only.
• Added a hyperlink to the accounts page in the administrators section of the control panel.
• Added Ajax Tab Container and populated with single Tab Panel called Expenditure. More tabs will be added later in order for us to review our accounts, and allocate sales.
• Added Ajax update panel to enable asynchronous postbacks.
• Added controls for expenditure area (where the cash got spent), expenditure goods (the goods or service paid for), description, cost, quantitiy, VATcost, reciept/invoice date and receipt/invoice number.
• Filtered expenditure goods dropDownList to only display relevant goods/services on expenditure area selection.
• Added async. postback trigger to update panel on expenditure area selectedIndexChanged, so expenditure goods dropDownList get filtered without a full postback to the server.
• Added updateProgress Ajax control extender to expenditure update panels, to indicate sql transactions.
• Added label to expenditure tab panels to show status of sql transactions.
• Finalised accounting transactions database table schema.
• Completed code-behind to write expenditure controls attributes to the accounting tranactions database table.
• Added updateProgress Ajax control extender to expenditure update panels, to indicate sql transactions.
• Added label to expenditure tab panels to show status of sql transactions.
• Tested various configurations of the expenditure controls, transactions were failing as i had forgot to set identity specification on the ID column of the accounting transactions database table, doh, doh, doh... Worked after i had realised my minor oversight.

SITE 69% COMPLETE:

• Finalised main board database table schema.
• Modified controls layout on motherboard tab of the add components page.
• Completed code-behind to write main board attributes to the main board database table.
• Added updateProgress Ajax control extender to main board update panels, to indicate sql transactions.
• Added label to main board tab panels to show status of sql transactions.
• Finalised hard disk database table schema.
• Modified controls layout on hard disk tab of the add components page.
• Completed code-behind to write hard disk attributes to the hard disk database table.
• Added updateProgress Ajax control extender to hard disk update panels, to indicate sql transactions.
• Added label to hard disk tab panels to show status of sql transactions.
• Modified processor and memory table schema, and code-behind to insert date component added and the user that added it, this functionality was already included in the main board and hard disk shema and code.

SITE 63% COMPLETE:

• Added identity banner, went through many iterations, but finalised on the current design, the blank section will house flash banners (once main site is complete), and the PortsideTechnologies.co.uk logo will be used on to create stickers for the company van.
• Finalised processor and memory database table schema.
• Added required controls for processor, memory, hard disk and motherboard(Jesus there are loads) component attributes, each attribute will be written to respaective table.
• Completed code-behind to write processor and memory components to respective tables.
• Added updateProgress Ajax control extender to processor and memory update panels, to indicate sql transactions.
• Added label to processor and memory panels to show status of sql transactions.
• Uploaded two pictures of my web server(since no-one else has :'(), only two as i am currently in the process of upgrading, no point in taking pics of a legacy system :).

SITE 59% COMPLETE:

• Created components tables in database and started working on schema for computer specification creation.
• Added members page, which queries database for site members, locked this to non-admins.
• Added add components page, which consists of a tab panel, with a tab for each component. Started to populate with controls that will add components to the components database table, completed processor, memory and hard disk layout, no database connectivity yet. Components will be used to generate computer specifications on the create computer page. This page has been locked out for non-admins
• Added create computer page, this is currently empty but will query components table and will use components to generate computer specifications. This is locked top non-admins, but will form the basis of the code for the configurator, which members can use.
• Created admins only section on the control panel which gives access to add components, create computer, and view members sections, more sections will be added when concieved, required and coded.

SITE 55% COMPLETE:

• Added tools page, which will eventually have a whole host of online tools to help you maintain your computer and provide you with helpful information.
• Added the first tool to the tools page; IP Address Detector, which enables members to find their IP Address quickly and easily. Coming soon... hard disk free space wiper, delete your files permanently.
• Locked tools page for use by members only.
• Locked configurator page for use by members only.
• Locked control panel page for use by members only.
• Added tab panel to the products page to separate home/office, server and gaming systems, actual products coming soon...
• Added accordion panel to the home page to keep my scriblings tidy, and show most recent updates.
• Temoporary logo added to give the site some sort of identity; this will be replaced by flash banner when i have time to do one ;)
• Added my first testimonial from Leeway Van Centre to the testimonials page.
• Added testimonial from BP Builders Ltd to the testimonials page.
• Ooops, almost forgot, added new panel on navigation side of page to display number of members, will add newest member ID when time permits.

SITE 50% COMPLETE:

Site layout more or less complete, decided on pages and functionality:

• HOME - updates, new features and products.
• ABOUT - description of company, products and services.
• PRODUCTS - list pre-configured computer systems for purchase online.
• GAllERY - pictures of members computer systems, members can upload images.
• REFERENCES - pictures of members computer systems.
• CONTACT - pictures of members computer systems.
• LINKS - pictures of members computer systems.
• CONFIGURATOR - enables members to configure their own system.
• CONTROL PANEL - enables members to configure settings.
• REGISTER - enables new members to join the site.
• FORGOT PASSWORD - enables members to recover their password.

Added image upload code to the control panel, this creates a thumbnail image on-the-fly and saves to the server, the member name is tagged onto the image name, just so we know who upladed the image.

Added image display functionality to the gallery, so all images thumbnails in the gallery are displayed, may need to page this if gallery gets too large.

Added new user wizard so that members can join, which enables them to use the configurator, and to use the control panel, more to come...