static void seedDepartments(TcustContext context) { var names = new Dictionary <string, string>(); names.Add("護理系", ""); names.Add("醫務暨健康管理系", ""); names.Add("醫學影像暨放射科學所", ""); names.Add("放射醫學科學研究所", ""); names.Add("資訊科技與管理系", ""); names.Add("行銷與流通管理系", ""); names.Add("進修推廣部", ""); names.Add("資工系", ""); foreach (var item in names) { string name = item.Key; var exist = context.Types.Where(t => t.Name == name).FirstOrDefault(); if (exist == null) { var department = new Department { Active = true, Name = name }; string updatedBy = ""; department.SetUpdated(updatedBy); context.Departments.Add(department); context.SaveChanges(); } } }
static void seedTypes(TcustContext context) { var types = new Dictionary <string, string>(); types.Add("union", "策略聯盟"); types.Add("intern", "企業實習"); types.Add("project", "產學合作"); types.Add("sister", "姊妹校"); foreach (var item in types) { string name = item.Key; string code = item.Value; var exist = context.Types.Where(t => t.Name == name).FirstOrDefault(); if (exist == null) { context.Types.Add(new Tcust.Models.Type { Active = true, Code = code, Name = name }); context.SaveChanges(); } } }
static void seedPartionAreas(TcustContext context, int parentId, string partionName, string[] countryNames) { var partion = context.CountryAreas.Where(c => c.Name == partionName && c.IsPartition).FirstOrDefault(); if (partion == null) { throw new Exception(); } foreach (var name in countryNames) { var country = context.CountryAreas.Where(c => c.Name == name).FirstOrDefault(); if (country == null) { country = new CountryArea() { Name = name, Active = true, Parent = parentId }; context.CountryAreas.Add(country); } country.PartitionId = partion.Id; } context.SaveChanges(); }
static void seedPartitions(TcustContext context) { var parent = context.CountryAreas.Where(c => c.Name == "台灣").FirstOrDefault(); if (parent == null) { throw new Exception(); } var areas = new List <string>() { "北區", "中區", "南區", "東區", "離島" }; foreach (var name in areas) { var exist = context.CountryAreas.Where(c => c.Name == name).FirstOrDefault(); if (exist == null) { var area = new CountryArea() { Name = name, Active = true, Parent = parent.Id, IsPartition = true }; context.CountryAreas.Add(area); } } context.SaveChanges(); }
static void CreateTermYear(TermYear termYear, TcustContext context) { var exist = context.TermYears.Where(c => c.Year == termYear.Year).FirstOrDefault(); if (exist == null) { context.TermYears.Add(termYear); context.SaveChanges(); } }
static void CreateTerm(Term term, TcustContext context) { var exist = context.Terms.Where(c => c.Number == term.Number).FirstOrDefault(); if (exist == null) { term.TermYearId = context.TermYears.Where(c => c.Year == term.Year).FirstOrDefault().Id; context.Terms.Add(term); context.SaveChanges(); } }
static void seedCountries(TcustContext context) { var country = new CountryArea() { Name = "台灣", Active = true, Parent = 0 }; var exist = context.CountryAreas.Where(c => c.Name == country.Name).FirstOrDefault(); if (exist == null) { context.CountryAreas.Add(country); context.SaveChanges(); } }
static void seedPartners(TcustContext context) { string updatedBy = "Stephen"; var partner = new Partner() { Active = true, CountryId = 1, AreaId = 7, Name = "統一超商", Type = PartnerType.Enterprise, }; partner.SetUpdated(updatedBy); context.Partners.Add(partner); context.SaveChanges(); }