public static DataTable AdminGetArticles(Int32 VolumeIssueId) { try { return(ArticleQueryHelper.AdminGetArticles(VolumeIssueId)); } catch (SqlException sqlEx) { Console.WriteLine(sqlEx.ToString()); throw new DataException("An exception occured getting all articles.", sqlEx); } }
public static Article AdminGetArticle(Int32 ArticleId) { Article art = new Article(); try { DataSet articleSet = ArticleQueryHelper.AdminGetArticle(ArticleId); if (articleSet.Tables.Count == 2) { //Get the issue details if (articleSet.Tables[0].Rows.Count > 0) { DataRow artRow = articleSet.Tables[0].Rows[0]; art.ArticleId = (Int32)artRow["ArticleId"]; art.Title = (string)artRow["Title"]; art.Authors = (string)artRow["Authors"]; art.Keywords = (string)artRow["Keywords"]; art.PageNumber = (Int32)artRow["PageNumber"]; art.IsActive = (bool)artRow["Active"]; } //Get the documents if (articleSet.Tables[1].Rows.Count > 0) { ArticleDocument artDoc; art.Documents = new List <ArticleDocument>(); foreach (DataRow docRow in articleSet.Tables[1].Rows) { artDoc = new ArticleDocument(); artDoc.DocId = (Int32)docRow["DocId"]; artDoc.FullFileName = (string)docRow["FileName"]; artDoc.ArtDocTypeDescription = (string)docRow["ArtDocTypeDescription"]; artDoc.ArtDocTypeId = (Int32)docRow["ArtDocTypeId"]; artDoc.IsActive = (bool)docRow["Active"]; artDoc.IsNew = false; art.Documents.Add(artDoc); } } } return(art); } catch (SqlException sqlEx) { Console.WriteLine(sqlEx.ToString()); throw new DataException("An exception occured getting the article details.", sqlEx); } }