public IHttpActionResult GetSearchedJobRoles([FromUri] SearchJobRolesRequestParams searchParams)
{
if (searchParams == null)
{
searchParams = new SearchJobRolesRequestParams();
}
return(Ok(GetJobRolesDbService().SearchJobRoles(searchParams)));
}
/// <summary>
/// Return list of Job roles based on supplied Search-Parameters
/// </summary>
/// <returns></returns>
JobRoleResponse IJobRolesDbService.SearchJobRoles(SearchJobRolesRequestParams request)
{
JobRoleResponse jobRolesResponse = new JobRoleResponse();
try
{
var dbSet = GetDbConnector().LoadDataSet("SearchJobRoles", QueryCommandType.StoredProcedure,
new List <System.Data.IDbDataParameter>
{
new SqlParameter()
{
ParameterName = "@JobRoleCode", Value = request.Code, SqlDbType = SqlDbType.VarChar, Size = 10
},
new SqlParameter()
{
ParameterName = "@JobRoleName", Value = request.Name, SqlDbType = SqlDbType.VarChar, Size = 500
},
new SqlParameter()
{
ParameterName = "@SkillCouncilTypeId", Value = request.SkillCouncilTypeId, SqlDbType = SqlDbType.Int
},
new SqlParameter()
{
ParameterName = "@SkillCouncilId", Value = request.SkillCouncilId, SqlDbType = SqlDbType.Int
},
});
//Comment : Here fill & return generic list from DbSet
var listjobRoles = new List <JobRole>();
if (dbSet != null && dbSet.Tables.Count > 0)
{
foreach (DataRow dataRow in dbSet.Tables[0].Rows)
{
listjobRoles.Add(
new JobRole()
{
Id = Convert.ToInt32(dataRow["JobRoleId"]),
SkillCouncilId = Convert.ToInt32(dataRow["SkillCouncilId"]),
SkillCouncilCode = dataRow["SkillCouncilCode"].ToString(),
SkillCouncilName = dataRow["SkillCouncilName"].ToString(),
Code = dataRow["Code"].ToString(),
Name = dataRow["Name"].ToString(),
Description = dataRow["Description"].ToString(),
IsActive = Convert.ToBoolean((dataRow["IsActive"] == DBNull.Value || dataRow["IsActive"] == null) ? 0 : dataRow["IsActive"])
});
}
}
//assign fecthed list
jobRolesResponse.JobRoles = listjobRoles;
jobRolesResponse.OperationStatus = new OperationStatus {
ServiceName = "SearchJobRoles", ServiceMethod = "Get", RequestProcessed = true, RequestSuccessful = true
};
}
catch (Exception ex)
{
jobRolesResponse.OperationStatus = new OperationStatus {
Messages = new List <Message>()
{
new Message()
{
DTOName = "JobRole", DTOProperty = "", MessageType = MessageType.SystemError, Text = ex.Message
}
}, RequestProcessed = true, RequestSuccessful = false
};
}
return(jobRolesResponse);
}
