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