protected void Page_Load(object sender, EventArgs e) { base.Page_Load(sender, e); if (!IsPostBack) { CurrentPerson = null; CurrentEmployee = null; int x = 0; Int32.TryParse(Request["Code"], out x); if (x != 0) { BusinessLogicLayer.Entities.HumanResources.Employees emp = new BusinessLogicLayer.Components.HumanResources.EmployeesLogic().GetByID(x); if (emp != null) { CurrentEmployee = emp; CurrentPerson = emp.EmployeePerson; LoadData(); } } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { descLength = 32; LoadData(); int idColumnist = 0; string code = Request["cl"]; if (string.IsNullOrEmpty(code)) { code = Page.RouteData.Values["cl"].ToString(); } Int32.TryParse(code, out idColumnist); BusinessLogicLayer.Entities.Persons.Person author = new BusinessLogicLayer.Entities.Persons.Person(); if (idColumnist != 0) { List<BusinessLogicLayer.Entities.ContentManagement.Article> articles = BusinessLogicLayer.Common.ArticleLogic.FindArticlesByAuthor(BusinessLogicLayer.Common.DefaultLanguageId, BusinessLogicLayer.Common.ManatiqID.ToString(), idColumnist.ToString()); var xlist = (from x in articles orderby x.PostDate descending select x).ToList(); int i = 0; author = BusinessLogicLayer.Common.PersonLogic.GetByID(idColumnist); foreach (BusinessLogicLayer.Entities.ContentManagement.Article a in xlist) { BusinessLogicLayer.Entities.ContentManagement.ContentModuleArticle cmArticles = new BusinessLogicLayer.Entities.ContentManagement.ContentModuleArticle(); cmArticles.ArticleID = a.ArticleId; cmArticles.CurrentArticle = a; cmArticles.ArticleOrder = i; cmArticles.HomePageID = HomePageID; Articles.Add(cmArticles); i++; } } else { int id = 0; code = Request["Code"]; if (string.IsNullOrEmpty(code)) { code = Page.RouteData.Values["Id"].ToString(); } Int32.TryParse(code, out id); if (id != 0) { BusinessLogicLayer.Entities.ContentManagement.Article article = BusinessLogicLayer.Common.ArticleLogic.GetByID(id); if (article != null) { author = BusinessLogicLayer.Common.PersonLogic.GetByID(article.AuthorId); List<BusinessLogicLayer.Entities.ContentManagement.Article> articles = BusinessLogicLayer.Common.ArticleLogic.FindArticlesByAuthor(BusinessLogicLayer.Common.DefaultLanguageId,BusinessLogicLayer.Common.ManatiqID.ToString(),article.AuthorId.ToString()); var xlist = (from x in articles orderby x.PostDate descending select x).ToList(); int i = 0; foreach (BusinessLogicLayer.Entities.ContentManagement.Article a in xlist) { BusinessLogicLayer.Entities.ContentManagement.ContentModuleArticle cmArticles = new BusinessLogicLayer.Entities.ContentManagement.ContentModuleArticle(); cmArticles.ArticleID = a.ArticleId; cmArticles.CurrentArticle = a; cmArticles.ArticleOrder = i; cmArticles.HomePageID = HomePageID; Articles.Add(cmArticles); i++; } } } } if (!author.NewRecord) { MainImage.Src = GetWriterImagePath(author.PersonImage); AuthorAlilas.InnerText = author.DisplayName; BusinessLogicLayer.Entities.HumanResources.Employees emp = new BusinessLogicLayer.Components.HumanResources.EmployeesLogic().GetByID(author.BusinessEntityId); if (emp != null) PositionLabel.InnerText = emp.Position; } ArticlesRepeater.DataSource = Articles; ArticlesRepeater.DataBind(); } }
private void SetData() { CurrentPerson = CurrentEmployee.EmployeePerson; CurrentEmployee.DepartmentId = Convert.ToInt32(employeeDepartment.Value); if (!string.IsNullOrEmpty(employeeBirthDate.Text)) { CurrentEmployee.BirthDate = employeeBirthDate.Date; CurrentPerson.DateofBirth = employeeBirthDate.Date; } if (!string.IsNullOrEmpty(employeeHireDate.Text)) CurrentEmployee.HireDate = employeeHireDate.Date; CurrentEmployee.EmployeeNumber = employeeNumber.Text; CurrentEmployee.Position = employeePosition.Text; CurrentEmployee.ModifiedDate = DateTime.Now; if (CurrentEmployee.NewRecord) CurrentEmployee.RowGuid = Guid.NewGuid(); string title = "", firstName = "", middleName = "", lastName = "", displayName = ""; displayName = miPersonName.Text; string[] nameSplit = miPersonName.Text.Trim().Split(' '); int nameCount = 0; int lastIndex = nameSplit.Length - 1; if (IsTitle(nameSplit[nameCount])) { title = nameSplit[nameCount]; lastIndex--; nameCount++; } if (nameCount <= lastIndex) { firstName = nameSplit[nameCount]; if (nameCount != lastIndex) lastName = nameSplit[lastIndex]; nameCount++; } middleName = ""; for (int i = nameCount; i < lastIndex; i++) { middleName += nameSplit[i] + " "; } middleName = middleName.Trim(); CurrentPerson.ModifiedDate = DateTime.Now; CurrentPerson.PersonImage = miPersonImage.ImagePath; CurrentPerson.Title = title; CurrentPerson.FirstName = firstName; CurrentPerson.DisplayName = displayName; CurrentPerson.LastName = lastName; CurrentPerson.MiddleName = middleName; CurrentPerson.Email = employeeEmail.Text; if (!string.IsNullOrEmpty(employeePassword.Text) && employeePassword.Text.Length > 5) { CurrentPerson.Credentials.PasswordSalt = Guid.NewGuid().ToString().Substring(0, 5); CurrentPerson.Credentials.PasswordHash = Tools.MD5(employeePassword.Text + CurrentPerson.Credentials.PasswordSalt); CurrentPerson.Credentials.IsActive = true; CurrentPerson.Credentials.IsActivated = true; if (CurrentPerson.Credentials.NewRecord) { CurrentPerson.Credentials.RowGuid = Guid.NewGuid(); } CurrentPerson.Credentials.ModifiedDate = DateTime.Now; CurrentPerson.Credentials.Username = employeeCredential.Text; } }
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; }