Talk:Sildur: Difference between revisions

From ICO wiki
Jump to navigationJump to search
Ipruul (talk | contribs)
Ipruul (talk | contribs)
No edit summary
Line 23: Line 23:


'''Koostaja: meeskond [[Pohjavesi]] '''
'''Koostaja: meeskond [[Pohjavesi]] '''
Projekti idee on Maanteeametil omada paremat ülevaadet Eesti riigiteedel olevatest sildadest ja nende olukorrast.
Tegu on mahuka ja ambitsioonika projektiga, eriti lisab keerukust Exceli failide sisselugemine.
Väga positiivne oli kaasas olev readme.txt fail, kus seletati kuidas programmi õigeks töötamiseks tuleb esmalt SQL Server Management Studios luua andmebaas ja seejärel importida kaasa pandud sql fail.
Pärast mõningasi katsetusi õnnestus programm tööle saada.
Mõningad veateated millega tuli tegemist teha:
----
System.Core
    Assembly Version: 4.0.0.0
    Win32 Version: 4.6.79.0 built by: NETFXREL2
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Xml
    Assembly Version: 4.0.0.0
    Win32 Version: 4.6.79.0 built by: NETFXREL2
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
PresentationFramework.Aero2
    Assembly Version: 4.0.0.0
    Win32 Version: 4.6.79.0 built by: NETFXREL2
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/PresentationFramework.Aero2/v4.0_4.0.0.0__31bf3856ad364e35/PresentationFramework.Aero2.dll
----------------------------------------
PresentationFramework-SystemXml
    Assembly Version: 4.0.0.0
    Win32 Version: 4.6.79.0
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/PresentationFramework-SystemXml/v4.0_4.0.0.0__b77a5c561934e089/PresentationFramework-SystemXml.dll
----------------------------------------
UIAutomationTypes
    Assembly Version: 4.0.0.0
    Win32 Version: 4.6.79.0 built by: NETFXREL2
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/UIAutomationTypes/v4.0_4.0.0.0__31bf3856ad364e35/UIAutomationTypes.dll
----------------------------------------
System.Windows.Forms
    Assembly Version: 4.0.0.0
    Win32 Version: 4.6.79.0 built by: NETFXREL2
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
    Assembly Version: 4.0.0.0
    Win32 Version: 4.6.93.0 built by: NETFXREL2STAGE
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
CustomMarshalers
    Assembly Version: 4.0.0.0
    Win32 Version: 4.6.79.0 built by: NETFXREL2
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/CustomMarshalers/v4.0_4.0.0.0__b03f5f7f11d50a3a/CustomMarshalers.dll
----------------------------------------
UIAutomationProvider
    Assembly Version: 4.0.0.0
    Win32 Version: 4.6.79.0 built by: NETFXREL2
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/UIAutomationProvider/v4.0_4.0.0.0__31bf3856ad364e35/UIAutomationProvider.dll
----------------------------------------
Sillad.BLL
    Assembly Version: 1.0.0.0
    Win32 Version: 1.0.0.0
    CodeBase: file:///C:/Users/ipruu_000/Documents/c%23%20projekt/hindamine/SillaRakendus_3.1_prototyyp/SillaRakendusUI/bin/Debug/Sillad.BLL.DLL
----------------------------------------
Microsoft.CSharp
    Assembly Version: 4.0.0.0
    Win32 Version: 4.6.79.0
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Microsoft.CSharp/v4.0_4.0.0.0__b03f5f7f11d50a3a/Microsoft.CSharp.dll
----------------------------------------
System.Dynamic
    Assembly Version: 4.0.0.0
    Win32 Version: 4.6.79.0
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Dynamic/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Dynamic.dll
----------------------------------------
Anonymously Hosted DynamicMethods Assembly
    Assembly Version: 0.0.0.0
    Win32 Version: 4.6.127.1 built by: NETFXREL3STAGE
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/mscorlib/v4.0_4.0.0.0__b77a5c561934e089/mscorlib.dll
----------------------------------------
Sillad.DAL
    Assembly Version: 1.0.0.0
    Win32 Version: 1.0.0.0
    CodeBase: file:///C:/Users/ipruu_000/Documents/c%23%20projekt/hindamine/SillaRakendus_3.1_prototyyp/SillaRakendusUI/bin/Debug/Sillad.DAL.DLL
----------------------------------------
EntityFramework
    Assembly Version: 6.0.0.0
    Win32 Version: 6.1.40302.0
    CodeBase: file:///C:/Users/ipruu_000/Documents/c%23%20projekt/hindamine/SillaRakendus_3.1_prototyyp/SillaRakendusUI/bin/Debug/EntityFramework.DLL
----------------------------------------
System.Data
    Assembly Version: 4.0.0.0
    Win32 Version: 4.6.127.1 built by: NETFXREL3STAGE
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
EntityFramework.SqlServer
    Assembly Version: 6.0.0.0
    Win32 Version: 6.1.40302.0
    CodeBase: file:///C:/Users/ipruu_000/Documents/c%23%20projekt/hindamine/SillaRakendus_3.1_prototyyp/SillaRakendusUI/bin/Debug/EntityFramework.SqlServer.DLL
