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));
}
