Mindfire has deep experience developing C#.NET-based desktop/server applications. We describe some of these C#.NET project experiences below, and will be glad to share our expertise in detail with you.
Sweep And Pool System
Sweep And Pool System
Industry:
Banking
Technologies:
C# .NET 2.0, SQL Server., MSDE
Our banking client has a customer that is one of the largest business groups in India and operates through many companies. It has diversified businesses.
Customer's Central Treasury, wants to manage the borrowing and lending of their group companies effectively by utilizing the idle cash lying in other group companies rather than going to financial institution like bank. The overall objective is to save on Interest Costs at one end and provide interest income for credit balance to the group companies.
Client has addressed the requirement for creating Sweeping and Pooling structure for one of there customer.
It has two main requirements from this system –
I. Sweeping of End of day Balances from participating accounts to the Pool owner account
II. Generating Inter Company MIS
Customer has defined 5 Tier Account Structure for Sweeping and Pooling. The Group companies participate in this pooling structure. This 5 Tier account Structure may vary in future hence it needs to be dynamic.
Tier 1 Account is the Pool Header Account (PH).
Tier 2 and Tier 3 Accounts will have Sub Header Accounts (SH).
Tier 4 Accounts would be the Business Accounts operated by group companies of Customer.
Tier 5 accounts are the Zero Balance Accounts (ZBA). The end of day of balance in these accounts would be swept automatically into the Tier 4 Business Accounts or to another ZBA account.
Customer would define the relationship between these Tier accounts. There will be multiple pools and one of the accounts would be Pool Owner account and rest of the accounts would participate in the pooling.
Sweeping and Pooling between the Pool Owner account and the participating account could happen either based on Limit Check (LC) or simple end of day balance transfer on daily basis. This again would be defined by Customer for which account, system should do the Limit Check and then sweep the balances.
Most of these accounts, which are participating in Sweeping and Pooling structure, will have a Pool Borrowing Limit (PBL) and Pool Lending Limit (PLL). Pool Borrowing Limit, is till how much amount an account can borrow from the pool owner account. Similarly, Pool Lending Limit is till how much amount an account can lend to the pool owner account. Limit Check would mean checking the PBL and PLL and then sweeping the balances into Pool owner account. The sweeping entries should be, transferring the balance fund into the pool owner account at the end of the day and transferring the swept balance back into the participating account from the pool owner account next day morning.
Shopping Kart
e-Business Solution company
Industry:
e-Business Solutions
Technologies:
C#,ASP .net 2.0, MS SQL Server 2005,
Website for customizing and accepting order for printing press products (business cards,labels, stamps, tickets etc.). The asp.net and javascript based order designer allows user to design and preview the product. The shopping cart section allows user to place the order quantity, calculates the amount details and accepts user's contact information. Finally order details parsed as a xml file stream and passed to the back end order processing services.
Automotive Business Application
Automotive software company
Industry:
Automotive industry
Technologies:
Net 2.0, C#, AJAX, MS SQL Server 2005
The application has broadly two sections. One for general public to see history of the company and different product/services offered by the company and the other is admin section. In the admin section distributors can upload their manuals and bulletins for view and download by customers.
Email Management System
Construction Company
Industry:
Commercial Construction Industry
Technologies:
Visual Studio .Net 2005, C#.NET, Exchange Server 2003/2007, Developer Express 7.2 , ActiveUp 2.2.1215, and MySQL 5.0
The requirement was to develop a windows application that would replicate the Microsoft Office Out Look with minimal functionality that would enable the end user to manage his / her emails. The application was finally integrated in to the existing Construction Management software.
Using this application the user can access their mail Boxes resided on ExchageServer. User can do all mail related stuffs like Compose, Send, Forward, Reply, and Reply All using this application. User can also send all types of file attachments.
This application uses ActiveUp Mail System component to implement all the functionalities. This application based on IMAP4 (Internet Message Access Protocol) for receiving emails and SMTP (Simple Mail Transfer Protocol) for sending emails.
IMAP4 is an application layer Internet protocol operating on port 143 that allows a local client to access e-mail on a remote server. The current version, IMAP version 4 revision 1 (IMAP4rev1), is defined by RFC 3501. IMAP4 and POP3 (Post Office Protocol version 3) are the two most prevalent Internet standard protocols for e-mail retrieval. Virtually all modern e-mail clients and servers support both. IMAP4, clients often stay connected as long as the user interface is active and download message content on demand. For users with many or large messages, this IMAP4 usage pattern can result in faster response times.
Simple Mail Transfer Protocol (SMTP) is the de facto standard for e-mail transmissions across the Internet. Formally SMTP is defined in RFC 821 (STD 10) as amended by RFC 1123 (STD 3). SMTP is a relatively simple, text-based protocol, in which one or more recipients of a message are specified along with the message text and possibly other encoded objects. The message is then transferred to a remote server using a procedure of queries and responses between the client and server. The SMTP client initiates a TCP connection to server's port 25.
The sent / received messages are stored as .eml files in the local file system.This application also has a search functionality implemented by which user can search phrases from any field like Subject, Message Body, Received or Sent date etc.It also provides options to set Message Rules by which the received mails automatically assigned to respective mail folders.
FM-MYSQL Data Migration Wizard
Construction Company
Industry:
Commercial Construction Industry
Technologies:
Visual Studio .Net 2005, C#.NET, Developer Express 7.2, File Maker 6.0, MySql 5.0
This is a complete data migration tool that has been developed to handle the data migration requirement of Construction Management software that was ported from the File Maker 6.0 to .NET 2.0 and My SQL 5.0 at the back end.
It involved detailed and through analysis of the existing File Maker data and the corresponding field and table in My SQL was done to ensure that no data
misses out during migration and all data are mapped correctly as per requirement. The primary aim of the project was to ensure that the newly ported .NET version of the application should be able to populate all the migrated data flawlessly as required on all the forms and simultaneously the application should run without errors.
The migration process involved exporting FileMaker data to MySql through .mer files (Merge Files).These files are validated by the migration tool before
migration. The application works with existing Database as well as creates new schema dynamically as required along with Tables.
User can use "Data - Mapper" screen to map data from ".mer" files to dynamically created Schema. The screen is very user interactive and gives the user a complete view of the data to be migrated on the screen it self and take decision accordingly.
"Data Generator Module" of the system is responsible for inserting customized data like GUIDs/UUIDs, Identity value generation, random strings or data from
Excel file or Text files as required.
Robust Exception Handling is built into the core of the system so as to get complete details of the errors that occurred during data migration. If there are any exception /errors during the course of migration then the errors are written to system event log and the data for that transaction is also logged into files and finally Transaction is rolled back.
CMS driven company website
A Financial Firm
Industry:
Finance
Technologies:
C# .net, ASP .net 2.0 , MS SQL Server 2005
There was a static site of the financial firm that needs to be regularly updated with regular incoming content, news and file resources. We built it as fully ASP.Net CMS site using master and content pages. The page metadata, page content, navigation are dynamically loaded from the database managed by the CMS. The CMS site administration section use ASP.net 2.0 role based authentication system in sync with the SQL Server 2005 for user roles and profiles as Submitter, Approver, or Admin. Each change to page content is done using built-in HTML editor and is versioned. There is a ability to roll back to any version of the page that has ever existed in the CMS. When a page is created, modified or removed from the site, a notification email sent to all the approvers to login to the system to review the changes and approve. All together it makes the website fully dynamic and content rich without the web-designer and programmer role in regular basis.
Web based E-ERP business solution
European e-business solution provider
Industry:
e-business solution
Technologies:
C# .net, ASP .net 2.0, Java Script, Ajax ToolKit 1.0, My SQL 5.0
This is a web based B2B2C environment that supports the management of complete supply chain. This includes cash register, e-commerce, e-invoicing, warehouse management , CMS and CRM. The system is built as two basic parts. First part is the product, stock maintenance and reporting section for managing the back end supply chain system by merchants, dealers and warehouse staff. The second part is the front end public website with product catalogue drawn from dynamic pages out of the CMS system. When order is placed via the product catalogue, it generates a supply chain record through http post to the backend system. The order processing chain from warehouse to dealers and then to customer is processed through supply chain cycle through the system. The complete website uses components of ASP.net Ajax ToolKit and that provides a rich UI and performance benefit.
