Essay Writing Service

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)

Exchange Rate Calculation System DevelopmentExchange Rate Risk and Impact on Foreign Trade

1. INTRODUCTION   1.1 Purpose of the system: Employees request the application in which he/she holds his/her savings amount to convert it into the currency of his/her respective country. In order to do that, this application has a scope to check for current currency exchange rates. He/she has to register in ERCS module and can apply for the

This paper uses real world application of exchange rate fluctuations, its causes and impact on the economy, risks associated with it and their management, in terms of Chinese economy to show the importance on these financial concepts and their requirement of understanding one to understand the other, all in wake of gaining he knowledge that will help in making transactions’ decisions that affect the economy on a global scale. Going for a bigger leap by learning to take smaller steps.


The incontrovertible evidence of understanding the importance of the exchange rate fluctuation mechanism and the types and magnitude of risk, attached to the international trading affecting those who are involved in transaction across border globally deems necessary the acquisition of knowledge by those who are involved in day to day market transactions. The global economy is reliant upon the study of economic and other socio-political variable affecting the exchange rate in the international market influence the terms of trade of the trading countries and consequently inducing changes in the budget restructuring and trading quantities that are contributed to the international market by individual countries. Thus the realization of the need for this paper came upon as a research topic.
This report takes into account several articles and write ups related to foreign exchange rates, their risks, exposure, and tries to plug them in with the conventional concepts of these financial instruments in order to enhance the understanding and the knowledge of exchange rate mechanism, its determinants and how it impacts any country’s economy specifically that of china. The literature support backs up the implication of the concepts applied here for the better grasp if the points that are attempting to be made noticeable.
The main theme of the paper revolves around the arena of foreign exchange rates; How they impact the economy, what causes them to fluctuate, the impact of these fluctuations; How they affect the country with a changing value of currency in relative terms, a mention of the recent effects that the economies of the countries have gone into having had been affected in terms of it economy and foreign trade sector, the risk exposure associated with the fluctuating exchange rates and how does hedging help in reducing that risk.
Even though the main theme would give an impression of a broad topic discussion, however we will remain confined to narrowed discussion limited within our topics only touching the subject in light of its practical application extracted from evidence presented in news articles and periodicals. This stance has been adopted, induced by the goal achieving grasp on the concepts and not on mere conventional definitions to these applicable financial-economic concepts.
The paper also sees through and explains the methods of conduction of research in terms of our sources of data and our approach. Graphs and charts relevant to the topic have been provided to further clear the ideas built upon the physical evidence by analysis of these statistical data sets. Eventually reaching to base where we design a cohesive note on the findings of all the efforts put into this research and thus helping us to reach to a conclusion based upon all the facts and evidence provided in the literature review and by the statistical data charts and graphs.

Literature Review

This section imparts knowledge using empirical evidence that is published in newspaper journals and articles and is related to our topic of interest, to augment the understanding of the financial concepts and phenomena that take place in the economy. Following are some critical reviews of articles pertaining to topic: Exchange rate risk, determinants and its impact on foreign trade.

Exchange Rate Fluctuations and its Causes.

The issue of the undervalued currency of China (Renminbi).and not just undervalued the word ‘substantial’ puts the emphasize on the meaning shedding curious gazes as to what might be the reason behind this, has been presented by the corporate author (Business Asia, 2007).However, the year 2007 and the year following that were expected to bring appreciation according to the author. The low valued currency helped in the exports volume increment but at the same time incurred costs in other sectors. The so expected appreciation would bring prosperity to the economy, indicating an economic growth or a path led to success. On the other hand, the appreciated currency would, by all means, even if little, impact the exporting sector negatively making the goods sold to foreign countries less cheaper and making the existence of Chinese goods in the competitive market all the more tougher (Business Asia, 2007).
El-Erian, ONeill, Bergsten, & Mohamed (2007), further takes the discussion forward with appreciating Chinese currency and at the same time the threat of protectionist trade measures and the falling dollar. He sheds light upon the problem of falling dollar and how it would be a problem being a constraint upon the Federal Reserve Bank to take measure against the economic down turns led by the crisis in the real estate. On the other hand, the Chinese Yuan has been allowed to appreciate modestly in the past two year from the time the article was written keeping an eye for the threat of protectionist measures (Business Asia, 2007). Already the appreciation had caused much apprehension for the Chinese; dollar falling further would be putting too much on their plate. The Depreciation of Dollar would imply further appreciation in Chinese currency which would threat the exports sector much. Nevertheless the depreciation of dollar by and large is a development for the world economy despite some negative consequences it may have on trade. And the circumstances are much more predictive for the weak dollar than the reality assumes, and it sure is likely to remain that way (El-Erian, ONeill, Bergsten, & Mohamed, 2007).
The important issues discussed by the corporate author diverts our attention towards the sterilization efforts, issuance of liabilities and Sino-US relation that are the main factors affecting the pace of the appreciation expected (Business Asia, 2007). The so long undervalued Chinese currency’s expectation to rise was induced by the central bank’s intention of sterilization for the manipulation of exchange rate, however all depended upon the success of this effort. The central bank can control the exchange rate by buying or selling the currency and hence stimulation and increase or a decrease respectively in the relative supply of the currency in circulation. Furthermore in sterilizing it insulates itself from the foreign exchange operations in order to prevent potentially adverse impacts of capital inflow or outflow. Thus in order to appreciate the Chinese Renminbi against US dollar the central bank of china would buy the domestic currency and create a shortage of supply, therefore increasing its value and it would sell the American dollar for the reverse effect. Hence, the Chinese currency would appreciate. (Business Asia, 2007)
El-Erian (El-Erian, ONeill, Bergsten, & Mohamed, 2007), taking a step further, reasoned the apprehensive condition of the Chinese, to see the falling dollar after all their efforts to keep the appreciation of their own currency modest. The threat of declining exports leading to broadening of trade balance was imminent. And to top it off the depreciating dollar only sought to be a cause for an augmentation of risk in the painstakingly controlled economy (El-Erian, ONeill, Bergsten, & Mohamed, 2007). The article but also points out that despite the negative consequences of the weakening dollar on trade given the predictable circumstances of a likely depreciation, it also implies a development of world economy against US. Because depreciation of dollar would in effect mean appreciation of the currencies that it must be held against which includes all the other countries of the world. Thus from the perspective of other countries an appreciation would be taking place implying a growth affect in their respective economies and indicating a surge of development in those countries (El-Erian, ONeill, Bergsten, & Mohamed, 2007).

The Negative and the Positive Impacts

Corporate author contributed in the same line of argument, though his inclination was towards the impacts then cause. His argument is in resonance to the arguments of El-Erian critically analyzed above. The author specifically talks about the strong appreciation of most Asian currencies against USD while there being still others, which were weaker than they were before the global financial crisis (Business Asia, 2009). The appreciation of other currencies has put the undervalued currency under pressure to appreciate further. China in this respect has continued to keep its currency undervalued. A rapid appreciation would imply a slower accumulation of foreign reserves. This brings two aspects under concern. First is the rising threat of protectionism from European countries and the US and the other is the giving full control of monetary policy back to Government (Business Asia, 2009).
The corporate author of Business Asia (Business Asia, 2009) also forces us to contemplate upon the issue, which is the rapid appreciation of currencies in Asia, especially in China, who has been keeping a modest appreciation rate in light of the threat of protectionism from EU and US. The weaker currency if allowed to appreciate rapidly would instigate protectionism from EU and US on now not so cheap goods owing to the devaluation of USD itself as well as the appreciation Asian currencies. However this would also imply developmental growth in other countries (referring to China) relative to the US (Business Asia, 2007). Furthermore another incentive for letting the currency appreciate for China and other Asian countries would be that letting the exchange rate fluctuate on its own terms, the Government will finally be free to use the monetary instruments to manipulate and reshape their monetary policy which otherwise had been committed to keeping the exchange rate fluctuations in check (Business Asia, 2009).
From the discussions regarding the exchange rate by different authors so far, it has been an enlightening experience to contemplate upon the issues faced in the real world by the real economies regarding the Foreign exchange rate fluctuations, how they are affected differently by the conditions of the economy in different countries, and the what reactions it induce in the effected economies. The Exchange rate fluctuation is now better understood in terms of two countries respected currency values. We can see a number of different impacting factors changing the rate which include the loosening of monetary policy in to let the Chinese currency appreciate against all currencies and on the other hand the devaluation of dollar appreciated the Chinese currency even further. Resultantly changing the relative development indicators of the countries effected (Business Asia, 2007).
Furthermore, the effects on the foreign exchange rate we also saw the application of the effects that the fluctuations of FOREX have on the economies, which is an exposure to the risk of losing trade as mentioned in our literature review (Business Asia, 2009). The rapidly increasing currency value also come forth rapidly rising prices of exports goods which would induce a fall in demand or worse, protectionist policies, in the importing countries for the exported goods of the country experiencing currency appreciation (Business Asia, 2007). Besides the risk of protectionism and other changing exchange rates negative impacts the positive impacts include in the likely situation of appreciation as mentioned above, loosening of control on exchange rates frees the monetary policy to concentrate on the other sectors of the economy. Also the appreciating value of the currency creates major attraction for short-term and high-return investment seekers (Huang, 2010). This can be explained better by Ying Huang’s argument on the main reason of speculative fund inflow to China.
Huang (2010) attempts to decipher the main reason for the inflow of funds into Chinese economy. The massive overseas funds inflow, according to the author, is primarily due to the appreciation in the Chinese Currency which makes it attractive to investors. These funds aim to earn a higher comparative return on short term basis due to high interest rates offered in China as Opposed to that of the United States. And, although, the housing and the stock market appear to be the main attraction of investments since funds may appear to target investment in these markets, however, the attractive appreciating Chinese currency is the major reason of the speculative inflow of funds and not these markets (Huang, 2010).
An appreciating value of Chinese currency shows promising future to the investors who seek high returns in a very short period. The reason being that, in spite of the high interest rates offered to the investors the appreciating value of currency increases the return by an even larger total than just with the high returns. The high returns and increasing value by the virtue of increasing Foreign exchange rate is major attraction for investors. The article pointed out the fact that even though the housing and stock market appear to be the investment targets reeling in the major influx of funds from overseas, however the main star of the speculative flow is the attractive currency of Chinese owing to its appreciating nature. The housing and stock market do not cause this major influx, however they do become the target investments eventually directly or indirectly (Huang, 2010).
This pretty much elaborates our discussion on foreign exchange rate; however, we still need further evidence upon the risk exposures that have been mentioned as an effect to these fluctuations in terms of their impact on economy or investors and why or why not investors decide to take precautionary measures in taking shelters from this kind of risk exposure

