//[HttpGet] public void Post([FromBody] string value) { try { var value1 = $@"Date., Time., Title., Caterogies., Url /N 14.4.2020.,9:00.,ODSC Virtual Conference.,['lectures'].,https://www.meetup.com/Tel-Aviv-Data-Science-ODSC/events/269601942/ 14.4.2020.,16:30.,Evening Zen: Mindful Practices for Creativity & Relaxation.,['fitness'].,https://www.meetup.com/mindfuladventuresIL/events/wxkmlrybccbcc/ 14.4.2020.,17:30.,Evening Zen: Mindful Practices for Creativity & Relaxation.,['fitness'].,https://www.meetup.com/mindfuladventuresIL/events/wxkmlrybcgbsb/ 14.4.2020.,18:00.,tinyML Talk: \Adaptive AI for a Smarter Edge by Sek Chai, Latent AI.,[].,https://www.meetup.com/tinyML-Enabling-ultra-low-Power-ML-at-the-edge-Herzeliyya-IL/events/269905393/ 14.4.2020., 18:00., KaggleIL #10 - WiDS Challenge 1st Place Overview.,[].,https://www.meetup.com/DataHack/events/270028110/ 15.4.2020., 10:30.,[Free event] Virtual AI Career Expo.,['lectures'].,https://www.meetup.com/Tel-Aviv-Data-Science-ODSC/events/269500187/ 15.4.2020.,19:00.,Online Global Startup Pitching Event.,['lectures'].,https://www.meetup.com/StartupBlink-Haifa/events/dsbfrrybcgbtb/ 15.4.2020.,19:00.,Online Global Startup Pitching Event.,['lectures'].,https://www.meetup.com/Startups-in-Tel-Aviv/events/jpbjrrybcgbtb/ 15.4.2020.,20:00.,deeplearning.ai free mini course: Real-world AI Applications in Medicine.,['lectures'].,https://www.meetup.com/Caesarea-Machine-Learning/events/269968767/ 15.4.2020.,20:00.,deeplearning.ai free mini mourse: Real-world AI Applications in Medicine.,['lectures'].,https://www.meetup.com/deeplearning-ai-tel-aviv/events/269968825/ 15.4.2020.,20:30.,Visual Program Represtentation Ideas & Hacking - Virtual Edition.,['lectures'].,https://www.meetup.com/Building-Visual-Support-Tooling-for-Programmers-Workshop/events/khsrdrybcgbtb/ 15.4.2020.,21:00.,What is the Product-C initiative? a Corona-time PM task force.,[].,https://www.meetup.com/P-PS-Product-Product-Strategy-by-Y-Perspective/events/270006332/ 16.4.2020.,9:00.,Community Day - Learn AI.,['lectures'].,https://www.meetup.com/Big-Data-Developers-in-Tel-Aviv-Yafo/events/269902510/ 16.4.2020.,9:00.,Community Day - Learn AI.,['lectures'].,https://www.meetup.com/Tel-Aviv-Streams/events/269913592/ 16.4.2020.,10:00.,SNAP LIVE TALK UX.,['lectures'].,https://www.meetup.com/SNAP-Web-UX-Graphic-Design-Meetup/events/269872549/ 16.4.2020.,10:30.,[Free Event] ODSC Virtual AI Expo.,[].,https://www.meetup.com/Tel-Aviv-Data-Science-ODSC/events/269601959/ 16.4.2020.,15:00.,Dr. Matan Protter: AlphaZero- Reinforcement Learning is a Game Changer.,['lectures'].,https://www.meetup.com/Tel-Aviv-Yafo-Deep-Corona-Academy-Alibaba/events/269906477/ 16.4.2020.,16:00.,Learn AI: Hands on Labs, Leadership, Lessons from AI Experts - Virtual Event.,['lectures'].,https://www.meetup.com/IBM-Startup-Developer-Tel-Aviv/events/269886298/ 16.4.2020.,16:00.,First Tel-Aviv Virtual ACE.,[].,https://www.meetup.com/Israel-Atlassian-User-Group/events/269971112/ 16.4.2020.,16:00.,My Website is Slow, Now What?.,[].,https://www.meetup.com/at-wix/events/270020380/ 16.4.2020.,17:00.,למכור מרחוק - המדריך ליזם: כך תגדילו את הרווחים מהבידוד.,[].,https://www.meetup.com/Fusion-LA-Israel/events/269878021/ 16.4.2020.,17:00.,Execute Inside Sales while in Quarantine.,[].,https://www.meetup.com/RAINMAKERS-IL/events/269896063/ 16.4.2020.,17:00.,יחסי עובד-מעסיק בזמן הקורונה - סשן שאלות ותשובות על דיני עבודה.,['lectures'].,https://www.meetup.com/Fusion-LA-Israel/events/269968613/ 16.4.2020.,18:00.,Design Sprint Webinar: Experiencing the Sprint.,[].,https://www.meetup.com/Design-Sprint-Nation/events/269731799/ 16.4.2020.,18:00.,WEBINAR - How COVID-19 is Affecting Digital Marketing Globally?.,['lectures'].,https://www.meetup.com/Digital-Marketing-Tel-Aviv/events/270022241/ 16.4.2020.,18:30.,DoiT International Google Cloud Quizzical.,['lectures'].,https://www.meetup.com/multicloud/events/269767979/ 16.4.2020.,18:30.,On-line Pair/Mob programming with TDD Workshop.,['lectures'].,https://www.meetup.com/Code-Mavens/events/269912329/ 16.4.2020.,19:00.,Online Workshop - Predict values with regression.,['lectures'].,https://www.meetup.com/Microsoft-Reactor-Tel-Aviv/events/269478251/ 16.4.2020.,19:30.,DataTalks #23: Mathematical models as tools for coping with epidemics.,[].,https://www.meetup.com/DataHack/events/269947668/ 16.4.2020.,20:00.,Working in pajamas: Collaborative design work, from home..,['lectures'].,https://www.meetup.com/Startup-Designers/events/269926240/ 16.4.2020.,20:00.,The Future is Coming Fast: Big Changes to Expect in the Next 10 Yrs-Online Event.,[].,https://www.meetup.com/Amman-Startup-Founder-101/events/269934651/ 16.4.2020.,20:00.,The Future is Coming Fast: Big Changes to Expect in the Next 10 Yrs-Online Event.,[].,https://www.meetup.com/Israel-Startup-Founder-101/events/269934726/ 16.4.2020.,20:00.,The Future is Coming Fast: Big Changes to Expect in the Next 10 Yrs-Online Event.,[].,https://www.meetup.com/Jerusalem-Startup-Founder-101/events/269934918/ 16.4.2020.,20:00.,The Future is Coming Fast: Big Changes to Expect in the Next 10 Yrs-Online Event.,[].,https://www.meetup.com/Ramallah-Startup-Founder-101/events/269934985/ 16.4.2020.,20:30.,חווית מדיטציה בשידור חי.,['fitness'].,https://www.meetup.com/Tel-Aviv-Yafo-Spiritual-Growth-Meetup/events/ljfgrrybcgbvb/ 17.4.2020.,8:30.,Free Live on-line Go course in Hebrew - part 3.,[].,https://www.meetup.com/Code-Mavens/events/269837222/ 17.4.2020.,13:00.,Free Online Guided Meditation- Beginners & Intermediate.,[].,https://www.meetup.com/%D7%9E%D7%93%D7%99%D7%98%D7%A6%D7%99%D7%94-%D7%9C%D7%94%D7%92%D7%A9%D7%9E%D7%94-%D7%A2%D7%A6%D7%9E%D7%99%D7%AA-%D7%95%D7%94%D7%AA%D7%A4%D7%AA%D7%97%D7%95%D7%AA-%D7%A8%D7%95%D7%97%D7%A0%D7%99%D7%AA/events/mcsfrrybcgbwb/ 17.4.2020.,13:00.,Friday Online Guided Meditation: Beginners and Intermediate.,[].,https://www.meetup.com/Tel-Aviv-Yafo-Spiritual-Growth-Meetup/events/klbjrrybcgbwb/ 17.4.2020.,13:00.,Free Online Guided Meditation- Beginners & Above.,[].,https://www.meetup.com/%D7%9E%D7%A4%D7%92%D7%A9%D7%99-%D7%99%D7%95%D7%92%D7%94-%D7%95%D7%9E%D7%93%D7%99%D7%98%D7%A6%D7%99%D7%94-%D7%9C%D7%94%D7%92%D7%A9%D7%9E%D7%94-%D7%A2%D7%A6%D7%9E%D7%99%D7%AA-%D7%91%D7%99%D7%A8%D7%95%D7%A9%D7%9C%D7%99%D7%9D/events/nmbjrrybcgbwb/ 19.4.2020.,9:30.,Tackle Cloud Financial Management with FinOps - Live Webinar.,['lectures'].,https://www.meetup.com/AWS-Quaterly-Updates/events/269867932/ 19.4.2020.,15:00.,Dr. Asi Messica - When Deep Learning Meets Recommender Systems.,['lectures'].,https://www.meetup.com/Tel-Aviv-Yafo-Deep-Corona-Academy-Alibaba/events/270020436/ 19.4.2020.,16:45.,Free Online Guided Meditation: Beginners and Follow-up.,[].,https://www.meetup.com/%D7%9E%D7%93%D7%99%D7%98%D7%A6%D7%99%D7%94-%D7%9C%D7%94%D7%92%D7%A9%D7%9E%D7%94-%D7%A2%D7%A6%D7%9E%D7%99%D7%AA-%D7%95%D7%94%D7%AA%D7%A4%D7%AA%D7%97%D7%95%D7%AA-%D7%A8%D7%95%D7%97%D7%A0%D7%99%D7%AA/events/gjkhrrybcgbzb/ 19.4.2020.,16:45.,Free Online Guided Meditation: Beginners and Intermediate.,[].,https://www.meetup.com/Tel-Aviv-Yafo-Spiritual-Growth-Meetup/events/nlkhrrybcgbzb/ 19.4.2020.,16:45.,Free Online Guided Meditation- Beginners & Above.,[].,https://www.meetup.com/%D7%9E%D7%A4%D7%92%D7%A9%D7%99-%D7%99%D7%95%D7%92%D7%94-%D7%95%D7%9E%D7%93%D7%99%D7%98%D7%A6%D7%99%D7%94-%D7%9C%D7%94%D7%92%D7%A9%D7%9E%D7%94-%D7%A2%D7%A6%D7%9E%D7%99%D7%AA-%D7%91%D7%99%D7%A8%D7%95%D7%A9%D7%9C%D7%99%D7%9D/events/bmkhrrybcgbzb/ 19.4.2020.,18:00.,Pydata April meetup.,['lectures'].,https://www.meetup.com/PyData-Tel-Aviv/events/268808132/ 19.4.2020.,18:00.,Junior Excellerator Program - Live Streaming.,['lectures', 'kids'].,https://www.meetup.com/JR-Devs-IL/events/269831533/ 19.4.2020.,19:00.,הכלים הפרקטיים לקידום האתר שלך, יום ראשון, 19.04.20 ב- 19:00.,[].,https://www.meetup.com/Freelance-Israel/events/269887133/ 19.4.2020.,20:00.,visual productivity toolbox.,[].,https://www.meetup.com/Startup-Designers/events/270020516/ 19.4.2020.,20:00.,הטכנולוגיות שישנו את חיינו - מבט אל העתיד.,[].,https://www.meetup.com/Wize-Night-Talks/events/270039541/ 20.4.2020.,10:00.,Online Workshop: Kubernetes, Docker, Containers for Beginners.,[].,https://www.meetup.com/IBM-Startup-Developer-Tel-Aviv/events/269890614/ 20.4.2020.,10:00.,איך הופכים תהיה לעשייה, 20.04.20 ב- 10:00.,[].,https://www.meetup.com/Freelance-Israel/events/270019809/ 20.4.2020.,15:00.,[Webinar] Haifa Volunteer WordPress Help Desk.,['lectures'].,https://www.meetup.com/Haifa-WordPress-Meetup-Group/events/twdsqrybcgbbc/ 20.4.2020.,17:30.,ironSource Kotlin bootcamp - April.,['lectures'].,https://www.meetup.com/ironSource-Kotlin-bootcamp-April/ 20.4.2020.,18:30.,April Meetup - Online.,[].,https://www.meetup.com/Go-Israel/events/kjvczlybchbjb/ 20.4.2020.,19:00.,Weekly Hasadna hack-night.,[].,https://www.meetup.com/The-Public-Knowledge-Workshop/events/cchvlrybcgbbc/ 20.4.2020.,19:00.,ZK-TLV 0x0b - At Home Edition - MPC-in-the-Head, another ZK approach.,[].,https://www.meetup.com/Zero-Knowledge-Tel-Aviv/events/270030098/ 20.4.2020.,21:00.,Pair-up event #17: Founders looking for co-founders.,[].,https://www.meetup.com/tlvstartuphub/events/269870040/ 20.4.2020.,21:00.,Virtual Pair-up event #17: Founders looking for co-founders.,[].,https://www.meetup.com/TLVStartupHubTech/events/270039565/ 21.4.2020.,10:00.,Build & Deploy Microservice using the 12 Factors methodology., ['lectures']., https://www.meetup.com/IBM-Startup-Developer-Tel-Aviv/events/269646027/ 21.4.2020.,15:00., Virtual Workshop: The Power of Apache Cassandra, Apache Kafka and Elasticsearch., ['fitness']., https://www.meetup.com/Tel-Aviv-AI-Tech-Talks/events/269987749/ 21.4.2020.,16:00., Property-Backed Digital Securities & How They Will Transform Real Estate., []., https://www.meetup.com/Real-Estate-Networking-Meetup-Group/events/269925954/ 22.4.2020.,8:00., DigitalHealth.il+ 2020 SAVE THE DATE!., []., https://www.meetup.com/Digital-Health-Israel/events/265176771/ 22.4.2020.,13:00., לקדם את העסק בפייסבוק לבד ובלי כסף, 22.04.20 ב- 13:00., []., https://www.meetup.com/Freelance-Israel/events/269905594/ 22.4.2020.,15:00., Tom Tirer - GANs N' Denoisers: Appetite for Reconstruction.,[].,https://www.meetup.com/Tel-Aviv-Yafo-Deep-Corona-Academy-Alibaba/events/269772219/ 22.4.2020.,16:00., [ONLINE] Kafka at massive scale: develop & monitor your microservices like a pro., ['lectures']., https://www.meetup.com/ApacheKafkaTLV/events/268831792/ 22.4.2020.,16:00., Unified Endpoint Security - Live Meetup., []., https://www.meetup.com/msc-il/events/269806087/ 22.4.2020.,16:00., Unified Endpoint Security - Live Meetup., []., https://www.meetup.com/Microsoft-Reactor-Tel-Aviv/events/269808641/ 22.4.2020.,16:00., Handling Increasing Load and Reducing Costs During COVID-19 Crisis., ['lectures']., https://www.meetup.com/Israeli-Aerospike-User-Group/events/269809325/ 22.4.2020.,16:00., Virtual meetup- How Agile Are We?., []., https://www.meetup.com/Scrum-Masters/events/270010675/ 22.4.2020.,16:00., [ONLINE] Kafka at massive scale: develop & monitor your microservices like a pro., ['lectures']., https://www.meetup.com/Meetups-at-Riskified/events/270020603/ 22.4.2020.,17:00., Azure IoT Security - Live Meetup., ['lectures']., https://www.meetup.com/msc-il/events/269773302/ 22.4.2020.,17:00., Azure IoT Security - Live Meetup., ['lectures']., https://www.meetup.com/Microsoft-Reactor-Tel-Aviv/events/269905264/ 22.4.2020.,18:00., React-IL Meetup @ Natural Intelligence!., []., https://www.meetup.com/React-IL/events/266866752/ 22.4.2020.,18:00., Basics of Design for Non-Designers., []., https://www.meetup.com/Haifa-Tech-Talks/events/267085314/ 22.4.2020.,18:00., Impact FinTech - from 'Nice to Have' to an Essence - ONLINE EVENT., []., https://www.meetup.com/FinTech-Aviv/events/269786192/ 22.4.2020.,18:00., [ONLINE] Istio - new features, hybrid mesh., []., https://www.meetup.com/cncf-tlv/events/269814330/ 22.4.2020.,18:00., AI as a Service - Live Meetup (MVP Show)., []., https://www.meetup.com/msc-il/events/269895045/ 22.4.2020.,18:00., AI as a Service Overview., []., https://www.meetup.com/Microsoft-Reactor-Tel-Aviv/events/269905286/ 22.4.2020.,19:00., Chatbot Developers & Conversation Designers Unite… Again!., ['lectures']., https://www.meetup.com/Chatbots-And-Conversation-Design/events/269764839/ 22.4.2020.,19:00., Back to Business! Market Entry Strategy for Startups., ['lectures']., https://www.meetup.com/Fusion-LA-Israel/events/270021452/ 23.4.2020.,10:15., rancher virtual rodeo (instead of planned physical meetup).,[].,https://www.meetup.com/rancher-israel/events/269158232/ 23.4.2020.,24:00.,Online meetup: Inside Snowflake., []., https://www.meetup.com/Tel-Aviv-Data-Professionals/events/ctvsgqybcgbfc/ 23.4.2020.,15:00., Webinar (April 23rd): Brazil's Healthcare Market.,['lectures'].,https://www.meetup.com/mHealth-Israel/events/269952135/ 23.4.2020.,16:00.,Moodle 3.9 QA Israel testing Meetup., []., https://www.meetup.com/Moodle-Israel/events/268350827/ 23.4.2020.,16:00., Budget During Covid-19 Times - Eran Schindler., ['lectures']., https://www.meetup.com/Petakh-Tiqwa-Innovation-Center-The-Nest/events/269786522/ 23.4.2020.,16:00., Protect Microsoft Teams with Cloud App Security - Live Meetup., ['lectures']., https://www.meetup.com/msc-il/events/269895982/ 23.4.2020.,16:00., Protect Microsoft Teams with Cloud App Security - Live Meetup., ['lectures']., https://www.meetup.com/Microsoft-Reactor-Tel-Aviv/events/269905305/ 23.4.2020.,17:45., RISC-V Service Tools Virtual Meetup., []., https://www.meetup.com/Israel-RISC-V-meetups/events/269926192/ 23.4.2020.,17:45., RISC-V Service Tools Virtual Meetup., []., https://www.meetup.com/IsraelConsumerHardware/events/269928377/ 23.4.2020.,18:00., AWS Service Mesh & CNCF Envoy., ['lectures']., https://www.meetup.com/AWS-IL/events/268789740/ 23.4.2020.,18:00., Azure DevOps for absolute Beginners - Live Meetup., ['lectures']., https://www.meetup.com/msc-il/events/269893765/ 23.4.2020.,18:00., Azure DevOps for absolute Beginners - Live Meetup., ['lectures']., https://www.meetup.com/Microsoft-Reactor-Tel-Aviv/events/269905349/ 23.4.2020.,18:30., DoiT International Presents: AWS and ECS Networking., ['lectures']., https://www.meetup.com/multicloud/events/269767727/ 23.4.2020.,19:00., Online Workshop - Building and deploying a Django app., ['lectures']., https://www.meetup.com/Microsoft-Reactor-Tel-Aviv/events/269877020/ 23.4.2020.,19:00., Online Event - Microsoft Commercial Marketplace Roadmap: April Updates., ['lectures']., https://www.meetup.com/Microsoft-Reactor-Tel-Aviv/events/270022077/ 23.4.2020.,19:00., Pawan Kumar - Flutter with VelocityX, minimalist UI Framework., []., https://www.meetup.com/GDG-Haifa/events/270029382/ 23.4.2020.,19:30., Model and Data Driven Approach for Object Tracking., ['lectures']., https://www.meetup.com/Computer-Vision-Israel-Meetup/events/270009928/ 23.4.2020.,20:00., Unsupervised Learning and Deep Learning Based Time-Series Forecasting., ['lectures']., https://www.meetup.com/Tel-Aviv-AI-Tech-Talks/events/269946524/ "; List <string> lines = value.Split("\r\n").ToList(); List <Item> items = new List <Item>(); lines.ForEach(line => { if (line.IndexOf("Date") != 0) { string[] column = line.Split(".,"); if (column.Length == 5) { items.Add(new Item { ItemStartDateObj = convertDateAndTimeToDateTime(column[0], column[1]), ItemTitle = column[2], ItemTags = column[3], ItemURL = column[4], ItemDuration = 60 * 60, PlatformID = 1 });; } } }); //List<Item> itemsToInsert = new List<Item>(); DateTime minDate = new DateTime(items.Min(x => x.ItemStartDateObj.Ticks)); DateTime maxDate = new DateTime(items.Max(x => x.ItemStartDateObj.Ticks)); List <Item> itemsLookup = _context.Items.Where(x => x.ItemStartDateObj.Ticks >= minDate.Ticks && x.ItemStartDateObj.Ticks <= maxDate.Ticks).ToList(); items.ForEach(x => { if (!itemsLookup.Exists(y => x.ItemTags == y.ItemTags && x.ItemTitle == y.ItemTitle && x.ItemURL == y.ItemURL && x.ItemStartDateObj == y.ItemStartDateObj)) { _context.Add(x); } }); //_context.Add(itemsToInsert); _context.SaveChanges(); } catch (Exception ee) { } }
private static void insertCsvContentToDb(string filePath) { int count = 0; var line = ""; string fileName = filePath.Split("\\").Last().ToString(); liveyTvContext.RemoveRange(liveyTvContext.Items.Where(x => x.ScarpingSource == fileName)); using (var reader = new StreamReader(filePath)) { while ((line = reader.ReadLine()) != null) { if (count > 0) { var spl = line.Split(".,"); string Date = spl[0]; string Time = spl[1]; string Title = spl[2]; string Caterogies = spl[3]; string Url = spl[4]; var dateTime = convertDateAndTimeToDateTime(Date, Time); Item item = new Item { createDate = DateTime.Now, Categories = null, ItemDescription = "", ItemDuration = 0, ItemEndDateObj = dateTime, ItemImgURL = "", ItemOwner = "", ItemStartDate = 0, ItemStartDateObj = dateTime, ItemTags = Caterogies, ItemTitle = Title, ItemURL = Url, PlatformID = 1, ScarpingSource = fileName }; liveyTvContext.Add(item); } count++; } liveyTvContext.SaveChanges(); } /* * using (var csv = new CsvReader(reader, CultureInfo.InvariantCulture)) * { * csv.Configuration.Delimiter = ".,"; * csv.Configuration.HasHeaderRecord = true; * var records = csv.GetRecords<CsvScrapingInput>(); * liveyTvContext.RemoveRange(liveyTvContext.Items.Where(x => x.ScarpingSource == fileName)); * records.ToList().ForEach(line => * { * Item item = new Item * { * createDate = DateTime.Now, * Categories = null, * ItemDescription = "", * ItemDuration = 0, * ItemEndDateObj = new DateTime(), * ItemImgURL = "", * ItemOwner = "", * ItemStartDate = 0, * ItemStartDateObj = new DateTime(), * ItemTags = line.Caterogies, * ItemTitle = line.Title, * ItemURL = line.Url, * PlatformID = 1, * ScarpingSource = fileName * }; * liveyTvContext.Add(item); * * }); * } */ }