Integration of Digital Document in ASP.Net

Redemption Automation System (RAS)
Loyalty Relationship Program

Industry:
Relationship Marketing

Technologies:
ASP.NET 2.0, SQL Server, VB.NET 2.0

The purpose of this project is to develop an enterprise automation system to support our client's business needs as followings:

Efficiency:
1. Manage merchandises (rewards) offered on various service platforms.
2. Collect redemption orders submitted from various service platforms.
3. Provide an online merchandise catalogue to potential customers.
4. Automation of Purchase Order generation and integrating it with the existing Purchase Order generation if one is existing

Tracking:
1. Track the status of the redemption orders
2. Keeping track of all the changes in the product detail eg. The price changes which will help in generation much more accurate reports generation or discounts offered on bulk purchases.

Control:
1. Managing the vendors who supply the redemption items.
2. Centralized management of redemptions
3. Generation of various reports for  DSS for the management
Provide a short description of the business objectives of the project

Vehicle Inventory System
Software Service Company

Industry:
Automobile

Technologies:
C#.net & SQL 2005

This is a comprehensive and informative website that provides various features to be availed by auto dealers. On having a valid account with the system a
dealer can avail a number of services and use them to his advantage. This web site is used to promote the New and the Used vehicles for pre sales activities. One can upload the data related to the vehicles along with their photo graphs etc on to the website. Each dealer will have its own set of vehicles added up on to the site. It has functionality to show different clips of the vehicles with background music etc. Mindfire was involved in adding additional features on the site and maintaining the website.

Chrome VinDecoder
Software Service Company

Industry:
Automobile

Technologies:
C#.net & SQL 2005

This involved the development of the web application that would accept the VIN number from the end user and would decode it and display all the Vehicle related information on the webpage. It uses the Chrome data (its a company that provides vehicular data information)at the back end to decode the VIN number from. It populates various sets of information's like Engine data, Fuel data, Interior, Exterior, Standard features, Mechanical Features etc of a vehicle. An end user can use this Vindecoder to decode a VIN number to extract all the data and get to know all the standard and technical features of a vehicle.

Sales Force Commission System (SFCS)
A Leading Insurance Company

Industry:
Insurance Group

Technologies:
Visual C#, .Net 2.0 framework, Crystal Reports 10, JavaScript, AJAX and SQL Server 2005

SFCS is a web application for internal use, which has been used for calculation of commission for agents. Monthly transactions get imported to the application to calculate commission for agents. Application is equipped for generating commission statement for each agent in PDF format. It also generates the financial transactions which get transferred to the accounting system.



For branch managers of special locations, a new kind of remuneration is added on top of the normal remuneration the BM gets. The calculation includes initial commission and clawback. We have also implemented the logic to split the commission as per the payment received from the customer against the policy.

Car Fax Decoder
Software Service Company

Industry:
Automobile

Technologies:
C#.net & SQL 2005

This involved the development of the web application that would accept the VIN number from the end user and would decode it and display all the Vehicle related information on the webpage. It uses the Car Fax data(its a separate company that provides vehicular data) at the back end to decode the VIN number from. An end user can use this Car Fax decoder to decode a VIN number to extract all the data and get to know all the features of a vehicle like Year , Make , Model , Price etc.

This needed us to completely understand the CarFax data structure to decode the data from the specific set of tables and populate them up.

Content Management System
Magazine Publishing Company

Industry:
Print Media

Technologies:
VS 2005 (VB.net) & SQL Server 2000

This project involved the development of an online CMS website for a weekly music magazine.It's a database driven website with Interfaces developed to
edit the content of the weekly Issue of the magazine.One can upload and edit the contents of the various sections of the magazine.As the weekly magazine gets launched the contents get updated with pictures and content of the latest issue. It has separate set of Users like Member, Promoter, Stockiest etc who have accessibility to different parts of the website based on their permissions. SQL Stored procedures have been used exclusively to handle various database operations.

Online Travel Website
Software Development Company

Industry:
Travel & Tourism

Technologies:
Asp.net & MS Access

This project involved the migration of an existing website in PHP and MY SQL to be migrated into ASP.Net and MS Access.This is an online travel management solution which can be used by end users to locate eco friendly destinations and plan their travels to those places. It also had an E-Shopping solution integrated into it as well with payment option integrated with a payment processor. Mindfire was involved in developing both an Admin and User interface.

Auto Notify System
Live Music Listing

Industry:
Music & Entertainment

Technologies:
ASP.Net 2.0, C#.net & SQL Server 2005

