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; }