public static void SeedWalls(WallContext context)
        {
            // if the database is empty
            if (!context.RetainingWalls.Any())
            {
                var             walls  = new List <RetainingWall>();
                TextFieldParser parser = new TextFieldParser("Data\\WallOutput2.csv");
                parser.SetDelimiters(",");

                while (!parser.EndOfData)
                {
                    string[] wall = parser.ReadFields();

                    if (parser.LineNumber != 2)
                    {
                        double longitude, latitude, length, maxHeight, minHeight;
                        Double.TryParse(wall[4], out longitude);
                        //RetainingWall.Longitude = longitude;
                        Double.TryParse(wall[5], out latitude);
                        //RetainingWall.Latitude = latitude;
                        Double.TryParse(wall[1], out length);
                        Double.TryParse(wall[2], out maxHeight);
                        Double.TryParse(wall[3], out minHeight);

                        var retainingWall = new RetainingWall()
                        {
                            Location  = wall[0],
                            Length    = length,
                            MaxHeight = maxHeight,
                            MinHeight = minHeight,
                            Longitude = longitude,
                            Latitude  = latitude
                        };

                        walls.Add(retainingWall);
                    }
                }

                foreach (var wall in walls)
                {
                    context.RetainingWalls.Add(wall);
                }

                context.SaveChanges();
            }
        }
Exemplo n.º 2
0
 public WallRepository(WallContext context)
 {
     _context = context;
 }