private classClientes fillRow(DataRow obj) { classClientes objCliente = new classClientes(); objCliente.id = Convert.ToInt32(((DataRow)obj).ItemArray.GetValue(0).ToString()); objCliente.nome = ((DataRow)obj).ItemArray.GetValue(1).ToString(); objCliente.cd_planoSaude = Convert.ToInt32(((DataRow)obj).ItemArray.GetValue(2).ToString()); objCliente.dataNascimento = Convert.ToDateTime(((DataRow)obj).ItemArray.GetValue(3).ToString()); objCliente.cpf = ((DataRow)obj).ItemArray.GetValue(4).ToString(); objCliente.telefone = ((DataRow)obj).ItemArray.GetValue(5).ToString(); objCliente.midias = ((DataRow)obj).ItemArray.GetValue(6).ToString(); objCliente.endereco = ((DataRow)obj).ItemArray.GetValue(7).ToString(); objCliente.profissao = ((DataRow)obj).ItemArray.GetValue(8).ToString(); objCliente.numeroCarteirinha = ((DataRow)obj).ItemArray.GetValue(9).ToString(); objCliente.planoSaude = ((DataRow)obj).ItemArray.GetValue(10).ToString(); return(objCliente); }
public bool getCustomerByID(ref classClientes objCliente, int id) { SqlConnection conn = new SqlConnection(); conn.ConnectionString = classModulo.strConn; SqlCommand cmd = new SqlCommand("spClientesObterPorID", 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) { foreach (DataRow obj in dt.Rows) { objCliente = fillRow(obj); } } } catch (Exception ex) { objErro.strErro = ex.Message; objErro.erro = true; objErro.cd_erro = ex.HResult; return(false); } finally { conn.Close(); } return(true); }