Download Center
Case Studies
Small Business e-Management Suite
Printing Process Managment
SVG-Editor
DB Manager
About Us
Home
Case Studies

G-System Group works very closely with customers, Small & Emerging businesses, to meet their Software Development, IT Consulting and Technology Integration requirements. Our goal is to be your trusted partner that truly understands your business process and information technology needs.
  • Small Business e-management application
  • Printing process Solution
  • ERF Editor
Contents ...

Small Business e-Management Suite

Client for this application is a software company based in China. They provide wide range of services - application development and ecommerce to wireless development. They wanted a solution of its kind which can provide all the features of an online ecommerce business at low cost.


Client Requirements:

Our client wanted to provide a solution to their customers which gives full features of ecommerce in their hand. Customer can create his site with desktop application features and can manage his site with no programming knowledge. Solution should also provide search engine management and automated site creation, account management etc.

Our Solution:

Scope of this project was more oriented towards development of web based application which will contain features of a desktop application and which can be used to create and manage site without any technical knowledge. G-System Group designed system which can run on web-farm and can be run with remote servers. Webservices were used extensively for that. Some of the important features are :

  • Automated site creation and support for multiple sites
  • Customization support for each and every page of a site, creation of new pages from web based interface
  • Drag and Drop feature to incorporate asp.net controls in webpage and set properties like a desktop application
  • Content management
  • Creation of Ecommerce store with different payment gateways support
  • Shipping includes features like full shipping or partial shipping & shipping phase management, online shipping cost calculation for UPS shipping etc.
  • Search engine management which provides ranking reports
  • Web statistics management with different reports
  • E-mail marketing, e-mail campaign and its statistics, targeted marketing etc.
  • Account Management
  • Email account management / Email user management

Result:

System developed allowed client to get customers to subscribe and use system without any technology knowledge. Customers can create new pages and manage content / controls. Also, sites can be hosted at different location and can use web services to communicate with database and middle tier.

Statistics:

  • Backend : 45 databases, total 890 tables and 2400 stored procedures
  • Frontend : 630 aspx pages, 220 ascx controls, 734 classes, 28 webservices and 19 windows services

Architecute - Technology:

  • Delphi.NET, Javascript, SQL Server Database
  • 5-tier architecture
  • Image processing, GDI+
  • MIDAS, CORBA
  • Web-Services, SOAP, XML

Core Benefits:

  • Quick delivery of items to the customers as Purchase orders are generated online and shipping can be managed partially or fully with online shipping rate calculations.
  • Site available 24*7*365 for orders
  • Customer Satisfaction as the status of processing can be viewed
  • Easy management of products, categories and related products
  • Customers can add/remove and modify products to their shopping cart
  • Automatically generates and emails a Tax Invoice to customers
  • Complete Inventory Management
  • Payment Gateway Integration
Contents ...

Printing Process Managment

Our client based in Canada, provides printed stationeries, brochures etc. from multiple locations.

Client Requirements:

Our client provides printing solutions for small businesses to large corporate. In complicated printing service procedure, which requires ordering, proof creation, proof approval and order approval by different people, client realized that there was no proper control system to manage the workflow and order process automatically and it was delaying order processing. Our client wanted unique solutions to resolve these problems and reduce human efforts and errors.

Our Solution:

G-System Group provided solution with following features which reduced human errors and automated ordering to XML file generation tasks.
  • Employee accounts management for Corporate customers
  • Ecommerce store for stationary purchase by company employees
  • Online order placement, on the fly proof creation in JPG format and proof approval, order approval
  • Online stationary design
  • Print ready formated document creation with accurate details

Result:

This order-on-demand solution is usable simultaneously by multiple printers. A printer can have multiple customers managing their account in the system and a customer can manage multiple printers for different stationeries. It provided customers full control over their employee orders, control over stationary design and online proof approval with accurate result. Other hand, printers got benefited from order processing without any efforts and generation of ready to print PDF files uploaded to their server. Customers can also invite different printers to bid on their non regular printing material.

Statistics:

Backend : 1 MySQL database, 28 tables,186 stored procedures,6 views,10 user defined function
Frontend : 134 aspx pages, 18 ascx controls, 54 classes

Architecture - Technology:

Architecture - Technology:
  • ASP.NET, Delphi.NET, Javascript, MySQL Database
  • 4-tier architecture
  • Image processing, GDI+
  • .NET Remoting, COM+ Interoperatability
  • MDB SQL Services for reports

