Mindfire has deep experience developing ASP.NET large-scale web applications and high-performance ASP.NET web sites. We describe some of these ASP.NET project experiences below, and will be glad to share our expertise in detail with you.
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, which has been used for the commission calculation for the agents. Monthly transactions get imported to the application to calculate the commission for the agent. Application is equipped with producing the commission statements each agent in PDF format. It also generates the financial transactions which get transferred into the accounting system.
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 selects Acts (Artists) to be added to its Notify List. And basically 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". For each act that 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 that goes out every Monday morning that lists all of 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 transaction are done using Authorize.net. 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. 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 maintenence 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 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
This system is basically used for tracking projects, time and expenses quickly and easily for maximum profitability for different industries like IT Service, Healthcare, architects designs, automotive etc. This system is perfect for the professionals, workgroups or 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 this project from VB6 to VB.Net and the database which was in Access to SQL Server 2005, but before doing this some task was very important to accomplish, like improve the efficiency of this existing software as it was so slow regarding to data display 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.
In simple words, for example we can say that before changing all these things the data populated in Flexgrid took 81 seconds and after these changes it just took 18 seconds.
3 : Currently we are working on writing Macros for this project. In order to generate correct / foramtted Pivot Tables out of single Excel Sheet.
www.campus18.com
Tangerine Digital Entertainment
Industry:
Entertainment/Media
Technologies:
ASP.NET 2.0, C#, SQL Server 2005, XML
Campus18 is a social networking site for youngsters in colleges and universities to showcase their talent to the world. Campus18 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 Campus18.
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 there CMS system, built on the latest .Net framework. This CMS helps is building 100% customisable websites.It has a mutilingual interface and has many useful modules build into it and is used by major canadian companies to build and maitain there 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 should be in Reporting services as employees are always confuse where to find a specific report and the ReportServer is just preferred to organize plenty of reports with different authorizations.
This application works on Reporting services, an XML file is generated through dataset under .rdl file and saved it on server then an xslt file is prepared, XSLT describes how the xml document should be displayed! Basically 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 are 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.
When we have developed and deployed reports on Report Server, users can view reports using Report Manager, which uses report server on 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 where in a Customer / Partner can create their helpdesk account. It also includes a Lost Password module.On Successful Login a user can see / view 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 on through different phases of 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 gets 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. 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.
Lab Report Automation Software
Software/Product Development, Consulting Services
Industry:
HealthCare
Technologies:
ASP.Net 2.0, C#, SQL Express 2005
Analyzed, designed and developed a fully functional website for a Health Lab.
The web site helps the LAB to generate the Monthly and the Daily reports as per the requirements.The web site have basically three modules to deal with the reports. It provides easy to use interface for entering the data and getting them validated. Once the data is entered reports in the CSV / txt format can be generated and then be mailed out to the concerned authorities.
