private void carregarGrid(ClinicaMedicaEntities4 conexao)
{
var lista = conexao.Paciente.ToList();
GridPaciente.DataSource = lista;
GridPaciente.DataBind();
}
private void carregarGrid(ClinicaMedicaEntities4 conexao)
{
var lista = conexao.Medicos.ToList();
gridexame.DataSource = lista;
gridexame.DataBind();
}
private void carregaexame(ClinicaMedicaEntities4 conexao)
{
var exame = conexao.Exame.ToList();
ddlexame.DataSource = exame;
ddlexame.DataTextField = "Tipo";
ddlexame.DataValueField = "ID";
ddlexame.DataBind();
}
private void carregamedico(ClinicaMedicaEntities4 conexao)
{
var medico = conexao.Medicos.ToList();
ddlmedico.DataSource = medico;
ddlmedico.DataTextField = "Nome";
ddlmedico.DataValueField = "CRM";
ddlmedico.DataBind();
}
private void carregapaciente(ClinicaMedicaEntities4 conexao)
{
var pacientes = conexao.Paciente.ToList();
ddlpaciente.DataSource = pacientes;
ddlpaciente.DataTextField = "Nome";
ddlpaciente.DataValueField = "CPF";
ddlpaciente.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ClinicaMedicaEntities4 conexao = new ClinicaMedicaEntities4();
carregarGrid(conexao);
carregapaciente(conexao);
carregaexame(conexao);
carregamedico(conexao);
}
}
protected void btnlogin_Click(object sender, EventArgs e)
{
string usuario = txtusuario.Text;
string senha = txtsenha.Text;
ClinicaMedicaEntities4 conexao = new ClinicaMedicaEntities4();
Usuario user = conexao.Usuario.FirstOrDefault(linha => linha.Login.Equals(usuario) && linha.Senha.Equals(senha));
if (user != null)
{
Response.Redirect("Principal.aspx");
}
}
protected void btncadastrar_Click(object sender, EventArgs e)
{
ClinicaMedicaEntities4 conexao = new ClinicaMedicaEntities4();
Exame exame = new Exame();
exame.Tipo = txttipo.Text;
exame.Valor = Convert.ToInt32(txtvalor.Text);
conexao.Exame.Add(exame);
conexao.SaveChanges();
Limpar();
carregarGrid(conexao);
}
protected void btncadastrar_Click(object sender, EventArgs e)
{
ClinicaMedicaEntities4 conexao = new ClinicaMedicaEntities4();
Consultas c = new Consultas();
c.Data = Convert.ToDateTime(txtdata.Text);
c.FK_Exame = Convert.ToInt32(ddlexame.Text);
c.FK_Medico = Convert.ToDecimal(ddlmedico.Text);
c.FK_Paciente = Convert.ToDecimal(ddlpaciente.Text);
conexao.Consultas.Add(c);
conexao.SaveChanges();
Limpar();
carregarGrid(conexao);
}
protected void btnalterar_Click1(object sender, EventArgs e)
{
if (GridPaciente.SelectedValue != null)
{
ClinicaMedicaEntities4 conexao = new ClinicaMedicaEntities4();
int id = Convert.ToInt32(GridPaciente.SelectedValue.ToString());
Paciente a = conexao.Paciente.FirstOrDefault(linha => linha.CPF.ToString().Equals(id.ToString()));
txtnome.Text = a.Nome;
txtcpf.Text = a.CPF.ToString();
txtemail.Text = a.Email;
txtendereco.Text = a.Endereco;
txtrg.Text = a.RG.ToString();
txttel.Text = a.Telefone.ToString();
}
}
protected void btncadastrar_Click(object sender, EventArgs e)
{
ClinicaMedicaEntities4 conexao = new ClinicaMedicaEntities4();
Medicos m = new Medicos();
m.CRM = Convert.ToDecimal(txtcrm.Text);
m.Nome = txtnome.Text;
m.CPF = Convert.ToDecimal(txtcpf.Text);
m.RG = Convert.ToDecimal(txtrg.Text);
m.Telefone = Convert.ToDecimal(txttel.Text);
m.Email = txtemail.Text;
conexao.Medicos.Add(m);
conexao.SaveChanges();
Limpar();
carregarGrid(conexao);
}
protected void btncadastrar_Click(object sender, EventArgs e)
{
ClinicaMedicaEntities4 conexao = new ClinicaMedicaEntities4();
Paciente p = new Paciente();
p.Nome = txtnome.Text;
p.CPF = Convert.ToDecimal(txtcpf.Text);
p.Endereco = txtendereco.Text;
p.Email = txtemail.Text;
p.Telefone = Convert.ToDecimal(txttel.Text);
p.RG = Convert.ToDecimal(txtrg.Text);
conexao.Paciente.Add(p);
conexao.SaveChanges();
Limpar();
carregarGrid(conexao);
}
protected void Page_Load(object sender, EventArgs e)
{
ClinicaMedicaEntities4 conexao = new ClinicaMedicaEntities4();
carregarGrid(conexao);
}