/// <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)); }