public Userdetails GetUserDetailByBadgeNumber(int BadgeNumber)
{
Userdetails userDetail = null;
tbl_EmpDetails tbl_EmpDetailsOB = (from e in _dbContext.tbl_EmpDetails where e.BadgeNumber == BadgeNumber select e).FirstOrDefault();
var department = _dbContext.tbl_Departments.Where(d => d.ID == tbl_EmpDetailsOB.DeptId).FirstOrDefault();
tbl_EmpDetailsOB.Department = department;
userDetail = _employeeDetailsMapper.GetUserDetilsFromTbl_EmpDetailsOB(tbl_EmpDetailsOB);
return(userDetail);
}
public Userdetails GetUserDetilsFromTbl_EmpDetailsOB(tbl_EmpDetails EmpDetailsOB)
{
var config = new MapperConfiguration(cfg => {
cfg.AllowNullCollections = true;
cfg.AllowNullDestinationValues = true;
cfg.CreateMap <tbl_EmpDetails, Userdetails>();
});
IMapper mapper = config.CreateMapper();
Userdetails = mapper.Map <tbl_EmpDetails, Userdetails>(EmpDetailsOB);
Userdetails.DepartmentName = EmpDetailsOB.Department.departmentName;
return(Userdetails);
}
public tbl_EmpDetails Gettbl_EmpDetailsOBFromUserDetails(Userdetails Userdetails)
{
var config = new MapperConfiguration(cfg => {
cfg.AllowNullCollections = true;
cfg.AllowNullDestinationValues = true;
cfg.CreateMap <Userdetails, tbl_EmpDetails>();
});
IMapper mapper = config.CreateMapper();
var source = new tbl_EmpDetails();
EmpDetailsOB = mapper.Map <Userdetails, tbl_EmpDetails>(Userdetails);
return(EmpDetailsOB);
}
public Userdetails GetUserDetailByName(string userName)
{
try
{
tbl_EmpDetails userdetailsOB = null;
userdetailsOB = (from e in _dbContext.tbl_EmpDetails
where e.UserName == userName
select e
).FirstOrDefault();
if (userdetailsOB != null)
{
tbl_Department dept = (from d in _dbContext.tbl_Departments where d.ID == userdetailsOB.DeptId select d).FirstOrDefault();
userdetailsOB.Department = dept;
}
Userdetails userDetail = null;
userDetail = _employeeDetailsMapper.GetUserDetilsFromTbl_EmpDetailsOB(userdetailsOB);
return(userDetail);
}
catch (Exception ex)
{
return(null);
}
}
