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