// For Deleting Specialty public static bool DeleteSpecialty(int specid, int UserId) { using (EditorsEntities entity = new EditorsEntities()) { var Topics = (from s in entity.Topics where s.UserID == UserId && s.Type == 2 && s.SpecialtyID == specid select s.TopicID).ToList(); foreach (var TopicId in Topics) { DeleteUserTopic(entity, TopicId, UserId); } //Nuke all auto-queries associated with this specialty entity.lib_DeleteUserAutoQueries(specid, UserId); // Executing lib_DeleteUserAutoQueries stored procedure // Finally, delete the enclosing specialty itself var UserSpecialtyToBeDelete = entity.UserSpecialties.Where(s => s.SpecialtyID == specid && s.UserID == UserId).FirstOrDefault(); if (UserSpecialtyToBeDelete != null) { entity.UserSpecialties.Remove(UserSpecialtyToBeDelete); } entity.SaveChanges(); return(true); } }
// For Deleting User SubTopic Calling from above static void DeleteUserSubTopic(EditorsEntities entity, int SubTopicId, int UserId) { // First, delete UserCitations for this SubTopic var UserCitationsToBeDeleted = entity.UserCitations.Where(u => u.SubTopicID == SubTopicId && u.UserID == UserId).ToList(); foreach (UserCitation UC in UserCitationsToBeDeleted) { entity.UserCitations.Remove(UC); } // Deleted UserCitations by above statement // Second, delete searches for this SubTopic entity.lib_DeleteSearchesFromSubTopic(SubTopicId, UserId); // Executing lib_DeleteSearchesFromSubTopic Stored Procedure. // Delete searches for this SubTopic by above stored procedure // Third, delete this SubTopic from subtopics and userhas sponsersubtopic var UserSubTopicToBeDeleted = entity.SubTopics.Where(s => s.SubTopicID == SubTopicId && s.UserID == UserId && s.Type == 2).FirstOrDefault(); if (UserSubTopicToBeDeleted != null) { entity.SubTopics.Remove(UserSubTopicToBeDeleted); } var UserSponsorFolderToBeDeleted = entity.UserHasSponsorFolders.Where(s => s.UserFolderId == SubTopicId && s.UserId == UserId).FirstOrDefault(); if (UserSponsorFolderToBeDeleted != null) { entity.UserHasSponsorFolders.Remove(UserSponsorFolderToBeDeleted); } entity.SaveChanges(); }
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 Hide UserTopic public static bool HideTopics(List <int> TopicIds, int UserId) { using (EditorsEntities entity = new EditorsEntities()) { foreach (var TopicId in TopicIds) { HideTopic(entity, TopicId, UserId); } entity.SaveChanges(); return(true); } }
// To Add User Specialty public static bool AddUserSpecialty(GetUserSpecialtyModel Model, int UserId) { using (EditorsEntities entity = new EditorsEntities()) { UserSpecialty UsNew = new UserSpecialty(); UsNew.SpecialtyID = (Int32)Model.SelectedSpecialtyId; UsNew.UserID = UserId; UsNew.DateAdded = DateTime.Now; entity.UserSpecialties.Add(UsNew); entity.SaveChanges(); return(true); } }
// For Delete ACR Document Relation public static bool DeleteACRDocumentRelation(int RelId) { using (EditorsEntities entity = new EditorsEntities()) { doc_in_subtopic docRelation = entity.doc_in_subtopic.Find(RelId); if (docRelation != null) { entity.doc_in_subtopic.Remove(docRelation); entity.SaveChanges(); } return(true); } }
// For delete ACR Document public static bool DeleteACRDocument(int docId) { using (EditorsEntities entity = new EditorsEntities()) { doc DeleteDoc = entity.docs.Find(docId); if (DeleteDoc != null) { entity.docs.Remove(DeleteDoc); entity.SaveChanges(); } return(true); } }
static void DeleteUserSposorTopic(EditorsEntities entity, int TopicId, int UserId) { // First need to Get and delete SubTopics in the Topic which is going to Delete var Subtopics = (from s in entity.SubTopics where s.TopicID == TopicId && (((s.Type == 2) && s.UserID == UserId) || s.Type == 3) select s.SubTopicID).ToList(); foreach (var SubTopicId in Subtopics) { DeleteUserSubTopic(entity, SubTopicId, UserId); } entity.lib_RemoveSponsorTopic(UserId, TopicId); entity.SaveChanges(); }
// 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 AddDocument(ACRDocumentsModel ModelAddDocument) { using (EditorsEntities entity = new EditorsEntities()) { doc newDoc = new doc(); newDoc.source = ModelAddDocument.Source; newDoc.nm = ModelAddDocument.Name; newDoc.last_updated_dt = ModelAddDocument.LastUpdatedDate; newDoc.clicks_count = ModelAddDocument.ClicksCount; newDoc.auto_upd = ModelAddDocument.IsAutoUpdate; entity.docs.Add(newDoc); entity.SaveChanges(); } return(true); }
// To Add User Topic public static bool AddTopic(int SpecId, string TopicName, int UserId) { using (EditorsEntities entity = new EditorsEntities()) { Topic NewUserTopic = new Topic(); NewUserTopic.TopicName = TopicName; NewUserTopic.SpecialtyID = SpecId; NewUserTopic.Type = 2; // 2 Represents User Topic NewUserTopic.UserID = UserId; NewUserTopic.createtime = DateTime.Now; entity.Topics.Add(NewUserTopic); entity.SaveChanges(); return(true); } }
public static bool ShowSubTopics(List <int> SubTopicIds, int UserId) { using (EditorsEntities entity = new EditorsEntities()) { foreach (var SubTopicId in SubTopicIds) { HiddenSubTopic HT = entity.HiddenSubTopics.Where(h => h.UserID == UserId && h.SubTopicID == SubTopicId).FirstOrDefault(); if (HT != null) { entity.HiddenSubTopics.Remove(HT); } } 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); } }
// To add ACRDocument Relation public static bool AddACRDocumentRelation(ACRDocumentRelationshipModel NewRelation, string subtopicId) { using (EditorsEntities entity = new EditorsEntities()) { doc ACRDocument = entity.docs.Find(NewRelation.DocId); if (ACRDocument != null) { doc_in_subtopic newRelationDB = new doc_in_subtopic(); newRelationDB.doc_id = NewRelation.DocId; newRelationDB.subtopic_id = Convert.ToInt32(subtopicId); entity.doc_in_subtopic.Add(newRelationDB); entity.SaveChanges(); return(true); } else { return(false); } } }
// To Add User Sub Topic public static bool AddSubTopic(string TopicId, string SubTopicName, int UserId) { using (EditorsEntities entity = new EditorsEntities()) { try { SubTopic NewUserSubTopic = new SubTopic(); NewUserSubTopic.TopicID = Convert.ToInt32(TopicId); NewUserSubTopic.UserID = UserId; NewUserSubTopic.SubTopicName = SubTopicName; NewUserSubTopic.Type = 2; // 2 Represents User SubTopic NewUserSubTopic.createtime = DateTime.Now; entity.SubTopics.Add(NewUserSubTopic); entity.SaveChanges(); return(true); } catch (Exception) { return(false); } } }
static void DeleteUserTopic(EditorsEntities entity, int TopicId, int UserId) { // First need to Get and delete SubTopics in the Topic which is going to Delete var Subtopics = (from s in entity.SubTopics where s.TopicID == TopicId && (((s.Type == 2) && s.UserID == UserId) || s.Type == 3) select s.SubTopicID).ToList(); foreach (var SubTopicId in Subtopics) { DeleteUserSubTopic(entity, SubTopicId, UserId); } // Completed Deleting Subtopics in Topics // Need to Delete UserTopic var UserTopicToBeDeleted = entity.Topics.Where(s => s.TopicID == TopicId && s.UserID == UserId && s.Type == 2).FirstOrDefault(); if (UserTopicToBeDeleted != null) { entity.Topics.Remove(UserTopicToBeDeleted); } entity.SaveChanges(); }