public void ImportSuburbs(MyHobbyContext context)
{
List <Suburb> suburbs = new List <Suburb>();
StreamReader sr = null;
try
{
City hk = context.Cities.SingleOrDefault(c => c.EnglishName == "Hong Kong");
if (hk != null)
{
return;
}
hk = new City()
{
Name = "香港", EnglishName = "Hong Kong"
};
context.Cities.Add(hk);
Assembly resourceAssembly = Assembly.GetAssembly(typeof(MyHobby.Resources.LocateThisAssembly));
Stream stream = resourceAssembly.GetManifestResourceStream("MyHobby.Resources.Suburbs_HK.txt");
sr = new StreamReader(stream);
if (sr != null)
{
string line = sr.ReadLine();
SuburbGroup group = null;
while (!string.IsNullOrEmpty(line))
{
string[] fields = SplitCSV(line); //line.Split(',');
if (fields.Length == 3)
{
group = new SuburbGroup()
{
Name = fields[1],
EnglishName = fields[2],
City = hk
};
context.SuburbGroups.Add(group);
}
else
{
Suburb suburb = new Suburb()
{
Name = fields[0],
EnglishName = fields[1],
SuburbGroup = group
};
context.Suburbs.Add(suburb);
}
line = sr.ReadLine();
}
context.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (sr != null)
{
sr.Close();
}
}
}
public BusinessRepository(MyHobbyContext ctx)
{
_ctx = ctx;
}
public UserRepository(MyHobbyContext ctx)
{
_ctx = ctx;
}
public SuburbRepository(MyHobbyContext ctx)
{
_ctx = ctx;
}
public void CallSeed(MyHobbyContext context)
{
Seed(context);
}
public AdminController(MyHobbyContext context)
{
_context = context;
}
public LessonRepository(MyHobbyContext ctx)
{
_ctx = ctx;
}
public SessionRepository(MyHobbyContext ctx)
{
_ctx = ctx;
}
