public void RecommendClass()
{
var users = db.U_User.Select(L => L.UserID).ToList();
foreach (var item in users)
{
U_SmallBell sb = new U_SmallBell();
var myLearnedClass = db.B_OrderDetail.Where(L => L.B_Order.UserID == item).GroupBy(L => L.C_Class.ClassTypeID).OrderByDescending(L => L.Count()).FirstOrDefault();
myLearnedClass = myLearnedClass == null?db.B_OrderDetail.Where(L => L.C_Class.ClassTypeID == 1).GroupBy(L => L.C_Class.ClassTypeID).FirstOrDefault() : myLearnedClass;
int classID = myLearnedClass.Key;
List <C_Class> classlist = myLearnedClass.Select(L => L.C_Class).ToList();
List <C_Class> allClass = db.C_Class.Where(L => L.ClassTypeID == classID).ToList();
foreach (var x in classlist)
{
allClass.Remove(x);
}
int y = allClass.OrderBy(L => Guid.NewGuid()).FirstOrDefault().ClassID;
sb.ClassID = y;
sb.NoticeContent = "趕快來看看推薦課程吧!";
sb.CreatedDate = DateTime.Now;
sb.StatusTypeID = 1;
sb.UserID = item;
db.U_SmallBell.Add(sb);
}
db.SaveChanges();
}
public void AddMessageNotice(int classid, string content)
{
U_SmallBell sb = new U_SmallBell();
sb.ClassID = classid;
sb.UserID = db.C_Class.Where(c => c.ClassID == classid).Select(u => u.U_User.UserID).FirstOrDefault();
sb.NoticeContent = content;
sb.CreatedDate = DateTime.Now;
sb.StatusTypeID = 4;
db.U_SmallBell.Add(sb);
db.SaveChanges();
}
public void AddSmallBell(int id, string content)
{
var users = db.U_User.Select(x => x.UserID).ToList();
foreach (var item in users)
{
U_SmallBell sb = new U_SmallBell();
sb.ClassID = id;
sb.NoticeContent = content;
sb.CreatedDate = DateTime.Now;
sb.StatusTypeID = 1;
sb.UserID = item;
db.U_SmallBell.Add(sb);
}
db.SaveChanges();
}