/// <summary>
/// Used to save the initial skill request (primary skills)
/// </summary>
/// <param name="argLoggedInUser">Logged in User ID</param>
/// <param name="argInitialRequest">Request Details</param>
/// <returns></returns>
public void CreateInitialRequest(UserInitialSkillRequestBE argSkillRequest, string argLoggedInUser)
{
#region Declarations
SkillsDBManager l_SkillsDBManager = new SkillsDBManager("SkillsDBConnection");
List <IDbDataParameter> l_Parameters = new List <IDbDataParameter>();
XElement l_skillXML = null;
int l_LastID = 0;
#endregion
try
{
if (argLoggedInUser != null && argSkillRequest != null && argSkillRequest.UserSubskills != null && argSkillRequest.UserSubskills.Count > 0)
{
//Generate XML
l_skillXML = GenerateSkillXML(argSkillRequest.UserSubskills);
//Create Parameters
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.LOGGEDINUSERID, argLoggedInUser, DbType.String));
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.COMMENTS, argSkillRequest.Comments, DbType.String));
l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.SKILLXML, l_skillXML.ToString(), DbType.Xml));
//Call stored procedure
l_SkillsDBManager.Insert(StoredProcedures.SAVE_INITIALSKILLREQUEST, CommandType.StoredProcedure, l_Parameters.ToArray(), out l_LastID);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <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);
}
public IHttpActionResult CreateInitialSkillRequest(string argLoggedInUser, [FromBody] UserInitialSkillRequestBE argInitialRequest)
{
#region Declarations
SkillBLO l_SkillBLO = new SkillBLO();
#endregion
try
{
l_SkillBLO.CreateInitialRequest(argInitialRequest, argLoggedInUser);
}
catch (Exception ex)
{
throw ex;
}
return(Ok());
}
/// <summary>
/// API call to save Initial skill requests
/// </summary>
/// <param name="argSkillRequest"></param>
/// <returns></returns>
private async Task <HttpResponseMessage> SaveInitialSkills(UserInitialSkillRequest argSkillRequest)
{
#region Declarations
HttpResponseMessage l_Response = new HttpResponseMessage();
UserInitialSkillRequestBE l_RequestBE = new UserInitialSkillRequestBE();
string l_SaveSkillURL = apiBaseURL + "/CreateInitialSkillRequest?argLoggedInUser=" + GetLoggedInUserID();
#endregion
try
{
l_RequestBE = ConvertSkillRequestToBusinessEntity(argSkillRequest);
if (l_RequestBE != null)
{
l_Response = await client.PostAsJsonAsync(l_SaveSkillURL, l_RequestBE);
}
}
catch (Exception ex)
{
throw ex;
}
return(l_Response);
}
