public TaskLogEntry(int taskLogID, DateTime dtTaskDate, string sUserID, Task task, TaskStatuses taskStatus)
{
_iTaskLogID = taskLogID;
_dtTaskDate = dtTaskDate;
_sUserID = sUserID;
_task = task;
_taskStatus = taskStatus;
}
public long CreateTaskAction(TaskStatuses taskStatuses, string taskTemplateTitle,
long taskTemplateFolderId, string jsonParameters, TaskTypes taskTypes)
{
using (var connection = new NpgsqlConnection(_connection))
{
return(KarmaDownloaderFunctions.InsertTask(connection, taskTemplateTitle, taskTemplateFolderId,
jsonParameters, (long)taskTypes, (long)taskStatuses));
}
}
public AddTaskViewModel(Calendar calendar)
{
TaskStatuses.AddRange(calendar.TaskStatuses);
TaskTypes.AddRange(calendar.TaskTypes);
Model.CalendarId = calendar.Id;
Model.PlannedStart = DateTime.Now;
Model.PlannedEnd = DateTime.Now;
Ok = ReactiveCommand.CreateFromObservable(() => CloseWindowInteraction.CloseWindow.Handle(true));
Cancel = ReactiveCommand.CreateFromObservable(() => CloseWindowInteraction.CloseWindow.Handle(false));
}
public BaseTask(double estimation, TaskTypes type, string title, string description, User taskOwner, User taskCreator, TaskStatuses status = TaskStatuses.Backlog)
{
Estimation = estimation;
Title = title;
Description = description;
Id = Guid.NewGuid().ToString();
this.taskCreator = taskCreator;
_creationDate = DateTime.Now;
UpdatedDate = DateTime.Now;
Status = status;
TaskOwner = taskOwner;
}
public TaskBLL(int id, int? parentGroupId, TaskInfo tInfo, TaskStatuses status,
DateTime? resolveTime, TimedTaskSettingsInfo timingInfo)
: base(id, parentGroupId, tInfo, resolveTime)
{
Status = status;
Details = tInfo.Details;
if (timingInfo != null)
{
TimingInfo = new TimedTaskSettingsInfo();
TimingInfo.DueTime = timingInfo.DueTime;
TimingInfo.TimeoutAction = timingInfo.TimeoutAction;
}
}
public ObservableCollection <TaskStatus> GetTranslatedTaskStatuses(string[] translations)
{
try
{
if (
(TaskStatuses.First().ToString() != translations[TaskStatuses.First().ID].ToString()) &&
(translations != null || translations.Length > TaskStatuses.Count)
)
{
foreach (var item in TaskStatuses)
{
item.Description = translations[item.ID];
}
}
return(TaskStatuses);
}
catch (Exception ex)
{
throw new Exception("Lists_Failed_Get_TaskStatuses : " + ex.Message, ex);
}
}
public static bool ForwardTask(long taskID, DateTime toDate, TaskStatuses currentTaskStatus = TaskStatuses.Forwarded, string taskNotes="")
{
bool returnValue = false;
Task task = DALTask.GetTaskByID(taskID);
task.Status = TaskStatuses.Normal;
task.StatusText = task.Status.ToString();
task.TaskDate = toDate;
task.TaskNotes = taskNotes;
long newTaskID = DALTask.AddTask(task);
if (newTaskID > 0)
{
returnValue = true;
if (currentTaskStatus == TaskStatuses.Deleted)
{
returnValue = DALTask.DeleteTask(taskID);
}
else
{
returnValue = DALTask.UpdateTaskStatus(taskID, currentTaskStatus);
}
}
return returnValue;
}
public static bool UpdateTaskStatus(long taskID, TaskStatuses withStatus)
{
return DALTask.UpdateTaskStatus(taskID, withStatus);
}
public TaskVM(int id, TaskInfo taskInfo, TaskStatuses status, DateTime? resolveTime, GroupVM parentGroup = null)
: base(id, taskInfo, resolveTime, parentGroup)
{
Details = taskInfo.Details;
Status = status;
}
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;
}
