Example #1
0
 private void _initfromRow(SqlDataReader dr)
 {
     FrameId = dr.IntOrZero("FrameId");
     PanelId = dr.IntOrZero("PanelId");
     Duration = dr.IntOrDefault("Duration", 60);
     Sort = dr.IntOrZero("Sort");
     BeginsOn = dr.AsNullable<DateTime>("BeginsOn");
     EndsOn = dr.AsNullable<DateTime>("EndsOn");
     DateCreated = dr.AsNullable<DateTime>("DateCreated");
     TemplateName = dr.StringOrDefault("TemplateName", "default");
     Html = dr.StringOrBlank("Html");
     FrameType = (FrameTypes)dr.IntOrZero("FrameType");
     CacheInterval = dr.IntOrZero("CacheInterval");
     CacheInterval = CacheInterval < 0 ? 0 : CacheInterval;
     Version = BitConverter.ToUInt64(dr.ValueOrNull<byte[]>("Version"), 0);       // is never a null
 }
Example #2
0
        private void _initFromRow(SqlDataReader r)
        {
            LocationId = r.IntOrZero("LocationId");
            LevelId = r.IntOrZero("LevelId");
            TemperatureUnit = r.StringOrDefault("TemperatureUnit", "C").ToLower();
            DateFormat = r.StringOrDefault("DateFormat", "LL");
            TimeFormat = r.StringOrDefault("TimeFormat", "LT");
            Latitude = r.ValueOrDefault<double>("Latitude", ServerGeoData.Latitude);
            Longitude = r.ValueOrDefault<double>("Longitude", ServerGeoData.Longitude);
            Woeid = r.IntOrZero("Woeid");
            Culture = r.StringOrBlank("Culture");

            Name = r.StringOrBlank("Name");
            if (Name == "")
                Name = string.Format("Location {0}", LocationId);

            TimeZone = TimeZoneInfo.FindSystemTimeZoneById(
                r.StringOrDefault("TimeZone", ServerGeoData.TimeZone.Id)
                );
        }