public ArticleLanguage GetArticlePageLanguageByLanguageId(int id)
{
ArticleLanguage lang = new ArticleLanguage();
if (CurrentArticleLanguage == null)
{
CurrentArticleLanguage = new List <ArticleLanguage>();
}
var availableArticleLanguages = from x in _CurrentArticleLanguage where x.LanguageId == id select x;
foreach (ArticleLanguage l in availableArticleLanguages)
{
lang = l;
}
return(lang);
}
public List<ArticleLanguage> GetAll()
{
ArticleLanguageDAC _articleLanguageComponent = new ArticleLanguageDAC();
IDataReader reader = _articleLanguageComponent.GetAllArticleLanguage().CreateDataReader();
List<ArticleLanguage> _articleLanguageList = new List<ArticleLanguage>();
while(reader.Read())
{
if(_articleLanguageList == null)
_articleLanguageList = new List<ArticleLanguage>();
ArticleLanguage _articleLanguage = new ArticleLanguage();
if(reader["ArticleLanguageId"] != DBNull.Value)
_articleLanguage.ArticleLanguageId = Convert.ToInt32(reader["ArticleLanguageId"]);
if(reader["ArticleId"] != DBNull.Value)
_articleLanguage.ArticleId = Convert.ToInt32(reader["ArticleId"]);
if(reader["LanguageId"] != DBNull.Value)
_articleLanguage.LanguageId = Convert.ToInt32(reader["LanguageId"]);
if(reader["ArticleName"] != DBNull.Value)
_articleLanguage.ArticleName = Convert.ToString(reader["ArticleName"]);
if(reader["ArticleContent"] != DBNull.Value)
_articleLanguage.ArticleContent = Convert.ToString(reader["ArticleContent"]);
if(reader["ArticleAttachment"] != DBNull.Value)
_articleLanguage.ArticleAttachment = Convert.ToString(reader["ArticleAttachment"]);
if(reader["AuthorAlias"] != DBNull.Value)
_articleLanguage.AuthorAlias = Convert.ToString(reader["AuthorAlias"]);
if(reader["ArticleAlias"] != DBNull.Value)
_articleLanguage.ArticleAlias = Convert.ToString(reader["ArticleAlias"]);
if(reader["PostDate"] != DBNull.Value)
_articleLanguage.PostDate = Convert.ToDateTime(reader["PostDate"]);
if(reader["PublishStartDate"] != DBNull.Value)
_articleLanguage.PublishStartDate = Convert.ToDateTime(reader["PublishStartDate"]);
if(reader["PublishEndDate"] != DBNull.Value)
_articleLanguage.PublishEndDate = Convert.ToDateTime(reader["PublishEndDate"]);
if(reader["RevisionDate"] != DBNull.Value)
_articleLanguage.RevisionDate = Convert.ToDateTime(reader["RevisionDate"]);
if(reader["ModifiedDate"] != DBNull.Value)
_articleLanguage.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]);
if (reader["ArticleSummary"] != DBNull.Value)
_articleLanguage.ArticleSummary = Convert.ToString(reader["ArticleSummary"]);
if (reader["ArticleSubTitle"] != DBNull.Value)
_articleLanguage.ArticleSubTitle = Convert.ToString(reader["ArticleSubTitle"]);
if (reader["ArticleShortTitle"] != DBNull.Value)
_articleLanguage.ArticleShortTitle = Convert.ToString(reader["ArticleShortTitle"]);
_articleLanguage.NewRecord = false;
_articleLanguageList.Add(_articleLanguage);
} reader.Close();
return _articleLanguageList;
}
public List<Article> GetAllArticles(string LanguageID)
{
ArticleDAC _articleComponent = new ArticleDAC();
string whereCondition = "";
IDataReader reader = _articleComponent.ViewAllArticles("LanguageID = " + LanguageID).CreateDataReader();
List<Article> _articleList = new List<Article>();
while (reader.Read())
{
if (_articleList == null)
_articleList = new List<Article>();
Article _article = new Article();
#region Article Information
if (reader["ArticleId"] != DBNull.Value)
_article.ArticleId = Convert.ToInt32(reader["ArticleId"]);
if (reader["SiteSectionId"] != DBNull.Value)
_article.SiteSectionId = Convert.ToInt32(reader["SiteSectionId"]);
if (reader["CreatorId"] != DBNull.Value)
_article.CreatorId = Convert.ToInt32(reader["CreatorId"]);
if (reader["ArticleStatusId"] != DBNull.Value)
_article.ArticleStatusId = Convert.ToInt32(reader["ArticleStatusId"]);
if (reader["AuthorId"] != DBNull.Value)
_article.AuthorId = Convert.ToInt32(reader["AuthorId"]);
if (reader["PostDate"] != DBNull.Value)
_article.PostDate = Convert.ToDateTime(reader["PostDate"]);
if (reader["AllowLanguageSpecificTags"] != DBNull.Value)
_article.AllowLanguageSpecificTags = Convert.ToBoolean(reader["AllowLanguageSpecificTags"]);
if (reader["RowGuid"] != DBNull.Value)
_article.RowGuid = new Guid(reader["RowGuid"].ToString());
if (reader["ModifiedDate"] != DBNull.Value)
_article.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]);
if (reader["CommentsTypeId"] != DBNull.Value)
_article.CommentsTypeId = Convert.ToInt32(reader["CommentsTypeId"]);
if (reader["EnableModeteration"] != DBNull.Value)
_article.EnableModeteration = Convert.ToBoolean(reader["EnableModeteration"]);
if (reader["SiteId"] != DBNull.Value)
_article.SiteId = Convert.ToInt32(reader["SiteId"]);
if (reader["ArticleTypeID"] != DBNull.Value)
_article.ArticleTypeID = Convert.ToInt32(reader["ArticleTypeID"]);
if (reader["ViewsCount"] != DBNull.Value)
_article.ViewsCount = Convert.ToInt32(reader["ViewsCount"]);
if (reader["CommentsCount"] != DBNull.Value)
_article.CommentsCount = Convert.ToInt32(reader["CommentsCount"]);
if (reader["CreatorName"] != DBNull.Value)
_article.CreatorName = Convert.ToString(reader["CreatorName"].ToString());
_article.NewRecord = false;
#endregion
#region Article Languages
List<ArticleLanguage> _articleLanguageList = new List<ArticleLanguage>();
ArticleLanguage _articleLanguage = new ArticleLanguage();
if (reader["ArticleLanguageId"] != DBNull.Value)
_articleLanguage.ArticleLanguageId = Convert.ToInt32(reader["ArticleLanguageId"]);
if (reader["ArticleId"] != DBNull.Value)
_articleLanguage.ArticleId = Convert.ToInt32(reader["ArticleId"]);
if (reader["LanguageId"] != DBNull.Value)
_articleLanguage.LanguageId = Convert.ToInt32(reader["LanguageId"]);
if (reader["ArticleName"] != DBNull.Value)
_articleLanguage.ArticleName = Convert.ToString(reader["ArticleName"]);
if (reader["ArticleContent"] != DBNull.Value)
_articleLanguage.ArticleContent = Convert.ToString(reader["ArticleContent"]);
if (reader["ArticleAttachment"] != DBNull.Value)
_articleLanguage.ArticleAttachment = Convert.ToString(reader["ArticleAttachment"]);
if (reader["AuthorAlias"] != DBNull.Value)
_articleLanguage.AuthorAlias = Convert.ToString(reader["AuthorAlias"]);
if (reader["ArticleAlias"] != DBNull.Value)
_articleLanguage.ArticleAlias = Convert.ToString(reader["ArticleAlias"]);
if (reader["LanguagePostDate"] != DBNull.Value)
_articleLanguage.PostDate = Convert.ToDateTime(reader["LanguagePostDate"]);
if (reader["PublishStartDate"] != DBNull.Value)
_articleLanguage.PublishStartDate = Convert.ToDateTime(reader["PublishStartDate"]);
if (reader["PublishEndDate"] != DBNull.Value)
_articleLanguage.PublishEndDate = Convert.ToDateTime(reader["PublishEndDate"]);
if (reader["RevisionDate"] != DBNull.Value)
_articleLanguage.RevisionDate = Convert.ToDateTime(reader["RevisionDate"]);
if (reader["ModifiedDate"] != DBNull.Value)
_articleLanguage.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]);
if (reader["ArticleSummary"] != DBNull.Value)
_articleLanguage.ArticleSummary = Convert.ToString(reader["ArticleSummary"]);
if (reader["ArticleSubTitle"] != DBNull.Value)
_articleLanguage.ArticleSubTitle = Convert.ToString(reader["ArticleSubTitle"]);
if (reader["ArticleShortTitle"] != DBNull.Value)
_articleLanguage.ArticleShortTitle = Convert.ToString(reader["ArticleShortTitle"]);
_articleLanguage.NewRecord = false;
_articleLanguageList.Add(_articleLanguage);
#endregion
#region Article Section
SiteSection _siteSection = new SiteSection();
if (reader["SiteSectionId"] != DBNull.Value)
_siteSection.SiteSectionId = Convert.ToInt32(reader["SiteSectionId"]);
if (reader["SiteSectionName"] != DBNull.Value)
_siteSection.Name = Convert.ToString(reader["SiteSectionName"]);
if (reader["SiteSectionParentId"] != DBNull.Value)
_siteSection.SiteSectionParentId = Convert.ToInt32(reader["SiteSectionParentId"]);
if (reader["SectionStatusId"] != DBNull.Value)
_siteSection.SectionStatusId = Convert.ToInt32(reader["SectionStatusId"]);
if (reader["SiteId"] != DBNull.Value)
_siteSection.SiteId = Convert.ToInt32(reader["SiteId"]);
if (reader["PersonId"] != DBNull.Value)
_siteSection.PersonId = Convert.ToInt32(reader["PersonId"]);
if (reader["SecurityAccessTypeId"] != DBNull.Value)
_siteSection.SecurityAccessTypeId = Convert.ToInt32(reader["SecurityAccessTypeId"]);
_siteSection.NewRecord = false;
_article.CurrentSection = _siteSection;
#endregion
#region Article Type
ArticleType _articleType = new ArticleType();
if (reader["ArticleTypeID"] != DBNull.Value)
_articleType.ArticleTypeID = Convert.ToInt32(reader["ArticleTypeID"]);
if (reader["ArticleTypeName"] != DBNull.Value)
_articleType.Name = Convert.ToString(reader["ArticleTypeName"]);
if (reader["ArticleTypeCode"] != DBNull.Value)
_articleType.Code = Convert.ToString(reader["ArticleTypeCode"]);
#endregion
#region Author Information
BusinessLogicLayer.Entities.Persons.Person _person = new Entities.Persons.Person();
if (reader["AuthorId"] != DBNull.Value)
_person.BusinessEntityId = Convert.ToInt32(reader["AuthorId"]);
if (reader["NameStyle"] != DBNull.Value)
_person.NameStyle = Convert.ToBoolean(reader["NameStyle"]);
if (reader["PersonImage"] != DBNull.Value)
_person.PersonImage = Convert.ToString(reader["PersonImage"]);
BusinessLogicLayer.Entities.Persons.PersonLanguages _personLanguages = new BusinessLogicLayer.Entities.Persons.PersonLanguages();
if (reader["PersonLanguageId"] != DBNull.Value)
_personLanguages.PersonLanguageId = Convert.ToInt32(reader["PersonLanguageId"]);
if (reader["AuthorId"] != DBNull.Value)
_personLanguages.PersonId = Convert.ToInt32(reader["AuthorId"]);
if (reader["LanguageId"] != DBNull.Value)
_personLanguages.LanguageId = Convert.ToInt32(reader["LanguageId"]);
if (reader["Title"] != DBNull.Value)
_personLanguages.Title = Convert.ToString(reader["Title"]);
if (reader["FirstName"] != DBNull.Value)
_personLanguages.FirstName = Convert.ToString(reader["FirstName"]);
if (reader["MiddleName"] != DBNull.Value)
_personLanguages.MiddleName = Convert.ToString(reader["MiddleName"]);
if (reader["LastName"] != DBNull.Value)
_personLanguages.LastName = Convert.ToString(reader["LastName"]);
if (reader["Suffix"] != DBNull.Value)
_personLanguages.Suffix = Convert.ToString(reader["Suffix"]);
if (reader["DisplayName"] != DBNull.Value)
_personLanguages.DisplayName = Convert.ToString(reader["DisplayName"]);
_person.PersonLanguages = new List<Entities.Persons.PersonLanguages>();
_person.PersonLanguages.Add(_personLanguages);
_article.Author = _person;
#endregion
_article.CurrentArticleLanguage = _articleLanguageList;
_articleList.Add(_article);
} reader.Close();
return _articleList;
}
public bool Update(ArticleLanguage articlelanguage ,int old_articleLanguageId)
{
ArticleLanguageDAC articlelanguageComponent = new ArticleLanguageDAC();
return articlelanguageComponent.UpdateArticleLanguage(articlelanguage.ArticleId, articlelanguage.LanguageId, articlelanguage.ArticleName, articlelanguage.ArticleContent, articlelanguage.ArticleAttachment, articlelanguage.AuthorAlias, articlelanguage.ArticleAlias, articlelanguage.PostDate, articlelanguage.PublishStartDate, articlelanguage.PublishEndDate, articlelanguage.RevisionDate, articlelanguage.ModifiedDate, articlelanguage.ArticleSummary, articlelanguage.ArticleSubTitle, articlelanguage.ArticleShortTitle, old_articleLanguageId);
}
public bool Insert(ArticleLanguage articlelanguage)
{
int autonumber = 0;
ArticleLanguageDAC articlelanguageComponent = new ArticleLanguageDAC();
bool endedSuccessfuly = articlelanguageComponent.InsertNewArticleLanguage( ref autonumber, articlelanguage.ArticleId, articlelanguage.LanguageId, articlelanguage.ArticleName, articlelanguage.ArticleContent, articlelanguage.ArticleAttachment, articlelanguage.AuthorAlias, articlelanguage.ArticleAlias, articlelanguage.PostDate, articlelanguage.PublishStartDate, articlelanguage.PublishEndDate, articlelanguage.RevisionDate, articlelanguage.ModifiedDate,articlelanguage.ArticleSummary,articlelanguage.ArticleSubTitle,articlelanguage.ArticleShortTitle);
if(endedSuccessfuly)
{
articlelanguage.ArticleLanguageId = autonumber;
}
return endedSuccessfuly;
}
public ArticleLanguage GetByID(int _articleLanguageId)
{
ArticleLanguageDAC _articleLanguageComponent = new ArticleLanguageDAC();
IDataReader reader = _articleLanguageComponent.GetByIDArticleLanguage(_articleLanguageId);
ArticleLanguage _articleLanguage = null;
while(reader.Read())
{
_articleLanguage = new ArticleLanguage();
if(reader["ArticleLanguageId"] != DBNull.Value)
_articleLanguage.ArticleLanguageId = Convert.ToInt32(reader["ArticleLanguageId"]);
if(reader["ArticleId"] != DBNull.Value)
_articleLanguage.ArticleId = Convert.ToInt32(reader["ArticleId"]);
if(reader["LanguageId"] != DBNull.Value)
_articleLanguage.LanguageId = Convert.ToInt32(reader["LanguageId"]);
if(reader["ArticleName"] != DBNull.Value)
_articleLanguage.ArticleName = Convert.ToString(reader["ArticleName"]);
if(reader["ArticleContent"] != DBNull.Value)
_articleLanguage.ArticleContent = Convert.ToString(reader["ArticleContent"]);
if(reader["ArticleAttachment"] != DBNull.Value)
_articleLanguage.ArticleAttachment = Convert.ToString(reader["ArticleAttachment"]);
if(reader["AuthorAlias"] != DBNull.Value)
_articleLanguage.AuthorAlias = Convert.ToString(reader["AuthorAlias"]);
if(reader["ArticleAlias"] != DBNull.Value)
_articleLanguage.ArticleAlias = Convert.ToString(reader["ArticleAlias"]);
if(reader["PostDate"] != DBNull.Value)
_articleLanguage.PostDate = Convert.ToDateTime(reader["PostDate"]);
if(reader["PublishStartDate"] != DBNull.Value)
_articleLanguage.PublishStartDate = Convert.ToDateTime(reader["PublishStartDate"]);
if(reader["PublishEndDate"] != DBNull.Value)
_articleLanguage.PublishEndDate = Convert.ToDateTime(reader["PublishEndDate"]);
if(reader["RevisionDate"] != DBNull.Value)
_articleLanguage.RevisionDate = Convert.ToDateTime(reader["RevisionDate"]);
if(reader["ModifiedDate"] != DBNull.Value)
_articleLanguage.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]);
if (reader["ArticleSummary"] != DBNull.Value)
_articleLanguage.ArticleSummary = Convert.ToString(reader["ArticleSummary"]);
if (reader["ArticleSubTitle"] != DBNull.Value)
_articleLanguage.ArticleSubTitle = Convert.ToString(reader["ArticleSubTitle"]);
if (reader["ArticleShortTitle"] != DBNull.Value)
_articleLanguage.ArticleShortTitle = Convert.ToString(reader["ArticleShortTitle"]);
_articleLanguage.NewRecord = false; } reader.Close();
return _articleLanguage;
}
public ArticleLanguage GetArticlePageLanguageByLanguageId(int id)
{
ArticleLanguage lang = new ArticleLanguage();
if (CurrentArticleLanguage == null)
CurrentArticleLanguage = new List<ArticleLanguage>();
var availableArticleLanguages = from x in _CurrentArticleLanguage where x.LanguageId == id select x;
foreach (ArticleLanguage l in availableArticleLanguages)
{
lang = l;
}
return lang;
}