public static void InsertWard() { using (NHAMISContext dbcontext = new NHAMISContext()) { string path = HttpContext.Current.Server.MapPath(@"~/Models/Initialisation/Wards.txt"); string[] Wards = File.ReadAllLines(path); foreach (string WardLine in Wards) { string wardName = WardLine.Split('=')[0]; string subcountyName = WardLine.Split('=')[1]; var subcountyId = dbcontext.Subcounties.Where(n => n.SubCountyName == subcountyName).Select(c => c.Id).FirstOrDefault(); Subcounty subcounty = dbcontext.Subcounties.Find(subcountyId); Ward Ward = new Ward() { WardName = wardName, Subcounty = subcounty }; dbcontext.Wards.Add(Ward); } dbcontext.SaveChanges(); } }
public static void InsertWard() { using (SchoolContext dbcontext = new SchoolContext()) { string path = HttpContext.Current.Server.MapPath(@"~/Models/Initialisation/Wards.txt"); string[] Wards = File.ReadAllLines(path); foreach (string WardLine in Wards) { string wardName = WardLine.Split('=')[0]; string constituencyName = WardLine.Split('=')[1]; var ConstituencyId = dbcontext.Constituency.Where(n => n.Name == constituencyName).Select(c => c.Id).FirstOrDefault(); Constituency Constituency = dbcontext.Constituency.Find(ConstituencyId); Ward Ward = new Ward() { Name = wardName, Constituency = Constituency }; dbcontext.Ward.Add(Ward); } dbcontext.SaveChanges(); } }