/// <summary> /// Adds a new DateTime value to the list of query parameters. /// </summary> /// <param name="key">The parameter name.</param> /// <param name="value">The parameter value.</param> /// <returns>The statement builder, for chaining method calls.</returns> public StatementBuilder AddValue(string key, DateTime value) { DateTimeValue queryValue = new DateTimeValue(); queryValue.value = value; return(AddValue(key, queryValue)); }
/// <summary> /// Converts a System.DateTime object to a date object. /// </summary> /// <param name="dateTime">The DateTime object.</param> /// <returns>A Dfp Datetime object.</returns> public static DfpDateTime FromDateTime(System.DateTime dateTime) { DfpDateTime retval = new DfpDateTime(); retval.date = new Date(); retval.date.year = dateTime.Year; retval.date.month = dateTime.Month; retval.date.day = dateTime.Day; retval.hour = dateTime.Hour; retval.minute = dateTime.Minute; retval.second = dateTime.Second; return retval; }
private static bool DateTimeValuesAreEqual(Value value1, Value value2) { DateTime dateTime1 = (value1 as DateTimeValue).value; DateTime dateTime2 = (value2 as DateTimeValue).value; return(DatesAreEqual(dateTime1.date, dateTime2.date) && dateTime1.hour == dateTime2.hour && dateTime1.minute == dateTime2.minute && dateTime1.second == dateTime2.second && String.Equals(dateTime1.timeZoneID, dateTime2.timeZoneID)); }
/// <summary> /// Converts a System.DateTime object to a date object. /// </summary> /// <param name="dateTime">The DateTime object.</param> /// <returns>A Dfp Datetime object.</returns> public static DfpDateTime FromDateTime(System.DateTime dateTime) { DfpDateTime retval = new DfpDateTime(); retval.date = new Date(); retval.date.year = dateTime.Year; retval.date.month = dateTime.Month; retval.date.day = dateTime.Day; retval.hour = dateTime.Hour; retval.minute = dateTime.Minute; retval.second = dateTime.Second; return(retval); }
/// <summary> /// Run the code example. /// </summary> /// <param name="user">The DFP user object running the code example.</param> public override void Run(DfpUser user) { // Get the OrderService. LineItemService lineItemService = (LineItemService)user.GetService( DfpService.v201311.LineItemService); long orderId = long.Parse(_T("INSERT_ORDER_ID_HERE")); try { // Create statement to only select line items for the given order that // have been modified in the last 3 days. DateTime threeDaysAgo = DateTimeUtilities.FromDateTime(System.DateTime.Now.AddDays(-3)); Statement filterStatement = new StatementBuilder( "WHERE lastModifiedDateTime >= :lastModifiedDateTime AND orderId = :orderId LIMIT 500"). AddValue("lastModifiedDateTime", threeDaysAgo). AddValue("orderId", orderId).ToStatement(); // Get line items by statement. LineItemPage page = lineItemService.getLineItemsByStatement(filterStatement); // Display results. if (page != null && page.results != null) { foreach (LineItem lineItem in page.results) { Console.WriteLine("Line item with id \"{0}\", belonging to order id \"{1}\" and " + "named \"{2}\" was found.", lineItem.id, lineItem.orderId, lineItem.name); } Console.WriteLine("Number of results found: {1}.", page.totalResultSetSize); } else { Console.WriteLine("No line items were found."); } } catch (Exception ex) { Console.WriteLine("Failed to get line items. Exception says \"{0}\"", ex.Message); } }
/// <summary> /// Adds a new DateTime value to the list of query parameters. /// </summary> /// <param name="key">The parameter name.</param> /// <param name="value">The parameter value.</param> /// <returns>The statement builder, for chaining method calls.</returns> public StatementBuilder AddValue(string key, DateTime value) { DateTimeValue queryValue = new DateTimeValue(); queryValue.value = value; return AddValue(key, queryValue); }