public void Delete(Credential credential) { using (var connection = this.databaseService.GetOpenConnection()) { connection.Execute("DELETE FROM credential WHERE id = @id ", credential); } }
public Credential Index(int id) { var credential = new Credential(); using (var connection = this.databaseService.GetOpenConnection()) { credential = connection.Query<Credential>("SELECT * FROM credential WHERE id = @id AND userid = @userid", new { id = id, userid = this.User }).FirstOrDefault(); } return credential; }
public Credential Post(Credential credential) { var user = this.User; using (var connection = this.databaseService.GetOpenConnection()) { connection.Execute("INSERT INTO credential (Name, Login, Password, GroupName, IsFavorite) VALUES (@Name, @Login,@Password, @GroupName, @IsFavorite)", credential); } return credential; }
public Credential Put(Credential credential) { using (var connection = this.databaseService.GetOpenConnection()) { credential = connection.Query<Credential>( @"UPDATE credential SET Name = @Name, Login = @Login, Password = @Password, GroupName = @GroupName, IsFavorite = @IsFavorite WHERE Id = @id AND userid = @userid", new { credential, userid = this.User }).FirstOrDefault(); } return credential; }
public void Options(Credential credential) { return; }