----------------------------------------
System.Numerics
    Assembly Version: 4.0.0.0
    Win32 Version: 4.6.79.0 built by: NETFXREL2
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll
----------------------------------------
System.Data.OracleClient
    Assembly Version: 4.0.0.0
    Win32 Version: 4.6.79.0 built by: NETFXREL2
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Data.OracleClient/v4.0_4.0.0.0__b77a5c561934e089/System.Data.OracleClient.dll
----------------------------------------
System.Transactions
    Assembly Version: 4.0.0.0
    Win32 Version: 4.6.79.0 built by: NETFXREL2
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.Xml.Linq
    Assembly Version: 4.0.0.0
    Win32 Version: 4.6.79.0 built by: NETFXREL2
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml.Linq/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.Linq.dll
----------------------------------------
System.ComponentModel.DataAnnotations
    Assembly Version: 4.0.0.0
    Win32 Version: 4.6.93.0
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.ComponentModel.DataAnnotations/v4.0_4.0.0.0__31bf3856ad364e35/System.ComponentModel.DataAnnotations.dll
----------------------------------------
System.EnterpriseServices
    Assembly Version: 4.0.0.0
    Win32 Version: 4.6.79.0 built by: NETFXREL2
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:
<configuration>
    <system.windows.forms jitDebugging="true" />
</configuration>
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
----
Eeldatavasti oli tegu probleemiga kus erinevalt käituvad otse Sisual Studiost käivitatav projekt ja exe failist käivitatav projekt.
Programmi ilu varjutavad natuke pidevad haldamatta vea teated, aga kui korra on andmed sisse laetud, siis väheneb tekkivate vigade arv.

Revision as of 00:22, 31 January 2016

Retsensioon meeskonna Sildur projekti prototüübile

Koostaja: meeskond Pohjavesi

Projekti idee on Maanteeametil omada paremat ülevaadet Eesti riigiteedel olevatest sildadest ja nende olukorrast.

Visuaalselt on tegu lihtsa wpf rakendusega, milles siiski on rõhku suunatud funktsionaalsusele.

Rakendus laseb luua uue kasutaja ja sellega siis sisse logida. Esiplaanil tuleb kasutaja ID millega kasutaja sisse logis. Nuppudest on realiseeritud Lisa/Muuda sildade andmeid, kus uues aknas avanevad Sildade lisamine, sildade muutmise ja importimise nupud. Väga positiivseks kujunes kasutaja tegevuste logi omamine ja kuvamine.


Sildade otsing ja sildade analüüsi nupud ei ole veel realiseeritud. Vigaselt kuvab programm ka Eesnime välja ning asutust, e-maili ei kuvata üldse.

Must have funktsionaalsusest puudub veel silla elementidega seonduvad väärtused ja pildialbum.

Üldiselt vaadates on tegu korraliku mauhka projektiga, milles on realiseeritud palju MVVM kihilise olemuse tugevaid pooli.


Retsensioon meeskonna Sildur projekti lõpppversioonile

Koostaja: meeskond Pohjavesi


Projekti idee on Maanteeametil omada paremat ülevaadet Eesti riigiteedel olevatest sildadest ja nende olukorrast. Tegu on mahuka ja ambitsioonika projektiga, eriti lisab keerukust Exceli failide sisselugemine.

Väga positiivne oli kaasas olev readme.txt fail, kus seletati kuidas programmi õigeks töötamiseks tuleb esmalt SQL Server Management Studios luua andmebaas ja seejärel importida kaasa pandud sql fail.


Pärast mõningasi katsetusi õnnestus programm tööle saada.

Mõningad veateated millega tuli tegemist teha:



System.Core

   Assembly Version: 4.0.0.0
   Win32 Version: 4.6.79.0 built by: NETFXREL2
   CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll

System.Xml

   Assembly Version: 4.0.0.0
   Win32 Version: 4.6.79.0 built by: NETFXREL2
   CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll

PresentationFramework.Aero2

   Assembly Version: 4.0.0.0
   Win32 Version: 4.6.79.0 built by: NETFXREL2
   CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/PresentationFramework.Aero2/v4.0_4.0.0.0__31bf3856ad364e35/PresentationFramework.Aero2.dll

PresentationFramework-SystemXml

   Assembly Version: 4.0.0.0
   Win32 Version: 4.6.79.0
   CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/PresentationFramework-SystemXml/v4.0_4.0.0.0__b77a5c561934e089/PresentationFramework-SystemXml.dll

UIAutomationTypes

   Assembly Version: 4.0.0.0
   Win32 Version: 4.6.79.0 built by: NETFXREL2
   CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/UIAutomationTypes/v4.0_4.0.0.0__31bf3856ad364e35/UIAutomationTypes.dll

