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));
}
}
