/// <summary> /// This method is used to convert Intial Request to business entity /// </summary> /// <param name="argSkillRequest"></param> /// <returns></returns> private UserInitialSkillRequestBE ConvertSkillRequestToBusinessEntity(UserInitialSkillRequest argSkillRequest) { #region Declarations UserInitialSkillRequestBE l_UserInitialSkillRequestBE = new UserInitialSkillRequestBE(); SubSkillBECollection l_SubskillsBECollection = new SubSkillBECollection(); SubskillsBE l_Subskills; #endregion try { if (argSkillRequest != null) { //Comments l_UserInitialSkillRequestBE.Comments = argSkillRequest.Comments; //Subskills if (argSkillRequest.SubskillCollection != null && argSkillRequest.SubskillCollection.Count > 0) { foreach (var subskills in argSkillRequest.SubskillCollection) { l_Subskills = new SubskillsBE(); l_Subskills.SubSkillID = subskills.SubSkillID; l_Subskills.SkillID = subskills.SkillID; l_SubskillsBECollection.Add(l_Subskills); } l_UserInitialSkillRequestBE.UserSubskills = l_SubskillsBECollection; } } } catch (Exception ex) { throw ex; } return(l_UserInitialSkillRequestBE); }
/// <summary> /// Method to fetch subskill data on the basis of skill ID and skill type /// </summary> /// <param name="argSkillID">Skill ID</param> /// <param name="argSubSkillTable">DataTable with subskill details</param> /// <param name="argSkillType">Skill Type (Required/Acquired)</param> /// <returns></returns> private SubSkillBECollection GetSubSkillData(int argSkillID, DataTable argSubSkillTable, string argSkillType) { SubSkillBECollection l_SubSkillBECollection = new SubSkillBECollection(); SubskillsBE l_SubskillsBE; try { if (argSubSkillTable != null && argSubSkillTable.Rows.Count > 0) { var requiredSubSkills = argSubSkillTable.AsEnumerable().Where(r => (int)r["RequiredSkillID"] == argSkillID && r["SubSkillType"].ToString().ToUpper() == argSkillType.ToUpper()); foreach (var item in requiredSubSkills) { l_SubskillsBE = new SubskillsBE(); l_SubskillsBE.SkillID = item["RequiredSkillID"] == DBNull.Value ? 0 : Convert.ToInt32(item["RequiredSkillID"]); l_SubskillsBE.SubSkillID = item["RequiredSubskillID"] == DBNull.Value ? 0 : Convert.ToInt32(item["RequiredSubskillID"]); l_SubskillsBE.SkillName = item["SkillName"] == DBNull.Value ? string.Empty : Convert.ToString(item["SkillName"]); l_SubskillsBE.SubSkillName = item["SubskillName"] == DBNull.Value ? string.Empty : Convert.ToString(item["SubskillName"]); l_SubskillsBE.SubSkillType = item["SubSkillType"] == DBNull.Value ? string.Empty : Convert.ToString(item["SubSkillType"]); l_SubskillsBE.SkillPoints = item["SkillPoints"] == DBNull.Value ? 0 : Convert.ToInt32(item["SkillPoints"]); l_SubSkillBECollection.Add(l_SubskillsBE); } } } catch (Exception) { throw; } return(l_SubSkillBECollection); }
/// <summary> /// This function is used to convert model to Business Entity /// </summary> /// <param name="argImproveSkills"></param> /// <param name="argGUID"></param> /// <returns></returns> private ImproveSkillsBE ConvertImproveSkillRequestToBusinessEntity(ImproveSkills argImproveSkills, string argGUID) { #region Declarations ImproveSkillsBE l_ImproveSkillsBE = new ImproveSkillsBE(); SubSkillBECollection l_SubskillsBECollection = new SubSkillBECollection(); SubskillsBE l_Subskills; #endregion try { if (argImproveSkills != null) { //Comments l_ImproveSkillsBE.Comments = argImproveSkills.Comments; //File details if (argImproveSkills.File != null) { l_ImproveSkillsBE.FileUploadName = argImproveSkills.File.FileName; l_ImproveSkillsBE.FileUploadGUID = argGUID; } //Mode l_ImproveSkillsBE.Mode = argImproveSkills.Mode; //Subskills if (argImproveSkills.SubskillCollection != null && argImproveSkills.SubskillCollection.Count > 0) { foreach (var subskills in argImproveSkills.SubskillCollection) { l_Subskills = new SubskillsBE(); l_Subskills.SubSkillID = subskills.SubSkillID; l_Subskills.SkillID = subskills.SkillID; l_SubskillsBECollection.Add(l_Subskills); } l_ImproveSkillsBE.UserSubskills = l_SubskillsBECollection; } } } catch (Exception ex) { throw ex; } return(l_ImproveSkillsBE); }
/// <summary> /// Used to fetch all subskills for a skill /// </summary> /// <param name="argLoggedInUser">Logged in UserID</param> /// <param name="argSkillID">SkillID</param> /// <returns></returns> public SubSkillBECollection GetAllSubSkills(int argLoggedInUser, int argSkillID) { #region Declarations SubSkillBECollection l_SubSkillCollection = new SubSkillBECollection(); SkillsDBManager l_SkillsDBManager = new SkillsDBManager("SkillsDBConnection"); List <IDbDataParameter> l_Parameters = new List <IDbDataParameter>(); DataTable l_SubSkillDataTable = new DataTable(); SubskillsBE l_SubSkill; int l_SubSkillCount = 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_SubSkillDataTable = l_SkillsDBManager.GetDataTable(StoredProcedures.GET_ALLSUBSKILLS_FORASKILL, CommandType.StoredProcedure, l_Parameters.ToArray()); if (l_SubSkillDataTable != null && l_SubSkillDataTable.Rows.Count > 0) { l_SubSkillCount = l_SubSkillDataTable.Rows.Count; for (int i = 0; i < l_SubSkillCount; i++) { l_SubSkill = new SubskillsBE(); DataRow l_Row = l_SubSkillDataTable.Rows[i]; l_SubSkill.SkillID = l_Row["SkillID"] == DBNull.Value ? 0 : Convert.ToInt32(l_Row["SkillID"]); l_SubSkill.SubSkillID = l_Row["SubskillID"] == DBNull.Value ? 0 : Convert.ToInt32(l_Row["SubskillID"]); l_SubSkill.SubSkillName = l_Row["SubskillName"] == DBNull.Value ? string.Empty : Convert.ToString(l_Row["SubskillName"]); l_SubSkillCollection.Add(l_SubSkill); } } } catch (Exception ex) { throw; } return(l_SubSkillCollection); }