public int Insert(SocialMediaAddRequest model) { int id = 0; this.DataProvider.ExecuteNonQuery( "SocialMedia_Insert", inputParamMapper : delegate(SqlParameterCollection paramCol) { SqlParameter parm = new SqlParameter(); parm.ParameterName = "@Id"; parm.SqlDbType = System.Data.SqlDbType.Int; parm.Direction = System.Data.ParameterDirection.Output; paramCol.Add(parm); paramCol.AddWithValue("@UserId", model.UserId); paramCol.AddWithValue("@Url", model.Url); paramCol.AddWithValue("@SocialMediaTypeId", model.SocialMediaTypeId); paramCol.AddWithValue("@ModifiedBy", model.ModifiedBy); }, returnParameters : delegate(SqlParameterCollection paramCol) { id = (int)paramCol["@Id"].Value; } ); return(id); }
public HttpResponseMessage Post(SocialMediaAddRequest model) { try { if (ModelState.IsValid) { IUserAuthData currentUser = _principal.Identity.GetCurrentUser(); model.ModifiedBy = currentUser.Name; int id = _socialMediaServices.Insert(model); ItemResponse <int> resp = new ItemResponse <int>(); resp.Item = id; return(Request.CreateResponse(System.Net.HttpStatusCode.OK, resp)); } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, ModelState)); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }