4 currency conversion 2 way

Question

2.00/5 (3 votes)

See more:

i have a currency table,that contain 4 Currency SGD,INR,USD AUD,I need to convert the total 12 conversion Using this api

C#

public static string CurrencyConvert(decimal amount, string fromCurrency, string toCurrency)
   {

       //Grab your values and build your Web Request to the API
       string apiURL = String.Format("https://www.google.com/finance/converter?a={0}&from={1}&to={2}&meta={3}", amount, fromCurrency, toCurrency, Guid.NewGuid().ToString());

       //Make your Web Request and grab the results
       var request = WebRequest.Create(apiURL);

       //Get the Response
       var streamReader = new StreamReader(request.GetResponse().GetResponseStream(), System.Text.Encoding.ASCII);

       //Grab your converted value (ie 2.45 USD)
       var result = Regex.Matches(streamReader.ReadToEnd(), "<span class=\"?bld\"?>([^<]+)</span>")[0].Groups[1].Value;

       //Get the Result
       return result;
   }

SGD to INR;
SGD to USD;
SGD to AUD,

INR to SGD,
INR to USD,
INR to AUD,

AUD to SGD,
AUD to INR,
AUD to USD,

USD to SGD
USD to AUD,
USD to INR,

Posted 20-Dec-15 6:17am

Member 12072368

Updated 21-Dec-15 2:47am

CHill60

v4

Add a Solution

Comments

Kornfeld Eliyahu Peter 20-Dec-15 12:23pm

And how you intend to do that? Using your own table for rates or use some online service for that?
Any starting?

Member 12072368 21-Dec-15 7:52am

I nintegrate google api ("https://www.google.com/finance/converter?a={0}&from={1}&to={2}&meta={3}")
using this link i need to cunvert 4 curruncy each other

Kornfeld Eliyahu Peter 21-Dec-15 8:05am

So? And where is the problem? Call the link with all the combinations and you will have to rate for the moment for each and every one...

Member 12072368 21-Dec-15 13:21pm

public static string CurrencyConvert1()
{

decimal amount = 1;
string fromCurrency = "SGD";
string toCurrency = "INR";
//Grab your values and build your Web Request to the API
string apiURL = String.Format("https://www.google.com/finance/converter?a={0}&from={1}&to={2}&meta={3}", amount, fromCurrency, toCurrency, Guid.NewGuid().ToString());

//Make your Web Request and grab the results
var request = WebRequest.Create(apiURL);

//Get the Response
var streamReader = new StreamReader(request.GetResponse().GetResponseStream(), System.Text.Encoding.ASCII);

//Grab your converted value (ie 2.45 USD)
var result = Regex.Matches(streamReader.ReadToEnd(), "<span class=\"?bld\"?>([^<]+)</span>")[0].Groups[1].Value;
result = result.Replace(toCurrency, "").Trim();
List<tools.sqlcontainer> SQLCommands = new List<tools.sqlcontainer>();
Tools.SqlContainer SQLContainer = new Tools.SqlContainer();
List<sqlparameter> SqlParameters = new List<sqlparameter>();
string ErrorIfAny = string.Empty;
DataSet ds = new DataSet();

SQLContainer.Query = "[Create_Convertion] @fromCurrency,@toCurrency,@conversionrate";

SqlParameters.Add(new SqlParameter("@fromCurrency", fromCurrency));
SqlParameters.Add(new SqlParameter("@toCurrency", toCurrency));
SqlParameters.Add(new SqlParameter("@conversionrate", result));
SQLContainer.SqlParameters = SqlParameters;
SQLCommands.Add(SQLContainer);
bool stat = Tools.GetData(SQLCommands, out ds, out ErrorIfAny);
this is for Single Combination to get the Current conversionrate and insert my datatable

Patrice T 20-Dec-15 12:52pm

Start to work, unless you have a question.

Suvendu Shekhar Giri 20-Dec-15 13:10pm

What have you tried so far?

BillWoodruff 20-Dec-15 13:57pm

Hey, this is the OP's first question here: how about leaving the question open long enough to let them clarify the question.

What exactly is the "currency table" you have now: is it a DataTable ? ... or ? Describe the form it's in, and what you know about its structure. Show the code you use to get, or create, the DataTable, or whatever you are using.

Tomas Takac 21-Dec-15 3:10am

Do not post your code in the comments. Please update your question via the Improve question link. And technically you still didn't ask a question. What is the problem you are facing? What help do you need?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

VR Karthikeyan · Answer 1 · 2015-12-21T16:32:00

Solution 1

Hi, refer this article,
http://www.c-sharpcorner.com/UploadFile/0c1bb2/live-currency-converter-using-Asp-Net-C-Sharp/[^]

Posted 21-Dec-15 16:32pm

VR Karthikeyan

Comments

Member 12072368 22-Dec-15 3:48am

how to insert the conversion rate to database