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(); }