public async Task <List <WM_TaskUser> > GetUserTasksByTaskId(string taskid)
{
var query = new StringBuilder();
query.AppendLine("{");
query.AppendLine("'TaskId': { '$eq': '" + taskid + "' }");
query.AppendLine("}");
return(await _WM_TaskUserRepository.GetManyToList(MongoHelper.ConvertQueryStringToDocument(query.ToString())));
}
private async Task <List <WM_TaskUser> > GetTaskUserByUserId(string userid)
{
var query = new StringBuilder();
query.AppendLine("{");
query.AppendLine("'UserId': { '$eq': '" + userid + "' }");
query.AppendLine(", 'IsCompleted': false");
query.AppendLine("}");
return(await _WM_TaskUserRepository.GetManyToList(MongoHelper.ConvertQueryStringToDocument(query.ToString())));
}
private async Task <List <WM_TaskUser> > DataTask_ByUser_ByTime(string userid, DateTime fromdate, DateTime todate)
{
var query = new StringBuilder();
query.AppendLine("{");
query.AppendLine("'UserId': { '$eq' : '" + userid + "' }");
query.AppendLine(", 'DateCreated': {");
query.AppendLine(" '$gte': ISODate('" + fromdate.ToString("yyyy-MM-dd") + "T00:00:00.000+07:00') ");
query.AppendLine(", '$lt': ISODate('" + todate.AddDays(1).ToString("yyyy-MM-dd") + "T00:00:00.000+07:00') ");
query.AppendLine("}");
query.AppendLine("}");
return(await _WM_TaskUserRepository.GetManyToList(MongoHelper.ConvertQueryStringToDocument(query.ToString())));
}
private async Task <List <string> > GetUserTaskInvolved(string taskid)
{
var list = new List <string>();
var query = new StringBuilder();
query.AppendLine("{");
query.AppendLine("'TaskId': { '$eq': '" + taskid + "' }");
query.AppendLine("}");
var k = await _WM_TaskUserRepository.GetManyToList(MongoHelper.ConvertQueryStringToDocument(query.ToString()));
var users = k.Select(n => n.UserId).Distinct().ToList();
foreach (var item in users)
{
list.Add(item);
}
return(list);
}
