public async Task <ActionResult <ResponsUserByBraSec> > ResponsToken([FromBody] RequestBranchSection request)
{
try
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var ResponsUsersBS = await _UserService.GetUserByBranSec(request);
return(Ok(ResponsUsersBS.Items));
}
catch (System.Exception ex)
{
return(BadRequest(ex.Message));
}
}
public async Task <QueryResult <ResponsUserByBraSec> > GetUserByBranSec(RequestBranchSection request)
{
var result = new QueryResult <ResponsUserByBraSec>();
try
{
//demografico de sede
var DemoSede = await this._objConf.GetConfig("DemograficoSede");
//Se obtienen los usuarios por sede y areas
var usersRespons = (from a in this._context.AuthUser
join b in this._context.uDIt on a.id equals b.idUser
join c in this._context.DemoIt on b.idDemograficoItem equals c.id
join d in this._context.UsSection on a.id equals d.idUser
join e in this._context.section on d.idSection equals e.id
where c.idDemografico == Convert.ToInt16(DemoSede.Items.ElementAt(0).value) && c.id == request.idbranch && request.areas.Contains(e.id) &&
(from j in this._context.UsSection where j.idUser == a.id && request.areas.Contains(j.idSection) select j).Count() == request.areas.Count()
select new ResponsUserByBraSec
{
id = a.id,
name = a.name,
lastName = a.lastName,
userName = a.userName,
state = a.estado == 1 ? true : false
}
);
result.Items = await usersRespons.Distinct().ToListAsync();
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
//Se retorna la lista
return(result);
}
public async Task <QueryResult <ResponsUserByBraSec> > GetUserByBranSec(RequestBranchSection request)
{
var obj = await this._UssRepo.GetUserByBranSec(request);
return(obj);
}
