/// <summary>
/// This is a generic method to get subskills for a skill
/// </summary>
/// <param name="argSkillID"></param>
/// <returns></returns>
public async Task <SubSkillBECollection> GetSubskillsForSkill(int argSkillID)
{
#region Declarations
SubSkillBECollection l_SubskillBECollection = new SubSkillBECollection();
int l_LoggedInUser = 0;
string l_skillsURL = string.Empty;
#endregion
try
{
InitializeClient();
l_LoggedInUser = GetLoggedInUserID();
l_skillsURL = apiBaseURL + "/GetAllSubSkills?argLoggedInUser="******"&argSkillID=" + argSkillID + "";
HttpResponseMessage l_SkillsData = await client.GetAsync(l_skillsURL);
if (l_SkillsData != null && l_SkillsData.IsSuccessStatusCode)
{
var l_SkillResponse = l_SkillsData.Content.ReadAsStringAsync().Result;
l_SubskillBECollection = JsonConvert.DeserializeObject <SubSkillBECollection>(l_SkillResponse);
}
}
catch (Exception ex)
{
throw ex;
}
return(l_SubskillBECollection);
}
/// <summary>
/// Convert subskill collection to view model
/// </summary>
/// <param name="argSubskillsBE"></param>
/// <returns></returns>
protected SubSkillCollection ConvertSubskillCollectionToModel(SubSkillBECollection argSubskillsBE)
{
SubSkillCollection l_SubskillCollection = new SubSkillCollection();
Subskills l_Subskills;
try
{
if (argSubskillsBE != null && argSubskillsBE.Count > 0)
{
foreach (var subskills in argSubskillsBE)
{
l_Subskills = new Subskills();
l_Subskills.SubSkillID = subskills.SubSkillID;
l_Subskills.SubSkillName = subskills.SubSkillName;
l_Subskills.SkillID = subskills.SkillID;
l_SubskillCollection.Add(l_Subskills);
}
}
}
catch (Exception)
{
throw;
}
return(l_SubskillCollection);
}
/// <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>
/// Method to convert subskill model collection from Business Entity
/// </summary>
/// <param name="argsubSkillBECollection">Subskill business entity</param>
/// <returns></returns>
private SubSkillCollection GetSubskillcollection(SubSkillBECollection argsubSkillBECollection)
{
#region Declarations
SubSkillCollection l_SubSkillCollection = new SubSkillCollection();
Subskills l_SubSkills;
#endregion
try
{
if (argsubSkillBECollection != null && argsubSkillBECollection.Count > 0)
{
foreach (var subskillBE in argsubSkillBECollection)
{
l_SubSkills = new Subskills();
l_SubSkills.SubSkillID = subskillBE.SubSkillID;
l_SubSkills.SubSkillName = subskillBE.SubSkillName;
l_SubSkills.SkillID = subskillBE.SkillID;
l_SubSkills.SkillPoints = subskillBE.SkillPoints;
l_SubSkills.SubSkillType = subskillBE.SubSkillType;
l_SubSkills.SkillName = subskillBE.SkillName;
l_SubSkillCollection.Add(l_SubSkills);
}
}
}
catch (Exception)
{
throw;
}
return(l_SubSkillCollection);
}
public async Task <JsonResult> GetSubskills(int argSkillID)
{
#region Declarations
SubSkillBECollection l_SubSkills = new SubSkillBECollection();
SubSkillCollection l_SubskillCollection = new SubSkillCollection();
#endregion
l_SubSkills = await GetSubskillsForSkill(argSkillID);
if (l_SubSkills != null && l_SubSkills.Count > 0)
{
l_SubskillCollection = ConvertSubskillCollectionToModel(l_SubSkills);
}
return(Json(l_SubskillCollection, JsonRequestBehavior.AllowGet));
}
/// <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);
}
public async Task <ActionResult> GetSubskills(int argSkillID)
{
#region Declarations
ImproveSkills l_ImproveSkills = new ImproveSkills();
SubSkillBECollection l_SubSkills = new SubSkillBECollection();
SubSkillCollection l_SubskillCollection = new SubSkillCollection();
#endregion
l_SubSkills = await GetSubskillsForSkill(argSkillID);
if (l_SubSkills != null && l_SubSkills.Count > 0)
{
l_SubskillCollection = ConvertSubskillCollectionToModel(l_SubSkills);
l_ImproveSkills.SubskillCollection = l_SubskillCollection;
}
return(PartialView("_partialImproveSubskills", l_ImproveSkills));
}
public async Task <ActionResult> GetSubskills(int argSkillID)
{
#region Declarations
UserInitialSkillRequest l_UserInitialSkillRequest = new UserInitialSkillRequest();
SubSkillBECollection l_SubSkills = new SubSkillBECollection();
SubSkillCollection l_SubskillCollection = new SubSkillCollection();
#endregion
l_SubSkills = await GetSubskillsForSkill(argSkillID);
if (l_SubSkills != null && l_SubSkills.Count > 0)
{
l_SubskillCollection = ConvertSubskillCollectionToModel(l_SubSkills);
l_UserInitialSkillRequest.SubskillCollection = l_SubskillCollection;
}
return(PartialView("_partialSubskills", l_UserInitialSkillRequest));
}
/// <summary>
/// This method is used to generate Skill XML
/// </summary>
/// <param name="argSubskills"></param>
/// <returns></returns>
private XElement GenerateSkillXML(SubSkillBECollection argSubskills)
{
XElement l_skillXML = null;
try
{
l_skillXML = new XElement("SkillSet",
from skill in argSubskills
select new XElement("Skill",
new XElement("SkillID", skill.SkillID),
new XElement("SubskillID", skill.SubSkillID)
));
}
catch (Exception ex)
{
throw ex;
}
return(l_skillXML);
}
/// <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);
}
public IHttpActionResult GetAllSubSkills(int argLoggedInUser, int argSkillID)
{
#region Declarations
SkillBLO l_SkillsBLO = new SkillBLO();
SubSkillBECollection l_SubSkillCollection = new SubSkillBECollection();
#endregion
try
{
l_SubSkillCollection = l_SkillsBLO.GetAllSubSkills(argLoggedInUser, argSkillID);
if (l_SubSkillCollection == null || l_SubSkillCollection.Count == 0)
{
return(NotFound());
}
}
catch (Exception ex)
{
throw ex;
}
return(Ok(l_SubSkillCollection));
}