/// <summary> /// Get DashBoard Activity Count /// </summary> /// <returns></returns> public static DashBoardActivityCount GetDashBoardActivityCount() { StringBuilder traceLog = null; using (LinksMediaContext dataContext = new LinksMediaContext()) { traceLog = new StringBuilder(); DashBoardActivityCount objDashBoardActivity = new DashBoardActivityCount(); try { traceLog.AppendLine("Start: GetDashBoardActivityCount()"); List <int> ChallengeSubTypeList = ChallengesBL.GetFitnessTestORWorkoutSubTypeId(ConstantHelper.constFittnessCommonSubTypeId); objDashBoardActivity.FitnessTestCount = dataContext.Challenge.Count(ch => !ch.IsDraft && ChallengeSubTypeList.Contains(ch.ChallengeSubTypeId)); objDashBoardActivity.ActiveFitnessTestCount = dataContext.Challenge.Count(ch => !ch.IsDraft && ch.IsActive && ChallengeSubTypeList.Contains(ch.ChallengeSubTypeId)); objDashBoardActivity.UserCount = dataContext.User.Count(); //objDashBoardActivity.PremiumUserCount = (from crd in dataContext.Credentials // where crd.UserType != Message.UserTypeTeam // && (crd.IOSSubscriptionStatus || crd.AndriodSubscriptionStatus) // select crd.Id // ).Distinct().Count(); objDashBoardActivity.PremiumUserCount = (from usr in dataContext.User join crd in dataContext.Credentials on usr.UserId equals crd.UserId where crd.UserType == Message.UserTypeUser && (crd.IOSSubscriptionStatus || crd.AndriodSubscriptionStatus) select crd.Id ).Distinct().Count(); objDashBoardActivity.TrainerCount = dataContext.Trainer.Count(); objDashBoardActivity.TeamCount = dataContext.Teams.Count(); objDashBoardActivity.WorkoutCount = dataContext.Challenge.Count(workt => !workt.IsDraft && workt.ChallengeSubTypeId == ConstantHelper.constWorkoutChallengeSubType); objDashBoardActivity.ActiveWorkoutCount = dataContext.Challenge.Count(workt => !workt.IsDraft && workt.IsActive && workt.ChallengeSubTypeId == ConstantHelper.constWorkoutChallengeSubType); objDashBoardActivity.ProgramCount = dataContext.Challenge.Count(y => !y.IsDraft && y.ChallengeSubTypeId == ConstantHelper.constProgramChallengeSubType); objDashBoardActivity.ActiveProgramCount = dataContext.Challenge.Count(y => !y.IsDraft && y.IsActive && y.ChallengeSubTypeId == ConstantHelper.constProgramChallengeSubType); objDashBoardActivity.ActivityCount = dataContext.Activity.Count(); return(objDashBoardActivity); } catch { throw; } finally { traceLog.AppendLine("GetDashBoardActivityCount end() : --- " + DateTime.Now.ToLongDateString()); LogManager.LogManagerInstance.WriteTraceLog(traceLog); } } }
/// <summary> /// Action to Get DashBorad data /// </summary> /// <returns>ActionResult</returns> /// <devdoc> /// Developer Name - Raghuraj Singh /// Date - 03/27/2015 /// </devdoc> public ActionResult DashBoard() { StringBuilder traceLog = null; DashBoard model = null; if (Login.IsSessionExpire(Convert.ToString(HttpContext.Session[Message.LoginUserName])) || Convert.ToString(HttpContext.Session["UserType"]) != Message.UserTypeAdmin) { return(this.RedirectToAction("Login", "Login")); } try { traceLog = new StringBuilder(); traceLog.AppendLine("Start: DashBoard controller"); HttpContext.Session["SelectedTrainerId"] = 0; #region Second MiledStone /*Get Challenge count from the database*/ //ViewBag.ChallengeCount = ChallengesCommonBL.GetChallengeCount(); ///*Get Program count from the database*/ //ViewBag.ProgramCount = UseresBL.GetProgramCount(); ///*Get Challenge count from the database*/ //ViewBag.ActiveChallengeCount = ChallengesCommonBL.GetActiveChallengeCount(); ///*Get Trainer count from the database*/ //ViewBag.TrainerCount = TrainersBL.GetTrainerCount(); ///*Get User count from the database*/ //ViewBag.UserCount = UseresBL.GetUserCount(); ///*Get Team count from the database*/ //ViewBag.TeamCount = TeamBL.GetTeamCount(); /*Get Activitie count from the database*/ // ViewBag.ActivityCount = ActivityBL.GetActivityCount(); DashBoardActivityCount objactivitycount = ActivityBL.GetDashBoardActivityCount(); /*Get featured activity queue list from the database*/ IEnumerable <FeaturedActivityQueue> objListFauturedActivity = ActivityBL.GetFeaturedActivity(); /*Get COD queue list from the database*/ IEnumerable <CODQueue> objListCOD = ChallengeOfTheDayBL.GetAllCOD(); /*Get Sponser challenge queue list from the database*/ IEnumerable <SponsorChallengeQueue> objListSponsorChallenge = SponsorChallengeBL.GetAllSponsorChallenge(); /*Bind view model*/ model = new DashBoard(); model.FauturedActivityQueue = objListFauturedActivity; model.ChallengeOfTheDayQueue = objListCOD; model.SponsorChallengeQueue = objListSponsorChallenge; model.DashBoardActivity = objactivitycount; return(this.View(model)); #endregion } catch (Exception ex) { LogManager.LogManagerInstance.WriteErrorLog(ex); /*transfer to error page*/ return(this.RedirectToAction("Error")); } finally { traceLog.AppendLine("DashBoard end() : --- " + DateTime.Now.ToLongDateString()); LogManager.LogManagerInstance.WriteTraceLog(traceLog); } }