public ActionResult vocabularyManagement() { var model = new AdminHomePageController(); model.vocab = db.Vocabularies.ToList(); return(View(model)); }
public ActionResult userManagement() { var model = new AdminHomePageController(); model.user = db.UserInfoes.ToList(); return(View(model)); }
public ActionResult feedbackManagement() { var model = new AdminHomePageController(); model.topic = db.CommentTopics.ToList(); model.cmt = db.UserComments.ToList(); return(View(model)); }
// GET: Admin_HomePage public ActionResult adminIndex() { var model = new AdminHomePageController(); model.topic = db.CommentTopics.ToList(); model.cmt = db.UserComments.ToList(); model.user = db.UserInfoes.ToList(); model.vocab = db.Vocabularies.ToList(); //lọc danh sách user mới vào 1 tuần này List <UserInfo> newUser = new List <UserInfo>(); foreach (var item in db.UserInfoes.ToList()) { try { TimeSpan time = DateTime.Now - (DateTime)item.dateRegister; int TongSoNgay = time.Days; if (TongSoNgay <= 7) { newUser.Add(item); } } catch {} } model.userNewInSevenDays = newUser; //thống kê level user List <StatisticsClass.LevelStudyStatistics> levelStatistics = new List <StatisticsClass.LevelStudyStatistics>(); List <string> userLevel = new List <string>(); List <int> sumUserLevel = new List <int>(); string[] userLevel1 = new string[20]; int[] sumUserLevel1 = new int[20]; foreach (var item in db.UserInfoes.ToList()) { bool isAlive = false; foreach (var itemUser in levelStatistics) { if (item.levelStudy == itemUser.level) { itemUser.sum++; isAlive = true; } } if (!isAlive) { StatisticsClass.LevelStudyStatistics temp = new StatisticsClass.LevelStudyStatistics(); temp.level = item.levelStudy; temp.sum = 1; levelStatistics.Add(temp); userLevel.Add(item.levelStudy); } } userLevel1 = userLevel.ToArray(); //truyền color và percent vào cho mỗi item thống kê for (int i = 0; i < levelStatistics.Count(); i++) { levelStatistics[i].color = Colors.listColors.ElementAt(i); levelStatistics[i].percent = levelStatistics[i].sum * 100 / db.UserInfoes.Count(); sumUserLevel.Add(levelStatistics[i].sum); } sumUserLevel1 = sumUserLevel.ToArray(); model._levelStudyStatistics = levelStatistics; model.UserLevel = userLevel1; model.sumOfUserAtALevel = sumUserLevel1; //thống kê vocab level List <StatisticsClass.VocabularyLevelStatistics> vocabLevelStatistics = new List <StatisticsClass.VocabularyLevelStatistics>(); foreach (var item in db.Vocabularies.ToList()) { bool isAlive = false; foreach (var item1 in vocabLevelStatistics) { if (item1.level == item.levelStudy) { item1.sum++; isAlive = true; } } if (!isAlive) { StatisticsClass.VocabularyLevelStatistics temp = new StatisticsClass.VocabularyLevelStatistics(); temp.level = item.levelStudy; temp.sum = 1; vocabLevelStatistics.Add(temp); } } foreach (var item in vocabLevelStatistics) { item.percent = item.sum * 100 / db.Vocabularies.Count(); } model._vocabLevelStatistics = vocabLevelStatistics; //thống kê feedback List <StatisticsClass.FeedbackStatistics> feedbackSta = new List <StatisticsClass.FeedbackStatistics>(); List <string> feedbackTopic = new List <string>(); List <int> sumFeedbackTopic = new List <int>(); foreach (var item in db.UserComments) { bool isAlive = false; foreach (var item1 in feedbackSta) { if (item1.feedbackName == item.topic) { item1.sum++; isAlive = true; } } if (!isAlive) { StatisticsClass.FeedbackStatistics temp = new StatisticsClass.FeedbackStatistics(); temp.feedbackName = item.topic; temp.sum = 1; feedbackSta.Add(temp); } } foreach (var item in feedbackSta) { feedbackTopic.Add(item.feedbackName); sumFeedbackTopic.Add(item.sum); } model._feedbackStatistics = feedbackSta; model.FeedbackName = feedbackTopic; model.sumFeedbackTopic = sumFeedbackTopic; return(View(model)); }