public PassOneObject RetreiveById(int id)
{
var context = new PassOneContext();
var query = from u in context.Users select u;
var users = query.ToList();
return users.Where(user => user.Id == id).Select(ConvertToDomainObject).FirstOrDefault();
}
public int GetNextIdValue()
{
var context = new PassOneContext();
var query = from u in context.Users select u;
var users = query.ToList();
return users.Select(user => user.Id).Concat(new[] {0}).Max() + 1;
}
public void Create(PassOneObject obj)
{
obj.Id = GetNextIdValue();
using (var db = new PassOneContext())
{
db.Users.Add(ConvertToEntity(obj));
db.SaveChanges();
}
}
public void Delete(PassOneObject obj)
{
using (var db = new PassOneContext())
{
var userQuery = from u in db.Users select u;
var user = userQuery.ToList().FirstOrDefault(user1 => user1.Id == obj.Id);
db.Users.Remove(user);
db.SaveChanges();
}
}
public void Delete(PassOneObject obj)
{
using (var db = new PassOneContext())
{
var query = from c in db.Credentials select c;
var creds = query.ToList().FirstOrDefault(creds1 => creds1.Id == obj.Id);
db.Credentials.Remove(creds);
db.SaveChanges();
}
}
public Dictionary<string, int> GetCredentialsList(PassOneUser passOneUser)
{
Dictionary<string, int> list;
using (var db = new PassOneContext())
{
db.Database.Connection.Open();
var query = from c in db.Credentials select c;
list = query.ToList().Where(credential => credential.UserId == passOneUser.Id).ToDictionary(credential => credential.Title, credential => credential.Id);
}
return list;
}
public void Edit(PassOneObject obj)
{
using (var db = new PassOneContext())
{
var userQuery = from u in db.Users select u;
var user = userQuery.ToList().FirstOrDefault(user1 => user1.Id == obj.Id);
userQuery.ToList().Remove(user);
userQuery.ToList().Add((ConvertToEntity(obj)));
db.SaveChanges();
}
}
public void Edit(PassOneObject obj)
{
using (var db = new PassOneContext())
{
var credsQuery = from u in db.Credentials select u;
var creds = credsQuery.ToList().FirstOrDefault(user1 => user1.Id == obj.Id);
db.Credentials.Remove(creds);
db.Credentials.Add((ConvertToEntity(obj)));
db.SaveChanges();
}
}
public PassOneUser Authenticate(string username, string password)
{
User user;
using (var db = new PassOneContext())
{
db.Database.Connection.Open();
var query = from u in db.Users select u;
user = query.ToList().FirstOrDefault(user1 => user1.Username == username && user1.Password == password);
}
if (user != null)
return new PassOneUser(user.Id, user.FirstName, user.LastName, user.Username, user.Password, user.k,
user.v);
return null;
}
public void Create(PassOneObject obj)
{
obj.Id = GetNextIdValue();
var creds = (PassOneCredentials) obj;
using (var db = new PassOneContext())
{
var userQuery = from u in db.Users select u;
var user = userQuery.ToList().FirstOrDefault(user1 => user1.Id == creds.UserId);
creds.Encrypt(new Encryption(user.k, user.v));
var entity = ConvertToEntity(creds);
entity.User = user;
db.Credentials.Add(entity);
db.SaveChanges();
}
}
public Dictionary<string, int> GetCredentialsList(int userId)
{
var list = new Dictionary<string, int>();
using (var db = new PassOneContext())
{
var query = from c in db.Credentials select c;
foreach (var credential in query.ToList())
{
if (credential.UserId == userId)
{
var decrypted = ConvertToDomainObject(credential);
decrypted.Decrypt(new Encryption(credential.User.k, credential.User.v));
list.Add(decrypted.Website, credential.Id);
}
}
}
return list;
}