Mindfire was  involved in the development of an Auto notify email module for the project. It involved the development of a module called General User (GU's) that would register on the site and select 'Acts' (Artists) to be added to its Notify List. There are 2 kinds of e-mails that are sent out automatically through the system, (1)Daily – notice of new events added to the calendars of "Notify Me Acts". When an 'Act' adds an event to its calendar, the next morning an e-mail is sent to all GU's that have the 'Act' in its 'Notify Me Acts' announcing the new event. (2)Weekly – a newsletter type e-mail goes out every Monday morning that lists all the events for "Notify Me Acts" in the next 10 days.

The entire functionality is implemented using Client Postback (ICallBack event handlers).

RSS Feed Module
Live Music Listing

Industry:
Music & Entertainment

Technologies:
C#.net & SQL Server 2005

Specific type of users with accounts will have the option of creating "my feed", which will have essentially similar content to the e-mail alerts they would receive. On each individual Act page there will be a link for "my feed" which will include the same data as the email body has. All feeds be funneled through FeedBurner.com. They are the industry leader by far in making feeds readable and measurable.

Blogger System
Live Music Listing

Industry:
Music & Entertainment

Technologies:
C#.net & SQL Server 2005

A specific type of users with accounts will have the option of adding comments against the individual Acts. When any user visits the Acts page they will be able to see all the comments that are there added to the corresponding Act. The User name will be a link. Clicking on User name takes to the User Profile page that shows the last updated 10 comments of that specific user. The entire functionality is implemented using Client Postback (ICallBack event handlers).

Golf Club Management System
Information Systems Solutions Provider

Industry:
Sports

Technologies:
ASP.Net 2.0, VB.Net, SQL 2000 and Crystal Report 10.0

This is a public Internet application developed for a private Golf club offering the public golfers the golf loyalty and reward programs. It deals with nine (9) different kinds of roles.

The program involves membership cards, for which monetary transactions are done using Authorize.net. It also involves shipping of gifts/cards for which cost calculation is done using UPS.

The application uses Windows Services running daily on the Web Server for different internal activities. The system also provides a complete reporting facility and mail sending functionality. The Admin's Lookup Maintenance module is implemented using AJAX (ICallBackEventHandlers – Client Post Back). The application provides interface to read CSV data and export it to SQL database.

Mindfire was involved in design, development and maintenance of the entire application.

Work Process Management System
Information Systems Solutions Provider

Industry:
Manufacturing & Service Industries

Technologies:
ASP.Net 2.0, VB.Net, SQL 2000, Oracle 9i and Crystal Report 10.0

This is an intranet application with multi-lingual and multi-database support, which is designed to facilitate and organize the transformation process of building a high performance organization. The software keeps track of relationships and organization of the performance objectives, priorities, problems, projects, etc. allowing users to navigate through the related forms with ease. It has a detailed reporting feature for all the modules and is tailored to provide information on overall efforts/work flow inside the organization.

POS Reporting System
Software Services & Solutions Provider

Industry:
Food & Beverages

Technologies:
ASP.Net 2.0, C#.Net, AJAX 1.0 FrameWork, SQL 2005 and Crystal Report 10.0

Mindfire developed the entire reporting system module. The requirement was to get the data files in form of MDB files from stores and get the data migrated into the SQL 2005 database server from where the reporting system will be using them to generate the reports. This involved writing windows service that will poll the store manager PC for the daily  MDB file and  then  pick up the file and upload it on to the centralised server. Once the MDB file reaches the centralised server it will be picked up by another windows service running on it that will parse and then migrate the data into the corresponding SQL server 2005 database. The reporting web application would then access these migrated data and generate the various reports that are there. All the reports are accessed based on the different  user roles  set in the system. There is also an admin interface to maintain and as well upload the MDB files manually incase the automated process fails.

Dynamic Content Management System
Full-Service Internet Company

Industry:
University / School Sports Website

Technologies:
ASP.NET 2.0, C#, Flex, Json, ActiveRecord, Nhibernate, MVP Architecture, VS 2005, MySql & Win XP

It is a content management system based web application & the purpose of it is to manage all the university level games (like Football, Baseball, Basketball etc.) i.e. Scheduling their fixtures, their Results, Team & User Management, Blogs, Polls, Article creation etc. Main Features are: SiteMap Management, Menu creation, Membership & Role Management, Article creation, RSS feed, Real Time Weather Display, Poll creation, Blogs Management, File Upload, Article Creation & their editing, displaying and linking.

Web Invoice
Oil Supplier Company

Industry:
Oil & Refinery

Technologies:
VB.Net, SQL Server 2005, JS, AJAX, Encryption using MD5 algorithm

Requirement was to develop a user friendly  secured Website to view the invoice and Draft detail's according to the user's login.The site basically has two types of user.General User & Admin.

The data previously processed and pushed into the Database by a windows service application are mapped to specific user by Admin. User's have valid login credentials allocated to them to view their specific data.

Once logged in the user has different search options to view their invoice related data.Admin can create/ edit / delete users and map them to a specific company. Admin have the option to set different setting as alert email format and invoice view format in the setting section as well.

For making data on the website more secure, some of the data elements are decrypted before being viewed on the web pages. Extensive use of stored procedures/ views and functions have been used to pull data from the database and populate them on the web pages.

AJAX  1.0 is also being used to avoid refresh of the search result pages.

Also the site has options to generate HTML and PDF reports on user's request for the selected data. Generated reports can also be emailed according to the users request. Each activity of an user is tracked for later view by the system admin and generate log files as well.

Online CMS System Weekly Magazine
Magazine Publishing Company

Industry:
Media & Entertainment

Technologies:
VS 2005 (VB.net), Ektron CMS400.Net & SQL Server 2005

The requirement involved the porting of an existing CMS system [developed in VB.net 2.0 & SQL 2000] into Ektron CMS400.Net. The data for the existing CMS system residing in SQL 2000 was migrated to the CMS content database [SQL 2005]. A parser was developed in VB.net to read data from SQL 2000 and push data to the Content Database. Smart Forms were used in the process to push data to the content database.

The new CMS site was developed from scratch based on the new templates designed and involved the usage of all the latest features available with the Ektron CMS400.Net. All the WebPages were organized in a well customized manner so that the admin can directly open each and every page without moving into CMS work area and edit any content on that page itself. Every content populated on the WebPages were associated with document [word / html] that was residing in the content database of Ektron. While uploading the document/ data inside the Ektron CMS environment, the admin can add Metadata, Teaser text, descriptions, associated image etc. to the related content. All these related data gets populated with the content when the respective item is being browsed for in the front end by end users.

List summary and Content List server control was exclusively used for managing and editing the contents including images and data.

Flexible Menu Server control was used to implement the dynamic menu control on the website.Using the Ektron CMS400.Net Metadata features Menu control was dynamically populated. The search / advance search functionality was implemented efficiently to populate results based on keywords being searched for. Taxonomy logic was maintained inside Ektron CMS work area for improving the search functionality.

For site navigation we have implemented Breadcrumb features using Breadcrumb and Folder Breadcrumb Server controls. Content rating feature for each and every document which were published on the website were accomplished using Content Rating and Content Review Server Control provided in Ektron CMS400.Net. XSLT was also used for displaying the rating star image.

Also there was a module which involved the development of Discussion / Community Board. The Discussion Board Server control was exclusively used for this purpose and was customized as per the requirements to have the custom look and feel. Content Block server control was also used to manage and upload documents.

There was a member module developed which allowed registration of new members and Log-in facility of existing members. This was completely implemented using the Ektron CMS400.Net API's. 

Cab Scheduling Software
Tours & Travel Agent

Industry:
Tourism

Technologies:
ASP.Net 2.0, C#.NET, MS Access 2.0/3.0, XML

The scheduling software is used basically to schedule a manifest of trips each day for a cab company and assign its drivers to the specific trips. It takes .dbf file and .txt file as its input. User provides Original Unscheduled Manifest .dbf file and Driver availability text file as inputs. The application then checks for each unscheduled trip and the available drivers.Assign trips to available drivers only, which satisfy the set company conditions. The drivers are assigned based upon a sequence. The sequence order changes everyday. The application then check the timing constraints, maximum number of trips to be assign to a driver. It also determines the distance between zones for each trips and analyzes which trip should get a trip based upon the distance conditions. It contain an adjacency matrix file which gives the distance between two zip-codes.The application checks whether pick-up for a trip is in the same zone in which the driver ended the previous trip OR if it is the driver's first trip OR if the pick-up is in the same zone as the home zone for the driver in Driver avail file. If any of the conditions satisfies, it assign the driver to that trip. If a trip is still not found, then it will relax the restrictions and assign to a driver a trip that is a distance 1 mile from the previous trip's drop-off zone. If this still cannot be achieved, relax the distance restriction to 2 miles and so on. Continue like this upto a specific value. Finally it give the user an option to download the final scheduled text file generated.

Then this final scheduled text file in turn is used as an input to an Ms Access report application to allow the user to generate and print the report in vehicle number wise. This report is finally used to assign and send drivers for the trips.

It also contain login functionality for admin. Admin have the control to allow user to use this site. Those IP addresses that are recommended by admin can only access this site. Admin can add/ reject an IP address.

Online Customer Pricing
Oil Supplier Company

Industry:
Oil & Refinery

Technologies:
VS 2005 ASP.NET(VB.NET) & SQL 2005

The project involves creating a website to be used by the customers to view their current pricing,creating CSV files for the invoices and upload or email the same.

Administrators of this website are able to create multiple price sheet using an online web form.The data on the website is secure and customers must only
have access to their own data and not have the ability to view the data of other customers. Complex calulations are involved in deducing the current price from the available set of data.

The project has some modules like manage user account, view and search invoices and maintain prices.Html reports are used to display the invoices and prices.

Bugs Website
Games WebSite Client

Industry:
Information Technology - Testing.

Technologies:
ASP.NET 2.0, C#.NET 2.0, AJAX,  SQL Server 2005, SQL Server Free Text Search, ASP.NET Web Service, Hansoft

This is a web application designed to mainly help players having an active subscription on our client's game server to report bugs, help other external partners and staff to process the bugs and act upon them. It is the web interface to the Hansoft defect tracking system which is used by the staff to manage defects internally. Users can perform various actions on the bug reports and the status of the bugs can be tracked since their birth.
Major components of the system include the Bugs Site application which manages all the bug reports data, Defect Tracking system Hansoft which manages all the defect data and the Authentication Web Service which manages all the user account. The Bugs Site application interacts with the secure authentication service to authenticate all users who access the site and interacts with the Hansoft application using the Hansoft SDK to access all the defect data.

The key challenges in this project include the integration of three systems called Bugs Site Application, Authentication service and Hansoft, providing localization and internationalization support, providing cross-browser support, providing a search based system across data stored in multiple languages, implementing user-friendly customizable reports showing various statistics by time periods, making the UI as dynamic as possible for the Bug site admins can edit the UI text description and column names etc, implementing a auto- email feature with a dynamic email content to update a user when there's a status change in the Bug Report submitted by her also we provided options to save the user's search queries and to use them at a later time just by selecting from a drop-down.

NetSuite Integration
A Services Compnay

Industry:
IT Consulting

Technologies:
ASP.NET 2.0, C#, WebService, AJAX Web Extensions, AJAX Control Toolkit Library, MySQL, NetSuite

This is a web based integration system that interacts with the NetSuite ERP through their webservice and helps clients to upload their inventory, employees, customers, Kit Integration Items, non-inventory resale, non-inventory purchase, service sale, service resale, service purchase, other charge sale, etc. The items are sent in bulk CSV or excel formats and the application parses them, recognizes them and sends them to appropriate account in NetSuite®.

Email Ad Builder
Service provider for auto dealers

Industry:
Automotive Industry

Technologies:
C#.net 1.1, JavaScript, CSS , ICSharpCode.SharpZipLib.dll

This is a web based tool that enables car dealers to directly send data including vehicle photographs to Ad-agencies.

The user has option to select about 10 vehicles from the grid form and on submitting they enter into Email Ad Builder form and provide minimum information's to send mail.On clicking the submit button the system will prepare a directory for each selected vehicle with photos and text information about that vehicle including the custom field information's from grid. It then prepares a .zip archive from the directories and sends it as an attachment in an email to the destination address entered.

Finally the temporary zip file and directories are removed from the server's file system. Here the SharpZipLib library have been used to achieve the Zip files creation functionality on the server.

Project Tracking System
Software Services

Industry:
IT Services

Technologies:
Visual Basic6, VB.NET, SQLServer 2005

The System developed is used for tracking projects, time and expenses quickly and easily for maximum profitability. It is used by different industries like IT Service, Healthcare, architects designs, automotive etc. This system is perfect for professionals, workgroups and enterprises who want to track time, projects, expenses, and knowledge. The main part of this project is as follows.

The main task was to migrate the System from VB6 to VB.Net and the database which was in Access was migrated to SQL Server 2005. But prior to migration we were involved in increasing the efficiency of the existing software as it was slow in displaying data and formatting of data.

For improving the efficiency of this project we have done some changes which are as follows.

1 : We have written stored procedures for this project.

2: We have done some major changes in the code written previously.

3: We have written triggers for this project.

For example before the changes, the data populated in Flexgrid took 81 seconds and after the changes it took just 18 seconds.

Currently we are working on writing Macros for this System to generate correct/formatted Pivot Tables out of single Excel Sheet.

Youth Social Networking
Tangerine Digital Entertainment

Industry:
Entertainment/Media

Technologies:
ASP.NET 2.0, C#, SQL Server 2005, XML

A social networking site for youngsters in colleges and universities to showcase their talent to the world. It is a platform for the young and the creative. The brand promotes new talent, connects talented and creatively inclined people and is a mouthpiece for the young audiences of the country.

Various Features:

-Users can create their profile and add details about their talent.

-Users can add their college/universities as campus and invite their batch mates to become member of the networking site.

-Users can upload their music, videos and photographs to the website and share them with the world.

-There is a facility of virtual room on the site which the user can customize just like his/her own real room.

-The site hosts various talent contest online which the user can participate and win prizes.

-The site has a juiceboard which with latest news and articles for users.

Content Management System [.Net 3.0]
Software Development Company

Industry:
IT Services

Technologies:
VS 2008 , ASP.Net 3.0 , NHibernate, MS SQL 2005 & MySql

We worked for this client on their CMS system which was built on the latest .Net framework. This CMS helps in building 100% customizable websites. It has a mutilingual interface and has many useful modules built into it and is used by major canadian companies to build and maintain their websites.

Gantt Chart
Software Consulting/Services

Industry:
Airlines

Technologies:
ASP.NET / VB .NET 2.0, MS SQL Server 2005, SQL Server 2005 Reporting Services, XML 1.0, XSLT 1.0

The requirement was to develop a chart that shows task schedule of an employee and is also capable to judge the performance of an employee as how much they worked during their shift. This chart was put in the Reporting services, reason being employees always get confused as to where to find a specific report, and the Report Server is preferred to organize vast amount of reports with different authorizations.

This application works on Reporting services. An XML file is generated through dataset under .rdl file and saved in the server. Thereafter an xslt file is prepared, XSLT describes how the xml document should be displayed - XSLT is a stylesheet language for XML. The original document is not changed; rather a new document is created based on the content of an existing one. The new document may be serialized (output) by the processor in standard XML syntax or in another format - such as HTML or plain text. Xslt is most often used to convert data between different XML schemas or to convert XML data into HTML or XHTML documents for web pages, creating a dynamic web page. On report (RDL File) creates a link that follows us to the HTML page, basically SQL Server 2005 reporting Services (SSRS) is a server-based reporting platform that provides comprehensive reporting functionality for a variety of data sources. Reporting Services includes a complete set of tools to create, manage, and deliver reports. Reporting services tools work within the Microsoft Visual Studio environment and is fully integrated with SQL Server Tools and components. Once we are done with creating RDL File, we will need to deploy it on Report Server which manages all reports and information kept in reports on backend. Some of its tasks involve keeping metadata of reports, Data source information for reports and cached reports. All of this information is kept in SQL Server database which we will configure as part of configuring Reporting Services.

The reports developed and deployed on Report Server, is viewed by users using Report Manager, which uses report server on the backend.

Help Desk System
CRM Software Provider

Industry:
Software Service

Technologies:
Agile Point, WSS 3.0, ASP.Net 2.0, C#, SQL Server 2005

Developed a Helpdesk System for Partners and Customers linked with Agile Point BPMS products.

This includes a registration module wherein a Customer / Partner can create their helpdesk account. It also includes a Lost Password module. On Successful Login a user can see the latest News and Events on the main page. This also has an option for creating a new Ticket and view the corresponding ticket status as it passes through the different phases of the registration process.

All these processes involve the Workflow designed using Agile Point Envision Process Templates. Processes like Registration, Login, Lost Password and Create New Ticket, triggers the corresponding process template. Each process template has its own phases / flows defined, which carries different Database operations, Mail Sending tasks, Conditional checks, Manual Approval Tasks, etc. The Manual / Approval Tasks get displayed in the WSS 3.0 site under a custom webpart. This site is mainly used by the internal staffs.

The task list is user specific i.e. it only displays those tasks which are assigned to the logged in user. The internal staffs can then set the status of different flow handler conditions. The main objective of this site is to handle the Ticketing request through proper Business Process Management flows using Agile Point.

Illustration
A Leading Insurance Company

Industry:
Insurance Group

Technologies:
Net 2.0 framework, ASP/VB .NET,Crystal Reports 10, JavaScript, SQL Server 2005, Excel 2003

This system has been developed to manage various products for an insurance company. The rudimentary concept is that Agents can directly fill up the Application form and generate the Excel docs for each product over net. All the products have different input requirements and based on input data output will be generated. The calculation is also different for each product with various input parameters. To manage the calculation one unique concept came up named 'Excel Engine' and a website to manage the input and output values.

Administrator has the ability to create input and output fields for a product with the validation options according to the requirement in the 'Excel Engine'.

User section has been implemented to manage application for customer and report generation. In User section 'Brokers' can manage their 'Broker-Agents' and administrator manages 'Brokers'. 'Broker-Agents' can access only those products and reports that are assigned to its respective 'Broker'.

Activity Management System
A Leading Insurance Company

Industry:
Insurance Group

Technologies:
ASP.NET, C#.NET, .Net 2.0 framework, Crystal Reports 10, JavaScript, SQL Server 2005, XML Chart

Activity management system is used to keep track of the managers' and agents' activities. It has two (admin / user) sections. An admin can create and update the agent information such as current status (active/terminated), reset password, assign override etc. Admin can synchronize the data from Access database to SQL Server database to update the agents. Mangers can enter the activities of their lower next hierarchy according to their role. Managers can also generate several reports (export to excel), graphs within a date range.

Visual WebGUI Web Development
Software Solution & Service Provider

Industry:
Health Care

Technologies:
WSS 3.0, C#.Net, SQL 2005

Developed web applications using Visual WebGUI for different medical surveys like Asthma, Diabetes, Cardiovascular, etc. Each survey is like a set of questionnaire designed using web gui forms. WebGUI facilitates creation of rich web based application with support for Ajax using the Windows Application approach. All the web forms are designed using Windows form and at the runtime it automatically gets interpreted as web pages. The database interaction is managed using .Net 3.5 LINQ concept.

Product Web Portal
Is a Virtual Reality Software company that provides software products for the engineering industry.

Industry:
Industrial Engineering

Technologies:
ASP.NET 2.0, VB.net, SQL 2005

This web application presents a rich set of AJAX enabled web pages for different categories of users (like Admin, engineering and guest users) for various user level activities like uploading Virtual realty models of virtually unlimited size, managing the VR as well as Transactional models, downloading model files etc.  This web portal includes user authentication / validation across all the pages of the application to secure the contents from non-authenticated users. The Admin section includes features like adding new user to the application, editing existing users, changing user role / permission etc. This web application also converts a Transactional model to a Virtual reality model on the fly upon user request and facilitates downloading the same onto the user machine.

Auto Data Poster
Service provider for auto dealers

Industry:
Automotive Industry

Technologies:
ASP.net 1.1, C#.net, SQL Server 2005

Using this tool we post our website information to a well known classified site automatically.Mainly we followed a process of automatically collecting Web information from the ad site , then edit it with our own website data and send results to the website site pro grammatically.This process helps the dealer in saving time in posting data to the site manually.  This is a web based tool that enables car dealers to directly send the latest updated data including vehicle photographs link to the ad site.The ad site terms and conditions are followed strictly to post data in order to avoid auto rejection of the posted entries.

Sell Management Module
Software Service provider for online auction.

Industry:
Utilities Industry

Technologies:
ASP.NET 3.5, C#.net, SQL 2005

The project involved the requirement of migrating an existing classic ASP application on to the .NET format. The business logic was ported into the .NET libraries to be used in the application.

It basically involved a sell module which allowed the creation of items by the Logged in user for Bidding based on the Listing Format (e.g. Auction, Dutch auction, Trade, Classified Ad. etc).
Other users will Bid for that Item by providing the Quantity and quote Price details & finally the bidding will be closed depending upon the User's Bid Value and End date.The owner of the Item can edit/Delete his/her item details before bidding starts. A detailed bidding view page was implemented which showed the latest Bid value, in order to enable users to make a call on the latest quoted price. This page continuously got updated through Ajax at a specific time interval to display the latest bid value.

There was also a Admin module that has the rights to create new Sell template for different Items with different Listing Format, so that at any moment those can be activated for bidding purpose.

Tax Filing Application

Industry:
Finance

Technologies:
ASP.NEt & SQL SERVER 2005

This is a web-based online tax filing application. Basically it allowed users to register themsleves and provide the application with all necessary information needed for tax filing,including supporting documents (through an upload feature).

The actual tax filing was being done by our client, who charged his users for this service. For payment we had paypal integration done.

Migrating classic Online Auction ASP software to .NET

Industry:
IT/Web Services

Technologies:
.NET 3.5 , C#.Net, SQL 2005

The existing application was an Online Auction software developed in ASP with SQL 2000 as the database. The project involved the requirement of migrating the ASP web application into an ASP.net application on Frame work 3.5.

In the ASP version the business logic of the application which was existing in the COM Dll was migrated into .NET assemblies.

The application broadly had 2 modes
1. Admin
2. User

The Admin user creates and maintains the various listing formats as well as manage the registered users and the sell items registered. Each and every transaction in the Sell Module (Like Invoice details, Listing details, Bidding deatails etc.) is managed and Controlled in the Admin section. Admin also has the rights to create New 'Sell' templates for different Items with different Listing Formats, so as to be activated for Bidding purpose at point of time.

Whereas a User can create an acccount and use the existing listing formats to post items for sale. Other users can login and bid for the posted items.

ASP website
IT Services

Industry:
IT Services

Technologies:
ASP, PHP, My SQL

This is an ASP based web site. Basically, this web site allows a student to create his/her account details, select the course he/she wants to pursue, selects the faculty and pay online.

Faculties are allowed to create new courses and their fees structures along with the number of days required to do the course and its scheduling. This also includes the number of HTML reports for Faculties and Students.

Affordable Edocs
Service Provider

Industry:
Service Provider

Technologies:
ASP.NET, C#, Crystal Reports, Sql Server 2005

EDOCS is a web application which allows customers to view their documents like bank statements online. The application has three section: admin, client and customer. The clients are financial institutions, doctors, hospitals etc. The admin and/or the client manager can upload the documents for a customer. The customer can then login to the application to view the documents. The application also has customer and document search functionality along with reports like client summary, new customers, all customer and client users. This application can integrates with a banking application. The application has a batch document upload program which is a Windows Service.

Google Maps Travel Calculator

Industry:
Sofware Service Provider

Technologies:
ASP.net and Google API

Modification on the Google Maps Travel Calculator. The issue was that every now and then Google asks to clarify one or both of the input addresses. When this occurs, the TravelCalc dll bombs and returns zero miles and time.

Custom .Net Application Development
Custom Solutions Consultant

Industry:
IT Services

Technologies:
.NET 3.5, VB.NET, SQL 2008, FileBound

The requirement was to developed a custom application that can generate good quality reports by writing text over the images using the power of .NET desktop application.

Therefore we have created a custom application that was developed to perform the following functions:

1. Reconcile Delivery Tickets scanned into a Document Management System with Company System Database.

2. Print Statements, Invoices & Tickets in a predetermined & presorted order.

ZNode Integration with Custom CRM Application

Industry:
E Shop

Technologies:
ASP.NET 3.5, ASP.NET AJAX, zNode Store Front, SQL Server 2008

The goal of this project was to get the sales order transactions into a different application. The challenge here was to do the same without modifying too much of zNode Code so as to keep the future updates from zNode trouble free. We did the same with some custom tables, Fields in the ZNode Database and the project was delivered successfully without touching the zNode Code base. The updates were real time and we have used windows service and a web service call to do the same.

ASP.Net Integration
Software Development Company

Industry:
Pollution Management

Technologies:
ASP.NET , SQL Server

This is an ASP.Net application which was developed using VB.net and SQL server 2000. We have used .Net to find and fix bugs in this application and also we have given solutions to the existing problem for this application.

Integration of Digital Document in ASP.Net
Healthcare

Industry:
Healthcare

Technologies:
ASP.NET 2.0 with VB.NET, Visual Studio 2005, SQL Server 2005, Visual Guard .Net, Telerik, Teleform & Win XP

It is a Web-based application & the purpose of it is to develop a personalized healthcare survey that is a part of a larger Medical group of hospital providers. Main features are Import patient demographic data, Manipulate data to provide sample set, Merge questionnaires, Scanning and verification of questionnaires, Store questionnaire responses, Track questionnaire status, XML Generation for CMS Upload, Melissa S/W & Visual Guard .Net integration.

Library Management
Consultant

Industry:
IT Services

Technologies:
.NET 3.5, SQL Server 2008, VB.NET

This is a desktop application which manages library of books etc. We have implemented MARC library in this project. We have also fixed the bugs in this application.

Sales Prototype Application
Internet Marketing

Industry:
Internet Marketing

Technologies:
ASP.Net

This is basically a Sales application for which we have implemented user interface. There are funtionalities in this application which can be used by both Buyer and Seller. The Seller can upload his own equipments so that any person who is a Buyer can select any equipment to purchase it. Seller can upload as many equipments so that buyer can purchase it.

SiteFinty CMS Website

Industry:
Animal Welfare

Technologies:
ASP.Net 3.5 and SF

The is a CMS website created by using SiteFinity CMS. The website provides Pet related information to users.

Driving Instruction Management System
Software Company

Industry:
Driving School

Technologies:
ASP.NET 2.0, SQL 2005

The application is designed for a client in the Driving School domain. It works on SasS model with multiple driving schools using the same application. The application had to support both the class room curriculum as well as the driving lessons.

The driving lessons, the maneuvers, the instructions, test patterns are customizable at state level and also at client level. Each and every progress of the student is closely monitored and recorded in the application. The certification process is also completely automated by the way of sending mails and other supported documents to the state authority.

The application has three parts namely, Office Operation ,Business Operations and Scheduler. Office Operation & Business Operations is designed for back office people here in the section they can track the students progress and billing, apart from that there is a permission matrix set for all employees to use specific pages which is controlled by the Admin. The application also has a student login and the scheduler is real time with instructor and class schedules.

Web Based Report Generation Application
Pharma Company

Industry:
Pharmaceutical

Technologies:
ASP.net 3.5, SQL server 2005

It is a web based project used to generate reports. It has two types of login Admin and User. The project consists of two reports called Line Summary and GAD and the admin pages to set up the product class, product group, product type, products, customers, compounds, sites and users and relationships between all these entities. Line Summary report to summarize revenue by product type and the GAD for details relating to revenue, margin and machine hours for certain customer, compounds and/or products that represent the bulk of revenue for a particular site. The two reports are loosely related so much that the GAD is a detailed sub set of the Line Summary. A user enters the Line Summary data for a site. Line summary data is based on Product Type group by product Group. Then the user will enter the GAD detail for a site. Gad data is based on customer, compound,product, product type group by product group. Finally subtract the total amount entered in GAD for a product group is subtracted by total amount entered for LS for the same to manage the total equal. The net effect is the ability to produce a GAD that itemizes specific detail data and then summarizes the balance of data by product group. The application has the feature to export Line Summary and GAD data in excel format with formulas.

Application also produce a consolidated report for a combination of multiple sites called a Reporting Group and for Product Class that is a combination of different Products. Admin also has a locking feature to lock the data entry for selected period and to manage different data exchange rates for different sites. This feature is used in reporting to generate report in local currency as well as in US dollar.

Web Tracking Rewrite
ISV

Industry:
Logistics

Technologies:
ASP.NET 4.0,  C# 4.0, jQuery, jQuery UI, SQL Server 2008, SSRS

WebTracking application is a web application that serves multiple freight forwarding companies. Forwarders need to provide an online resource to their Customers. Their Customers primarily consist of Shippers, Consignees and Agents, who wish to track their shipments. This is similar to online tracking provided by UPS, Fed Ex and such companies. So the data needs to be compartmentalized by 1) Forwarder and 2) Customer (specific to the owning Forwarder).



