getAccountBalanceDetail.cshtml 📄
Table of Contents
- Overview & Purpose 🚀
- Technologies & Dependencies 🔧
- Layout & Styles 🎨
- Navigation Menu 🧭
- View Model & Data Models 📦
- Key Sections 📑
- Grid Configurations ⚙️
- Chart Configurations 📉
- Templates & Modal 📦
- Scripts & Event Handling 📝
- API Endpoints Overview 🌐
- Usage Examples 🔍
- UML Diagram 🛠️
- Conclusion 🏁
Overview & Purpose 🚀
getAccountBalanceDetail.cshtml is an ASP.NET Core Razor view designed to present a comprehensive Account Balance Dashboard for jobs.
It consolidates:
- Job metadata (e.g., contract type, dates, manager)
- Financial summaries (grid + charts)
- Detail lists (revenue/cost breakdown, ledger, employees, equipment, work orders, POs, IT assets)
Users can navigate via an on‑page dropdown, search/filter/export data, and drill into documents via a modal.
Technologies & Dependencies 🔧
| Library/Framework | Purpose |
|---|---|
| ASP.NET Core Razor | Server‑side view rendering |
Syncfusion EJ2 (ejs-) |
Grids, Charts, Textboxes |
| jQuery | DOM manipulation & AJAX |
| DataTables + Buttons | CSV/Excel/PDF exports |
| Bootstrap 5 | Responsive layout & modal dialogs |
| MetisMenu, Simplebar | Sidebar & scrollbar enhancements |
| jsZip, pdfmake | Excel/PDF generation |
@using Syncfusion.JavaScript
@using Syncfusion.JavaScript.Models
@using Syncfusion.EJ2
@model IrbyImaging.UI.Models.Balances
Layout & Styles 🎨
- Layout:
_iViewLayout.cshtml(master page) - Custom CSS:
.floating-save-btn– fixed dropdown navigation.e-custom*,.e-attr*– Syncfusion grid header styling- Responsive
.row,.col-*,.card,.card-body
<style>
.floating-save-btn { position: fixed; bottom: 25px; right: 80px; z-index: 1000; }
.e-grid .e-headercell.e-custom { background: lightgreen; font-weight: bold; }
/* …more classes for coloring headers & row heights… */
</style>
Navigation Menu 🧭
A fixed <SELECT> allows jumping to each section via anchor links:
<select id="Select" class="floating-save-btn">
<option value="#Summary">Summary</option>
<option value="#ChartSummary">Charts</option>
<!-- …other sections… -->
</select>
<script>
$("#Select").change(e => {
window.location.href = $(e.target).val();
});
</script>
View Model & Data Models 📦
Model: IrbyImaging.UI.Models.Balances
Key properties used:
Job– metadata:JdeNumber,Name,ContractType, dates...Details– list for Job Summary (e.g.,Lead)ViewBag.datasource*– grid data sourcesViewBag.chartSource*– chart data
public class Balances {
public JobDetails Job { get; set; }
public IEnumerable<BalanceDetail> Details { get; set; }
// ...Employees, Equipment, WorkOrders, PurchaseOrders, Assets...
}
Key Sections 📑
1. Job Summary 👷
Displays read‑only job metadata using Syncfusion Textboxes:
<div id="ControlRegion">
<h3>Job Summary</h3>
<div class="form-group row mb-2">
<label class="col-sm-1">Job #</label>
<div class="col-sm-2">
<ejs-textbox width="200px" id="number" value="@Model.Job.JdeNumber" readonly></ejs-textbox>
</div>
<!-- Job Name, ContractType, JobType… -->
</div>
<!-- WorkType, Field Office, Customer, Region… -->
<!-- Lead, Manager, Superintendent, Estimator… -->
<!-- Planned/Actual Start/Complete… -->
</div>
2. Financial Summary 💰
A Syncfusion TreeGrid summarizing current month & YTD:
<div id="Summary">
<h3>Financial Summary</h3>
<ejs-grid id="TreeGrid1"
dataSource="ViewBag.datasource1"
allowExcelExport="true"
allowPdfExport="true"
allowTextWrap="true"
width="100%" height="100%">
<e-grid-columns>
<e-grid-column field="Type" headerText="JOB" width="290" textAlign="Center"></e-grid-column>
<!-- CURRENT MONTH stacked columns (Revenue, Cost, Margin, Margin%) -->
<!-- YEAR-TO-DATE stacked columns (Revenue, Cost, Margin, …) -->
</e-grid-columns>
</ejs-grid>
</div>
Column Snapshot:
| Section | Field | HeaderText | Format | Align |
|---|---|---|---|---|
| Type | Type |
JOB | – | Center |
| Current Month | Revenue |
REVENUE | N2 | Right |
Cost |
COST | N2 | Right | |
Margin |
MARGIN | N2 | Right | |
MarginPct |
MARGIN % | – | Center | |
| Year‑to‑Date | YTDRevenue |
REVENUE | N2 | Right |
| … | … | … | … | … |
3. Chart Summaries 📊
3.1 Revenue & Cost (Trailing 12 Months)
<ejs-chart id="container1" title="Revenue and Cost by Month">
<e-chart-primaryxaxis valueType="Category" interval="1"></e-chart-primaryxaxis>
<e-series-collection>
<e-series dataSource="ViewBag.chartSource" xName="x" yName="y" name="Revenue" type="StackingLine"></e-series>
<e-series dataSource="ViewBag.chartSource" xName="x" yName="y1" name="Cost" type="StackingLine"></e-series>
</e-series-collection>
</ejs-chart>
3.2 CIEB / BIEC by Month
<ejs-chart id="container2" title="CIEB/BIEC by Month">
<e-series-collection>
<e-series dataSource="ViewBag.chartSourcecieb" type="StackingColumn" name="CIEB"></e-series>
<e-series dataSource="ViewBag.chartSourcebiec" type="StackingColumn" name="BIEC"></e-series>
</e-series-collection>
</ejs-chart>
3.3 Margin & Unbilled Charts
container3– Margin (Column)container4– Unbilled (Column)
4. Revenue & Cost Grid 📈
Detailed TreeGrid with search & export:
<div id="RevenueCost">
<h3>Revenue & Cost Details by Job</h3>
<input type="text" id="searchText">
<ejs-button id="Search" content="Search"></ejs-button>
<ejs-grid id="TreeGrid" dataSource="ViewBag.datasource"
allowFiltering="true" allowSorting="true"
toolbar="@(new List<string> { "ExcelExport","PdfExport" })"
frozenColumns="2" allowPaging="true">
<e-grid-columns>
<e-grid-column field="JobNumber" headerText="Job#"></e-grid-column>
<e-grid-column field="CostCode" headerText="Cost Code"></e-grid-column>
<!-- Revenue, Cost, ManHours, Type, State, Customer, Lead… -->
</e-grid-columns>
</ejs-grid>
</div>
5. Account Ledger 🔒
Similar TreeGrid (TreeGrid2), fields include:
| Field | HeaderText | Format |
|---|---|---|
| JobNumber | Job# | – |
| AccountId | Acct# | – |
| Amount | Amount | C2 |
| Description | Desc | – |
| InvoiceDate | Invoice Date | date |
| GLDate | GL Date | date |
| … | … | … |
Search bound to #Search7 input.
6. Employees 👥
Tree‑structured grid (grid2):
- Fields:
JdeNumber,LastName,FirstName,JobName,EmployeeStatus - ChildMapping:
Children - Template:
<script id="emptemplate1">for JDE → employee details link
7. Equipment List 🚗
grid4 with TreeGrid, childMapping, custom jobtemplate4 links.
8. Work Orders 🛠️
- Equipment WO:
grid6 - Non‑Equipment WO:
grid8
Each supports search, export, date formatting viaload6/load8.
9. Purchase Orders 📦
grid5, date formatting in load5, jobtemplate5.
10. IT Assets 🖥️
grid7, search via Search8, template for employee link via emptemplate.
Grid Configurations ⚙️
- allowFiltering, allowSorting, allowReordering, allowTextWrap
- allowExcelExport, allowPdfExport, toolbar (
ExcelExport,PdfExport) - allowPaging (pageSize configured)
- frozenColumns for key identifier columns
- dataBound events auto‑fit columns
Chart Configurations 📉
<ejs-chart>with primaryXAxis valueType"Category"- type:
StackingLine,StackingColumn,Column - dashArray, marker, datalabel for enhanced readability
Templates & Modal 📦
- Document Modal: clicking
.anchorDetailloads/IView/DocumentView?id={DocumentId}into#myModalContentvia AJAX - Templates (
<script type="text/x-template">):emptemplate,emptemplate1– employee linkjobtemplate,jobtemplate4,jobtemplate5,jobtemplate6,jobtemplate8– job details linkdoctemplate– document name anchor
<script id="doctemplate" type="text/x-template">
<a href="javascript:void(0);" class="anchorDetail" data-id=${DocumentId}>${Name}</a>
</script>
Scripts & Event Handling 📝
| Functionality | Script Location | Description |
|---|---|---|
| Section Navigation | top <script> |
$("#Select").change(...) |
| Data‑bound autoFit | multiple dataBound* |
this.autoFitColumns([...]) |
| Date Formatting | load* functions |
set .columns[i].format = {type:'date',...} |
| Search Buttons | document.getElementById('SearchX') |
grid.search(val) |
| Export Toolbar | toolbarClick |
handle Excel/PDF/CSV exports |
| Modal Content Load | .anchorDetail click |
AJAX GET /IView/DocumentView |
API Endpoints Overview 🌐
- GET /IView/DocumentView?id={DocumentId}
Returns partial view for document display in modal.
No direct data‑post endpoints – all data is provided via the controller populating
Model&ViewBag.
Usage Examples 🔍
-
Controller populates:
public IActionResult getAccountBalanceDetail(int jobId) { var model = _service.GetBalances(jobId); ViewBag.datasource1 = model.SummaryTree; ViewBag.chartSource = model.MonthlyChart; // …other ViewBags… return View(model); } -
View references the model and renders the dashboard.
-
User navigates with dropdown or scrolls to anchors.
-
Search fields filter each grid instantly.
-
Export via toolbar to Excel/PDF.
UML Diagram 🛠️
classDiagram
class Balances {
+Job : JobDetails
+Details : List<BalanceDetail>
+Employees, Equipment, WorkOrders, PurchaseOrders, Assets : IEnumerable<>
}
class getAccountBalanceDetail {
+Render(Balances model)
+InitGrids()
+InitCharts()
}
Balances --> JobDetails
getAccountBalanceDetail ..> Balances : uses
Conclusion 🏁
getAccountBalanceDetail.cshtml delivers a rich, interactive dashboard for job account balances, combining Syncfusion grids & charts, AJAX‑driven modals, export capabilities, and deep drill‑downs into job, employee, equipment, and financial details. This view can be easily extended by populating additional data in the controller and adding new sections or charts as needed.