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