public HttpResponseMessage MyBlogPost(MyBlogDomain model)
{
ItemResponse <int> resp = new ItemResponse <int>();
resp.Item = _userService.MyBlogPost(model);
return(Request.CreateResponse(HttpStatusCode.OK, resp));
}
public int MyBlogPost(MyBlogDomain model)
{
int Id = 0;
_dataProvider.ExecuteNonQuery(
"BlogPost_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("@Header", model.Header);
paramCol.AddWithValue("@Description", model.Description);
paramCol.AddWithValue("@BlogPost", model.BlogPost);
paramCol.AddWithValue("@Image", model.Image);
},
returnParameters : delegate(SqlParameterCollection paramCol)
{
Id = (int)paramCol["@Id"].Value;
}
);
return(Id);
}
public static MyBlogDomain DisplayMyPostsMapper(IDataReader reader)
{
MyBlogDomain model = new MyBlogDomain();
int index = 0;
model.Id = reader.GetInt32(index++);
model.Header = reader.GetString(index++);
model.Description = reader.GetString(index++);
model.BlogPost = reader.GetString(index++);
model.Image = reader.GetString(index++);
return(model);
}
public List <MyBlogDomain> DisplayMyPosts()
{
List <MyBlogDomain> result = new List <MyBlogDomain>();
_dataProvider.ExecuteCmd(
"BlogPost_SelectAll",
inputParamMapper : null,
singleRecordMapper : delegate(IDataReader reader, short set)
{
MyBlogDomain model = DisplayMyPostsMapper(reader);
result.Add(model);
}
);
return(result);
}
public MyBlogDomain SelectMyBlogById(int id)
{
MyBlogDomain model = null;
_dataProvider.ExecuteCmd(
"BlogPost_SelectById",
inputParamMapper : delegate(SqlParameterCollection paramCol)
{
paramCol.AddWithValue("@Id", id);
},
singleRecordMapper : delegate(IDataReader reader, short set)
{
model = DisplayMyPostsMapper(reader);
}
);
return(model);
}
