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));
        }
        /// <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));
        }
Exemplo n.º 3
0
        /// <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.AdManager.v201908.Date)
            {
                Google.Api.Ads.AdManager.v201908.Date date =
                    (Google.Api.Ads.AdManager.v201908.Date)value;
                return(string.Format("{0:0000}-{1:00}-{2:00}", date.year, date.month, date.day));
            }
            else if (value is Google.Api.Ads.AdManager.v201908.DateTime)
            {
                Google.Api.Ads.AdManager.v201908.DateTime dateTime =
                    (Google.Api.Ads.AdManager.v201908.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>
        /// Formats the value of the DFP date time using the specified
        /// <see href="https://nodatime.org/2.3.x/userguide/localdatetime-patterns">
        /// NodaTime compatible</see> format.
        /// </summary>
        public static string ToString(AdManagerDateTime dateTime, string patternText,
                                      IFormatProvider formatProvider)
        {
            LocalDateTime localDateTime = new LocalDateTime(dateTime.date.year, dateTime.date.month,
                                                            dateTime.date.day, dateTime.hour, dateTime.minute, dateTime.second);
            DateTimeZone timeZone = DateTimeZoneProviders.Tzdb[dateTime.timeZoneId];

            return(timeZone.AtLeniently(localDateTime).ToString(patternText, formatProvider));
        }
        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");
        }
        /// <summary>
        /// Converts a System.DateTime object to a AdManager 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 AdManager Datetime object.</returns>
        public static AdManagerDateTime FromDateTime(System.DateTime dateTime, string timeZoneId)
        {
            PreconditionUtilities.CheckArgumentNotNull(dateTime, "dateTime");
            PreconditionUtilities.CheckArgumentNotNull(timeZoneId, "timeZoneId");

            AdManagerDateTime retval = new AdManagerDateTime();

            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));
        }
 /// <summary>
 /// Formats the value of the DFP date time using the specified
 /// <see href="https://nodatime.org/2.3.x/userguide/localdatetime-patterns">
 /// NodaTime compatible</see> format.
 /// </summary>
 public static string ToString(AdManagerDateTime dateTime, string patternText)
 {
     return(ToString(dateTime, patternText, null));
 }