private void SetupFilesTab() { if (Collar == null) { return; } FilesDataGridView.DataSource = DatabaseViews.CollarFixesByFile(Collar.CollarManufacturer, Collar.CollarId); EnableFileControls(); }
private void SetupFixesTab() { if (Collar == null) { return; } FixConflictsDataGridView.DataSource = DatabaseViews.ConflictingFixes(Collar.CollarManufacturer, Collar.CollarId, 36500); //last 100 years var summary = DatabaseViews.CollarFixSummary(Collar.CollarManufacturer, Collar.CollarId).FirstOrDefault(); SummaryLabel.Text = summary == null ? "There are NO fixes." : (summary.Count == summary.Unique ? String.Format("{0} fixes between {1:d} and {2:d}.", summary.Count, summary.First, summary.Last) : String.Format("{3}/{0} unique/total fixes between {1:d} and {2:d}.", summary.Count, summary.First, summary.Last, summary.Unique)); var query = from fix in Database.CollarFixes where fix.Collar == Collar select new { fix.FixDate, fix.Lat, fix.Lon, fix.CollarFile.FileName, fix.LineNumber }; FixesGridView.DataSource = query; FixConflictsDataGridView_SelectionChanged(null, null); }