TeamViewer

Artikler i denne sektion

Eksempler på C# kode

Avatar
Henrik Bohn
Opdateret
Følg

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;
    Uri svcUri = new Uri("http://srv2008trktest:10050/GeoEnvironODataService.svc/");
    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)";
 
    Uri svcUri = new Uri("http://srv2008trktest:10050/GeoEnvironODataService.svc/");
    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";
     
    Uri svcUri = new Uri("http://srv2008trktest:10050/GeoEnvironODataService.svc/");
    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.