/// <summary> /// ToDoアイテムを追加します。 /// </summary> /// <param name="todo"></param> /// <returns></returns> public TodosItem Add(TodosItem todo) { if (string.IsNullOrEmpty(todo.Id)) { todo.Id = Guid.NewGuid().ToString(); } // Save var cl = GetDatabaseClient(); var sql = $"insert into [TODOS] (Id,State,Priority,Title,StartDate,EndDate,Memo,UserName) VALUES (@Id,@State,@Priority,@Title,@StartDate,@EndDate,@Memo,@UserName)"; var p = new Dictionary <string, object> { { "Id", todo.Id }, { "State", todo.State }, { "Priority", todo.Priority }, { "Title", todo.Title }, { "StartDate", todo.StartDate }, { "EndDate", todo.EndDate }, { "Memo", todo.Memo }, { "UserName", todo.UserName } }; cl.ExecuteSql(sql, p); // Get return(Get(todo.Id)); }
/// <summary> /// ToDoアイテムを更新します。 /// </summary> /// <param name="todo"></param> /// <returns></returns> public TodosItem Update(TodosItem todo) { // Save var cl = GetDatabaseClient(); var sql = $"update TODOS set Title = @Title, Memo = @Memo,State=@State,Priority=@Priority,StartDate=@StartDate,EndDate=@EndDate where Id = @Id"; var p = new Dictionary <string, object> { { "Id", todo.Id }, { "State", todo.State }, { "Priority", todo.Priority }, { "Title", todo.Title }, { "StartDate", todo.StartDate }, { "EndDate", todo.EndDate }, { "Memo", todo.Memo }, { "UserName", todo.UserName } }; cl.ExecuteSql(sql, p); // Get return(Get(todo.Id)); }