Risk Exposure- Avoid it or Avoid Avoiding it?

A decent explanation can be induced by analyzing the perspective of Georgina Lee (Lee, 2009). Lee talks about the increased scrutiny that Chinese state owned businesses have to face now. The derivatives market used to hedge the investments against interest, currency and commodity risk are put under surveillance in order to put constraints on this phenomena and discourage these market transactions that would eventually lead to ‘too much’ hedging that all the risk averse investors would start using these financial instrument to secure their investments. The State-owned Asset Supervision and Administration Commission was spurred into action after several State-owned Enterprises, their subsidiaries and affiliates suffered high losses due to failed foreign exchange, fuel and interest rate hedging contracts (Lee, 2009).
Although, according to Georgina Lee, the use of derivate securities as financial instruments to hedge the investments against certain kind of risks may be a very attractive phenomenon of wisely securing your assets against risk, but it brings forth the new kind of risk associated with it, that is the probability of losing profits in case unexpected adverse circumstances would come into play (Lee, 2009). The article discusses the new limitations and regulations put to scrutinize the state-owned businesses and restrain them from using derivative securities. After observing several high profile losses incurred to state-owned enterprises, the SASAC came into action to prevent further losses due to failed foreign exchange, interest and fuel hedging contracts (Lee, 2009).
Lee’s discussion merely elaborates why Chinese Supervision Commission had to keep in check the derivative markets in order to prevent another experience like past of failed securities. However, it is more of a choice in other countries than of a legislative measure, which is made after analyzing the costs incurred in using the financial hedging instruments (Larry Kirschner, 2009).
Larry Kirschner elaborates upon the Foreign Exchange Rate risk exposure and how and why different companies manipulate the financial derivatives as instrument to manage their risk. Also they write that a few companies would rather not address the foreign exchange risk exposure at all. According to the authors, it requires a great deal of understanding, assessment and prioritization of the exposures before they can apply these any hedging instrument to gain from such investments (Larry Kirschner, 2009).They observe that where many companies have become complacent with their foreign exchange risk management practices, there exist other companies that would rather condone addressing to such exposures. There are many things to consider and much effort required before utilizing any instrument to manage against such risk exposures (Larry Kirschner, 2009).
The implication by the authors enlightens us about the importance of better understanding of the foreign exchange rate fluctuations and risk exposure before they can be manipulated into profit extraction or general hedging against an expected risk of adverse circumstances. The reason for some companies being comfortable with their hedging or risk management practices stands that they understand the further risks attached to it and after having properly assessed, analyzed and derived from the given risks and they have weighed their expectations of gains with current condoning alternative and have reached to a conclusion to generate expectations of comparatively more gains through hedging (Larry Kirschner, 2009). These preliminary requirements are basic necessity and incur some cost as well which discourages other companies from using financial instrument to their own advantage. Thus it can be derived that although risk exposure management may be beneficial for companies to hedge against exchange rate risk, however, it requires careful analysis of international exposures with due consideration given to internal control by the companies (Larry Kirschner, 2009).
The analysis above provides quite an insight on the choices faced by the investors and the reason why they chose to or chose not to use financial derivatives to hedge against the foreign risk. At the end it all depends of your weighted analysis of cost and benefits and risk involved that contribute in the final decision making process (Larry Kirschner, 2009). Despite all these discussions we know from intuition that we as humans would prefer lesser risk. Putting this natural instinct upon financial intuition it should be an understood fact that investors would go for a stable investment of low risk provided he choice is a decision made after thorough analytical efforts. However in light of all the above analysis and our major intuition we should see that due to the depreciating dollar value, many countries’ investors should have switched to a more stable currency as a reserve currency but we observe that dollar still remains to be the reserve currency all over uncontested with the exception of the challenging statement delivered by Governor of People’s bank of China (Montecillo, 2009).
Montecillo (2009) reflects the view of the Governor of People’s Bank of China, Zhou Xiao Chan, that current global financial system faces vulnerability and systematic risks. He also emphasized that reform must create an international reserve currency with stable value, rule based issuance and manageable supply. The article further illustrates on the point made that they are serving as a “unit of accountâ€? and as a “medium of exchangeâ€?. Moreover its “store of valueâ€? is also considered from the perspective of both the government and the private sectors. Following the perspective Governor of people’s Bank of China actually challenged the statement of BSP(the Bangko Sentralng Pilipinas ) that despite declining value of dollar (from 72.7% in end- June2001 to 62.8% as of end- June 2009: the article quotes) dollar will remain the world most widely used currency-Uncontested reserve currency- as no alternative existed as then (Montecillo, 2009).
Another type of risk associated with the foreign exchange rate fluctuation has been thoroughly highlighted in this article enlightened by the challenging statement of Governor of People’s Bank of China. With the declining value of dollar with respect to other currencies, in effect appreciating them against the USD, the risk associated with them puts the investors in reserve currency at exposure (Montecillo, 2009). The stable foreign reserve currency is the requirement for foreign transactions and for investment purposes. However, a fluctuating reserve currency would create imbalance of gains and losses and putting the market players at a high risk of losing money who have invested in a currency with declining value, for example, and need to pay in other currency that would have appreciated against the reserve currency in effect. Thus the declining value of Dollar though may not have challenged its world-wide demand as a reserve currency, but China has contested that perspective in term of demanding a relatively stable alternative and seek shelter from the exposure this foreign exchange rate fluctuation risk (Montecillo, 2009).

Data Analysis

Figure 1: Foreign Direct Investment in China
(The World Bank, 2010)
The figure shows foreign direct investment in China which is increasing over the period at an increasing rate (The World Bank, 2010). The reason can be explained as an induction due to attraction of high interest rates and constantly increasing value of Chinese currency (Huang, 2010). The appreciating Chinese currency is a major attraction for short term foreign investors seeking high returns on their investments. Thus, the increase in the foreign direct investment can be justified by the increase in the Chinese currency against other currencies and also the deprecation of dollar against Asian currencies (Business Asia, 2009).
Figure 2: Growth in Money Supply (percentage change)
(The World Bank, 2010)
The increase in the money supply can be seen as an effort to prevent the adverse consequences expected to be brought up by the simultaneous increase in the value of Chinese Currency against US dollar and the Depreciation of US dollar against Asian currencies (Business Asia, 2009). it is only by selling out domestic currency and buying the foreign currency, that the central bank of china would be able to keep the demand for Chinese currency low and hence low value and keep the foreign reserves high to keep the foreign currency to depreciate against their own currency to avoid the risk of protectionism (Business Asia, 2007). The Foreign reserves record can be observed in figure 2.
Figure 3: China’s Foreign Reserves (includes Gold, Current US$)
(The World bank, 2010)
The figure above shows the increase in the foreign reserve currency ( US dollars) which further supports our claim of China having had used protective measure to keep the appreciation of its currency modest by buying in foreign reserves and selling our domestic currency (The World Bank, 2010). Clearly these efforts have been put into play after 2004 since the foreign direct investment had a peaking high rate of increment till that year as can be observed in the Figure 1 (The World Bank, 2010). And since the value of currency has been attempted to put under control, the threat of protectionist policies against Chinese exports receded as he prices of exports against started to fall as can be observed in the figure 3 (The World bank, 2010).
Figure 4: USD-CNY
(Yahoo, 2010)
We see the appreciating Chinese currency against USD but till 2005 mid a very stable exchange rate points towards the mentioned efforts on behalf of Chinese government by manipulating the money supply to keep the Foreign exchange rate from appreciating (The World Bank, 2010). However, during the period of constant exchange rate or say merely constant keeping a moderate change allowed, the currency did come under pressure (Business Asia, 2009) for its own increasing value to be taken care of while also managing the impact of depreciation of dollar on the Chinese currency and eventually its exports (Business Asia, 2007). After 2006 the monetary policy seems to have been allowed to let lose the exchange rate to be able to concentrate on the other sectors as well (Business Asia, 2007).


