private ObjectPropertyDictionary GetBaseProperties()
        {
            ObjectPropertyDictionary objProperties = new ObjectPropertyDictionary();

            objProperties.Add("VendorID", SqlDbType.Int);
            objProperties.Add("VendorName", SqlDbType.VarChar);
            objProperties.Add("Address", SqlDbType.VarChar);
            objProperties.Add("City", SqlDbType.VarChar);
            objProperties.Add("State", SqlDbType.VarChar);
            objProperties.Add("Zip", SqlDbType.Int);
            objProperties.Add("Phone", SqlDbType.VarChar);
            objProperties.Add("Email", SqlDbType.VarChar);
            objProperties.Add("EliteVendorID", SqlDbType.Int);
            objProperties.Add("Billed", SqlDbType.VarChar);
            objProperties.Add("Delivered", SqlDbType.VarChar);
            objProperties.Add("Type", SqlDbType.VarChar);

            return objProperties;
        }
        private Employee GetLocalItem(ParameterCollection ParameterCollection, ObjectPropertyDictionary PropertyValues, string StoredProcName)
        {
            Employee objItem = (Employee)DataHelper.GetItem<Employee>(ParameterCollection, PropertyValues, StoredProcName, base.GetConnectionString());

            //notes:    get embedded properties
            this.GetEmbeddedProperties(ref objItem);

            //notes:    return success indicator
            objItem.StatusResult = new ResponseStatus("", "", ResponseStatusResult.Success);

            return objItem;
        }
        private EmployeeCollection GetLocalCollection(ParameterCollection ParameterCollection, ObjectPropertyDictionary PropertyValues, string StoredProcName)
        {
            List<Object> objGenericList = DataHelper.GetList<Employee>(ParameterCollection, PropertyValues, StoredProcName, base.GetConnectionString());
            EmployeeCollection objCollection = new EmployeeCollection();

            foreach (Object item in objGenericList)
            {
                Employee objItem = (Employee)item;

                //notes:    get embedded properties
                this.GetEmbeddedProperties(ref objItem);

                objCollection.Add(objItem);
            }

            objCollection.StatusResult = new ResponseStatus("", "", ResponseStatusResult.Success);
            return objCollection;
        }
        private ObjectPropertyDictionary GetBaseProperties()
        {
            ObjectPropertyDictionary objProperties = new ObjectPropertyDictionary();

            objProperties.Add("TKID", SqlDbType.Int);

            objProperties.Add("Email", SqlDbType.VarChar);
            objProperties.Add("FirstName", SqlDbType.VarChar);
            objProperties.Add("LastName", SqlDbType.VarChar);
            objProperties.Add("Title", SqlDbType.VarChar);

            return objProperties;
        }
        private VendorItemCollection GetLocalCollection(ParameterCollection ParameterCollection, ObjectPropertyDictionary PropertyValues, string StoredProcName)
        {
            List<Object> objGenericList = DataHelper.GetList<VendorItem>(ParameterCollection, PropertyValues, StoredProcName, base.GetConnectionString());
            VendorItemCollection objCollection = new VendorItemCollection();

            foreach (Object item in objGenericList)
            {
                VendorItem objItem = (VendorItem)item;

                objCollection.Add(objItem);
            }

            objCollection.StatusResult = new ResponseStatus("Collection successful.", "", ResponseStatusResult.Success);
            return objCollection;
        }
        private VendorItem GetLocalItem(ParameterCollection ParameterCollection, ObjectPropertyDictionary PropertyValues, string StoredProcName)
        {
            VendorItem objItem = (VendorItem)DataHelper.GetItem<VendorItem>(ParameterCollection, PropertyValues, StoredProcName, base.GetConnectionString());

            //notes:    get embedded properties
            this.GetEmbeddedProperties(ref objItem);

            //notes:    return success indicator
            objItem.StatusResult = new ResponseStatus { ResponseStatusResult = ResponseStatusResult.Success };

            return objItem;
        }
        private ObjectPropertyDictionary GetBaseProperties()
        {
            ObjectPropertyDictionary objProperties = new ObjectPropertyDictionary();

            objProperties.Add("SubscriptionID", SqlDbType.Int);
            objProperties.Add("VendorID", SqlDbType.Int);
            objProperties.Add("VendorName", SqlDbType.VarChar);
            objProperties.Add("EmployeeID", SqlDbType.Int);
            objProperties.Add("Address", SqlDbType.VarChar);
            objProperties.Add("City", SqlDbType.VarChar);
            objProperties.Add("State", SqlDbType.VarChar);
            objProperties.Add("Zip", SqlDbType.Int);
            objProperties.Add("AccountNumber", SqlDbType.Int);
            objProperties.Add("BillingNumber", SqlDbType.VarChar);
            objProperties.Add("StartDate", SqlDbType.DateTime);
            objProperties.Add("EndDate", SqlDbType.DateTime);
            objProperties.Add("Paid", SqlDbType.VarChar);
            objProperties.Add("HomeAddress", SqlDbType.Bit);
            objProperties.Add("Notes", SqlDbType.VarChar);

            return objProperties;
        }