private Task ToTask(object[] r)
{
var offset = ProjectDao.PROJECT_COLUMNS.Length;
var task = new Task
{
Project = r[0] != null?ProjectDao.ToProject(r) : null,
ID = Convert.ToInt32(r[0 + offset]),
Title = (string)r[1 + offset],
CreateBy = ToGuid(r[2 + offset]),
CreateOn = TenantUtil.DateTimeFromUtc((DateTime)r[3 + offset]),
LastModifiedBy = ToGuid(r[4 + offset]),
LastModifiedOn = TenantUtil.DateTimeFromUtc((DateTime)r[5 + offset]),
Description = (string)r[6 + offset],
Responsible = ToGuid(r[7 + offset]),
Priority = (TaskPriority)Convert.ToInt32(r[8 + offset]),
Status = (TaskStatus)Convert.ToInt32(r[9 + offset]),
Milestone = r[10 + offset] == null ? 0 : Convert.ToInt32(r[10 + offset]),
SortOrder = Convert.ToInt32(r[11 + offset]),
Deadline = r[12 + offset] != null?DateTime.SpecifyKind((DateTime)r[12 + offset], DateTimeKind.Local) : default(DateTime),
Responsibles = !string.IsNullOrEmpty((string)r[13 + offset]) ? new HashSet <Guid>(((string)r[13 + offset]).Split(',').Select(resp => ToGuid(resp))) : new HashSet <Guid>(),
SubTasks = new List <Subtask>()
};
if (!task.Responsible.Equals(Guid.Empty))
{
task.Responsibles.Add(task.Responsible);
}
return(task);
}
private static Task ToTask(object[] r)
{
var offset = ProjectDao.ProjectColumns.Length;
var deadline = Convert.ToDateTime(r[11 + offset]);
var startDate = Convert.ToDateTime(r[12 + offset]);
var task = new Task
{
Project = r[0] != null?ProjectDao.ToProject(r) : null,
ID = Convert.ToInt32(r[0 + offset]),
Title = (string)r[1 + offset],
CreateBy = ToGuid(r[2 + offset]),
CreateOn = TenantUtil.DateTimeFromUtc(Convert.ToDateTime(r[3 + offset])),
LastModifiedBy = ToGuid(r[4 + offset]),
LastModifiedOn = TenantUtil.DateTimeFromUtc(Convert.ToDateTime(r[5 + offset])),
Description = (string)r[6 + offset],
Priority = (TaskPriority)Convert.ToInt32(r[7 + offset]),
Status = (TaskStatus)Convert.ToInt32(r[8 + offset]),
Milestone = r[9 + offset] == null ? 0 : Convert.ToInt32(r[9 + offset]),
SortOrder = Convert.ToInt32(r[10 + offset]),
Deadline = !deadline.Equals(DateTime.MinValue) ? DateTime.SpecifyKind(deadline, DateTimeKind.Local) : default(DateTime),
StartDate = !startDate.Equals(DateTime.MinValue) ? DateTime.SpecifyKind(startDate, DateTimeKind.Local) : default(DateTime),
Progress = Convert.ToInt32(r[13 + offset]),
Responsibles = !string.IsNullOrEmpty((string)r[14 + offset]) ? new List <Guid>(((string)r[14 + offset]).Split(',').Select(ToGuid)) : new List <Guid>(),
SubTasks = new List <Subtask>(),
CustomTaskStatus = r[15 + offset] != null ? (int?)Convert.ToInt32(r[15 + offset]) : null
};
return(task);
}
private Message ToMessage(object[] r)
{
var offset = ProjectDao.PROJECT_COLUMNS.Length;
return(new Message()
{
Project = r[0] != null?ProjectDao.ToProject(r) : null,
ID = Convert.ToInt32(r[0 + offset]),
Title = (string)r[1 + offset],
CreateBy = ToGuid(r[2 + offset]),
CreateOn = TenantUtil.DateTimeFromUtc((DateTime)r[3 + offset]),
LastModifiedBy = ToGuid(r[4 + offset]),
LastModifiedOn = TenantUtil.DateTimeFromUtc((DateTime)r[5 + offset]),
Content = (string)r[6 + offset]
});
}
private Message ToMessage(object[] r)
{
var offset = ProjectDao.ProjectColumns.Length;
return new Message
{
Project = r[0] != null ? ProjectDao.ToProject(r) : null,
ID = Convert.ToInt32(r[0 + offset]),
Title = (string) r[1 + offset],
Status = (MessageStatus)Convert.ToInt32(r[2 + offset]),
CreateBy = ToGuid(r[3 + offset]),
CreateOn = TenantUtil.DateTimeFromUtc(Convert.ToDateTime(r[4 + offset])),
LastModifiedBy = ToGuid(r[5 + offset]),
LastModifiedOn = TenantUtil.DateTimeFromUtc(Convert.ToDateTime(r[6 + offset])),
Content = (string) r[7 + offset]
};
}
private static Milestone ToMilestone(object[] r)
{
var offset = ProjectDao.ProjectColumns.Length;
return(new Milestone
{
Project = r[0] != null?ProjectDao.ToProject(r) : null,
ID = Convert.ToInt32(r[0 + offset]),
Title = (string)r[1 + offset],
CreateBy = ToGuid(r[2 + offset]),
CreateOn = TenantUtil.DateTimeFromUtc(Convert.ToDateTime(r[3 + offset])),
LastModifiedBy = ToGuid(r[4 + offset]),
LastModifiedOn = TenantUtil.DateTimeFromUtc(Convert.ToDateTime(r[5 + offset])),
DeadLine = DateTime.SpecifyKind(Convert.ToDateTime(r[6 + offset]), DateTimeKind.Local),
Status = (MilestoneStatus)Convert.ToInt32(r[7 + offset]),
IsNotify = Convert.ToBoolean(r[8 + offset]),
IsKey = Convert.ToBoolean(r[9 + offset]),
Description = (string)r[10 + offset],
Responsible = ToGuid(r[11 + offset]),
ActiveTaskCount = Convert.ToInt32(r[12 + ProjectDao.ProjectColumns.Length]),
ClosedTaskCount = Convert.ToInt32(r[13 + ProjectDao.ProjectColumns.Length])
});
}
