public void UpdateProfilePhoto(BlogsMediaRequestModel model)
{
DataProvider.ExecuteNonQuery(GetConnection, "dbo.Blogs_MediaUpdate"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@BlogId", model.BlogId);
paramCollection.AddWithValue("@MediaId", model.MediaId);
}, returnParameters : delegate(SqlParameterCollection param) { }
);
}
public int Insert(BlogsMediaRequestModel model)
{
int uid = 0;
DataProvider.ExecuteNonQuery(GetConnection, "dbo.BlogsMedia_Insert"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@BlogId", model.BlogId);
paramCollection.AddWithValue("@MediaId", model.MediaId);
paramCollection.AddWithValue("@IsCoverPhoto", model.IsCoverPhoto);
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 uid);
}
);
return(uid);
}
