getAccountBalanceDetail.cshtml 📄


Table of Contents

  1. Overview & Purpose 🚀
  2. Technologies & Dependencies 🔧
  3. Layout & Styles 🎨
  4. Navigation Menu 🧭
  5. View Model & Data Models 📦
  6. Key Sections 📑
  7. Grid Configurations ⚙️
  8. Chart Configurations 📉
  9. Templates & Modal 📦
  10. Scripts & Event Handling 📝
  11. API Endpoints Overview 🌐
  12. Usage Examples 🔍
  13. UML Diagram 🛠️
  14. 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>

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 sources
  • ViewBag.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 via load6/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 .anchorDetail loads /IView/DocumentView?id={DocumentId} into #myModalContent via AJAX
  • Templates (<script type="text/x-template">):
    • emptemplate, emptemplate1 – employee link
    • jobtemplate, jobtemplate4, jobtemplate5, jobtemplate6, jobtemplate8 – job details link
    • doctemplate – 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 🔍

  1. 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);
    }
    
  2. View references the model and renders the dashboard.

  3. User navigates with dropdown or scrolls to anchors.

  4. Search fields filter each grid instantly.

  5. 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.