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();
}
}