public void Initialize()
{
using var db = new SoPContext();
//Remove users
var userList = db.Users.ToList();
db.Users.RemoveRange(userList);
db.SaveChanges();
//Add Admin User
var adminUser = User.CreateNew("admin", "admin");
db.Users.Add(adminUser);
db.SaveChanges();
}
public void AddUser()
{
var user = User.CreateNew("testuser", "password");
using var db = new SoPContext();
db.Users.Add(user);
db.SaveChanges();
}
public void Delete(int passwordEntryId)
{
using var context = new SoPContext();
var pass = context.PasswordEntries.FirstOrDefault(pass => pass.Id == passwordEntryId);
if (pass != null)
{
context.PasswordEntries.Remove(pass);
context.SaveChanges();
}
}
public void Delete(int categoryId)
{
using var context = new SoPContext();
var cat = context.Categories.FirstOrDefault(cat => cat.Id == categoryId);
if (cat != null)
{
context.Categories.Remove(cat);
context.SaveChanges();
}
}
public bool Create(User user)
{
try
{
using var dbContext = new SoPContext();
dbContext.Users.Add(user);
dbContext.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public bool Create(Category category)
{
try
{
using var context = new SoPContext();
context.Categories.Add(category);
context.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public void AddData()
{
using var db = new SoPContext();
var dbUser = db.Users.FirstOrDefault(u => u.Username == "admin");
var id = 0;
if (dbUser != null)
{
id = dbUser.Id;
}
else
{
var user = User.CreateNew("admin", "admin");
id = db.Users.Add(user).Entity.Id;
}
var password1 = new PasswordEntry()
{
Description = "Password 1 for category 1",
Password = "******",
Title = "Password 1"
};
var password2 = new PasswordEntry()
{
Description = "Password 2 for category 1",
Password = "******",
Title = "Password 2"
};
var password3 = new PasswordEntry()
{
Description = "Password 3 for category 2",
Password = "******",
Title = "Password 3"
};
var cat1 = Category.CreateNew("TestCategory 1", "Category for testing 1", id);
cat1.Passwords.Add(password1);
cat1.Passwords.Add(password2);
var cat2 = Category.CreateNew("TestCategory 2", "Category for testing 2", id);
cat2.Passwords.Add(password3);
db.Categories.Add(cat1);
db.Categories.Add(cat2);
db.SaveChanges();
}
public void Save(PasswordEntry passwordEntry)
{
using var context = new SoPContext();
context.Update(passwordEntry);
context.SaveChanges();
}
public void Save(Category category)
{
using var context = new SoPContext();
context.Update(category);
context.SaveChanges();
}