|
|
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 ... |
|
|
|