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