/// <summary> /// Method to convert UserRequests business entity to Model /// </summary> /// <param name="argUserRequestsBECollection">UserRequests Business Entity</param> /// <returns></returns> private UserRequestsCollection ConvertUserRequestsToModel(UserRequestsBECollection argUserRequestsBECollection) { UserRequestsCollection l_UserRequestsCollection = new UserRequestsCollection(); UserRequests l_Requests; try { if (argUserRequestsBECollection != null && argUserRequestsBECollection.Count > 0) { foreach (var item in argUserRequestsBECollection) { l_Requests = new UserRequests(); l_Requests.Comments = item.Comments; l_Requests.Status = item.Status; l_Requests.RequestedDate = item.RequestedDate; l_Requests.RequestType = item.RequestType; l_Requests.Skill = item.Skill; l_Requests.SubSkill = item.SubSkill; l_Requests.BadgeID = item.BadgeID; l_Requests.BadgeGivenFor = item.BadgeGivenFor; l_UserRequestsCollection.Add(l_Requests); } } } catch (Exception ex) { throw ex; } return(l_UserRequestsCollection); }
/// <summary> /// Used to get the list of requests made by user along with their status /// </summary> /// <param name="argLoggedInUser">Logged in User ID</param> /// <param name="argType">Request Type</param> /// <returns></returns> public UserRequestsBECollection GetUserSkillRequests(int argLoggedInUser, string argType) { #region Declarations UserRequestsBECollection l_requestCollection = new UserRequestsBECollection(); SkillsDBManager l_SkillsDBManager = new SkillsDBManager("SkillsDBConnection"); List <IDbDataParameter> l_Parameters = new List <IDbDataParameter>(); DataTable l_SkillDataTable = new DataTable(); UserRequestsBE l_RequestBE; int l_SkillCount = 0; #endregion try { l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.LOGGEDINUSERID, argLoggedInUser, DbType.Int32)); if (string.IsNullOrEmpty(argType)) { l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.TYPE, DBNull.Value, DbType.String)); } else { l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.TYPE, argType, DbType.String)); } l_SkillDataTable = l_SkillsDBManager.GetDataTable(StoredProcedures.GET_ALLSKILLREQUESTS, CommandType.StoredProcedure, l_Parameters.ToArray()); if (l_SkillDataTable != null && l_SkillDataTable.Rows.Count > 0) { l_SkillCount = l_SkillDataTable.Rows.Count; for (int i = 0; i < l_SkillCount; i++) { l_RequestBE = new UserRequestsBE(); DataRow l_Row = l_SkillDataTable.Rows[i]; l_RequestBE.RequestType = l_Row["Request type"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["Request type"]); l_RequestBE.Status = l_Row["Status"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["Status"]); l_RequestBE.Comments = l_Row["Comments"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["Comments"]); l_RequestBE.RequestedDate = l_Row["Request date"] == DBNull.Value ? DateTime.Now : Convert.ToDateTime(l_Row["Request date"]); l_RequestBE.Skill = l_Row["Skill"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["Skill"]); l_RequestBE.SubSkill = l_Row["Sub-skill"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["Sub-skill"]); //Badge Details l_RequestBE.BadgeGivenFor = l_Row["BadgeGivenFor"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["BadgeGivenFor"]); l_RequestBE.BadgeName = l_Row["BadgeName"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["BadgeName"]); l_RequestBE.BadgeImageURL = l_Row["BadgeImageURL"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["BadgeImageURL"]); l_RequestBE.BadgeID = l_Row["BadgeID"] == DBNull.Value ? 0 : Convert.ToInt32(l_Row["BadgeID"]); l_requestCollection.Add(l_RequestBE); } } } catch (Exception ex) { throw ex; } return(l_requestCollection); }
public async Task <ActionResult> GetUserRequests(string argRequestType) { #region Declarations UserRequests l_UserRequests = new UserRequests(); UserRequestsBECollection l_UserRequestsBECollection = new UserRequestsBECollection(); UserRequestsCollection l_UserRequestsCollection = new UserRequestsCollection(); string l_skillsURL = string.Empty; #endregion l_skillsURL = apiBaseURL + "/GetUserRequests?argLoggedInUser="******"&argType=" + argRequestType + ""; HttpResponseMessage l_SkillsData = await client.GetAsync(l_skillsURL); if (l_SkillsData != null && l_SkillsData.IsSuccessStatusCode) { var l_SkillResponse = l_SkillsData.Content.ReadAsStringAsync().Result; l_UserRequestsBECollection = JsonConvert.DeserializeObject <UserRequestsBECollection>(l_SkillResponse); } l_UserRequestsCollection = ConvertUserRequestsToModel(l_UserRequestsBECollection); return(PartialView("_partialGetUserRequests", l_UserRequestsCollection)); }
public IHttpActionResult GetUserRequests(int argLoggedInUser, string argType) { #region Declarations UserRequestsBLO l_RequestBLO = new UserRequestsBLO(); UserRequestsBECollection l_UserRequestsBECollection = new UserRequestsBECollection(); #endregion try { l_UserRequestsBECollection = l_RequestBLO.GetUserSkillRequests(argLoggedInUser, argType); if (l_UserRequestsBECollection == null || l_UserRequestsBECollection.Count == 0) { return(NotFound()); } } catch (Exception ex) { throw ex; } return(Ok(l_UserRequestsBECollection)); }