/// <summary> /// Used to save skills & subskills created using Improve Skills option /// </summary> /// <param name="argLoggedInUser">Logged in user</param> /// <param name="argImproveSkills">Skill and Subskill details</param> /// <returns></returns> public void ImproveSkills(ImproveSkillsBE argImproveSkills, 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 && argImproveSkills != null && argImproveSkills.UserSubskills != null && argImproveSkills.UserSubskills.Count > 0) { //Generate XML l_skillXML = GenerateSkillXML(argImproveSkills.UserSubskills); //Create Parameters l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.LOGGEDINUSERID, argLoggedInUser, DbType.String)); l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.COMMENTS, argImproveSkills.Comments, DbType.String)); l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.SKILLXML, l_skillXML.ToString(), DbType.Xml)); l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.TYPE, argImproveSkills.Mode, DbType.String)); if (string.IsNullOrEmpty(argImproveSkills.FileUploadGUID)) { l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.FILEUPLOADGUID, DBNull.Value, DbType.String)); } else { l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.FILEUPLOADGUID, argImproveSkills.FileUploadGUID, DbType.String)); } if (string.IsNullOrEmpty(argImproveSkills.FileUploadName)) { l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.FILEUPLOADNAME, DBNull.Value, DbType.String)); } else { l_Parameters.Add(l_SkillsDBManager.CreateParameter(ProcedureParams.FILEUPLOADNAME, argImproveSkills.FileUploadName, DbType.String)); } //Call stored procedure l_SkillsDBManager.Insert(StoredProcedures.SAVE_IMPROVESKILLS, CommandType.StoredProcedure, l_Parameters.ToArray(), out l_LastID); } } catch (Exception ex) { throw ex; } }
public IHttpActionResult ImproveSkills(string argLoggedInUser, [FromBody] ImproveSkillsBE argImproveSkills) { #region Declarations SkillBLO l_SkillBLO = new SkillBLO(); #endregion try { l_SkillBLO.ImproveSkills(argImproveSkills, argLoggedInUser); } catch (Exception ex) { throw ex; } return(Ok()); }
/// <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> /// Save Initial skill requests to DB /// </summary> /// <param name="argSkillRequest"></param> /// <returns></returns> private async Task <HttpResponseMessage> ImproveSkillRequest(ImproveSkills argImproveSkills, string argGUID) { #region Declarations HttpResponseMessage l_Response = new HttpResponseMessage(); ImproveSkillsBE l_ImproveSkillsBE = new ImproveSkillsBE(); string l_SaveSkillURL = apiBaseURL + "/ImproveSkills?argLoggedInUser=" + GetLoggedInUserID(); #endregion try { l_ImproveSkillsBE = ConvertImproveSkillRequestToBusinessEntity(argImproveSkills, argGUID); if (l_ImproveSkillsBE != null) { l_Response = await client.PostAsJsonAsync(l_SaveSkillURL, l_ImproveSkillsBE); } } catch (Exception ex) { throw ex; } return(l_Response); }