Esempio n. 1
0
        public int AddFaq(HelpInsertRequest model)
        {
            int uid = 0;

            DataProvider.ExecuteNonQuery(GetConnection, "dbo.Help_Insert"
                                         , inputParamMapper : delegate(SqlParameterCollection paramCollection)
            {
                SqlParameter p = new SqlParameter("@Id", System.Data.SqlDbType.Int);
                p.Direction    = System.Data.ParameterDirection.Output;

                paramCollection.Add(p);

                paramCollection.AddWithValue("@SortOrder", model.SortOrder);
                paramCollection.AddWithValue("@WebsiteId", model.WebsiteId);
                paramCollection.AddWithValue("@Question", model.Question);
                paramCollection.AddWithValue("@Answer", model.Answer);
            }, returnParameters : delegate(SqlParameterCollection param)
            {
                int.TryParse(param["@Id"].Value.ToString(), out uid);
            }
                                         );


            return(uid);
        }
Esempio n. 2
0
        public HttpResponseMessage InsertHelp(HelpInsertRequest model)
        {
            if (!ModelState.IsValid)
            {
                return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
            }

            int id = _HelpService.AddFaq(model);

            ItemResponse <int> response = new ItemResponse <int>();

            response.Item = id;

            return(Request.CreateResponse(HttpStatusCode.OK, response));
        }