This Admin Tool will only work with Commerce Starter Kit but it can be modified for IBuySpy Store application. Sorry this site is only implemented with C# and ASP.NET. VB.NET version is not available.
I have created this admin tool, which is 100% compatible with Commerce Starter Kit, but it can be modified to work with IBuySpy Store application. Very little database enhancement is required. I have added a column “Admins” to Customer Table. Default value is zero which means customers and if one then store admins. And also I have altered the tables to perform cascade update and delete. Customer cascade delete is not a good idea but I have implemented all the possible functionality into the Store Admin. I have used SQL statements as much as possible to avoid any database updates. These SQL statements can be replaced with Store Procedures for better performance.
This site is tested with .NET Framework 1.1, ASP.NET v1.1, Visual Studio C#.NET 2003, IIS web server 5.0 and SQL server 2000 on Windows 2000 server
Instruction for new Database installation
- Run CommerceDBScript.sql Query in SQL Analyzer
This will create Store Database tables, store procedures and etc.
- Run CommerceDBData.sql Query in SQL Analyzer
This script will add the data to the tables
- Create an ASPNET user account in the database and make sure to add this account to db owner
Instruction for Manual update of the Database
Note: Backup everything before you do any kind of modification within database. (I’m not responsible for any damage to the database and data loss)
- Manually add the “Admins” column to CMRC_Customers table, datatype should be “int” , make column default value to “0“, and make allow nulls unchecked. Add a data to Admins column “0” means customers, and “1” means admins. (see image)
- Alter Tables for Cascade update and delete
- Make sure you have ASPNET user account is setup in the database
CMRC_Customers Table Structure:
CMRC_Customers Table Data:
IIS web server setup
· Unzip the files to a CommerceAdmin folder from a CommerceAdmin.zip and make it virtual folder in IIS web server.
· In IIS web server go to folder property and convert it to application.
· Make sure you have read/write permission on ProductImages and ProductImages Thumbs Folders in IIS web server for a Commerce Starter Kit Site.
· Make sure ASP.NET account have read/write permission to ProductImage and ProductImages Thumbs folders (for upload functionality) with in Commerce Starter Kit site
If you do not have write permission to the folders then you will get the error by uploading images to the folder and upload will fail.
Web.Config setup for CommerceAdmin
In Web.Config file make sure ConnectionString is properly pointing to correct database.
To load a default Template the XMLTemplate key should be set to default template.
Images folder physical and virtual path should be set to locations.
<appSettings>
<add key="ConnectionString" value="server=localhost;Trusted_Connection=true;uid=sa;pwd=;database=Commerce" />
<!-- Cookie Name -->
<add key="CookieName" value="CMRC_Admin" />
<!-- Local Machine -->
<!-- Physical Image Path -->
<add key="ImageFilePath" value="C:/Inetpub/wwwroot/Commerce/ProductImages/" />
<add key="ImageFileThumbsPath" value="C:/Inetpub/wwwroot/Commerce/ProductImages/thumbs/" />
<!-- Virtual Image Path -->
<add key="VirtualImagePath" value="http://localhost/Commerce/ProductImages/" />
<add key="VirtualImageThumbsPath" value="http://localhost/Commerce/ProductImages/thumbs/" />
</appSettings>
About Zip file:
I have included in zip file: CommerceStore (original code), CommerceStoreAdmin, and CommerceStoreDB (Only C# version)
Demo Site:
Commerce Store : http://spystore.artisticode.com/
Commerce Store Admin : http://spyadmin.artisticode.com/
View source : http://spyadmin.artisticode.com/codeviewer/
Now login to admin site is allowed with limited access