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