The way to go about the research conducted for this term paper is known as the methodology. The method pursued in gathering the required material and data for the paper comprises mostly follows a general type in terms of the form and efforts put in to acquire it. There are majorly three type data sources used for research reports or gathering relevant data on the topic of interest (Lombard, 2010).But our concern is with the Secondary Research or Data Collection method. This includes data and observational facts as already recorded by previous researchers. The provided datasets have already been analyzed and shaped before by previous writers and authors with copyrights protecting their work.
The material from the secondary source is further manipulated and used to assist in making points of information with proper referencing and credits paid to the original workers. As readily available data sets they are a person’s prior choice to any other method. Some negative aspects, however, are associated with the Secondary data sets as well. Despite the time saving and cost saving features of Secondary data sets, there is no guarantee of them meeting the exact requirements of the researcher seeking evidence to support his theories or claims. Furthermore the validity and reliability of the researched data sets may be in question and source can project dubious impressions unless the researches are conducted by reliable sources as government agencies (Lombard, 2010)

Purpose of Research

The purpose of research is to help make the understanding of concepts of foreign exchange rate fluctuations. and its causes and effects and the hedging and investment against these fluctuations easy in light of evidence from Chinese currency revaluation against US Dollars, the investment it induced, and the negative and the positive aspects of the Chinese currency revaluation.

Research Approach and Strategy

Given the purpose of the research and the types of the research explained it comes down to putting it down to defining our Strategy and deciding which approach to adopt (Lombard, 2010). Bearing in mind the scale and the scope of our topic and the limited resources, the best and most efficient approach for us to have, which we adopted, is to gather data from secondary research source upon the evidence of Chinese economy to explain the different aspects of the foreign exchange rate role in the economy.
All our research material refers to a secondary data source, which consists of point of views of different authors publishing their research or findings in articles appearing in periodicals. Our strategy remains to manipulate this secondary source material and mold them to help up support our own claims and concepts without changing the main framework and the meaning of ideas associated with the empirical evidence. This approach not only proved the strategy to be cost effective but also very efficient in term of time saving and with proper citation the sources can tracked back to authenticate their reliability and validity.

Data Collection and Analysis

Provided with the theoretical concepts from different authors point of views (referring to the Literature review), relevant data including charts/data sets recording foreign exchange rate fluctuations in Chinese currency against US Dollar and its induction of investment and other impacts are provided in the section covering statistical data for better analysis of our concepts in view of empirical evidence.


The course of writing this term paper has helped us find and clear quite a few things which need to be summarized in this section. The findings of this research includes the following important concepts

Foreign Exchange Rate Fluctuations and Causes

China’s Foreign exchange rate had been increasing moderately owing to their controlled efforts. The efforts of controlling the exchange rate from fluctuating was in line due to risk of protectionist policies against Chinese exports from EU and US countries because of rapidly increasing value of currency relative to other currencies (Business Asia, 2007). Also there was pressure due to depreciating value of dollar against the Asian currencies which made matters worse and the need for control bigger. The foreign exchange rate was stabilized by diverting monetary policy into manipulating the money supply accordingly to set the foreign exchange rate at fixed level (El-Erian, ONeill, Bergsten, & Mohamed, 2007). Besides the threat of protectionism there was also a positive impact of being included under the impression of having hit a developmental hike.

Foreign Exchange Rate Risk and its Management

The exchange rate fluctuations bring about its own pros and cons. In the case of china, the appreciating value of Chinese currency brought about major investment incentives and a major attraction for short term high return seeking investors (Huang, 2010). And with investment opportunities come forth the risk associated with these investments and its management (Lee, 2009) which in turn brings forth more risks of losing money by using investment derivatives without proper calculation of risk involved in the investment related to the exchange rate fluctuation and correctly predicting FOREX forecast. It is very important to first analyze the risks associated before deciding whether or not to hedge against it or if it is even worth hedging against (Lee, 2009).


Despite what we expect based upon our calculative procedure of forecasting and weighting and comparing alternatives, there is always a chance for an anomaly to exist within all kinds circumstances. With all our observation of increasing Chinese currency value and dollar being instable, we would have expected the world to shift to a more stable and risk free currency as their reserve currency. However, we see that with the exception of challenging statement from the governor of People’s Bank of China, Dollar remains as the reserve currency of most of the countries uncontested (Montecillo, 2009).


We conclude our term paper with summarizing the findings during the course of our research and finally stating the end result to what our findings led us to extract as our conclusion. We found that Fluctuating exchange rates have impacts, both positive and negative on, on different sectors of the economy, especially trade and investment. We also found that investment brings along a lot of risks and it requires a very careful and analyzed decision whether to hedge against these risk or not and using which derivative. We learned that despite our careful calculations, not everything works out according to our predictions and there is always some chance of error in calculations or an unpredictable situation taking over.
The reason for slow appreciation in Chinese Currency against other currency, especially US Dollar, in the first half of the current decade can be credited to the efforts put in to keep the exchange rate from appreciating, which projected a threat of protectionist policies from trading partners against the Chinese exports that were becoming less cheap (Business Asia, 2007). The, efforts however, involved binding the monetary policy to exchange rate fluctuations and keep it from being used for other sectors. On the other hand, if the Chinese had let the exchange rate fluctuate freely, it would free th
respective currency and it can change for user specified foreign currency. Then the employee can view his/her required currency converted details. 1.2 Scope: Scope of the system is to provide Exchange Rate Calculation System. This application is being developed only for the purpose of Currency Conversion and it is developed in such a way that it makes the user to convert his/her savings to their respective foreign currency easily.       Disadvantages:      1.The Administrator(s) has the authority to change the conversion rate.       2. SYSTEM REQUIREMENTS

2.1 H/W System Configuration:-

Processor                             –    Core 4 duo

Speed                                  –    2.5 GHz RAM                                    –    2 GB(min) Hard Disk                            –   70 GB Key Board                           –    Standard Windows Keyboard Mouse                                 –    Two or Three Button Mouse Monitor                                –    SVGA

2.2 S/W System Configuration:-

Operating System             : Windows95/98/2000/XP Software                           : Visual Studio 2010 Database Connectivity       :   MySQL. 2.3 MODULES OF THE SYSTEM

  1. Rate
  2. Convert
  3. Get rates
  4. Get currency

2.3.1  Rate: To get the rate to convert a currency to another. For example, if you need the rate to convert Canadian Dollars to Euros we need to know the rate of conversion of the country. The currency conversion rates will vary fromo country to country. Based on these rates the coversion takes place. 2.3.2 Convert: This is used to convert an amount from one currency to another. For example, if you need to convert 500 American dollars to Indian rupees. This module is responsible for the conversion of the amount into other currencies. 2.3.3 Get rate: This module is used to get a list of all the rate conversions from a base currency. Currently the base currency is always US Dollar. The amount of money is converted from any currency to any other using these rates of conversion.   2.3.4 Get currency: This module is used to get a list of all the available currencies. Currently there are more than 170 out of which few are used in the project.           3. SYSTEM STUDY  FEASIBILITY STUDY The feasibility of the project is analyzed in this phase and business proposal is put forth with a very general plan for the project and some cost estimates. During system analysis the feasibility study of the proposed system is to be carried out. This is to ensure that the proposed system is not a burden to the company.  For feasibility analysis, some understanding of the major requirements for the system is essential. Three key considerations involved in the feasibility analysis are


