Esempio n. 1
0
 private void MapCommonParameters(AnnouncementAddRequest model, SqlParameterCollection paramCollection)
 {
     paramCollection.AddWithValue("@title", model.Title);
     paramCollection.AddWithValue("@announcementCategoryId", model.AnnouncementCategoryId);
     paramCollection.AddWithValue("@body", model.Body);
     paramCollection.AddWithValue("@userId", UserService.GetCurrentUserId());
 }
Esempio n. 2
0
        public HttpResponseMessage Create(AnnouncementAddRequest model)
        {
            if (!ModelState.IsValid)
            {
                return(Request.CreateResponse(HttpStatusCode.BadRequest, ModelState));
            }

            if (model == null)
            {
                return(Request.CreateResponse(HttpStatusCode.BadRequest, "Required announcement inputs: Author, Title, Body, and Category."));
            }

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

            response.Item = _announcement.Insert(model); // update name to _announcment.

            return(Request.CreateResponse(HttpStatusCode.Created, response));
        }
Esempio n. 3
0
        public int Insert(AnnouncementAddRequest model)
        {
            int id = 0;

            DataProvider.ExecuteNonQuery(GetConnection, "dbo.Announcement_Insert"
                                         , inputParamMapper : delegate(SqlParameterCollection paramCollection)
            {
                MapCommonParameters(model, paramCollection);

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

                paramCollection.Add(p);
            }, returnParameters : delegate(SqlParameterCollection param)
            {
                int.TryParse(param["@id"].Value.ToString(), out id);
            }
                                         );

            return(id);
        }