DotNetInvoice Forums

Besides adding fields in the web.config file is there any sample code or list of areas that need to be updated in order to properly extend the custom profile?

   <profile defaultProvider="CustomProfileProvider" enabled="true">
   <properties>
    <add name="first_name" type="String" defaultValue="[null]" customProviderData="first_name;nvarchar"/>
    <add name="last_name" type="String" defaultValue="[null]" customProviderData="last_name;nvarchar"/>
    <add name="company" type="String" defaultValue="[null]" customProviderData="company;nvarchar"/>
    <add name="telephone" type="String" defaultValue="[null]" customProviderData="telephone;nvarchar"/>
    <add name="email" type="String" defaultValue="[null]" customProviderData="email;nvarchar"/>
    <add name="website" type="String" defaultValue="[null]" customProviderData="website;nvarchar"/>
    <add name="dni_status_id" type="Integer" defaultValue="[null]" customProviderData="dni_status_id;int"/>
    <add name="address1" type="String" defaultValue="[null]" customProviderData="address1;nvarchar"/>
    <add name="address2" type="String" defaultValue="[null]" customProviderData="address2;nvarchar"/>
    <add name="city" type="String" defaultValue="[null]" customProviderData="city;nvarchar"/>
    <add name="state" type="String" defaultValue="[null]" customProviderData="state;nvarchar"/>
    <add name="country" type="String" defaultValue="[null]" customProviderData="country;nvarchar"/>
    <add name="postal_code" type="String" defaultValue="[null]" customProviderData="postal_code;nvarchar"/>
    <add name="notes" type="String" defaultValue="[null]" customProviderData="notes;nvarchar"/>
    <add name="account_number" type="String" defaultValue="[null]" customProviderData="account_number;nvarchar"/>
    
    <add name="email2" type="String" defaultValue="[null]" customProviderData="email2;nvarchar"/>
    <add name="email3" type="String" defaultValue="[null]" customProviderData="email3;nvarchar"/>
    <add name="telephone2" type="String" defaultValue="[null]" customProviderData="telephone2;nvarchar"/>
    <add name="telephone3" type="String" defaultValue="[null]" customProviderData="telephone3;nvarchar"/>
    <add name="first_name2" type="String" defaultValue="[null]" customProviderData="first_name2;nvarchar"/>
    <add name="last_name2" type="String" defaultValue="[null]" customProviderData="last_name2;nvarchar"/>
    <add name="website2" type="String" defaultValue="[null]" customProviderData="website2;nvarchar"/>
    <add name="website3" type="String" defaultValue="[null]" customProviderData="website3;nvarchar"/> 
    </properties>
   <providers>
    <clear/>
    <add name="CustomProfileProvider" connectionStringName="main" table="dni_clients" applicationName="/" type="SqlTableProfileProvider"/>
   </providers>
  </profile>

Adding the additional fields to the web.config and dni_clients tables are all that is required to add access to the additional fields in the code.  Below are some primary places in the code where the profile is accessed.  You'll only need to add your new fields in the places you want access to them.

account.aspx

admin/client/edit.aspx

admin/invoices/edit.aspx

admin/imports/clients.aspx 

--
DotNetInvoice Support
support@dotnetinvoice.com