3.1 ECONOMICAL FEASIBILITY This study is carried out to check the economic impact that the system will have on the organization. The amount of fund that the company can pour into the research and development of the system is limited. The expenditures must be justified. Thus the developed system as well within the budget and this was achieved because most of the technologies used are freely available. Only the customized products had to be purchased. 3.2 TECHNICAL FEASIBILITY This study is carried out to check the technical feasibility, that is, the technical requirements of the system. Any system developed must not have a high demand on the available technical resources. This will lead to high demands on the available technical resources. This will lead to high demands being placed on the client. The developed system must have a modest requirement, as only minimal or null changes are required for implementing this system. 3.3 SOCIAL FEASIBILITY The aspect of study is to check the level of acceptance of the system by the user. This includes the process of training the user to use the system efficiently. The user must not feel threatened by the system, instead must accept it as a necessity. The level of acceptance by the users solely depends on the methods that are employed to educate the user about the system and to make him familiar with it. His level of confidence must be raised so that he is also able to make some constructive criticism, which is welcomed, as he is the final user of the system.                 4. SOFTWARE ENVIRONMENT

4.1 .NET

The .NET Framework (pronounced dot net) is a software framework acquired by Microsoft that runs mainly on Microsoft Windows. It consists a big class library known as Framework Class Library (FCL) and has  language ability(each language can use code written in other languages) across various programming languages. Programs composed for .NET Framework carry out in a software environment (as contrested to hardware environment), acknowledged as Common Language Runtime (CLR), an application virtual machine that allows services such as protection, memory management, and exception handling. FCL and CLR together constitute .NET Framework.   4.2 Design Goals For .NET:

  • Leverage current ActiveX Data Objects (ADO) knowledge.
  •  Support the n-tier programming model
  • Integrate XML support

            5. CODING Home Page: namespace BankApp_ERCS { partial class frmHomePage { private System.ComponentModel.IContainer components = null; protected override void Dispose(bool disposing) { if (disposing && (components != null)) { components.Dispose(); } base.Dispose(disposing); } #region Windows Form Designer generated code private void InitializeComponent() { System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(frmHomePage)); this.pictureBox1 = new System.Windows.Forms.PictureBox(); this.menuStrip1 = new System.Windows.Forms.MenuStrip(); this.homePageToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem(); this.loginToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem(); this.vIEWEXCHANGEToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem(); this.rEGISTERToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem(); this.cONTACTUSToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem(); this.aBOUTUSToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem(); this.eXITToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem(); this.panel2 = new System.Windows.Forms.Panel(); this.lblWelcomeMsg = new System.Windows.Forms.Label(); this.panel1 = new System.Windows.Forms.Panel(); this.label1 = new System.Windows.Forms.Label(); ((System.ComponentModel.ISupportInitialize)(this.pictureBox1)).BeginInit(); this.menuStrip1.SuspendLayout(); this.panel2.SuspendLayout(); this.panel1.SuspendLayout(); this.SuspendLayout(); // // pictureBox1 // this.pictureBox1.BackColor = System.Drawing.Color.White; this.pictureBox1.Image = ((System.Drawing.Image)(resources.GetObject(“pictureBox1.Image”))); this.pictureBox1.Location = new System.Drawing.Point(3, 3); this.pictureBox1.Name = “pictureBox1”; this.pictureBox1.Size = new System.Drawing.Size(149, 126); this.pictureBox1.SizeMode = System.Windows.Forms.PictureBoxSizeMode.StretchImage; this.pictureBox1.TabIndex = 0; this.pictureBox1.TabStop = false; this.pictureBox1.Click += new System.EventHandler(this.pictureBox1_Click); // // menuStrip1 // this.menuStrip1.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(192)))), ((int)(((byte)(255))))); this.menuStrip1.Dock = System.Windows.Forms.DockStyle.Left; this.menuStrip1.Items.AddRange(new System.Windows.Forms.ToolStripItem[] { this.homePageToolStripMenuItem, this.loginToolStripMenuItem, this.vIEWEXCHANGEToolStripMenuItem, this.rEGISTERToolStripMenuItem, this.cONTACTUSToolStripMenuItem, this.aBOUTUSToolStripMenuItem, this.eXITToolStripMenuItem}); this.menuStrip1.Location = new System.Drawing.Point(0, 0); this.menuStrip1.Name = “menuStrip1”; this.menuStrip1.Size = new System.Drawing.Size(195, 504); this.menuStrip1.TabIndex = 5; this.menuStrip1.Text = “menuStrip1”; // // homePageToolStripMenuItem // this.homePageToolStripMenuItem.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(192)))), ((int)(((byte)(192))))); this.homePageToolStripMenuItem.ImageTransparentColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(192)))), ((int)(((byte)(192))))); this.homePageToolStripMenuItem.Margin = new System.Windows.Forms.Padding(5); this.homePageToolStripMenuItem.Name = “homePageToolStripMenuItem”; this.homePageToolStripMenuItem.Padding = new System.Windows.Forms.Padding(4, 4, 4, 30); this.homePageToolStripMenuItem.Size = new System.Drawing.Size(172, 53); this.homePageToolStripMenuItem.Text = “HOME”; this.homePageToolStripMenuItem.Click += new System.EventHandler(this.homePageToolStripMenuItem_Click); // // loginToolStripMenuItem // this.loginToolStripMenuItem.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(255)))), ((int)(((byte)(128))))); this.loginToolStripMenuItem.Margin = new System.Windows.Forms.Padding(5); this.loginToolStripMenuItem.Name = “loginToolStripMenuItem”; this.loginToolStripMenuItem.Padding = new System.Windows.Forms.Padding(4, 4, 4, 30); this.loginToolStripMenuItem.Size = new System.Drawing.Size(172, 53); this.loginToolStripMenuItem.Text = “LOGIN “; this.loginToolStripMenuItem.Click += new System.EventHandler(this.loginToolStripMenuItem_Click_1); // // vIEWEXCHANGEToolStripMenuItem // this.vIEWEXCHANGEToolStripMenuItem.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(128)))), ((int)(((byte)(255)))), ((int)(((byte)(128))))); this.vIEWEXCHANGEToolStripMenuItem.Margin = new System.Windows.Forms.Padding(5); this.vIEWEXCHANGEToolStripMenuItem.Name = “vIEWEXCHANGEToolStripMenuItem”; this.vIEWEXCHANGEToolStripMenuItem.Padding = new System.Windows.Forms.Padding(4, 4, 0, 30); this.vIEWEXCHANGEToolStripMenuItem.Size = new System.Drawing.Size(172, 53); this.vIEWEXCHANGEToolStripMenuItem.Text = “VIEW EXCHANGE RATE CHART”; this.vIEWEXCHANGEToolStripMenuItem.Click += new System.EventHandler(this.vIEWEXCHANGEToolStripMenuItem_Click); // // rEGISTERToolStripMenuItem // this.rEGISTERToolStripMenuItem.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(192)))), ((int)(((byte)(128))))); this.rEGISTERToolStripMenuItem.Margin = new System.Windows.Forms.Padding(5); this.rEGISTERToolStripMenuItem.Name = “rEGISTERToolStripMenuItem”; this.rEGISTERToolStripMenuItem.Padding = new System.Windows.Forms.Padding(4, 4, 4, 30); this.rEGISTERToolStripMenuItem.Size = new System.Drawing.Size(172, 53); this.rEGISTERToolStripMenuItem.Text = “REGISTER “; this.rEGISTERToolStripMenuItem.Click += new System.EventHandler(this.rEGISTERToolStripMenuItem_Click); // // cONTACTUSToolStripMenuItem // this.cONTACTUSToolStripMenuItem.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(128)))), ((int)(((byte)(255)))), ((int)(((byte)(255))))); this.cONTACTUSToolStripMenuItem.Margin = new System.Windows.Forms.Padding(5); this.cONTACTUSToolStripMenuItem.Name = “cONTACTUSToolStripMenuItem”; this.cONTACTUSToolStripMenuItem.Padding = new System.Windows.Forms.Padding(4, 4, 4, 30); this.cONTACTUSToolStripMenuItem.Size = new System.Drawing.Size(172, 53); this.cONTACTUSToolStripMenuItem.Text = “CONTACT US”; this.cONTACTUSToolStripMenuItem.Click += new System.EventHandler(this.cONTACTUSToolStripMenuItem_Click); // // aBOUTUSToolStripMenuItem // this.aBOUTUSToolStripMenuItem.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(128)))), ((int)(((byte)(128)))), ((int)(((byte)(255))))); this.aBOUTUSToolStripMenuItem.Margin = new System.Windows.Forms.Padding(5); this.aBOUTUSToolStripMenuItem.Name = “aBOUTUSToolStripMenuItem”; this.aBOUTUSToolStripMenuItem.Padding = new System.Windows.Forms.Padding(4, 4, 4, 30); this.aBOUTUSToolStripMenuItem.Size = new System.Drawing.Size(172, 53); this.aBOUTUSToolStripMenuItem.Text = “ABOUT US”; this.aBOUTUSToolStripMenuItem.Click += new System.EventHandler(this.aBOUTUSToolStripMenuItem_Click); // // eXITToolStripMenuItem // this.eXITToolStripMenuItem.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(128)))), ((int)(((byte)(255))))); this.eXITToolStripMenuItem.Margin = new System.Windows.Forms.Padding(5); this.eXITToolStripMenuItem.Name = “eXITToolStripMenuItem”; this.eXITToolStripMenuItem.Padding = new System.Windows.Forms.Padding(4, 4, 4, 30); this.eXITToolStripMenuItem.Size = new System.Drawing.Size(172, 53); this.eXITToolStripMenuItem.Text = “EXIT”; this.eXITToolStripMenuItem.Click += new System.EventHandler(this.eXITToolStripMenuItem_Click); // // panel2 // this.panel2.AutoSize = true; this.panel2.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(192)))), ((int)(((byte)(192))))); this.panel2.BackgroundImage = ((System.Drawing.Image)(resources.GetObject(“panel2.BackgroundImage”))); this.panel2.BackgroundImageLayout = System.Windows.Forms.ImageLayout.Stretch; this.panel2.Controls.Add(this.lblWelcomeMsg); this.panel2.Dock = System.Windows.Forms.DockStyle.Fill; this.panel2.Location = new System.Drawing.Point(0, 0); this.panel2.Name = “panel2”; this.panel2.Size = new System.Drawing.Size(1252, 504); this.panel2.TabInd
ex = 8; this.panel2.Paint += new System.Windows.Forms.PaintEventHandler(this.panel2_Paint); // // lblWelcomeMsg // this.lblWelcomeMsg.AutoSize = true; this.lblWelcomeMsg.BackColor = System.Drawing.Color.White; this.lblWelcomeMsg.Font = new System.Drawing.Font(“Modern No. 20”, 18F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.lblWelcomeMsg.Location = new System.Drawing.Point(208, 162); this.lblWelcomeMsg.Name = “lblWelcomeMsg”; this.lblWelcomeMsg.Size = new System.Drawing.Size(592, 25); this.lblWelcomeMsg.TabIndex = 4; this.lblWelcomeMsg.Text = “Welcome To Foreign Exchange Currency Converter !!!!”; // // panel1 // this.panel1.BackColor = System.Drawing.Color.White; this.panel1.Controls.Add(this.label1); this.panel1.Controls.Add(this.pictureBox1); this.panel1.Dock = System.Windows.Forms.DockStyle.Top; this.panel1.Location = new System.Drawing.Point(195, 0); this.panel1.Name = “panel1”; this.panel1.Size = new System.Drawing.Size(1057, 132); this.panel1.TabIndex = 10; // // label1 // this.label1.AutoSize = true; this.label1.BackColor = System.Drawing.Color.White; this.label1.Font = new System.Drawing.Font(“Microsoft Sans Serif”, 26.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.label1.Location = new System.Drawing.Point(390, 23); this.label1.Name = “label1”; this.label1.Size = new System.Drawing.Size(362, 39); this.label1.TabIndex = 5; this.label1.Text = “S&H FOREX Pvt.Ltd.”; this.label1.UseMnemonic = false; // // frmHomePage // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.BackColor = System.Drawing.Color.LightCyan; this.ClientSize = new System.Drawing.Size(1252, 504); this.Controls.Add(this.panel1); this.Controls.Add(this.menuStrip1); this.Controls.Add(this.panel2); this.IsMdiContainer = true; this.MainMenuStrip = this.menuStrip1; this.Name = “frmHomePage”; this.Text = “S&H FOREX Pvt.Ltd.”; this.WindowState = System.Windows.Forms.FormWindowState.Maximized; ((System.ComponentModel.ISupportInitialize)(this.pictureBox1)).EndInit(); this.menuStrip1.ResumeLayout(false); this.menuStrip1.PerformLayout(); this.panel2.ResumeLayout(false); this.panel2.PerformLayout(); this.panel1.ResumeLayout(false); this.panel1.PerformLayout(); this.ResumeLayout(false); this.PerformLayout(); } #endregion private System.Windows.Forms.PictureBox pictureBox1; private System.Windows.Forms.MenuStrip menuStrip1; private System.Windows.Forms.ToolStripMenuItem homePageToolStripMenuItem; private System.Windows.Forms.ToolStripMenuItem loginToolStripMenuItem; private System.Windows.Forms.Panel panel2; private System.Windows.Forms.ToolStripMenuItem vIEWEXCHANGEToolStripMenuItem; private System.Windows.Forms.ToolStripMenuItem rEGISTERToolStripMenuItem; private System.Windows.Forms.ToolStripMenuItem cONTACTUSToolStripMenuItem; private System.Windows.Forms.ToolStripMenuItem aBOUTUSToolStripMenuItem; private System.Windows.Forms.ToolStripMenuItem eXITToolStripMenuItem; private System.Windows.Forms.Panel panel1; private System.Windows.Forms.Label label1; private System.Windows.Forms.Label lblWelcomeMsg; } } Admin Home Page: using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; namespace BankApp_ERCS { public partial class frmAdminHome : Form { public static bool isAdmin = false; public frmAdminHome() { InitializeComponent(); } private void btnViewUsers_Click(object sender, EventArgs e) { frmRegisteredUsers regUser = new frmRegisteredUsers(); regUser.Show(); //this.Hide(); } private void btnViewChart_Click(object sender, EventArgs e) { isAdmin = true; frmViewChart viewChart= new frmViewChart(); viewChart.Show(); } private void btnUpdateChart_Click(object sender, EventArgs e) { } private void btnAddAdmin_Click(object sender, EventArgs e) { this.Close(); } } }     User Home Page: using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace BankApp_ERCS { public partial class frmUserHomePage : Form { public static string var; string addressLoad; SqlCommand sCommand; SqlDataAdapter sAdapter; SqlCommandBuilder sBuilder; DataSet dataSet; // DataTable dataTable; SqlDataReader dataReader; public frmUserHomePage() { InitializeComponent(); } private void menuStrip1_ItemClicked(object sender, ToolStripItemClickedEventArgs e) { } //private void frmUserHomePage_Load(object sender, EventArgs e) //{ //    addressLoad = textBox1.Text; //} private void vIEWCHARTToolStripMenuItem_Click(object sender, EventArgs e) { panel2.Controls.Clear(); frmViewChart frmView = new frmViewChart(); frmView.TopLevel = false; panel2.Controls.Add(frmView); frmView.Show(); } private void panel2_Paint(object sender, PaintEventArgs e) { txtLOUser.Text = frmLoginPage.mobileNumber; } private void lOGOUTToolStripMenuItem_Click(object sender, EventArgs e) { this.Close(); } private void hOMEToolStripMenuItem_Click(object sender, EventArgs e) { frmUserHomePage frm = new frmUserHomePage(); frm.Show(); } private void btnConvert_Click(object sender, EventArgs e) { frmCurrencyConversion cur = new frmCurrencyConversion(); cur.Show(); } private void btnRetrieve_Click(object sender, EventArgs e) { } private void frmUserHomePage_Load(object sender, EventArgs e) { txtLOUser.Enabled = false; string connectionString = @”Data Source=SS\SQLEXPRESS;Initial Catalog=FOREX;Integrated Security=true”; string sql = “SELECT MobileNo,Employee_Name,Bank_AC_No, Addrss,balance FROM tblUserDetails where MobileNo='” + txtLOUser.Text + “‘”; SqlConnection connection = new SqlConnection(connectionString); connection.Open(); sCommand = new SqlCommand(sql, connection); sAdapter = new SqlDataAdapter(sCommand); sBuilder = new SqlCommandBuilder(sAdapter); dataSet = new DataSet(); dataReader = sCommand.ExecuteReader(); bool temp = false; while (dataReader.Read()) { txtName.Text = dataReader.GetString(1); txtAC.Text = dataReader.GetDecimal (2).ToString (); textBox1.Text = dataReader.GetString(3); textBox2.Text = dataReader.GetDecimal(4).ToString(); txtName.Enabled = false; txtAC.Enabled = false; textBox1.Enabled = false; textBox2.Enabled = false; var = textBox2.Text; temp = true; addressLoad = textBox1.Text; } if (temp == false) MessageBox.Show(” Data Not Found!!!”, “Data Not Found”, MessageBoxButtons.OK, MessageBoxIcon.Error); connection.Close(); //connection.Open(); //dataSet = new DataSet(); //sAdapter = new SqlDataAdapter(“select * from Table2”, con); //sAdapter.Fill(dataSet, “Table2″); //connection.Close(); } private void toolStripMenuItem1_Click(object sender, EventArgs e) { button1.Visible = true; textBox1.Enabled = true; textBox1.ReadOnly = false; } private void textBox1_TextChanged(object sender, EventArgs e) { //SqlConnection conn = new SqlConnection( @”Data Source=XS42-0QFIN5E\SQLEXPRESS;Initial Catalog=FOREX;Integrated Security=true”); //        conn.Open(); //        string sql2 = “UPDATE tblUserDetails SET Addrss = ” + textBox1.Text + ” WHERE MobileNo=” + txtLOUser.Text + “;”; //        SqlCommand myCommand2 = new SqlCommand(sql2, conn); //        try //        { //            conn.Open(); //            myCommand2.ExecuteNonQuery(); //        } //        catch (Exception ex) //        { //            Console.WriteLine(“Error: ” + ex); //        } //        finally //        { //            conn.Close(); //        } } private void toolStripMenuItem2_Click(object sender, EventArgs e) { frmCurrencyConversion cur = new frmCurrencyConversion(); cur.Show(); } private void toolStripMenuItem3_Click(object sender, EventArgs e) { this.Close(); } private void button1_Click(object sender, EventArgs e) { string addressChanged = textBox1.Text; if (addressChanged != addressLoad) { SqlConnection conn = ne
w SqlConnection(@”Data Source=SS\SQLEXPRESS;Initial Catalog=FOREX;Integrated Security=true”); conn.Open(); string sql2 = “UPDATE tblUserDetails SET Addrss = ‘” + textBox1.Text + “‘ WHERE MobileNo='” + txtLOUser.Text + “‘”; SqlCommand myCommand2 = new SqlCommand(sql2, conn); try { myCommand2.ExecuteNonQuery(); } catch (Exception ex) { Console.WriteLine(“Error: ” + ex); } finally { conn.Close(); MessageBox.Show(“Address updated successfully”); } } else { MessageBox.Show(“No Changes to save”); } } private void panel1_Paint(object sender, PaintEventArgs e) { } private void textBox1_TextChanged_1(object sender, EventArgs e) { } } }     View Chart: using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace BankApp_ERCS { public partial class frmViewChart : Form { //SqlCommand sCommand; SqlDataAdapter sAdapter; SqlCommandBuilder sBuilder; DataSet dataSet; DataTable dataTable; public frmViewChart() { InitializeComponent(); } private void frmViewChart_Load_1(object sender, EventArgs e) { SqlConnection obj1 = new SqlConnection(@”Data Source=SS\SQLEXPRESS;Initial Catalog=FOREX;Integrated Security=true”); obj1.Open(); string selQuery = “select SerialNo,Country,ExchangeRate from tblExchangeRates”; SqlCommand obj2 = new SqlCommand(selQuery, obj1); sAdapter = new SqlDataAdapter(obj2); dataSet = new DataSet(); sAdapter.Fill(dataSet, “UserDetails”); dataTable = dataSet.Tables[“UserDetails”]; obj1.Close(); dataGridViewChart.DataSource = dataSet.Tables[“UserDetails”]; dataGridViewChart.SelectionMode = DataGridViewSelectionMode.FullRowSelect; if (frmAdminHome.isAdmin) { dataGridViewChart.ReadOnly = false; dataGridViewChart.AllowUserToAddRows = true; frmAdminHome.isAdmin = false; } else { btnUpdate.Visible = false; dataGridViewChart.ReadOnly = true; dataGridViewChart.AllowUserToAddRows = false; } } private void btnUpdate_Click(object sender, EventArgs e) { sBuilder = new SqlCommandBuilder(sAdapter); sAdapter.Update(dataSet, “UserDetails”); MessageBox.Show(“Exhange rates updated successfully !!”, “Update”, MessageBoxButtons.OK, MessageBoxIcon.Information); } } } Currency Conversion: using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace BankApp_ERCS { public partial class frmCurrencyConversion : Form { SqlCommand sCommand; SqlDataAdapter sAdapter; //SqlCommandBuilder sBuilder; DataSet dataSet; //DataTable dataTable; //SqlDataReader dataReader; public frmCurrencyConversion() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { //float num = (float)textBox2.Text; // float num = (float)Convert.ToDouble(textBox2.Text); float num = float.Parse(frmUserHomePage.var); float selectedCountryValue = (float)comboBox1.SelectedValue; float result = num * selectedCountryValue; textBox3.Text = result.ToString() + ” “+ comboBox1.Text; } private void frmCurrencyConversion_Load(object sender, EventArgs e) { textBox2.Text = frmUserHomePage.var + ” ” + “USD”; string connectionString = @”Data Source=SS\SQLEXPRESS;Initial Catalog=FOREX;Integrated Security=true”; string sql = “SELECT * FROM tblExchangeRates “; SqlConnection connection = new SqlConnection(connectionString); connection.Open(); sCommand = new SqlCommand(sql, connection); sAdapter = new SqlDataAdapter(sCommand); //sBuilder = new SqlCommandBuilder(sAdapter); dataSet = new DataSet(); //DataTable table = new DataTable(); sAdapter.Fill(dataSet); comboBox1.DataSource = dataSet.Tables[0]; comboBox1.ValueMember = dataSet.Tables[0].Columns[2].ColumnName; comboBox1.DisplayMember = dataSet.Tables[0].Columns[1].ColumnName; connection.Close(); } private void textBox2_TextChanged(object sender, EventArgs e) { } } }   Form Registration Page: using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace BankApp_ERCS { public partial class frmRegistrationPage : Form { SqlCommand sCommand; SqlDataAdapter sAdapter; SqlCommandBuilder sBuilder; DataSet dataSet; DataTable dataTable; SqlConnection conObj = new SqlConnection(@”Data Source=SS\SQLEXPRESS;Initial Catalog=FOREX;Integrated Security=true”); public frmRegistrationPage() { InitializeComponent(); } private void frmRegistrationPage_Load(object sender, EventArgs e) { conObj.Open(); } private void btnSubmit_Click(object sender, EventArgs e) { Random random = new Random(); float randomNumber = random.Next(10000, 100000); String query = “insert into tblUserDetails(Employee_Name,Company_Name,Bank_AC_No,BankName,SecurityQuestion,Answer,Passwd,MobileNo,Addrss,Balance) values(‘” + txtEmpName.Text + “‘,'” + txtCmpnyName.Text + “‘,'” + txtAC.Text + “‘,'” + txtBankName.Text + “‘,'” + cmbQuestion.Text + “‘,'” + txtAns.Text + “‘,'” + txtPswd.Text + “‘,'” + txtMob.Text + “‘,'” + txtAddr.Text + “‘,'”+randomNumber+”‘)”; SqlCommand cmd = new SqlCommand(query, conObj); cmd.ExecuteNonQuery(); MessageBox.Show(“Registered Successfully!!! “, “SUCCESS”, MessageBoxButtons.OK, MessageBoxIcon.Information); //string sql = “SELECT User_id from tblUserDetails where Employee_Name='” + txtEmpName.Text + “‘ “; ////SqlConnection connection = new SqlConnection(conObj); ////connection.Open(); //sCommand = new SqlCommand(sql, conObj); //sAdapter = new SqlDataAdapter(sCommand); //sBuilder = new SqlCommandBuilder(sAdapter); //dataSet = new DataSet(); //sAdapter.Fill(dataSet, “UserDetails”); //dataTable = dataSet.Tables[“UserDetails”]; //conObj.Close(); //dataGridMsg.DataSource = dataSet.Tables[“UserDetails”]; //dataGridMsg.ReadOnly = true; //dataGridMsg.SelectionMode = DataGridViewSelectionMode.FullRowSelect; } private void btnClear_Click(object sender, EventArgs e) { txtEmpName.Clear(); txtCmpnyName.Clear(); txtBankName.Clear(); txtAC.Clear(); txtPswd.Clear(); txtRePswd.Clear(); txtMob.Clear(); txtAddr.Clear(); } private void txtBankName_TextChanged(object sender, EventArgs e) { } private void dataGridMsg_CellContentClick(object sender, DataGridViewCellEventArgs e) { } } }   Registered Users:   using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace BankApp_ERCS { public partial class frmRegisteredUsers : Form { SqlCommand sCommand; SqlDataAdapter sAdapter; SqlCommandBuilder sBuilder; DataSet dataSet; DataTable dataTable; public frmRegisteredUsers() { InitializeComponent(); } private void frmRegisteredUsers_Load(object sender, EventArgs e) { string connectionString = @”Data Source=SS\SQLEXPRESS;Initial Catalog=FOREX;Integrated Security=true”; string sql = “SELECT Employee_Name, Bank_AC_No, MobileNo, Balance FROM tblUserDetails”; SqlConnection connection = new SqlConnection(connectionString); connection.Open(); sCommand = new SqlCommand(sql, connection); sAdapter = new SqlDataAdapter(sCommand); sBuilder = new SqlCommandBuilder(sAdapter); dataSet = new DataSet(); sAdapter.Fill(dataSet, “UserDetails”); dataTable = dataSet.Tables[“UserDetails”]; connection.Close(); dataGridViewUsers.DataSource = dataSet.Tables[“UserDetails”]; dataGridViewUsers.ReadOnly = true; dataGridViewUsers.SelectionMode = DataGridViewSelectionMode.FullRowSelect; } } } Form login page: using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace BankApp_ERCS { public partial class frmLoginPage : Form { public frmLoginPage() { InitializeComponent(); } public static string mobileNumber; private void linkReg_LinkClicked(object sender
, LinkLabelLinkClickedEventArgs e) { frmRegistrationPage f3 = new frmRegistrationPage(); f3.Show(); this.Hide(); } private void btnUserLogin_Click(object sender, EventArgs e) { mobileNumber = txtUser.Text; if (txtUser.Text == “Admin” || txtUser.Text == “admin” || txtUser.Text == “ADMIN”) { btnUserLogin.Enabled = false; MessageBox.Show(“Please Select the Admin Tab “, “LOGIN ERROR”, MessageBoxButtons.OK, MessageBoxIcon.Error); txtUser.Clear(); btnUserLogin.Enabled = true; } else { string mobileNo = txtUser.Text; string pwd = txtPswd.Text; SqlConnection obj1 = new SqlConnection(@”Data Source=SS\SQLEXPRESS;Initial Catalog=FOREX;Integrated Security=true”); obj1.Open(); string selQuery = “select MobileNo,Passwd from tblUserDetails where MobileNo='” + txtUser.Text + “‘”; SqlCommand obj2 = new SqlCommand(selQuery, obj1); SqlDataReader obj3 = obj2.ExecuteReader(); if (obj3.HasRows) { while (obj3.Read()) { string mblNo = obj3[“MobileNo”].ToString(); string pswd = obj3[“Passwd”].ToString(); if (mblNo == mobileNo && pswd == pwd) { mobileNumber = mblNo; frmUserHomePage userHome = new frmUserHomePage(); userHome.Show(); this.Hide(); } else { MessageBox.Show(“Invalid Credentials “, “LOGIN ERROR”, MessageBoxButtons.OK, MessageBoxIcon.Error); } } } else { MessageBox.Show(“Invalid Credentials “, “LOGIN ERROR”, MessageBoxButtons.OK, MessageBoxIcon.Error); } } } private void btnUserClear_Click(object sender, EventArgs e) { txtUser.Clear(); txtPswd.Clear(); } private void btnAdminLogin_Click(object sender, EventArgs e) { if ((txtAdmin.Text == “Admin” || txtAdmin.Text == “admin” || txtAdmin.Text == “ADMIN”) &&(txtAdPswd.Text == “Ad123$”) ) { frmAdminHome adminHome = new frmAdminHome(); adminHome.Show(); this.Hide(); } else { btnAdminLogin.Enabled = false; MessageBox.Show(“Please Enter Valid Credentials “,”WARNING”,  MessageBoxButtons.OK,MessageBoxIcon.Warning); txtAdmin.Clear(); btnAdminLogin.Enabled = true; } } private void btnAdClear_Click(object sender, EventArgs e) { txtAdmin.Clear(); txtAdPswd.Clear(); } private void linkForgot_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { mobileNumber = txtUser.Text; frmForgotPassword forgot = new frmForgotPassword(); forgot.Show(); } private void frmLoginPage_Load(object sender, EventArgs e) { } private void linkViewChart_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { frmViewChart view = new frmViewChart(); view.Show(); } private void tabPage1_Click(object sender, EventArgs e) { } } }   Forgot password page: using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace BankApp_ERCS { public partial class frmForgotPassword : Form { public static int ss; string secQue; string secAns; string pswd; public frmForgotPassword() { InitializeComponent(); } private void frmForgotPassword_Load(object sender, EventArgs e) { } private void button3_Click(object sender, EventArgs e) { string mobNo = textBox4.Text; SqlConnection obj1 = new SqlConnection(@”Data Source=SS\SQLEXPRESS;Initial Catalog=FOREX;Integrated Security=true”); obj1.Open(); string selQuery = “select SecurityQuestion,Answer,Passwd from tblUserDetails where MobileNo='” + mobNo + “‘”; SqlCommand obj2 = new SqlCommand(selQuery, obj1); SqlDataReader obj3 = obj2.ExecuteReader(); if (obj3.HasRows) { while (obj3.Read()) { secQue = obj3[“SecurityQuestion”].ToString(); secAns = obj3[“Answer”].ToString(); pswd = obj3[“Passwd”].ToString(); textBox1.Text = secQue.ToString(); } } panel1.Visible = true; } private void button1_Click_1(object sender, EventArgs e) { string mobNo = textBox4.Text; if (textBox3.Text == secAns) { textBox2.Text = pswd.ToString(); } else { MessageBox.Show(“Invalid Credentials “, “LOGIN ERROR”, MessageBoxButtons.OK, MessageBoxIcon.Error); } } private void button2_Click_1(object sender, EventArgs e) { this.Close(); } } }   Contact us page: using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; namespace BankApp_ERCS { public partial class frmContactUs : Form { public frmContactUs() { InitializeComponent(); } } }                                 6. SYSTEM DESIGN   6.1 INPUT DESIGN The input design is the link between the information system and the user. It comprises the developing allotment and action for data preparation and those acts are needed to put transaction data in to an accessible form for cococt can be accomplished by checking the computer to read data from a written or printed document or it can occur by having others keying the data direct into system. The design of input focuses on governing the amount of the input needed, administering the errors, preventing adjournment, preventing unnessesary acts and putting the process easy. The input is arranged in such a way so that it provides security and ease of use with confining the privateness.   OBJECTIVES 1. Input Design is the action of changing a user-oriented description of the input into a computer-established system. This design is crucial to avert faults in the data input process and show the correct centering to the direction for acquiring correct data from the computerized system. 2. It is accomplished by making user-friendly screens for the data entry to address big volume of data. The destination of designing input is to attain data entry more comfortable and to be free from faults. The data entry screen is contrived in such a way that all the data controls can be executed. It also allows record considering facilities. 3. When the data is acceded it will assure for its cogency. Data can be enrolled with the aid of screens. Appropriate messages are allowed as when asked so that the user will not be in maize of instant. Thus the aim of input design is to create an input range that is comfortable to follow     6.2 OUTPUT DESIGN A caliber output is one, which assembles the demands of the end user and confronts the data distinctly. In any system consequences of actioning are conveyed to the users and to other system through outputs. In output design it is decided how the data is to be displaced for immediate need and also the hard copy output. It is the most crucial and aim source data to the user. Effective and healthy output design amends the system’s relationship to aid user deciding. 1. Planning computer output should continue in an coordinated, thoughtful manner; the right output must be acquired while assuring that each output component is planned so that people will find the system can use well and efficaciously. When analytic thinking design computer output, they should Name the particular output that is asked to conform to the necessaries. 2. Select methods for delivering data. 3. Create written document, report, or other data format that comprise data acquired by the organization. The end product form of an data system should attain one or more of the following aims.

  • Carry data about past actions, present condition or expulsions of the


  • Signal crucial cases, chances, troubles, or admonitions.
  • Activate an action.
  • Affirm an action.

