public void RespondToRequest(long requestID, string status) { var request = _context.Requests.FirstOrDefault(r => r.RequestId == requestID); request.Status = status; _context.Requests.Update(request); var SenderAccount = _context.Accounts.Include(a => a.Circle).FirstOrDefault(s => request.SenderId == s.AccountId); var RecipientAccount = _context.Accounts.Include(a => a.Circle).FirstOrDefault(rec => request.RecepientId == rec.AccountId); if (request.Status == "Accepted") { var SenderCircleMember = new CircleMember { CircleId = RecipientAccount.Circle.CircleId, AccountId = SenderAccount.AccountId }; var RecipientCircleMember = new CircleMember { CircleId = SenderAccount.Circle.CircleId, AccountId = RecipientAccount.AccountId }; _context.Add(SenderCircleMember); _context.Add(RecipientCircleMember); } _context.SaveChanges(); }
private void Seed() { using (var context = new InnerCircleDataContext(ContextOptions)) { context.Database.EnsureDeleted(); context.Database.EnsureCreated(); // Create 3 accounts for (int i = 0; i < 3; i++) { var account1 = new Account { Email = new Email { Value = $"Account{i}@email.com", }, Username = new Username { Value = $"Account{i}Username" }, Password = new Password { Value = "Password" } }; context.Add(account1); } context.SaveChanges(); // Make accounts 1 and 2 members of circle var CircleMember = new CircleMember() { CircleId = 1, AccountId = 2 }; var CircleMember2 = new CircleMember() { CircleId = 2, AccountId = 2 }; context.Add(CircleMember2); context.Add(CircleMember); context.SaveChanges(); for (int i = 0; i < 3; i++) { var post = new Post() { AccountId = 3, Description = $"Post number {i} ", MediaUrl = $"url{i}", Username = $"Account3Username" }; context.Add(post); context.SaveChanges(); } } }
private void Seed() { using (var context = new InnerCircleDataContext(ContextOptions)) { context.Database.EnsureDeleted(); context.Database.EnsureCreated(); for (int i = 0; i < 5; i++) { var account1 = new Account { Email = new Email { Value = $"Account{i}@email.com", }, Username = new Username { Value = $"Account{i}Username" }, Password = new Password { Value = "Password" } }; context.Add(account1); context.SaveChanges(); } } }
public Message CreateMessage(MessageDTO message) { //set variables var m = new Message { RecepientId = message.RecepientId, SenderId = message.SenderId, message = message.Message, time = DateTime.Now }; //Add to data Base _context.Add(m); //Save the Message _context.SaveChanges(); return(m); }
public Post CreatePost(Post post, long AccountId) { // Set the value post.AccountId = AccountId; post.Username = _context.Usernames.FirstOrDefault(u => u.AccountID == AccountId).Value; // Add the new post _context.Add(post); // Save changes _context.SaveChanges(); return(post); }
private void CreateAccounts(int count, InnerCircleDataContext context) { for (int i = 0; i < 5; i++) { var account1 = new Account { Email = new Email { Value = $"Account{i}@email.com", }, Username = new Username { Value = $"Account{i}Username" }, Password = new Password { Value = "Password" } }; context.Add(account1); context.SaveChanges(); } }