public IEnumerable <ProposalLineItem> GetByParentId(int id)
{
using (var db = DBConnection.GetConnection())
{
return(ProposalLineItem.GetByProposalId(db, id));
}
}
public bool Delete(ProposalLineItem j)
{
using (var db = DBConnection.GetConnection())
{
return(ProposalLineItem.Delete <ProposalLineItem>(db, j));
}
}
public bool Post([FromBody] ProposalLineItem j)
{
using (var db = DBConnection.GetConnection())
{
return(ProposalLineItem.Persist <ProposalLineItem>(db, j));
}
}
public ProposalLineItem Get(int id)
{
using (var db = DBConnection.GetConnection())
{
return(ProposalLineItem.GetById <ProposalLineItem>(db, id));
}
}
public IEnumerable <ProposalLineItem> Get()
{
using (var db = DBConnection.GetConnection())
{
return(ProposalLineItem.GetAll <ProposalLineItem>(db));
}
}
/// <summary>
/// Run the code examples.
/// </summary>
public void Run(DfpUser user, long proposalId, long rateCardId, long productId)
{
using (ProposalLineItemService proposalLineItemService =
(ProposalLineItemService)user.GetService(DfpService.v201805.ProposalLineItemService)) {
// Create a proposal line item.
ProposalLineItem proposalLineItem = new ProposalLineItem();
proposalLineItem.name =
"Programmatic proposal line item #" + new Random().Next(int.MaxValue);
proposalLineItem.proposalId = proposalId;
proposalLineItem.rateCardId = rateCardId;
proposalLineItem.productId = productId;
// Set the Marketplace information.
proposalLineItem.marketplaceInfo = new ProposalLineItemMarketplaceInfo()
{
adExchangeEnvironment = AdExchangeEnvironment.DISPLAY
};
// Set the length of the proposal line item to run.
proposalLineItem.startDateTime =
DateTimeUtilities.FromDateTime(System.DateTime.Now.AddDays(7), "America/New_York");
proposalLineItem.endDateTime =
DateTimeUtilities.FromDateTime(System.DateTime.Now.AddDays(30), "America/New_York");
// Set pricing for the proposal line item for 1000 impressions at a CPM of $2
// for a total value of $2.
proposalLineItem.goal = new Goal()
{
unitType = UnitType.IMPRESSIONS,
units = 1000L
};
proposalLineItem.netCost = new Money()
{
currencyCode = "USD", microAmount = 2000000L
};
proposalLineItem.netRate = new Money()
{
currencyCode = "USD", microAmount = 2000000L
};
proposalLineItem.rateType = RateType.CPM;
try {
// Create the proposal line item on the server.
ProposalLineItem[] proposalLineItems = proposalLineItemService.createProposalLineItems(
new ProposalLineItem[] { proposalLineItem });
foreach (ProposalLineItem createdProposalLineItem in proposalLineItems)
{
Console.WriteLine("A programmatic proposal line item with ID \"{0}\" "
+ "and name \"{1}\" was created.",
createdProposalLineItem.id,
createdProposalLineItem.name);
}
} catch (Exception e) {
Console.WriteLine("Failed to create proposal line items. Exception says \"{0}\"",
e.Message);
}
}
}
/// <summary>
/// Run the code example.
/// </summary>
public void Run(DfpUser user)
{
using (ProposalLineItemService proposalLineItemService =
(ProposalLineItemService)user.GetService(
DfpService.v201802.ProposalLineItemService))
{
// Set the ID of the proposal line item.
long proposalLineItemId = long.Parse(_T("INSERT_PROPOSAL_LINE_ITEM_ID_HERE"));
// Create a statement to get the proposal line item.
StatementBuilder statementBuilder = new StatementBuilder()
.Where("id = :proposalLineItemId").OrderBy("id ASC").Limit(1)
.AddValue("proposalLineItemId", proposalLineItemId);
try
{
// Get proposal line items by statement.
ProposalLineItemPage page =
proposalLineItemService.getProposalLineItemsByStatement(
statementBuilder.ToStatement());
ProposalLineItem proposalLineItem = page.results[0];
// Update proposal line item notes.
proposalLineItem.internalNotes = "Proposal line item ready for submission";
// Update the proposal line item on the server.
ProposalLineItem[] proposalLineItems =
proposalLineItemService.updateProposalLineItems(new ProposalLineItem[]
{
proposalLineItem
});
if (proposalLineItems != null)
{
foreach (ProposalLineItem updatedProposalLineItem in proposalLineItems)
{
Console.WriteLine(
"A proposal line item with ID = '{0}' and name '{1}' was updated.",
updatedProposalLineItem.id, updatedProposalLineItem.name);
}
}
else
{
Console.WriteLine("No proposal line items updated.");
}
}
catch (Exception e)
{
Console.WriteLine(
"Failed to update proposal line items. Exception says \"{0}\"", e.Message);
}
}
}
/// <summary>
/// Run the code examples.
/// </summary>
public void Run(AdManagerUser user)
{
using (ProposalLineItemService proposalLineItemService =
user.GetService <ProposalLineItemService>())
using (NetworkService networkService = user.GetService <NetworkService>())
{
long proposalId = long.Parse(_T("INSERT_PROPOSAL_ID_HERE"));
long rateCardId = long.Parse(_T("INSERT_RATE_CARD_ID_HERE"));
long productId = long.Parse(_T("INSERT_PRODUCT_ID_HERE"));
// Get the root ad unit ID used to target the whole site.
String rootAdUnitId = networkService.getCurrentNetwork().effectiveRootAdUnitId;
// Create inventory targeting.
InventoryTargeting inventoryTargeting = new InventoryTargeting();
// Create ad unit targeting for the root ad unit (i.e. the whole network).
AdUnitTargeting adUnitTargeting = new AdUnitTargeting();
adUnitTargeting.adUnitId = rootAdUnitId;
adUnitTargeting.includeDescendants = true;
inventoryTargeting.targetedAdUnits = new AdUnitTargeting[]
{
adUnitTargeting
};
// Create targeting.
Targeting targeting = new Targeting();
targeting.inventoryTargeting = inventoryTargeting;
// Create a proposal line item.
ProposalLineItem proposalLineItem = new ProposalLineItem();
proposalLineItem.name =
"Proposal line item #" + new Random().Next(int.MaxValue);
proposalLineItem.proposalId = proposalId;
proposalLineItem.rateCardId = rateCardId;
proposalLineItem.productId = productId;
proposalLineItem.targeting = targeting;
// Set the length of the proposal line item to run.
proposalLineItem.startDateTime =
DateTimeUtilities.FromDateTime(System.DateTime.Now.AddDays(7),
"America/New_York");
proposalLineItem.endDateTime =
DateTimeUtilities.FromDateTime(System.DateTime.Now.AddDays(30),
"America/New_York");
// Set delivery specifications for the proposal line item.
proposalLineItem.deliveryRateType = DeliveryRateType.EVENLY;
proposalLineItem.creativeRotationType = CreativeRotationType.OPTIMIZED;
// Set billing specifications for the proposal line item.
proposalLineItem.billingCap = BillingCap.CAPPED_CUMULATIVE;
proposalLineItem.billingSource = BillingSource.THIRD_PARTY_VOLUME;
// Set pricing for the proposal line item for 1000 impressions at a CPM of $2
// for a total value of $2.
proposalLineItem.goal = new Goal()
{
unitType = UnitType.IMPRESSIONS,
units = 1000L
};
proposalLineItem.netCost = new Money()
{
currencyCode = "USD",
microAmount = 2000000L
};
proposalLineItem.netRate = new Money()
{
currencyCode = "USD",
microAmount = 2000000L
};
proposalLineItem.rateType = RateType.CPM;
try
{
// Create the proposal line item on the server.
ProposalLineItem[] proposalLineItems =
proposalLineItemService.createProposalLineItems(new ProposalLineItem[]
{
proposalLineItem
});
foreach (ProposalLineItem createdProposalLineItem in proposalLineItems)
{
Console.WriteLine(
"A proposal line item with ID \"{0}\" and name \"{1}\" was " +
"created.",
createdProposalLineItem.id, createdProposalLineItem.name);
}
}
catch (Exception e)
{
Console.WriteLine(
"Failed to create proposal line items. Exception says \"{0}\"",
e.Message);
}
}
}
/// <summary>
/// Run the code examples.
/// </summary>
public void Run(AdManagerUser user, long proposalId)
{
using (ProposalLineItemService proposalLineItemService =
user.GetService <ProposalLineItemService>())
using (NetworkService networkService = user.GetService <NetworkService>())
{
ProposalLineItem proposalLineItem = new ProposalLineItem();
proposalLineItem.name = "Programmatic proposal line item #" +
new Random().Next(int.MaxValue);
proposalLineItem.proposalId = proposalId;
proposalLineItem.lineItemType = LineItemType.STANDARD;
// Set required Marketplace information.
proposalLineItem.marketplaceInfo = new ProposalLineItemMarketplaceInfo()
{
adExchangeEnvironment = AdExchangeEnvironment.DISPLAY
};
// Get the root ad unit ID used to target the whole site.
String rootAdUnitId = networkService.getCurrentNetwork().effectiveRootAdUnitId;
// Create inventory targeting.
InventoryTargeting inventoryTargeting = new InventoryTargeting();
// Create ad unit targeting for the root ad unit (i.e. the whole network).
AdUnitTargeting adUnitTargeting = new AdUnitTargeting();
adUnitTargeting.adUnitId = rootAdUnitId;
adUnitTargeting.includeDescendants = true;
inventoryTargeting.targetedAdUnits = new AdUnitTargeting[]
{
adUnitTargeting
};
// Create targeting.
Targeting targeting = new Targeting();
targeting.inventoryTargeting = inventoryTargeting;
proposalLineItem.targeting = targeting;
// Create creative placeholder.
Size size = new Size()
{
width = 300,
height = 250,
isAspectRatio = false
};
CreativePlaceholder creativePlaceholder = new CreativePlaceholder();
creativePlaceholder.size = size;
proposalLineItem.creativePlaceholders = new CreativePlaceholder[]
{
creativePlaceholder
};
// Set the length of the proposal line item to run.
proposalLineItem.startDateTime =
DateTimeUtilities.FromDateTime(System.DateTime.Now.AddDays(7),
"America/New_York");
proposalLineItem.endDateTime =
DateTimeUtilities.FromDateTime(System.DateTime.Now.AddDays(30),
"America/New_York");
// Set delivery specifications for the proposal line item.
proposalLineItem.deliveryRateType = DeliveryRateType.EVENLY;
// Set pricing for the proposal line item for 1000 impressions at a CPM of $2
// for a total value of $2.
proposalLineItem.goal = new Goal()
{
unitType = UnitType.IMPRESSIONS,
units = 1000L
};
proposalLineItem.netCost = new Money()
{
currencyCode = "USD",
microAmount = 2000000L
};
proposalLineItem.netRate = new Money()
{
currencyCode = "USD",
microAmount = 2000000L
};
proposalLineItem.rateType = RateType.CPM;
try
{
// Create the proposal line item on the server.
ProposalLineItem[] proposalLineItems =
proposalLineItemService.createProposalLineItems(new ProposalLineItem[]
{
proposalLineItem
});
foreach (ProposalLineItem createdProposalLineItem in proposalLineItems)
{
Console.WriteLine(
"A programmatic proposal line item with ID \"{0}\" " +
"and name \"{1}\" was created.", createdProposalLineItem.id,
createdProposalLineItem.name);
}
}
catch (Exception e)
{
Console.WriteLine(
"Failed to create programmatic proposal line items. " +
"Exception says \"{0}\"", e.Message);
}
}
}
/// <summary>
/// Run the code examples.
/// </summary>
/// <param name="user">The DFP user object running the code examples.</param>
public override void Run(DfpUser user) {
// [START get_proposal_line_item_service] MOE:strip_line
// Get the ProposalLineItemService.
ProposalLineItemService proposalLineItemService =
(ProposalLineItemService) user.GetService(DfpService.v201508.ProposalLineItemService);
// [END get_proposal_line_item_service] MOE:strip_line
// Get the NetworkService.
NetworkService networkService =
(NetworkService) user.GetService(DfpService.v201508.NetworkService);
long proposalId = long.Parse(_T("INSERT_PROPOSAL_ID_HERE"));
long rateCardId = long.Parse(_T("INSERT_RATE_CARD_ID_HERE"));
long productId = long.Parse(_T("INSERT_PRODUCT_ID_HERE"));
// [START add_targeting] MOE:strip_line
// Get the root ad unit ID used to target the whole site.
String rootAdUnitId = networkService.getCurrentNetwork().effectiveRootAdUnitId;
// Create inventory targeting.
InventoryTargeting inventoryTargeting = new InventoryTargeting();
// Create ad unit targeting for the root ad unit (i.e. the whole network).
AdUnitTargeting adUnitTargeting = new AdUnitTargeting();
adUnitTargeting.adUnitId = rootAdUnitId;
adUnitTargeting.includeDescendants = true;
inventoryTargeting.targetedAdUnits = new AdUnitTargeting[] {adUnitTargeting};
// Create targeting.
Targeting targeting = new Targeting();
targeting.inventoryTargeting = inventoryTargeting;
// [END add_targeting] MOE:strip_line
// [START create_proposal_line_item_local] MOE:strip_line
// Create a proposal line item.
ProposalLineItem proposalLineItem = new ProposalLineItem();
proposalLineItem.name = "Proposal line item #" + new Random().Next(int.MaxValue);
// [END create_proposal_line_item_local] MOE:strip_line
// [START set_required_creation_fields] MOE:strip_line
proposalLineItem.proposalId = proposalId;
proposalLineItem.rateCardId = rateCardId;
proposalLineItem.productId = productId;
proposalLineItem.targeting = targeting;
// [END set_required_creation_fields] MOE:strip_line
// [START set_dates] MOE:strip_line
// Set the length of the proposal line item to run.
proposalLineItem.startDateTime =
DateTimeUtilities.FromDateTime(System.DateTime.Now.AddDays(7), "America/New_York");
proposalLineItem.endDateTime =
DateTimeUtilities.FromDateTime(System.DateTime.Now.AddDays(30), "America/New_York");
// [END set_dates] MOE:strip_line
// [START set_delivery_info] MOE:strip_line
// Set delivery specifications for the proposal line item.
proposalLineItem.deliveryRateType = DeliveryRateType.EVENLY;
proposalLineItem.creativeRotationType = CreativeRotationType.OPTIMIZED;
// [END set_delivery_info] MOE:strip_line
// [START set_billing] MOE:strip_line
// Set billing specifications for the proposal line item.
proposalLineItem.billingCap = BillingCap.CAPPED_CUMULATIVE;
proposalLineItem.billingSource = BillingSource.THIRD_PARTY_VOLUME;
// [END set_billing] MOE:strip_line
// [START set_goal] MOE:strip_line
// Set pricing for the proposal line item for 1000 impressions at a CPM of $2
// for a total value of $2.
proposalLineItem.goal = new Goal() {unitType = UnitType.IMPRESSIONS, units = 1000L};
// [END set_goal] MOE:strip_line
// [START set_costs] MOE:strip_line
proposalLineItem.cost = new Money() {currencyCode = "USD", microAmount = 2000000L};
proposalLineItem.costPerUnit = new Money() {currencyCode = "USD", microAmount = 2000000L};
proposalLineItem.rateType = RateType.CPM;
// [END set_costs] MOE:strip_line
try {
// [START create_proposal_line_item_server] MOE:strip_line
// Create the proposal line item on the server.
ProposalLineItem[] proposalLineItems = proposalLineItemService.createProposalLineItems(
new ProposalLineItem[] {proposalLineItem});
// [END create_proposal_line_item_server] MOE:strip_line
foreach (ProposalLineItem createdProposalLineItem in proposalLineItems) {
Console.WriteLine("A proposal line item with ID \"{0}\" and name \"{1}\" was created.",
createdProposalLineItem.id, createdProposalLineItem.name);
}
} catch (Exception e) {
Console.WriteLine("Failed to create proposal line items. Exception says \"{0}\"",
e.Message);
}
}