Core Benefits:

  • Purchase process moved to the users desktop
  • Simplified workflow and order process
  • Immediate proof approval in JPG, GIF or Bitmap format
  • Print Ready MDB format
  • Dealers can create and proof their own unique print jobs with variable data and graphics and printers can manage dealers
  • Faster Delivery
  • Greatly reduces the cost of errors & back order size
  • Program available 24*7*365 for orders
  • Guarantees enforcement of corporate identity and design standards
  • Provides for consistency of product, quality and price
  • Elimination of paper proofs and invoice
  • View order status and order history & all kind of reports as per the client requirement
  • Define user groups with ordering rights, product visibility and customization
  • Reduces the overall turnaround and fulfillment times
Contents ...

SVG-Editor

Our client based in Germany, is a leading provider of top technology pre-production CAM, archiving and engineering software solutions for the PCB industry.

Client Requirements:

Probably one of the most difficult and time-consuming actions during implementation of Genesis was the configuration of the ERF files. This was done by automatind editing system, using a MDB 3D Editor. SVG files contain different settings in different formats for Genesis. Biggest problem in above solution was, there were no real validations after SVG files were edited and thus process was error-prone since it required from the user indepth knowledge of all the SVG parameters, variables, ranges and actions.

Our Solution:

TheSVG- editor solved this problem by supplying an elegant method to view, edit and understand the different items that compose an SVG  file, with on-line help for each of the items, which should prevent the user to stroll to hundreds of manual pages in order to try and understand the meaning and consequences of his actions.

Result:

This solution helped quick configuration of product Genesis and removed errors with proper validations.

Technology:

DOM, ECMAScript, RDF

Example:


Requirements:
  • Figure: Red circle
  • Center: X=100, Y=100, R = 50
  • Color= Red

Generated SVG file:

1: <?xml version="1.0" encoding="UTF-8" standalone="no"?>
2: <!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.0//EN"
3: "http://www.w3.org/TR/SVG/DTD/svg10.dtd">
4: <svg xmlns="http://www.w3.org/2000/svg">
5: <title>Circle</title>
6: <circle cx="100" cy="100" r="50" stroke="red" stroke-width="2px" fill="none"/>
7: </svg>
Contents ...

DB Manager

Definition:

DB Manager is an integrated, programming environment for managing data base.

If we have to be more precise that could have hardly been called a definition because the product in its latest versions is also used as an Integrated Development Environment - IDE used in the creation of final applications.

What is the purpose of DB Manager:

First of all that is the possibility to explore, support the ability to modify and create Tables. It is even accepted that database can be taken as a number of tables which have certain logical or other types of connections in between.
A typical feature of the product is that even XML ( but not only that Document Object Model) can be looked upon and modified in the form of tables.

Let's try and give an example of what has been written down to the very moment:

Example:

If you have already worked with some of the office sets, which inevitably has made you use kinds of tables. Representing information in the forms of tables is easy to access and comprehend. Tables are mostly used when certain verifications or presentations are necessary.

This is a well-trained practice in some economic sectors but things are different in technical and scientific sectors.
Imagine that your task is to arrange all the constructive documents of a certain object which for example can be the new model of a press. That task would be much more difficult if the object was a car or a plane. In that case more text documents should be added (some technological maps, for example) as well as some constructive drawings and not only catalogue number, name, price, size and number.

You have to agree that is a difficult task takes a lot of time and human abilities.

Here come to help the mighty systems operating with bases of Oracle, MS SQL, DB2, InterBase, MS Access, dBase, Paradox and others which need some specialized knowledge. If you are not acquainted with relating databases in details and the way they work then you should seek consultants. That is necessary because the language of SQL which is responsible for managing the databases is a separate product having its own specific nature.

Let us take it for granted that you have enough knowledge of working with MS Excel or some other similar product. If you were in the possession of a program which would help you to edit the tables in databases in a way close to the way it is done with some electronic tables then your process of learning would have taken so little time and wouldn1t interfere with your working process.

It is often necessary to add to each record its accompanying graphic drawing or text documents. It is not that simple with the office packets and they also have another purpose of usage.

If your company is a small or medium one and it is working in the development or production sphere then DB Manager would replace successfully all the expensive systems of management and control of the processes and document turnovers.

In common words the basic purpose of DB Manager is to help you to operate the content of different data base no matter where they are located or what format they have.

The system has either good application for Microsoft Windows as well as for Linux platforms. DB Manager in its corporative versions can be also offered like versions for Novell and UNIX.

The test results can guarantee the equally high level reliability in every of the mentioned operating systems.
Contents ...
Copyright © 2003 G-System Group Ltd.
*  .NET Consulting and Development
*  Client - Server Applications
*  Complex Database Applications
*  Web Applications using ASP.NET, ASP, JSP, J2EE
office@g-92.com
support@g-92.com