System.Windows.Forms

   Assembly Version: 4.0.0.0
   Win32 Version: 4.6.79.0 built by: NETFXREL2
   CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll

System.Drawing

   Assembly Version: 4.0.0.0
   Win32 Version: 4.6.93.0 built by: NETFXREL2STAGE
   CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll

CustomMarshalers

   Assembly Version: 4.0.0.0
   Win32 Version: 4.6.79.0 built by: NETFXREL2
   CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/CustomMarshalers/v4.0_4.0.0.0__b03f5f7f11d50a3a/CustomMarshalers.dll

UIAutomationProvider

   Assembly Version: 4.0.0.0
   Win32 Version: 4.6.79.0 built by: NETFXREL2
   CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/UIAutomationProvider/v4.0_4.0.0.0__31bf3856ad364e35/UIAutomationProvider.dll

Sillad.BLL

   Assembly Version: 1.0.0.0
   Win32 Version: 1.0.0.0
   CodeBase: file:///C:/Users/ipruu_000/Documents/c%23%20projekt/hindamine/SillaRakendus_3.1_prototyyp/SillaRakendusUI/bin/Debug/Sillad.BLL.DLL

Microsoft.CSharp

   Assembly Version: 4.0.0.0
   Win32 Version: 4.6.79.0
   CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Microsoft.CSharp/v4.0_4.0.0.0__b03f5f7f11d50a3a/Microsoft.CSharp.dll

System.Dynamic

   Assembly Version: 4.0.0.0
   Win32 Version: 4.6.79.0
   CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Dynamic/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Dynamic.dll

Anonymously Hosted DynamicMethods Assembly

   Assembly Version: 0.0.0.0
   Win32 Version: 4.6.127.1 built by: NETFXREL3STAGE
   CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/mscorlib/v4.0_4.0.0.0__b77a5c561934e089/mscorlib.dll

Sillad.DAL

   Assembly Version: 1.0.0.0
   Win32 Version: 1.0.0.0
   CodeBase: file:///C:/Users/ipruu_000/Documents/c%23%20projekt/hindamine/SillaRakendus_3.1_prototyyp/SillaRakendusUI/bin/Debug/Sillad.DAL.DLL

EntityFramework

   Assembly Version: 6.0.0.0
   Win32 Version: 6.1.40302.0
   CodeBase: file:///C:/Users/ipruu_000/Documents/c%23%20projekt/hindamine/SillaRakendus_3.1_prototyyp/SillaRakendusUI/bin/Debug/EntityFramework.DLL

System.Data

   Assembly Version: 4.0.0.0
   Win32 Version: 4.6.127.1 built by: NETFXREL3STAGE
   CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll

EntityFramework.SqlServer

   Assembly Version: 6.0.0.0
   Win32 Version: 6.1.40302.0
   CodeBase: file:///C:/Users/ipruu_000/Documents/c%23%20projekt/hindamine/SillaRakendus_3.1_prototyyp/SillaRakendusUI/bin/Debug/EntityFramework.SqlServer.DLL

System.Numerics

   Assembly Version: 4.0.0.0
   Win32 Version: 4.6.79.0 built by: NETFXREL2
   CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll

System.Data.OracleClient

   Assembly Version: 4.0.0.0
   Win32 Version: 4.6.79.0 built by: NETFXREL2
   CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Data.OracleClient/v4.0_4.0.0.0__b77a5c561934e089/System.Data.OracleClient.dll

System.Transactions

   Assembly Version: 4.0.0.0
   Win32 Version: 4.6.79.0 built by: NETFXREL2
   CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll

System.Xml.Linq

   Assembly Version: 4.0.0.0
   Win32 Version: 4.6.79.0 built by: NETFXREL2
   CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml.Linq/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.Linq.dll

System.ComponentModel.DataAnnotations

   Assembly Version: 4.0.0.0
   Win32 Version: 4.6.93.0
   CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.ComponentModel.DataAnnotations/v4.0_4.0.0.0__31bf3856ad364e35/System.ComponentModel.DataAnnotations.dll

System.EnterpriseServices

   Assembly Version: 4.0.0.0
   Win32 Version: 4.6.79.0 built by: NETFXREL2
   CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll

                            • JIT Debugging **************

To enable just-in-time (JIT) debugging, the .config file for this application or computer (machine.config) must have the jitDebugging value set in the system.windows.forms section. The application must also be compiled with debugging enabled.

For example:

<configuration>

   <system.windows.forms jitDebugging="true" />

</configuration>

When JIT debugging is enabled, any unhandled exception will be sent to the JIT debugger registered on the computer rather than be handled by this dialog box.



Eeldatavasti oli tegu probleemiga kus erinevalt käituvad otse Sisual Studiost käivitatav projekt ja exe failist käivitatav projekt.

Programmi ilu varjutavad natuke pidevad haldamatta vea teated, aga kui korra on andmed sisse laetud, siis väheneb tekkivate vigade arv.