public List <Dictionary <String, Object> > GetReplyListById(int id) { List <Dictionary <String, Object> > list = new List <Dictionary <string, object> >(); var context = new LOJEntities3(); var discuss = from e in context.DiscussComments 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.time); hash.Add("commentid", t.commentid); hash.Add("commentNum", getReplyListNum((int)t.discussid)); list.Add(hash); } return(list); }
public Dictionary <String, Object> GetProblemById(int id) { var context = new LOJEntities3(); var problem = from e in context.QuestionSets where e.id == id 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); return(hash); } return(null); }
public List <Dictionary <String, Object> > GetFriendList(int uid) { List <Dictionary <String, Object> > list = new List <Dictionary <string, object> >(); var context = new LOJEntities3(); var user = from e in context.Friends where e.id1 == uid || e.id2 == uid select e; foreach (var u in user) { int id = (int)u.id1; if (id == uid) { id = (int)u.id2; } User user2 = getUser(id); Dictionary <String, Object> hash = new Dictionary <string, object>(); hash.Add("userid", user2.id); hash.Add("username", user2.name); hash.Add("phone", user2.phone); hash.Add("time", user2.time); hash.Add("avator", user2.avator); list.Add(hash); } return(list); }
public Dictionary <String, Object> GetUserInfo(int uid) { var context = new LOJEntities3(); var user = from e in context.Users where e.id == uid select e; if (user == null) { return(null); } else { foreach (var u in user) { Dictionary <String, Object> hash = new Dictionary <string, object>(); hash.Add("userid", u.id); hash.Add("username", u.name); hash.Add("phone", u.phone); hash.Add("time", u.time); hash.Add("avator", u.avator); return(hash); } } return(null); }
public Dictionary <String, Object> GetUserLogin(String email, String password) { var context = new LOJEntities3(); var useridentified = from e in context.User_Identified where e.email == email select e; if (useridentified == null) { return(null); } else { foreach (var u in useridentified) { Console.WriteLine("666"); String pwd = Encrypt(password); if (pwd != u.password) { return(null); } else { var context2 = new LOJEntities3(); User user = context2.Users.Find(u.userid); Dictionary <String, Object> hash = new Dictionary <string, object>(); hash.Add("userid", user.id); hash.Add("username", user.name); hash.Add("phone", user.phone); hash.Add("email", u.email); hash.Add("time", user.time); hash.Add("avator", user.avator); return(hash); } } } return(null); }
public List <Dictionary <String, Object> > GetDiscussList(int id) { List <Dictionary <String, Object> > list = new List <Dictionary <string, object> >(); var context = new LOJEntities3(); var solution = from e in context.Solutions where e.questionid == id select e; foreach (var t in solution) { 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("solution", t.comment); hash.Add("msg", t.comment); hash.Add("time", t.answerTime); hash.Add("questionid", t.questionid); hash.Add("solutionid", t.solutionid); hash.Add("comments", GetDiscussReplyList(t.solutionid)); list.Add(hash); } return(list); }