/// <summary>
/// Convert query collection business entity collection to model
/// </summary>
/// <param name="argQueryBECollection">Query business entity collection</param>
/// <returns></returns>
private QueryCollection ConvertUserRequestsToModel(QueryBECollection argQueryBECollection)
{
#region Declarations
QueryCollection l_QueryCollection = new QueryCollection();
Query l_Query;
#endregion
try
{
if (argQueryBECollection != null && argQueryBECollection.Count > 0)
{
foreach (var item in argQueryBECollection)
{
l_Query = new Query();
l_Query.Name = item.Name;
l_Query.Email = item.Email;
l_Query.ContactNumber = item.ContactNumber;
l_Query.SkillPoints = item.SkillPoints;
l_QueryCollection.Add(l_Query);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(l_QueryCollection);
}
/// <summary>
/// Used to get list of experts with required skills and subskills
/// </summary>
/// <param name="argLoggedInUser">Logged in User ID</param>
/// <param name="argSkillID">Skill ID</param>
/// <param name="argSubSkillID">SubSkill ID</param>
/// <returns></returns>
public QueryBECollection GetEmployeesBasedOnSkillAndSubskill(int argLoggedInUser, int argSkillID, int argSubSkillID)
{
#region Declarations
QueryBECollection l_QueryBECollection = new QueryBECollection();
SkillsDBManager l_SkillsDBManager = new SkillsDBManager("SkillsDBConnection");
List <IDbDataParameter> l_Parameters = new List <IDbDataParameter>();
DataTable l_QueryDataTable = new DataTable();
QueryBE l_Query;
int l_QueryResultCount = 0;
#endregion
try
{
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.LOGGEDINUSERID, argLoggedInUser, DbType.Int32));
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.SKILLID, argSkillID, DbType.Int32));
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.SUBSKILLID, argSubSkillID, DbType.Int32));
l_QueryDataTable = l_SkillsDBManager.GetDataTable(StoredProcedures.GET_EMPLOYEESFORASKILLSUBSKILL, CommandType.StoredProcedure, l_Parameters.ToArray());
if (l_QueryDataTable != null && l_QueryDataTable.Rows.Count > 0)
{
l_QueryResultCount = l_QueryDataTable.Rows.Count;
for (int i = 0; i < l_QueryResultCount; i++)
{
l_Query = new QueryBE();
DataRow l_Row = l_QueryDataTable.Rows[i];
l_Query.Name = l_Row["Employee Name"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["Employee Name"]);
l_Query.Email = l_Row["Email"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["Email"]);
l_Query.ContactNumber = l_Row["Contact Number"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["Contact Number"]);
l_Query.SkillPoints = l_Row["Skill Points"] == DBNull.Value ? 0 : Convert.ToInt32(l_Row["Skill Points"]);
l_QueryBECollection.Add(l_Query);
}
}
}
catch (Exception ex)
{
throw;
}
return(l_QueryBECollection);
}
public async Task <ActionResult> GetQueryResults(int argSkillID, int argSubSkillID)
{
#region Declarations
Query l_Query = new Query();
QueryCollection l_QueryCollection = new QueryCollection();
QueryBECollection l_QueryBECollection = new QueryBECollection();
string l_QueryURL = string.Empty;
#endregion
l_QueryURL = apiBaseURL + "/GetQueryResults?argLoggedInUser="******"&argSkillID=" + argSkillID + "&argSubSkillID=" + argSubSkillID;
HttpResponseMessage l_QueryData = await client.GetAsync(l_QueryURL);
if (l_QueryData != null && l_QueryData.IsSuccessStatusCode)
{
var l_QueryResponse = l_QueryData.Content.ReadAsStringAsync().Result;
l_QueryBECollection = JsonConvert.DeserializeObject <QueryBECollection>(l_QueryResponse);
}
l_QueryCollection = ConvertUserRequestsToModel(l_QueryBECollection);
return(PartialView("_partialGetQueryResults", l_QueryCollection));
}
public IHttpActionResult GetQueryResults(int argLoggedInUser, int argSkillID, int argSubSkillID)
{
#region Declarations
QueryBLO l_QueryBLO = new QueryBLO();
QueryBECollection l_QueryBECollection = new QueryBECollection();
#endregion
try
{
l_QueryBECollection = l_QueryBLO.GetEmployeesBasedOnSkillAndSubskill(argLoggedInUser, argSkillID, argSubSkillID);
if (l_QueryBECollection == null || l_QueryBECollection.Count == 0)
{
return(NotFound());
}
}
catch (Exception ex)
{
throw ex;
}
return(Ok(l_QueryBECollection));
}
