public HttpResponseMessage Insert(PrivacyAddRequest model)
        {
            if (!ModelState.IsValid)
            {
                return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
            }
            try
            {
                ItemResponse <int> resp = new ItemResponse <int>();
                resp.Item = _PrivacyService.Insert(model);

                return(Request.CreateResponse(HttpStatusCode.OK, resp));
            }
            catch (Exception ex)
            {
                return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
            }
        }
        public int Insert(PrivacyAddRequest model)
        {
            int id = 0;

            DataProvider.ExecuteNonQuery("dbo.Privacy_Insert"
                                         , inputParamMapper : delegate(SqlParameterCollection paramCollection)
            {
                paramCollection.AddWithValue("@ParentId", model.ParentId);
                paramCollection.AddWithValue("@DisplayOrder", model.DisplayOrder);
                paramCollection.AddWithValue("@Title", (Object)model.Title ?? DBNull.Value);
                paramCollection.AddWithValue("@Description", (Object)model.Description ?? DBNull.Value);
                paramCollection.AddWithValue("@ModifiedBy", model.ModifiedBy);

                SqlParameter idParameter = new SqlParameter("@Id", System.Data.SqlDbType.Int);
                idParameter.Direction    = System.Data.ParameterDirection.Output;

                paramCollection.Add(idParameter);
            }
                                         , returnParameters : delegate(SqlParameterCollection param)
            {
                Int32.TryParse(param["@Id"].Value.ToString(), out id);
            });
            return(id);
        }