public static bool Annotate(MyLibraryModel Model, int pmid, int UserId)
{
using (EditorsEntities entity = new EditorsEntities())
{
UserComment UpdateComment = (from u in entity.UserComments where u.userid == UserId && u.pmid == pmid select u).FirstOrDefault();
if (UpdateComment == null)
{
UserComment NewUserComment = new UserComment();
NewUserComment.pmid = pmid;
NewUserComment.userid = UserId;
NewUserComment.nickname = Model.UserComment.nickname;
NewUserComment.comment = Model.UserComment.comment;
NewUserComment.updatedate = DateTime.Now;
NewUserComment.createdate = DateTime.Now;
entity.UserComments.Add(NewUserComment);
}
else
{
UpdateComment.userid = UserId;
UpdateComment.nickname = Model.UserComment.nickname;
UpdateComment.comment = Model.UserComment.comment;
UpdateComment.updatedate = DateTime.Now;
entity.Entry(UpdateComment).State = EntityState.Modified;
}
entity.SaveChanges();
return(true);
}
}
// To Delete UserCitation
public static bool DeleteCitation(int fid, int mid, int userid)
{
using (EditorsEntities entity = new EditorsEntities())
{
UserCitation UC = entity.UserCitations.Where(c => c.UserID == userid && c.PMID == mid && c.SubTopicID == fid).FirstOrDefault();
if (UC != null)
{
UC.Deleted = true;
entity.Entry(UC).State = EntityState.Modified;
entity.SaveChanges();
}
return(true);
}
}
public static bool UpdateACRDocClickCount(int Id)
{
using (EditorsEntities entity = new EditorsEntities())
{
doc Result = (from ad in entity.docs
where
ad.id == Id
select ad).FirstOrDefault();
if (Result != null)
{
Result.clicks_count++;
entity.Entry(Result).State = EntityState.Modified;
entity.SaveChanges();
}
return(true);
}
}
// for update ACR Document
public static bool EditDocument(ACRDocumentsModel EditDocumentModel)
{
using (EditorsEntities entity = new EditorsEntities())
{
doc editDoc = entity.docs.Find(EditDocumentModel.Id);
if (editDoc != null)
{
editDoc.source = EditDocumentModel.Source;
editDoc.nm = EditDocumentModel.Name;
editDoc.last_updated_dt = EditDocumentModel.LastUpdatedDate;
editDoc.clicks_count = EditDocumentModel.ClicksCount;
editDoc.auto_upd = EditDocumentModel.IsAutoUpdate;
entity.Entry(editDoc).State = EntityState.Modified;
entity.SaveChanges();
}
return(true);
}
}