The shipment and tracking history is entered to the web application via a window service that runs in a frequent interval and transfers any new or edited shipment and tracking data.



The customized themes are one of the exotic features of the application. End user is allowed to customize the color, font, background etc as per his/her choice.



The broad functions include:



Administrative



- To create/modify/delete forwarder.



- To create/modify/delete companies under forwarder companies.



Operative



- Show/print Tracking history.



- View/create/delete/print request for shipments.



- View/print financial information.



- Extensive search/filtering criteria to every list page.



- Shipment information from login page.

ASP.NET Shopping Cart
IT Services and outsourcing

Industry:
IT services

Technologies:
ASP.NET 3.5, SQL Server Express 2008

Developed a static Shopping Cart ASP.NET based web site. It has the login credentials plus the ability to read the products from the Database, if entered manually. There was no ADMIN site to handle the products and categories. Also the shopping cart has the feature till user can see the items in there cart and total price without any taxes, shipping cost etc. Moreover it was not related to any payment gateway.

Event Registration
Software Service Provider

Industry:
Services

Technologies:
ASP.NET 4.0, SQL Server 2008, C#, ASP.NET

The purpose of this project was to develop a website to allow users to register online for different events organized by our client. The website provides a smoother user experience using its intuitive user interface to allow users for individual or group registration and to help manage the user accounts. The website allows users to create their own login and also provides a seamless integration with Windows Live ID. The registration process involves a number of steps including providing details of the registrants, adding guests and finally make payment through paypal. User can add and cancel registration of any registratnt / guest and the website provides a smooth user interface for online payment and cancellation of payments though Paypal integration.

