private void UpdateColumnLabels(Domain.Report report)
{
var output = report.OutPut.Split(',');
var columnLabels = report.ColumnLabels.Split(',');
for (int i = 0; i < output.Length; i++)
{
var columnName = output[i];
var currentColumnLabel = _virtualOfficeEntities.ReportLabels.FirstOrDefault(rep => rep.ReportId == report.Id && rep.ColumnName == columnName);
if (!currentColumnLabel.IsNull())
{
currentColumnLabel.Label = string.Format("\"{0}\"", columnLabels[i]);
_virtualOfficeEntities.ReportLabels.AddOrUpdate(currentColumnLabel);
}
else
{
var columnLabel = new Data.ReportLabel
{
ColumnName = output[i],
ReportId = report.Id,
Label = string.Format("\"{0}\"", columnLabels[i]),
TimeSpan = DateTime.Now,
RowVersion = ConverterHelper.GetVersionRow()
};
_virtualOfficeEntities.ReportLabels.Add(columnLabel);
}
}
_virtualOfficeEntities.SaveChanges();
}
private void AddColumnLabels(Domain.Report report)
{
var output = report.OutPut.Split(',');
var columnLabels = report.ColumnLabels.Split(',');
for (int i = 0; i < output.Length; i++)
{
var columnLabel = new Data.ReportLabel
{
ColumnName = output[i],
ReportId = report.Id,
Label = string.Format("\"{0}\"", columnLabels[i]),
TimeSpan = DateTime.Now,
RowVersion = ConverterHelper.GetVersionRow()
};
_virtualOfficeEntities.ReportLabels.Add(columnLabel);
}
_virtualOfficeEntities.SaveChanges();
}
