public Staff GetStaffByLoginName(string loginName)
{
Staff staff = new Staff();
currentPeriodDb = new CurrentPeriodDb();
int periodId = 0;
DataSet dsCurrentPeriod = currentPeriodDb.SelectAllCurrentPeriod();
if (dsCurrentPeriod != null)
{
periodId = Convert.ToInt32(dsCurrentPeriod.Tables[0].Rows[0][currentPeriodDb.FIELD_PERIOD_ID]);
}
if (periodId <= 0)
{
throw new Exception("No current period exist in the system! Please contact your system administrator.");
}
DataSet dsStaff = staffDb.SelectStaffByLoginName(loginName, periodId);
if (dsStaff != null)
{
if (dsStaff.Tables[0].Rows.Count > 0)
{
staff.Id = Convert.ToString(dsStaff.Tables[0].Rows[0][staffDb.FIELD_STAFF_ID]);
staff.Name = Convert.ToString(dsStaff.Tables[0].Rows[0]["Name"]);
staff.LoginName = Convert.ToString(dsStaff.Tables[0].Rows[0][staffDb.FIELD_LOGIN_NAME]);
staff.Email = Convert.ToString(dsStaff.Tables[0].Rows[0][staffDb.FIELD_EMAIL]);
staff.Company.Name = Convert.ToString(dsStaff.Tables[0].Rows[0]["Company_Name"]);
staff.Department.Name = Convert.ToString(dsStaff.Tables[0].Rows[0]["Department_Name"]);
staff.JobRole.Id = Convert.ToInt32(dsStaff.Tables[0].Rows[0]["Job_Role_ID"]);
staff.JobRole.Name = Convert.ToString(dsStaff.Tables[0].Rows[0]["Job_Role_Name"]);
staff.Level.Name = Convert.ToString(dsStaff.Tables[0].Rows[0]["Job_Role_Level_Name"]);
staff.Level.Id = Convert.ToString(dsStaff.Tables[0].Rows[0]["Job_Role_Level_ID"]);
staff.CompanyDepartmentJobRoleId = Convert.ToInt32(dsStaff.Tables[0].Rows[0][staffDb.FIELD_COMPANY_DEPARTMENT_JOB_ROLE_ID]);
staff.Location.Name = Convert.ToString(dsStaff.Tables[0].Rows[0][staffDb.FIELD_LOCATION_NAME]);
staff.MetricsCount = metricDbFacade.CountMetrics(staff.CompanyDepartmentJobRoleId, periodId);
staff.IsActive = Convert.ToBoolean(dsStaff.Tables[0].Rows[0]["Is_Active"]);
staff.Role = new Role();
staff.Role.Id = Convert.ToInt32(dsStaff.Tables[0].Rows[0]["Role_Id"]);
RoleLogic roleLogic = new RoleLogic();
staff.Role = roleLogic.Get(staff);
staff.FormatNameToPascalCasing();
return(staff);
}
}
return(null);
}
public CurrentPeriodDbFacade()
{
currentPeriodD = new CurrentPeriodDb();
periodLogic = new PeriodLogic();
}
