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 Period GetCurrentPeriod()
//{
// try
// {
// Period period = new Period();
// DataSet dsPeriod = currentPeriodD.SelectAllCurrentPeriod();
// if (dsPeriod != null)
// {
// if (dsPeriod.Tables[0].Rows.Count > 0)
// {
// periodDbFacade = new PeriodDbFacade();
// period.Id = Convert.ToInt32(dsPeriod.Tables[0].Rows[0][currentPeriodD.FIELD_PERIOD_ID]);
// period = periodLogic.GetCurrentPeriod(period.Id);
// //period = periodDbFacade.LoadCurrentAppraisalDetail(period.Id);
// return period;
// }
// }
// return null;
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
public Period GetCurrentPeriod()
{
try
{
Period period = null;
DataSet dsPeriod = currentPeriodD.SelectAllCurrentPeriod();
if (dsPeriod != null)
{
if (dsPeriod.Tables[0].Rows.Count > 0)
{
period = new Period();
periodDbFacade = new PeriodDbFacade();
period.Id = Convert.ToInt32(dsPeriod.Tables[0].Rows[0][currentPeriodD.FIELD_PERIOD_ID]);
period = periodLogic.GetCurrentPeriod(period.Id);
}
}
return(period);
}
catch (Exception)
{
throw;
}
}