public int AddTemplate(int FolderId, string TxtNewNoteName, string Content) { CMember member = (CMember)Session[CMemberSession.Session_Login_User];//會員 //查詢筆記資料夾 CNoteFolder myFolder = CNoteFolderFactory.fn筆記資料夾查詢(member) .FirstOrDefault(f => f.fFolderId == FolderId); int level = CNoteFactory.fn私人筆記查詢(myFolder).Where(n => n.fIsTrash == false).Count(); CNote myNote = new CNote() { fCreateDateTime = DateTime.UtcNow.AddHours(08), fEditDateTime = DateTime.UtcNow.AddHours(08), fFolderId = FolderId, fIsMyFavourite = false, fIsTrash = false, fHTMLContent = "", fJsonContent = Content, fNoteListLevel = level, fNoteListName = TxtNewNoteName, fTheContactPerson = null, fTheShareLink = null }; int noteid = CNoteFactory.fn私人筆記新增(myFolder, myNote); return(noteid); }
public ActionResult MyNote(int?FolderId) { if (Session[CMemberSession.Session_Login_User] == null)//防止未登入者進入筆記系統 { return(RedirectToAction("../Member/Login")); } CMember member = (CMember)Session[CMemberSession.Session_Login_User];//會員 //查詢未分類筆記 CNoteFolder defaultFolder = CNoteFolderFactory.fn筆記資料夾查詢(member) .FirstOrDefault(f => f.fFolderName == "未分類筆記"); List <CNote> lsDefaultNote = CNoteFactory.fn私人筆記查詢(defaultFolder) .ToList(); //網址未輸入資料夾ID,轉到未分類筆記 if (FolderId == null) { return(View("MyNote", "_Layout", lsDefaultNote)); } //查詢筆記資料夾 CNoteFolder myFolder = CNoteFolderFactory.fn筆記資料夾查詢(member) .FirstOrDefault(f => f.fFolderId == (int)FolderId); //網址輸入不存在的資料夾ID,轉到未分類筆記 if (myFolder == null) { return(View("MyNote", "_Layout", lsDefaultNote)); } //查詢所有筆記 List <CNote> lsNote = CNoteFactory.fn私人筆記查詢(myFolder) .ToList(); //轉到筆記頁面 return(View("MyNote", "_Layout", lsNote)); }
public ActionResult DeleteFolder(int FolderId) { CMember member = (CMember)Session[CMemberSession.Session_Login_User];//會員 //查詢筆記資料夾 CNoteFolder myFolder = CNoteFolderFactory.fn筆記資料夾查詢(member) .FirstOrDefault(f => f.fFolderId == FolderId); CNoteFolderFactory.fn筆記資料夾刪除(myFolder, member); //查詢所有的筆記資料夾 List <CNoteFolder> lsFolder = CNoteFolderFactory.fn筆記資料夾查詢(member) .ToList(); //筆記資料夾包含筆記的列表 List <CNoteFolderViewModel> lsNotefolderVM = new List <CNoteFolderViewModel>(); //讀取筆記資料夾內的筆記 foreach (var folder in lsFolder) { List <CNote> myLsNote = CNoteFactory.fn私人筆記查詢(folder) .ToList(); lsNotefolderVM.Add(new CNoteFolderViewModel() { fFolderId = folder.fFolderId, fFolderName = folder.fFolderName, fMemberId = folder.fMemberId, lsNote = myLsNote }); } return(PartialView("_TrashView", lsNotefolderVM)); //return "資料夾刪除成功!"; }
public string FolderRename(int FolderId, string FolderName) { CMember member = (CMember)Session[CMemberSession.Session_Login_User];//會員 //查詢筆記資料夾 CNoteFolder myFolder = CNoteFolderFactory.fn筆記資料夾查詢(member) .FirstOrDefault(f => f.fFolderId == FolderId); myFolder.fFolderName = FolderName; CNoteFolderFactory.fn筆記資料夾更新(myFolder); return("資料夾重新命名成功!"); }
public string SearchFavor(int FolderId, int NoteId) { CMember member = (CMember)Session[CMemberSession.Session_Login_User];//會員 //查詢筆記資料夾 CNoteFolder myFolder = CNoteFolderFactory.fn筆記資料夾查詢(member) .FirstOrDefault(f => f.fFolderId == (int)FolderId); //查詢指定筆記內容 CNote myNote = CNoteFactory.fn私人筆記查詢(myFolder) .FirstOrDefault(n => n.fNoteId == NoteId && n.fIsTrash == false && n.fIsMyFavourite == true); return(myNote.fJsonContent); }
public int AddNoteFolder(string TxtNewFolderName) { CMember member = (CMember)Session[CMemberSession.Session_Login_User];//會員 CNoteFolder myFolder = new CNoteFolder() { fMemberId = member.fMemberId, fFolderName = TxtNewFolderName }; int folderid = CNoteFolderFactory.fn筆記資料夾新增(member, myFolder); return(folderid); }
public ActionResult SearchVersion(int FolderId, int NoteId) { CMember member = (CMember)Session[CMemberSession.Session_Login_User];//會員 //查詢筆記資料夾 CNoteFolder myFolder = CNoteFolderFactory.fn筆記資料夾查詢(member) .FirstOrDefault(f => f.fFolderId == (int)FolderId); //查詢指定筆記內容 CNote myNote = CNoteFactory.fn私人筆記查詢(myFolder) .FirstOrDefault(n => n.fNoteId == NoteId && n.fIsTrash == false); List <CVersion> lsVersion = CVersionFactory.fn筆記版本控制查詢(myNote); return(PartialView("_SearchVersionView", lsVersion)); }
public string NoteRename(int FolderId, int NoteId, string NoteName) { CMember member = (CMember)Session[CMemberSession.Session_Login_User];//會員 //查詢筆記資料夾 CNoteFolder myFolder = CNoteFolderFactory.fn筆記資料夾查詢(member) .FirstOrDefault(f => f.fFolderId == FolderId); //查詢指定筆記內容 CNote myNote = CNoteFactory.fn私人筆記查詢(myFolder) .FirstOrDefault(n => n.fNoteId == NoteId); myNote.fNoteListName = NoteName; myNote.fEditDateTime = DateTime.UtcNow.AddHours(08); CNoteFactory.fn私人筆記更新(myNote); return("筆記已重新命名!"); }
public string Update(int FolderId, int NoteId, string JsonContent) { CMember member = (CMember)Session[CMemberSession.Session_Login_User];//會員 //查詢筆記資料夾 CNoteFolder myFolder = CNoteFolderFactory.fn筆記資料夾查詢(member) .FirstOrDefault(f => f.fFolderId == FolderId); //查詢指定筆記內容 CNote myNote = CNoteFactory.fn私人筆記查詢(myFolder) .FirstOrDefault(n => n.fNoteId == NoteId); myNote.fJsonContent = JsonContent; myNote.fEditDateTime = DateTime.UtcNow.AddHours(08); CNoteFactory.fn私人筆記更新(myNote); return("筆記更新成功"); }
public string MoveOutTrash(int FolderId, int NoteId) { CMember member = (CMember)Session[CMemberSession.Session_Login_User];//會員 CNoteFolder m原筆記資料夾 = CNoteFolderFactory.fn筆記資料夾查詢(member) .FirstOrDefault(f => f.fFolderId == FolderId); CNote myNote = CNoteFactory.fn私人筆記查詢(m原筆記資料夾) .FirstOrDefault(n => n.fNoteId == NoteId); myNote.fIsTrash = false; CNoteFactory.fn私人筆記更新(myNote); return("筆記還原!"); }
public string UpdateFavor(int FolderId, int NoteId, bool IsFavor) { CMember member = (CMember)Session[CMemberSession.Session_Login_User];//會員 //查詢筆記資料夾 CNoteFolder myFolder = CNoteFolderFactory.fn筆記資料夾查詢(member) .FirstOrDefault(f => f.fFolderId == FolderId); //查詢指定筆記內容 CNote myNote = CNoteFactory.fn私人筆記查詢(myFolder) .FirstOrDefault(n => n.fNoteId == NoteId); myNote.fIsMyFavourite = IsFavor; myNote.fEditDateTime = DateTime.UtcNow.AddHours(08); CNoteFactory.fn私人筆記更新(myNote); return("我的最愛筆記已更新!"); }
public ActionResult MoveToTrash(int FolderId, int NoteId) { CMember member = (CMember)Session[CMemberSession.Session_Login_User];//會員 CNoteFolder m原筆記資料夾 = CNoteFolderFactory.fn筆記資料夾查詢(member) .FirstOrDefault(f => f.fFolderId == FolderId); CNoteFolder m未分類筆記 = CNoteFolderFactory.fn筆記資料夾查詢(member) .FirstOrDefault(f => f.fFolderName == "未分類筆記"); CNote myNote = CNoteFactory.fn私人筆記查詢(m原筆記資料夾) .FirstOrDefault(n => n.fNoteId == NoteId); myNote.fIsTrash = true; myNote.fFolderId = m未分類筆記.fFolderId; CNoteFactory.fn私人筆記更新(myNote); //查詢所有的筆記資料夾 List <CNoteFolder> lsFolder = CNoteFolderFactory.fn筆記資料夾查詢(member) .ToList(); //筆記資料夾包含筆記的列表 List <CNoteFolderViewModel> lsNotefolderVM = new List <CNoteFolderViewModel>(); //讀取筆記資料夾內的筆記 foreach (var folder in lsFolder) { List <CNote> myLsNote = CNoteFactory.fn私人筆記查詢(folder) .ToList(); lsNotefolderVM.Add(new CNoteFolderViewModel() { fFolderId = folder.fFolderId, fFolderName = folder.fFolderName, fMemberId = folder.fMemberId, lsNote = myLsNote }); } return(PartialView("_TrashView", lsNotefolderVM)); //return "筆記移到垃圾桶!"; }