//string getHash(string phone, string comment) =>
// CryptoHelper.ComputeSha256Hash(phone + comment + Now());
public BtcAddressEntity getByHash(string hash)
{
SQLiteParameter[] parameters = { new SQLiteParameter("@hash", hash) };
DbDataReader reader = db.All("SELECT * " +
"FROM " + TABLE_NAME + " " +
"WHERE hash LIKE @hash " +
"LIMIT 1;", parameters);
if (reader == null)
{
return(null);
}
reader.Read();
try {
return(new BtcAddressEntity()
{
id = reader.GetValue(0).ToString(),
hash = reader.GetValue(1).ToString(),
btc_addr = reader.GetValue(2).ToString(),
phone = reader.GetValue(3).ToString(),
comment = reader.GetValue(4).ToString(),
income_balance = MoneyParser.ParseString(reader.GetValue(5).ToString()),
wait_balance = MoneyParser.ParseString(reader.GetValue(6).ToString()),
created_at = int.Parse(reader.GetValue(7).ToString()),
updated_at = int.Parse(reader.GetValue(8).ToString()),
client = reader.GetValue(9).ToString(),
paid_from = reader.GetValue(10).ToString()
});
} catch (Exception) { }
return(null);
}
static void Main(string[] args)
{
// 1. Skriv ett program som läser in en fil med växlingskurser och
// sedan konverterar en inmatad valuta till svenska kronor.
// 2. Skapa sedan ett uppslagsverk med valutanamn och skriv ut namnen på valutorna konverteringen sker emellan.
// (Valutor lagras på RegionInfo, en egenskap på CultureInfo)
// 3. Lägg till ett ytterligare val för valuta att konvertera till (förutom SEK).
MoneyConverter moneyConverter = new MoneyConverter("Resources\\Riksbanken_2020-10-13.csv", "SEK");
Console.Write("Skriv in önskad växlings-valuta och mängd (tex 100 usd): ");
string input = Console.ReadLine();
Console.WriteLine("Skriv vilken valuta du vill växla till (tex, GBP)");
string currencyInput = Console.ReadLine();
Money enteredMoney = MoneyParser.Parse(input);
Money convertedMoney = moneyConverter.ConvertToTargetCurrency(enteredMoney);
if (currencyInput != "SEK")
{
convertedMoney = moneyConverter.ConvertFromTargetCurrency(convertedMoney.Amount, currencyInput);
}
Console.WriteLine($"Dina {enteredMoney} ({GetCurrencyName(enteredMoney)}) blir {convertedMoney} ({GetCurrencyName(convertedMoney)})");
}
public void CanGetMoneyFromHtml()
{
var sourceHtml = @"<p xmlns=""http://www.w3.org/1999/xhtml"" class=""indent"">17 October 2019, payment of £16,000 from Fiera Capital (UK) Ltd, 39 St James's Street, London SW1A 1JD, via Chartwell Partners Ltd, 26 High Street, Marlborough SN8 1LZ, for a speaking engagement. Hours: 4 hrs. Fee paid direct to charity. I consulted ACoBA about this one-off fee. (Registered 21 October 2019)</p>";
var result = new MoneyParser().Parse(sourceHtml);
Assert.AreEqual(16000m, result[0].Amount);
}
public void CanGetMultipleMoneyFromHtml()
{
var sourceHtml = @"<p xmlns=""http://www.w3.org/1999/xhtml"" class=""indent"">Name of donor: (1) Conservative Drug Policy Reform Group (CDPRG); (2) Zimmer & Co<br/>Address of donor: (1) Suite 15.17, Citibase, 15th Floor Millbank Tower, 21-24 Millbank, London SW1P 4Q;<br/>(2) 1139 Morgan Road, Suite 11, Montego Bay, Jamaica<br/>Estimate of the probable value (or amount of any donation): (1) Accommodation and subsistence, £521.76;<br/>(2) Flights, £3,262.19<br/>Destination of visit: Kingston, Jamaica<br/>Dates of visit: 23-26 September 2019<br/>Purpose of visit: To meet Jamaican Ministers and policy makers. I was also due to attend and speak at a conference on the regulatory and legislative framework around policy towards cannabis in Jamaica, but the visit was cut short.<br/>(Registered 24 October 2019)</p>";
var result = new MoneyParser().Parse(sourceHtml);
Assert.AreEqual(521.76m, result[0].Amount);
Assert.AreEqual(3262.19m, result[1].Amount);
}
public bm_ratesData Get()
{
try
{
var list = row.Split(';');
return(new bm_ratesData()
{
cource = MoneyParser.ParseString(list[3]),
balance = MoneyParser.ParseString(list[5]),
});
}
catch (Exception) { }
return(null);
}
public List <KeyValuePair <EmailIdentity, TicketClientCreateResponse> > GetLastByClient(TicketClientSettingsData client)
{
List <KeyValuePair <EmailIdentity, TicketClientCreateResponse> > list = new List <KeyValuePair <EmailIdentity, TicketClientCreateResponse> >();
foreach (var email in emails)
{
var text = email.ToMailMessage().Body;
if (text.IndexOf(client.email_parser.is_client) == -1)
{
continue;
}
string matchCodeRow = Regex.Match(text, client.email_parser.code[0]).Value;
string matchCode = Regex.Match(matchCodeRow, client.email_parser.code[1]).Value;
string matchFromRow = Regex.Match(text, client.email_parser.from[0]).Value;
string matchFrom = Regex.Match(matchFromRow, client.email_parser.from[1]).Value;
string matchToRow = Regex.Match(text, client.email_parser.to[0]).Value;
string matchTo = Regex.Match(matchToRow, client.email_parser.to[1]).Value;
string matchBtcAmountRow = Regex.Match(text, client.email_parser.btc_amount[0]).Value;
string matchBtcAmount = Regex.Match(matchBtcAmountRow, client.email_parser.btc_amount[1]).Value;
string matchBtcAddressRow = Regex.Match(text, client.email_parser.btc_address[0]).Value;
string matchBtcAddress = Regex.Match(matchBtcAddressRow, client.email_parser.btc_address[1]).Value;
list.Add(new KeyValuePair <EmailIdentity, TicketClientCreateResponse>(
new EmailIdentity()
{
btcAddr = HTMLHelper.StripHTML(matchBtcAddress).Trim(),
phoneFrom = HTMLHelper.StripHTML(matchFrom).Trim()
},
new TicketClientCreateResponse()
{
account = HTMLHelper.StripHTML(matchTo).Trim(),
comment = HTMLHelper.StripHTML(matchCode).Trim(),
btc_amount = MoneyParser.ParseString(HTMLHelper.StripHTML(matchBtcAmount)),
email = email.ToMailMessage().To.ToString().Trim()
}
));
}
return(list);
}
static void Main(string[] args)
{
// 1. Skriv ett program som läser in en fil med växlingskurser och
// sedan konverterar en inmatad valuta till svenska kronor.
// Exempelvis: 100 USD, eller 50 GBP
// Exempelvis ut: 900 SEK
// 2. Skapa sedan ett uppslagsverk med valutanamn och skriv ut namnen på valutorna konverteringen sker emellan.
// (Valutor lagras på RegionInfo, en egenskap på CultureInfo)
// Alla CultureInfo-objekt kan hämtas via CultureInfo.GetCultures(CultureTypes.SpecificCultures)
// 3. Lägg till ett ytterligare val för valuta att konvertera till (förutom SEK).
// Exempelvis: 100 USD -> GBP eller AUD
string targetCurrency = "SEK";
string targetPath = "Resources\\Riksbanken_2020-10-13.csv";
MoneyConverter moneyConverter = new MoneyConverter(targetPath, targetCurrency);
Console.WriteLine("Skriv in önskad växlings-valuta och mängd (t.ex. 100 USD)");
string input = Console.ReadLine();
Console.WriteLine("Skriv vilken valuta du vill växla till (t.ex. GBP)");
string currencyInput = Console.ReadLine();
Money enteredMoney = MoneyParser.Parse(input);
Money convertedMoney = moneyConverter.ConvertToTargetCurrency(enteredMoney);
if (currencyInput != targetCurrency)
{
convertedMoney = moneyConverter.ConvertFromTargetCurrency(convertedMoney.Amount, currencyInput);
}
Console.WriteLine($"Dina {enteredMoney} ({GetCurrencyName(enteredMoney)}) blir {convertedMoney} ({GetCurrencyName(convertedMoney)})");
}
