public static bool AddValue(Value value)
{
bool returnValue = false;
int ValueID = getNextValueID();
List<IBaseQueryData> queryDatum = new List<IBaseQueryData>();
IBaseQueryData queryData = new InsertQueryData();
queryData.TableName = "PLN_Values";
queryData.Fields.Add(new FieldData { FieldName = "ValueID", FieldType = SqlDbType.Int, FieldValue = ValueID.ToString() });
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 = getNextSequenceID(value.ForUser.UserID).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 = 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 AddGoalStep(int goalID, GoalStep goalStep)
{
bool returnValue = false;
List<IBaseQueryData> queryDatum = new List<IBaseQueryData>();
IBaseQueryData queryData = new InsertQueryData();
long taskID = DALTask.getNextTaskID();
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 = 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() });
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 = 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 InsertQueryData();
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 = taskID.ToString() });
queryData.Fields.Add(new FieldData { FieldName = "Sequence", FieldType = SqlDbType.Int, FieldValue = getNextSequence(goalID).ToString() });
queryDatum.Add(queryData);
SQLWrapper.ExecuteQuery(queryDatum);
DALGoal.SetGoalDueDate(goalID);
return returnValue;
}
public static bool AddDailyNote(DailyNote dailyNote)
{
bool returnValue = false;
int dailyNoteID = getNextDailyNoteID();
List<IBaseQueryData> queryDatum = new List<IBaseQueryData>();
IBaseQueryData queryData = new InsertQueryData();
queryData.TableName = "CMN_DailyNotes";
queryData.Fields.Add(new FieldData { FieldName = "DailyNoteID", FieldType = SqlDbType.Int, FieldValue = dailyNoteID.ToString() });
queryData.Fields.Add(new FieldData { FieldName = "DailyNote", FieldType = SqlDbType.NVarChar, FieldValue = dailyNote.Notes.Trim() });
queryData.Fields.Add(new FieldData { FieldName = "ForDate", FieldType = SqlDbType.Date, FieldValue = dailyNote.ForDate.ToString(Constants.DATE_FORMAT_SQL) });
queryData.Fields.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 AddBigRock(BigRock bigRock)
{
bool returnValue = false;
long BigRockID = getNextBigRockID();
List<IBaseQueryData> queryDatum = new List<IBaseQueryData>();
IBaseQueryData queryData = new InsertQueryData();
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() });
queryDatum.Add(queryData);
returnValue = SQLWrapper.ExecuteQuery(queryDatum);
return returnValue;
}
public static bool AddCompassRole(CompassRole CompassRole)
{
bool returnValue = false;
int CompassRoleID = getNextCompassRoleID();
List<IBaseQueryData> queryDatum = new List<IBaseQueryData>();
IBaseQueryData queryData = new InsertQueryData();
queryData.TableName = "PLN_CompassRoles";
queryData.Fields.Add(new FieldData { FieldName = "CompassRoleID", FieldType = SqlDbType.Int, FieldValue = CompassRoleID.ToString() });
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 = getNextSequenceID(CompassRole.ForUser.UserID).ToString() });
queryDatum.Add(queryData);
returnValue = SQLWrapper.ExecuteQuery(queryDatum);
return returnValue;
}
public static bool AddGoal(Goal goal)
{
bool returnValue = false;
int goalID = getNextGoalID();
List<IBaseQueryData> queryDatum = new List<IBaseQueryData>();
IBaseQueryData queryData = new InsertQueryData();
queryData.TableName = "PLN_Goals";
queryData.Fields.Add(new FieldData { FieldName = "GoalID", FieldType = SqlDbType.Int, FieldValue = 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() });
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 = 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 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 UpdateMission(Mission mission)
{
bool returnValue = false;
List<IBaseQueryData> queryDatum = new List<IBaseQueryData>();
IBaseQueryData queryData = new UpdateQueryData();
queryData.TableName = "PLN_Missions";
queryData.Fields.Add(new FieldData { FieldName = "MissionTitle", FieldType = SqlDbType.NVarChar, FieldValue = mission.MissionTitle.Trim() });
queryData.Fields.Add(new FieldData { FieldName = "MissionNotes", FieldType = SqlDbType.NVarChar, FieldValue = mission.MissionNotes.Trim() });
queryData.Fields.Add(new FieldData { FieldName = "UserId", FieldType = SqlDbType.Int, FieldValue = mission.ForUser.UserID.ToString() });
queryData.Fields.Add(new FieldData { FieldName = "Sequence", FieldType = SqlDbType.Int, FieldValue = ((int)mission.Sequence).ToString() });
queryData.KeyFields.Add(new FieldData { FieldName = "MissionID", FieldType = SqlDbType.Int, FieldValue = mission.MissionID.ToString() });
queryDatum.Add(queryData);
queryData = new DeleteQueryData();
queryData.TableName = "PLN_MissionCategories";
queryData.KeyFields.Add(new FieldData { FieldName = "MissionID", FieldType = SqlDbType.Int, FieldValue = mission.MissionID.ToString() });
queryDatum.Add(queryData);
if (mission.Categories != null)
{
for (int i = 0; i <= mission.Categories.Count - 1; i++)
{
queryData = new InsertQueryData();
queryData.TableName = "PLN_MissionCategories";
queryData.Fields.Add(new FieldData { FieldName = "MissionID", FieldType = SqlDbType.Int, FieldValue = mission.MissionID.ToString() });
queryData.Fields.Add(new FieldData { FieldName = "CategoryID", FieldType = SqlDbType.Int, FieldValue = mission.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;
}
