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