public bool Delete(string id) { using (CustomerDataAdapter adapter = new CustomerDataAdapter()) { return adapter.DeleteCustomer(id); } }
public Customer GetCustomerByEmail(string email) { Customer customer = new Customer(); IDataReader dr = new CustomerDataAdapter().GetCustomerByEmail(email); if (dr.Read()) { customer = PopulateReader(dr); } dr.Close(); return customer; }
public bool Insert(Customer customer) { using (CustomerDataAdapter adapter = new CustomerDataAdapter()) { return adapter.InsertCustomer(customer.Company, customer.Name, customer.PhoneNo, customer.Email, customer.Fax, customer.Address, customer.Website, customer.Remarks, customer.PostCode , customer.Country, customer.Rating); } }
public string GetMaxId() { string maxid = string.Empty; IDataReader dr = new CustomerDataAdapter().GetMaxId(); while (dr.Read()) { maxid = dr["id"].ToString(); } dr.Close(); return maxid; }
public Customer GetCustomersById(int id) { Customer customer = new Customer(); using (IDataReader dr = new CustomerDataAdapter().GetCustomerByCode(id)) { if (dr.Read()) { customer = PopulateReader(dr); } dr.Close(); } return customer; }
public CustomerCollection GetCustomers() { CustomerCollection customers = new CustomerCollection(); using(IDataReader dr = new CustomerDataAdapter().GetCustomers()) { while (dr.Read()) { customers.Add(PopulateReader(dr)); } dr.Close(); } return customers; }
public bool IsCustomerExist(int id) { bool exist = false; using (IDataReader dr = new CustomerDataAdapter().GetCustomerByCode(id)) { if (dr.Read()) exist = true; dr.Close(); } return exist; }