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;
}
