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); }