/// <summary>
    /// Gets the text value of an unwrapped Value object.
    /// </summary>
    /// <param name="value">The unwrapped Value.</param>
    /// <returns>A formatted text representation of the value.</returns>
    /// <remarks>DateValue is formatted in yyyy-mm-dd format. DateTimeValue is
    /// formatted in yyyy-mm-dd HH:mm:ss Z format.</remarks>
    private static string GetTextValue(Object value) {
      if (value == null) {
        return "";
      }

      if (value is Google.Api.Ads.Dfp.v201608.Date) {
        Google.Api.Ads.Dfp.v201608.Date date =
            (Google.Api.Ads.Dfp.v201608.Date) value;
        return string.Format("{0:0000}-{1:00}-{2:00}",
            date.year,
            date.month,
            date.day);
      } else if (value is Google.Api.Ads.Dfp.v201608.DateTime) {
        Google.Api.Ads.Dfp.v201608.DateTime dateTime =
            (Google.Api.Ads.Dfp.v201608.DateTime) value;
        return string.Format("{0:0000}-{1:00}-{2:00}T{3:00}:{4:00}:{5:00} {6}",
            dateTime.date.year,
            dateTime.date.month,
            dateTime.date.day,
            dateTime.hour,
            dateTime.minute,
            dateTime.second,
            dateTime.timeZoneID);
      } else if (value is List<object>) {
        List<string> textValues = (value as List<object>)
            .ConvertAll(new Converter<object, string>(GetTextValue))
            .ConvertAll(new Converter<string, string>(EscapeCsv));
        return String.Join<string>(",", textValues);
      } else {
        // NumberValue, BooleanValue, TextValue
        return value.ToString();
      }
    }
        /// <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));
        }
        public void TestGetObjectDateTimeSetValue()
        {
            DateTime dateTime = new DateTime();
            Date     date     = new Date();

            date.year           = 2012;
            date.month          = 12;
            date.day            = 2;
            dateTime.date       = date;
            dateTime.hour       = 12;
            dateTime.minute     = 45;
            dateTime.second     = 0;
            dateTime.timeZoneID = "Asia/Shanghai";
            DateTimeValue dateTimeValue = new DateTimeValue();

            dateTimeValue.value = dateTime;

            SetValue setValue = new SetValue();

            setValue.values = new Value[] { dateTimeValue };
            List <object> value = PqlUtilities.GetValue(setValue) as List <object>;

            Assert.AreEqual(1, value.Count);
            Assert.True(value.Contains(dateTime));
        }
Esempio n. 4
0
        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));
        }
        public void TestFromString()
        {
            DateTime dfpDateTime = DateTimeUtilities.FromString("20150130 23:59:58", "America/New_York");

            Assert.AreEqual(dfpDateTime.date.year, 2015);
            Assert.AreEqual(dfpDateTime.date.month, 1);
            Assert.AreEqual(dfpDateTime.date.day, 30);
            Assert.AreEqual(dfpDateTime.hour, 23);
            Assert.AreEqual(dfpDateTime.minute, 59);
            Assert.AreEqual(dfpDateTime.second, 58);
            Assert.AreEqual(dfpDateTime.timeZoneID, "America/New_York");
        }
        public void TestFromDateTimeIgnoresSystemTimeZone()
        {
            System.DateTime dateTime    = new System.DateTime(2015, 1, 30, 23, 59, 58, DateTimeKind.Utc);
            DateTime        dfpDateTime = DateTimeUtilities.FromDateTime(dateTime, "America/New_York");

            Assert.AreEqual(dfpDateTime.date.year, 2015);
            Assert.AreEqual(dfpDateTime.date.month, 1);
            Assert.AreEqual(dfpDateTime.date.day, 30);
            Assert.AreEqual(dfpDateTime.hour, 23);
            Assert.AreEqual(dfpDateTime.minute, 59);
            Assert.AreEqual(dfpDateTime.second, 58);
            Assert.AreEqual(dfpDateTime.timeZoneID, "America/New_York");
        }
