/// <summary> /// Action to display dashboard page. /// </summary> /// <returns></returns> public ActionResult Index() { try { objDashboard = objCommonRepository.GetCount(); return View(objDashboard); } catch (Exception ex) { CommonRepository.LogError("DashboardController", "Index", ex.ToString()); Session[Helpers.CommonConstants.Message] = Messages.GetMessage("[Error]"); Session[Helpers.CommonConstants.MessageType] = "2"; return View(); } }
/// <summary> /// Function to Get Count of Entities /// </summary> /// <returns></returns> public Dashboard.Dashboard GetCount() { try { string sQuery = "select count(*) as TotalAdmin from GHC_AdminUsers"; sQuery += " Select count(*) as TotalUser from GHC_Users"; DataSet ds = DBMethods.GetInfoSet(sQuery); if (ds != null && ds.Tables.Count > 0) { //Count of Admin Users objDashboard.nTCAdminUser = Methods.doInt(ds.Tables[0].Rows[0]["TotalAdmin"]); //Count of Users objDashboard.nTCUsers = Methods.doInt(ds.Tables[1].Rows[0]["TotalUser"]); } //Count of Reports objDashboard.nTCReports = Methods.doInt(0); //Count of Forms objDashboard.nTCForms = Methods.doInt(0); } catch (Exception ex) { objDashboard = null; CommonRepository.LogError(RepositoryName, "GetCount", ex.ToString()); } return objDashboard; }