public int DeleteCommentByCommID(int CommId) { int count = 0; commentsDataContext db = new commentsDataContext(); var comment = from c in db.comments where c.commID == CommId select c; if (comment.Count() > 0) { db.comments.DeleteAllOnSubmit(comment); count = db.comments.Where(c => c.commID == CommId).Count(); } return(count); }
public comments GetComment(int commID) { commentsDataContext db = new commentsDataContext(); if (db.comments.Count() > 0) { var comm = db.comments.Single(c => c.commID == commID); return(comm); } else { return(null); } }
public IList <comments> GetComment() { commentsDataContext db = new commentsDataContext(); IEnumerable <comments> comm = from c in db.comments select c; if (comm != null) { return(comm.ToList <comments>()); } else { return(new List <comments>()); } }
public int InsertComments(comments comm) { commentsDataContext db = new commentsDataContext(); try { db.comments.InsertOnSubmit(comm); db.SubmitChanges(); return(comm.commID); } catch { return(0); } }