protected void PopulateRequestedAds(AdMatch current_match) { //Create the output table to list requested ads . DataTable adList = new DataTable(); adList.Columns.Add("uploadedad_id"); adList.Columns.Add("admatch_id"); adList.Columns.Add("title"); adList.Columns.Add("data"); adList.Columns.Add("num_wanted"); adList.Columns.Add("num_printed"); adList.Columns.Add("daily_quota"); foreach (RequestedAd ad_item in current_match.RequestedAdsByadmatch_) { DataRow new_row = adList.NewRow(); new_row["uploadedad_id"] = ad_item.uploadedad_id; new_row["admatch_id"] = ad_item.admatch_id; new_row["title"] = ad_item.uploadedad_.title; new_row["data"] = ad_item.uploadedad_.data; new_row["num_wanted"] = ad_item.num_wanted; new_row["num_printed"] = ad_item.num_printed; new_row["daily_quota"] = ad_item.daily_quota; adList.Rows.Add(new_row); } RequestedAdsListView.DataSource = adList; RequestedAdsListView.DataBind(); }
/// <summary> /// Gets a collection of RequestedAd objects by a AdMatch object. /// </summary> /// <param name="adMatch">adMatch</param> /// <param name="orderBy"></param> /// <param name="startRowIndex"></param> /// <param name="pageSize"></param> /// <param name="totalRows"></param> /// <returns>A collection RequestedAd objects.</returns> protected static EntityList<RequestedAd> GetRequestedAdsByadmatch_(AdMatch @admatch_, string orderBy, long startRowIndex, int pageSize, out long totalRows) { string commandText = @" FROM [dbo].[RequestedAds] WHERE [RequestedAds].[admatch_id] = @admatch_id "; List<SqlParameter> parameters = new List<SqlParameter>(); parameters.Add(new SqlParameter("@admatch_id", @admatch_.admatch_id)); return GetList<RequestedAd>(SelectFieldList, commandText, parameters, orderBy, startRowIndex, pageSize, out totalRows); }
/// <summary> /// Gets a collection of RequestedAd objects by a AdMatch object. /// </summary> /// <param name="admatch_">admatch_</param> /// <returns>A collection RequestedAd objects.</returns> public static EntityList<RequestedAd> GetRequestedAdsByadmatch_(AdMatch @admatch_) { string commandText = "RequestedAdGetByAdMatch"; List<SqlParameter> parameters = new List<SqlParameter>(); parameters.Add(new SqlParameter("@admatch_id", @admatch_.admatch_id)); return GetList<RequestedAd>(@admatch_, commandText, parameters); }
/// <summary> /// Deletes RequestedAd objects by a AdMatch object. /// </summary> /// <param name="adMatch">adMatch</param> public static void DeleteRequestedAdsByadmatch_(AdMatch adMatch) { string commandText = "RequestedAdDeleteByAdMatch"; System.Collections.Generic.List<SqlParameter> parameters = new System.Collections.Generic.List<SqlParameter>(); parameters.Add(new SqlParameter("@admatch_id", adMatch.admatch_id)); using (SqlHelper helper = new SqlHelper()) { helper.Execute(commandText, CommandType.StoredProcedure, parameters); } }
/// <summary> /// Create a new RequestedAd object from a AdMatch object. /// </summary> /// <param name="admatch_">admatch_</param> /// <returns>The newly created RequestedAd object.</returns> public static RequestedAd CreateRequestedAdByadmatch_(AdMatch @admatch_) { RequestedAd requestedAd = InitializeNew<RequestedAd>(); requestedAd.admatch_id = @admatch_.admatch_id; requestedAd.admatch_ = @admatch_; return requestedAd; }
/// <summary> /// Gets a collection of PlacedAd objects by a AdMatch object. /// </summary> /// <param name="adMatch">adMatch</param> /// <param name="startRowIndex"></param> /// <param name="pageSize"></param> /// <param name="totalRows"></param> /// <returns>A collection PlacedAd objects.</returns> public static EntityList<PlacedAd> GetPlacedAdsByadmatch_(AdMatch @admatch_, long startRowIndex, int pageSize, out long totalRows) { string commandText = @" FROM [dbo].[PlacedAds] WHERE [PlacedAds].[admatch_id] = @admatch_id "; List<SqlParameter> parameters = new List<SqlParameter>(); parameters.Add(new SqlParameter("@admatch_id", @admatch_.admatch_id)); return GetList<PlacedAd>(SelectFieldList, commandText, parameters, null, startRowIndex, pageSize, out totalRows); }
/// <summary> /// Create a new PlacedAd object from a AdMatch object. /// </summary> /// <param name="admatch_">admatch_</param> /// <returns>The newly created PlacedAd object.</returns> public static PlacedAd CreatePlacedAdByadmatch_(AdMatch @admatch_) { PlacedAd placedAd = InitializeNew<PlacedAd>(); placedAd.admatch_id = @admatch_.admatch_id; placedAd.admatch_ = @admatch_; return placedAd; }