public void AddIfNotExist(NoteEntity note) { if (null == note) { throw new ArgumentNullException("note"); } using (var dc = new MyDataContext()) { //var a = new System.IO.StringWriter(); //dc.Log = a; var entity = dc.NoteTable.FirstOrDefault(n => n.NotePath == note.NotePath); if (null != entity) { return; } ensureTitleIsNotEmpty(note); dc.NoteTable.InsertOnSubmit(note); dc.SafeSubmitChanges(); } //Debug.WriteLine(a); if (NoteCreated != null) { NoteCreated(note); } if (NoteChanged != null) { NoteChanged(); } }
/// <summary> /// 如果笔记存在,则将笔记删除。 /// </summary> /// <param name="id"></param> public void DeleteIfExist(string id) { if (string.IsNullOrEmpty(id)) { throw new ArgumentNullException("id"); } using (var dc = new MyDataContext()) { var entity = dc.NoteTable.FirstOrDefault(n => n.Id == id); if (null == entity) { return; } dc.NoteTable.DeleteOnSubmit(entity); dc.SafeSubmitChanges(); if (NoteDeleted != null) { NoteDeleted(entity); } if (NoteChanged != null) { NoteChanged(); } } }
public void AddIfNotExist(NoteEntity note) { if (null == note) { throw new ArgumentNullException("note"); } using (var dc = new MyDataContext()) { //var a = new System.IO.StringWriter(); //dc.Log = a; var entity = dc.NoteTable.FirstOrDefault(n => n.NotePath == note.NotePath); if (null != entity) return; ensureTitleIsNotEmpty(note); dc.NoteTable.InsertOnSubmit(note); dc.SafeSubmitChanges(); } //Debug.WriteLine(a); if (NoteCreated != null) { NoteCreated(note); } if (NoteChanged != null) { NoteChanged(); } }
public void DeleteAllIfExist(List <string> ids) { if (null == ids) { throw new ArgumentNullException("ids"); } var isNoteChangedFlag = false; using (var dc = new MyDataContext()) { foreach (var id in ids) { var entity = dc.NoteTable.FirstOrDefault(n => n.Id == id); if (null == entity) { return; } dc.NoteTable.DeleteOnSubmit(entity); if (NoteDeleted != null) { NoteDeleted(entity); } isNoteChangedFlag = true; } dc.SafeSubmitChanges(); } if (isNoteChangedFlag) { if (NoteChanged != null) { NoteChanged(); } } }
public void Clear() { using (var dc = new MyDataContext()) { dc.NotebookTable.DeleteAllOnSubmit(from e in dc.NotebookTable select e); dc.SafeSubmitChanges(); } }
public void Clear() { using (var dc = new MyDataContext()) { dc.NotebookTable.DeleteAllOnSubmit(from e in dc.NotebookTable select e); dc.SafeSubmitChanges(); } }
public void Clear() { using (var dc = new MyDataContext()) { dc.NoteTable.DeleteAllOnSubmit(from e in dc.NoteTable select e); dc.SafeSubmitChanges(); } if (NoteCleared != null) { NoteCleared(); } if (NoteChanged != null) { NoteChanged(); } }
public void ModifyIfExist(NoteEntity entity) { if (null == entity) { throw new ArgumentNullException("entity"); } using (var dc = new MyDataContext()) { //var a = new System.IO.StringWriter(); //dc.Log = a; var note = dc.NoteTable.FirstOrDefault(n => n.Id == entity.Id); if (null == note) { Debug.WriteLine("ModifyIfExist::note is null."); return; } ensureTitleIsNotEmpty(entity); var oldNote = note.DeepClone(); note.NotePath = entity.NotePath; note.Title = entity.Title; note.CreateTime = entity.CreateTime; note.ModifyTime = entity.ModifyTime; note.Size = entity.Size; note.Source = entity.Source; note.NotebookName = entity.NotebookName; note.NotebookPath = entity.NotebookPath; note.Content = entity.Content; note.Author = entity.Author; note.NoteStatus = entity.NoteStatus; dc.SafeSubmitChanges(); //Debug.WriteLine(a); if (NoteModified != null) { NoteModified(oldNote, note); } if (NoteChanged != null) { NoteChanged(); } } }
private static void DeleteIfExist(string id) { if (string.IsNullOrEmpty(id)) { throw new ArgumentNullException("id"); } using (var dc = new MyDataContext()) { var entity = dc.ImageTable.FirstOrDefault(p => p.Id == id); if (null == entity) { return; } dc.ImageTable.DeleteOnSubmit(entity); dc.SafeSubmitChanges(); } }
public static void InsertIfNotExist(ImageEntity imgEntity) { if (null == imgEntity) { throw new ArgumentNullException("imgEntity"); } using (var dc = new MyDataContext()) { var entity = dc.ImageTable.FirstOrDefault(i => i.Id == imgEntity.Id); if (null != entity) { return; } dc.ImageTable.InsertOnSubmit(imgEntity); dc.SafeSubmitChanges(); } }
/// <summary> /// 将笔记标记为已删除。 /// </summary> /// <param name="id"></param> public void MarkAsDeletedIfExist(string id) { if (string.IsNullOrEmpty(id)) { throw new ArgumentNullException("id"); } using (var dc = new MyDataContext()) { var entity = dc.NoteTable.FirstOrDefault(n => n.Id == id); if (null == entity) { return; } entity.NoteStatus = NoteStatus.Deleted; dc.SafeSubmitChanges(); } }
public static void DeleteImageByBelongedNotePath(string belongedNotePath) { if (string.IsNullOrEmpty(belongedNotePath)) { throw new ArgumentNullException("belongedNotePath"); } using (var dc = new MyDataContext()) { var entities = from image in dc.ImageTable where image.BelongedNotePath.Equals(belongedNotePath) select image; foreach (var entity in entities) { dc.ImageTable.DeleteOnSubmit(entity); } dc.SafeSubmitChanges(); } }
public static void DeleteImageByBelongedNotePath(string belongedNotePath) { if (string.IsNullOrEmpty(belongedNotePath)) { throw new ArgumentNullException("belongedNotePath"); } using (var dc = new MyDataContext()) { var entities = from image in dc.ImageTable where image.BelongedNotePath.Equals(belongedNotePath) select image; foreach (var entity in entities) { dc.ImageTable.DeleteOnSubmit(entity); } dc.SafeSubmitChanges(); } }
public void ModifyOrAddIfNotExistsAll(List <Notebook> notebooks) { if (null == notebooks) { throw new ArgumentNullException("notebooks"); } using (var dc = new MyDataContext()) { foreach (var nb in notebooks) { var notebookEntity = dc.NotebookTable.FirstOrDefault(n => n.Path == nb.Path); if (null == notebookEntity) { var entity = new NotebookEntity(nb); dc.NotebookTable.InsertOnSubmit(entity); if (NotebookCreated != null) { NotebookCreated(entity); } } else { if (notebookEntity.Name == nb.Name && notebookEntity.Path == nb.Path && notebookEntity.NotesNum == nb.NotesNum && notebookEntity.CreateTime == nb.CreateTime && notebookEntity.ModifyTime == nb.ModifyTime) { continue; } notebookEntity.Name = nb.Name; notebookEntity.Path = nb.Path; notebookEntity.NotesNum = nb.NotesNum; notebookEntity.CreateTime = nb.CreateTime; notebookEntity.ModifyTime = nb.ModifyTime; if (NotebookModified != null) { NotebookModified(notebookEntity); } } } dc.SafeSubmitChanges(); } }
public static void ModifyIfExist(ImageEntity entity) { if (null == entity) { throw new ArgumentNullException("entity"); } using (var dc = new MyDataContext()) { var pic = dc.ImageTable.FirstOrDefault(p => p.Id == entity.Id); if (null == pic) { return; } pic.ImgLocalSavePath = entity.ImgLocalSavePath; pic.BelongedNotePath = entity.BelongedNotePath; pic.ImgRemoteUrl = entity.ImgRemoteUrl; dc.SafeSubmitChanges(); } }
public void BatchOperate(Dictionary<NoteBatchOperateEnum, List<NoteEntity>> dic) { if (null == dic) { throw new ArgumentNullException("dic"); } var isNoteChangedFlag = false; using (var dc = new MyDataContext()) { foreach (var noteEntity in dic[NoteBatchOperateEnum.Add]) { if (null == noteEntity) continue; var entity = dc.NoteTable.FirstOrDefault(n => n.NotePath == noteEntity.NotePath); if (null != entity) return; ensureTitleIsNotEmpty(noteEntity); dc.NoteTable.InsertOnSubmit(noteEntity); if (NoteCreated != null) { NoteCreated(noteEntity); } isNoteChangedFlag = true; } foreach (var noteEntity in dic[NoteBatchOperateEnum.Modify]) { var note = dc.NoteTable.FirstOrDefault(n => n.Id == noteEntity.Id); if (null == note) { return; } ensureTitleIsNotEmpty(noteEntity); var oldNote = note.DeepClone(); note.NotePath = noteEntity.NotePath; note.Title = noteEntity.Title; note.CreateTime = noteEntity.CreateTime; note.ModifyTime = noteEntity.ModifyTime; note.Size = noteEntity.Size; note.Source = noteEntity.Source; note.NotebookName = noteEntity.NotebookName; note.NotebookPath = noteEntity.NotebookPath; note.Content = noteEntity.Content; note.Author = noteEntity.Author; note.NoteStatus = noteEntity.NoteStatus; if (NoteModified != null) { NoteModified(oldNote, note); } isNoteChangedFlag = true; } foreach (var noteEntity in dic[NoteBatchOperateEnum.Delete]) { var entity = dc.NoteTable.FirstOrDefault(n => n.Id == noteEntity.Id); if (null == entity) return; dc.NoteTable.DeleteOnSubmit(entity); if (NoteDeleted != null) { NoteDeleted(entity); } isNoteChangedFlag = true; } dc.SafeSubmitChanges(); } if (isNoteChangedFlag) { if (NoteChanged != null) { NoteChanged(); } } }
public void ModifyIfExist(NoteEntity entity) { if (null == entity) { throw new ArgumentNullException("entity"); } using (var dc = new MyDataContext()) { //var a = new System.IO.StringWriter(); //dc.Log = a; var note = dc.NoteTable.FirstOrDefault(n => n.Id == entity.Id); if (null == note) { Debug.WriteLine("ModifyIfExist::note is null."); return; } ensureTitleIsNotEmpty(entity); var oldNote = note.DeepClone(); note.NotePath = entity.NotePath; note.Title = entity.Title; note.CreateTime = entity.CreateTime; note.ModifyTime = entity.ModifyTime; note.Size = entity.Size; note.Source = entity.Source; note.NotebookName = entity.NotebookName; note.NotebookPath = entity.NotebookPath; note.Content = entity.Content; note.Author = entity.Author; note.NoteStatus = entity.NoteStatus; dc.SafeSubmitChanges(); //Debug.WriteLine(a); if (NoteModified != null) { NoteModified(oldNote, note); } if (NoteChanged != null) { NoteChanged(); } } }
/// <summary> /// 将笔记标记为已删除。 /// </summary> /// <param name="id"></param> public void MarkAsDeletedIfExist(string id) { if (string.IsNullOrEmpty(id)) { throw new ArgumentNullException("id"); } using (var dc = new MyDataContext()) { var entity = dc.NoteTable.FirstOrDefault(n => n.Id == id); if (null == entity) return; entity.NoteStatus = NoteStatus.Deleted; dc.SafeSubmitChanges(); } }
/// <summary> /// 如果笔记存在,则将笔记删除。 /// </summary> /// <param name="id"></param> public void DeleteIfExist(string id) { if (string.IsNullOrEmpty(id)) { throw new ArgumentNullException("id"); } using (var dc = new MyDataContext()) { var entity = dc.NoteTable.FirstOrDefault(n => n.Id == id); if (null == entity) return; dc.NoteTable.DeleteOnSubmit(entity); dc.SafeSubmitChanges(); if (NoteDeleted != null) { NoteDeleted(entity); } if (NoteChanged != null) { NoteChanged(); } } }
public void DeleteAllIfExist(List<string> ids) { if (null == ids) { throw new ArgumentNullException("ids"); } var isNoteChangedFlag = false; using (var dc = new MyDataContext()) { foreach (var id in ids) { var entity = dc.NoteTable.FirstOrDefault(n => n.Id == id); if (null == entity) return; dc.NoteTable.DeleteOnSubmit(entity); if (NoteDeleted != null) { NoteDeleted(entity); } isNoteChangedFlag = true; } dc.SafeSubmitChanges(); } if (isNoteChangedFlag) { if (NoteChanged != null) { NoteChanged(); } } }
public void Clear() { using (var dc = new MyDataContext()) { dc.NoteTable.DeleteAllOnSubmit(from e in dc.NoteTable select e); dc.SafeSubmitChanges(); } if (NoteCleared != null) { NoteCleared(); } if (NoteChanged != null) { NoteChanged(); } }
public void BatchOperate(Dictionary <NoteBatchOperateEnum, List <NoteEntity> > dic) { if (null == dic) { throw new ArgumentNullException("dic"); } var isNoteChangedFlag = false; using (var dc = new MyDataContext()) { foreach (var noteEntity in dic[NoteBatchOperateEnum.Add]) { if (null == noteEntity) { continue; } var entity = dc.NoteTable.FirstOrDefault(n => n.NotePath == noteEntity.NotePath); if (null != entity) { return; } ensureTitleIsNotEmpty(noteEntity); dc.NoteTable.InsertOnSubmit(noteEntity); if (NoteCreated != null) { NoteCreated(noteEntity); } isNoteChangedFlag = true; } foreach (var noteEntity in dic[NoteBatchOperateEnum.Modify]) { var note = dc.NoteTable.FirstOrDefault(n => n.Id == noteEntity.Id); if (null == note) { return; } ensureTitleIsNotEmpty(noteEntity); var oldNote = note.DeepClone(); note.NotePath = noteEntity.NotePath; note.Title = noteEntity.Title; note.CreateTime = noteEntity.CreateTime; note.ModifyTime = noteEntity.ModifyTime; note.Size = noteEntity.Size; note.Source = noteEntity.Source; note.NotebookName = noteEntity.NotebookName; note.NotebookPath = noteEntity.NotebookPath; note.Content = noteEntity.Content; note.Author = noteEntity.Author; note.NoteStatus = noteEntity.NoteStatus; if (NoteModified != null) { NoteModified(oldNote, note); } isNoteChangedFlag = true; } foreach (var noteEntity in dic[NoteBatchOperateEnum.Delete]) { var entity = dc.NoteTable.FirstOrDefault(n => n.Id == noteEntity.Id); if (null == entity) { return; } dc.NoteTable.DeleteOnSubmit(entity); if (NoteDeleted != null) { NoteDeleted(entity); } isNoteChangedFlag = true; } dc.SafeSubmitChanges(); } if (isNoteChangedFlag) { if (NoteChanged != null) { NoteChanged(); } } }
public static void ModifyIfExist(ImageEntity entity) { if (null == entity) { throw new ArgumentNullException("entity"); } using (var dc = new MyDataContext()) { var pic = dc.ImageTable.FirstOrDefault(p => p.Id == entity.Id); if (null == pic) return; pic.ImgLocalSavePath = entity.ImgLocalSavePath; pic.BelongedNotePath = entity.BelongedNotePath; pic.ImgRemoteUrl = entity.ImgRemoteUrl; dc.SafeSubmitChanges(); } }
public static void InsertIfNotExist(ImageEntity imgEntity) { if (null == imgEntity) { throw new ArgumentNullException("imgEntity"); } using (var dc = new MyDataContext()) { var entity = dc.ImageTable.FirstOrDefault(i => i.Id == imgEntity.Id); if (null != entity) return; dc.ImageTable.InsertOnSubmit(imgEntity); dc.SafeSubmitChanges(); } }
public void ModifyOrAddIfNotExistsAll(List<Notebook> notebooks) { if (null == notebooks) { throw new ArgumentNullException("notebooks"); } using (var dc = new MyDataContext()) { foreach (var nb in notebooks) { var notebookEntity = dc.NotebookTable.FirstOrDefault(n => n.Path == nb.Path); if (null == notebookEntity) { var entity = new NotebookEntity(nb); dc.NotebookTable.InsertOnSubmit(entity); if (NotebookCreated != null) { NotebookCreated(entity); } } else { if (notebookEntity.Name == nb.Name && notebookEntity.Path == nb.Path && notebookEntity.NotesNum == nb.NotesNum && notebookEntity.CreateTime == nb.CreateTime && notebookEntity.ModifyTime == nb.ModifyTime) continue; notebookEntity.Name = nb.Name; notebookEntity.Path = nb.Path; notebookEntity.NotesNum = nb.NotesNum; notebookEntity.CreateTime = nb.CreateTime; notebookEntity.ModifyTime = nb.ModifyTime; if (NotebookModified != null) { NotebookModified(notebookEntity); } } } dc.SafeSubmitChanges(); } }
private static void DeleteIfExist(string id) { if (string.IsNullOrEmpty(id)) { throw new ArgumentNullException("id"); } using (var dc = new MyDataContext()) { var entity = dc.ImageTable.FirstOrDefault(p => p.Id == id); if (null == entity) return; dc.ImageTable.DeleteOnSubmit(entity); dc.SafeSubmitChanges(); } }