public ContactsAndMessages(string currentUserId, ContactsContext contactsDb, UserManager <ApplicationUser> identityDb) { MessagesContext messagesDb = new MessagesContext(); this.Contacts = new UserContacts(currentUserId, contactsDb, identityDb); this.Messages = new List <Message>(); }
public ContactsAndMessages(string currentUserId, ContactsContext contactsDb, UserManager <ApplicationUser> identityDb, string selectedContactUsername) { MessagesContext messagesDb = new MessagesContext(); this.Contacts = new UserContacts(currentUserId, contactsDb, identityDb); SelectedContact = identityDb.Users.Where(x => x.UserName == selectedContactUsername).FirstOrDefault(); this.Messages = messagesDb.Messages.Where(x => (x.FromUser == currentUserId && x.ToUser == SelectedContact.Id) || (x.FromUser == SelectedContact.Id && x.ToUser == currentUserId)).ToList(); }
// Crete new context. Also initializes the database if it doesn't exist. public static MessagesContext Create(string connectionString) { var optionsBuilder = new DbContextOptionsBuilder <MessagesContext>(); optionsBuilder.UseMySql(connectionString); var context = new MessagesContext(optionsBuilder.Options); // Usefull for database creation when it doesn't exist yet. context.Database.EnsureCreated(); return(context); }
public void AddMessage(MessagesContext db) { db.Messages.Add(this); db.SaveChanges(); }