public IActionResult AddOrder(string title, int cost, string link) { OrderModel order = new OrderModel() { //Name = title, //Link = link, //Cost = cost }; using (var db = new BusinessLogic.BusinessLogic()) db.AddOrder(Mapper.Map <OrderBL>(order)); return(Redirect("~/Home/Index")); }
public IActionResult SearchPage() { //SpreadsheetsService myService = new SpreadsheetsService("CoinsOrganizer"); //myService.setUserCredentials("*****@*****.**", "POBEDAnotabt9865122879"); //SpreadsheetQuery query = new SpreadsheetQuery(); //SpreadsheetFeed feed = myService.Query(query); //Console.WriteLine("Your spreadsheets: "); //foreach (SpreadsheetEntry entry in feed.Entries) //{ // Console.WriteLine(entry.Title.Text); //} DeleteAllOrders(); string[] Scopes = { SheetsService.Scope.SpreadsheetsReadonly }; string ApplicationName = "Google Sheets API .NET Quickstart"; UserCredential credential; using (var stream = new FileStream("credentials.json", FileMode.Open, FileAccess.Read)) { string credPath = "token.json"; credential = GoogleWebAuthorizationBroker.AuthorizeAsync( GoogleClientSecrets.Load(stream).Secrets, Scopes, "user", CancellationToken.None, new FileDataStore(credPath, true)).Result; Console.WriteLine("Credential file saved to: " + credPath); } // Create Google Sheets API service. var service = new SheetsService(new BaseClientService.Initializer() { HttpClientInitializer = credential, ApplicationName = ApplicationName, }); // Define request parameters. String spreadsheetId = "13Hh_x_kU9BhBryuIwwGvB6r0PpztjZaVu8y5-5BbeTk"; String range = "'Висилка'!A909:I971"; SpreadsheetsResource.ValuesResource.GetRequest request = service.Spreadsheets.Values.Get(spreadsheetId, range); // Prints the names and majors of students in a sample spreadsheet: // https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit ValueRange response = request.Execute(); IList <IList <Object> > values = response.Values; if (values != null && values.Count > 0) { //Console.WriteLine("Name, Major"); foreach (var row in values) { OrderModel orders = new OrderModel(); if (row.Count == 9) { var index = int.Parse(row[8].ToString() == "." ? "0" : row[8].ToString()); var title = row[0].ToString(); var paid = row[1].ToString() == "т"; double price = 0d; var isDollar = row[4].ToString().Contains("$"); var isZloty = row[4].ToString().Contains("zł"); //if (row[4].ToString() != "") //{ // price = double.Parse(row[4].ToString().Replace("$.", "").Replace(",", "").Replace(" zł", "")); //} var email = row[3].ToString(); var nickname = row[2].ToString(); double soldprice = 0d; if (row[4].ToString() != "") { soldprice = double.Parse(row[4].ToString().Replace(" zł", "").Replace(",", "").Replace("$", "")); } var trackNumber = row[5].ToString(); var orderdetails = row[6].ToString() + " " + row[7].ToString(); //double dollarPrice = 0d; //if (row[11].ToString() != "") //{ // dollarPrice = double.Parse(row[11].ToString().Replace("$", "").Replace(",", "")); //} //var englishName = row[12].ToString(); //bool isInStock = row[7].ToString() != "#N/A"; //var avers = row[1].ToString(); //var revers = row[2].ToString(); //if (avers == "foto") //{ // avers = string.Empty; //} //if (revers == "foto") //{ // revers = string.Empty; //} orders = new OrderModel() { NickName = nickname, IsPaid = paid, TrackNumber = trackNumber, OrderDetails = orderdetails, Email = email, OrderId = index, Name = title, SalePrice = soldprice, SaleCurrency = isZloty ? "zł" : "$", WhereSold = isZloty ? "Allegro" : "Ebay", Link = string.Empty //CoinId = index, //Name = title, //Cost = price, //Link = link, //ZlotyPrice = allegroPrice, //PolishName = allegroName, //DollarPrice = dollarPrice, //EnglishName = englishName, //IsInStock = isInStock, //AversFotoLink = avers, //ReversFotoLink = revers }; } else { } // Print columns A and E, which correspond to indices 0 and 4. //Console.WriteLine("{0}, {1}", row[0], row[4]); if (orders.Link == null) { } if (orders.OrderId != 1018 && orders.OrderId != 0) { using (var db = new BusinessLogic.BusinessLogic()) db.AddOrder(Mapper.Map <OrderBL>(orders)); } } } //else //{ // Console.WriteLine("No data found."); //} //Console.Read(); return(View()); }