Description

The project implements multy-functional University Explorer application based on tree view which provide to manage all stuff and activities inthe university .

The project is implemented as a n-tier application.

The data is stored in InterBase and SQL Server DataBases

Project structure:

-The DataAccess Layer is implemented using EntityFramework.

-Busines logic layer -Classical Asmx WebService which use DataAccess Layer methods and implement distributed logic for different connections

-The Presentation layer is implemented as a Desctop Application (WinForms)

Basic Technology:

.NET ( C# )

Source Control:

We are going to use Tortoise SVNr as a Source Control

Team Members:

Our team consists of 6 guys
  • Vyshnevskyy Oleksandr
  • Oleksiv Ivan
  • Pogranychnyy Andrij
  • Strutynskyy Andrij
  • Terlezkyy Volodymyr
  • Uzhela Oleksandr

Photo Gallery













And KADABRA Man - our special consultant


GetStarted

  1. Register on codeplex.com
login name must be clear( like my ovyshnevskyy )
  1. Join our project at http://universityexplorer.codeplex.com.
Send yours login names to my email xanderednax@gmail.com and then I add you to the project members
  1. Download TortoiceSvn
http://sourceforge.net/projects/tortoisesvn/files/Application/1.6.5/TortoiseSVN-1.6.5.16974-win32-svn-1.6.5.msi/download
Install it and make check out with

URL: https://universityexplorer.svn.codeplex.com/svn
Username: <same as your website password>
Password: <same as your website password>
  1. Install Firebird database engine and DDEX extension for VS2008.

Follow next steps

1. Download proper Firebird distribution from Firebird page (download the installer as well as the embed version). from http://www.firebirdsql.org/index.php?op=files&id=engine_211

2. Install Firebird. Remember, the main user and password is sysdba/password and you can change it using gsec -user SYSDBA -password masterkey -modify sysdba -pw blahblah

3. Download and install the Firebird .NET client from http://www.firebirdsql.org/index.php?op=files&id=netprovider

4. A little tricky part here: You have to find the proper "gacutil.exe" file for your .NET distribution. The one you can find in c:\windows\microsoft.net\... ISN'T the right one, it's for .NET 1.x framework. I've found the proper one in c:\program files\Microsoft SDK's\Windows\v6.0A\Bin\x64 (Vista 64bit). So - with this gacutil do this:
gacutil.exe /l FirebirdSql.Data.FirebirdClient

You have to get something like this:
<cite>
Microsoft (R) .NET Global Assembly Cache Utility. Version 3.5.21022.8
Copyright (c) Microsoft Corporation. All rights reserved.
The Global Assembly Cache contains the following assemblies:
FirebirdSql.Data.FirebirdClient, Version=2.5.0.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c, processorArchitecture=MSIL
Number of items = 1
</cite>

There are two interesting info we'll need soon: Version number and PublicKeyToken. Write it down now.

5. Download the Firebird DDEX provider and unzip the whole archive to the common accessible directory (D:\prog\firebird for me). from http://downloads.sourceforge.net/firebird/FirebirdDDEXProvider-2.0.4.zip

6. Modify machine.config file (it resides somewhere in the c:\windows\microsoft.net\framework\V2.xxx... directory - don't worry there is "v2", it's valid for .NET3.5 too). Do these changes:

Immediatelly BEFORE the tag </configSections> insert this line:
<cite><section name="firebirdsql.data.firebirdclient" type="System.Data.Common.DbProviderConfigurationHandler, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /></cite>

Immediatelly BEFORE the tag </DbProviderFactories> insert this line:
<cite><add name="FirebirdClient Data Provider" invariant="FirebirdSql.Data.FirebirdClient" description=".Net Framework Data Provider for Firebird" type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient, Version=2.5.0.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c" /></cite>

(replace the PublicToken and the Version by the values from step 4) Pay attention here - the </DbProviderFactories> may be hidden on the end of the line!

Modify the 32bit version is enough, but you can modify the 64bit version of machine.config too.

7. Edit the proper XXX.reg file for your system (located in the DDEX archive (step 5) in the reg_files folder). Replace the %Path% with the path to the DDEX files (I've d:\\prog\\firebird - don't forget the double backslashes! Import this .reg file to the register (just double click on it.)

That's it! Start the Visual Studio and try to add Firebird data source.

Last edited Nov 9, 2009 at 10:15 AM by ovyshnevskyy, version 18