6.4 UML Concepts The Unified Modelling Language (UML) is a standard language for composing software blue prints. The UML is a language for

  • Visualizing
  • Specifying
  • Constructing
  • Documenting the artifacts of a software intensifier system.

The UML is a language which provides vocabulary and the rules for blending words in that vocabulary for the aim of communicating. A modeling language is a language whose vocabulary and the rules focus on the concession and physical representation of a organization. Modeling affords an agreement of a system. 6.4.1 Building Blocks of the UML The vocabulary of the UML encompasses three kinds of building blocks:

  • Things
  • Relationships
  • Diagrams

Things are the generalizations that are first-class subjects in a example; relationships tie these things together; plots group concerning accumulations of things. 1. Things in the UML There are four kinds of things in the UML:

  • Structural things
  • Behavioral things
  • Grouping things
  • Annotational things

  Structural things are the nouns of UML models. The structural things applied in the project plan are: First, a class is a description of a set of objects that contribution the similar attributes, functionings, relationships and meaning.

Origin Size
open() close() move() display()


Fig: Classes

Second, a use case is a description of set of succession of accomplishes that a system does that affords an evident result of assess to detail actor.  Fig: Use Cases Third, a node is a physical component that subsists at runtime and comprises a computational imagination, in general having at least some computer memory and frequently actioning capacity.  Fig: Nodes Behavioral things are the dynamic parts of UML models. The behavioral thing used is: Interaction: An interaction is a behaviour that contains a set of contents changed amidst a set of objects amongst a detail circumstance to achieve a particular aim. An interaction involves an amount of other components, including messages, activity sequences (the behavior invoked by a message, and links (the connection between objects).  Fig: Messages 2. Relationships in the UML: There are four kinds of relationships in the UML:

  • Dependency
  • Association
  • Generalization
  • Realization

dependency is a semantic relationship between two things in which a change to one thing may affect the semantics of the other thing (the dependent thing).  Fig: Dependencies An association is a structural relationship that describes a set associates, a associate being a connecter among objects. Aggregation is a special kind of association, being a structural relationship amongst a whole and its parts.  Fig: Association A generalization is a specialization/ generalization relationship in which objects of the differentiated component (the child) are commutable for objects of the generalized component (the parent).  Fig: Generalization A realization is a semantic relationship amongst classifiers, whereas in one classifier assigns a abbreviate that some other word assures to accomplish.  Fig: Realization                 6.4.2 UML DIAGRAMS: 1. USE CASE Diagram                                                                                                            FIG USE CASE DIAGRAM The above diagram is Use Case diagram of our system. It shows the set of actions performed by various users. In our system we have 3 types of users. They are 1) Administrator 2) Registered User and 3) Unregistered User. As described earlier, the content in the Ovals are actions performed in the system and those actors are like symbols represent users in system. Those dashed lines from user to action means users are performing those actions respectively.   2. COMPONENT DIAGRAM Screenshot (8) FIG COMPONENT DIAGRAM A component diagram shows various components invoked in system at time of execution of various functions in the system.       3.Deployment Diagram:                              Screenshot (7)                                                       FIG DEPLOYMENT DIAGRAM The deployment diagram shows the architechture of the system as deployment of software artifacts to deployment targets.           Sequence Diagrams:                                             FIG SEQUENCE DIAGRAM 1 This shows the sequence of actions performed in cases of loggin into the application and loggin out.                                            FIG SEQUENCE DIAGRAM 2 This sequence diagram shows the sequence of actions performed when the conversion takes place.                   FIG  SEQUENCE DIAGRAM 3 This sequence diagram shows the sequence of actions performed in order to enter registration details of new users and to submit the registration and add the new user details to the database used.                                            7. SYSTEM TESTING The motive of testing is to find out errors. Testing is the sequence of trying to find out every possible fault or weakness in a work product. It gives a way to check the functionality of components, sub-assemblies, assemblies and/or a finished product It is the process of utilizing software with the intention of ensuring that the Software system meets its requirements and user expectations and doen’t fail in an deniable manner. There are various types of tests. Each test type defines a specific testing requirement.   7.1 TYPES OF TESTS   1. Unit testing Unit testing includes the design of test cases that validate that the internal program logic is working correctly, and that program inputs produce valid and required outputs. All decision branches and internal code flow should be checked. It is the testing of each and every software units of the application . It is done after the completion of an individual unit before integration. This is a structural testing, that depends on understanding of its creation and is invasive. Unit tests perform primary tests at component level and test a particular business process, application, and system configuration. Unit tests check for each unique path of a business process functions accurately to the documented requirements and contains clearly defined inputs and expected results.   2Integration testing Integration tests are structured to test integrated software components to check if they actually run as one single program.  Testing is event driven and is more bothered about the primary outcome of screens or fields. Integration tests depict that despite the fact that the components were individually satisfied, as shown by successfully unit testing, the combination of components is correct and homogeneous. Integration testing is specially aimed at finding out the problems that come up from the combination of components.     3Functional test Functional tests gives systematic demonstrations that functions tested are obtained as specified by the business and technical requirements, system documentation, and user guides. Functional testing concentrates on the following items: ·         Valid Input               :  recognised classes of valid input must be accepted. ·         Invalid Input             : recognized classes of invalid input must be rejected. ·         Functions                  : recognised functions must be executed. ·         Output                       : recognized classes of application outputs must be exercised. ·         Systems/Procedures: interfacing systems or procedures must be implored. Organization and preparation of functional tests is concentrated on requirements, key functions, or special test cases. In addition, systematic coverage involved to identify Business process flows; data fields, predefined processes, and successive processes must be appraised for testing. Before functional testing is completed, additional tests are found out and the effective value of current tests is determined.   4. System Test System testing checks that the whole integrated software system meets requirements. It tests a configuration to check the known and predictable results. An ex
ample of system testing is the configuration oriented system integration test. System testing is based on process descriptions and flows, focusing pre-driven process links and integration points.   5. White Box Testing White Box Testing is a testing in which the software tester has resourceful knowledge of the internal workings, architecture and language of the software, or at least its purpose. It is purposeIt is used to check areas that can’t be reachedand tested  from a black box level.   6. Black Box Testing Black Box Testing is checking the software without any understanding of the internal functions, design architecture or language of the module being tested. Black box tests, as most other kinds of tests, must be written from a most reliable source document, such as specification or requirements document, such as specification or requirements document. It is a testing in which the software under test is considered, as a black box .You cannot “see” inside the box. The test gives inputs to the software and responds to outputs without bothering about how the software actually works. 7.2 Unit Testing: Unit testing is usually performed as part of a combination of code and unit test phases of the software lifecycle, inspite of it it is not uncommon for coding and unit testing to be conducted as two distinct phases. Test procedure and approach Field testing will be conducted manually and functional tests will be written in detail. Test objectives • All field entries must function correctly properly. • Pages must be operated from the indicated link. • The initial screen, messages/promts and responses/outputs must not be delayed. Features to be tested • Verify that the inputs are of the appropriate format • No duplicate/equivalent inputs should be allowed • All links should take the user to the correct specified page.     7.3 Integration Testing Software integration testing is the progressive integration testing of two or more integrated software components on a single platform to produce errors caused by interface flaws. The task of the integration test is to validate that components or software applications, e.g. components in a software system or – one step up – software applications at the company level – interplay without fail. Test Results: All the test cases mentioned above passed successfully. No flaws encountered.   7.4 Acceptance Testing User Acceptance Testing is a crucial phase of any project and requires noteworthy participation by the end user. It also safeguards that the system meets the functional requirements. Test Results: All the test cases mentioned above passed successfully. No flaws encountered.                           8. OUTPUT SCREENS    FIG 8.1 MAIN HOME PAGE  FIG 8.2 USER LOGIN PAGE  FIG 8.3 USER LOGIN CREDENTIALS PAGE  FIG 8.4 ADMIN LOGIN PAGE  FIG 8.5 USER HOME PAGE  FIG 8.6 USER DETAILS PAGE  FIG 8.7 USER EDIT DETAILS PAGE C:\Users\d\AppData\Local\Microsoft\Windows\INetCache\Content.Word\Screenshot (30).png FIG 8.8 CONVERSION PAGE  FIG 8.9 CONERSION PAGE WITH CONVERTED AMOUNT  FIG 8.10 VIEW EXCHANGE RATE CHART PAGE  FIG 8.11 REGISTRATION  PAGE  FIG 8.12 CONTACT US PAGE  FIG 8.13 ABOUT US PAGE  FIG 8.14 ADMIN HOME PAGE  FIG 8.15 ADMIN VIEW USERS PAGE  FIG 8.16 ADMIN’S UPDATING CURRENCY RATE PAGE  FIG 8.17 FOR FORGOT PASSWORD C:\Users\d\AppData\Local\Microsoft\Windows\INetCache\Content.Word\Screenshot (39).png FIG 8.18 MOBILE NUMBER ENTERED IN FORGOT PASSWORD POPUP  FIG 8.19 SECURITY QUESTION IN FORGOT PASSWORD POPUP  FIG 8.20 PASSWORD OBTAINED                       9. CONCLUSION This application helps employees to convert their savings into homeland currency. The users can create ids and link their bank accounts to their id. This would make it easy for the user to have an overall idea about his savings. The admin handles the currency rates and has a record of the registered users and their details.         10. BIBLIOGRAPHY  Sites references Made From: 1) 2) 3) 4) 5) 6) 

EssayHub’s Community of Professional Tutors & Editors
Tutoring Service, EssayHub
Professional Essay Writers for Hire
Essay Writing Service, EssayPro
Professional Custom
Professional Custom Essay Writing Services
In need of qualified essay help online or professional assistance with your research paper?
Browsing the web for a reliable custom writing service to give you a hand with college assignment?
Out of time and require quick and moreover effective support with your term paper or dissertation?