public static void Main(string[] args) { FileAdapter fileAdapter = new FileAdapter(); var allFamilies = fileAdapter.getAllFamilies(); //AddAllFamilies(allFamilies); using (FamilyDbContext familyDbContext = new FamilyDbContext()) { var first = familyDbContext.Childs.First(child => child.FirstName.Equals("Maria")); Interest interest = familyDbContext.Interests.First(interst => interst.Type.Equals("Fodbold")); ChildInterest childInterest = new ChildInterest() { Child = first, Interest = interest }; familyDbContext.ChildInterests.Add(childInterest); familyDbContext.SaveChanges(); } CreateHostBuilder(args).Build().Run(); }
private List <Contact> CreateTestContactsWithDetails(FamilyDbContext context) { // Create test entities var category1 = new ContactCategory { CategoryName = "Friends", }; var contact1 = new Contact { ContactCategory = category1 }; // Persist entities context.Contacts.Add(contact1); context.SaveChanges(); // Create one-to-one related entity var data1 = new ContactData { Data = "Data 1", ContactId = contact1.Id, Contact = contact1 }; context.ContactDatas.Add(data1); context.SaveChanges(); // Detach entities var objContext = ((IObjectContextAdapter)context).ObjectContext; objContext.Detach(contact1); // Clear reference properties contact1.ContactCategory = null; contact1.ContactData = null; // Return entities return(new List <Contact> { contact1 }); }
public Token Authenticate(string login, string password) { // authentication by the Login and Password var now = CommonService.Now; Token result = null; // создаем новый контекст, дабы не использовать "уже загруженные" сущности using (var dbContext = new FamilyDbContext()) { UserToken userToken = null; // authentication for Managers if (userToken == null) { // находим пользователя по логину var manager = dbContext.Set <Manager>() .Include(t => t.Person.Avatar) .Include(t => t.Roles) //.Where(m => m.Person.State == Common.Enums.ObjectState.Active) .FirstOrDefault(m => m.Login.ToLower() == login.ToLower()); if (manager != null && CommonService.VerifyPassword(password, manager.Password)) { userToken = UserToken.Create(manager, null, now.AddHours(DefaultExpirationHours)); } } // authentication for Guests if (userToken == null) { var guest = dbContext.Set <Guest>() .FirstOrDefault(g => g.Date <= now && now <= g.Expire && g.Login.ToLower() == login.ToLower()); if (guest != null && CommonService.VerifyPassword(password, guest.Password)) { userToken = UserToken.Create(null, guest, guest.Expire); } } // saving new token if (userToken != null) { dbContext.Set <UserToken>().Add(userToken); dbContext.SaveChanges(); result = this.BuildToken(userToken); } } return(result); }
private static void AddAllFamilies(IList <Family> allFamilies) { using (FamilyDbContext familyDbContext = new FamilyDbContext()) { for (int i = 0; i < allFamilies.Count; i++) { familyDbContext.Families.Add(new Family() { HouseNumber = allFamilies[i].HouseNumber, StreetName = allFamilies[i].StreetName }); familyDbContext.SaveChanges(); } } }