/// <summary>
/// Dodawanie nowej linii
/// </summary>
/// <param name="id">Id obszaru</param>
public void LineCreate(int id)
{
Geodeta.Data.Line line = new Geodeta.Data.Line {
AreaId = id
};
this.db.Line.Add(line);
this.db.SaveChanges();
}
/// <summary>
/// Pobieranie linii o danym id
/// </summary>
/// <param name="id">Id linii</param>
/// <returns>Linia o danym id</returns>
public Geodeta.Data.Line LineDetails(int id = 0)
{
Geodeta.Data.Line linia = this.db.Line.Find(id);
if (linia == null)
{
return(null);
}
return(linia);
}
/// <summary>
/// Dodawanie linii punktów i listy punktów obszaru
/// </summary>
/// <param name="id">Id obszaru</param>
/// <param name="x">Lista wspołrzędnych X punktów</param>
/// <param name="y">Lista wspołrzędnych Y punktów</param>
/// <param name="note">Lista id notatek</param>
public void CreateListOfPoints(int id, List <double> x, List <double> y, List <string> notetitlepoint, List <string> notecontentpoint, List <string> notetitleline, List <string> notecontentline)
{
List <int> lineid = new List <int>();
List <int> pointid = new List <int>();
Debug.WriteLine(notetitleline.Count);
for (int i = 0; i < x.Count; i++)
{
if (notetitleline[i] != "" && notecontentline[i] != "Brak notatki")
{
Geodeta.Data.Note note1 = this.db.Note.Add(new Geodeta.Data.Note {
Title = notetitleline[i], ContentNote = notecontentline[i]
});
this.db.SaveChanges();
Geodeta.Data.Line line = new Geodeta.Data.Line {
AreaId = id, NoteId = note1.ID
};
this.db.Line.Add(line);
this.db.SaveChanges();
lineid.Add(line.ID);
}
else
{
Geodeta.Data.Line line = new Geodeta.Data.Line {
AreaId = id
};
this.db.Line.Add(line);
this.db.SaveChanges();
lineid.Add(line.ID);
}
if (notetitlepoint[i] != "" && notecontentpoint[i] != "Brak notatki")
{
Debug.WriteLine("waruenk 1");
Geodeta.Data.Note note1 = this.db.Note.Add(new Geodeta.Data.Note {
Title = notetitlepoint[i], ContentNote = notecontentpoint[i]
});
this.db.SaveChanges();
Geodeta.Data.Point point = new Geodeta.Data.Point {
CoordinateX = x[i], CoordinateY = y[i], NoteId = note1.ID
};
this.db.Point.Add(point);
this.db.SaveChanges();
pointid.Add(point.ID);
}
else
{
Debug.WriteLine("waruenk else1");
Geodeta.Data.Point point = new Geodeta.Data.Point {
CoordinateX = x[i], CoordinateY = y[i]
};
this.db.Point.Add(point);
this.db.SaveChanges();
pointid.Add(point.ID);
}
}
for (int i = 0; i < pointid.Count; i++)
{
if (i == 0)
{
this.db.ListOfPoints.Add(new Geodeta.Data.ListOfPoints {
LineId = lineid[i], PointId = pointid[i]
});
this.db.SaveChanges();
}
if (i > 0 && pointid.Count - 1 > i)
{
this.db.ListOfPoints.Add(new Geodeta.Data.ListOfPoints {
LineId = lineid[i - 1], PointId = pointid[i]
});
this.db.ListOfPoints.Add(new Geodeta.Data.ListOfPoints {
LineId = lineid[i], PointId = pointid[i]
});
this.db.SaveChanges();
}
if (pointid.Count - 1 == i)
{
this.db.ListOfPoints.Add(new Geodeta.Data.ListOfPoints {
LineId = lineid[i - 1], PointId = pointid[i]
});
this.db.ListOfPoints.Add(new Geodeta.Data.ListOfPoints {
LineId = lineid[i], PointId = pointid[i]
});
this.db.ListOfPoints.Add(new Geodeta.Data.ListOfPoints {
LineId = lineid[i], PointId = pointid[i - (x.Count - 1)]
});
this.db.SaveChanges();
}
}
}
