public List <Dictionary <String, Object> > GetDiscussList()
{
List <Dictionary <String, Object> > list = new List <Dictionary <string, object> >();
var context = new LOJEntities3();
var discuss = from e in context.Discusses select e;
foreach (var t in discuss)
{
Dictionary <String, Object> hash = new Dictionary <string, object>();
User user = UserInfoController.getUser((int)t.userid);
hash.Add("uid", user.id);
hash.Add("name", user.name);
hash.Add("phone", user.phone);
hash.Add("avator", user.avator);
hash.Add("commentNum", getReplyListNum((int)t.discussid));
hash.Add("tid", t.discussid);
hash.Add("msg", t.comment);
hash.Add("time", t.discuestime);
hash.Add("title", t.title);
hash.Add("type", t.type);
// hash.Add("commentNum", getReplyListNum((int)t.discussid));
list.Add(hash);
}
return(list);
}
public List <Dictionary <String, Object> > GetProblemList()
{
List <Dictionary <String, Object> > list = new List <Dictionary <string, object> >();
var context = new LOJEntities3();
var problem = from e in context.QuestionSets select e;
foreach (var t in problem)
{
Dictionary <String, Object> hash = new Dictionary <string, object>();
User user = UserInfoController.getUser((int)t.userid);
hash.Add("uid", user.id);
hash.Add("name", user.name);
hash.Add("phone", user.phone);
hash.Add("avator", user.avator);
hash.Add("category", t.category);
hash.Add("difficulty", t.difficulty);
hash.Add("problemID", t.id);
hash.Add("problemInfo", t.queInfo);
hash.Add("source", t.source);
hash.Add("time", t.time);
hash.Add("title", t.title);
list.Add(hash);
}
return(list);
}
public List <Dictionary <String, Object> > getMyTwitter(int uid)
{
List <Dictionary <String, Object> > list = new List <Dictionary <string, object> >();
var context = new LOJEntities3();
var marks = from e in context.MarkProblems where e.uid == uid select e;
foreach (var t in marks)
{
Dictionary <String, Object> hash = new Dictionary <string, object>();
User user = UserInfoController.getUser((int)t.uid);
QuestionSet question = ProblemController.GetProblemByQueId((int)t.queid);
hash.Add("uid", user.id);
hash.Add("name", user.name);
hash.Add("markid", t.markid);
hash.Add("phone", user.phone);
hash.Add("queid", question.id);
hash.Add("avator", user.avator);
hash.Add("queTitle", question.title);
hash.Add("queSource", question.source);
hash.Add("queCategory", question.category);
hash.Add("queDifficulty", question.difficulty);
list.Add(hash);
}
return(list);
}
public List <Dictionary <String, Object> > getFriendTwitter(int uid)
{
List <Dictionary <String, Object> > list = new List <Dictionary <string, object> >();
var context = new LOJEntities3();
List <User> friends = UserInfoController.getFriends(uid);
for (int i = 0; i < friends.Count; i++)
{
int id = friends[i].id;
var twitter = from e in context.Twitters where e.uid == id select e;
foreach (var t in twitter)
{
Dictionary <String, Object> hash = new Dictionary <string, object>();
User user = UserInfoController.getUser(id);
hash.Add("name", user.name);
hash.Add("phone", user.phone);
hash.Add("avator", user.avator);
hash.Add("uid", id);
hash.Add("tid", t.tid);
hash.Add("msg", t.msg);
hash.Add("time", t.date);
list.Add(hash);
}
}
return(list);
}
public Dictionary <string, object> GetUpdateSendList(int ChatSessionId, String msg, int uid)
{
using (var dbContext = new LOJEntities3())
{
ChatSession chat = new ChatSession();
var session = from e in dbContext.ChatSessions where e.sessionid == ChatSessionId select e;
foreach (var u in session)
{
chat = u;
break;
}
//List<Dictionary<String, Object>> list = new List<Dictionary<string, object>>();
JArray array = new JArray();
if (chat.content != "[]")
{
array = JArray.Parse(chat.content);
// list = JsonConvert.DeserializeObject<List<Dictionary<String, Object>>>(chat.content);
}
Dictionary <string, object> dict = new Dictionary <string, object>();
dict.Add("message", msg);
dict.Add("uid", uid);
dict.Add("name", UserInfoController.getUser(uid).name);
dict.Add("avator", UserInfoController.getUser(uid).avator);
dict.Add("date", DateTime.Now.ToString());
String jsonStr = JsonConvert.SerializeObject(dict);
array.Add((JObject)JsonConvert.DeserializeObject(jsonStr));
chat.content = array.ToString();
dbContext.Entry(chat).State = System.Data.Entity.EntityState.Modified;
try
{
if (dbContext.SaveChanges() > 0)
{
return(dict);
}
else
{
return(null);
}
}
catch (Exception e)
{
return(null);
}
}
}
public List <Dictionary <String, Object> > GetChatSessionList(int uid)
{
List <Dictionary <String, Object> > list = new List <Dictionary <string, object> >();
var context = new LOJEntities3();
User u = UserInfoController.getUser(uid);
String name = u.name;
var session = from e in context.ChatSessions where e.username1 == name || e.username2 == name select e;
foreach (var s in session)
{
Dictionary <String, Object> hash = new Dictionary <string, object>();
hash.Add("sessionID", s.sessionid);
hash.Add("username1", s.username1);
hash.Add("username2", s.username2);
hash.Add("content", s.content);
list.Add(hash);
}
return(list);
}
/// <summary>
/// 返回相关解答的评论
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static List <Dictionary <String, Object> > GetDiscussReplyList(int id)
{
List <Dictionary <String, Object> > list = new List <Dictionary <string, object> >();
var context = new LOJEntities3();
var solutionComments = from e in context.SolutionComments where e.solutionid == id select e;
foreach (var t in solutionComments)
{
Dictionary <String, Object> hash = new Dictionary <string, object>();
User user = UserInfoController.getUser((int)t.userid);
hash.Add("uid", user.id);
hash.Add("name", user.name);
hash.Add("phone", user.phone);
hash.Add("avator", user.avator);
hash.Add("commenttime", t.date);
hash.Add("commentid", t.commentid);
hash.Add("solutionid", t.solutionid);
hash.Add("comment", t.comment);
list.Add(hash);
}
return(list);
}
public List <Dictionary <String, Object> > GetRecordListByQid(int qid)
{
List <Dictionary <String, Object> > list = new List <Dictionary <string, object> >();
var context = new LOJEntities3();
var records = from e in context.Records where e.questionid == qid select e;
foreach (var t in records)
{
Dictionary <String, Object> hash = new Dictionary <string, object>();
User user = UserInfoController.getUser((int)t.userid);
hash.Add("uid", user.id);
hash.Add("name", user.name);
hash.Add("phone", user.phone);
hash.Add("avator", user.avator);
hash.Add("time", t.submittime);
hash.Add("qid", t.questionid);
hash.Add("recordid", t.recordid);
hash.Add("qname", ProblemController.GetProblemByQueId((int)t.questionid).title);
hash.Add("status", t.status);
// hash.Add("commentNum", getReplyListNum((int)t.discussid));
list.Add(hash);
}
return(list);
}
public Dictionary <String, Object> GetDiscuss(int id)
{
var context = new LOJEntities3();
var discuss = from e in context.Discusses where e.discussid == id select e;
foreach (var t in discuss)
{
Dictionary <String, Object> hash = new Dictionary <string, object>();
User user = UserInfoController.getUser((int)t.userid);
hash.Add("uid", user.id);
hash.Add("name", user.name);
hash.Add("phone", user.phone);
hash.Add("avator", user.avator);
// hash.Add("replynum", t.DiscussComments.Count());
hash.Add("tid", t.discussid);
hash.Add("msg", t.comment);
hash.Add("time", t.discuestime);
hash.Add("title", t.title);
hash.Add("type", t.type);
hash.Add("commentNum", getReplyListNum((int)t.discussid));
return(hash);
}
return(null);
}