public async Task <JsonResult> OIAPIUsagestatisticsReFresh()
{
OIDashboard model = new OIDashboard();
//model = GetOIDashboard();
try
{
//set API Usage Count from cosmos DB
string url = Request.Url.Scheme + "://" + Request.Url.Authority;
string[] hostParts = new System.Uri(url).Host.Split('.');
string SubDomain = hostParts[0];
string CallType = "CMOI";
int ResultCode = 200;
/*Set default value to 0*/
model.MonthCount = Convert.ToString(await GetCurrentMonthLogsCount(SubDomain, CallType, ResultCode));
model.FormatMonthCount = CommonMethod.FormatNumber(model.MonthCount);
model.HourlyAPIUsageCount = Convert.ToString(await GetHourlyLogsCount(SubDomain, CallType, ResultCode));
model.FormatHourlyAPIUsageCount = CommonMethod.FormatNumber(model.HourlyAPIUsageCount);
}
catch (Exception ex)
{
//Empty catch block to stop from breaking
}
return(Json(model, JsonRequestBehavior.AllowGet));
}
public OIDashboard GetOIDashboard()
{
//Set Data Queue count
OIDashboard oIDashboard = new OIDashboard();
OIDashboardFacade fac = new OIDashboardFacade(this.CurrentClient.ApplicationDBConnectionString);
DataSet ds = fac.GetDashboardQueueCount();
if (ds != null && ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
if (dt != null && dt.Rows != null && dt.Rows.Count > 0)
{
oIDashboard.ImportProcess = dt.Rows[0]["ImportProcess"] is DBNull ? "" : Convert.ToString(dt.Rows[0]["ImportProcess"]);
oIDashboard.AllCount = dt.Rows[0]["TotalRecordCount"] is DBNull ? "" : Convert.ToString(dt.Rows[0]["TotalRecordCount"]);
oIDashboard.InputRecordCount = dt.Rows[0]["InputRecordCount"] is DBNull ? "" : Convert.ToString(dt.Rows[0]["InputRecordCount"]);
oIDashboard.UnMatchRecordCount = dt.Rows[0]["UnMatchedRecordCount"] is DBNull ? "" : Convert.ToString(dt.Rows[0]["UnMatchedRecordCount"]);
oIDashboard.MatchedOutputQueueCount = dt.Rows[0]["MatchedOutputQueueCount"] is DBNull ? "" : Convert.ToString(dt.Rows[0]["MatchedOutputQueueCount"]);
oIDashboard.ArchivalQueueCount = dt.Rows[0]["ArchivalQueueCount"] is DBNull ? "" : Convert.ToString(dt.Rows[0]["ArchivalQueueCount"]);
oIDashboard.FirmographicsExportQueueCount = dt.Rows[0]["FirmographicsExportQueueCount"] is DBNull ? "" : Convert.ToString(dt.Rows[0]["FirmographicsExportQueueCount"]);
oIDashboard.FormatAllCount = CommonMethod.FormatNumber(oIDashboard.AllCount);
oIDashboard.FormatUnMatchRecordCount = CommonMethod.FormatNumber(oIDashboard.UnMatchRecordCount);
oIDashboard.FormatMatchedOutputQueueCount = CommonMethod.FormatNumber(oIDashboard.MatchedOutputQueueCount);
oIDashboard.FormatArchivalQueueCount = CommonMethod.FormatNumber(oIDashboard.ArchivalQueueCount);
oIDashboard.FormatFirmographicsExportQueueCount = CommonMethod.FormatNumber(oIDashboard.FirmographicsExportQueueCount);
oIDashboard.FormatInputRecordCount = CommonMethod.FormatNumber(oIDashboard.InputRecordCount);
}
else
{
oIDashboard.ImportProcess = "0";
oIDashboard.InputRecordCount = "0";
oIDashboard.AllCount = "0";
oIDashboard.UnMatchRecordCount = "0";
oIDashboard.MatchedOutputQueueCount = "0";
oIDashboard.ArchivalQueueCount = "0";
oIDashboard.FirmographicsExportQueueCount = "0";
oIDashboard.FormatAllCount = "0";
oIDashboard.FormatUnMatchRecordCount = "0";
oIDashboard.FormatMatchedOutputQueueCount = "0";
oIDashboard.FormatArchivalQueueCount = "0";
oIDashboard.FormatFirmographicsExportQueueCount = "0";
oIDashboard.FormatInputRecordCount = "0";
}
if (ds.Tables.Count > 1)
{
DataTable dt2 = ds.Tables[1];
if (dt2 != null && dt2.Rows != null && dt2.Rows.Count > 0)
{
oIDashboard.CorporateTreeExportQueueCount = dt2.Rows[0]["CorporateTreeExportQueueCount"] is DBNull ? "" : Convert.ToString(dt2.Rows[0]["CorporateTreeExportQueueCount"]);
oIDashboard.FormatCorporateTreeExportQueueCount = CommonMethod.FormatNumber(oIDashboard.CorporateTreeExportQueueCount);
}
}
}
return(oIDashboard);
}
public async System.Threading.Tasks.Task <ActionResult> Index()
{
OIDashboard model = new OIDashboard();
//Set Data Queue count
model = GetOIDashboard();
try
{
string url = Request.Url.Scheme + "://" + Request.Url.Authority;
string[] hostParts = new System.Uri(url).Host.Split('.');
string SubDomain = hostParts[0];
//set API Usage Count from mongo DB
string CallType = "CMOI";
int ResultCode = 200;
model.MonthCount = Convert.ToString(await GetCurrentMonthLogsCount(SubDomain, CallType, ResultCode));
model.FormatMonthCount = CommonMethod.FormatNumber(model.MonthCount);
model.HourlyAPIUsageCount = Convert.ToString(await GetHourlyLogsCount(SubDomain, CallType, ResultCode));
model.FormatHourlyAPIUsageCount = CommonMethod.FormatNumber(model.HourlyAPIUsageCount);
#region Cosmos DB Code commented as it is not in use
//model.AllAPIUsageCount = Convert.ToString(await GetAllLogsCount(SubDomain, CallType, ResultCode));
//model.FormatAllAPIUsageCount = CommonMethod.FormatNumber(model.AllAPIUsageCount);
//model.MonthCount = Convert.ToString(await GetMonthLogsCount(SubDomain, CallType, ResultCode));
//model.FormatMonthCount = CommonMethod.FormatNumber(model.MonthCount);
//model.YTDCount = Convert.ToString(await GetYearLogsCount(SubDomain, CallType, ResultCode));
//model.FormatYTDCount = CommonMethod.FormatNumber(model.YTDCount);
#endregion
}
catch (Exception ex)
{
model.MonthCount = "0";
model.FormatMonthCount = "0";
}
Helper.CurrentProvider = ProviderType.OI.ToString();
return(View("~/Views/OI/OIHome/Index.cshtml", model));
}
public JsonResult OIActiveStatisticsFilter()
{
OIDashboard model = GetOIDashboard();
return(Json(model, JsonRequestBehavior.AllowGet));
}
