public GraphDetails GenerateDashboardData(GraphDetails objGraphDetails) { #region Call API objGraphDetails = WebApiLogic.GetPostComplexTypeToAPI <GraphDetails>(objGraphDetails, "LoadDashboardData", "DashBoard"); #endregion return(objGraphDetails); }
public GraphDetails SaveDashboardData(GraphDetails objGraphDetails) { #region Call API objGraphDetails = WebApiLogic.GetPostComplexTypeToAPI <GraphDetails>(objGraphDetails, "GetAppointmentGrid", "DashBoard"); #endregion return(objGraphDetails); }
private void GetGraphDetails(ref GraphDetails objGraphDetails) { using (AVOAIALifeEntities entity = new AVOAIALifeEntities()) { int reportID = objGraphDetails.ReportID; var graphDetails = entity.tblDashboardReports.Where(a => a.ReportID == reportID).FirstOrDefault(); objGraphDetails.ReportName = graphDetails.ReportTitle; objGraphDetails.Theme = graphDetails.Theme; objGraphDetails.Type = graphDetails.Type; //objGraphDetails.CategoryField = graphDetails.YAxisTitle; objGraphDetails.StartDuration = Convert.ToInt32(graphDetails.StartDuration); objGraphDetails.PlotAreaFillAlphas = graphDetails.PlotAreaFillAlphas ?? 0; objGraphDetails.GraphHeight = graphDetails.Height; objGraphDetails.GraphWidth = graphDetails.Width; objGraphDetails.IsGrowth = graphDetails.IsGrowth ?? false; objGraphDetails.Rotate = graphDetails.Rotate ?? false; objGraphDetails.valueAxes.position = graphDetails.VAPosition; objGraphDetails.valueAxes.labelsEnabled = graphDetails.VALabelsEnabled ?? false; objGraphDetails.valueAxes.title = graphDetails.ValueAxisTitle; objGraphDetails.valueAxes.unit = graphDetails.ValueAxisUnit; objGraphDetails.lstvalueAxes.Add(objGraphDetails.valueAxes); objGraphDetails.strvalueAxes = JsonConvert.SerializeObject(objGraphDetails.lstvalueAxes); objGraphDetails.categoryAxis.gridPosition = "start"; objGraphDetails.categoryAxis.position = "left"; objGraphDetails.categoryAxis.axisAlpha = 0; objGraphDetails.categoryAxis.tickLength = 0; objGraphDetails.categoryAxis.labelRotation = graphDetails.LabelRotation ?? 0; objGraphDetails.strcategoryAxis = JsonConvert.SerializeObject(objGraphDetails.categoryAxis); objGraphDetails.IsDrillDown = graphDetails.IsDrillDown ?? false; objGraphDetails.Depth3D = graphDetails.depth3D != null ? graphDetails.depth3D : 0; objGraphDetails.Angle = graphDetails.angle != null ? graphDetails.angle : 0; } }
public ActionResult DemoGraphGI(string ReportType) { GraphDetails obj = new GraphDetails(); obj.GraphType = ReportType; return(View(obj)); }
public GraphDetails GenerateDashboardData(GraphDetails objGraphDetails) { objGraphDetails.UserId = Context.tblUserDetails.Where(a => a.LoginID == objGraphDetails.UserName).Select(a => a.UserID).FirstOrDefault() ?? new Guid(); GetGraphDetails(ref objGraphDetails); GetDataProvider(ref objGraphDetails); GetGraphs(ref objGraphDetails); return(objGraphDetails); }
public ActionResult MakeBarChart(int ReportID) { GraphDetails objGraphDetails = new GraphDetails(); objGraphDetails.GraphType = "Column"; objGraphDetails.IsDrillDown = true; #region Call API objGraphDetails.ReportID = ReportID; objGraphDetails = objDashboardLogic.GenerateDashboardData(objGraphDetails); #endregion return(View("~/Views/DashBoard/PartialColumnChart.cshtml", objGraphDetails)); }
public JsonResult MakeChart(int ReportID, string UserName) { if (!string.IsNullOrEmpty(UserName)) { Username = CrossCutting.CrossCutting_EncryptDecrypt.Decrypt(UserName); } GraphDetails objGraphDetails = new GraphDetails(); DashBoardBL dashBoard = new DashBoardBL(); objGraphDetails.ReportID = ReportID; objGraphDetails.UserName = Username; objGraphDetails = dashBoard.GenerateDashboardData(objGraphDetails); return(Json(objGraphDetails, JsonRequestBehavior.AllowGet)); }
public ActionResult GetAppointmentGrid(GraphDetails objAppointdetails) { try { AjaxGrid <MyCalendar> usergrid = null; //objAppointdetails = WebApiLogic.GetPostComplexTypeToAPI<GraphDetails>(objAppointdetails, "LoadAppointmentData", "DashBoardLifeApi"); //var GridUserData = objAppointdetails.appointmentList.AsQueryable(); ViewBag.Details = objAppointdetails; TempData["Load"] = "FirstTime"; // usergrid = (AjaxGrid<MyCalendar>)new AjaxGridFactory().CreateAjaxGrid("", 1, false); return(PartialView("~/Views/DashBoard/_AppointmentGrid.cshtml", usergrid)); } catch (Exception Ex) { return(View("Error")); } }
public GraphDetails LoadDashboardData(GraphDetails objGraphDetails) { DashBoardLogic objLogic = new DashBoardLogic(); return(objLogic.GenerateDashboardData(objGraphDetails)); }
public ActionResult ReportViewer(int ReportID) { GraphDetails objGraphDetails = new GraphDetails(); return(View(objGraphDetails)); }
public GraphDetails SaveCalendarAppointment(GraphDetails objGraphDetails) { return(objDashboardLogic.SaveDashboardData(objGraphDetails)); }
public GraphDetails GenerateDashboardData(GraphDetails objGraphDetails) { DashBoardBL objBusiness = new DashBoardBL(); return(objBusiness.GenerateDashboardData(objGraphDetails)); }
private void GetDataProvider(ref GraphDetails objGraphDetails) { using (AVOAIALifeEntities entity = new AVOAIALifeEntities()) { int reportID = objGraphDetails.ReportID; Guid userId = objGraphDetails.UserId; var data = entity.tblDashboardSubReports.Where(a => a.ReportID == reportID && a.UserId == userId).ToList(); if (objGraphDetails.IsDrillDown) { data = entity.tblDashboardSubReports.Where(a => a.ReportID == reportID && a.ParentId == null && a.UserId == userId ).ToList(); foreach (var item in data) { Dictionary <string, string> datap = new Dictionary <string, string>(); objGraphDetails.CategoryField = item.YAxisTitle; datap.Add(item.YAxisTitle, item.YAxisValue1); foreach (var axis in entity.tblDashboardXAxis.Where(a => a.SubReportID == item.SubReportID).ToList()) { datap.Add(axis.XAxisTitle, axis.XAxisValue); datap.Add(axis.ColorCodeTitle, axis.ColorCode); } datap.Add("url", "#"); datap.Add("description", "click to drill-down"); var Childata = entity.tblDashboardSubReports.Where(a => a.ParentId == item.SubReportID).ToList(); if (Childata != null && Childata.Count() > 0) { List <Dictionary <string, string> > ChilDataProvider = new List <Dictionary <string, string> >(); foreach (var childitem in Childata) { Dictionary <string, string> Child = new Dictionary <string, string>(); Child.Add(item.YAxisTitle, item.YAxisValue1); foreach (var axis in entity.tblDashboardXAxis.Where(a => a.SubReportID == childitem.SubReportID).ToList()) { Child.Add(axis.XAxisTitle, axis.XAxisValue); Child.Add(axis.ColorCodeTitle, axis.ColorCode); } ChilDataProvider.Add(Child); } datap.Add("data", JsonConvert.SerializeObject(ChilDataProvider)); } objGraphDetails.DataProvider.Add(datap); } } else { foreach (var item in data) { Dictionary <string, string> datap = new Dictionary <string, string>(); objGraphDetails.CategoryField = item.YAxisTitle; datap.Add(item.YAxisTitle, item.YAxisValue1); foreach (var axis in entity.tblDashboardXAxis.Where(a => a.SubReportID == item.SubReportID).ToList()) { datap.Add(axis.XAxisTitle, axis.XAxisValue); datap.Add(axis.ColorCodeTitle, axis.ColorCode); } objGraphDetails.DataProvider.Add(datap); } } } objGraphDetails.strDataProvider = JsonConvert.SerializeObject(objGraphDetails.DataProvider); }
private void GetGraphs(ref GraphDetails objGraphDetails) { using (AVOAIALifeEntities entity = new AVOAIALifeEntities()) { int reportID = objGraphDetails.ReportID; if (objGraphDetails.IsDrillDown) { objGraphDetails.lstGraphs = entity.tblDashboardReportGraphs.Where(a => a.ReportID == reportID).Select(a => new Graphs { balloonText = a.BallonText, fillAlphas = a.FillAlphas ?? 0, title = a.Title, type = a.Type, labelText = a.LabelText, valueField = a.ValueField, lineAlpha = a.LineAplhas ?? 0, fixedColumnWidth = a.FixedColumnWidth ?? 0, //fillColorsField = a.FillColorsField, //bulletColor = a.BulletColor, //bullet = a.Bullet, bulletBorderAlpha = a.BulletBorderAlpha ?? 0, bulletSize = a.BulletSize ?? 0, useLineColorForBulletBorder = a.UseLineColorForBulletBorder ?? false, lineThickness = a.LineThickness ?? 0, dashLengthField = "dashLengthColumn", urlField = "url", alphaField = "alpha" }).ToList(); } else { objGraphDetails.lstGraphs = entity.tblDashboardReportGraphs.Where(a => a.ReportID == reportID).Select(a => new Graphs { balloonText = a.BallonText, fillAlphas = a.FillAlphas ?? 0, title = a.Title, type = a.Type, labelText = a.LabelText, valueField = a.ValueField, lineAlpha = a.LineAplhas ?? 0, fixedColumnWidth = a.FixedColumnWidth ?? 0, fillColorsField = a.FillColorsField, bulletColor = a.BulletColor, bullet = a.Bullet, bulletBorderAlpha = a.BulletBorderAlpha ?? 0, bulletSize = a.BulletSize ?? 0, useLineColorForBulletBorder = a.UseLineColorForBulletBorder ?? false, lineThickness = a.LineThickness ?? 0, }).ToList(); } objGraphDetails.graphs = entity.tblDashboardReportGraphs.Where(a => a.ReportID == reportID).Select(a => new Graphs { balloonText = a.BallonText, fillAlphas = a.FillAlphas ?? 0, title = a.Title, type = a.Type, labelText = a.LabelText, valueField = a.ValueField, lineAlpha = a.LineAplhas ?? 0, fixedColumnWidth = a.FixedColumnWidth ?? 0, fillColorsField = a.FillColorsField, bulletColor = a.BulletColor, bullet = a.Bullet, bulletBorderAlpha = a.BulletBorderAlpha ?? 0, bulletSize = a.BulletSize ?? 0, useLineColorForBulletBorder = a.UseLineColorForBulletBorder ?? false, lineThickness = a.LineThickness ?? 0, }).FirstOrDefault(); } objGraphDetails.strlstGraphs = JsonConvert.SerializeObject(objGraphDetails.lstGraphs); }
private void GetDataProvider(ref GraphDetails objGraphDetails) { using (AVOAIALifeEntities entity = new AVOAIALifeEntities()) { int reportID = objGraphDetails.ReportID; Guid userId = objGraphDetails.UserId; var data = entity.tblDashboardSubReports.Where(a => a.ReportID == reportID && a.UserId == userId).ToList(); if (objGraphDetails.IsDrillDown) { data = entity.tblDashboardSubReports.Where(a => a.ReportID == reportID && a.ParentId == null && a.UserId == userId ).ToList(); foreach (var item in data) { Dictionary <string, string> datap = new Dictionary <string, string>(); objGraphDetails.CategoryField = item.YAxisTitle; datap.Add(item.YAxisTitle, item.YAxisValue1); datap.Add(item.XAxisTitle1, item.XAxisValue1); if (!string.IsNullOrEmpty(item.ColorCodeTitle1)) { datap.Add(item.ColorCodeTitle1, item.ColorCode1); } if (!string.IsNullOrEmpty(item.XAxisTitle2)) { datap.Add(item.XAxisTitle2, item.XAxisValue2); } if (!string.IsNullOrEmpty(item.ColorCodeTitle2)) { datap.Add(item.ColorCodeTitle2, item.ColorCode2); } if (!string.IsNullOrEmpty(item.XAxisTitle3)) { datap.Add(item.XAxisTitle3, item.XAxisValue3); } datap.Add("url", "#"); datap.Add("description", "click to drill-down"); var Childata = entity.tblDashboardSubReports.Where(a => a.ParentId == item.SubReportID).ToList(); if (Childata != null && Childata.Count() > 0) { List <Dictionary <string, string> > ChilDataProvider = new List <Dictionary <string, string> >(); foreach (var childitem in Childata) { Dictionary <string, string> Child = new Dictionary <string, string>(); Child.Add(childitem.YAxisTitle, childitem.YAxisValue1); Child.Add(childitem.XAxisTitle1, childitem.XAxisValue1); if (!string.IsNullOrEmpty(childitem.ColorCodeTitle1)) { Child.Add(childitem.ColorCodeTitle1, childitem.ColorCode1); } if (!string.IsNullOrEmpty(childitem.XAxisTitle2)) { Child.Add(childitem.XAxisTitle2, childitem.XAxisValue2); } if (!string.IsNullOrEmpty(childitem.ColorCodeTitle2)) { Child.Add(childitem.ColorCodeTitle2, childitem.ColorCode2); } if (!string.IsNullOrEmpty(childitem.XAxisTitle3)) { Child.Add(childitem.XAxisTitle3, childitem.XAxisValue3); } ChilDataProvider.Add(Child); } datap.Add("data", JsonConvert.SerializeObject(ChilDataProvider)); } objGraphDetails.DataProvider.Add(datap); } } else { foreach (var item in data) { Dictionary <string, string> datap = new Dictionary <string, string>(); objGraphDetails.CategoryField = item.YAxisTitle; datap.Add(item.YAxisTitle, item.YAxisValue1); datap.Add(item.XAxisTitle1, item.XAxisValue1); if (!string.IsNullOrEmpty(item.ColorCodeTitle1)) { datap.Add(item.ColorCodeTitle1, item.ColorCode1); } if (!string.IsNullOrEmpty(item.XAxisTitle2)) { datap.Add(item.XAxisTitle2, item.XAxisValue2); } if (!string.IsNullOrEmpty(item.ColorCodeTitle2)) { datap.Add(item.ColorCodeTitle2, item.ColorCode2); } if (!string.IsNullOrEmpty(item.XAxisTitle3)) { datap.Add(item.XAxisTitle3, item.XAxisValue3); } objGraphDetails.DataProvider.Add(datap); } } //if (data.Count > 1 && objGraphDetails.IsGrowth) //{ // decimal prev = Convert.ToDecimal(data[0].XAxisValue1); // decimal present = Convert.ToDecimal(data[1].XAxisValue1); // growth = GetGrowthRate(prev, present); // if (objGraphDetails.ReportID == 2) // objGraphDetails.Growth = "CI " + growth + "%"; // else // objGraphDetails.Growth = "Growth " + growth + "%"; // if (!string.IsNullOrEmpty(data[0].XAxisTitle2)) // { // decimal prevCII = Convert.ToDecimal(data[0].XAxisValue2); // decimal presentCII = Convert.ToDecimal(data[1].XAxisValue2); // string growthII = GetGrowthRate(prevCII, presentCII); // if (objGraphDetails.ReportID == 2) // objGraphDetails.Growth += " CII " + growthII + "%"; // else // objGraphDetails.Growth += " Growth " + growthII + "%"; // } //} } objGraphDetails.strDataProvider = JsonConvert.SerializeObject(objGraphDetails.DataProvider); }
public ActionResult MyCalendar() { GraphDetails obj = new GraphDetails(); return(View(obj)); }