/// <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); }