public static List <Cliente> SelectAll() { Cliente c; List <Cliente> cs = new List <Cliente>(); try { using (conn = new SqlConnection(connectionString)) { conn.Open(); string s = "SELECT * FROM Cliente"; SqlCommand cmd = new SqlCommand(s, conn); SqlDataReader d; using (d = cmd.ExecuteReader()) { if (d.HasRows) { while (d.Read()) { int i = Convert.ToInt32(d["id"]); string n = d["Nome"].ToString(); string cpf = (d["CPF"] != null) ? d["CPF"].ToString() : ""; string cnpj = (d["CNPJ"] != null) ? d["CNPJ"].ToString() : ""; string e = d["Email"].ToString(); Endereco end = DALEndereco.SelectFromCliente(i); Telefone t = DALTelefone.SelectFromCliente(i); c = new Cliente(i, n, e, end, t); if (cpf != "") { c.setCPF(cpf); } else { c.setCNPJ(cnpj); } cs.Add(c); } } } } } catch (Exception) { throw; } return(cs); }
public static Cliente Select(int i) { Cliente c = new Cliente(); try { using (conn = new SqlConnection(connectionString)) { conn.Open(); string s = "SELECT * FROM Cliente WHERE id = @id "; SqlCommand cmd = new SqlCommand(s, conn); cmd.Parameters.Add("@id", SqlDbType.Int).Value = i; SqlDataReader d; using (d = cmd.ExecuteReader()) { if (d.HasRows) { while (d.Read()) { string n = d["Nome"].ToString(); string cpf = (d["CPF"] != null) ? d["CPF"].ToString() : ""; string cnpj = (d["CNPJ"] != null) ? d["CNPJ"].ToString() : ""; string e = d["Email"].ToString(); Endereco end = DALEndereco.SelectFromCliente(i); Telefone t = DALTelefone.SelectFromCliente(i); c = new Cliente(i, n, e, end, t); if (cpf != "") { c.setCPF(cpf); } else { c.setCNPJ(cnpj); } } } } } } catch (Exception) { throw; } return(c); }