public static long AddTask(Task task)
{
long taskID = getNextTaskID();
List<IBaseQueryData> queryDatum = new List<IBaseQueryData>();
IBaseQueryData queryData = new InsertQueryData();
queryData.TableName = "TSK_Tasks";
queryData.Fields.Add(new FieldData { FieldName = "TaskID", FieldType = SqlDbType.Int, FieldValue = taskID.ToString() });
queryData.Fields.Add(new FieldData { FieldName = "UserId", FieldType = SqlDbType.Int, FieldValue = task.ForUser.UserID.ToString() });
queryData.Fields.Add(new FieldData { FieldName = "IsMasterTask", FieldType = SqlDbType.Bit, FieldValue = task.IsMasterTask ? "1" : "0" });
queryData.Fields.Add(new FieldData { FieldName = "IsGoalStep", FieldType = SqlDbType.Bit, FieldValue = task.IsGoalStep ? "1" : "0" });
queryData.Fields.Add(new FieldData { FieldName = "IsRecurring", FieldType = SqlDbType.Bit, FieldValue = task.IsRecurring ? "1" : "0" });
queryData.Fields.Add(new FieldData { FieldName = "ScheduleID", FieldType = SqlDbType.Int, FieldValue = "0" });
queryData.Fields.Add(new FieldData { FieldName = "TaskName", FieldType = SqlDbType.NVarChar, FieldValue = task.TaskName.Trim() });
queryData.Fields.Add(new FieldData { FieldName = "TaskNotes", FieldType = SqlDbType.NVarChar, FieldValue = task.TaskNotes.Trim() });
queryData.Fields.Add(new FieldData { FieldName = "TaskDate", FieldType = SqlDbType.Date, FieldValue = task.TaskDate.ToString(Constants.DATE_FORMAT_SQL) });
queryData.Fields.Add(new FieldData { FieldName = "TaskPriorityID", FieldType = SqlDbType.Int, FieldValue = ((int)task.Priority).ToString() });
queryData.Fields.Add(new FieldData { FieldName = "TaskStatusID", FieldType = SqlDbType.Int, FieldValue = ((int)task.Status).ToString() });
queryDatum.Add(queryData);
for (int i = 0; i <= task.Categories.Count - 1; i++)
{
queryData = new InsertQueryData();
queryData.TableName = "TSK_TaskCategories";
queryData.Fields.Add(new FieldData { FieldName = "TaskID", FieldType = SqlDbType.Int, FieldValue = taskID.ToString() });
queryData.Fields.Add(new FieldData { FieldName = "CategoryID", FieldType = SqlDbType.Int, FieldValue = task.Categories[i].CategoryID.ToString() });
queryData.Fields.Add(new FieldData { FieldName = "Sequence", FieldType = SqlDbType.Int, FieldValue = (i + 1).ToString() });
queryDatum.Add(queryData);
}
SQLWrapper.ExecuteQuery(queryDatum);
return taskID;
}
public static bool UpdateTask(Task task)
{
return MyPlanner.DAL.DALTask.UpdateTask(task);
}
public static long AddTask(Task task)
{
return MyPlanner.DAL.DALTask.AddTask(task);
}
public static bool DeleteTask(Task task)
{
return SQLWrapper.ExecuteQuery(PrepareDeleteTaskQueries(task));
}
private static Task loadTask(DataTable dtTasks, int RowNo)
{
Task task = new Task();
task.TaskID = Convert.ToInt32(dtTasks.Rows[RowNo]["TaskID"]);
task.ForUser = DALAppUser.GetUserByID( Convert.ToInt32(dtTasks.Rows[RowNo]["UserID"]));
task.TaskName = dtTasks.Rows[RowNo]["TaskName"].ToString();
task.TaskNotes = dtTasks.Rows[RowNo]["TaskNotes"].ToString();
task.TaskDate = Convert.ToDateTime(dtTasks.Rows[RowNo]["TaskDate"]);
task.Priority = (TaskPriorities)Convert.ToInt32(dtTasks.Rows[RowNo]["TaskPriorityID"]);
task.PriorityText = task.Priority.ToString();
task.PriorityID = Convert.ToInt32(dtTasks.Rows[RowNo]["TaskPriorityID"]);
task.Status = (TaskStatuses)Convert.ToInt32(dtTasks.Rows[RowNo]["TaskStatusID"]);
task.StatusID = Convert.ToInt32(dtTasks.Rows[RowNo]["TaskStatusID"]);
task.StatusText = task.Status.ToString();
task.Categories = DALCategory.GetCategoriesByTaskID(task.TaskID);
return task;
}
public static List<IBaseQueryData> PrepareDeleteTaskQueries(Task task)
{
List<IBaseQueryData> queryDatum = new List<IBaseQueryData>();
DeleteQueryData queryData = new DeleteQueryData();
queryData.TableName = "TSK_TaskCategories";
queryData.KeyFields.Add(new FieldData { FieldName = "TaskID", FieldType = SqlDbType.Int, FieldValue = task.TaskID.ToString() });
queryDatum.Add(queryData);
queryData = new DeleteQueryData();
queryData.TableName = "TSK_Tasks";
queryData.KeyFields.Add(new FieldData { FieldName = "TaskID", FieldType = SqlDbType.Int, FieldValue = task.TaskID.ToString() });
queryDatum.Add(queryData);
return queryDatum;
}
