Asp.Net/ Sql

1.1 Project Scope
Buyposters.com is an interactive site for users who want to buy posters over the net. This site is of use to users who want to service the posters available for sale with different types of frames, mats, and glass materials. There is a rich set of frames and canvases available for users to buy online. A user friendly view of the frame or canvas selected for any poster is shown to the users to make a clear understanding of final product before placing an order.

2.1 Client Requirements
Client want to develope a online shopping portal for selling posters using C#, and SqlServer-2000. He offers over 100 different frames and 150 mats in online frame shop. Once in the frame shop user should be able to use 3-step frame tool. Start by choosing a frame moulding. user can choose to view them by price, material, and color. If user clicks on the frame image the frame should be graphically rendered around the selected item.Next choose mats. Mats can be selected by color. Finally choose the type of glass user would like. client want to We offer canvas transfer services on many of the posters and prints. 3 options are available for canvas transfers. Canvas Transfer Only: Item is shipped rolled without stretchers. Stretch and Mount: Canvas is stretched and mounted on a custom made wooden frame backing. The canvas is wrapped around the sides and stapled to the wooden backing on the back (museum style mount). Transfer and Frame: Most all transferred prints can also be framed. No matting or glass options are available for framed canvas transfers. The whole site should be managed by superadmin with different rights to admins at different levels. There should be a proper time management for serviced items and non serviced items.

2.2 Our Approach
The whole site is devided into 2 parts

1. User Side
Displays different poster, frames, mats, glasses available for users to select. It deals with users registration, Authentication, shopping cart, search functionality, categorywise sorting, data filtering.

2. Admin Side
Admin part manages product managenment, order processing, Batch processing, Payment transactions, Shipping sizes management, database utilities.

3.1 System Feature 1
OObject Oriented Programming with class hierarchy is used to manage all database tables. Microsoft.net provides facility for creating custom components which are used in dynamic management and control of the site. Web User controls are created for common functionality through out the site.

Image processing was an important aspect of the whole site. Seperate module is created for managing image processing of frames and canvases. Service items images are created at run time for any frame or canvas selected for any poster.

Separate modules are created for Authentication, User registration,Order processing,Shipping Management, Shipping cost calculation. Variable shipping costs are calculated for different frames and canvas material.

3.2 System Feature 2
Sql Server-2000 is used as backend database. Sql Server-2000 gives optimum performance with Microsoft.net. Microsoft has written separate classes for Sql Server database interaction which helps in faster retrival of data from database. Sql Server supports stored procedures which are used throughout the site for data manupulation.

4.1 User Interfaces
This is an interactive site developed in C#.Net,Sql Server-2000 for buying posters online. Users can select different frames of different material,price range and color. Users can go for different canvases,mats, glass available with any image. They can stretch existing images to fit there requirements. They can view complete frame before placing an order. Creating frame view with different images, for different canvases was a crucial part of this project which involved lot of image processing work. Different shipping prices for products depending on there frames,canvas selections are calculated. Different sorting options are available for users to view data. Different custom controls were developed to easily maintain site. Database driven stored procedures were written to manage different database activities.

All posters are separated in different categories like Animals, Art, Celebrity Photos, College, Education, Fantasy, Flowers, Humor which are again devided into different subcategories. This helps users to reach their desired poster very easily. Search option helps users to search for any poster if they donot know posters categories and subcategories.

Search results can be filtered for different conditions like Min Price, Max Price,Width range, height range, Poster Type,Poster Orientation like Portrait, Landscape,Square. Results can also be sorted in different order like Alphabetical order, Newest Items, Most Popular items, Order by Price.

Every user must create an account with buyposters.com before purchasing anything from site. Creating an account helps users to track their orders for shipping. It also helps users in getting address details quickly. users will come to know about different schemes from emails and newsletters from buyposters.com

Different frames of different material,price range and color are available to create framed posters. Users can go for different canvases,mats, glass available with any poster. They can stretch existing poster to fit there requirements. They can view complete frame before placing an order.

