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; }
/// <summary> /// Takes an prepopulated IDataReader and creates an array of Banners /// </summary> public static List<Banner> PopulateObject(IDataReader dr) { ColumnFieldList list = new ColumnFieldList(dr); List<Banner> arr = new List<Banner>(); Banner obj; while (dr.Read()) { obj = new Banner(); if (list.IsColumnPresent("BannerID")) { obj._bannerID = (int)dr["BannerID"]; } if (list.IsColumnPresent("WebBannerID")) { obj._webBannerID = (string)dr["WebBannerID"]; } if (list.IsColumnPresent("IMSPlanID")) { obj._iMSPlanID = (int)dr["IMSPlanID"]; } if (list.IsColumnPresent("FileLocation")) { obj._fileLocation = (string)dr["FileLocation"]; } if (list.IsColumnPresent("BannerType")) { obj._bannerType = (int)dr["BannerType"]; } if (list.IsColumnPresent("ClickThroughURL")) { obj._clickThroughURL = (string)dr["ClickThroughURL"]; } if (list.IsColumnPresent("TotalImpressions")) { obj._totalImpressions = (int)dr["TotalImpressions"]; } if (list.IsColumnPresent("TotalClicks")) { obj._totalClicks = (int)dr["TotalClicks"]; } arr.Add(obj); } dr.Close(); return arr; }