public int CheckUser()
{
var result = SprocHelper.ExecDANGNHAP(session, username, password);
var temp = int.Parse(result.ResultSet[0].Rows[0].Values[0].ToString());
if (temp == 1)
{
IdNV = int.Parse(result.ResultSet[0].Rows[0].Values[1].ToString());
}
return(temp);
}
public int CreateEmployeeClassification(GetEmployeeClassificationsResult employeeClassification)
{
if (employeeClassification == null)
{
throw new ArgumentNullException(nameof(employeeClassification),
$"{nameof(employeeClassification)} is null.");
}
using (var uow = new UnitOfWork())
{
var temp = SprocHelper.ExecHR_CreateEmployeeClassificationIntoObjects(
uow,
employeeClassification.EmployeeClassificationName,
employeeClassification.IsExempt,
employeeClassification.IsEmployee
);
return(temp.Single().EmployeeClassificationKey);
}
}
public NHANVIEN_DTO getNhanVienById(int IdNV)
{
NHANVIEN_DTO dto = new NHANVIEN_DTO();
var result = SprocHelper.ExecNHANVIEN_ById(session, IdNV);
var values = result.ResultSet[0].Rows[0].Values;
try
{
dto.IdNV = int.Parse(values[0].ToString());
dto.HoTenNV = values[1].ToString();
dto.NgaySinhNV = DateTime.Parse(values[2].ToString());
dto.GioiTinhNV = Boolean.Parse(values[3].ToString());
dto.DiaChiNV = values[4].ToString();
dto.DienThoaiNV = values[5].ToString();
dto.GhiChuNV = values[6] == null ? null : values[6].ToString();
dto.TenBP = values[7].ToString();
return(dto);
}
catch (Exception e)
{
throw e;
}
}
public static XPDataView ExecKHACHHANG_GetAll()
{
return(SprocHelper.ExecKHACHHANG_GetAllIntoDataView(session));
}
public GetEmployeeClassificationsResult?GetEmployeeClassifications(int employeeClassificationKey)
{
return(SprocHelper.ExecHR_GetEmployeeClassificationsIntoObjects(Session.DefaultSession, employeeClassificationKey).SingleOrDefault());
}
public IList <GetEmployeeClassificationsResult> GetEmployeeClassifications()
{
return(SprocHelper.ExecHR_GetEmployeeClassificationsIntoObjects(Session.DefaultSession, null).ToList());
}
public IList <CountEmployeesByClassificationResult> CountEmployeesByClassification()
{
return(SprocHelper.ExecHR_CountEmployeesByClassificationIntoObjects(Session.DefaultSession).ToList());
}
