public static List <JazzArtifact> CreateJazzObjects(string xml)
{
List <JazzArtifact> artifacts = new List <JazzArtifact>();
XmlDocument doc = new XmlDocument();
doc.LoadXml(xml);
foreach (XmlNode node in doc.DocumentElement)
{
JazzArtifact a = new JazzArtifact();
foreach (XmlNode child in node.ChildNodes)
{
if (child.Name == "REFERENCE_ID")
{
a.IbmId = Convert.ToInt32(child.InnerText);
}
else if (child.Name == "URL1_title")
{
a.Name = child.InnerText;
}
else if (child.Name == "URL1")
{
a.Url = child.InnerText;
}
}
artifacts.Add(a);
}
return(artifacts);
}
public IEnumerable <JazzArtifact> GetArtifactsForPage(int workProductId, int page)
{
int artifactPerPage = 15;
int totalArtifacts = context.IbmArtifact.Count(a => a.WorkproductId == workProductId);
int amoutOfPages = totalArtifacts / artifactPerPage;
if (totalArtifacts % artifactPerPage > 0)
{
amoutOfPages++;
}
int skip = page * artifactPerPage;
List <JazzArtifact> artifacts = new List <JazzArtifact>();
var artifactsPerPage = context.IbmArtifact.Where(a => a.WorkproductId == workProductId).Skip(skip).Take(artifactPerPage).ToList();
foreach (var a in artifactsPerPage)
{
JazzArtifact artifact = new JazzArtifact()
{
IbmId = a.IbmId,
Id = a.Id,
Name = a.Name,
Url = a.Url
};
artifacts.Add(artifact);
}
return(artifacts);
}
public ReviewsForArtifact GetReviewsForArtifact(int id)
{
ReviewsForArtifact artifact = new ReviewsForArtifact();
var art = context.IbmArtifact.Where(x => x.Id == id).Include(p => p.IbmArtifactReview).FirstOrDefault();
JazzArtifact a = new JazzArtifact()
{
Id = art.Id, IbmId = art.IbmId, Name = art.Name, Url = art.Url
};
artifact.Artifact = a;
List <int> ids = art.IbmArtifactReview.Select(x => x.ReviewId).ToList();
var reviews = context.Review.Where(x => ids.Contains(x.Id)).ToList();
List <ReviewSetup> setups = new List <ReviewSetup>();
foreach (var r in reviews)
{
ReviewSetup s = new ReviewSetup()
{
Id = r.Id, Name = r.Name
};
setups.Add(s);
}
artifact.Reviews = setups;
return(artifact);
}
public IEnumerable <JazzArtifact> GetAllArtifactForWorkProduct(int id)
{
List <JazzArtifact> artifacts = new List <JazzArtifact>();
foreach (var a in context.IbmArtifact.Where(ar => ar.WorkproductId == id).ToList())
{
JazzArtifact artifact = new JazzArtifact()
{
IbmId = a.IbmId,
Id = a.Id,
Name = a.Name,
Url = a.Url
};
artifacts.Add(artifact);
}
return(artifacts);
}
