public bool ValidarLogin(string login)
{
using (ISession session = SessionFactory.AbrirSession())
{
return((from e in session.Query <Usuario>() where e.Login.Equals(login) select e).Count() > 0);
}
}
public bool ValidarAcesso(string login, string senha)
{
using (ISession session = SessionFactory.AbrirSession())
{
return((from e in session.Query <Usuario>() where e.Login.Equals(login) && e.Senha.Equals(senha) select e).Count() > 0);
}
}
public ActionResult Edit(int id, Eventos eventos)
{
try
{
using (ISession session = SessionFactory.AbrirSession())
{
var eventosAlterado = session.Get <Eventos>(id);
eventosAlterado.DataCriacao = Convert.ToDateTime(eventos.DataCriacao);
eventosAlterado.DataEntrega = Convert.ToDateTime(eventos.DataEntrega);
eventosAlterado.Titulo = eventos.Titulo;
eventosAlterado.Descricao = eventos.Descricao;
eventosAlterado.FlagPronto = eventos.FlagPronto;
using (ITransaction transaction = session.BeginTransaction())
{
session.Save(eventosAlterado);
transaction.Commit();
}
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public Usuario ValidarAcesso(string email, string senha)
{
using (ISession session = SessionFactory.AbrirSession())
{
return((from e in session.Query <Usuario>() where e.Email.Equals(email) && e.Senha.Equals(senha) select e).FirstOrDefault());
}
}
public static List <ContaBancaria> SelecionarPorFavorecidoId(this List <ContaBancaria> contasBancarias, long favorecidoId, ECategoria categoria)
{
SessionFactory.CriarSession();
using (var session = SessionFactory.AbrirSession())
{
return(session.Query <ContaBancaria>().Where(cb => cb.CategoriaFavorecido == (int)categoria && cb.FavorecidoId == favorecidoId).ToList());
}
}
public static Funcionario SelecionarPorUsuario(this Funcionario fun)
{
SessionFactory.CriarSession();
using (var session = SessionFactory.AbrirSession())
{
return(session.Query <Funcionario>().Where(f => f.Usuario == fun.Usuario).SingleOrDefault());
}
}
public static List <T> Selecionar <T>(this List <T> ts)
{
using (var session = SessionFactory.AbrirSession())
{
ts = (from t in session.Query <T>() select t).ToList();
return(ts);
}
}
// GET: Eventos
public ActionResult Index()
{
using (ISession session = SessionFactory.AbrirSession())
{
var eventos = session.Query <Eventos>().ToList();
return(View(eventos));
}
}
public static T SelecionarPorId <T>(this T t, long id)
{
using (var session = SessionFactory.AbrirSession())
{
t = session.Get <T>(id);
return(t);
}
}
// GET: Eventos/Edit/5
public ActionResult Edit(int id)
{
using (ISession session = SessionFactory.AbrirSession())
{
var eventos = session.Get <Eventos>(id);
return(View(eventos));
}
}
public static List <T> SelecionarOnde <T>(this List <T> ts, Expression <Func <T, bool> > expression)
{
using (var session = SessionFactory.AbrirSession())
{
ts = session.Query <T>().Where(expression).ToList();
return(ts);
}
}
public static T SelecionarUmOnde <T>(this T t, Expression <Func <T, bool> > expression)
{
using (var session = SessionFactory.AbrirSession())
{
t = session.Query <T>().Where(expression).SingleOrDefault();
return(t);
}
}
public bool validaElementoEvaluacionSigno(string nombre)
{
using (ISession session = SessionFactory.AbrirSession())
{
return((from e in session.Query <ElementoEvaluacionSigno>()
where e.nombreSigno.Equals(nombre)
select e).Count() > 0);
}
}
public bool validaEstadoElementoRegion(string nombre)
{
using (ISession session = SessionFactory.AbrirSession())
{
return((from e in session.Query <EstadoElementoRegion>()
where e.nomestadoelto.Equals(nombre)
select e).Count() > 0);
}
}
public bool validaSintoma(string descripcion)
{
using (ISession session = SessionFactory.AbrirSession())
{
return((from e in session.Query <Sintoma>()
where e.descripcion.Equals(descripcion)
select e).Count() > 0);
}
}
public bool validaRegion(string parte)
{
using (ISession session = SessionFactory.AbrirSession())
{
return((from e in session.Query <Region>()
where e.parteExplorada.Equals(parte)
select e).Count() > 0);
}
}
public bool validaElementoRegionalEvaluar(string nombre)
{
using (ISession session = SessionFactory.AbrirSession())
{
return((from e in session.Query <ElementoRegionalEvaluar>()
where e.nombreEltoExplorado.Equals(nombre)
select e).Count() > 0);
}
}
public bool validaSintomaGeneral(SintomaGeneral sg)
{
using (ISession session = SessionFactory.AbrirSession())
{
return((from e in session.Query <SintomaGeneral>() where
e.codigoSintoma.Equals(sg.codigoSintoma) &&
e.idExpediente.Equals(sg.idExpediente) &&
e.idSintomaGeneral.Equals(sg.idSintomaGeneral)
select e).Count() > 0);
}
}
public bool validarPadecimentoActual(int p, int ex)
{
using (ISession session = SessionFactory.AbrirSession())
{
return((from e in session.Query <PadecimientoActual>()
where
e.idPadecimiento.Equals(p) &&
e.idExpediente.Equals(ex)
select e).Count() > 0);
}
}
public bool validarSignoVital(SignoVital st)
{
using (ISession session = SessionFactory.AbrirSession())
{
return((from e in session.Query <SignoVital>()
where
e.idSignoVital.Equals(st.idSignoVital) &&
e.idExpediente.Equals(st.idExpediente) &&
e.idSignoEvaluar.Equals(st.idSignoEvaluar)
select e).Count() > 0);
}
}
public ActionResult Create(Eventos eventos)
{
try
{
using (ISession session = SessionFactory.AbrirSession())
{
using (ITransaction transacao = session.BeginTransaction())
{
session.Save(eventos);
transacao.Commit();
}
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public static void Excluir <T>(this T t)
{
using (var session = SessionFactory.AbrirSession())
{
using (ITransaction transacao = session.BeginTransaction())
{
try
{
session.Delete(t);
transacao.Commit();
}
catch (Exception e)
{
if (!transacao.WasCommitted)
{
transacao.Rollback();
}
throw new Exception("Erro ao excluir dados: " + e.Message);
}
}
}
}
private void FetchRepositories(string authorization)
{
var byteArray = Encoding.ASCII.GetBytes(authorization);
_client.DefaultRequestHeaders.Authorization = new System.Net.Http.Headers.AuthenticationHeaderValue("Basic", Convert.ToBase64String(byteArray));
_client.DefaultRequestHeaders.UserAgent.ParseAdd("GitHubApiSeeker");
_userRepository = new UserRepository(SessionFactory.AbrirSession());
_repoRepository = new RepoRepository(SessionFactory.AbrirSession());
//HttpResponseMessage users_message;
//Thread t = new Thread(FetchAndSaveRepos);
//t.Start();
for (int i = 0; i < pages.Length; i++)
{
pages[i] = (START_PAGE) + i * (MAX_PAGE / pages.Length);
Console.WriteLine($"pages[i]: {pages[i]}");
}
for (int i = 1; i < pages.Length - 1; i++)
{
threads[i] = new Thread(FetchUsersFromTo);
threads[i].Start(i - 1);
}
}