public static Banner GetBannerByWebBannerID(string WebBannerID)
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("HG_GetBannerByWebBannerID");
db.AddInParameter(dbCommand, "WebBannerID", DbType.String, WebBannerID);
Banner banner = new Banner();
using (IDataReader dr = db.ExecuteReader(dbCommand))
{
banner = Banner.PopulateSingleObject(dr);
dr.Close();
}
return(banner);
}
public static Banner GetNextBanner(BannerType bannerType, string URL)
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("HG_GetNextBanner");
db.AddInParameter(dbCommand, "BannerType", DbType.Int32, bannerType);
db.AddInParameter(dbCommand, "URL", DbType.String, URL);
Banner banner = new Banner();
using (IDataReader dr = db.ExecuteReader(dbCommand))
{
banner = Banner.PopulateSingleObject(dr);
dr.Close();
}
return(banner);
}
