public Publication getPublication(string id)
{
Publication p = new Publication();
if (_client.Open())
{
var command = new SqlCommand
{
Connection = _client.connection,
CommandText = "getPub",
CommandType = CommandType.StoredProcedure
};
var par1 = new SqlParameter("@id", SqlDbType.NVarChar)
{
Direction = ParameterDirection.Input,
Value = id
};
command.Parameters.Add(par1);
command.ExecuteNonQuery();
var dataReader = command.ExecuteReader();
while (dataReader.Read())
{
p.getPub(dataReader["profile"].ToString(), dataReader["ID"].ToString(), dataReader["imgPath"].ToString(), dataReader["description"].ToString());
}
}
_client.Close();
return(p);
}