Product price changes for every frame selected. frame details are also displayed in shopping cart.

Site Administration
complete site is managed by superadmin with full rights. Following image shows inventory management from admin side. Admin can filter the products by different suppliers available, dropshipped items, discontinued items. Admin can edit any product he want by selecting the checkbox in ID column and updating any of the columns he want. Admin can also export selected products in Excel or csv format. To add new products in database admin will upload a csv file in proper format to the server. The uploaded file will be processed on the server to add new inventory.

Database Updater Utility
It is always easy to take database backup in csv,excel format at regular interval. These files will be used as reference in future in case of any failures. Admin can also upload new data in csv,excel format. Admin has to set upload criteria before uploading any file to server.

Orders Management
All pending orders are displayed in Orders Management screen. Orders can be sorted on order status, services whether order items are serviced or not, different product types, suppliers for order items, payment types, shipping spots. Orders are clubbed together and batches are created. The idea is to group order items with common interest, like all serviced items will be added in one batch.

Batch Management
Every batch will be shipped after collecting payments from the users credit cards. Each batch will be assigned a tracking number given by shipping company. These tracking numbers will be emailed to customers to track there orders online.

Ready to Ship Items Management
This screen displays batch items which are ready to be shipped. Their tracking numbers are already assigned and emailed to customers.

Shipping Sizes Management
Shipping cost depends on product dimensions. products are differentiated into different sizes depending on their dimensions. Larger the product dimension higher is the shipping cost. Admin can edit any shipping size or add new shipping size.

4.2 Software Interfaces
Exceed component is used for zip, unzip utility used in database backup.
Payment integration with Authorize.net is done for orders and transaction processing.

2.1 Client Requirements
Client wants to create a primary Portal which works as a web interface for Video Conferencing Service business. Companies / Individuals interested to use these services can register here and use the system or get services. Users should be able to create meetings, send invitation to all whom they want to invite in conference, set payment mode for conference i.e. Host pays or Individual user pays. If host paid all charges all users should be given free entry in conference The conference server works on the concept of number of users at any time in conference. Client bought license for 500 users for one year. Client want to create agents/ Partners who will buy license for fixed number users(20,50,100) from client and sell services to other users. The entire web interface and payment processing facility will be provided by client. The partners should be able set their own domains or use the default provided by client for promoting services, they can select any predefined template for there own portal . Partner can also create their partner for promoting services. Partners are given commission already agreed between client and the partner for promoting services Users have to pay charges for using the conference services. They can buy registration package and get discount on conference charges. Partners are allowed to increase rates for conference charges for users on there own portal. There is a set of rules the partners must follow before setting there rate for different things. The rates set by any partner should be above those set by Superadmin. More is the rate set by partners more is there commission. MPO can sell services to SPO and receive commission from MPO. The commission given to SPO will come as a percentage commission MPO receives from Super Admin Whenever any user visits partners domain or portal all setting related to that partner should be automatically set in the site. It should display partners logo, his address details, contact details as if the site belongs to partner with no reference to main site from client. All communications with users should refer partners details. Partners should be able to change all the required things from admin side.

2.2 Our Approach
The site development is divided into two parts

1. User Side
User interface part which provides all the functionality to create conferences, user registration, partner registration, shopping cart , product display.

2. Admin Side
Admin Interface for displaying all types of reports and site management for Super admin and partner portal owners.

2.3 Technology Used

3.1 System Feature 1
Object Oriented Programming with class hierarchy is used to manage all database tables. Microsoft.net provides facility for creating custom components which are used in dynamic management and control of the site. Web User controls are created for common functionality through out the site.

Following broad modules are created for smooth management of the site.

Conference Management Module
Conference module has all the functionality of conference management on the conference server. All the XML web service API’s are called from the conference module. It processes all the data from XML response and displays in proper format to users.

