public async Task <APIResult> Post([FromBody] LAFAgentQuery lafAgentQuery) { IEnumerable <MyUser> fooList; if (string.IsNullOrEmpty(lafAgentQuery.DepartmentName)) { if (string.IsNullOrEmpty(lafAgentQuery.Name)) { await db.LOBMyUsers.ToListAsync(); fooList = (await db.LOBMyUsers.ToListAsync()).Select(x => x.ToMyUsers()); } else { fooList = (await(db.LOBMyUsers.Where(x => x.Name.Contains(lafAgentQuery.Name))) .ToListAsync()).Select(x => x.ToMyUsers()); } } else { if (string.IsNullOrEmpty(lafAgentQuery.Name)) { fooList = (await(db.LOBMyUsers.Where(x => x.DepartmentName == lafAgentQuery.DepartmentName)) .ToListAsync()).Select(x => x.ToMyUsers()); } else { fooList = (await(db.LOBMyUsers.Where(x => x.Name.Contains(lafAgentQuery.Name) && x.DepartmentName == lafAgentQuery.DepartmentName)) .ToListAsync()).Select(x => x.ToMyUsers()); } } var fooLAFAgentReslutList = new List <LAFAgentReslut>(); var pp = fooList.ToList(); foreach (var item in fooList) { var fooItem = new LAFAgentReslut() { DepartmentName = item.DepartmentName, MyUserId = item.MyUserId, Name = item.Name, }; fooLAFAgentReslutList.Add(fooItem); } fooResult.Success = true; fooResult.Message = ""; fooResult.TokenFail = false; fooResult.Payload = fooLAFAgentReslutList; return(fooResult); }
public APIResult Post([FromBody] LAFAgentQuery lafAgentQuery) { IQueryable <MyUser> fooList; //if (string.IsNullOrEmpty(lafAgentQuery.DepartmentName)&&string.IsNullOrEmpty(lafAgentQuery.Name)) //{ //} if (string.IsNullOrEmpty(lafAgentQuery.DepartmentName)) { if (string.IsNullOrEmpty(lafAgentQuery.Name)) { fooList = Context.MyUsers; } else { fooList = Context.MyUsers.Where(x => x.Name.Contains(lafAgentQuery.Name)); } } else { if (string.IsNullOrEmpty(lafAgentQuery.Name)) { fooList = Context.MyUsers.Where(x => x.DepartmentName == lafAgentQuery.DepartmentName); } else { fooList = Context.MyUsers.Where(x => x.Name.Contains(lafAgentQuery.Name) && x.DepartmentName == lafAgentQuery.DepartmentName); } } var fooLAFAgentReslutList = new List <LAFAgentReslut>(); var pp = fooList.ToList(); foreach (var item in fooList) { var fooItem = new LAFAgentReslut() { DepartmentName = item.DepartmentName, MyUserId = item.MyUserId, Name = item.Name, }; fooLAFAgentReslutList.Add(fooItem); } fooResult.Success = true; fooResult.Message = ""; fooResult.TokenFail = false; fooResult.Payload = fooLAFAgentReslutList; return(fooResult); }