protected virtual void WriteDataWithStatus(IProgressMonitor progressMonitor, ref IProgressStatus status, TextWriter writer, BindingListSource bindingListSource, DsvWriter dsvWriter)
{
IList <RowItem> rows = Array.AsReadOnly(bindingListSource.Cast <RowItem>().ToArray());
IList <PropertyDescriptor> properties = bindingListSource.GetItemProperties(new PropertyDescriptor[0]).Cast <PropertyDescriptor>().ToArray();
dsvWriter.WriteHeaderRow(writer, properties);
var rowCount = rows.Count;
int startPercent = status.PercentComplete;
for (int rowIndex = 0; rowIndex < rowCount; rowIndex++)
{
if (progressMonitor.IsCanceled)
{
return;
}
int percentComplete = startPercent + (rowIndex * (100 - startPercent) / rowCount);
if (percentComplete > status.PercentComplete)
{
status = status.ChangeMessage(string.Format(Resources.AbstractViewContext_WriteData_Writing_row__0___1_, (rowIndex + 1), rowCount))
.ChangePercentComplete(percentComplete);
progressMonitor.UpdateProgress(status);
}
dsvWriter.WriteDataRow(writer, rows[rowIndex], properties);
}
}
public DataGridViewColumn FindColumn(PropertyPath propertyPath)
{
var propertyDescriptor =
BindingListSource.GetItemProperties(null)
.OfType <ColumnPropertyDescriptor>()
.FirstOrDefault(colPd => Equals(propertyPath, colPd.PropertyPath));
if (null == propertyDescriptor)
{
return(null);
}
return(DataGridView.Columns.Cast <DataGridViewColumn>().FirstOrDefault(col => col.DataPropertyName == propertyDescriptor.Name));
}
public DataGridViewColumn FindColumn(PropertyPath propertyPath)
{
// Get the list separately for debugging, since this helps in figuring out what
// the propertyPath should be.
var propertyDescriptorList = BindingListSource.GetItemProperties(null)
.OfType <ColumnPropertyDescriptor>();
var propertyDescriptor = propertyDescriptorList
.FirstOrDefault(colPd => Equals(propertyPath, colPd.PropertyPath));
if (null == propertyDescriptor)
{
return(null);
}
return(DataGridView.Columns.Cast <DataGridViewColumn>().FirstOrDefault(col => col.DataPropertyName == propertyDescriptor.Name));
}
public void TestPivotResultsThenIsotopeLabel()
{
var assembly = typeof(LiveReportPivotTest).Assembly;
XmlSerializer documentSerializer = new XmlSerializer(typeof(SrmDocument));
// ReSharper disable once AssignNullToNotNullAttribute
var document = (SrmDocument)documentSerializer.Deserialize(
assembly.GetManifestResourceStream(typeof(ReportSpecConverterTest), "silac_1_to_4.sky"));
XmlSerializer reportSerializer = new XmlSerializer(typeof(ReportOrViewSpecList));
// ReSharper disable once AssignNullToNotNullAttribute
var views = (ReportOrViewSpecList)reportSerializer.Deserialize(
assembly.GetManifestResourceStream(typeof(ReportSpecConverterTest), "LiveReportPivots.skyr"));
var view = views.First(reportSpec => reportSpec.Name == "ResultSummaryPivotResultsThenLabelType").ViewSpec;
var bindingListSource = new BindingListSource();
var documentContainer = new MemoryDocumentContainer();
Assert.IsTrue(documentContainer.SetDocument(document, null));
var dataSchema = new SkylineDataSchema(documentContainer, DataSchemaLocalizer.INVARIANT);
bindingListSource.SetViewContext(new DocumentGridViewContext(dataSchema), new ViewInfo(dataSchema, typeof(Precursor), view));
var expectedColumnNames = new[] {
"PeptideSequence",
"Chromatograms Replicate",
"Chromatograms PeptideRetentionTime",
"light IsotopeLabelType",
"light MeanTotalArea",
"light Chromatograms TotalArea",
"heavy IsotopeLabelType",
"heavy MeanTotalArea",
"heavy Chromatograms TotalArea",
};
var actualColumnNames =
bindingListSource.GetItemProperties(null)
.Cast <PropertyDescriptor>()
.Select(pd => pd.DisplayName)
.ToArray();
CollectionAssert.AreEqual(expectedColumnNames, actualColumnNames);
}
public void CheckReport(ReportSpec reportSpec)
{
string message = string.Format("Report {0}", reportSpec.Name);
var converter = new ReportSpecConverter(_dataSchema);
var viewInfo = converter.Convert(reportSpec);
var report = Report.Load(reportSpec);
ResultSet resultSet;
try
{
resultSet = report.Execute(_database);
}
catch (Exception)
{
return;
}
using (var bindingListSource = new BindingListSource())
{
bindingListSource.SetViewContext(new SkylineViewContext(viewInfo.ParentColumn, GetRowSource(viewInfo)),
viewInfo);
var oldCaptions = resultSet.ColumnInfos.Select(columnInfo => columnInfo.Caption).ToArray();
var properties = bindingListSource.GetItemProperties(null);
IList resultRows = bindingListSource;
var newCaptions = properties.Cast <PropertyDescriptor>().Select(pd => pd.DisplayName).ToArray();
if (!oldCaptions.SequenceEqual(newCaptions))
{
CollectionAssert.AreEqual(oldCaptions, newCaptions, message);
}
if (resultSet.RowCount != resultRows.Count)
{
Assert.AreEqual(resultSet.RowCount, resultRows.Count, message);
}
resultRows = SortRows(resultRows, properties);
resultSet = SortResultSet(resultSet);
for (int iRow = 0; iRow < resultSet.RowCount; iRow++)
{
for (int iCol = 0; iCol < resultSet.ColumnInfos.Count; iCol++)
{
var propertyDescriptor = properties[iCol];
object oldValue = resultSet.GetRow(iRow)[iCol];
object newValue = propertyDescriptor.GetValue(resultRows[iRow]);
if (!Equals(oldValue, newValue))
{
Assert.AreEqual(oldValue, newValue,
message + "{0}:Values are not equal on Row {1} Column {2} ({3}) FullName:{4}",
message, iRow, iCol, propertyDescriptor.DisplayName, propertyDescriptor.Name);
}
}
}
foreach (char separator in new[] { ',', '\t' })
{
StringWriter oldStringWriter = new StringWriter();
var cultureInfo = LocalizationHelper.CurrentCulture;
ResultSet.WriteReportHelper(resultSet, separator, oldStringWriter, cultureInfo);
StringWriter newStringWriter = new StringWriter();
var skylineViewContext = (SkylineViewContext)bindingListSource.ViewContext;
ProgressStatus progressStatus = new ProgressStatus("Status");
skylineViewContext.Export(null, ref progressStatus, viewInfo, newStringWriter,
new DsvWriter(cultureInfo, separator));
var newLineSeparators = new[] { "\r\n" };
var oldLines = oldStringWriter.ToString().Split(newLineSeparators, StringSplitOptions.None);
var newLines = newStringWriter.ToString().Split(newLineSeparators, StringSplitOptions.None);
// TODO(nicksh): Old reports would hide columns for annotations that were not in the document.
bool anyHiddenColumns = resultSet.ColumnInfos.Any(column => column.IsHidden);
if (!anyHiddenColumns)
{
Assert.AreEqual(oldLines[0], newLines[0]);
CollectionAssert.AreEquivalent(oldLines, newLines);
}
}
}
}
public void TestMapping()
{
var settings = SrmSettingsList.GetDefault();
var document = new SrmDocument(settings);
var documentContainer = new MemoryDocumentContainer();
documentContainer.SetDocument(document, null);
using (var database = new Database(settings))
{
var dataSchema = new SkylineDataSchema(documentContainer, DataSchemaLocalizer.INVARIANT);
var sessionFactory = database.SessionFactory;
foreach (var classMetaData in sessionFactory.GetAllClassMetadata().Values)
{
var tableType = classMetaData.GetMappedClass(EntityMode.Poco);
foreach (var propertyName in classMetaData.PropertyNames)
{
if (propertyName == "Protein" && tableType == typeof(DbProteinResult))
{
continue;
}
var queryDef = new QueryDef
{
Select = new[] { new ReportColumn(tableType, propertyName), }
};
var reportSpec = new ReportSpec("test", queryDef);
var newTableType = ReportSpecConverter.GetNewTableType(reportSpec);
Assert.IsNotNull(newTableType, "No table for type {0}", tableType);
var converter = new ReportSpecConverter(dataSchema);
var viewInfo = converter.Convert(reportSpec);
Assert.IsNotNull(viewInfo, "Unable to convert property {0} in table {1}", propertyName, tableType);
Assert.AreEqual(1, viewInfo.DisplayColumns.Count, "No conversion for property {0} in table {1}", propertyName, tableType);
Assert.IsNotNull(viewInfo.DisplayColumns[0].ColumnDescriptor, "Column not found for property {0} in table {1}", propertyName, tableType);
var report = Report.Load(reportSpec);
var resultSet = report.Execute(database);
var bindingListSource = new BindingListSource();
bindingListSource.SetViewContext(new SkylineViewContext(viewInfo.ParentColumn, Array.CreateInstance(viewInfo.ParentColumn.PropertyType, 0)), viewInfo);
var properties = bindingListSource.GetItemProperties(null);
var oldCaptions = resultSet.ColumnInfos.Select(columnInfo => columnInfo.Caption).ToArray();
var newCaptions = properties.Cast <PropertyDescriptor>().Select(pd => pd.DisplayName).ToArray();
if (oldCaptions.Length != newCaptions.Length)
{
Console.Out.WriteLine(oldCaptions);
}
CollectionAssert.AreEqual(oldCaptions, newCaptions, "Caption mismatch on {0} in {1}", propertyName, tableType);
for (int i = 0; i < resultSet.ColumnInfos.Count; i++)
{
var columnInfo = resultSet.ColumnInfos[i];
var formatAttribute = (FormatAttribute)properties[i].Attributes[typeof(FormatAttribute)];
string message = string.Format("Format problem on column converted from {0} in {1}",
columnInfo.ReportColumn.Column, columnInfo.ReportColumn.Table);
if (null == columnInfo.Format)
{
Assert.IsTrue(null == formatAttribute || null == formatAttribute.Format, message);
}
else
{
Assert.IsNotNull(formatAttribute, message);
Assert.AreEqual(columnInfo.Format, formatAttribute.Format, message);
}
if (columnInfo.IsNumeric)
{
Assert.IsNotNull(formatAttribute, message);
Assert.AreEqual(TextUtil.EXCEL_NA, formatAttribute.NullValue, message);
}
else
{
Assert.IsTrue(null == formatAttribute || null == formatAttribute.NullValue, message);
}
}
}
}
}
}
public void QuickFilter(DataGridViewColumn column)
{
_columnFilterPropertyDescriptor = BindingListSource.GetItemProperties(null)[column.DataPropertyName];
filterToolStripMenuItem_Click(filterToolStripMenuItem, new EventArgs());
}
