public void AddExame(OrdemServicoExame exame)
{
if (exame.IsValid)
{
Exames.Add(exame);
}
}
public void Criar(CriarExameModel model)
{
var contador = _context.Exames.Where(a => a.IdAtleta == model.IdAtleta).Count();
var exame = new Exames {
IdAtleta = model.IdAtleta,
IdAuxiliar = model.IdAuxiliar,
IdUsuario = model.IdUsuario,
QuantiFichas = contador + 1
};
_context.Exames.Add(exame);
_context.SaveChanges();
var Exercicios = model.ExameExercicios;
_exerciciosServices.Exercicios(Exercicios, _context.Exames.FirstOrDefault(a => a.IdAtleta == model.IdAtleta && a.QuantiFichas == (contador + 1)).Id);
}
public ActionResult Cadastrar(Exames oExames)
{
if (ModelState.IsValid)
{
try
{
oExames.UsuarioInclusao = CustomAuthorizationProvider.UsuarioAutenticado.Login;
ExamesBusines.Inserir(oExames);
Extensions.GravaCookie("MensagemSucesso", "Exame registrado com sucesso.", 10);
return(Json(new { resultado = new RetornoJSON()
{
URL = Url.Action("Index", "Exames")
} }));
}catch (Exception ex)
{
if (ex.GetBaseException() == null)
{
return(Json(new { resultado = new RetornoJSON()
{
Erro = ex.Message
} }));
}
else
{
return(Json(new { resultado = new RetornoJSON()
{
Erro = ex.GetBaseException().Message
} }));
}
}
}
else
{
return(Json(new { resultado = TratarRetornoValidacaoToJSON() }));
}
}
public Double CalcularValorTotal()
{
Double valorTotal = Exames.Sum(exame => exame.TipoExame.Valor);
return(valorTotal);
}
public void Update(Exames Exame)
{
_ExameRepository.Update(Exame);
}
public void Create(Exames Exame)
{
_ExameRepository.Create(Exame);
}
public void Update(Exames entity)
{
_db.Exames.Update(entity);
_db.SaveChanges();
}
public void Create(Exames entity)
{
_db.Exames.Add(entity);
_db.SaveChanges();
}
// GET: ASO
public ActionResult ListaASOEmpregado(string ukEmpregado)
{
Guid emp = Guid.Parse(ukEmpregado);
var ListaASO = (from al in AlocacaoBusiness.Consulta.Where(p => string.IsNullOrEmpty(p.UsuarioExclusao)).ToList()
join ad in AdmissaoBusiness.Consulta.Where(p => string.IsNullOrEmpty(p.UsuarioExclusao) && p.UKEmpregado.Equals(emp)).ToList()
on al.UKAdmissao equals ad.UniqueKey
join e in EmpregadoBusiness.Consulta.Where(p => string.IsNullOrEmpty(p.UsuarioExclusao) && p.UniqueKey.Equals(emp)).ToList()
on ad.UKEmpregado equals e.UniqueKey
join f in FuncaoBusiness.Consulta.Where(p => string.IsNullOrEmpty(p.UsuarioExclusao)).ToList()
on al.UKFuncao equals f.UniqueKey
join est in EstabelecimentoBusiness.Consulta.Where(p => string.IsNullOrEmpty(p.UsuarioExclusao)).ToList()
on al.UKEstabelecimento equals est.UniqueKey
join wa in WorkAreaBusiness.Consulta.Where(p => string.IsNullOrEmpty(p.UsuarioExclusao)).ToList()
on al.UKEstabelecimento equals wa.UKEstabelecimento
join fon in FonteGeradoraDeRiscoBusiness.Consulta.Where(p => string.IsNullOrEmpty(p.UsuarioExclusao)).ToList()
on wa.UniqueKey equals fon.UKWorkArea
join fp in REL_FontePerigoBusiness.Consulta.Where(p => string.IsNullOrEmpty(p.UsuarioExclusao)).ToList()
on fon.UniqueKey equals fp.UKFonteGeradora
join re in REL_RiscosExamesBusiness.Consulta.Where(p => string.IsNullOrEmpty(p.UsuarioExclusao)).ToList()
on fp.UKPerigo equals re.ukPerigo
join pr in REL_PerigoRiscoBusiness.Consulta.Where(p => string.IsNullOrEmpty(p.UsuarioExclusao)).ToList()
on fp.UKPerigo equals pr.UKPerigo
join r in RiscoBusiness.Consulta.Where(p => string.IsNullOrEmpty(p.UsuarioExclusao)).ToList()
on pr.UKRisco equals r.UniqueKey
join p in PerigoBusiness.Consulta.Where(p => string.IsNullOrEmpty(p.UsuarioExclusao)).ToList()
on fp.UKPerigo equals p.UniqueKey
//where r.UniqueKey.Equals(emp) && ad.UKEmpregado.Equals(emp)
select new VMLaso()
{
ukPerigo = fp.UKPerigo,
Estabelecimento = est.NomeCompleto,
NomeEmpregado = e.Nome,
CPF = e.CPF,
Funcao = f.NomeDaFuncao,
Perigo = p.Descricao,
}).ToList();
List <VMLaso> asolist = ListaASO;
List <VMLExamesRiscos> ListaE = new List <VMLExamesRiscos>();
VMLExamesRiscos obj = null;
Exames oEx = null;
Perigo Per = null;
if (obj == null)
{
List <VMLExamesRiscos> ListaExame = new List <VMLExamesRiscos>();
foreach (var item3 in asolist)
{
if (item3 != null)
{
var oListaExame = (from r in REL_RiscosExamesBusiness.Consulta.Where(p => string.IsNullOrEmpty(p.UsuarioExclusao) && p.ukPerigo.Equals(item3.ukPerigo)).ToList()
join e in ExamesBusiness.Consulta.Where(p => string.IsNullOrEmpty(p.UsuarioExclusao)).ToList()
on r.ukExame equals e.UniqueKey
join p in PerigoBusiness.Consulta.Where(p => string.IsNullOrEmpty(p.UsuarioExclusao)).ToList()
on r.ukPerigo equals p.UniqueKey
select new VMLExamesRiscos()
{
Perigo = p.Descricao,
TipoExame = r.TipoExame,
Exame = e.Nome,
Obrigatoriedade = r.Obrigariedade,
}).ToList();
ListaExame = oListaExame.ToList();
}
}
foreach (var item2 in ListaExame)
{
if (obj == null)
{
obj = new VMLExamesRiscos()
{
Perigo = item2.Perigo,
Exame = item2.Exame,
Obrigatoriedade = item2.Obrigatoriedade,
TipoExame = item2.TipoExame,
ListaExames = new List <Exames>()
};
oEx = new Exames()
{
Nome = item2.Exame,
};
obj.ListaExames.Add(oEx);
ListaE.Add(obj);
}
else
{
if (obj.Perigo.Equals(item2.Perigo))
{
oEx = new Exames()
{
Nome = item2.Exame,
};
obj.ListaExames.Add(oEx);
ListaE.Add(obj);
}
}
}
ViewBag.ListaExame = ListaE.ToList().OrderBy(p => p.TipoExame);
}
ViewBag.listaASO = ListaASO.ToList();
return(View());
}
public void carregarResultadoLaudo(Cliente.Cliente cCliente, string strExame)
{
if (strExame.Equals("//////"))
{
return;
}
string strExemeArquivo = strExame.Replace('/', '_');
string path = Environment.GetFolderPath(Environment.SpecialFolder.Personal) + "\\Labol_Resultados\\" + cCliente.ano + cCliente.mes + "\\";
//string path = Directory.GetCurrentDirectory() + "\\" + cCliente.ano + cCliente.mes + "\\";
if (!Directory.Exists(path))
{
DirectoryInfo di = Directory.CreateDirectory(path);
//this.copiarArquivos(Directory.GetCurrentDirectory() + "\\img\\lab_3.gif", Environment.GetFolderPath(Environment.SpecialFolder.Personal) + "\\Labol_Resultados\\lab_3.gif");
}
string strFileNameBase = cCliente.codigo + "_" + strExemeArquivo + "_";
string[] filePaths = Directory.GetFiles(path, strFileNameBase + "*www");
if (true)//filePaths.Length == 0)
{
//List<String> lCamposJaAdicionados = new List<string>();
SortedDictionary <string, Exame.Exame> sdCamposExame;
//List<Exame.Exame> lCampos = Exames.getExames(strExame, this.strCaminhoArqTemp + "\\XEXAS.LAB", this.strCaminhoArqTemp + "\\TEXAS.LAB");
if (this.dExames.ContainsKey(strExame))
{
sdCamposExame = this.dExames[strExame];
}
else
{
sdCamposExame = Exames.getExames(strExame, this.strCaminhoArqTemp + "\\XEXAS.LAB", this.strCaminhoArqTemp + "\\TEXAS.LAB", this.strCaminhoArqTemp + "\\TEXTAB.LAB");
this.dExames[strExame] = sdCamposExame;
}
//List<Exame.Exame> retornoPosRegistro = Exames.getCamposExameValNormais(cCliente, lCampos, strExame);
string strArqLaudo = "\\LAUDOS" + cCliente.mes + "." + cCliente.ano.Substring(2, 2);
this.copiarArquivos(Settings1.Default.caminho_labol + strArqLaudo, this.strCaminhoArqTemp + strArqLaudo);
List <LaudoValor>[] lLaudoValor = LabolLeExames.Laudo.Laudos.getIndiceLaudo(cCliente.codigo, strExame, this.strCaminhoArqTemp + strArqLaudo);
this.strResultado = Resultado.Apresentacao.montaApresentacaoResultado(cCliente, sdCamposExame, lLaudoValor);
Random r = new Random();
this.strArquivoGerado = path + cCliente.codigo + "_" + strExemeArquivo + "_" + DateTime.Now.ToString("yyyy-MM-dd_HH-mm-ss_") + r.Next(999999).ToString() + ".html";
TextWriter tw = new StreamWriter(this.strArquivoGerado);
tw.WriteLine(this.strResultado);
tw.Close();
System.Diagnostics.Process.Start("IEXPLORE.EXE", this.strArquivoGerado);
//this.webBrowser1.Url = new Uri(this.strArquivoGerado);
}
//else
//{
// this.webBrowser1.Url = new Uri(filePaths[0]);
//}
}
