public void LoadWorkDuration()
{
DashboardProvider provider = null;
try
{
BeginDate = string.IsNullOrEmpty(this.hfStartDate.Value) ? DateTime.Parse(DateTime.UtcNow.AddDays(-15).ToString("yyyy-MM-dd").Replace("/", "-")) : DateTime.Parse(this.hfStartDate.Value);
EndDate = string.IsNullOrEmpty(this.hfEndDate.Value) ? DateTime.Parse(DateTime.UtcNow.ToString("yyyy-MM-dd").Replace("/", "-")) : DateTime.Parse(this.hfEndDate.Value);
// Create provider.
provider = new DashboardProvider();
provider.AppManager = this.mAppManager;
// Get dashboard item command.
SqlCommand itemCommand = provider.CreateItemCommand_Report(DashboardProvider.USER_WORK_DURATION);
// Assign parameters value.
itemCommand.Parameters["@UserId"].Value = this.mAppManager.LoginUser.Id;
itemCommand.Parameters["@BeginDate"].Value = BeginDate;
itemCommand.Parameters["@EndDate"].Value = EndDate;
// Retrieve item data.
DataSet dataSet = provider.RetrieveItemData(itemCommand);
DataTable dataTable = dataSet.Tables[0];
// Bind with chart.
Series series = this.chtWrkDuration.Series["Default"];
series.Points.DataBind(dataTable.DefaultView, "WorkDate", "WorkDuration1", "");
// Label values shown angel
series.LabelAngle = -90;
series.LabelFormat = "N2";
series.LabelForeColor = System.Drawing.Color.DarkBlue;
series.SmartLabelStyle.Enabled = false;
int i = 0;
foreach (var point in series.Points)
{
if (!string.IsNullOrEmpty(Convert.ToString(point.YValues[0])) && !Convert.ToString(point.YValues[0]).Equals("0"))
{
point.ToolTip = string.Concat("Hours ", Convert.ToString(dataTable.Rows[i]["WorkDuration1"]).Replace(".", ":"));
point.IsValueShownAsLabel = true;
}
i++;
}
}
catch { throw; }
}
public void LoadLabels()
{
DashboardProvider provider = null;
List <LblLanguage> lblLanguagelst = null;
ILblLanguage mLanguageService = null;
lblLanguagelst = new List <LblLanguage>();
provider = new DashboardProvider();
provider.AppManager = this.AppManager;
mLanguageService = AppService.Create <ILblLanguage>();
mLanguageService.AppManager = AppManager;
// retrieve
lblLanguagelst = mLanguageService.RetrieveLabel(AppManager.LoginUser.Id, "USERDURATIONWIDGET");
Utility _objUtil = new Utility();
_objUtil.LoadLabels(lblLanguagelst);
}
public void DisplayData()
{
DashboardProvider provider = null;
try
{
// Create provider.
provider = new DashboardProvider();
provider.AppManager = this.AppManager;
// Get dashboard item command.
SqlCommand itemCommand = provider.CreateItemCommand(DashboardProvider.USER_ACTIVITY_STATUS);
// Assign parameters value.
itemCommand.Parameters["@UserId"].Value = this.AppManager.LoginUser.Id;
// Retrieve item data.
DataSet dataSet = provider.RetrieveItemData(itemCommand);
DataTable dataTable = dataSet.Tables[0];
// Bind with chart.
this.Chart1.Series.Clear();
this.Chart1.DataBindCrossTable(dataTable.DefaultView, "Status", "ActivityDate", "ActivityCount", "");
foreach (Series series in this.Chart1.Series)
{
if (series.Name.Equals("Waiting For Approval", StringComparison.InvariantCultureIgnoreCase))
{
series.Color = System.Drawing.Color.FromArgb(236, 188, 67);
}
else if (series.Name.Equals("Approved Activity", StringComparison.InvariantCultureIgnoreCase))
{
series.LegendText = "Approved";
series.Color = System.Drawing.Color.FromArgb(67, 142, 83);
}
else if (series.Name.Equals("Rejected Activity", StringComparison.InvariantCultureIgnoreCase))
{
series.LegendText = "Rejected";
series.Color = System.Drawing.Color.FromArgb(236, 100, 74);
}
else if (series.Name.Equals("Resetted Activity", StringComparison.InvariantCultureIgnoreCase))
{
series.LegendText = "Resetted";
series.Color = System.Drawing.Color.FromArgb(85, 93, 131);
}
series.ChartType = SeriesChartType.StackedColumn;
series.SetCustomProperty("PointWidth", "0.8");
series.SetCustomProperty("DrawBySide", "false");
// Label values shown angel
series.LabelAngle = -90;
series.LabelForeColor = System.Drawing.Color.Black;
series.SmartLabelStyle.Enabled = false;
foreach (var point in series.Points)
{
if (!string.IsNullOrEmpty(Convert.ToString(point.YValues[0])) && !Convert.ToString(point.YValues[0]).Equals("0"))
{
point.ToolTip = string.Concat("Activity Count : ", Convert.ToString(point.YValues[0]));
point.IsValueShownAsLabel = true;
}
}
}
}
catch { throw; }
}
public DashboardController(DashboardProvider dashboardProvider)
{
this.dashboardProvider = dashboardProvider;
}
// GET: Fcpa/Dashboard
public ActionResult GetDashboard(int year)
{
var result = DashboardProvider.GetDashboard(year);
return(Json(result, JsonRequestBehavior.AllowGet));
}
public HomeController(SecurityProvider securityProvider, DashboardProvider dashboardProvider)
{
this.securityProvider = securityProvider;
this.dashboardProvider = dashboardProvider;
}
