public void DeleteCategory(int CategoryID)
{
Category categoryToDelete = db.Categories.Where(u => u.CategoryID == CategoryID).FirstOrDefault();
if (categoryToDelete != null)
{
db.Categories.Remove(categoryToDelete);
db.SaveChanges();
}
}
public void DeleteUser(int UserID)
{
User userToDelete = db.Users.Where(u => u.UserID == UserID).FirstOrDefault();
if (userToDelete != null)
{
db.Users.Remove(userToDelete);
db.SaveChanges();
}
}
public void DeleteAnswer(int AnswerID)
{
Answer answerToDelete = db.Answers.Where(a => a.AnswerID == AnswerID).FirstOrDefault();
if (answerToDelete != null)
{
db.Answers.Remove(answerToDelete);
db.SaveChanges();
qr.UpdateQuestionAnswersCount(answerToDelete.QuestionID, -1);
}
}
public void UpdateVote(int aid, int uid, int value)
{
int updateValue;
if (value > 0)
{
updateValue = 1;
}
else if (value < 0)
{
updateValue = -1;
}
else
{
updateValue = 0;
}
Vote vote = db.Votes.Where(temp => temp.AnswerID == aid && temp.UserID == uid).FirstOrDefault();
if (vote != null)
{
vote.VoteValue = updateValue;
}
else
{
Vote newVote = new Vote()
{
AnswerID = aid, UserID = uid, VoteValue = updateValue
};
db.Votes.Add(newVote);
}
db.SaveChanges();
}
public void DeleteQuestion(int QuestionID)
{
Question questionToDelete = db.Questions.Where(q => q.QuestionID == QuestionID).FirstOrDefault();
if (questionToDelete != null)
{
db.Questions.Remove(questionToDelete);
db.SaveChanges();
}
}
