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();
}
}
public WallRepository(WallContext context)
{
_context = context;
}