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