Page 1 of 1
Adding Store Email and Phone Number to Invoice
Posted: Wed Jun 15, 2016 9:45 am
by skinsfan99
We would like to add the Store's email and phone number to the invoice. In the invoice.aspx file I find this line of code:
<span class="inlineCaption"><%#AbleContext.Current.Store.Name%></span> - this displays the store name.
<%# AbleContext.Current.Store.DefaultWarehouse.FormatAddress(true) %> - This formats and prints the street address, city, state, zip and country.
I am assuming the next lines would be something like:
<span class="inlineCaption"><%#AbleContext.Current.Store.Email%></span> - email
<span class="inlineCaption"><%#AbleContext.Current.Store.Phone%></span> - phone
Are these variables available for the store and are these the correct names.
We are looking to bring some of the custom coding in house. What version of Visual Studio will we need?
Until we get Visual Studio installed is there a reference available to show me what fields are available in the database?
Thank you
Re: Adding Store Email and Phone Number to Invoice
Posted: Thu Jun 16, 2016 12:43 am
by mazhar
I am assuming the next lines would be something like:
<span class="inlineCaption"><%#AbleContext.Current.Store.Email%></span> - email
<span class="inlineCaption"><%#AbleContext.Current.Store.Phone%></span> - phone
It would be like this where you will have to get Email and Phone from Default Warehouse
Code: Select all
<span class="inlineCaption"><%#AbleContext.Current.Store.DefaultWarehouse.Email%></span> - email
<span class="inlineCaption"><%#AbleContext.Current.Store.DefaultWarehouse.Phone%></span> - phone
Until we get Visual Studio installed is there a reference available to show me what fields are available in the database?
You can download the documentation file from following URL. You may have to unblock the chm file to view its content in windows. Just right click on chm file and then from properties unblock it.
http://www.ablecommerce.com/docs/Commer ... erGold.chm
We are looking to bring some of the custom coding in house. What version of Visual Studio will we need?
You can use Visual Studio 2015 community edition which is free.
Re: Adding Store Email and Phone Number to Invoice
Posted: Tue Jul 12, 2016 10:48 am
by skinsfan99
Mazhar,
Thanks for the information.
I forgot to ask but what version of MS SQL would we need to have installed to be able to create tables, stored procedures, etc?
Thank you,
David
Re: Adding Store Email and Phone Number to Invoice
Posted: Tue Jul 12, 2016 9:50 pm
by mazhar
Here is the information about software requirements
http://help.ablecommerce.com/installati ... ements.htm
A new (empty) Microsoft SQL database for data storage.
The following versions are supported:
SQL 2012
SQL 2008 R2
SQL 2005
SQL 2005/2008 Express**
SQL 2012
** Microsoft's SQL Express is a free, easy-to-use, lightweight version of SQL Server. Download
Re: Adding Store Email and Phone Number to Invoice
Posted: Thu Jul 14, 2016 7:18 am
by AbleMods
Mazhar has anyone tested Able Gold on SQL 2014 or SQL 2016? Seems like the supported SQL versions could use a little updating....
Re: Adding Store Email and Phone Number to Invoice
Posted: Thu Jul 14, 2016 8:22 am
by Katie
I'm pretty sure it runs on SQL 2014, but I'm not sure about SQL 2016. SQL compatibility has never really been an issue. I think the only time we had to write separate code was between SQL 2000 and SQL 2005.
And yes, it does look like we need to get those updated. Where does the time go...
Thanks
Katie
Re: Adding Store Email and Phone Number to Invoice
Posted: Thu Jul 14, 2016 8:32 am
by AbleMods
SQL 2016 just came out. I never even saw anyone using SQL 2014.
Re: Adding Store Email and Phone Number to Invoice
Posted: Thu Jul 14, 2016 11:36 pm
by jmestep
My local development sites run fine on SQL Server 2014.