/// <summary>
///
/// </summary>
/// <param name="export"></param>
private void ProcessHours(int assessmentID, ref SingleRowExport export)
{
const string d = "Documentation";
const string ip = "Interview Process";
var fhours = db.FINANCIAL_HOURS.Where(x => x.Assessment_Id == assessmentID).ToList();
export.d["Doc Hrs"] = fhours.Where(x => x.ReviewType == d).Sum(y => y.Hours).ToString();
export.d["Int Hrs"] = fhours.Where(x => x.ReviewType == ip).Sum(y => y.Hours).ToString();
export.d["Pre Doc"] = GetHours(fhours, "Pre-exam prep", d);
export.d["IRP Doc"] = GetHours(fhours, "IRP", d);
export.d["D1 Doc"] = GetHours(fhours, "Domain 1", d);
export.d["D2 Doc"] = GetHours(fhours, "Domain 2", d);
export.d["D3 Doc"] = GetHours(fhours, "Domain 3", d);
export.d["D4 Doc"] = GetHours(fhours, "Domain 4", d);
export.d["D5 Doc"] = GetHours(fhours, "Domain 5", d);
export.d["Oth1 Doc"] = GetHours(fhours, "Other (specify)", d);
export.d["Oth2 Doc"] = GetHours(fhours, "Additional Other (specify)", d);
export.d["Pre Int"] = GetHours(fhours, "Pre-exam prep", ip);
export.d["IRP Int"] = GetHours(fhours, "IRP", ip);
export.d["D1 Int"] = GetHours(fhours, "Domain 1", ip);
export.d["D2 Int"] = GetHours(fhours, "Domain 2", ip);
export.d["D3 Int"] = GetHours(fhours, "Domain 3", ip);
export.d["D4 Int"] = GetHours(fhours, "Domain 4", ip);
export.d["D5 Int"] = GetHours(fhours, "Domain 5", ip);
export.d["Exit Int"] = GetHours(fhours, "Discussing end results with CU", ip);
export.d["Oth1 Int"] = GetHours(fhours, "Other (specify)", ip);
export.d["Oth2 Int"] = GetHours(fhours, "Additional Other (specify)", ip);
// Statements marked as 'Reviewed'
Dictionary <string, int> countStatementsReviewed = new Dictionary <string, int>();
var stmtCounts = db.usp_StatementsReviewed(assessmentID).ToList <usp_StatementsReviewed_Result>();
foreach (var row in stmtCounts)
{
countStatementsReviewed[row.Component] = row.ReviewedCount ?? 0;
}
export.d["D1 Rev"] = countStatementsReviewed["Domain 1"].ToString();
export.d["D2 Rev"] = countStatementsReviewed["Domain 2"].ToString();
export.d["D3 Rev"] = countStatementsReviewed["Domain 3"].ToString();
export.d["D4 Rev"] = countStatementsReviewed["Domain 4"].ToString();
export.d["D5 Rev"] = countStatementsReviewed["Domain 5"].ToString();
export.d["D1 Rvw"] = countStatementsReviewed["Domain 1"].ToString();
export.d["D2 Rvw"] = countStatementsReviewed["Domain 2"].ToString();
export.d["D3 Rvw"] = countStatementsReviewed["Domain 3"].ToString();
export.d["D4 Rvw"] = countStatementsReviewed["Domain 4"].ToString();
export.d["D5 Rvw"] = countStatementsReviewed["Domain 5"].ToString();
export.d["Tot Rvw"] = (countStatementsReviewed["Domain 1"]
+ countStatementsReviewed["Domain 2"]
+ countStatementsReviewed["Domain 3"]
+ countStatementsReviewed["Domain 4"]
+ countStatementsReviewed["Domain 5"]).ToString();
}
public AdminTabData GetTabData(int assessmentId)
{
Dictionary <string, int> countStatementsReviewed = new Dictionary <string, int>();
AdminTabData rvalue = new AdminTabData();
using (var db = new CSET_Context())
{
try
{
var stmtCounts = db.usp_StatementsReviewed(assessmentId).ToList <usp_StatementsReviewed_Result>();
foreach (var row in stmtCounts)
{
rvalue.DetailData.Add(new FINANCIAL_HOURS_OVERRIDE(row));
countStatementsReviewed[row.Component] = row.ReviewedCount ?? 0;
}
var totals = db.usp_StatementsReviewedTabTotals(assessmentId).ToList <usp_StatementsReviewedTabTotals_Result>();
foreach (var row in totals)
{
rvalue.ReviewTotals.Add(new ReviewTotals()
{
Total = row.Totals, ReviewType = row.ReviewType
});
rvalue.GrandTotal = row.GrandTotal ?? 0;
}
}
catch (System.Exception exc)
{
BusinessLogic.Helpers.CsetLogManager.Instance.LogErrorMessage(exc.ToString());
}
// add another total entry for Statements Reviewed
var totalReviewed = new ReviewTotals
{
ReviewType = "Statements Reviewed",
Total = 0
};
foreach (var d in countStatementsReviewed)
{
totalReviewed.Total += d.Value;
}
rvalue.ReviewTotals.Add(totalReviewed);
rvalue.Attributes = db.usp_financial_attributes(assessmentId).ToList();
}
return(rvalue);
}
