Donate

ASP.NET MVC Sales Dashboard Demo Application

-
As I was doing some research on chart controls to be integrated in ASP.NET MVC, I found a working from Shield UI which is MVC 4 regarding Sales Dashboard. As I was running the application to the browser, only the left container shows the chart.
The right and bottom part does not show anything. It seems the remaining chart samples will be manually shown to the browser by entering the correct URL. To solve this, I added a ViewModel class, modified the HTML markup in the Index view and modified the codes in Home Controller. See updates below:

SalesDashboardViewModel.cs
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
 
namespace SalesDashboardMVC.Models
{
    public class SalesDashboardViewModel
    {
        public IEnumerable<QuarterlySales> Quarterly_Sales { get; set; }
        public IEnumerable<SalesByProduct> Sales_By_Products { get; set; }
        public IEnumerable<PerformanceData> Performance_Data { get; set; }        
    }
}

Home Controller
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
public class HomeController : Controller
    {
        private SalesDashboardViewModel modelSalesDashboard;
 
        public ActionResult Index()
        {
            modelSalesDashboard = new SalesDashboardViewModel();
            modelSalesDashboard.Quarterly_Sales = QuarterlySales.GetData();
            modelSalesDashboard.Performance_Data = PerformanceData.GetDataByQuarter("Q1");
            modelSalesDashboard.Sales_By_Products = SalesByProduct.GetDataByProductAndQuarter("Men", "Q1");
 
            return View(modelSalesDashboard);
        }}

Index View
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
@model SalesDashboardMVC.Models.SalesDashboardViewModel
 
<div class="dashboard">
    <div class="header">        
        Sales DashBoard using <span class="highlight">Shield UI ASP.NET Chart</span>        
    </div>
    <div class="topleft">
        @(Html.ShieldChart(Model.Quarterly_Sales)
            .Name("quarterlySales")
            .HtmlAttribute("class", "chart")
            .PrimaryHeader(header => header.Text("Quarterly Sales"))
            .Export(false)
            .Tooltip(tooltip => tooltip.CustomPointText("Sales Volume: <b>{point.y}</b>"))
            .AxisX(axisX => axisX.CategoricalValues(model => model.Quarter))
            .AxisY(axisY => axisY.Title(title => title.Text("Quarterly Overview")))
            .DataSeries(dataSeries => dataSeries
                .Bar()
                .Data(model => model.Sales)
                .EnablePointSelection(true))
            .ChartLegend(chartLegend => chartLegend
                .Align(Shield.Mvc.UI.Chart.Align.Center))
            .Events(events => events.PointSelect("app.quarterSelected")))
    </div>
    <div class="topright">
         @(Html.ShieldChart(Model.Performance_Data)
            .Name("productsByQuarter")
            .HtmlAttribute("class", "chart")
            .Export(false)
            .PrimaryHeader(header => header.Text("Select a Quarter to show products sales"))
            .AxisY(axisY => axisY.Title(title => title.Text("Break-Down for selected quarter")))
            .DataSeries(dataSeries => dataSeries
                .Donut()
                .Name("Q Data")
                .Data(model => new
                {
                    collectionAlias = model.Product,
                    x = model.Product, 
                    y = model.Data,
                })
                .EnablePointSelection(true)
                .AddToLegend(true))
            .ChartLegend(chartLegend => chartLegend.Align(Shield.Mvc.UI.Chart.Align.Center))
            .Events(events => events.PointSelect("app.productSelected")))      
      
    </div>
    <div class="bottom">  
         @(Html.ShieldChart(Model.Sales_By_Products)
            .Name("salesDetails")
            .HtmlAttribute("class", "chart")
            .PrimaryHeader(header => header.Text("Select a product to show sales details"))
            .Export(false)
            .DataSeries(dataSeries => dataSeries
                .Line()
                .Data(model => model.QuarterSales)
                .AddToLegend(false)))
    </div>
</div>

Screenshot:
Original Sample Code and Article Here: ASP.NET MVC Sales Dashboard Application

Greg Esguerra

Comments

Post a Comment

Donate

Popular Posts From This Blog

WPF CRUD Application Using DataGrid, MVVM Pattern, Entity Framework, And C#.NET

-
Image
Good day to all! Here's an example of a WPF CRUD (Create,Update and Delete) project using the DataGrid control, ADO.NET Entity Framework 6.x, C#.NET and Model–View–Viewmodel(MVVM) architectural pattern. This post was based from this tutorial WPF CRUD With DataGrid, Entity Framework And C#.NET except that we are now using the MVVM framework. The steps below are pretty straightforward and easy to follow. I. Project Setup 1. Add a table called Students in you database. The complete script is found in this post WPF CRUD With DataGrid, Entity Framework And C#.NET 2. Create a WPF Project and add four folders called DataAccess, Model, View and ViewModel. 3. Your project structure may look similar with the screenshot provided below. II. Coding The Model and Repository Class 1. Inside the Model folder, add an ADO.NET Entity Data Model that connects to the Students table in your database. On my part, I named it StudentModel . 2. For the connectionstring name in App.config file, I
Read more

How To Insert Or Add Emojis In Microsoft Teams Status Message

-
Image
Good day Gents! I was trying to update my Microsoft Teams status and was wondering if I can add or insert emoji. For editing or adding new teams status, only text fields are available and there's no emoji icon similar to writing a teams message. After googling for a few minutes, I found this link Emoji's in status which is a feature request in Microsoft Teams User's Voice Forum. So far this upgrade request only has thirty votes which is relatively small and may be considered a low priority for the product team to implement. Given the limitations at hand, I tried several approach including copying an emoji in a chat message which didn't work and later found a solution using Microsoft Outlook 365. First is to create a new email message in Microsoft Outlook and press (Window Key + .). The emoji dropdown control will appear. Next is to select the emoji that you wanted to add to Teams. Copy the emoji from the newly created email message template and paste that to Micr
Read more

TypeScript Error Or Bug: The term 'tsc' is not recognized as the name of a cmdlet, function, script file, or operable program.

-
Image
Good Day Gents! During this free-time I started setting up Node.js on my machine as part of my career goals which is learning new frameworks in preparation for new projects. So the first thing I did was to install TypeScript language to get myself familiar with Angular 2+. After I finished setting up TypeScript, I then created a simple HelloWorld program and ran the application through Visual Studio Code using the "tsc: build - tsconfig.json" command. I encountered an error which says "The term 'tsc' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again." Below are the details on my machine and packages installed:   - Operating System: Windows 10 Pro   - Node.js: 14.16.0   - npm version: 6.14.11   - Typescript: 4.2.3 (using command: "npm install -g typescript") After doing some research and reading thr
Read more