I dette afsnit vises eksempler på hvordan servicen kan kaldes fra et C# program. Der ligges til grund, at der er oprettet en reference til servicen. For at se afsnit hvordan servicen kan kaldes fra en browser. klik her
Hent entitet
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
|
private void button_GetEntity_Click( object sender, EventArgs e) { // Hent virksomhed hvis SeqNo = 175100043 decimal seqNo = 175100043; var svc = new GeoEnvironODataServiceContext(svcUri); var company = (from c in svc.Companies where c.SeqNo == seqNo select c).FirstOrDefault(); // Vis virksomheds info string geometriWKT = (company.GeometryWKT == null ? "" : company.GeometryWKT); string link = company.GELink; string id = company.Id; string navn = company.Name; string adresse = company.Address; string postnr = company.PostalCode; string by = company.PostalCodeName; string kommunenr = company.MunicipalityCode; string vejkode = company.StreetCode; string husnr = company.StreetBuildingIdentifier; string matrnr = company.LandParcelIdentifier; string ejerlavskode = company.CadastralDistrictIdentifier; string ejerlav = company.CadastralDistrictName; string etableringsDato = (company.EstablishDate == null ? "" : company.EstablishDate.Value.ToString( "dd-MM-yyyy" )); string cvr = company.CentralCompanyNo; string hovedAktivitet = company.MainActivity; string hovedAktivitetId = company.MainActivityId; string hovedAktivitetLovId = company.MainActivityLegislationId; string sagsbehandler = company.OfficerId; string spildevandTilRec = company.WasteWaterToRecipient; string risikoaktivitet = company.ActivityRisk; } |
Opret/ Redigér geometri
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
private void button_CreateOrUpdateGeometry_Click( object sender, EventArgs e) { // Opret eller redigér geomerti for boring hvis SeqNo = 175100004 decimal seqNo = 175100004; string seqNoType = "boring" ; string geometryWKT = "POINT (506968.371 6240963.933)" ; var svc = new GeoEnvironODataServiceContext(svcUri); Geometry geometry = new Geometry() { SeqNo = seqNo, SeqNoType = seqNoType, GeometryWKT = geometryWKT }; svc.AddToGeometries(geometry); svc.SaveChanges(); } |
Slet geometri
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
|
private void button_DeleteGeometry_Click( object sender, EventArgs e) { // Slet geomerti for boring hvis SeqNo = 175100004 decimal seqNo = 175100004; string seqNoType = "boring" ; var svc = new GeoEnvironODataServiceContext(svcUri); Geometry geometry; try { geometry = (from g in svc.Geometries where g.SeqNo == seqNo && g.SeqNoType == seqNoType select g).FirstOrDefault(); } catch (System.Data.Services.Client.DataServiceQueryException) { //Geometrien findes ikke! return ; } svc.DeleteObject(geometry); svc.SaveChanges(); } |
Opret kontakt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
|
private void button_CreateBldApplicant_Click( object sender, EventArgs e) { decimal seqNo = 0; decimal bldCasefileSeqNo = 175100009; string name = "Geokon A/S" ; string name2 = null ; string municipalityCode = "175" ; string streetCode = "0705" ; int ? streetBuildingNumber = 11; string streetBuildingLetter = null ; string streetBuildingApartNumber = null ; string address = "Rødovrevej 11" ; string postCode = "2610" ; string cvrCpr = "15959177" ; string attention = null ; string comment = null ; var svc = new GeoEnvironODataServiceContext( new Uri( "http://devapp1:10051/GeoEnvironODataService.svc/" )); BldApplicant newBldApplicant = new BldApplicant() { SeqNo = seqNo, BldCasefileSeqNo = bldCasefileSeqNo, Name = name, Name2 = name2, MunicipalityCode = municipalityCode, StreetCode = streetCode, StreetBuildingNumber = streetBuildingNumber, StreetBuildingLetter = streetBuildingLetter, StreetBuildingApartNumber = streetBuildingApartNumber, Address = address, PostCode = postCode, CvrCpr = cvrCpr, Attention = attention, Comment = comment }; //Check om BldApplicant allerede findes BldApplicant existingApplicant = (from bldApplicant in svc.BldApplicants where bldApplicant.BldCasefileSeqNo == newBldApplicant.BldCasefileSeqNo && bldApplicant.Name == newBldApplicant.Name select bldApplicant).FirstOrDefault(); if (existingApplicant != null ) { DialogResult result = MessageBox.Show( "BldApplicant eksisterer allerede.\nOpret BldApplicant alligevel?" , "BldApplicant eksisterer allerede" , MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation); if (result != DialogResult.Yes) return ; } // Opret BldApplicant svc.AddToBldApplicants(newBldApplicant); svc.SaveChanges(); //Verificer at BldApplicant blev oprettet BldApplicant applicant = (from bldApplicant in svc.BldApplicants where bldApplicant.BldCasefileSeqNo == newBldApplicant.BldCasefileSeqNo && bldApplicant.Name == newBldApplicant.Name select bldApplicant).FirstOrDefault(); if (applicant == null ) throw new Exception( "Den nye BldApplicant er ikke blevet registreret" ); } |
Kommentarer
0 kommentarer
Artiklen er lukket for kommentarer.