//Delete the ManagerComment on the basis of the projectID public static List<ManagerComment> DeleteManagerComment(ManagerComment mc) { var mComment = (from managerComment in dataContext.ManagerComments where managerComment.ManagerCommentID == mc.ManagerCommentID select managerComment).SingleOrDefault(); dataContext.ManagerComments.Remove(mComment); dataContext.SaveChanges(); return GetAllManagerComments(); }
//Update the ManagerComment on the basis of the projectID public static List<ManagerComment> UpdateManagerComment(ManagerComment mc) { //get the details of the managerComment var mComment = (from managerComment in dataContext.ManagerComments where managerComment.ManagerCommentID == mc.ManagerCommentID select managerComment).SingleOrDefault(); mComment.Comments = mc.Comments; mComment.ProjectTaskID = mc.ProjectTaskID; dataContext.SaveChanges(); return GetAllManagerComments(); }
//Insert ManagerComment public static List<ManagerComment> InsertManagerComment(ManagerComment mc) { dataContext.ManagerComments.Add(mc); dataContext.SaveChanges(); return GetAllManagerComments(); }