public static List <Question> GetAllQuestions() { List <Question> qList = new List <Question>(); using (CI = new Models.CombinedIntelligenceEntities()) { var result = CI.getAllQuestions().ToList(); foreach (var question in result) { Question cur = new Question() { Id = question.QuestionID, UserId = question.UserID, BodyText = question.Body, DatePosted = question.DatePosted, HeaderText = question.Header }; var votes = CI.getQVotes(question.QuestionID).ToList(); foreach (var vote in votes) { cur.Votes.Add(new Vote(vote.UserId, (VoteTypes)vote.Value)); } qList.Add(cur); var tags = CI.getQTags(question.QuestionID).ToList(); foreach (var tag in tags) { cur.AddTag(new Tag(tag.Name)); } } } return(qList); }
public static List <Answer> GetAnswers(int UID) { List <Answer> ansList = new List <Answer>(); using (CI = new Models.CombinedIntelligenceEntities()) { var result = CI.getUserAnswers(UID).ToList(); foreach (var answer in result) { Answer cur = new Answer() { Id = answer.AnswerId, UserId = answer.UserId, BodyText = answer.Body, DatePosted = answer.DatePosted, Accepted = answer.Accepted == 1, QuestionId = answer.QuestionId }; var votes = CI.getAVotes(answer.AnswerId).ToList(); foreach (var vote in votes) { cur.Votes.Add(new Vote(vote.UserId, (VoteTypes)vote.Value)); } ansList.Add(cur); } } return(ansList); }
public static void updateScore(int uID, int value) { using (CI = new Models.CombinedIntelligenceEntities()) { CI.updateScore(uID, value); } }
public static User registerUser(string password, string email, int teamId, string name, string surname, string image) { using (CI = new Models.CombinedIntelligenceEntities()) { var res = CI.RegisterUser(password, email, teamId, name, surname, image).ToList().First(); if (res == -1) { return new User() { Id = -1 } } ; User user = new User() { Id = (int)res, Email = email, Image = image, Name = name, Score = 0, Team = getTeamName(teamId) }; return(user); } }
public static string getTeamName(int TID) { using (CI = new Models.CombinedIntelligenceEntities()) { return(CI.getTeamName(TID).ToList().First()); } }
public static void userPreference(int UID, int TID) { using (CI = new Models.CombinedIntelligenceEntities()) { CI.AddUserPreference(TID, UID); } }
public static User getUserLogin(string email, string password) { using (CI = new Models.CombinedIntelligenceEntities()) { var result = CI.GetUserLogin(email, password).ToList(); if (result.Count == 0) { return(null); } var res = result.First(); User user = new User() { Id = res.UserID, Email = email, Image = res.Image, Name = res.Name, Score = res.Score, Team = getTeamName(res.TeamId) }; var tags = getUserTags(res.UserID); foreach (var tag in tags) { user.AddTag(new Tag(tag)); } return(user); } }
public static void addQTag(int QID, int TID) { using (CI = new Models.CombinedIntelligenceEntities()) { CI.AddQTag(TID, QID); } }
public static void acceptAnswer(int AnsId) { using (CI = new Models.CombinedIntelligenceEntities()) { var result = CI.AcceptAns(AnsId); } }
public static List <string> getUserTags(int uID) { using (CI = new Models.CombinedIntelligenceEntities()) { var tags = CI.getUserTags(uID).ToList(); return(tags); } }
public static Question addQuestion(Question newQuestion) { using (CI = new Models.CombinedIntelligenceEntities()) { var result = CI.AddQuestion(newQuestion.UserId, newQuestion.HeaderText, newQuestion.BodyText).ToList().First(); newQuestion.DatePosted = result.DatePosted; newQuestion.Id = result.QuestionId; return(newQuestion); } }
public static Answer addAnswer(Answer newAnswer) { using (CI = new Models.CombinedIntelligenceEntities()) { var result = CI.AddAnswer(newAnswer.QuestionId, newAnswer.UserId, newAnswer.BodyText).ToList().First(); newAnswer.DatePosted = result.DatePosted; newAnswer.Id = result.AnswerId; newAnswer.Accepted = false; return(newAnswer); } }
public static Tag addTag(Tag newTag) { using (CI = new Models.CombinedIntelligenceEntities()) { var result = CI.AddTag(newTag.Name).ToList().First();; if (result.HasValue) { newTag.id = result.Value; } return(newTag); } }
public static User getUser(int ID) { using (CI = new Models.CombinedIntelligenceEntities()) { var result = CI.GetUser(ID).ToList().First(); var user = new User() { Id = result.UserID, Email = result.Email, Team = result.Name, Score = result.Score, Name = result.FirstNames, //Surname = result.Surname, Image = result.Image }; var tagList = CI.getUserTags(ID).ToList(); foreach (var tag in tagList) { user.AddTag(new Tag(tag)); } return(user); } }