public void AddEmployeeBranchRight(EmployeeBranchRights employeeBranchRight)
{
employeeBranchRight.Branch = this;
_classSchedules.Add(employeeBranchRight);
}
public Employee GetEmployeeByIdAndPassword(string employeeId, string password)
{
Employee emp = null;
Department dpt = null;
JobPosition jpos = null;
EmployeeBranchRights ebr = null;
try
{
SqlParameter param1 = new SqlParameter("nEmployeeID", employeeId);
SqlParameter param2 = new SqlParameter("strPassword", password);
DataSet dsEmployee = SqlHelper.ExecuteDataset(SqlHelperUtils.connectionString, "sp_GetEmployeeByIdAndPassword", param1, param2);
if (dsEmployee.Tables[0].Rows.Count > 0)
{
emp = new Employee();
dpt = new Department();
jpos = new JobPosition();
foreach (DataRow dr in dsEmployee.Tables[0].Rows)
{
emp.Id = Convert.ToInt32(dr["nEmployeeID"].ToString());
dpt.Id = Convert.ToInt32(dr["nDepartmentId"].ToString());
emp.StrEmployeeName = dr["strEmployeeName"].ToString();
emp.MobileNo = dr["strContactNo"].ToString();
jpos.Id = dr["strJobPositionCode"].ToString();
emp.Department = dpt;
emp.JobPosition = jpos;
}
}
else
{
return(null);
}
if (dsEmployee.Tables[1].Rows.Count > 0)
{
foreach (DataRow dr in dsEmployee.Tables[1].Rows)
{
ebr = new EmployeeBranchRights();
Employee _emp = new Employee();
Branch _branch = new Branch();
_emp.Id = Convert.ToInt32(dr["nEmployeeID"].ToString());
_branch.Id = dr["strBranchCode"].ToString();
ebr.Employee = _emp;
ebr.Branch = _branch;
emp.EmployeeBranchRights.Add(ebr);
}
}
if (dsEmployee.Tables[2].Rows.Count > 0)
{
RightsLevel _rl = new RightsLevel();
foreach (DataRow dr in dsEmployee.Tables[2].Rows)
{
Right _r = new Right();
RightsLevelEntry _rle = new RightsLevelEntry();
_r.Id = Convert.ToInt32(dr["nRightsID"].ToString());
_r.StrDescription = dr["strDescription"].ToString();
_rl.Id = Convert.ToInt32(dr["nRightsLevelID"].ToString());
_rle.Right = _r;
_rle.RightsLevel = _rl;
_rl.RightsLevelEntrys.Add(_rle);
}
emp.RightsLevel = _rl;
}
return(emp);
}
catch (Exception ex)
{
UI.ShowErrorMessage(null, ex.Message, "Error");
return(null);
}
}
