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