public IHttpActionResult UpdatePerosnalSkills() { UserSkillsDetails Model = new UserSkillsDetails(); try { Model.Skills = (HttpContext.Current.Request.Params["UserSkillsDetail_Skills"]); Model.Version = Convert.ToDecimal(HttpContext.Current.Request.Params["UserSkillsDetail_Version"]); Model.LastUsedYear = Convert.ToInt32(HttpContext.Current.Request.Params["UserSkillsDetail_LastUsedYear"]); Model.Experience = Convert.ToInt32(HttpContext.Current.Request.Params["UserSkillsDetail_Experience"]); Model.UserID = Convert.ToInt32(HttpContext.Current.Request.Params["UserId"]); return(Json(_UserProfileRepository.UpdatePersonalSkills(Model))); } catch (Exception ex) { return(Json(ex.Message)); } }
public ResponseModel UpdatePersonalSkills(UserSkillsDetails model) { ResponseModel responseModel = new ResponseModel(); try { responseModel = DBManager.SpHelper <ResponseModel> .GetListWithRawSql("Usp_UpdatePersonalSkills @userid,@Skills,@Version,@LastUsedYear,@Experience", new SqlParameter { ParameterName = "@userid", DbType = System.Data.DbType.Int32, Value = model.UserID }, new SqlParameter { ParameterName = "@Skills", DbType = System.Data.DbType.String, Value = model.Skills }, new SqlParameter { ParameterName = "@Version", DbType = System.Data.DbType.Decimal, Value = model.Version }, new SqlParameter { ParameterName = "@LastUsedYear", DbType = System.Data.DbType.Int32, Value = model.LastUsedYear }, new SqlParameter { ParameterName = "@Experience", DbType = System.Data.DbType.Int32, Value = model.Experience }).Single(); return(responseModel); } catch (Exception ex) { responseModel.Status = false; responseModel.Message = ex.Message; } return(responseModel); }