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