public EECEmployee GetMobile(string empId)
{
var objReturn = new EECEmployee();
using (var cn = new SqlConnection(ConnectionHelper.HRDBConnection()))
{
cn.Open();
var cmd = cn.CreateCommand();
cmd.CommandText = "SELECT Mobile FROM dbo.Employee_Info_Extended WHERE Emp_ID=@emp_id";
cmd.Parameters.AddWithValue("@emp_id", empId);
var dr = cmd.ExecuteReader();
while (dr.Read())
{
objReturn = new EECEmployee
{
mobile = dr["Mobile"].ToString()
};
}
}
return(objReturn);
}
public ManagerCentre GetManagerCentreDetails(string id)
{
var objReturn = new ManagerCentre();
var listDirectReports = new List <DirectReports>();
var listSharesLineManager = new List <SharesLineManager>();
try
{
int.Parse(id);
var eecEmployee = new EECEmployee();
var employeeDetails = eecEmployee.GetEmployeeDetails(id).FirstOrDefault();
var managerDetails = eecEmployee.GetEmployeeDetails(employeeDetails.line_Manager_No).FirstOrDefault();
var directReports = eecEmployee.GetDirectReports(id);
var sharesLineManager = eecEmployee.GetSharesLineManager(employeeDetails.line_Manager_No);
foreach (var items in directReports)
{
listDirectReports.Add(new DirectReports
{
CostCenter = items.cost_Center,
Department = items.department,
EmployeeeID = items.emp_ID,
Grade = items.grade,
HireDate = items.hiring_Date,
Name = items.employee_Name_English,
NameArabic = items.employee_Name_Arabic,
Position = items.position,
PositionArabic = items.positionArabic,
UserPhoto = items.imageByte
});
}
foreach (var items in sharesLineManager)
{
listSharesLineManager.Add(new SharesLineManager
{
CostCenter = items.cost_Center,
Department = items.department,
EmployeeeID = items.emp_ID,
Grade = items.grade,
HireDate = items.hiring_Date,
Name = items.employee_Name_English,
NameArabic = items.employee_Name_Arabic,
Position = items.position,
PositionArabic = items.positionArabic,
UserPhoto = items.imageByte
});
}
objReturn = new ManagerCentre
{
Birthday = employeeDetails.birth_Date,
CostCenter = employeeDetails.cost_Center,
Department = employeeDetails.department,
Email = employeeDetails.e_Mail,
EmployeeeID = employeeDetails.emp_ID,
Gender = employeeDetails.gender,
Grade = employeeDetails.grade,
HireDate = employeeDetails.hiring_Date,
ManagerID = employeeDetails.line_Manager_No,
ManagerName = employeeDetails.line_Manager_Name,
ManagerPhoto = managerDetails.imageByte,
ManagerPosition = managerDetails.position,
Mobile = employeeDetails.mobile,
Name = employeeDetails.employee_Name_English,
NameArabic = employeeDetails.employee_Name_Arabic,
Nationality = employeeDetails.nationality,
Position = employeeDetails.position,
PositionArabic = employeeDetails.positionArabic,
UserPhoto = employeeDetails.imageByte,
DirectReports = listDirectReports,
NoOfDirectorReports = listDirectReports.Count,
SharesLineManager = listSharesLineManager,
};
}
catch
{
objReturn = null;
}
return(objReturn);
}