public static int Salvar(Pergunta pergunta)
{
var ret = 0;
using (var db = new ProjectoBaseDataContext())
{
if (pergunta.Id <= 0)
{
db.Perguntas.Add(pergunta);
}
else
{
var model = BuscarPeloId(pergunta.Id).Respostas.ToList();
model.ForEach(p => p.Pergunta = null);
if (model.Any())
{
foreach (var item in model)
{
db.Entry(item).State = EntityState.Modified;
}
db.Respostas.RemoveRange(model);
}
db.Respostas.AddRange(pergunta.Respostas);
pergunta.Respostas = null;
db.Entry(pergunta).State = EntityState.Modified;
}
db.SaveChanges();
ret = pergunta.Id;
}
return(ret);
}
public static List <Candidatura> RecuperarLista(string filtro = "", string ordem = "")
{
var ret = new List <Candidatura>();
using (var db = new ProjectoBaseDataContext())
{
//var filtroWhere = "";
//if (!string.IsNullOrEmpty(filtro))
//{
// filtroWhere = string.Format("where (lower(DocumentosId) like '%{0}%') ", filtro.ToLower());
//}
//var sql =
// "select * from Candidatura " +
// filtroWhere +
// "order by " + (!string.IsNullOrEmpty(ordem) ? ordem : "DocumentosId");
//ret = db.Database.Connection.Query<Candidatura>(sql).ToList();
//ret = db.Candidaturas.SqlQuery(sql).ToList();
ret = db.Candidaturas
.Include(u => u.Usuario)
.Include(u => u.Provincia)
.Include(u => u.AreaCandidatura)
.ToList();
}
return(ret);
}
public int Salvar(UsuarioPerfil perfil)
{
var ret = 0;
using (var db = new ProjectoBaseDataContext())
{
var model = db.UsuarioPerfis
.Where(x => x.PerfilNome == perfil.PerfilNome)
.FirstOrDefault();
if (model == null)
{
db.UsuarioPerfis.Add(perfil);
}
else
{
model.PerfilNome = perfil.PerfilNome;
model.Ativo = perfil.Ativo;
db.UsuarioPerfis.Attach(perfil);
db.Entry(perfil).State = EntityState.Unchanged;
}
db.SaveChanges();
ret = perfil.Id;
}
return(ret);
}
public static void Seed(ProjectoBaseDataContext context)
{
if (!context.UsuarioPerfis.Where(u => u.PerfilNome == "Administrador").Any())
{
context.UsuarioPerfis.AddOrUpdate(x => x.PerfilNome,
new UsuarioPerfil()
{
PerfilNome = "Administrador", Ativo = true
});
}
var perfilAdmin = context.UsuarioPerfis.Where(u => u.PerfilNome == "Administrador").FirstOrDefault();
context.Usuarios.AddOrUpdate(x => x.Email,
new Usuario()
{
Id = Guid.NewGuid().ToString(),
NomeUsuario = "Admin",
Email = "*****@*****.**",
Senha = "master".Encrypt(),
NomeCompleto = "Administrador do Sistema",
DataNascimento = DateTime.Now.AddYears(-25),
UsuarioPerfilId = perfilAdmin.Id,
Genero = "M"
}
);
}
public static Exame BuscarPeloId(string id)
{
Exame ret = null;
using (var db = new ProjectoBaseDataContext())
{
ret = db.Exames.Find(id);
}
return(ret);
}
public static List <Exame> BuscarTodos()
{
List <Exame> ret = null;
using (var db = new ProjectoBaseDataContext())
{
ret = db.Exames.ToList();
}
return(ret);
}
public static List <AreaCandidatura> BuscarTodas()
{
List <AreaCandidatura> ret = null;
using (var db = new ProjectoBaseDataContext())
{
ret = db.AreaCandidaturas.ToList();
}
return(ret);
}
public static Concurso BuscarPeloId(string id)
{
Concurso ret = null;
using (var db = new ProjectoBaseDataContext())
{
ret = db.Concursos.Find(id);
}
return(ret);
}
public static Candidatura BuscarPeloId(string id)
{
Candidatura ret = null;
using (var db = new ProjectoBaseDataContext())
{
ret = db.Candidaturas.Find(id);
}
return(ret);
}
public static Usuario BuscarPeloId(string id)
{
Usuario ret = null;
using (var db = new ProjectoBaseDataContext())
{
ret = db.Usuarios.Find(id);
}
return(ret);
}
public static Usuario BuscarPeloEmail(string email)
{
Usuario ret = null;
using (var db = new ProjectoBaseDataContext())
{
ret = db.Usuarios.Where(u => u.Email == email).FirstOrDefault();
}
return(ret);
}
public static AreaCandidatura BuscarPeloId(int?id)
{
AreaCandidatura ret = null;
using (var db = new ProjectoBaseDataContext())
{
ret = db.AreaCandidaturas.Find(id);
}
return(ret);
}
public static List <Concurso> RecuperarLista(string filtro = "", string ordem = "")
{
var ret = new List <Concurso>();
using (var db = new ProjectoBaseDataContext())
{
ret = db.Concursos
.ToList();
}
return(ret);
}
public static List <Candidatura> BuscarPeloUsuarioId(string id)
{
var ret = new List <Candidatura>();
using (var db = new ProjectoBaseDataContext())
{
ret = db.Candidaturas.Where(u => u.UsuarioId == id)
.ToList();
}
return(ret);
}
public static Resposta BuscarPeloId(int?id)
{
Resposta ret = null;
using (var db = new ProjectoBaseDataContext())
{
ret = db.Respostas
.Where(p => p.Id.Equals(id))
.FirstOrDefault();
}
return(ret);
}
public static UsuarioPerfil BuscarPeloNome(string perfilNome)
{
UsuarioPerfil ret = null;
using (var db = new ProjectoBaseDataContext())
{
ret = db.UsuarioPerfis
.Where(x => x.PerfilNome == perfilNome)
.FirstOrDefault();
}
return(ret);
}
public static Questionario BuscarPeloId(int?id)
{
Questionario ret = null;
using (var db = new ProjectoBaseDataContext())
{
ret = db.Questionarios.Include(p => p.Perguntas.Select(r => r.Respostas))
.Where(q => q.Id == id)
.AsNoTracking()
.FirstOrDefault();
}
return(ret);
}
public static TempoExame BuscarPeloId(string id)
{
TempoExame ret = null;
using (var db = new ProjectoBaseDataContext())
{
ret = db.TempoExames
.Where(q => q.Id == id)
.AsNoTracking()
.FirstOrDefault();
}
return(ret);
}
public static List <TempoExame> BuscarTodos()
{
List <TempoExame> ret = null;
using (var db = new ProjectoBaseDataContext())
{
ret = db.TempoExames
.AsNoTracking()
.OrderBy(t => t.ValorMinuto)
.ToList();
}
return(ret);
}
public static Concurso BuscarConcursoAtual()
{
Concurso ret = null;
using (var db = new ProjectoBaseDataContext())
{
ret = db.Concursos
.OrderByDescending(c => c.Ativo)
.ThenByDescending(c => c.DataCadastro)
.FirstOrDefault();
}
return(ret);
}
public bool AlterarSenha(string novaSenha)
{
var ret = false;
using (var db = new ProjectoBaseDataContext())
{
//this.Senha = CriptoHelper.Encrypt(novaSenha);
//db.Usuarios.Attach(this);
//db.Entry(this).Property(x => x.Senha).IsModified = true;
db.SaveChanges();
}
return(ret);
}
public static Pergunta BuscarPeloId(int?id)
{
Pergunta ret = null;
using (var db = new ProjectoBaseDataContext())
{
ret = db.Perguntas.Include(r => r.Respostas)
.Where(p => p.Id == id)
.AsNoTracking()
.FirstOrDefault();
}
return(ret);
}
public static Usuario ValidarUsuario(string email, string senha)
{
Usuario ret = null;
senha = senha.Encrypt();
using (var db = new ProjectoBaseDataContext())
{
ret = db.Usuarios
.Include(x => x.UsuarioPerfil)
.Where(x => x.Email == email && x.Senha == senha)
.FirstOrDefault();
}
return(ret);
}
public static List <Questionario> BuscarTodos()
{
List <Questionario> ret = null;
using (var db = new ProjectoBaseDataContext())
{
ret = db.Questionarios
.Include(a => a.AreaCandidatura)
.Include(a => a.Perguntas.Select(r => r.Respostas))
.AsNoTracking()
.OrderByDescending(q => q.DataCadastro)
.ToList();
}
return(ret);
}
public static bool EliminarPorId(int id)
{
var pergunta = BuscarPeloId(id);
if (pergunta != null && !pergunta.Respostas.Any())
{
using (var db = new ProjectoBaseDataContext())
{
db.Perguntas.Remove(pergunta);
db.SaveChanges();
}
return(true);
}
return(false);
}
public static bool ExcluirPeloId(string id)
{
var ret = false;
if (id != null)
{
using (var db = new ProjectoBaseDataContext())
{
var usuario = BuscarPeloId(id);
db.Usuarios.Remove(usuario);
db.SaveChanges();
ret = true;
}
}
return(ret);
}
public static void Seed(ProjectoBaseDataContext context)
{
context.UsuarioPerfis.AddOrUpdate(x => x.PerfilNome,
new UsuarioPerfil()
{
PerfilNome = "Administrador", Ativo = true
},
new UsuarioPerfil()
{
PerfilNome = "Gestor", Ativo = true
},
new UsuarioPerfil()
{
PerfilNome = "Usuário", Ativo = true
});
context.SaveChanges();
}
public static void Seed(ProjectoBaseDataContext context)
{
context.AreaCandidaturas.AddOrUpdate(x => x.AreaNome,
new AreaCandidatura()
{
AreaNome = "Tecnologias de Informação", Ativo = true
},
new AreaCandidatura()
{
AreaNome = "Auxiliar de Limpeza", Ativo = true
},
new AreaCandidatura()
{
AreaNome = "Recursos Humanos", Ativo = true
});
context.SaveChanges();
}
