public Gnome.Core.Model.Database.Transaction Convert(FioTransaction fio) { var settings = new JsonSerializerSettings(); settings.ContractResolver = new TransactionContractResolver(); var data = JsonConvert.SerializeObject(fio, Formatting.None, settings); return(new Gnome.Core.Model.Database.Transaction() { AccountId = fio.AccountId, Amount = fio.Amount, Date = fio.Date, Type = "fio", Data = data }); }
public static FIOTransactionResult GetFIOTransactions(Project project, string token, ApplicationDbContext context, bool loadOnlyAccountInfo, DateTime from) { FIOTransactionResult result = new FIOTransactionResult(); project.Owner.TransactionsLastUpdate = DateTime.Now; try { string url = FioBankHelper.TRANSACTIONS_DATE_PREFIX + token + FioBankHelper.GetDatePostfix(from, DateTime.Now); WebClient client = new WebClient(); string data = ""; try { data = client.DownloadString(url); } catch (Exception e) { result.Error = true; return(result); } if (string.IsNullOrEmpty(data)) { result.Error = true; return(result); } XmlDocument doc = new XmlDocument(); doc.LoadXml(data); if (loadOnlyAccountInfo) { SetAccountInformation(doc, result); result.Error = false; return(result); } XmlNode transactionList = doc.DocumentElement.SelectSingleNode("/AccountStatement/TransactionList"); result.Transactions = new List <FioTransaction>(); if (!transactionList.HasChildNodes) { result.Error = false; return(result); } XmlNodeList transactions = doc.DocumentElement.SelectNodes("/AccountStatement/TransactionList/Transaction"); foreach (XmlNode transactionNode in transactions) { result.Log += "TransactionStart | "; string transactionIDString = transactionNode.SelectSingleNode("column_22").InnerText; result.Log += "ID1: *" + transactionIDString + "* | "; long transactionID; if (!long.TryParse(transactionIDString, NumberStyles.Any, CultureInfo.InvariantCulture, out transactionID)) { result.Log += "ID2|"; result.Error = true; return(result); } result.Log += "ID3: *" + transactionID + "* | "; //Ammount decimal ammount; XmlNode ammountNode = transactionNode.SelectSingleNode("column_1"); if (ammountNode != null && !string.IsNullOrEmpty(ammountNode.InnerText) && !string.IsNullOrWhiteSpace(ammountNode.InnerText)) { if (ammountNode.InnerText.Contains('-')) { continue; } result.Log += "Ammount1: *" + ammountNode.InnerText + "* | "; if (!decimal.TryParse(ammountNode.InnerText, NumberStyles.Any, CultureInfo.InvariantCulture, out ammount)) { double ammountDouble; if (double.TryParse(ammountNode.InnerText.Replace('.', ','), out ammountDouble)) { result.Log += "Ammount2: *" + ammountDouble + "* | "; ammount = Convert.ToDecimal(ammountDouble); } else { result.Log += "Ammount3| "; result.Error = true; return(result); } } } else { ammount = 0; } result.Log += "Ammount4: *" + ammount + "* | "; //Variable symbol long variableSymbol; XmlNode variableSymbolNode = transactionNode.SelectSingleNode("column_5"); if (variableSymbolNode != null && !string.IsNullOrEmpty(variableSymbolNode.InnerText) && !string.IsNullOrWhiteSpace(variableSymbolNode.InnerText)) { result.Log += "VS1: *" + variableSymbolNode.InnerText + "* | "; if (!long.TryParse(variableSymbolNode.InnerText, out variableSymbol)) { result.Log += "VS2|"; result.Error = true; return(result); } } else { variableSymbol = 0; } result.Log += "VS1: *" + variableSymbol + "* | "; //Date DateTime date; XmlNode dateNode = transactionNode.SelectSingleNode("column_0"); if (dateNode != null && !string.IsNullOrEmpty(dateNode.InnerText) && !string.IsNullOrWhiteSpace(dateNode.InnerText)) { if (!DateTime.TryParse(dateNode.InnerText, out date)) { result.Error = true; return(result); } } else { date = DateTime.Now; } //Bank number int bankNumber; XmlNode bankNumberNode = transactionNode.SelectSingleNode("column_3"); if (bankNumberNode != null && !string.IsNullOrEmpty(bankNumberNode.InnerText) && !string.IsNullOrWhiteSpace(bankNumberNode.InnerText)) { if (!int.TryParse(bankNumberNode.InnerText, out bankNumber)) { result.Error = true; return(result); } } else { bankNumber = 0; } string note = transactionNode.SelectSingleNode("column_25") != null?transactionNode.SelectSingleNode("column_25").InnerText : ""; string accountNumber = transactionNode.SelectSingleNode("column_2") != null?transactionNode.SelectSingleNode("column_2").InnerText : ""; FioTransaction fioTransaction = new FioTransaction() { AccountNumber = accountNumber, BankCode = bankNumber, Amount = ammount, Date = date, TransactionID = transactionID, Note = note, VariableSymbol = variableSymbol }; result.Log += fioTransaction.ToString() + " ||| "; result.Transactions.Add(fioTransaction); } } catch (Exception e) { result.Log += e.Message + " |||| " + e.StackTrace; result.Error = true; return(result); } result.Error = false; return(result); }