public RegistrationViewDetailsModel GetAdminDetailsByRegistrationID(int?RegistrationID)
{
using (var _context = new DatabaseContext())
{
string RoleCode = "Manager";
var queryResult = (from registration in _context.Registration
join role in _context.Role on registration.RoleID equals role.RoleID
where registration.RegistrationID == RegistrationID && role.RoleCode == RoleCode
select registration).FirstOrDefault();
if (queryResult != null)
{
var objRegistrationViewDetailsModel = new RegistrationViewDetailsModel()
{
Birthdate = Convert.ToString(queryResult.Birthdate),
DateofLeaving = Convert.ToString(queryResult.DateofLeaving),
DateofJoining = Convert.ToString(queryResult.DateofLeaving),
EmailID = queryResult.EmailID,
EmployeeID = queryResult.EmployeeID,
Gender = queryResult.Gender,
IsActive = Convert.ToBoolean(queryResult.IsActive),
Mobileno = queryResult.Mobileno,
FullName = TimeSheetHelper.GetFullName(queryResult.FirstName, queryResult.MiddleName, queryResult.LastName),
RegistrationID = queryResult.RegistrationID,
RoleID = Convert.ToInt32(queryResult.RoleID),
Username = queryResult.Username
};
return(objRegistrationViewDetailsModel);
}
return(new RegistrationViewDetailsModel());
}
}
public string GetUsernamebyRegistrationID(int RegistrationID)
{
using (DatabaseContext _context = new DatabaseContext())
{
var employee = (from registration in _context.Registration
where registration.RegistrationID == RegistrationID
select registration).FirstOrDefault();
if (employee != null)
{
return(TimeSheetHelper.GetFullName(employee.FirstName, employee.MiddleName, employee.LastName));
}
else
{
return("");
}
}
}
