public void DeleteCategory(int CategoryID)
{
Category ct = db.Categories.Where(temp => temp.CategoryID == CategoryID).FirstOrDefault();
if (ct != null)
{
db.Categories.Remove(ct);
db.SaveChanges();
}
}
public void DeleteUser(int uid)
{
User us = db.Users.Where(temp => temp.UserID == uid).FirstOrDefault();
if (us != null)
{
db.Users.Remove(us);
db.SaveChanges();
}
}
public void DeleteAnswer(int aid)
{
Answer ans = db.Answers.Where(temp => temp.AnswerID == aid).FirstOrDefault();
if (ans != null)
{
db.Answers.Remove(ans);
db.SaveChanges();
qr.UpdateQuestionAnswersCount(ans.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 v = db.Votes.Where(temp => temp.AnswerID == aid && temp.UserID == uid).FirstOrDefault();
if (v != null)
{
v.VoteValue = UpdateValue;
}
else
{
Vote newVote = new Vote()
{
AnswerID = aid, UserID = uid, VoteValue = UpdateValue
};
db.Votes.Add(newVote);
}
db.SaveChanges();
}
public void UpdateVote(int AnswerID, int UserID, int Value)
{
int updateValue = 0;
if (Value > 0)
{
updateValue = 1;
}
else if (Value < 0)
{
updateValue = -1;
}
else
{
updateValue = 0;
}
Vote vote = db.Votes.Where(temp => temp.AnswerID == AnswerID && temp.UserID == UserID).FirstOrDefault();
if (vote != null)
{
vote.VoteValue = updateValue;
}
else
{
Vote newVote = new Vote()
{
AnswerID = AnswerID, UserID = UserID, VoteValue = updateValue
};
db.Votes.Add(newVote);
}
db.SaveChanges();
}
public void DeleteQuestion(int qid)
{
Question qt = db.Questions.Where(temp => temp.QuestionID == qid).FirstOrDefault();
if (qt != null)
{
db.Questions.Remove(qt);
db.SaveChanges();
}
}
public void DeleteQuestion(int QuestionID)
{
Question ques = db.Questions.Where(temp => temp.QuestionID == QuestionID).FirstOrDefault();
if (ques != null)
{
db.Questions.Remove(ques);
db.SaveChanges();
}
}
public void InsertAnswer(Answer a)
{
db.Answers.Add(a);
db.SaveChanges();
qr.UpdateQuestionAnswersCount(a.QuestionID, 1);
}
public void InsertCategory(Category c)
{
db.Categories.Add(c);
db.SaveChanges();
}
public void InsertUser(User u)
{
db.Users.Add(u);
db.SaveChanges();
}
public void InsertQuestion(Question q)
{
db.Questions.Add(q);
db.SaveChanges();
}
