private classEvaluation fillRow(DataRow obj)
{
classEvaluation objEvaluation = new classEvaluation();
objEvaluation.id = Convert.ToInt32(((DataRow)obj).ItemArray.GetValue(0).ToString());
objEvaluation.cd_cliente = Convert.ToInt32(((DataRow)obj).ItemArray.GetValue(1).ToString());
objEvaluation.dataInicio = Convert.ToDateTime(((DataRow)obj).ItemArray.GetValue(2).ToString());
objEvaluation.diagnosticoMedico = (((DataRow)obj).ItemArray.GetValue(3).ToString());
objEvaluation.nomeMedico = ((DataRow)obj).ItemArray.GetValue(4).ToString();
objEvaluation.CRMmedico = ((DataRow)obj).ItemArray.GetValue(5).ToString();
objEvaluation.anamnese = ((DataRow)obj).ItemArray.GetValue(6).ToString();
objEvaluation.medicamentos = ((DataRow)obj).ItemArray.GetValue(7).ToString();
objEvaluation.doencasAssociadas = ((DataRow)obj).ItemArray.GetValue(8).ToString();
objEvaluation.etilista = Convert.ToBoolean(((DataRow)obj).ItemArray.GetValue(9).ToString());
objEvaluation.tabagista = Convert.ToBoolean(((DataRow)obj).ItemArray.GetValue(10).ToString());
objEvaluation.hobbies = ((DataRow)obj).ItemArray.GetValue(11).ToString();
objEvaluation.planoTratamento = (((DataRow)obj).ItemArray.GetValue(12).ToString());
objEvaluation.cd_tipoTratamento = Convert.ToInt32(((DataRow)obj).ItemArray.GetValue(13).ToString());
objEvaluation.EVA = Convert.ToInt16(((DataRow)obj).ItemArray.GetValue(14).ToString());
objEvaluation.examesComplementares = (((DataRow)obj).ItemArray.GetValue(15).ToString());
objEvaluation.QueixaPrincipal = (((DataRow)obj).ItemArray.GetValue(16).ToString());
objEvaluation.fechada = Convert.ToBoolean(((DataRow)obj).ItemArray.GetValue(17).ToString());
return(objEvaluation);
}
public bool getById(ref classEvaluation objEvaluation, int id)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = classModulo.strConn;
SqlCommand cmd = new SqlCommand("spAvaliacoesObterPorID", conn);
cmd.Parameters.AddWithValue("@id", id);
cmd.CommandType = CommandType.StoredProcedure;
try
{
conn.Open();
DataTable dt = new DataTable();
dt.Load(cmd.ExecuteReader());
if (dt.Rows.Count > 0)
{
objEvaluation = (fillRow(dt.Rows[0]));
}
}
catch (Exception ex)
{
objErro.strErro = ex.Message;
objErro.erro = true;
objErro.cd_erro = ex.HResult;
return(false);
}
finally
{
conn.Close();
}
return(true);
}