Custom Application for Kitchen
Food industry

Industry:
Food Industry

Technologies:
ASP.NET, SQL SERVER

This was a small application that was custom build by the client to manage orders for their kitchen. Their primary clients were hospitals and they manage the menu list for each day of a week for a specific time period, after which the same menus was re-arranged to be served on different week days.

They needed an interface to do this for long periods, so that the system can alert the kitchens as to what needs to be served in the kitchen on specific days of the week and in what quantities for a hospital in advance.

The application was accessible to the hospitals to create their order list, as well as to the concerned kitchens to track the order and ensure timely delivery.

Outbreak Managemenmt System
Software Service Provider

Industry:
HealthCare

Technologies:
ASP.Net MVC3, Ado.net Entity Framework, jQuery ,SSRS

OMS is a Outbreak Managemenmt System to measure the health outbreak of diseases. It is a web application using MVC3 Framework based on the .NET 4.0 framework. ADO.NET Entity framework is used to interact with the database. Reports are developed using SQL Server Reporting Services. jQuery is used for client validation and UI interaction. Rajor View engine is used for the view pages used in the application.

  Work mainly involved in the implementation of the following areas :- * Reports part - Designing reports, Writing stored procedures to populate the reports, Dynamic Crosstab reports , Sub Reports.

* Export and Import Functionality - Exporting data to Excel file, Importing data from the excel file to the database for all master entities.

