public override IContext CreateContext(string contextName, ContextSchema schema) { if (string.IsNullOrEmpty(contextName)) { throw new ArgumentNullException("contextName"); } if (schema == null) { throw new ArgumentNullException("schema"); } IContext context; lock (padlock) { if (ContextsContains(contextName)) { throw new ContextAlreadyExistsException("A context with the name [" + contextName + "] already exists."); } using (var transaction = TransactionFactory.BeginTransaction(CurrentDB)) { CurrentDB.ExecuteNonQuery("dbo.USER_CreateContext", transaction, CurrentDB.CreateStringInputParameter("@chvContext", DbType.AnsiString, contextName)); foreach (var s in schema) { AddSchemaToContext(s, contextName, transaction); } context = new Context(contextName); transaction.Commit(); } contexts.Add(context); } return(context); }
/// <summary> /// 物理删除笔记 /// </summary> /// <param name="noteId"></param> public void RemoveNoteFinal(int noteId) { var note = GetMyNote(noteId); CurrentDB.OneNoteTable.Remove(note); CurrentDB.SaveChanges(); }
public void Delete(int planId) { var plan = CurrentDB.DayPlanTable.Find(planId); CurrentDB.DayPlanTable.Remove(plan); CurrentDB.SaveChanges(); }
public override IEnumerable <IContext> GetContexts() { if (contexts != null) { return(contexts); } lock (padlock) { if (contexts == null) { var contextCollection = new List <IContext>(); var dsFunction = CurrentDB.ExecuteDataSet("dbo.USER_GetContexts"); if (dsFunction.Tables.Count > 0) { foreach (DataRow row in dsFunction.Tables[0].Rows) { var contextName = (string)row["ContextName"]; IContext uc = new Context(contextName); contextCollection.Add(uc); } } contexts = contextCollection; } } return(contexts); }
/// <summary> /// 是否将上传了附件笔记 /// </summary> /// <param name="noteId"></param> public void CreateAttachment(int noteId) { var note = CurrentDB.OneNoteTable.Find(noteId); note.WithAttach = true; CurrentDB.SaveChanges(); }
/// <summary> /// 更新笔记本 /// </summary> /// <param name="bookId"></param> /// <param name="bookName"></param> /// <returns></returns> public NoteBook UpdateNoteBook(int bookId, string bookName) { var notebook = GetMyBook(bookId); notebook.BookName = bookName; CurrentDB.SaveChanges(); return(notebook); }
public DayPlan Update(int planId, string content, DateTime endAt) { var plan = CurrentDB.DayPlanTable.Find(planId); plan.Content = content; plan.CreateAt = endAt; CurrentDB.SaveChanges(); return(plan); }
/// <summary> /// 增加一条笔记 /// </summary> /// <param name="note"></param> /// <returns></returns> public OneNote CreateNote(NewNote note) { var oneNote = (OneNote)note; oneNote.UserId = CurrentPrincipal.UserId; CurrentDB.OneNoteTable.Add(oneNote); CurrentDB.SaveChanges(); return(note); }
public override void DeleteUser(IUser user) { if (user == null) { throw new ArgumentNullException("user"); } UserCache.RemoveUserFromCache(user); CurrentDB.ExecuteNonQuery("dbo.USER_Delete", CurrentDB.CreateInputParameter("@guidUserID", DbType.Guid, new Guid(user.Id))); }
protected virtual void AddSchemaToContext(PropertyDefinition definition, string contextName, ITransaction transaction) { CurrentDB.ExecuteNonQuery("dbo.USER_AddContextualPropertySchema", transaction, CurrentDB.CreateStringInputParameter("@chvContext", DbType.AnsiString, contextName, true), CurrentDB.CreateStringInputParameter("@chvPropertyName", DbType.AnsiString, definition.PropertyName, true)); }
public bool ToggleShareIt(int noteId) { var note = GetMyNote(noteId); if (note != null) { note.ShareOrNot = !note.ShareOrNot; CurrentDB.SaveChanges(); return(note.ShareOrNot); } return(false); }
public bool ToggleShareOrNot(int planId) { var plan = CreateMyQuery().FirstOrDefault(o => o.Id == planId); if (plan != null) { plan.ShareOrNot = !plan.ShareOrNot; CurrentDB.SaveChanges(); return(plan.ShareOrNot); } return(false); }
/// <summary> /// 修改1条笔记 /// </summary> /// <param name="noteId"></param> /// <param name="oneNote"></param> /// <returns></returns> public OneNote UpdateNote(NoteUpdating noteUpdating) { var oneNote = GetMyNote(noteUpdating.NoteId); if (oneNote == null) { throw new ArgumentException("笔记未找到"); } noteUpdating.Merge(oneNote).UpdateAt = DateTime.Now; CurrentDB.SaveChanges(); return(oneNote); }
public bool DeletePlan(int planId) { var plan = CreateMyQuery().FirstOrDefault(o => o.Id == planId); if (plan == null) { return(false); } CurrentDB.DayPlanTable.Remove(plan); CurrentDB.SaveChanges(); return(true); }
public bool ToggleCompleted(int planId) { var plan = CreateMyQuery().FirstOrDefault(o => o.Id == planId); if (plan != null) { plan.IsCompleted = !plan.IsCompleted; plan.CompletedAt = plan.IsCompleted ? new DateTime?(DateTime.Now) : null; CurrentDB.SaveChanges(); return(plan.IsCompleted); } return(false); }
/// <summary> /// 撤销删除的笔记 /// </summary> /// <param name="noteId"></param> /// <returns></returns> public bool RecoveryNote(int noteId) { var onenote = GetMyNote(noteId, true); if (onenote == null) { return(false); } onenote.IsDeleted = false; CurrentDB.SaveChanges(); return(!onenote.IsDeleted); }
public DayPlan Create(PlanType type, long UserId, DateTime StartAt) { DayPlan dayplan = new DayPlan() { UserId = CurrentPrincipal.UserId, CreateAt = DateTime.Now, UpdateAt = DateTime.Now }; CurrentDB.DayPlanTable.Add(dayplan); CurrentDB.SaveChanges(); return(dayplan); }
private ShareList CreateShareList(int?noteId = null, int?planId = null) { var shareInfo = CurrentDB.ShareTable.Add(new ShareList() { UserId = AuthorizationContext.CurrentPrincipal.UserId, ShareAt = DateTime.Now, PlanId = planId, NoteId = noteId }); CurrentDB.SaveChanges(); return(shareInfo); }
public DayPlan UpdatePlan(PlanUpdateInput updating) { var plan = CreateMyQuery().FirstOrDefault(o => o.Id == updating.PlanId); if (plan == null) { return(null); } plan = updating.UpdateTo(plan); CurrentDB.SaveChanges(); return(plan); }
/// <summary> /// 删除笔记本 /// </summary> /// <param name="bookId"></param> public void RemoveNoteBook(int bookId) // OK { var notebook = GetMyBook(bookId); if (notebook != null) { var notes = CurrentDB.OneNoteTable.Where(o => o.BookId == bookId); CurrentDB.OneNoteTable.RemoveRange(notes); CurrentDB.NoteBookTable.Remove(notebook); CurrentDB.SaveChanges(); } }
public DayOne.Entities.DayPlan CreatePlan(PlanInput planInput) { if (planInput == null) { throw new ArgumentNullException("planInput"); } DayPlan dayplan = planInput; dayplan.UserId = this.CurrentPrincipal.UserId; dayplan = CurrentDB.DayPlanTable.Add(dayplan); CurrentDB.SaveChanges(); return(dayplan); }
public override string[] GetDomains() { var dsDomains = CurrentDB.ExecuteDataSet("dbo.USER_GetDomains"); if (dsDomains.Tables.Count == 1 && dsDomains.Tables[0].Rows.Count > 0) { var result = new string[dsDomains.Tables[0].Rows.Count]; for (var i = 0; i < result.Length; i++) { result[i] = dsDomains.Tables[0].Rows[i]["Domain"].ToString(); } return(result); } return(new string[0]); }
public override IUser GetUserById(string userId) { var user = UserCache.GetUserById(userId); if (user != null) { return(user); } var dsUser = CurrentDB.ExecuteDataSet("dbo.USER_GetByID", CurrentDB.CreateInputParameter("@guidUserID", DbType.Guid, new Guid(userId))); user = GetUserFromDataSet(dsUser); UserCache.AddUserToCache(user); return(user); }
public override void DeleteContext(IContext context) { if (context == null) { throw new ArgumentNullException("context"); } lock (padlock) { using (var transaction = TransactionFactory.BeginTransaction(CurrentDB)) { CurrentDB.ExecuteNonQuery("dbo.USER_DeleteContext", transaction, CurrentDB.CreateStringInputParameter("@chvContext", DbType.AnsiString, context.Name, true)); transaction.Commit(); } contexts.Remove(context); } }
public override IList <IUser> GetUsersByDomain(string domain) { if (domain == null) { domain = string.Empty; } var dsUser = CurrentDB.ExecuteDataSet("dbo.USER_GetUsersByDomain", CurrentDB.CreateStringInputParameter("@chvDomain", DbType.AnsiString, domain, false)); var uc = GetUsersFromDataSet(dsUser); UserCache.AddUsersToCache(uc); return(uc); }
public UserInfo ChangePassword(string newpw) { if (string.IsNullOrWhiteSpace(newpw)) { return(null); } var userInfo = CurrentDB.UserTable.Find(CurrentPrincipal.UserId); if (userInfo == null) { return(null); } userInfo.PassWord = newpw; CurrentDB.SaveChanges(); return(null); }
protected virtual void SaveProperty(IUser user, IProperty property, ITransaction transaction) { var propertyValue = string.Empty; if (!property.IsEmpty()) { propertyValue = property.ToSerializedString(); } if (propertyValue.Length > 0) { CurrentDB.ExecuteNonQuery("dbo.USER_UpdateProperty", transaction, CurrentDB.CreateInputParameter("@guidUserId", DbType.Guid, new Guid(user.Id)), CurrentDB.CreateStringInputParameter("@chvProperty", DbType.AnsiString, property.Name), CurrentDB.CreateStringInputParameter("@chvnPropertyValue", DbType.String, propertyValue.Length <= 4000 ? propertyValue : null), CurrentDB.CreateStringInputParameter("@txtnExtPropertyValue", DbType.String, propertyValue.Length > 4000 ? propertyValue : null), CurrentDB.CreateStringInputParameter("@chvContext", DbType.AnsiString, property.Context == null || string.IsNullOrEmpty(property.Context.Name) ? null : property.Context.Name)); } else { CurrentDB.ExecuteNonQuery("dbo.USER_DeleteProperty", transaction, CurrentDB.CreateInputParameter("@guidUserId", DbType.Guid, new Guid(user.Id)), CurrentDB.CreateStringInputParameter("@chvPropertyName", DbType.AnsiString, property.Name), CurrentDB.CreateStringInputParameter("@chvContextName", DbType.AnsiString, property.Context == null || string.IsNullOrEmpty(property.Context.Name) ? null : property.Context.Name)); } property.IsDirty = false; }
/// <summary> /// 逻辑删除 放到回收站 /// </summary> /// <param name="noteId"></param> public void RemoveNote2(int noteId, bool destroy = false) { var onenote = GetMyNote(noteId, true); if (onenote == null) { return; } if (destroy) { CurrentDB.OneNoteTable.Remove(onenote); } else { onenote.IsDeleted = true; } CurrentDB.SaveChanges(); }
/// <summary> /// 增加笔记本 /// </summary> /// <param name="bookName"></param> /// <param name="bookId"></param> /// <returns></returns> public NoteBook AddNoteBook(string bookName) // OK { if (string.IsNullOrWhiteSpace(bookName)) { throw new ArgumentNullException("bookName"); } NoteBook notebook = new NoteBook() { UserId = CurrentPrincipal.UserId, CreateAt = DateTime.Now, BookName = bookName, ShareOrNot = false, }; CurrentDB.NoteBookTable.Add(notebook); CurrentDB.SaveChanges(); return(notebook); }
public override IUser GetUserByUserName(string userName, string domain) { var user = UserCache.GetUserByUserName(userName, domain); if (user != null) { return(user); } var dsUser = CurrentDB.ExecuteDataSet("dbo.USER_GetByUsername", CurrentDB.CreateStringInputParameter("@chvnUsername", DbType.String, userName), CurrentDB.CreateStringInputParameter("@chvDomain", DbType.AnsiString, domain ?? string.Empty)); user = GetUserFromDataSet(dsUser); UserCache.AddUserToCache(user); return(user); }