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));
}
