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