public async Task <JsonResult> BarData()
{
var devs = new List <PSUser>();
var users = await _context.Users.ToListAsync();
foreach (var user in users)
{
foreach (var role in await _userManager.GetRolesAsync(user))
{
if (role == "Developer")
{
devs.Add(user);
}
}
}
var list = new List <BarChartModel>();
var tickets = _context.Tickets.Include(t => t.TicketStatus);
foreach (var dev in devs)
{
var bar = new BarChartModel
{
Name = dev.FirstName,
NumAssigned = tickets
.Where(t => t.DeveloperUserId == dev.Id && t.TicketStatus.Name != "Closed")
.ToList().Count,
NumClosed = tickets.Where(t => t.DeveloperUserId == dev.Id && t.TicketStatus.Name == "Closed")
.ToList().Count
};
list.Add(bar);
}
return(Json(list));
}
public IHttpActionResult MonthlySalesForYearReport(int year)
{
SalesRepository salesRepository = new SalesRepository();
List <SumGroupByModel> monthlyInfoForYear = salesRepository.GetMonthlySalesDataForAYear(year);
monthlyInfoForYear = salesRepository.GetMonthlySalesDataForAYear(year);
List <BarChartModel> chart = new List <BarChartModel>();
string[] months = { "Jan", "Feb", "March", "April", "May", "June", "July", "Aug", "Sep", "Oct", "Nov", "Dec" };
int i, j;
int count = monthlyInfoForYear.Count();
//Adding All the Months and Giving the Sum Amount Zero to the chart
for (i = 0; i < 12; i++)
{
BarChartModel barChartModel = new BarChartModel(months[i], 0);
chart.Add(barChartModel);
}
//Now Assigning Value to the months where the Sum Amount exists for that particular month
for (i = 0; i < count; i++)
{
chart[monthlyInfoForYear[i].Id - 1].Y = monthlyInfoForYear[i].Column1;
}
return(Ok(chart));
}
public IHttpActionResult SingleBranchMonthlySales(int id, int year)
{
BranchRepository branchRepository = new BranchRepository();
List <SumGroupByModel> brvm = branchRepository.SingleBranchMonthlySales(id, year);
List <BarChartModel> chart = new List <BarChartModel>();
string[] months = { "Jan", "Feb", "March", "April", "May", "June", "July", "Aug", "Sep", "Oct", "Nov", "Dec" };
int i, j;
int count = brvm.Count();
//Adding All the Months and Giving the Sum Amount Zero to the chart
for (i = 0; i < 12; i++)
{
BarChartModel barChartModel = new BarChartModel(months[i], 0);
chart.Add(barChartModel);
}
//Now the Assigning Value to the months where the Sum Amount exists for that particular month
for (i = 0; i < count; i++)
{
chart[brvm[i].Id - 1].Y = brvm[i].Column1;
}
return(Ok(chart));
}
public IHttpActionResult DiscountReportByBranch()
{
List <DiscountViewModel> discountModels = new List <DiscountViewModel>();
List <DiscountReportViewModel> model = new List <DiscountReportViewModel>();
model = invoiceRepository.DiscountReportByBranch();
foreach (var item in model)
{
DiscountViewModel discount = new DiscountViewModel();
discount.Branch_Id = item.BranchId;
discount.Column1 = item.Discount;
discountModels.Add(discount);
}
List <BarChartModel> barCharts = new List <BarChartModel>();
foreach (DiscountViewModel item in discountModels)
{
DiscountViewModel dvm = new DiscountViewModel();
BranchRepository branch = new BranchRepository();
string branchName = branch.Get(item.Branch_Id).Name;
dvm.Column1 = item.Column1;
BarChartModel barChart = new BarChartModel(branchName, (double)dvm.Column1);
barCharts.Add(barChart);
}
var lsitOfData = Newtonsoft.Json.JsonConvert.SerializeObject(barCharts);
return(Ok(barCharts));
}
private ObservableCollection <BarChartModel> UpdateDataList(CubeDTO[] data)
{
ViolationsCollection = data;
var dataList = new ObservableCollection <BarChartModel>();
var targetvalue =
ViolationsCollection.FirstOrDefault(item => item.LegendName.ToLower().Contains("target"));
foreach (var cubeDto in ViolationsCollection)
{
var barChartModel = new BarChartModel();
barChartModel.Key = cubeDto.LegendName;
barChartModel.Value = cubeDto.Details[0].Value;
if (cubeDto.LegendName.Trim() == this.ToYearValue.ToString())
{
barChartModel.Color = targetvalue.Details[0].Value < barChartModel.Value ? "Red" : "#2E9D01";
BorderColor = targetvalue.Details[0].Value < barChartModel.Value ? "Red" : "#00ffcc";
dataList.Add(barChartModel);;
}
else if (cubeDto.LegendName.Trim() == FromYearValue.ToString())
{
barChartModel.Color = "#0090FF";
dataList.Insert(0, barChartModel);
}
else
{
barChartModel.Color = "#5E2A05";
dataList.Insert(1, barChartModel);
}
}
return(dataList);
}
public ActionResult TopThreeCustomerGraph()
{
pchutEntities2 context1 = new pchutEntities2();
var list1 = context1.Database.SqlQuery <TopCustomerViewModel>("select top 3 user_id, sum(total_ammount) as Column1 from invoice group by user_id order by sum(total_ammount) desc").ToList();
List <BarChartModel> topThreeCustomers = new List <BarChartModel>();
foreach (TopCustomerViewModel topThree in list1)
{
TopCustomerViewModel tcvm = new TopCustomerViewModel();
UserRepository user = new UserRepository();
var userDetails = user.Get(topThree.User_Id);
user userInfo = new user();
userInfo.user_name = userDetails.user_name;
//tcvm.User_Id = topThree.User_Id;
tcvm.Column1 = topThree.Column1;
BarChartModel topChartModel = new BarChartModel(userInfo.user_name, (double)tcvm.Column1);
topThreeCustomers.Add(topChartModel);
}
ViewBag.DataPoints = Newtonsoft.Json.JsonConvert.SerializeObject(topThreeCustomers);
return(View());
}
public IHttpActionResult TopThreeCustomerGraph()
{
context = new PcHutDbContext();
var list1 = context.Database.SqlQuery <TopCustomerViewModel>("select top 3 CustomerId as User_id, sum(Invoices.TotalAmount) as Column1 from Invoices group by CustomerId order by sum(Invoices.TotalAmount) desc").ToList();
List <BarChartModel> topThreeCustomers = new List <BarChartModel>();
foreach (TopCustomerViewModel topThree in list1)
{
TopCustomerViewModel tcvm = new TopCustomerViewModel();
CustomerRepository user = new CustomerRepository();
var userDetails = user.Get(topThree.User_Id);
Customer userInfo = new Customer();
userInfo.Name = userDetails.Name;
//tcvm.User_Id = topThree.User_Id;
tcvm.Column1 = topThree.Column1;
BarChartModel topChartModel = new BarChartModel(userInfo.Name, (double)tcvm.Column1);
topThreeCustomers.Add(topChartModel);
}
var listofData = Newtonsoft.Json.JsonConvert.SerializeObject(topThreeCustomers);
//foreach()
return(Ok(topThreeCustomers));
}
public IHttpActionResult TopBrandGraph(int id)
{
List <TopCategoryViewModel> temp = new List <TopCategoryViewModel>();
temp = brandRepository.TopBrands(id);
//List<TopCategoryViewModel> tbvm = new List<TopCategoryViewModel>();
var tbvm = temp.GroupBy(p => p.Id).Select(g => new { Id = g.Key, totalQuantity = g.Sum(p => p.Quantity) }).ToList();
var newList = tbvm.OrderBy(x => x.totalQuantity);
var revList = newList.Reverse();// BrandId with highest quanity goes on top
List <BarChartModel> barCharts = new List <BarChartModel>();
foreach (var item in revList)
{
string name = brandRepository.Get(item.Id).Name;
BarChartModel barChart = new BarChartModel(name, item.totalQuantity);
barCharts.Add(barChart);
}
var lsitOfData = Newtonsoft.Json.JsonConvert.SerializeObject(barCharts);
return(Ok(barCharts));
}
public IHttpActionResult CategoryProductAmountChart()
{
CategoryRepository categoryRepository = new CategoryRepository();
var list = categoryRepository.NumberOfProductsInCategory();
List <BarChartModel> categoriesProductAmount = new List <BarChartModel>();
foreach (var data in list)
{
BarChartModel chart = new BarChartModel(data.Name, data.Count);
categoriesProductAmount.Add(chart);
}
return(Ok(categoriesProductAmount));
}
public IHttpActionResult SalesReportByBranch(int id)
{
BranchRepository branchRepository = new BranchRepository();
List <SumGroupByModel> brvm = branchRepository.SingleBranch(id);
List <BarChartModel> chart = new List <BarChartModel>();
foreach (SumGroupByModel sumGroupByModel in brvm)
{
BarChartModel barChartModel = new BarChartModel(sumGroupByModel.Id.ToString(), sumGroupByModel.Column1);
chart.Add(barChartModel);
}
return(Ok(chart));
}
// GET: Category
public ActionResult CategoryProductAmountChart()
{
CategoryRepository categoryRepository = new CategoryRepository();
var list = categoryRepository.NumberOfProductsInCategory();
List <BarChartModel> categoriesProductAmount = new List <BarChartModel>();
foreach (var data in list)
{
BarChartModel chart = new BarChartModel(data.Name, (double)data.DefaultCount);
categoriesProductAmount.Add(chart);
}
ViewBag.DataPoints = Newtonsoft.Json.JsonConvert.SerializeObject(categoriesProductAmount);
return(View());
}
public async Task <ActionResult> GetTopRobotCompaniesByRobotAndRentsCountAsync(int?count)
{
var filterParams = new RobotPopularityFilterParamsDto
{
Type = RobotPopularity.ByRobotAndRentCount,
CountToTake = count ?? 5
};
var companies = await _robotCompanyService.GetTopNPopularCompaniesAsync(filterParams);
var response = new BarChartModel
{
Titles = companies.Select(t => t.Name),
RobotRentsCount = companies.Select(t => t.CountOfRents),
RobotsCount = companies.Select(t => t.CountOfRobots)
};
return(Json(JsonResultData.Success(response)));
}
public async void AudienceHelpFunction(int a, int b, int c, int d)
{
BarChartModel barChartModel = new BarChartModel();
barChartModel.BarValue = a;
barChartModel.BarColor = Color.ParseColor("#9C27B0");
barChartModel.BarTag = "Α"; //You can set your own tag to bar model
barChartModel.BarText = a.ToString();
BarChartModel barChartModel2 = new BarChartModel();
barChartModel2.BarValue = b;
barChartModel2.BarColor = Color.ParseColor("#9C27B0");
barChartModel2.BarTag = "Β"; //You can set your own tag to bar model
barChartModel2.BarText = b.ToString();
BarChartModel barChartModel3 = new BarChartModel();
barChartModel3.BarValue = c;
barChartModel3.BarColor = Color.ParseColor("#9C27B0");
barChartModel3.BarTag = "Γ"; //You can set your own tag to bar model
barChartModel3.BarText = c.ToString();
BarChartModel barChartModel4 = new BarChartModel();
barChartModel4.BarValue = d;
barChartModel4.BarColor = Color.ParseColor("#9C27B0");
barChartModel4.BarTag = "Δ"; //You can set your own tag to bar model
barChartModel4.BarText = d.ToString();
barChart.AddBar(barChartModel);
barChart.AddBar(barChartModel2);
barChart.AddBar(barChartModel3);
barChart.AddBar(barChartModel4);
await Task.Delay(1500);
Sounds();
await Task.Delay(7000);
this.Dismiss();
}
public IHttpActionResult TopCategoryGraph(int id)
{
List <TopCategoryViewModel> tcvm = new List <TopCategoryViewModel>();
tcvm = CategoryRepository.TopCategory(id);
var newList = tcvm.OrderBy(x => x.Quantity);
var revList = newList.Reverse();// categoryId with highest quanity goes on top of list
List <BarChartModel> barCharts = new List <BarChartModel>();
foreach (var item in revList)
{
string catName = CategoryRepository.Get(item.Id).Name;
BarChartModel barChart = new BarChartModel(catName, (double)item.Quantity);
barCharts.Add(barChart);
}
var lsitOfData = Newtonsoft.Json.JsonConvert.SerializeObject(barCharts);
return(Ok(barCharts));
}
private void Add_ViolationsDetails(CubeDTO[] data)
{
Application.Current.Dispatcher.Invoke(() =>
{
ViolationsCollection = data;
DataList = new ObservableCollection <BarChartModel>();
var targetvalue =
ViolationsCollection.FirstOrDefault(item => item.LegendName.ToLower().Contains("target"));
foreach (var cubeDto in ViolationsCollection)
{
var barChartModel = new BarChartModel();
barChartModel.Key = cubeDto.LegendName;
barChartModel.Value = cubeDto.Details[0].Value;
if (cubeDto.LegendName.Trim() == this.ToYearValue.ToString())
{
if (targetvalue.Details[0].Value < barChartModel.Value)
{
barChartModel.Color = "Red";
}
else
{
barChartModel.Color = "#2E9D01";
}
DataList.Add(barChartModel);;
}
else if (cubeDto.LegendName.Trim() == FromYearValue.ToString())
{
barChartModel.Color = "#0090FF";
DataList.Insert(0, barChartModel);
}
else
{
barChartModel.Color = "#5E2A05";
DataList.Insert(1, barChartModel);
}
}
});
}
public ActionResult ChartDemo()
{
var strfrom = "/upload/abc.mp4";
var strnew = "/upload/ab.flv";
var widthandheight = "480x360";
var info = VideoConvertFlv(strfrom, strnew, widthandheight);
Response.Write(info);
var html = MakeFlvHtml("upload/ab.flv", 200, 100);
Response.Write(html);
var chartModels = new List<ChartModel>();
var toPayChart = new PieChartModel
{
Name = "2012年应付金额",
Data = new List<decimal> { 200, 500, 300, 400, 150 },
Legends = new List<string> { "服装费", "住宿费", "取暖费", "能源费", "通讯费" },
Width = 600, //Optional
Height = 600 //Optional
};
chartModels.Add(toPayChart);
var barChart = new BarChartModel
{
Name = "2012年销售",
GroupNames = new List<string> { "Q1", "Q2", "Q3", "Q4" },
ColLegends = new List<string> { "苹果", "香蕉" },
Width = 800, //Optional
Height = 400 //Optional
};
barChart.Add(new List<decimal> { 10, 12 });
barChart.Add(new List<decimal> { 11, 15 });
barChart.Add(new List<decimal> { 5, 6 });
barChart.Add(new List<decimal> { 5, 7 });
chartModels.Add(barChart);
ViewData["Chart"] = chartModels.ToHtml();
return View();
}