IMPLEMENTATION

4.1     Introduction                        

The tool used in the development of “Sale Supply Application” is SQL Server at the backend. For front end for window base application we use C Sharp. Besides these tools we have used the number of other CASE tools (Photoshop, Coral Draw, and Icon Maker, CSS, HTML).

4.2    Microsoft SQL Server

A database is a structure that comes in two flavors a flat database and a relational database. A relational database is much more oriented to the human mind and is often preferred over the gabble-de-gook flat database that is just stored on hard drives like a text file. SQL Server is a relational database. In a relational structured database there are tables that store data. The columns define which kinds of information will be stored in the table. An individual column must be created for each type of data you wish to store (i.e. Name, Contact No, and Email).

On the other hand, a row contains the actual values for these specified columns. Each row will have 1 value for each and every column. For example a table with columns (Name, ContectNo, Email) could have a row with the values (Ilyas, 03335875101, ilyaskhan366@yahoo.com). If all this relational database talk is too confusing, don't despair. We will talk about and show a few examples in the coming lessons.

Databases are most useful when it comes to storing information that fits into logical categories. For example, say that you wanted to store information of all the employees in a company. With a database you can group different parts of your business into separate tables to help store your information logically. Example tables might be Employees, Supervisors, and Customers. Each table would then contain columns specific to these three areas. To help store information related to each employee, the Employees table might have the following columns Hire, Date, Position, Age, and Salary.

4.3 C Sharp ^[3]

4.3.1 C# Introduction

C#(pronounced “C-sharp”) is object-oriented programming language from Microsoft that aims to combine the computing power of C++ with the programming ease of Visual Basic. C# is based on C++ and contains features similar to those of Java. It is designed to work with Microsoft’s aims is to facilitate the exchange of information and services over the Web, and to enable developers to build highly portable applications, C# simplifies programming through its use of Extensible Markup Language (XML) and Simple Object Access Protocol(SOAP) which allow access to a programming object or method with our requiring the programmer to write additional code for each step. Because programmers can build on existing code, rather than repeatedly duplicating it, C# is expected to make it faster and less expensive to get new products and services to market.

The following table summarizes the C# versions with year and features.

Version	Year	Features
1.0	1999-2002	Modern, Object Oriented, Simple, Flexible, Typesafe, Managed, Garbage Collection, Cross-platform
2.0	2005	Generics, Anonymous Method, Partial Class, Nullable Type
3.0	2008	LINQ, Lamda Expression, Extension Method, Anonymous Type, Var
4.0	2010	Named and Optional Parameters, Dynamic Binding
5.0	2012	Async Programming

Table 1.2 Summarizes the C# Versions with year and Features

4.3.2 C Sharp – Features?

It is also helpful to think of C# in terms of what it can do for you.C# will allow you to

• Reduce the time to create large windows Application.
• Add source code in the form of .dll which help in Design and also source code.
• Build-in Tools Provide for designing.
• Every Tools and Properties and Event which is also help to reduce our code.
• Build-in plug-in are available which help for connection with server. i.e with Sql Server.
• Easier IDE. 

4.3.3 Basic Understanding:

Before starting this tutorial it is important that you have a basic understanding and experience in the following:

• C# console screen programming Basic and also basic Syntax.
• Visual Studio IDE basic.
• Basic programming knowledge.
• SQL Server basic Syntax means how to create table, relationship, what is ERD.

4.3.4 Data types

• Integer
• Character
• Float
• String
• DateTime

4.4     ICONION

ICONION is software which is widely use for Icon Generator. So we use this software for icon because this is very easy and also provide built-in icon.

Iconion Icon Generator:  Icon fonts are an exciting method that gives web designers the scalability, flexibility, and performance to manipulate the icons. But what if you need to use these icons in a desktop or mobile application? Or create a website favicon or multi-colored icon?  The only answer is old-fashioned image icons in png or ico format. Iconion converts your favorite icon fonts to modern, colorful image icons.

What you can do with Iconion? Select icons from Font Awesome, Entypo, Linecons, Typeicons and any other symbol fonts you like. Save as png, bmp, jpeg or ico files. Select any size, no matter 8px or 1024px, the images will be of the same crisp quality. Add style: Icon color, Icon shadow and Icon long shadow, Gradient, Stroke, Icon rotate, Background, Background color, Background gradient, Background shadow, Background border, Rotate.  Or just apply one of awesome pre-made templates!

Which icons you can create with Iconion? Flat icons, round icons, square icons, long-shadow icons, Windows 8 icons, iOS icons, Mac icons, custom social media icons: facebook icon, twitter icon, google plus icon and many more...

4.5     HTML (Hyper Text Markup Language)

HTML is a language for describing web pages.

• HTML stands for Hyper Text Markup Language
• HTML is not a programming language, it is a markup language
• A markup language is a set of markup tags
• HTML uses markup tags to describe web pages

4.6 CSS (Cascading Styling Sheet)

CSS is a style language that defines layout of HTML documents. For example, CSS covers fonts, colors, margins, lines, height, width, background images, advanced positions and many other things.

HTML can be difficult to used  add layout to websites. But CSS offers more options and is more accurate and sophisticated. CSS is supported by all browsers today. There are three types of style sheets

• Inline Style Sheets are used in separate lines
• External Style Sheets can save a lot of work
• External Style Sheets are stored in CSS files

4.7 Coral Draw

Corel Corporation developed and released a software program called Corel DRAW, a vector graphics editor. The software is a robust graphics suite, providing many features for users to edit graphics. These features include contrast adjustment, color balancing, adding special effects like borders to images, and it is capable of working with multiple layers and multiple pages.

CorelDraw was originally released in January of 1989, running on the Windows 2.x operating system. Today, the software is still used by many people, with the latest version, X6, being released on March 20, 2012. Corel DRAW is primarily designed for the Windows operating system. There were several releases for Mac OS and Mac OS X, but poor sales resulted in the discontinuation of those versions. There was also a port to Linux in 2000, requiring a modified version of Wine to run the software.

We use Coral Draw for backgourd , logo and form other effect which necessary, in our project.

4.8   Adobe Photo Shop

Adobe Photoshop is a graphics editing application popular for it is extensive amount of features. Photoshop is also, currently, the leading graphics editing application.

Adobe Photoshop is hands down, the most popular program for creating and modifying images for the web and Desktop application.

There are many versions of Adobe Photo Shop but here I used Adobe photo shop CS6 version, because it is required very small amount of space in hard drive, and it is very easy to use.