//internal static void SupplierProc(IDataReader dr, FieldDictionary Fields, object Param)
//{
// SupplierCollection coll = Param as SupplierCollection;
// Supplier item = Mapper.ReadSupplier(dr, Fields);
// coll.Add(item);
//}
public CustomerCollection GetAllCustomers()
{
string str = @"select CustomerID, CompanyName, ContactName, ContactTitle, Address, City,
Region, PostalCode, Country, Phone, Fax from Customers" ;
SqlCommand cmd = new SqlCommand(str, new SqlConnection(_strCnn));
CustomerCollection cc = new CustomerCollection();
DataRead.RunQuery(cmd, new DataRead.ProcessRow(CustomerProc), cc);
cc.AcceptChanges();
return(cc);
}
public CustomerCollection GetCustomerByCustomerId(string CustomerId)
{
string str = @"select CustomerID, CompanyName, ContactName, ContactTitle, Address, City,
Region, PostalCode, Country, Phone, Fax from Customers where CustomerID = @CustomerId" ;
SqlCommand cmd = new SqlCommand(str, new SqlConnection(_strCnn));
cmd.Parameters.Add("@CustomerId", SqlDbType.NChar, 0, "CustomerId");
cmd.Parameters[0].Value = CustomerId;
CustomerCollection cc = new CustomerCollection();
DataRead.RunQuery(cmd, new DataRead.ProcessRow(CustomerProc), cc);
cc.AcceptChanges();
return(cc);
}