public static bool UpdateGoal(Goal goal) { bool returnValue = false; List<IBaseQueryData> queryDatum = new List<IBaseQueryData>(); IBaseQueryData queryData = new UpdateQueryData(); queryData.TableName = "PLN_Goals"; queryData.Fields.Add(new FieldData { FieldName = "GoalID", FieldType = SqlDbType.Int, FieldValue = goal.GoalID.ToString() }); queryData.Fields.Add(new FieldData { FieldName = "UserId", FieldType = SqlDbType.Int, FieldValue = goal.ForUser.UserID.ToString() }); queryData.Fields.Add(new FieldData { FieldName = "IsCompleted", FieldType = SqlDbType.Bit, FieldValue = goal.IsCompleted ? "1" : "0" }); queryData.Fields.Add(new FieldData { FieldName = "GoalSubject", FieldType = SqlDbType.NVarChar, FieldValue = goal.GoalSubject.Trim() }); queryData.Fields.Add(new FieldData { FieldName = "GoalReason", FieldType = SqlDbType.NVarChar, FieldValue = goal.GoalReason.Trim() }); queryData.Fields.Add(new FieldData { FieldName = "GoalNotes", FieldType = SqlDbType.NVarChar, FieldValue = goal.GoalNotes.Trim() }); queryData.Fields.Add(new FieldData { FieldName = "DueOn", FieldType = SqlDbType.Date, FieldValue = goal.DueOn.ToString(Constants.DATE_FORMAT_SQL) }); if (goal.Sequence <= 0) { goal.Sequence = GetGoalsForUser(goal.ForUser.UserID, null).Count + 1; } queryData.Fields.Add(new FieldData { FieldName = "Sequence", FieldType = SqlDbType.Int, FieldValue = goal.Sequence.ToString() }); queryData.KeyFields.Add(new FieldData { FieldName = "GoalID", FieldType = SqlDbType.Int, FieldValue = goal.GoalID.ToString() }); queryDatum.Add(queryData); queryData = new DeleteQueryData(); queryData.TableName = "PLN_GoalCategories"; queryData.KeyFields.Add(new FieldData { FieldName = "GoalID", FieldType = SqlDbType.Int, FieldValue = goal.GoalID.ToString() }); queryDatum.Add(queryData); for (int i = 0; i <= goal.Categories.Count - 1; i++) { queryData = new InsertQueryData(); queryData.TableName = "PLN_GoalCategories"; queryData.Fields.Add(new FieldData { FieldName = "GoalID", FieldType = SqlDbType.Int, FieldValue = goal.GoalID.ToString() }); queryData.Fields.Add(new FieldData { FieldName = "CategoryID", FieldType = SqlDbType.Int, FieldValue = goal.Categories[i].CategoryID.ToString() }); queryData.Fields.Add(new FieldData { FieldName = "Sequence", FieldType = SqlDbType.Int, FieldValue = (i + 1).ToString() }); queryDatum.Add(queryData); } returnValue = SQLWrapper.ExecuteQuery(queryDatum); return returnValue; }
public static bool SetGoalAsCompleted(int goalID) { bool returnValue = false; IBaseQueryData queryData = new UpdateQueryData(); queryData.TableName = "PLN_Goals"; queryData.Fields.Add(new FieldData { FieldName = "IsCompleted", FieldType = SqlDbType.Bit, FieldValue = "1" }); queryData.KeyFields.Add(new FieldData { FieldName = "GoalID", FieldType = SqlDbType.Int, FieldValue = goalID.ToString() }); returnValue = SQLWrapper.ExecuteQuery(queryData); if (returnValue) { Goal goal = GetGoalByID(goalID); for (int i = 0; i <= goal.Steps.Count - 1; i++) { goal.Steps[i].taskInfo.Status = TaskStatuses.Completed; DALGoalStep.UpdateGoalStep(goalID, goal.Steps[i]); } } return returnValue; }
public static bool SetGoalDueDate(int goalID) { bool returnValue = false; DateTime goalDueDate = DALGoalStep.GetGoalDueDate(goalID); IBaseQueryData queryData = new UpdateQueryData(); queryData.TableName = "PLN_Goals"; queryData.Fields.Add(new FieldData { FieldName = "DueOn", FieldType = SqlDbType.Date, FieldValue = goalDueDate.ToString(Constants.DATE_FORMAT_SQL) }); queryData.KeyFields.Add(new FieldData { FieldName = "GoalID", FieldType = SqlDbType.Int, FieldValue = goalID.ToString() }); returnValue = SQLWrapper.ExecuteQuery(queryData); return returnValue; }
public static bool UpdateBigRock(BigRock bigRock) { bool returnValue = false; List<IBaseQueryData> queryDatum = new List<IBaseQueryData>(); IBaseQueryData queryData = new UpdateQueryData(); queryData.TableName = "PLN_BigRocks"; queryData.Fields.Add(new FieldData { FieldName = "CompassRoleID", FieldType = SqlDbType.Int, FieldValue = bigRock.AsCompassRole.CompassRoleID.ToString() }); queryData.Fields.Add(new FieldData { FieldName = "UserId", FieldType = SqlDbType.Int, FieldValue = bigRock.ForUser.UserID.ToString() }); queryData.Fields.Add(new FieldData { FieldName = "ForWeek", FieldType = SqlDbType.Date, FieldValue = bigRock.ForWeek.ToString(Constants.DATE_FORMAT_SQL) }); queryData.Fields.Add(new FieldData { FieldName = "BigRockName", FieldType = SqlDbType.NVarChar, FieldValue = bigRock.BigRockName.Trim() }); queryData.Fields.Add(new FieldData { FieldName = "Sequence", FieldType = SqlDbType.Int, FieldValue = getNextSequenceID(bigRock.ForUser.UserID).ToString() }); queryData.KeyFields.Add(new FieldData { FieldName = "BigRockID", FieldType = SqlDbType.Decimal, FieldValue = bigRock.BigRockID.ToString() }); queryDatum.Add(queryData); returnValue = SQLWrapper.ExecuteQuery(queryDatum); return returnValue; }
public static bool UpdateGoalStep(int goalID, GoalStep goalStep) { bool returnValue = false; List<IBaseQueryData> queryDatum = new List<IBaseQueryData>(); IBaseQueryData queryData = new UpdateQueryData(); queryData = new UpdateQueryData(); queryData.TableName = "TSK_Tasks"; queryData.Fields.Add(new FieldData { FieldName = "UserId", FieldType = SqlDbType.Int, FieldValue = goalStep.taskInfo.ForUser.UserID.ToString() }); queryData.Fields.Add(new FieldData { FieldName = "IsMasterTask", FieldType = SqlDbType.Bit, FieldValue = goalStep.taskInfo.IsMasterTask ? "1" : "0" }); queryData.Fields.Add(new FieldData { FieldName = "IsGoalStep", FieldType = SqlDbType.Bit, FieldValue = "1" }); queryData.Fields.Add(new FieldData { FieldName = "IsRecurring", FieldType = SqlDbType.Bit, FieldValue = goalStep.taskInfo.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 = goalStep.taskInfo.TaskName.Trim() }); queryData.Fields.Add(new FieldData { FieldName = "TaskNotes", FieldType = SqlDbType.NVarChar, FieldValue = goalStep.taskInfo.TaskNotes.Trim() }); queryData.Fields.Add(new FieldData { FieldName = "TaskDate", FieldType = SqlDbType.Date, FieldValue = goalStep.taskInfo.TaskDate.ToString(Constants.DATE_FORMAT_SQL) }); queryData.Fields.Add(new FieldData { FieldName = "TaskPriorityID", FieldType = SqlDbType.Int, FieldValue = ((int)goalStep.taskInfo.Priority).ToString() }); queryData.Fields.Add(new FieldData { FieldName = "TaskStatusID", FieldType = SqlDbType.Int, FieldValue = ((int)goalStep.taskInfo.Status).ToString() }); queryData.KeyFields.Add(new FieldData { FieldName = "TaskID", FieldType = SqlDbType.Int, FieldValue = goalStep.taskInfo.TaskID.ToString() }); queryDatum.Add(queryData); queryData = new DeleteQueryData(); queryData.TableName = "TSK_TaskCategories"; queryData.KeyFields.Add(new FieldData { FieldName = "TaskID", FieldType = SqlDbType.Int, FieldValue = goalStep.taskInfo.TaskID.ToString() }); queryDatum.Add(queryData); for (int j = 0; j <= goalStep.taskInfo.Categories.Count - 1; j++) { queryData = new InsertQueryData(); queryData.TableName = "TSK_TaskCategories"; queryData.Fields.Add(new FieldData { FieldName = "TaskID", FieldType = SqlDbType.Int, FieldValue = goalStep.taskInfo.TaskID.ToString() }); queryData.Fields.Add(new FieldData { FieldName = "CategoryID", FieldType = SqlDbType.Int, FieldValue = goalStep.taskInfo.Categories[j].CategoryID.ToString() }); queryData.Fields.Add(new FieldData { FieldName = "Sequence", FieldType = SqlDbType.Int, FieldValue = (j + 1).ToString() }); queryDatum.Add(queryData); } queryData = new UpdateQueryData(); queryData.TableName = "PLN_GoalSteps"; queryData.Fields.Add(new FieldData { FieldName = "GoalID", FieldType = SqlDbType.Int, FieldValue = goalID.ToString() }); queryData.Fields.Add(new FieldData { FieldName = "TaskID", FieldType = SqlDbType.Decimal, FieldValue = goalStep.taskInfo.TaskID.ToString() }); queryData.Fields.Add(new FieldData { FieldName = "Sequence", FieldType = SqlDbType.Int, FieldValue = goalStep.Sequence.ToString() }); queryData.KeyFields.Add(new FieldData { FieldName = "GoalStepID", FieldType = SqlDbType.Int, FieldValue = goalStep.GoalStepID.ToString() }); queryDatum.Add(queryData); SQLWrapper.ExecuteQuery(queryDatum); DALGoal.SetGoalDueDate(goalID); return returnValue; }
public static bool UpdateDailyNote(DailyNote dailyNote) { bool returnValue = false; List<IBaseQueryData> queryDatum = new List<IBaseQueryData>(); IBaseQueryData queryData = new UpdateQueryData(); queryData.TableName = "CMN_DailyNotes"; queryData.Fields.Add(new FieldData { FieldName = "DailyNote", FieldType = SqlDbType.NVarChar, FieldValue = dailyNote.Notes.Trim() }); queryData.KeyFields.Add(new FieldData { FieldName = "ForDate", FieldType = SqlDbType.Date, FieldValue = dailyNote.ForDate.ToString(Constants.DATE_FORMAT_SQL) }); queryData.KeyFields.Add(new FieldData { FieldName = "UserId", FieldType = SqlDbType.Int, FieldValue = dailyNote.ForUser.UserID.ToString() }); queryDatum.Add(queryData); returnValue = SQLWrapper.ExecuteQuery(queryDatum); return returnValue; }
public static bool UpdateValue(Value value) { bool returnValue = false; List<IBaseQueryData> queryDatum = new List<IBaseQueryData>(); IBaseQueryData queryData = new UpdateQueryData(); queryData.TableName = "PLN_Values"; queryData.Fields.Add(new FieldData { FieldName = "ValueTitle", FieldType = SqlDbType.NVarChar, FieldValue = value.ValueTitle.Trim() }); queryData.Fields.Add(new FieldData { FieldName = "ValueNotes", FieldType = SqlDbType.NVarChar, FieldValue = value.ValueNotes.Trim() }); queryData.Fields.Add(new FieldData { FieldName = "UserId", FieldType = SqlDbType.Int, FieldValue = value.ForUser.UserID.ToString() }); queryData.Fields.Add(new FieldData { FieldName = "Sequence", FieldType = SqlDbType.Int, FieldValue = ((int)value.Sequence).ToString() }); queryData.KeyFields.Add(new FieldData { FieldName = "ValueID", FieldType = SqlDbType.Int, FieldValue = value.ValueID.ToString() }); queryDatum.Add(queryData); queryData = new DeleteQueryData(); queryData.TableName = "PLN_ValueCategories"; queryData.KeyFields.Add(new FieldData { FieldName = "ValueID", FieldType = SqlDbType.Int, FieldValue = value.ValueID.ToString() }); queryDatum.Add(queryData); if (value.Categories != null) { for (int i = 0; i <= value.Categories.Count - 1; i++) { queryData = new InsertQueryData(); queryData.TableName = "PLN_ValueCategories"; queryData.Fields.Add(new FieldData { FieldName = "ValueID", FieldType = SqlDbType.Int, FieldValue = value.ValueID.ToString() }); queryData.Fields.Add(new FieldData { FieldName = "CategoryID", FieldType = SqlDbType.Int, FieldValue = value.Categories[i].CategoryID.ToString() }); queryData.Fields.Add(new FieldData { FieldName = "Sequence", FieldType = SqlDbType.Int, FieldValue = (i + 1).ToString() }); queryDatum.Add(queryData); } } returnValue = SQLWrapper.ExecuteQuery(queryDatum); return returnValue; }
public static bool UpdateTaskStatus(long taskID, TaskStatuses withStatus) { bool returnValue = false; List<IBaseQueryData> queryDatum = new List<IBaseQueryData>(); IBaseQueryData queryData = new UpdateQueryData(); queryData.TableName = "TSK_Tasks"; queryData.Fields.Add(new FieldData { FieldName = "TaskStatusID", FieldType = SqlDbType.Int, FieldValue = ((int)withStatus).ToString() }); queryData.KeyFields.Add(new FieldData { FieldName = "TaskID", FieldType = SqlDbType.Int, FieldValue = taskID.ToString() }); queryDatum.Add(queryData); returnValue = SQLWrapper.ExecuteQuery(queryDatum); return returnValue; }
public static bool UpdateTask(Task task) { bool returnValue = false; List<IBaseQueryData> queryDatum = new List<IBaseQueryData>(); IBaseQueryData queryData = new UpdateQueryData(); queryData.TableName = "TSK_Tasks"; 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() }); queryData.KeyFields.Add(new FieldData { FieldName = "TaskID", FieldType = SqlDbType.Int, FieldValue = task.TaskID.ToString() }); queryDatum.Add(queryData); queryData = new DeleteQueryData(); queryData.TableName = "TSK_TaskCategories"; queryData.KeyFields.Add(new FieldData { FieldName = "TaskID", FieldType = SqlDbType.Int, FieldValue = task.TaskID.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 = task.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); } returnValue = SQLWrapper.ExecuteQuery(queryDatum); return returnValue; }
public static bool UpdateCompassRole(CompassRole CompassRole) { bool returnValue = false; List<IBaseQueryData> queryDatum = new List<IBaseQueryData>(); IBaseQueryData queryData = new UpdateQueryData(); queryData.TableName = "PLN_CompassRoles"; queryData.Fields.Add(new FieldData { FieldName = "CompassRoleName", FieldType = SqlDbType.NVarChar, FieldValue = CompassRole.CompassRoleName.Trim() }); queryData.Fields.Add(new FieldData { FieldName = "Notes", FieldType = SqlDbType.NVarChar, FieldValue = CompassRole.Notes.Trim() }); queryData.Fields.Add(new FieldData { FieldName = "UserId", FieldType = SqlDbType.Int, FieldValue = CompassRole.ForUser.UserID.ToString() }); queryData.Fields.Add(new FieldData { FieldName = "Sequence", FieldType = SqlDbType.Int, FieldValue = ((int)CompassRole.Sequence).ToString() }); queryData.KeyFields.Add(new FieldData { FieldName = "CompassRoleID", FieldType = SqlDbType.Int, FieldValue = CompassRole.CompassRoleID.ToString() }); queryDatum.Add(queryData); returnValue = SQLWrapper.ExecuteQuery(queryDatum); return returnValue; }