private void _init() { using (SqlCommand cmd = new SqlCommand() { CommandType = CommandType.Text, CommandText = "SELECT TOP 1 * FROM Weather WHERE FrameId=@frameId", }) { cmd.Parameters.AddWithValue("@frameId", this.FrameId); cmd.ExecuteReaderExt((dr) => { return false; }); } // TODO: add own Woeid to Weather model /*Location location = new Location(DisplayId); if (location.LocationId != 0) { Woeid = location.Woeid; TemperatureUnit = location.TemperatureUnit; } else { Woeid = 56199578; // Old Sacramento TemperatureUnit = "f"; }*/ }
public Panel(int panelId) { using (SqlCommand cmd = new SqlCommand() { CommandType = CommandType.Text, CommandText = "SELECT TOP 1 * FROM Panel WHERE PanelId=@panelId", }) { cmd.Parameters.AddWithValue("@panelId", panelId); cmd.ExecuteReaderExt((dr) => { _initFromRow(dr); return false; }); } }
public Location(int displayId) { using (SqlCommand cmd = new SqlCommand() { CommandType = CommandType.Text, CommandText = "exec dbo.sp_GetLocationDetails @displayId", }) { cmd.Parameters.AddWithValue("@displayId", displayId); cmd.ExecuteReaderExt((r) => { _initFromRow(r); return false; }); } }
public static List<Panel> List(int canvasId) { List<Panel> list = new List<Panel>(); using (SqlCommand cmd = new SqlCommand() { CommandType = CommandType.Text, CommandText = "SELECT p.*, f.PanelId FsPanelId, c.Height CanvasHeight, c.Width CanvasWidth FROM Panel p " + "INNER JOIN Canvas c on c.CanvasId=p.CanvasId " + "LEFT JOIN FullScreen f on f.PanelId=p.PanelId WHERE p.CanvasId=@canvasId ORDER BY p.PanelId", }) { cmd.Parameters.AddWithValue("@canvasId", canvasId); cmd.ExecuteReaderExt((r) => { Panel panel = null; int panelId = r.IntOrZero("PanelId"); int fullScreenPanelId = r.IntOrZero("FsPanelId"); if (panelId == fullScreenPanelId) panel = new FullScreenPanel() { PanelId = panelId, Top = 0, Left = 0, Height = r.IntOrZero("CanvasHeight"), Width = r.IntOrZero("CanvasWidth"), Name = r.StringOrBlank("Name"), FadeLength = r.ValueOrDefault<double>("FadeLength", 0), }; else panel = new Panel() { PanelId = panelId, Top = r.IntOrZero("Top"), Left = r.IntOrZero("Left"), Height = r.IntOrZero("Height"), Width = r.IntOrZero("Width"), Name = r.StringOrBlank("Name"), FadeLength = r.ValueOrDefault<double>("FadeLength", 0), }; if (panel.Name == "") panel.Name = string.Format("Panel {0}", panelId); list.Add(panel); return true; }); } return list; }
public static bool IsFullScreen(int panelId) { bool isFullScreen = false; using (SqlCommand cmd = new SqlCommand() { CommandType = CommandType.Text, CommandText = "SELECT TOP 1 * FROM Panel WHERE PanelId=@panelId", }) { cmd.Parameters.AddWithValue("@panelId", panelId); cmd.ExecuteReaderExt((dr) => { isFullScreen = true; return false; }); } return isFullScreen; }
private void _init() { using (SqlCommand cmd = new SqlCommand() { CommandType = CommandType.Text, CommandText = "SELECT TOP 1 * FROM Youtube WHERE FrameId=@frameId", }) { cmd.Parameters.AddWithValue("@frameId", this.FrameId); cmd.ExecuteReaderExt((dr) => { YoutubeId = dr.StringOrBlank("YoutubeId").Trim(); AutoLoop = dr.Boolean("AutoLoop"); Volume = dr.IntOrZero("Volume"); Aspect = dr.IntOrZero("Aspect"); Quality = dr.IntOrZero("Quality"); Start = dr.IntOrZero("Start"); Rate = dr.IntOrZero("Rate"); return false; }); } }
private void _init() { using (SqlCommand cmd = new SqlCommand() { CommandType = CommandType.Text, CommandText = "SELECT TOP 1 f.*, t.FrameType, t.Html, t.Name TemplateName FROM Frame f inner join Template t on t.TemplateId=f.TemplateId WHERE FrameId=@frameId", }) { cmd.Parameters.AddWithValue("@frameId", this.FrameId); cmd.ExecuteReaderExt((dr) => { this._initfromRow(dr); return false; }); } }
public Display(int displayId) { using (SqlCommand cmd = new SqlCommand() { CommandType = CommandType.Text, CommandText = "SELECT TOP 1 * FROM Display WHERE displayId=@displayId", }) { cmd.Parameters.AddWithValue("@displayId", displayId); cmd.ExecuteReaderExt((r) => { _initFromRow(r); return false; }); } }
public Display(string host) { using (SqlCommand cmd = new SqlCommand() { CommandType = CommandType.Text, CommandText = "SELECT TOP 1 * FROM Display WHERE Host=@host", }) { cmd.Parameters.AddWithValue("@host", host); cmd.ExecuteReaderExt((r) => { _initFromRow(r); return false; }); } }
private void _init() { using (SqlCommand cmd = new SqlCommand() { CommandType = CommandType.Text, CommandText = "SELECT TOP 1 * FROM Powerbi WHERE FrameId=@frameId", }) { cmd.Parameters.AddWithValue("@frameId", FrameId); cmd.ExecuteReaderExt((dr) => { TargetUrl = dr.StringOrBlank("Url").Trim(); Action = (Models.PowerbiTypes)dr.IntOrZero("Type") == Models.PowerbiTypes.PowerbiType_Report ? "loadReport" : "loadTile"; AccountId = dr.IntOrZero("AccountId"); return false; }); } }
public static List<Location> List(int levelId = 0) { List<Location> list = new List<Location>(); using (SqlCommand cmd = new SqlCommand() { CommandType = CommandType.Text, CommandText = "select l.*, v.Name Name2 from Location l inner join Level v on v.LevelId=l.LevelId " + "where @levelId=0 or l.LevelId=@levelId order by v.Name, l.Name;", }) { cmd.Parameters.AddWithValue("@levelId", levelId); cmd.ExecuteReaderExt((r) => { Location loc = new Location(); loc._initFromRow(r); string name2 = r.StringOrBlank("Name2").Trim(); loc.Name = string.Format("{0} : {1}", name2 == "" ? string.Format("Level {0}", loc.LevelId) : name2, loc.Name ); list.Add(loc); return true; }); } return list; }
private void _init() { using (SqlCommand cmd = new SqlCommand() { CommandType = CommandType.Text, CommandText = "SELECT TOP 1 o.*, Account, Password, Url, EwsVersion FROM Outlook o inner join ExchangeAccount x on x.AccountId=o.AccountId WHERE o.FrameId=@frameId", }) { cmd.Parameters.AddWithValue("@frameId", FrameId); cmd.ExecuteReaderExt((dr) => { Account = dr.StringOrBlank("Account").Trim(); Password = (byte[])dr["Password"]; Mode = dr.IntOrZero("Mode"); EwsVersion = (ExchangeVersion)dr.IntOrZero("EwsVersion"); ShowEvents = dr.IntOrZero("ShowEvents"); if (ShowEvents < 0) ShowEvents = 0; Mailbox = dr.StringOrBlank("Mailbox").Trim(); if (string.IsNullOrWhiteSpace(Mailbox)) Mailbox = Account; Name = dr.StringOrBlank("Name").Trim(); URL = dr.StringOrBlank("Url").Trim(); Privacy = (DisplayMonkey.Models.OutlookPrivacy)dr.IntOrZero("Privacy"); AllowReserve = dr.Boolean("AllowReserve"); ShowAsFlags = dr.IntOrZero("ShowAsFlags"); return false; }); } }
private void _init() { using (SqlCommand cmd = new SqlCommand() { CommandType = CommandType.Text, CommandText = "SELECT TOP 1 i.*, Name FROM Picture i INNER JOIN Content c ON c.ContentId=i.ContentId WHERE i.FrameId=@frameId", }) { cmd.Parameters.AddWithValue("@frameId", FrameId); cmd.ExecuteReaderExt((dr) => { ContentId = dr.IntOrZero("ContentId"); Mode = (RenderModes)dr.IntOrZero("Mode"); Name = dr.StringOrBlank("Name"); return false; }); } }
private void _init() { using (SqlCommand cmd = new SqlCommand() { CommandType = CommandType.Text, CommandText = "SELECT TOP 1 * FROM Clock WHERE FrameId=@frameId", }) { cmd.Parameters.AddWithValue("@frameId", this.FrameId); cmd.ExecuteReaderExt((dr) => { this.ShowDate = dr.Boolean("ShowDate"); this.ShowTime = dr.Boolean("ShowTime"); this.ShowSeconds = dr.Boolean("ShowSeconds"); this.Type = dr.IntOrZero("Type"); this.Label = dr.StringOrDefault("Label", null); string szTimeZoneId = dr.StringOrDefault("TimeZone", null); if (szTimeZoneId != null) this.TimeZone = TimeZoneInfo.FindSystemTimeZoneById(szTimeZoneId); return false; }); } }