// OrderSet.h : Implementation of the COrderSet class
  
  // COrderSet implementation
  
  // code generated on 9 October 2005, 19:24
  
  include <stdafx.h>
  include <OrderSet.h>
  IMPLEMENT_DYNAMIC(COrderSet, CRecordset)
  
  COrderSet::COrderSet(CDatabase* pdb)
          : CRecordset(pdb)
  {
          m_OrderID = 0;
          m_CustomerID = L"";
          m_EmployeeID = 0;
          m_OrderDate;
          m_RequiredDate;
          m_ShippedDate;
          m_ShipVia = 0;
          m_Freight = 0.0;
          m_ShipName = L"";
          m_ShipAddress = L"";
          m_ShipCity = L"";
          m_ShipRegion = L"";
          m_ShipPostalCode = L"";
          m_ShipCountry = L"";
          m_nFields = 14;
          m_nDefaultType = dynaset;
  }
  //#error Security Issue: The connection string may contain a password
  // The connection string below may contain plain text passwords and/or
  // other sensitive information. Please remove the #error after reviewing
  // the connection string for any security related issues. You may want to
  // store the password in some other form or use a different user authentication.
  CString COrderSet::GetDefaultConnect()
  {
          return _T("DSN=Northwind;DBQ=D:\\Beginning Visual C++ 2005\\Model Access DB\\Northwind.mdb;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=admin;");
  }
  
  CString COrderSet::GetDefaultSQL()
  {
          return _T("[Orders]");
  }
  
  void COrderSet::DoFieldExchange(CFieldExchange* pFX)
  {
          pFX->SetFieldType(CFieldExchange::outputColumn);
  // Macros such as RFX_Text() and RFX_Int() are dependent on the
  // type of the member variable, not the type of the field in the database.
  // ODBC will try to automatically convert the column value to the requested type
          RFX_Long(pFX, _T("[OrderID]"), m_OrderID);
          RFX_Text(pFX, _T("[CustomerID]"), m_CustomerID);
          RFX_Long(pFX, _T("[EmployeeID]"), m_EmployeeID);
          RFX_Date(pFX, _T("[OrderDate]"), m_OrderDate);
          RFX_Date(pFX, _T("[RequiredDate]"), m_RequiredDate);
          RFX_Date(pFX, _T("[ShippedDate]"), m_ShippedDate);
          RFX_Long(pFX, _T("[ShipVia]"), m_ShipVia);
          RFX_Double(pFX, _T("[Freight]"), m_Freight);
          RFX_Text(pFX, _T("[ShipName]"), m_ShipName);
          RFX_Text(pFX, _T("[ShipAddress]"), m_ShipAddress);
          RFX_Text(pFX, _T("[ShipCity]"), m_ShipCity);
          RFX_Text(pFX, _T("[ShipRegion]"), m_ShipRegion);
          RFX_Text(pFX, _T("[ShipPostalCode]"), m_ShipPostalCode);
          RFX_Text(pFX, _T("[ShipCountry]"), m_ShipCountry);
  
  }
  
//////////////////////////////////////////////////////////////////////////


  // COrderSet diagnostics
  
  ifdef _DEBUG
  void COrderSet::AssertValid() const
  {
          CRecordset::AssertValid();
  }
  
  void COrderSet::Dump(CDumpContext& dc) const
  {
          CRecordset::Dump(dc);
  }
  endif //_DEBUG
  
  long COrderSet::CreateNewOrderID(void)
  {
    if(!IsOpen())
      Open(CRecordset::dynaset);
  
    // Check for no records in recordset  
    long newOrderID = 0;
    if(!(IsBOF() && IsEOF()))
    {                                         // We have records
      MoveFirst();                            // so go to the first
      while(!IsEOF())                         // Compare with all the others
      {
        // Save order ID if its larger
        if(newOrderID < m_OrderID)
            newOrderID = m_OrderID;
  
        MoveNext();                           // Go to next record
      }
    }
    return ++newOrderID;
  }