* Search Module (like for Case,Contact,Organization  etc.), Advance Search Module, Call Log Section.

* Quick Case Entry Section - The Quick case Entry screen is where the system displays the demographic data entered by the user along with any associated conditions. Auto-fill provides users the ability to quickly enter case data.

* Implement Inline add, copy, edit and delete functionality for cases using Telerik Grid.

* Replace all the dropdown controls with Telerik controls through out the application to support some new enhanced feature and modify the code accordingly.

POS Application
Hospitality

Industry:
Hospitality Industry

Technologies:
ASP.Net, C#, SQL Server 2008, WPF, RFID Tech

We have developed a POS application oriented towards hospitality industry using RFID technology. The application consists of issuing RFID bands to guests along with integration of an exsiting POS application. The application reads tag ids from the RFID tags and associates them with the guest profle. The application works with different RFID readers like RFIDeas AIR ID writer, RFID ENROL ID and FEIG reader and uses the SDKs available with these readers. There is another section in the application which is for Guest Recognition which displays multiple guest details based on the tags scanned as the guests walk in through an Alien RFID Gateway. Alien reader reads 100's of tags at once and uses the Alien SDK and works for UHF band. The protocols used are ISO 14443 and 15693.

We have used below HW

1)FEIG Reader

2)RFIDeas

3)Alien Reader

4)Magnetic Strip Reader

5)DL, Passport scanner for scaning only

6)Ethaca Printer for printing

Web Application
Healthcare

Industry:
Healthcare

Technologies:
ASP.NET 4.0, SQL 2008

This application consists of a web application and a window service. The web application is the UI part that is designed as per end users and the Window service is integrated to this web application. Its the window service that actually reads the file from a specified folder, import the file and record information in the database. Once the record and file information is updated by the window service, end user can then see those information from the website.

All the information required to setup the web application and the window service are defined in the configuration(config) files. The web application has its own webconfig file and the window service has its own appconfig file.

Project Organiser
IT Service Provider

Industry:
Industrial Engineering

Technologies:
ASP.Net 4.0, C#.Net, AJAX, JavaScript, jQuery, CSS, MS SQL Server 2008, XML

The project involved development of a web based solution for managing of Jobs, Tasks and creating Condition Report. It was an existing Excel application recently built and exists on their internal network file-share. Client had expressed a desire to rebuild this application using an online platform to improve security functionality around the entered information and multiple user capabilities. Our job in this project was to design and develop a web based solution with all of the existing functionality of the current Excel application.