/// <summary>
///
/// </summary>
/// <param name="userID"></param>
/// <param name="stream"></param>
public void ProcessDiagram(int assessmentId, MemoryStream stream)
{
DataTable dtComponents = BuildDiagramComponents(assessmentId);
DataTable dtZones = BuildDiagramZones(assessmentId);
DataTable dtLinks = BuildDiagramLinks(assessmentId);
DataTable dtShapes = BuildDiagramShapes(assessmentId);
DataTable dtTexts = BuildDiagramText(assessmentId);
// Create an Excel document from the data that has been gathered
var doc = new CSETtoExcelDocument();
doc.AddDataTable(dtComponents);
doc.AddDataTable(dtZones);
doc.AddDataTable(dtLinks);
doc.AddDataTable(dtShapes);
doc.AddDataTable(dtTexts);
List <DataMap> list = new List <DataMap>();
doc.WriteExcelFile(stream, list);
}
public void ProcessAssessment(int assessmentID, MemoryStream stream)
{
DataTable dt = BuildAssessment(assessmentID);
// Create an Excel document from the data that has been gathered
var doc = new CSETtoExcelDocument();
doc.AddDataTable(dt);
List <DataMap> list = new List <DataMap>();
doc.WriteExcelFile(stream, list);
}
/// <summary>
///
/// </summary>
/// <param name="userID"></param>
/// <param name="stream"></param>
public void ProcessAllAssessmentsForUser(int userID, MemoryStream stream)
{
DataTable dtAll = null;
var sm = new StandardsManager();
// get all the assessment IDs that this user has access to
var myAssessmentIDs = db.ASSESSMENT_CONTACTS.Where(x => x.UserId == userID).Select(y => y.Assessment_Id).ToList();
foreach (int assessmentID in myAssessmentIDs)
{
// ignore assessments that don't have the ACET standard
if (!sm.GetACET(assessmentID))
{
continue;
}
// get the values as a DataTable
DataTable dt = BuildAssessment(assessmentID);
// append the row into dtAll .....
if (dtAll == null)
{
dtAll = dt.Copy();
}
else
{
if (dt.Rows.Count > 0)
{
dtAll.LoadDataRow(dt.Rows[0].ItemArray, true);
}
}
}
// Create an Excel document from the data that has been gathered
var doc = new CSETtoExcelDocument();
doc.AddDataTable(dtAll);
List <DataMap> list = new List <DataMap>();
doc.WriteExcelFile(stream, list);
}
