public void GetCategory()
{
DtCategory = ConnectBase.Select("SELECT * FROM " + ConnectBase.categoryBase);
for (int i = 0; i < DtCategory.Rows.Count; i++)
{
var NewCategory = new TaskModel()
{
ID = (int)DtCategory.Rows[i]["ID"], CategoryName = DtCategory.Rows[i]["CategoryName"].ToString(), CanDeleted = (bool)DtCategory.Rows[i]["CanDeleted"], CreateTime = (DateTime)DtCategory.Rows[i]["CreateTime"]
};
TaskTabItems.Add(NewCategory);
}
}
public void GetTasks()
{
DtTasks = ConnectBase.Select("SELECT * FROM " + ConnectBase.tasksBase);
//int index, indexC;
for (int i = 0; i < DtTasks.Rows.Count; i++)
{
var cIndex = TaskTabItems.Select((v, index) => new { Index = index, Value = v.ID }) // Pair up values and indexes
.Where(p => p.Value == (int)DtTasks.Rows[i]["Caregory_ID"]) // Do the filtering
.Select(p => p.Index).First(); // Keep the index and drop the value
var NewTask = new TaskModel()
{
ID = (int)DtTasks.Rows[i]["ID"], TaskName = DtTasks.Rows[i]["TaskName"].ToString(), TaskBody = DtTasks.Rows[i]["TaskBody"].ToString(),
Priority = DtTasks.Rows[i]["Priority"].ToString(), CreateTime = (DateTime)DtTasks.Rows[i]["CreateTime"], IsFavorite = (bool)DtTasks.Rows[i]["IsFavorite"],
IsReminder = (bool)DtTasks.Rows[i]["IsReminder"], ReminderTime = DtTasks.Rows[i]["ReminderTime"].ToString() == "" ? DateTime.Now.AddSeconds(-1): (DateTime)DtTasks.Rows[i]["ReminderTime"],
IsActive = (bool)DtTasks.Rows[i]["IsActive"]
}; //, IsFavorite = (bool)DtTasks.Rows[i]["IsFavorite"], IsReminder = (bool)DtTasks.Rows[i]["IsReminder"], IsActive = (bool)DtTasks.Rows[i]["IsActive"] // ReminderTime = (DateTime)DtTasks.Rows[i]["ReminderTime"],
TaskTabItems[cIndex].Task.Add(NewTask);
}
}
