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
}
private void _initFromRow(SqlDataReader r)
{
PanelId = r.IntOrZero("PanelId");
Top = r.IntOrZero("Top");
Left = r.IntOrZero("Left");
Width = r.IntOrZero("Width");
Height = r.IntOrZero("Height");
FadeLength = r.ValueOrDefault<double>("FadeLength", 0);
Name = r.StringOrBlank("Name").Trim();
if (Name == "")
Name = string.Format("Panel {0}", PanelId);
}
private void _initFromRow(SqlDataReader r)
{
DisplayId = r.IntOrZero("DisplayId");
CanvasId = r.IntOrZero("CanvasId");
LocationId = r.IntOrZero("LocationId");
Host = r.StringOrBlank("Host").Trim();
NoScroll = r.Boolean("NoScroll");
NoCursor = r.Boolean("NoCursor");
ReadyTimeout = r.IntOrZero("ReadyTimeout");
PollInterval = r.IntOrZero("PollInterval");
ErrorLength = r.IntOrZero("ErrorLength");
Name = r.StringOrBlank("Name").Trim();
if (Name == "")
Name = string.Format("Display {0}", DisplayId);
if (r["RecycleTime"] != DBNull.Value)
{
RecycleTime = (TimeSpan)r["RecycleTime"];
}
}
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)
);
}
