/// <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));
}
