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 IHttpActionResult GetUserDetailsById(int?RegistrationID)
{
var userDetailsResponse = _IUsersRepository.GetUserDetailsByRegistrationID(RegistrationID);
if (userDetailsResponse == null)
{
userDetailsResponse = new RegistrationViewDetailsModel();
}
if (string.IsNullOrEmpty(userDetailsResponse.DateofLeaving) || userDetailsResponse.DateofLeaving == "01/01/0001")
{
userDetailsResponse.IsActive = true;
}
else
{
userDetailsResponse.IsActive = false;
}
userDetailsResponse.DateofLeaving = (string.IsNullOrEmpty(userDetailsResponse.DateofLeaving) || userDetailsResponse.DateofLeaving == "01/01/0001") ? "" : userDetailsResponse.DateofLeaving;
var RId = Convert.ToString(RegistrationID);
var roles = _IRoleRepository.getRoles().Select(arg =>
new ValueDescription
{
Value = Convert.ToString(arg.RoleID),
Text = arg.Rolename
}).ToList();
var departments = _IDepartmentRepository.GetDepartments()
.Select(arg =>
new ValueDescription
{
Value = Convert.ToString(arg.DeptId),
Text = arg.DepartmentName
}).ToList();
var jobs = _IJobsRepository.GetJobs()
.Select(arg =>
new ValueDescription
{
Value = Convert.ToString(arg.JobId),
Text = arg.JobTitle
}).ToList();
var managers = _IAssignRolesRepository.ListofAdmins().Select(n =>
new ValueDescription
{
Value = Convert.ToString(n.RegistrationID),
Text = n.FullName
}).ToList();
if (userDetailsResponse != null)
{
userDetailsResponse.Roles = roles;
userDetailsResponse.Departments = departments;
userDetailsResponse.Jobs = jobs;
userDetailsResponse.Managers = managers;
}
return(Ok(userDetailsResponse));
}
public IHttpActionResult SaveUser(RegistrationViewDetailsModel objuser)
{
int result = 0;
var user = new Registration()
{
FirstName = objuser.FirstName,
MiddleName = objuser.MiddleName,
LastName = objuser.LastName,
Birthdate = Convert.ToDateTime(objuser.Birthdate),
ConfirmPassword = objuser.ConfirmPassword,
DateofJoining = Convert.ToDateTime(objuser.DateofJoining),
DateofLeaving = Convert.ToDateTime(objuser.DateofLeaving),
DeptId = objuser.DeptId,
EmailID = objuser.EmailID,
EmergencyContact = objuser.EmergencyContact,
EmergencyContactNumber = objuser.EmergencyContactNumber,
EmployeeID = objuser.EmployeeID,
JobId = objuser.JobId,
Gender = objuser.Gender,
IsActive = objuser.IsActive ? true : true,
ManagerId = objuser.ManagerId,
Mobileno = objuser.Mobileno,
Password = objuser.Password,
RegistrationID = objuser.RegistrationID,
RoleID = objuser.RoleID,
Username = objuser.Username,
WorkEmail = objuser.WorkEmail,
CreatedOn = DateTime.Now
};
if (objuser.RegistrationID > 0)
{
result = _IRegistrationRepository.UpdateUser(user);
}
else
{
if (!string.IsNullOrWhiteSpace(objuser.Username))
{
var isvalidUserName = _IRegistrationRepository.CheckUserNameExists(objuser.Username);
if (!isvalidUserName)
{
result = _IRegistrationRepository.AddUser(user);
}
else
{
result = -1;
}
}
}
return(Ok(result));
}
public IHttpActionResult GetUserDetails()
{
var userDetailsResponse = new RegistrationViewDetailsModel();
var roles = _IRoleRepository.getRoles().Select(arg =>
new ValueDescription
{
Value = Convert.ToString(arg.RoleID),
Text = arg.Rolename
}).ToList();
var departments = _IDepartmentRepository.GetDepartments()
.Select(arg =>
new ValueDescription
{
Value = Convert.ToString(arg.DeptId),
Text = arg.DepartmentName
}).ToList();
var jobs = _IJobsRepository.GetJobs()
.Select(arg =>
new ValueDescription
{
Value = Convert.ToString(arg.JobId),
Text = arg.JobTitle
}).ToList();
var managers = _IAssignRolesRepository.ListofAdmins().Select(n =>
new ValueDescription
{
Value = Convert.ToString(n.RegistrationID),
Text = n.FullName
}).ToList();
if (userDetailsResponse != null)
{
userDetailsResponse.Roles = roles;
userDetailsResponse.Departments = departments;
userDetailsResponse.Jobs = jobs;
userDetailsResponse.Managers = managers;
}
return(Ok(userDetailsResponse));
}
public RegistrationViewDetailsModel GetUserDetailsByRegistrationID(int?RegistrationID)
{
try
{
using (var _context = new DatabaseContext())
{
//string[] RoleCodes = new string[] { "SuperAdmin", "Manager" };
var queryResult = (from registration in _context.Registration
join A in _context.AssignedRoles on registration.RegistrationID equals A.RegistrationID into A_join
from A in A_join.DefaultIfEmpty()
join AA in _context.Registration on A.AssignToAdmin equals AA.RegistrationID into AA_join
from AA in AA_join.DefaultIfEmpty()
join role in _context.Role on registration.RoleID equals role.RoleID into RL_join
from role in RL_join.DefaultIfEmpty()
join department in _context.Departments on registration.DeptId equals department.DeptId into D_join
from department in D_join.DefaultIfEmpty()
join job in _context.Jobs on registration.JobId equals job.JobId into J_join
from job in J_join.DefaultIfEmpty()
where registration.RegistrationID == RegistrationID
select new RegistrationViewModel()
{
registration = registration,
roles = role,
departments = department,
jobs = job,
ManagerFirstName = AA.FirstName,
ManagerLastName = AA.LastName,
ManagerMiddleName = AA.MiddleName
}).FirstOrDefault();
if (queryResult != null)
{
var objRegistrationViewDetailsModel = new RegistrationViewDetailsModel()
{
Birthdate = string.IsNullOrEmpty(queryResult.registration.Birthdate.ToString()) ? "" : Convert.ToDateTime(queryResult.registration.Birthdate, new CultureInfo("es-US", true)).ToString("MM/dd/yyyy"),
DateofJoining = string.IsNullOrEmpty(queryResult.registration.DateofJoining.ToString()) ? "" : Convert.ToDateTime(queryResult.registration.DateofJoining, new CultureInfo("es-US", true)).ToString("MM/dd/yyyy"),
DateofLeaving = string.IsNullOrEmpty(queryResult.registration.DateofLeaving.ToString()) ? "" : Convert.ToDateTime(queryResult.registration.DateofLeaving, new CultureInfo("es-US", true)).ToString("MM/dd/yyyy"),
EmailID = queryResult.registration.EmailID,
EmployeeID = queryResult.registration.EmployeeID,
Gender = queryResult.registration.Gender,
IsActive = Convert.ToBoolean(queryResult.registration.IsActive),
Mobileno = queryResult.registration.Mobileno,
FirstName = queryResult.registration.FirstName,
MiddleName = queryResult.registration.MiddleName,
LastName = queryResult.registration.LastName,
RegistrationID = queryResult.registration.RegistrationID,
RoleID = Convert.ToInt32(queryResult.registration.RoleID),
Username = queryResult.registration.Username,
WorkEmail = queryResult.registration.WorkEmail,
EmergencyContact = queryResult.registration.EmergencyContact,
EmergencyContactNumber = queryResult.registration.EmergencyContactNumber,
DeptId = Convert.ToInt32(queryResult.registration.DeptId),
ManagerId = Convert.ToInt32(queryResult.registration.ManagerId),
JobId = Convert.ToInt32(queryResult.registration.JobId),
JobTitle = queryResult.jobs == null ? "" : queryResult.jobs.JobTitle,
RoleName = queryResult.roles == null ? "" : queryResult.roles.Rolename,
DepartmentName = queryResult.departments == null ? "" : queryResult.departments.DepartmentName,
ManagerFirstName = queryResult.ManagerFirstName == null ? "" : queryResult.ManagerFirstName,
ManagerMiddleName = queryResult.ManagerMiddleName == null ? "" : queryResult.ManagerMiddleName,
ManagerLastName = queryResult.ManagerLastName == null ? "" : queryResult.ManagerLastName
};
return(objRegistrationViewDetailsModel);
}
return(new RegistrationViewDetailsModel());
}
}
catch (Exception ex)
{
throw ex;
}
}
