/// <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(); } } }