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 List<Employees> GetAllView(int LanguageID) { EmployeesDAC _employeesComponent = new EmployeesDAC(); IDataReader reader = _employeesComponent.GetAllEmployeesView("LanguageID = " + LanguageID).CreateDataReader(); List<Employees> _employeesList = new List<Employees>(); while (reader.Read()) { if (_employeesList == null) _employeesList = new List<Employees>(); Employees _employees = new Employees(); #region Employee Info if (reader["EmployeeId"] != DBNull.Value) _employees.EmployeeId = Convert.ToInt32(reader["EmployeeId"]); if (reader["EmployeeNumber"] != DBNull.Value) _employees.EmployeeNumber = Convert.ToString(reader["EmployeeNumber"]); if (reader["DepartmentId"] != DBNull.Value) _employees.DepartmentId = Convert.ToInt32(reader["DepartmentId"]); if (reader["DivisionId"] != DBNull.Value) _employees.DivisionId = Convert.ToInt32(reader["DivisionId"]); if (reader["FormalSiteUrl"] != DBNull.Value) _employees.FormalSiteUrl = Convert.ToString(reader["FormalSiteUrl"]); if (reader["NationalIdNumber"] != DBNull.Value) _employees.NationalIdNumber = Convert.ToString(reader["NationalIdNumber"]); if (reader["NationalIdType"] != DBNull.Value) _employees.NationalIdType = Convert.ToString(reader["NationalIdType"]); if (reader["ManagerId"] != DBNull.Value) _employees.ManagerId = Convert.ToInt32(reader["ManagerId"]); if (reader["BirthDate"] != DBNull.Value) _employees.BirthDate = Convert.ToDateTime(reader["BirthDate"]); if (reader["MaritalStatus"] != DBNull.Value) _employees.MaritalStatus = Convert.ToString(reader["MaritalStatus"]); if (reader["Gender"] != DBNull.Value) _employees.Gender = Convert.ToString(reader["Gender"]); if (reader["HireDate"] != DBNull.Value) _employees.HireDate = Convert.ToDateTime(reader["HireDate"]); if (reader["SalariedFlag"] != DBNull.Value) _employees.SalariedFlag = Convert.ToBoolean(reader["SalariedFlag"]); if (reader["VacationHours"] != DBNull.Value) _employees.VacationHours = Convert.ToInt16(reader["VacationHours"]); if (reader["SickLeaveHours"] != DBNull.Value) _employees.SickLeaveHours = Convert.ToInt16(reader["SickLeaveHours"]); if (reader["CurrentFlag"] != DBNull.Value) _employees.CurrentFlag = Convert.ToBoolean(reader["CurrentFlag"]); if (reader["EmployeeRowGuid"] != DBNull.Value) _employees.RowGuid = new Guid(reader["RowGuid"].ToString()); if (reader["EmployeeModifiedDate"] != DBNull.Value) _employees.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]); if (reader["Position"] != DBNull.Value) _employees.Position = Convert.ToString(reader["Position"]); _employees.NewRecord = false; #endregion #region Person Info BusinessLogicLayer.Entities.Persons.Person _person = new BusinessLogicLayer.Entities.Persons.Person(); #region Main Info if (reader["EmployeeId"] != DBNull.Value) _person.BusinessEntityId = Convert.ToInt32(reader["EmployeeId"]); if (reader["NameStyle"] != DBNull.Value) _person.NameStyle = Convert.ToBoolean(reader["NameStyle"]); if (reader["EmailPromotion"] != DBNull.Value) _person.EmailPromotion = Convert.ToInt32(reader["EmailPromotion"]); if (reader["RowGuid"] != DBNull.Value) _person.RowGuid = new Guid(reader["RowGuid"].ToString()); if (reader["ModifiedDate"] != DBNull.Value) _person.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]); if (reader["CreatedDate"] != DBNull.Value) _person.CreatedDate = Convert.ToDateTime(reader["CreatedDate"]); if (reader["NationalityCode"] != DBNull.Value) _person.NationalityCode = Convert.ToString(reader["NationalityCode"]); if (reader["Gender"] != DBNull.Value) _person.Gender = Convert.ToString(reader["Gender"]); if (reader["DateofBirth"] != DBNull.Value) _person.DateofBirth = Convert.ToDateTime(reader["DateofBirth"]); if (reader["PersonImage"] != DBNull.Value) _person.PersonImage = Convert.ToString(reader["PersonImage"]); #endregion #region Person Languages BusinessLogicLayer.Entities.Persons.PersonLanguages _personLanguages = new BusinessLogicLayer.Entities.Persons.PersonLanguages(); if (reader["PersonLanguageId"] != DBNull.Value) _personLanguages.PersonLanguageId = Convert.ToInt32(reader["PersonLanguageId"]); if (reader["EmployeeId"] != DBNull.Value) _personLanguages.PersonId = Convert.ToInt32(reader["EmployeeId"]); 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.Add(_personLanguages); #endregion #region Credentials BusinessLogicLayer.Entities.Persons.Credential _credential = new BusinessLogicLayer.Entities.Persons.Credential(); if (reader["EmployeeId"] != DBNull.Value) _credential.BusinessEntityId = Convert.ToInt32(reader["EmployeeId"]); if (reader["Username"] != DBNull.Value) _credential.Username = Convert.ToString(reader["Username"]); if (reader["IsActivated"] != DBNull.Value) _credential.IsActivated = Convert.ToBoolean(reader["IsActivated"]); if (reader["IsActive"] != DBNull.Value) _credential.IsActive = Convert.ToBoolean(reader["IsActive"]); _person.Credentials = _credential; #endregion _employees.EmployeePerson = _person; #endregion #region Departments Departments _departments = new Departments(); #region Department Info if (reader["DepartmentId"] != DBNull.Value) _departments.DepartmentId = Convert.ToInt32(reader["DepartmentId"]); if (reader["OrganizationId"] != DBNull.Value) _departments.OrganizationId = Convert.ToInt32(reader["OrganizationId"]); if (reader["DepartmentName"] != DBNull.Value) _departments.DepartmentName = Convert.ToString(reader["DepartmentName"]); if (reader["DepartmentDescription"] != DBNull.Value) _departments.DepartmentDescription = Convert.ToString(reader["DepartmentDescription"]); #endregion #region Organization Organizations _organizations = new Organizations(); if (reader["OrganizationId"] != DBNull.Value) _organizations.OrganizationId = Convert.ToInt32(reader["OrganizationId"]); if (reader["OrganizationName"] != DBNull.Value) _organizations.OrganizationName = Convert.ToString(reader["OrganizationName"]); if (reader["OrganizationDescription"] != DBNull.Value) _organizations.OrganizationDescription = Convert.ToString(reader["OrganizationDescription"]); _departments.Organization = _organizations; #endregion _employees.Department = _departments; #endregion #region Division Divisions _divisions = new Divisions(); if (reader["DivisionId"] != DBNull.Value) _divisions.DivisionId = Convert.ToInt32(reader["DivisionId"]); if (reader["DepartmentId"] != DBNull.Value) _divisions.DepartmentId = Convert.ToInt32(reader["DepartmentId"]); if (reader["DivisionName"] != DBNull.Value) _divisions.DivisionName = Convert.ToString(reader["DivisionName"]); if (reader["DivisionDescription"] != DBNull.Value) _divisions.DivisionDescription = Convert.ToString(reader["DivisionDescription"]); _employees.Division = _divisions; #endregion _employeesList.Add(_employees); } reader.Close(); return _employeesList; }