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