static public void Delete(System.Int32 id, esSqlAccessType sqlAccessType)
{
var obj = new AnnotationPlotSeries();
obj.Id = id;
obj.AcceptChanges();
obj.MarkAsDeleted();
obj.Save(sqlAccessType);
}
private void CopyAnnotationData(int fromAnnotationId, int toAnnotationId)
{
Annotation ann = new Annotation();
if (!ann.LoadByPrimaryKey(toAnnotationId))
{
MessageBox.Show("To Annotation Not found");
return;
}
ann = new Annotation();
if (!ann.LoadByPrimaryKey(fromAnnotationId))
{
MessageBox.Show("From Annotation Not found");
return;
}
Dictionary<int, int> axisKeys = new Dictionary<int, int>();
Dictionary<int, int> seriesKeys = new Dictionary<int,int>();
using (esTransactionScope scope = new esTransactionScope())
{
foreach (AnnotationPlot annPlot in ann.AnnotationPlotCollectionByAnnotationId)
{
AnnotationPlot annPlotClone = new AnnotationPlot();
annPlotClone.AnnotationId = toAnnotationId;
annPlotClone.RegionId = annPlot.RegionId;
annPlotClone.Description = annPlot.Description;
annPlotClone.Title = annPlot.Title;
annPlotClone.Type = annPlot.Type;
annPlotClone.DimensionCount = annPlot.DimensionCount;
annPlotClone.Save();
foreach (AnnotationPlotAxis annPlotAxis in annPlot.AnnotationPlotAxisCollectionByPlotId)
{
AnnotationPlotAxis annPlotAxisClone = new AnnotationPlotAxis();
annPlotAxisClone.PlotId = annPlotClone.Id;
annPlotAxisClone.Label = annPlotAxis.Label;
annPlotAxisClone.MinValue = annPlotAxis.MinValue;
annPlotAxisClone.MaxValue = annPlotAxis.MaxValue;
annPlotAxisClone.Scale = annPlotAxis.Scale;
annPlotAxisClone.Type = annPlotAxis.Type;
annPlotAxisClone.Dimension = annPlotAxis.Dimension;
annPlotAxisClone.Save();
axisKeys.Add(annPlotAxis.Id.Value, annPlotAxisClone.Id.Value);
}
foreach (AnnotationPlotSeries annPlotSeries in annPlot.AnnotationPlotSeriesCollectionByPlotId)
{
AnnotationPlotSeries annPlotSeriesClone = new AnnotationPlotSeries();
annPlotSeriesClone.PlotId = annPlotClone.Id;
annPlotSeriesClone.Description = annPlotSeries.Description;
annPlotSeriesClone.ColorRGB = annPlotSeries.ColorRGB;
annPlotSeriesClone.Save();
seriesKeys.Add(annPlotSeries.Id.Value, annPlotSeriesClone.Id.Value);
}
}
foreach (AnnotationPlot annPlot in ann.AnnotationPlotCollectionByAnnotationId)
{
foreach (AnnotationPlotAxis annPlotAxis in annPlot.AnnotationPlotAxisCollectionByPlotId)
{
foreach (AnnotationPlotAxisData annPlotAxisData in annPlotAxis.AnnotationPlotAxisDataCollectionByAxisId)
{
AnnotationPlotAxisData annPlotAxisDataClone = new AnnotationPlotAxisData();
annPlotAxisDataClone.AxisId = axisKeys[annPlotAxisData.AxisId.Value];
annPlotAxisDataClone.SeriesId = seriesKeys[annPlotAxisData.SeriesId.Value];
annPlotAxisDataClone.DataBin = annPlotAxisData.DataBin;
annPlotAxisDataClone.Save();
}
}
foreach (AnnotationPlotSeries annPlotSeries in annPlot.AnnotationPlotSeriesCollectionByPlotId)
{
foreach (AnnotationPlotAxisData annPlotAxisData in annPlotSeries.AnnotationPlotAxisDataCollectionBySeriesId)
{
AnnotationPlotAxisData annPlotAxisDataClone = new AnnotationPlotAxisData();
annPlotAxisDataClone.Query.Where(
annPlotAxisDataClone.Query.AxisId == axisKeys[annPlotAxisData.AxisId.Value] &&
annPlotAxisDataClone.Query.SeriesId == seriesKeys[annPlotAxisData.SeriesId.Value]);
if (!annPlotAxisDataClone.Query.Load())
{
annPlotAxisDataClone = new AnnotationPlotAxisData();
annPlotAxisDataClone.AxisId = axisKeys[annPlotAxisData.AxisId.Value];
annPlotAxisDataClone.SeriesId = seriesKeys[annPlotAxisData.SeriesId.Value];
annPlotAxisDataClone.DataBin = annPlotAxisData.DataBin;
annPlotAxisDataClone.Save();
}
}
}
}
scope.Complete();
}
}
