public ActionResult Create([Bind(Include = "Id,Name,Message")] Comment comment, bool captchaValid) { comment.TimeStamp = DateTime.Now; if (ModelState.IsValid && !string.IsNullOrWhiteSpace(comment.Name) && !string.IsNullOrWhiteSpace(comment.Message)) { db.Comments.Add(comment); db.SaveChanges(); return(RedirectToAction("Index")); } return(View("ErrorComment")); }
public IActionResult DeleteWalletById(int id) { var wallet = context.Wallets.Find(id); if (wallet == null) { return(NotFound()); } context.Wallets.Remove(wallet); context.SaveChanges(); // Default 404 if delete was successful return(NoContent()); }
public IActionResult DeleteFounderById(int id) { var founder = context.Founders.Find(id); if (founder == null) { return(NotFound()); } context.Founders.Remove(founder); context.SaveChanges(); // Default 404 if delete was successful return(NoContent()); }
//Updates the coin list, adding those who are not there yet public async Task GetAllCoins() { string baseImageAndLinkUrl = "https://www.cryptocompare.com"; string jsonResponse = await SendRequest(@"https://min-api.cryptocompare.com/data/top/mktcapfull?limit=100&tsym=USD" + _apiKey); CurrenciesToplist topList = JsonSerializer.Deserialize <CurrenciesToplist>(jsonResponse); foreach (Datum datum in topList.Data) { Currency currency = new Currency() { Name = datum.CoinInfo.FullName, Symbol = datum.CoinInfo.Name, ValueUSD = 0, WebPage = baseImageAndLinkUrl + datum.CoinInfo.Url, ImageURL = baseImageAndLinkUrl + datum.CoinInfo.ImageUrl }; if (_context.Currencies.FirstOrDefault(c => c.Name == datum.CoinInfo.FullName) == null) { _context.Currencies.Add(currency); } } try { _context.SaveChanges(); } catch (Exception e) { _logger.LogError(e.Message); } }
public IActionResult DeleteAssetById(int id) { var asset = context.Assets.Find(id); if (asset == null) { return(NotFound()); } var forks = context.Assets.Where(c => c.Fork.ID == asset.ID).ToList(); if (forks.Count > 0) { return(NotFound()); } context.Assets.Remove(asset); context.SaveChanges(); // Default 404 if delete was successful return(NoContent()); }
public CryptoController(CryptoContext context) { _context = context; if (_context.CryptoItems.Count() == 0) { // Create new CryptoItems if collection is empty _context.CryptoItems.Add(new CryptoItem { Name = "Bitcoin" }); _context.CryptoItems.Add(new CryptoItem { Name = "Ethereum" }); _context.SaveChanges(); } }
public async Task Import(Guid exchangeId, bool recalculate) { var exchange = _context.Exchanges.Find(exchangeId); var importer = GetImporter(exchange.ExchangeId); var transactions = await importer.GetTransactions(exchange); foreach (var transaction in transactions) { // Check if already in database and skip var row = _context.Transactions.SingleOrDefault(t => t.ExchangeId == exchangeId && t.TransactionKey == transaction.TransactionKey); if (row == null) { _context.Transactions.Add(transaction); _context.SaveChanges(); } } if (recalculate) { BackgroundJob.Enqueue <Calculator>(c => c.RecalculateAll()); } }
static void Main(string[] args) { IWebDriver chromeDriver = new ChromeDriver(); //string pathToFile = @"C:\Users\jnprogrammer9\Documents\Projects\c#\webScrapper-Selenium\webScrapper-Selenium\webScrapper-Selenium\test.txt"; string coinName, coinSymbol, coinPrice, coinMarketCap, coinSupply, coinVolume24hr; chromeDriver.Navigate().GoToUrl("https://coinmarketcap.com/all/views/all/"); var table = chromeDriver.FindElement(By.XPath("//table[@id='currencies-all']")); try { // "//table[@id='currencies-all']//tr[@id='id-bitcoin']//td[@class='no-wrap currency-name']//a[@class='currency-name-container']" // coinName = chromeDriver.FindElement(By.XPath("//table[@id='currencies-all']//tr/td//a[@class='currency-name-container']")).Text; //$x("//table[@id='currencies-all']//tr[@id='id-bitcoin']")[0] // foreach (var row in table.FindElements(By.TagName("tbody"))) coinName = chromeDriver.FindElement(By.XPath("//table[@id='currencies-all']//tr/td//a[@class='currency-name-container']")).Text; coinSymbol = chromeDriver.FindElement(By.XPath("//table[@id='currencies-all']//tr/td[@class='text-left col-symbol']")).Text; coinPrice = chromeDriver.FindElement(By.XPath("//table[@id='currencies-all']//tr/td//a[@class='price']")).Text; // < td class="text-left col-symbol">BTC</td> Console.WriteLine(coinName); Console.WriteLine(coinSymbol); Console.WriteLine(coinPrice); using (var db = new CryptoContext()) { var aCryptoTable = new CryptoTable { CoinName = coinName, CoinSymbol = coinSymbol }; db.CryptoTables.Add(aCryptoTable); db.SaveChanges(); var query = from b in db.CryptoTables orderby b.CoinName select b; foreach (var item in query) { Console.WriteLine(item.CoinSymbol); } } /* coinSymbol = chromeDriver.FindElement(By.XPath("")).Text; * coinPrice = chromeDriver.FindElement(By.XPath("")).Text; * coinMarketCap = chromeDriver.FindElement(By.XPath("")).Text; * coinSupply = chromeDriver.FindElement(By.XPath("")).Text; * coinVolume24hr = chromeDriver.FindElement(By.XPath("")).Text;*/ //Console.WriteLine("{0} {1} Price:{2} MarketCap:{3} Supply:{4} 24Hr Volume: {5}\n",coinName,coinSymbol,coinPrice,coinMarketCap,coinSupply,coinVolume24hr); ////table[@id='currencies-all']//tr[@id='id-bitcoin'] } catch (Exception e) { Console.WriteLine("Error:" + e); } chromeDriver.Close(); Console.WriteLine("No errors thrown"); }