public Provider() { if (context == null) { context = new DataAccessDataContext(); } }
private Guid InsertWardMetadata(Guid zoneId, int wardNumber, string wardName, CordinatePoint top, CordinatePoint left, CordinatePoint bottom, CordinatePoint right, DataAccessDataContext context) { Guid wardId = Guid.NewGuid(); Ward ward = new Ward { Id = wardId, Number = wardNumber, Name = wardName, ZoneId = zoneId, TopCordinate = top.Latitude + "," + top.Longitude, LeftCordinate = left.Latitude + "," + left.Longitude, BottomCordinate = bottom.Latitude + "," + bottom.Longitude, RightCordinate = right.Latitude + "," + right.Longitude }; context.Wards.InsertOnSubmit(ward); SubmitData(); return wardId; }
private void InsertCordinateMetadata(Guid wardId, IList<CordinatePoint> cordinates, DataAccessDataContext context) { IList<Cordinate> cordinateList = new List<Cordinate>(); foreach (var cordinate in cordinates) { Cordinate cordinatePoint = new Cordinate { Id = Guid.NewGuid(), Latitude = cordinate.Latitude, Longitude = cordinate.Longitude, WardId = wardId, Rank = cordinate.Rank }; cordinateList.Add(cordinatePoint); } context.Cordinates.InsertAllOnSubmit(cordinateList.AsEnumerable()); SubmitData(); }