Esempio n. 7
0
        /// <summary>
        /// Run the code example.
        /// </summary>
        /// <param name="user">The DFP user object running the code example.</param>
        public void Run(DfpUser user, long proposalId)
        {
            ProposalService proposalService =
                (ProposalService)user.GetService(DfpService.v201608.ProposalService);

            // Create a statement to select Marketplace comments.
            StatementBuilder statementBuilder = new StatementBuilder()
                                                .Where("proposalId = :proposalId")
                                                .AddValue("proposalId", proposalId);

            // Retrieve a small amount of Marketplace comments at a time, paging through
            // until all Marketplace comments have been retrieved.
            MarketplaceCommentPage page = new MarketplaceCommentPage();

            try {
                do
                {
                    page = proposalService.getMarketplaceCommentsByStatement(statementBuilder.ToStatement());

                    if (page.results != null)
                    {
                        // Print out some information for each proposal.
                        int i = page.startIndex;
                        foreach (MarketplaceComment marketplaceComment in page.results)
                        {
                            Google.Api.Ads.Dfp.v201608.DateTime creationTime = marketplaceComment.creationTime;
                            string isoTimestamp = new System.DateTime(
                                day: creationTime.date.day,
                                month: creationTime.date.month,
                                year: creationTime.date.year,
                                hour: creationTime.hour,
                                minute: creationTime.minute,
                                second: creationTime.second
                                ).ToString("s");
                            Console.WriteLine("{0}) Marketplace comment with creation time \"{1}\" "
                                              + "and comment \"{2}\" was found.",
                                              i++,
                                              isoTimestamp,
                                              marketplaceComment.comment);
                        }
                    }

                    statementBuilder.IncreaseOffsetBy(StatementBuilder.SUGGESTED_PAGE_LIMIT);
                } while (statementBuilder.GetOffset() < page.totalResultSetSize);

                Console.WriteLine("Number of results found: {0}", page.totalResultSetSize);
            } catch (Exception e) {
                Console.WriteLine("Failed to get Marketplace comments. Exception says \"{0}\"",
                                  e.Message);
            }
        }
Esempio n. 8
0
        /// <summary>
        /// Converts a System.DateTime object to a Dfp DateTime object with the specified timeZoneId.
        /// Does not perform time zone conversion. This means the returned DateTime value
        /// may not represent the same instant as the System.DateTime value.
        /// </summary>
        /// <param name="dateTime">The DateTime object.</param>
        /// <param name="timeZoneId">The timeZoneId to use.</param>
        /// <returns>A Dfp Datetime object.</returns>
        public static DfpDateTime FromDateTime(System.DateTime dateTime, string timeZoneId)
        {
            PreconditionUtilities.CheckArgumentNotNull(dateTime, "dateTime");
            PreconditionUtilities.CheckArgumentNotNull(timeZoneId, "timeZoneId");

            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;
            retval.timeZoneID = timeZoneId;
            return(retval);
        }
        public void TestGetObjectDateTimeValue()
        {
            DateTime dateTime = new DateTime();
            Date     date     = new Date();

            date.year           = 2012;
            date.month          = 12;
            date.day            = 2;
            dateTime.date       = date;
            dateTime.hour       = 12;
            dateTime.minute     = 45;
            dateTime.second     = 0;
            dateTime.timeZoneID = "Asia/Shanghai";
            DateTimeValue dateTimeValue = new DateTimeValue();

            dateTimeValue.value = dateTime;
            Assert.AreEqual(dateTime, PqlUtilities.GetValue(dateTimeValue));
        }
        public void TestGetObjectDateSetValue()
        {
            DateTime dateTime = new DateTime();
            Date     date     = new Date();

            date.year  = 2012;
            date.month = 12;
            date.day   = 2;
            DateValue dateValue = new DateValue();

            dateValue.value = date;

            SetValue setValue = new SetValue();

            setValue.values = new Value[] { dateValue };
            List <object> value = PqlUtilities.GetValue(setValue) as List <object>;

            Assert.AreEqual(1, value.Count);
            Assert.True(value.Contains(date));
        }