Пример #1
0
        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));
            }
        }
Пример #2
0
        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);
        }