Conference Details Module
This module manages all the conferences created by any user in the system. Maintains details of conference like conference date, start time, end time, number of users in the conference, conference type whether host pays or individual user pays for his conference time. If Host is paying for conference all the conference participants should be allowed free entry to conference.

Template Module
Whole site is run on template. There are different templates to be loaded dynamically when any user logs in. All the templates are stored in a common folder. Cookies are used to store the current template name for any user. Portal owners can change the template anytime they want. Custom controls are created which loads any template at runtime.

Cookies Module
Cookies play an important role in smooth functioning of the site. Separate module that takes care of all cookies is created. Different cookies stored in site are user details cookies, Current portal owner details cookies, template cookies, affiliate cookies etc.

Payment Processing Module
All the payments from partners, affiliate, and site will be collected by super admin. He then distributes commissions to all others involved in the business. Payment integration with authorize.net is done for online credit card processing.

Commission Module
Super admin collects all money through out the site and give away commission to all at a agreed percentage. Even the commission distribution for affiliates of any partner is done by super admin. Commission amount to be given to affiliate of Partners will be computed from the commission given to partners. Commission will be calculated in a drill down manner like Admin -> MPO -> SPO -> Affiliate i.e. first of all commission will be calculated for MPO. From this commission MPO gives commission to SPO, from this commission SPO gives commission to Affiliates.

Emails Module
Emails are sent throughout the sites at different stages. All emails are dynamically generated using different templates. Emails module will read the template and format is to send emails to any user or partner.

Other Supporting Modules
Other supporting modules includes users registration and authentication module, product inventory management module, shopping cart module, order processing module, shipping cost calculation, Reports generation.

3.2 System Feature 2
Sql Server-2000 is used as backend database. Sql Server-2000 gives optimum performance with Microsoft.net. Microsoft has written separate classes for Sql Server database interaction which helps in faster retrival of data from database. Sql Server supports stored procedures which are used throughout the site for data manupulation.

4.1 User Interfaces
Home Page

Users account Management page in Yellow Template

Users Time Account Package Purchase screen in Green Template

Conference Creation screen with White Template

Meeting Invitation Toolset with Red Template

Email Invitation Preview

Customized Contact Us Information For portal owners.
Any portal owner can change the information to be displayed in Contact Us tab to his liking. The information should be properly formatted in html form to make a presentable view.

Customized About Us Information For portal owners.
Any portal owner can change the information to be displayed in About Us tab to his liking. The information should be properly formatted in html form to make a presentable view.

Shopping Cart

Shopping Cart processing Screen

Affiliate Home Page

Meeting Minute Purchase Screen

Conference Meeting Details Screen

Conference Entry Screen. Enter conference participant code and join conference as a participant.

Site Administration
Complete site is managed by superadmin with full rights.
Portal Owners Admin Section

Registered Users List

Conference Package rate Setup

Commission Rate Setup

Product Setup from SuperAdmin side

Commission Reports
Any admin can see commission reports for him and his descendants. Select the commission type, Month and Year and click Generate Report. This shows you commissions for all the users in selected category

Commission Calculation Report
Monthly account report which shows Superadmin all the account heads for profit and loss. This report displays all the accounts from where money is generated and accounts where money is spent. A clear cut report that shows the profit generated in any month. Just select the Month and year and you get a details of all accounts in that month.

Reports Generated
Following is a brief list of all the reports generated from admin section.

ChargeBack section
For any chargeback Superadmin will add chargeback entries through this screen. The chargeback amount will be deducted from commission amount of the user responsible for chargeback.

4.2 Software Interfaces

E/pop Conference server Product Overview
In e/pop conference server the entire video conferencing session sends all traffic via the e/pop server. Since this server is at a fixed IP address, and uses port 80 and http, it achieves high levels of proxy and firewall compatibility, plus provides the foundation for multiparty desktop video conferencing! Wired red has given some xml API using which one can communicate with Conference server from outside. Using these API one can create new meetings, start any meeting and allow member to join any meeting, end any meeting.