protected void btnSalvar_Click(object sender, EventArgs e) { PegasusAcademyEntities conexao = new PegasusAcademyEntities(); try { Personal prof = new Personal(); prof.Nome = txtNome.Text; prof.Bairro = txtBairro.Text; prof.Celular = txtCelular.Text; prof.CPF = txtCPF.Text; prof.DataNasc = Convert.ToDateTime(txtDatanasc.Text); prof.Endereco = txtEndereco.Text; prof.Experiencia = txtExp.Text; prof.Formacao = txtFormacao.Text; conexao.Personal.Add(prof); conexao.SaveChanges(); limpar(); Response.Write("<script>alert('Personal salvo(a) com Sucesso!');</script>"); } catch { Response.Write("<script>alert('Registro não salvo!');</script>"); } }
protected void btnRemover_Click(object sender, EventArgs e) { try { PegasusAcademyEntities conexao = new PegasusAcademyEntities(); int IDselecionado = Convert.ToInt32(GridView1.SelectedValue.ToString()); Personal p = conexao.Personal.FirstOrDefault( linha => linha.ID_Personal.ToString().Equals(IDselecionado.ToString())); conexao.Personal.Remove(p); conexao.SaveChanges(); Response.Write("<script>alert('Personal removido com sucesso');</script>"); GridView1.DataBind(); } catch { Response.Write("<script>alert('Falha ao remover');</script>"); } }
protected void btnEntrar_Click(object sender, EventArgs e) { string usuario = txtUser.Text; string senha = txtSenha.Text; // Cria conexão com o banco de dados PegasusAcademyEntities conexao = new PegasusAcademyEntities(); //Consulta objeto usuário baseado em login e senha usuario usuarios = conexao.usuario.FirstOrDefault( linha => linha.login.Equals(usuario) && linha.senha.Equals(senha) ); if (usuarios != null) { //Login Bem sucedido Response.Redirect("Cadastro_prof.aspx"); } }
protected void btnBuscar_Click(object sender, EventArgs e) { using (PegasusAcademyEntities entities = new PegasusAcademyEntities()) { List <Personal> lista = null; if (rbNome.Checked) { lista = entities.Personal.Where(x => x.Nome.StartsWith(txtBuscar.Text)).ToList(); } else if (rbCPF.Checked) { lista = entities.Personal.Where(x => x.CPF.StartsWith(txtBuscar.Text)).ToList(); } else { lista = entities.Personal.ToList(); } GridView1.DataSource = lista.OrderBy(x => x.ID_Personal); GridView1.DataBind(); } }
protected void btnSalvar_Click(object sender, EventArgs e) { PegasusAcademyEntities conexao = new PegasusAcademyEntities(); try { Aluno a = new Aluno(); a.Nome = txtNome.Text; a.Celular = txtCelular.Text; a.CPF = txtCPF.Text; a.DataNasc = Convert.ToDateTime(txtDataNasc.Text); a.Endereco = txtEndereco.Text; a.Personal = ddlPersonal.SelectedValue; conexao.Aluno.Add(a); conexao.SaveChanges(); limpar(); Response.Write("<script>alert('Aluno salvo com Sucesso!');</script>"); } catch { Response.Write("<script>alert('Registro não salvo!');</script>"); } }