void ITaskFolderRepository.Add(TaskFolder folder)
{
using (var conn = GetConnection())
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "INSERT INTO TaskFolders (ID, Name) VALUES (@Id, @Name);";
cmd.Parameters.AddWithValue("@ID", folder.ID);
cmd.Parameters.AddWithValue("@Name", folder.Name);
cmd.ExecuteNonQuery();
_logger.InfoFormat("new task foler inserted, id:{0}, name:{1}", folder.ID, folder.Name);
}
}
}
void ITaskFolderService.Update(TaskFolder folder)
{
_repository.Update(folder);
}
void ITaskFolderService.Delete(TaskFolder folder)
{
_repository.Remove(folder);
_logger.InfoFormat("删除任务表#{0}", folder.ID);
}
void ITaskFolderService.Create(TaskFolder folder)
{
_repository.Add(folder);
_logger.InfoFormat("新增任务表{0}#{1}|{2}", folder, folder.ID, folder.Name);
}
void ITaskFolderService.Delete(TaskFolder folder)
{
_repository.Remove(folder);
_logger.InfoFormat("删除任务表#{0}", folder.ID);
}
void ITaskFolderService.Update(TaskFolder folder)
{
_repository.Update(folder);
}
void ITaskFolderService.Create(TaskFolder folder)
{
_repository.Add(folder);
_logger.InfoFormat("新增任务表{0}#{1}|{2}", folder, folder.ID, folder.Name);
}
void ITaskFolderRepository.Remove(TaskFolder folder)
{
var sql = string.Format("DELETE FROM TaskFolders WHERE ID = {0};", folder.ID);
using (var conn = GetConnection())
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
}
}
}
void ITaskFolderRepository.Update(TaskFolder folder)
{
using (var conn = GetConnection())
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "UPDATE TaskFolders SET Name = @Name WHERE ID = @Id";
cmd.Parameters.AddWithValue("@Id", Utils.ConvertType<int>(folder.ID));
cmd.Parameters.AddWithValue("@Name", folder.Name);
cmd.ExecuteNonQuery();
}
}
}
/// <summary>
/// 发送获取所有任务表的请求
/// </summary>
private void SendGetAllTaskFoldersRequest()
{
var sharedPreferences = GetSharedPreferences("CooperPreferences", FileCreationMode.Private);
var cookie = CookieManager.GetCookie(sharedPreferences, "CooperCookie");
var url = Constants.GET_TASKFOLDER_LIST_URL;
HttpWebRequestHelper.SendHttpPostRequest(cookie, url, null,
response =>
{
var result = HttpWebRequestHelper.GetTextFromResponse(response);
_logger.InfoFormat("Request URL:{0}, StatusCode:{1}", url, response.StatusCode);
_logger.InfoFormat("Result:{0}", result);
var jsonValue = JsonObject.Parse(result);
var taskFolders = new List<TaskFolder>();
var obj = jsonValue as JsonObject;
foreach (var pair in obj)
{
if (Utils.IsNumber(pair.Key))
{
var taskFolder = new TaskFolder();
taskFolder.ID = Utils.ConvertType<int>(pair.Key);
taskFolder.Name = pair.Value;
taskFolders.Add(taskFolder);
SaveTaskFolder(taskFolder);
}
else
{
_logger.InfoFormat("Fetched TaskFolder:{0}", pair.Key);
}
}
RunOnUiThread(() =>
{
var folders = _taskFolderService.GetAllTaskFolders();
_listView.Adapter = new TaskFolderAdapter(this, Resource.Layout.TaskFolderListItem, folders.ToArray());
});
});
}
/// <summary>
/// 将一个任务表保存或更新到本地Sqlite数据库
/// </summary>
/// <param name="taskFolder"></param>
private void SaveTaskFolder(TaskFolder taskFolder)
{
var folder = _taskFolderService.GetTaskFolder(taskFolder.ID);
if (folder == null)
{
_taskFolderService.Create(taskFolder);
}
else
{
_taskFolderService.Update(taskFolder);
}
}
