public static string GetGalleryID(Member member, DefaultGalleryType GalleryType)
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("HG_GetGalleryID");
db.AddInParameter(dbCommand, "MemberID", DbType.Int32, member.MemberID);
//db.AddInParameter(dbCommand, "GalleryType", DbType.String, GalleryType);
string WebGalleryID = string.Empty;
//execute the stored procedure
using (IDataReader dr = db.ExecuteReader(dbCommand))
{
if (dr.Read())
{
WebGalleryID = (string)dr[0];
}
dr.Close();
}
return WebGalleryID;
}
public static string GetGalleryID(Member member, DefaultGalleryType GalleryType)
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("HG_GetGalleryID");
db.AddInParameter(dbCommand, "MemberID", DbType.Int32, member.MemberID);
//db.AddInParameter(dbCommand, "GalleryType", DbType.String, GalleryType);
string WebGalleryID = string.Empty;
//execute the stored procedure
using (IDataReader dr = db.ExecuteReader(dbCommand))
{
if (dr.Read())
{
WebGalleryID = (string)dr[0];
}
dr.Close();
}
return(WebGalleryID);
}
