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