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(); } } }
public void SaveRequest(RequestDTO requestDTO) { var sender = _context.Usernames.FirstOrDefault(u => u.AccountID == requestDTO.SenderId); var recepient = _context.Usernames.FirstOrDefault(u => u.AccountID == requestDTO.RecepientId); var request = new Request { RecepientId = requestDTO.RecepientId, SenderId = requestDTO.SenderId, Status = "Pending" }; _context.Requests.Add(request); _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 Account CreateAccount(AccountDTO accountDTO) { // Verify the new account is unique var existingAcct = _context.Usernames.Where(a => a.Value == accountDTO.Username).FirstOrDefault(); if (existingAcct == null) { var account = new Account { Username = new Username { Value = accountDTO.Username }, Password = new Password { Value = accountDTO.Password }, Email = new Email { Value = accountDTO.Email }, FirstName = accountDTO.FirstName, LastName = accountDTO.LastName }; _context.Accounts.Add(account); _context.SaveChanges(); return(account); } else { throw new Exception("Username Already In Use"); } }
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(); } }