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