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(); }