/// <summary>
/// Converts <see cref="ATMarkDTO"/> to requested entity type
/// </summary>
/// <param name="mark">the mark</param>
/// <param name="existing">existing item</param>
/// <returns>corresponding entity</returns>
public ATRotation ToRotationItem(ATMarkDTO mark, ATRotation existing)
{
var o = existing ?? new ATRotation();
o.Mark = this.ToMark(mark, null != existing ? existing.Mark : null);
return(o);
}
/// <summary>
/// The get marks for file.
/// </summary>
/// <param name="fileId">
/// The file id.
/// </param>
/// <returns>
/// The <see cref="Tuple"/>.
/// </returns>
#pragma warning disable 168
public Tuple <List <ATShape>, List <ATDrawing>, List <ATHighlightStrikeOut>, List <ATTextItem>, List <ATRotation> > GetMarksForFile(Guid fileId)
{
// trick to make NHibernate to load all child instances in one roundtrip to db (if db supports it)
var result = new Tuple <List <ATShape>, List <ATDrawing>, List <ATHighlightStrikeOut>, List <ATTextItem>, List <ATRotation> >
(new List <ATShape>(), new List <ATDrawing>(), new List <ATHighlightStrikeOut>(), new List <ATTextItem>(), new List <ATRotation>());
ATMark mark = null;
ATShape note = null;
ATDrawing atDrawing = null;
ATHighlightStrikeOut atHighlightStrikeOut = null;
ATTextItem textItem = null;
ATRotation rotationItem = null;
// Query to load the companies
var marks = this.Repository.Session.QueryOver(() => mark).Where(x => x.File.Id == fileId).Fetch(x => x.File).Eager.Future <ATMark>();
// Query to load the Notes
var notes = this.Repository.Session.QueryOver(() => note)
.JoinAlias(p => p.Mark, () => mark)
.Future <ATShape>();
// Query to load the Drawings
var drawings = this.Repository.Session.QueryOver(() => atDrawing)
.JoinAlias(p => p.Mark, () => mark)
.Future <ATDrawing>();
// Query to load the Highlights
var highlights = this.Repository.Session.QueryOver(() => atHighlightStrikeOut)
.JoinAlias(p => p.Mark, () => mark)
.Future <ATHighlightStrikeOut>();
// Query to load the TextItems
var textItems = this.Repository.Session.QueryOver(() => textItem)
.JoinAlias(p => p.Mark, () => mark)
.Future <ATTextItem>();
// Query to load the Rotations
var rotationItems = this.Repository.Session.QueryOver(() => rotationItem)
.JoinAlias(p => p.Mark, () => mark)
.Future <ATRotation>();
// when this is executed, the three queries are executed in one roundtrip
var results = marks.ToList();
foreach (var joinedMark in results)
{
foreach (var joinedNote in joinedMark.Shapes)
{
result.Item1.Add(joinedNote);
}
foreach (var joinedDrawing in joinedMark.Drawings)
{
result.Item2.Add(joinedDrawing);
}
foreach (var joinedHighlight in joinedMark.HighlightStrikeOuts)
{
result.Item3.Add(joinedHighlight);
}
foreach (var joinedText in joinedMark.TextItems)
{
result.Item4.Add(joinedText);
}
foreach (var rotation in joinedMark.Rotations)
{
result.Item5.Add(rotation);
}
}
return(result);
}
/// <summary>
/// Initializes a new instance of the <see cref="ATMarkDTO"/> class.
/// </summary>
/// <param name="rotation">
/// The ATRotation.
/// </param>
public ATMarkDTO(ATRotation rotation) : this(rotation.Mark)
{
}
public IEnumerable <ATMark> GetMarks(Guid fileId)
{
ATMark mark = null;
ATShape note = null;
ATDrawing atDrawing = null;
ATHighlightStrikeOut atHighlightStrikeOut = null;
ATTextItem textItem = null;
ATRotation rotationItem = null;
ATPicture pictureItem = null;
ATFormula formulaItem = null;
ATAnnotation annotationItem = null;
// Query to load the companies
// var marks = this.Repository.Session.QueryOver(() => mark).Where(x => x.File.Id == fileId).Fetch(x => x.File).Eager.Future<ATMark>();
var mrs = this.Repository.Session.QueryOver <ATMark>()
.Left.JoinAlias(p => p.Annotations, () => annotationItem)
.Left.JoinAlias(p => p.Shapes, () => note)
.Left.JoinAlias(p => p.Drawings, () => atDrawing)
.Left.JoinAlias(p => p.HighlightStrikeOuts, () => atHighlightStrikeOut)
.Left.JoinAlias(p => p.TextItems, () => textItem)
.Left.JoinAlias(p => p.Rotations, () => rotationItem)
.Left.JoinAlias(p => p.Pictures, () => pictureItem)
.Left.JoinAlias(p => p.Formulas, () => formulaItem)
.Where(p => p.File.Id == fileId)
.Fetch(p => p.File).Eager.Future <ATMark>();
// .List();
//// Query to load the Notes
//var notes = this.Repository.Session.QueryOver(() => note)
// .JoinAlias(p => p.Mark, () => mark)
// .Future<ATShape>();
//// Query to load the Drawings
//var drawings = this.Repository.Session.QueryOver(() => atDrawing)
// .JoinAlias(p => p.Mark, () => mark)
// .Future<ATDrawing>();
//// Query to load the Highlights
//var highlights = this.Repository.Session.QueryOver(() => atHighlightStrikeOut)
// .JoinAlias(p => p.Mark, () => mark)
// .Future<ATHighlightStrikeOut>();
//// Query to load the TextItems
//var textItems = this.Repository.Session.QueryOver(() => textItem)
// .JoinAlias(p => p.Mark, () => mark)
// .Future<ATTextItem>();
//// Query to load the Rotations
//var rotationItems = this.Repository.Session.QueryOver(() => rotationItem)
// .JoinAlias(p => p.Mark, () => mark)
// .Future<ATRotation>();
//// Query to load the Pictures
//var pictureItems = this.Repository.Session.QueryOver(() => pictureItem)
// .JoinAlias(p => p.Mark, () => mark)
// .Future<ATPicture>();
//// Query to load the Formulas
//var formulaItems = this.Repository.Session.QueryOver(() => formulaItem)
// .JoinAlias(p => p.Mark, () => mark)
// .Future<ATFormula>();
//// Query to load the Annotations
//var annotationItems = this.Repository.Session.QueryOver(() => annotationItem)
// .JoinAlias(p => p.Mark, () => mark)
// .Future<ATAnnotation>();
return(mrs.OrderBy(x => x.DateChanged).ToList());
}