public frmAvaliacao(String avaId)
{
InitializeComponent();
ava = new Avaliacao();
func = new Funcionario();
alu = new Aluno();
ana = new Anamnese();
per = new Perimetro();
comp = new Composicao();
neuro = new Neuromotor();
util = new Utils();
util.desabilitarCampos(tbAnamnese.Controls, false);
ttbGeralSaude.Enabled = true;
ttbAtividadeFisica.Enabled = true;
ttbPartesModificar.Enabled = true;
ttbObjetivoPraticaExe.Enabled = true;
util.numericMaskFormata(tbPerimetros.Controls);
util.numericMaskFormata(tbComposicao.Controls);
util.numericMaskFormata(ttbNeuroWells);
ava.Id = avaId;
ava = ava.getById();
func.Id = ava.FuncId;
func.getDadosFunc();
alu.Id = Convert.ToInt32(ava.AluId);
alu = alu.getAlunoById();
if (alu.Sexo == 'm')
{
lblProtocolo.Text = "Pollock - 3 dobras";
ttbCompAxilarMedia.Enabled = false;
ttbCompSubEscap.Enabled = false;
ttbCompSupraIliaca.Enabled = false;
ttbCompTricipital.Enabled = false;
}
else
{
lblProtocolo.Text = "Pollock - 7 dobras";
}
lblAvaliado.Text = alu.Nome;
lblAvaliador.Text = func.Nome;
lblIdade.Text = ""+util.getIdade(alu.DtNasc);
lblCodigo.Text = ava.Id;
if (!ava.jaRealizada())
{
ana.nova(ava.Id);
per.nova(ava.Id);
comp.nova(ava.Id, alu.Sexo);
neuro.novo(ava.Id);
ava = ava.getById();
}
setarCamposAna();
setarCamposPer();
setarCamposComp();
setarCamposNeuro();
lblData.Text = ava.DtRealizada;
atualizaTermo();
}
public Neuromotor getById(String id)
{
Neuromotor neuro = new Neuromotor();
sql = "SELECT * FROM neuromotor WHERE neuro_id=@1";
sql = sql.Replace("@1", id);
bco.conecta();
result = bco.executeQuery(sql, out dt);
bco.desconecta();
if (dt.Rows.Count > 0)
{
neuro.Id = dt.Rows[0]["neuro_id"].ToString();
neuro.Flexao = dt.Rows[0]["neuro_flexao"].ToString();
neuro.Abdominal = dt.Rows[0]["neuro_abdominal"].ToString();
neuro.Wells = dt.Rows[0]["neuro_banco_wells"].ToString();
neuro.FlexaoLegenda = dt.Rows[0]["neuro_flexao_legenda"].ToString();
neuro.AbdominalLegenda = dt.Rows[0]["neuro_abdominal_legenda"].ToString();
neuro.WellsLegenda = dt.Rows[0]["neuro_wells_legenda"].ToString();
}
return neuro;
}
public bool atualiza(Neuromotor neuro)
{
sql = "UPDATE neuromotor SET neuro_flexao=@1, neuro_abdominal=@2, neuro_banco_wells=@3 " +
", neuro_flexao_legenda='@4', neuro_abdominal_legenda='@5', neuro_wells_legenda='@6' "+
"WHERE neuro_id = @A";
sql = sql.Replace("@A", neuro.Id);
sql = sql.Replace("@1", neuro.Flexao);
sql = sql.Replace("@2", neuro.Abdominal);
if (neuro.Wells == "")
sql = sql.Replace("@3", "null");
else
sql = sql.Replace("@3", neuro.Wells);
sql = sql.Replace("@4", neuro.FlexaoLegenda);
sql = sql.Replace("@5", neuro.AbdominalLegenda);
sql = sql.Replace("@6", neuro.WellsLegenda);
bco.conecta();
result = bco.executeNonQuery(sql);
bco.desconecta();
return result;
}
private void setarCamposNeuro()
{
neuro.Id = ava.NeuroId;
neuro = neuro.getById();
ttbNeuroWells.Text = neuro.Wells;
try
{
numNeuroAbdominal.Value = Convert.ToDecimal(neuro.Abdominal);
}
catch { }
try
{
numNeuroFlexao.Value = Convert.ToDecimal(neuro.Flexao);
}
catch { }
}
