As a project or company grows, storing and managing information throughout your
business becomes virtually impossible.
But a well organized, easy-to-use application is crucial to future development and maintenance. Built in C#,
SSW Time PRO .NET lets you
take control of your data giving you more opportunity to
spend time where it really matters.
-
Prerequisites
If setting up on a new machine (after a "Backup" of the database has been made from the old machine and stored on a removable drive or CD/DVD), the following items need to be installed in the following order:
- Install IIS
- Go to "Start" > "Control Panel".
- Double click "Add or Remove Programs".
- Click the "Add/Remove Windows Components" button on the left hand side.
- Check the "Internet Information Services" checkbox.
- Click the "Next >" button.
- You may be asked to use the Windows installation CD.
- Install .NET 2.0
- Install SQL Server
- For Security, make sure that mixed authentication is provided (i.e. "SQL Server and Windows Authentication Mode").
- Install SQL Server SP 1a, 2, 3a, and 4
- Install SQL Reporting Services
- Install SQL Reporting Services Service Packs
- "Restore" the database using Enterprise Manager.
- Expand the Database Server node (i.e. "(local)").
- Right-click the "Databases" node and select "All Tasks" > "Restore Database...".
- Specify the name of the database to be Restored and select the "From Device" radio button.
- Click on the elipses button (i.e. "...") or with SQL 2000 click the "Select Devices..." button.
- Click the "Add" button (and then the elipses "..." button in SQL 2000).
- Locate the backed up database (i.e. the .bak or .sqlbak or .trn file) from CD/DVD or Removable Drive.
- Click "OK" then "OK" again, and check the "Restore" checkbox.
- In the "Options" section, confirm that the .mdf and .ldf files are pointing to the correct location of the installed version of SQL Server (i.e. "C:\Program Files\Microsoft SQL Server\MSSQL\Data\").
- Click "OK" to restore.
- Install SSW TimePRO.NET
Note: If remote machines need to access the the database server then the firewall must be turned off.
-
Running Time PRO .NET and Connecting to a New or Existing Database

Figure: If you are running SSW Time PRO .NET for the first time, configure your database

Figure: Click Select... to configure your database.

Figure: Create a "New Database" or "Use Existing Database"

Figure: For a new database, SSW SQL Deploy will launch and create the new database

Figure: For an existing database, click "Build..." to search for the database on the server using the Data Link Properties dialog.

Figure: Login Time PRO .NET - The default password for two sample accounts is "timepro"
Note: You can also configure the database connection by clicking the "Connect" button.

Figure: The Time PRO .NET main menu
-
Options and Preferences
When selecting Tools -> Options, the Options Dialog will open with four tabs.

Figure: Timesheets Tab - Preferences for the timesheet entries which are stored in the
user's the configuration file

Figure: Connection tab - Select whether you want to connect to your data
via web services or a direct database connection

Figure: Database tab - For a direct database connection to the database,
set the connection string
and update the database version

Figure: Reports tab - Configure the Reporting Services reports (optional)
-
Configure Reports
In order to configure reports on a local or remote server the following steps must be taken:
- From the menu go to Tools > Options
- Select the "Reports" Tab and click the "Select.." button

Figure: Configure reports on an existing report server.
- On the Create Reports Form select the "New Publication" radio button and click the elipses button "..."

Figure: Create Reports Form.
- Select a folder that contains the .rdl files (e.g. C:\Program Files\SSW Time PRO.NET\Reports).

Figure: Select Folder.
- Click on the "Create" button.

Figure: "Create" Report folder.
- Wait until the Reports are created.

Figure: Report creation progress form.
The report form accessed from the main form, allows you to select certain types of reports
(from projects, to clients, or employees).

Figure: Figure: Reports Form provides a tree of the types of reports you can view.

Figure: Reports filter form to select a specific Project to report on.
Reports will be generated through SQL Server Reporting Services.
View a sample of the
Project Report.
-
Client Form
The client form gives you the option of adding information from four
different sections including Details, Contacts, Rates, and Projects.

Figure: Details Tab - Enter general client information

Figure: Contacts tab - Enter other contacts for the client and set the
main contact

Figure: Rates tab - Keep track of any special
charges or deals that you have made with your clients

Figure: Projects tab - Lists all the active projects for the client
-
Employee Form
The employee form gives you the option of adding information from three
different sections including Details, Accounts, and Rates.

Figure: Details tab - Enter general information for an employee

Figure: Accounts tab - Enter the employee's bank and super details

Figure: Rates tab - keep track of any special
charges or deals that the Employee is involved in
-
Projects Form
At SSW there are plenty of projects for plenty of clients. SSW Time PRO
.NET is a project on its own, and all details and charges, Start dates and
due dates need to be stored with an easy way to view them. The Project Form
gives you the option of adding information from three different sections
including Details, Contacts, Financial, and Time.

Figure: Details tab - enter general information about a project

Figure: Financial tab - Enter financial information for the project

Figure: Contacts tab - View contact details of the client involved in the
project
-
Search Forms
At SSW we provide a standard Search Form in all our products with
enhanced capabilities of searching for any particular employee or client
etc. This Search Form comes with a complex set of criteria to allow users
the perfect chance to find what they are looking for.

Figure: An example of an Employee Search Form.
-
Timesheet Forms
Time sheets need to be entered by employees in every company to keep
track of what they have done on a daily basis. If every employee is required
to enter timesheets every day there has to be a quick, easy and efficient
method of entering their daily work details.

Figure: The Time Sheet Summary Form provides a one-click display for
details on any calendar day. Entries entered per day can be viewed, deleted
and
edited.

Figure: New/edit time entry form - Enter and edit details on a specific
time entry. With
auto-complete on fields, the Entry Form provides the most efficient way to
enter time sheets every day.
-
Additional Help
For any additional information you would like to read about check our
knowledge base in the help menu of the application.

Figure: Click Help->SSW Knowledge Base to read articles and FAQs on SSW Time
PRO .NET
For any additional features or suggestions click the "Suggestion" menu
item to open a new email message addressed to SSW.
-
Acknowledgements
Adam Cogan
Adel Helal