public void Create(PassOneObject obj) { obj.Id = GetNextIdValue(); using (var db = new PassOneContext()) { db.Users.Add(new EntityUser((User)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 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); var userQuery = from u in db.Users select u; var user = userQuery.ToList().FirstOrDefault(user1 => user1.Id == creds.UserId); db.Credentials.Remove(creds); db.Credentials.Add(new EntityCredential(new Encryption(user.k, user.v), (Credentials) obj)); db.SaveChanges(); } }
public void Create(PassOneObject obj) { obj.Id = GetNextIdValue(); var creds = (Credentials) 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); var entity = new EntityCredential(new Encryption(user.k, user.v), creds) {User = user}; db.Credentials.Add(entity); db.SaveChanges(); } }