public Customer GetOneCustomerById(int id) { Customer customer = new Customer(); try { using (SqlConnection conn = GetSqlConnection()) { using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = @"SELECT * FROM Customers WHERE id = @Id"; cmd.Parameters.AddWithValue("@Id", id); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { customer = CustomerFactory.MakeCustomer(reader); } } } } catch (Exception) { throw new Exception(ErrorTypes.ERROR_GETONE_CLIENT); } return(customer); }
public IEnumerable <Customer> GetCustomers() { List <Customer> customers = new List <Customer>(); try { using (SqlConnection conn = GetSqlConnection()) { using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = @"SELECT * FROM Customers"; SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Customer customer = CustomerFactory.MakeCustomer(reader); customers.Add(customer); } } } } catch (Exception) { throw new Exception(ErrorTypes.ERROR_GETLIST_CLIENT); } return(customers); }
public IEnumerable <Customer> GetCustomers() { try { XElement doc = XElement.Load(connectionString); IEnumerable <Customer> customers = (from node in doc.Elements("Customer") select CustomerFactory.MakeCustomer(node)); return(customers); } catch (Exception) { throw new Exception(ErrorTypes.ERROR_GETLIST_CLIENT); } }
public Customer GetOneCustomerById(int id) { try { XElement doc = XElement.Load(connectionString); Customer customer = (from node in doc.Elements("Customer") where node.Element("Id").Value == id.ToString() select CustomerFactory.MakeCustomer(node)) .SingleOrDefault(); return(customer); } catch (Exception) { throw new Exception(ErrorTypes.ERROR_GETONE_CLIENT); } }