public IEnumerable <SelectListItem> Coordenadores(params object[] param)
{
// params[0] -> cabeçalho (Selecione..., Todos...)
// params[1] -> SelectedValue
string cabecalho = param[0].ToString();
string selectedValue = param[1].ToString();
EmpresaSecurity <SecurityContext> security = new EmpresaSecurity <SecurityContext>();
Sessao s = security.getSessaoCorrente();
IEnumerable <App_Dominio.Repositories.UsuarioRepository> Usuarios = security.getUsuarios((int)Sistema.DWMIMOVEL, s.empresaId, "Coordenador");
IList <SelectListItem> q = new List <SelectListItem>();
if (cabecalho != "")
{
q.Add(new SelectListItem()
{
Value = "", Text = cabecalho
});
}
q = q.Union(from e in Usuarios.AsEnumerable()
orderby e.nome
select new SelectListItem()
{
Value = e.usuarioId.ToString(),
Text = e.nome,
Selected = (selectedValue != "" ? e.nome.Equals(selectedValue) : false)
}).ToList();
return(q);
}
public override IEnumerable <AreaAtendimentoViewModel> Bind(int?index, int pageSize = 50, params object[] param)
{
EmpresaSecurity <SecurityContext> security = new EmpresaSecurity <SecurityContext>();
IEnumerable <UsuarioRepository> q = security.getUsuarios((int)DWM.Models.Enumeracoes.Sistema.SINDMED, security.getSessaoCorrente().empresaId);
string _descricao = param != null && param.Count() > 0 && param[0] != null ? param[0].ToString() : null;
IEnumerable <AreaAtendimentoViewModel> query = (from are in db.AreaAtendimentos
where (_descricao == null || String.IsNullOrEmpty(_descricao) || are.descricao.StartsWith(_descricao.Trim()))
orderby are.descricao
select new AreaAtendimentoViewModel
{
areaAtendimentoId = are.areaAtendimentoId,
descricao = are.descricao,
codigo = are.codigo,
usuario1Id = are.usuario1Id,
usuario2Id = are.usuario2Id,
PageSize = pageSize,
TotalCount = (from are1 in db.AreaAtendimentos
where (_descricao == null || String.IsNullOrEmpty(_descricao) || are1.descricao.StartsWith(_descricao.Trim()))
select are1).Count()
}).Skip((index ?? 0) * pageSize).Take(pageSize).ToList();
return((from are in query
select new AreaAtendimentoViewModel
{
areaAtendimentoId = are.areaAtendimentoId,
descricao = are.descricao,
codigo = are.codigo,
usuario1Id = are.usuario1Id,
nome_usuario1 = are.usuario1Id.HasValue ? (from usu1 in q where usu1.usuarioId == are.usuario1Id select usu1.nome).FirstOrDefault() : "",
usuario2Id = are.usuario2Id,
nome_usuario2 = are.usuario2Id.HasValue ? (from usu2 in q where usu2.usuarioId == are.usuario2Id select usu2.nome).FirstOrDefault() : "",
PageSize = are.PageSize,
TotalCount = are.TotalCount
}).ToList());
}
