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