private async Task AddRecipesAsync() { var list = await GetAllRecepiesFromHttpRequest(); SQLiteAsyncConnection conn = new SQLiteAsyncConnection(dbName); await conn.InsertAllAsync(list); }
async void RecreateDb (SQLiteAsyncConnection connection, bool init) { await connection.CreateTablesAsync<Ticket, User> (); if (init) { await connection.InsertAllAsync (new [] { new User{ Name = "Dmitry Reshetnik", CreationDateTime = DateTime.UtcNow }, new User{ Name = "Oleg Tyshchenko", CreationDateTime = DateTime.UtcNow }, }); } }
private async Task PrepareDatabase() { var path = Path.Combine(Path.GetDirectoryName(typeof(TodoService).Assembly.Location), "todos.db"); if (File.Exists(path)) File.Delete(path); var db = new SQLiteAsyncConnection(path); await db.CreateTableAsync<TodoItem>(); var count = await db.InsertAllAsync(Todos); Assert.Equal(Todos.Count, count); }
private async Task AddLikesAsync() { var likesList = new List<Likes>() { new Likes() { recipeName = "beetroot", memName = "samuel" }, }; SQLiteAsyncConnection conn = new SQLiteAsyncConnection("RecipeGeneratorApp.db"); await conn.InsertAllAsync(likesList); }
//TODO:remove method public static async Task CreateDataBaseAsync(this Activity context, int taskCount, int bonusCount) { var path = Rep.Instance.DataBaseFile; var connection = new SQLiteAsyncConnection(path); //File.Delete(path); if (!File.Exists(path)) { var results = await connection.CreateTablesAsync<TaskTable, BonusTable, CategoryTable>(); if (results.Results.Count == 3) { var tasks = GetTasks(context.Assets.Open("Task.csv")); var bonuses = GetBonus(context.Assets.Open("Bonus.csv")); var category = GetCategory(context.Assets.Open("Category.csv")); await connection.InsertAllAsync(tasks); await connection.InsertAllAsync(bonuses); await connection.InsertAllAsync(category); } } await Rep.Instance.TaskGenerateAsync(taskCount); await Rep.Instance.BonusGenerateAsync(bonusCount); }
private async Task AddUniversitiesAsync() { // Create a Universities list var universitiesLists = new List<Universities>() { new Universities() { Name = "Tshwane University of Technology", }, new Universities() { Name = "University Of Johannesburg", }, new Universities() { Name = "University Of Pretoria", }, new Universities() { Name = "University Of Limpopo", }, new Universities() { Name = "University of South Africa", }, new Universities() { Name = "University of Kwazulu Natal", }, new Universities() { Name = "University of Stellenbosch", }, new Universities() { Name = "University of Mpumalanga", }, new Universities() { Name = "University of Venda", }, new Universities() { Name = "Nelson Mandela Metropolitan Univesity", }, /////////////////////////////////////////////////////////New new Universities() { Name = "North West University", }, new Universities() { Name = "University of the Witwatersrand", }, new Universities() { Name = "University of Cape Town", }, new Universities() { Name = "Durban University of Technology", }, new Universities() { Name = "University of the Western Cape", }, new Universities() { Name = "Walter Sisulu University", }, new Universities() { Name = "Cape Peninsula University of Technology", }, new Universities() { Name = "Vaal University of Technology", }, new Universities() { Name = "Sol Plaatje University", }, }; // Add rows to the User Table SQLiteAsyncConnection conn = new SQLiteAsyncConnection("institutionFinder.db"); await conn.InsertAllAsync(universitiesLists); }
private async Task AddCoursesAsync() { // Create a users list var userList = new List<Courses>() { new Courses() { Id = 21, courses = "IT", }, new Courses() { Id = 24, courses = "International Law and Global Justice - LLM", }, new Courses() { Id = 20, courses = "Public Management", }, new Courses() { Id = 19, courses = "Legal Practice - MA", }, new Courses() { Id = 20, courses = "Translation Studies - MA", }, new Courses() { Id = 18, courses = "Political Theory - MA", }, new Courses() { Id = 22, courses = "English Studies (online) - MA (distance learning)", }, new Courses() { Id = 28, courses = "Ethnomusicology - MA", }, new Courses() { Id = 21, courses = "Creative Writing - MA", }, new Courses() { Id = 29, courses = "Translational Neuroscience - MSc", }, new Courses() { Id = 30, courses = "Periodontics - DClinDent", }, new Courses() { Id = 25, courses = "Health Economics and Decision Modelling - MSc", }, new Courses() { Id = 19, courses = "Language Practise", }, new Courses() { Id = 15, courses = "Dental Technology - MSc", }, new Courses() { Id = 18, courses = "Dementia Studies - MA", }, new Courses() { Id = 25, courses = "Cancer Care - PG Cert", }, new Courses() { Id = 22, courses = "Data Communications - MSc(Eng)", }, new Courses() { Id = 31, courses = "Civil Engineering – MSc", }, new Courses() { Id = 26, courses = "Dental Materials Science - MSc", }, new Courses() { Id = 30, courses = "Advanced Mechanical Engineering - MSc(Res)", }, new Courses() { Id = 31, courses = "Architectural Engineering Design - MSc(Eng)", }, new Courses() { Id = 22, courses = "Finance - MSc", }, new Courses() { Id = 21, courses = "Marketing Management Practice - MSc", }, new Courses() { Id = 20, courses = "Leadership and Management - MSc", }, new Courses() { Id = 26, courses = "Political Communication", }, new Courses() { Id = 26, courses = "Department of Geography, Faculty of Social Sciences", }, new Courses() { Id = 17, courses = "School of Languages and Cultures, Faculty of Arts and Humanities", }, new Courses() { Id = 20, courses = "Information Management", }, new Courses() { Id = 16, courses = "Human Resource Management", }, new Courses() { Id = 20, courses = "Global Journalism ", }, new Courses() { Id = 21, courses = "Financial Economics ", }, new Courses() { Id = 28, courses = "Educational Studies ", }, new Courses() { Id = 28, courses = "Education ", }, new Courses() { Id = 26, courses = "Creative Writing", }, new Courses() { Id = 21, courses = "Computer Science, Advanced (Enterprise Computing)", }, new Courses() { Id = 24, courses = "Business Administration", }, new Courses() { Id = 30, courses = "Quantity Survey Engineering", }, new Courses() { Id = 19, courses = "Applied Linguistics with TESOL - MA/Diploma", }, new Courses() { Id = 26, courses = "Advanced Software Engineering - MSc(Eng)", }, new Courses() { Id = 25, courses = "Utility Lineworker Technology", }, new Courses() { Id = 17, courses = "Health Care Assistant", }, new Courses() { Id = 16, courses = "Commercial Truck Driving", }, new Courses() { Id = 24, courses = "Business & Marketing Management", }, new Courses() { Id = 23, courses = "Automation & Control", } }; // Add rows to the User Table SQLiteAsyncConnection conn = new SQLiteAsyncConnection("institutionFinder.db"); await conn.InsertAllAsync(userList); }
private async Task LottoSavedAsync() { var saved = new List<LottoSaved>() { new LottoSaved() { num1 = 2, num2 = 1, num3 = 34, num4 = 3, num5 = 23, num6 = 9 }, }; SQLiteAsyncConnection conn = new SQLiteAsyncConnection("LottoAppProject.db"); await conn.InsertAllAsync(saved); }
private async Task LottoPlusResultsAsync() { var res = new List<LottoPlusResults>() { new LottoPlusResults() { date = "2015-08-20", num1 = 0, num2 = 0, num3 = 0, num4 = 0, num5 = 0, num6 = 0, bonus = 0 }, }; SQLiteAsyncConnection conn = new SQLiteAsyncConnection("LottoAppProject.db"); await conn.InsertAllAsync(res); }
private async Task AddUsersAsync() { // Create a users list var duaList = new List<Dualar>() { new Dualar() { DuaName = "Allahu Ekber", Dua = "Allahu Ekber", kacKezOkunmali=100, kacKezOkundu=0 }, new Dualar() { DuaName = "La ilahe İllallah", Dua = "La ilahe İllallah", kacKezOkunmali=100, kacKezOkundu=0 }, new Dualar() { DuaName = "Subhanallah", Dua = "Subhanallah", kacKezOkunmali=100, kacKezOkundu=0 }, new Dualar() { DuaName = "Elhamdulillah", Dua = "Elhamdulillah", kacKezOkunmali=100, kacKezOkundu=0 }, new Dualar() { DuaName = "Tövbe Estağfurullah", Dua = "Tövbe Estağfurullah", kacKezOkunmali=100, kacKezOkundu=0 }, new Dualar() { DuaName = "Kelime-i Tevhid", Dua = "La ilahe İllallah, Muhammedün Resulullah", kacKezOkunmali=100, kacKezOkundu=0 }, new Dualar() { DuaName="Kelime-i Şehadet", Dua ="Eşhedü en la ilahe illallah ve eşhedü enne Muhammeden abdühü ve resulühü", kacKezOkunmali=100, kacKezOkundu=0 }, new Dualar() { DuaName ="Salavat-ı Şerif", Dua = "Allahümme Salli Ala Seyyidina Muhammedin ve Ala Ali Seyyidina Muhammed", kacKezOkunmali=100, kacKezOkundu=0 } }; var sayacList = new List<Zikirmatik>() { new Zikirmatik() { Counter=0 } }; // Add rows to the User Table SQLiteAsyncConnection conn = new SQLiteAsyncConnection("duaDB.db"); await conn.InsertAllAsync(duaList); await conn.InsertAllAsync(sayacList); //Zikirmatiğin sayacı son kaldığı değere setleniyor var allusers = await conn.QueryAsync<Zikirmatik>("SELECT Counter FROM ZikirmatikSayac WHERE Id = 1"); foreach (var user in allusers) { Sayac.Text = user.Counter.ToString(); } }
public static async Task<bool> UpdateDataAsync() { bool updated = false; WebHelper webHelper = new WebHelper(); if (await webHelper.getAllData()) { SQLiteAsyncConnection conn = new SQLiteAsyncConnection(Windows.Storage.ApplicationData.Current.LocalFolder.Path + "\\Data.db"); await conn.DropTableAsync<Term>(); await conn.DropTableAsync<Lesson>(); await conn.DropTableAsync<Exam>();//删除之前的数据 await conn.DropTableAsync<Course>();//不提示成绩更新情况下,直接删除成绩 await conn.CreateTablesAsync<Course, Term, Lesson, Exam>(); await conn.InsertAllAsync(webHelper.Exams);//update exams; await conn.InsertAllAsync(webHelper.Terms); await conn.InsertAllAsync(webHelper.Lessons); await conn.InsertAllAsync(webHelper.Courses); Term.ClearData(); Exam.ClearData(); WeekDay.ClearData(); updated = true; } return updated; ////区分有无成绩更新,方便后续扩展出成绩提示 //var previousCourses = terms.SelectMany(term => term.Courses); //var updateCourses = from course in webHelper.Courses // let previousCourse = from tempCourse in previousCourses // where tempCourse.CourseName == course.CourseName && // tempCourse.TermNumber == course.TermNumber && // (tempCourse.GradePoints != course.GradePoints | tempCourse.MakeUpExamGrades != course.MakeUpExamGrades) // select tempCourse // where previousCourse.Any() // select course; //var newCourses = from course in webHelper.Courses // let previousCourse = from tempCourse in previousCourses // where tempCourse.CourseName == course.CourseName && // tempCourse.TermNumber == course.TermNumber // select tempCourse // where !previousCourse.Any() // select course; //var updatedCourse = updateCourses.ToList(); // var newcourses = newCourses.ToList(); //if (updateCourses.Any() | newCourses.Any()) //{ // try // { // await conn.InsertAllAsync(newCourses); // await conn.UpdateAllAsync(updateCourses); // } // catch (Exception) // { // await conn.DropTableAsync<Course>(); // var message = new Windows.UI.Popups.MessageDialog("更新本地数据出错,建议或重试,或进入设置删除本地账号和数据或重启应用后再导入"); // await message.ShowAsync(); // } // updated = true; //} }
/// <summary> /// Supposed to add 3 records to table /// Upon query only get first returned /// BUT id is incremented for 3 records added ??? /// </summary> public async void InsertList() { SQLiteAsyncConnection connection = new SQLiteAsyncConnection(textBox.Text); var SensorList = new List<Sensor>() { new Sensor() { dateTime = DateTime.Now, Name="Temperature1", Value = GetRandomValue("Temperature1") }, new Sensor() { dateTime = DateTime.Now, Name="Temperature2", Value = GetRandomValue("Temperature2") }, new Sensor() { dateTime = DateTime.Now, Name="Humidity1", Value = GetRandomValue("Humidity1") } }; int n = await connection.InsertAllAsync(SensorList); }
private async Task AddArticlesAsync() { // Create a Articles list var list = new List<Article>() { new Article() { Title = "Hackers exploit touch payment tech", Content = "Security experts testing ways to break smartphone software have found several bugs in the NFC payment system found on many handsets." }, new Article() { Title = "Assassin's Creed glitches criticised", Content = "Widespread glitches in French Revolution-set Assassin's Creed: Unity have put its publisher Ubisoft under pressure." } }; // Add rows to the Article Table SQLiteAsyncConnection conn = new SQLiteAsyncConnection(dbName); await conn.InsertAllAsync(list); }
private static Task CreateDatabase (SQLiteAsyncConnection connection, CancellationToken cancellationToken) { return Task.Factory.StartNew(() => { //Create the tables var createTask = connection.CreateTablesAsync (tableTypes); createTask.Wait(); //Count number of assignments var countTask = connection.Table<Assignment>().CountAsync(); countTask.Wait(); //If no assignments exist, insert our initial data if (countTask.Result == 0) { var insertTask = connection.InsertAllAsync(TestData.All); //Wait for inserts insertTask.Wait(); //Mark database created initialized = true; } }); }
private async Task AddUsersAsync() { var userList = new List<User>() { new User() { Surname = "Bisho", name = "Samuel" }, }; SQLiteAsyncConnection conn = new SQLiteAsyncConnection("LottoAppProject.db"); await conn.InsertAllAsync(userList); }
private async Task CreateTaiKhoanItems() { var taikhoanlist = new List<taikhoan> { new taikhoan() { Tentaikhoan = "Tiền mặt", Sotienbandau = "-10000000", Loaitiente = "USD", Loaitaikhoan = "Ví", Ghichu = "Không có" } }; var ghichepList = new List<ghichep> { new ghichep() { Ghichu = "Khong co", Mucdichchi="khong biet", Loai = "Thu tien", Sotien = "1202" } }; // Add rows to the taisan Table SQLiteAsyncConnection conn = new SQLiteAsyncConnection("moneybook.db"); await conn.InsertAllAsync(taikhoanlist); await conn.InsertAllAsync(ghichepList); }
private async Task LottoLiveResultsAsync() { var result = new List<LottoLiveResults>() { new LottoLiveResults() { date = "2015-08-20", num1 = 10, num2 = 30, num3 = 20, num4 = 40, num5 = 44, num6 = 5, bonus = 3 }, }; SQLiteAsyncConnection conn = new SQLiteAsyncConnection("LottoAppProject.db"); await conn.InsertAllAsync(result); }
private async Task<string> insertUpdateAllData(IEnumerable<Person> data, string path) { try { var db = new SQLiteAsyncConnection(path); if (await db.InsertAllAsync(data) != 0) await db.UpdateAllAsync(data); return "List of data inserted or updated"; } catch (SQLiteException ex) { return ex.Message; } }
private async Task PowerBallResultsAsync() { var winnings = new List<PowerBallResults>() { new PowerBallResults() { dateP = "2015-08-20", numA = 10, numB = 20, numC = 30, numD = 40, numE = 44, bonusP = 33 }, }; SQLiteAsyncConnection conn = new SQLiteAsyncConnection("LottoAppProject.db"); await conn.InsertAllAsync(winnings); }
public async Task InsertAll <T>(List <T> items) where T : BaseModel, new() { await connection.InsertAllAsync(items); }
private async Task PowerBallSavedAsync() { var store = new List<PowerBallSaved>() { new PowerBallSaved() { num1 = 2, num2 = 4, num3 = 34, num4 = 1, num5 = 33 }, }; SQLiteAsyncConnection conn = new SQLiteAsyncConnection("LottoSA.db"); await conn.InsertAllAsync(store); }
private async Task AdministratorAsync() { var Admin = new List<Administrator>() { new Administrator() { firstName = "Buti", surname = "Bisho", email = "*****@*****.**", password = "******" }, }; SQLiteAsyncConnection conn = new SQLiteAsyncConnection("LottoAppProject.db"); await conn.InsertAllAsync(Admin); }
private async Task AddCollegeAsync() { // Create a users list var CollegeLists = new List<College>() { new College() { Name = "Port Elizabeth TVET College", }, new College() { Name = "Central JHB TVET College", }, new College() { Name = "Sedibeng TVET College", }, new College() { Name = "Tshwane North TVET College", }, new College() { Name = "CN Mahlangu", }, new College() { Name = "Sekhu-khune TVET College", }, new College() { Name = "Thekwini TVET College", }, new College() { Name = "False Bay TVET College", }, new College() { Name = "South Cape TVET College", }, new College() { Name = "Buffalo City TVET College", }, ///////////////////new new College() { Name = "Ikhala FET College", }, new College() { Name = "King Hintsa FET College", }, new College() { Name = "Goldfields FET College", }, new College() { Name = "Elangeni FET College", }, new College() { Name = "Majuba FET College", }, new College() { Name = "Letaba FET College", }, }; // Add rows to the User Table SQLiteAsyncConnection conn = new SQLiteAsyncConnection("institutionFinder.db"); await conn.InsertAllAsync(CollegeLists); }
private async Task AddMembersAsync() { var memberList = new List<Member>() { new Member() { name = "Samuel", surname = "Bisho", email = "*****@*****.**", password = "******" }, }; SQLiteAsyncConnection conn = new SQLiteAsyncConnection("RecipeGeneratorApp.db"); await conn.InsertAllAsync(memberList); }
private async Task AddUsersAsync() { // Create a users list var CampusesList = new List<Campuses>() { new Campuses() { City = "Tshwane University of Technology", Name = "Soshanguve South Campus", WebsiteLink = "www.tut.ac.za", Latitude = -25.540486, Longitude = 28.096136 }, new Campuses() { City = "Tshwane University of Technology", Name = "Soshanguve North Campus", WebsiteLink = "www.tut.ac.za", Latitude = -25.540486, Longitude = 28.096136 }, new Campuses() { City = "Tshwane University of Technology", Name = "Pretoria Campus", WebsiteLink = "www.tut.ac.za", Latitude = -25.7339177, Longitude = 28.1631843 }, new Campuses() { City = "Tshwane University of Technology", Name = "Malahleni Campus", WebsiteLink = "www.tut.ac.za", Latitude = -25.8777006, Longitude = 29.2365414 }, new Campuses() { City = "Tshwane University of Technology", Name = "Nelspruit Campus", WebsiteLink = "www.tut.ac.za", Latitude = -25.540486, Longitude = 28.096136 }, new Campuses() { City = "Tshwane University of Technology", Name = "Ga-Rankuwa Campus", WebsiteLink = "www.tut.ac.za", Latitude = -25.6110577, Longitude = 28.0056446 }, new Campuses() { City = "University Of Johannesburg", Name = "Bunting Road Campus", WebsiteLink = "www.uj.ac.za", Latitude = -26.1892543, Longitude = 28.0132699 }, //TNC new Campuses() { City = "University Of Johannesburg", Name = "Soweto Campus", WebsiteLink = "www.uj.ac.za", Latitude =-26.26078, Longitude = 27.92357 }, new Campuses() { City = "University Of Johannesburg", Name = "Auckland Park Campus ", WebsiteLink = "www.uj.ac.za", Latitude = -26.18359, Longitude = 27.9976812 }, new Campuses() { City = "Port Elizabeth TVET College", Name = "Mthatha Campus", WebsiteLink = "www.tnc.ac.za", Latitude = -33.9614199, Longitude = 25.61021 }, new Campuses() { City = "Port Elizabeth TVET College", Name = "Dower Campus ", WebsiteLink = "www.rosebank.ac.za", Latitude = -33.9614199, Longitude = 25.61021 }, new Campuses() { City = "University Of Limpopo", Name = "Polokwane campus", WebsiteLink = "www.ul.ac.za", Latitude = -23.90877, Longitude = 29.45807 }, new Campuses() { City = "University Of Limpopo", Name = "Medunsa campus", WebsiteLink = "www.ul.ac.za", Latitude = -25.540486, Longitude = 28.096136 }, new Campuses() { City = "University Of Pretoria", Name = "Onderstepoort Campus", WebsiteLink = "www.tut.ac.za" , Latitude = -25.7545492, Longitude = 28.2314476 }, new Campuses() { City = "University Of Pretoria", Name = "Groenkloof Campus", WebsiteLink = "www.tut.ac.za", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "University Of Pretoria", Name = "Prinshof Campus", WebsiteLink = "www.tut.ac.za", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "University of South Africa", Name = "Middelburg Campus", WebsiteLink = "www.tut.ac.za", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "University of South Africa", Name = "Pretoria Campus", WebsiteLink = "www.tut.ac.za", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "University of South Africa", Name = " Muckleneuk Campus ", WebsiteLink = "www.tut.ac.za", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "University of Kwazulu Natal", Name = "Durban Campus", WebsiteLink = "www.uj.ac.za", Latitude = -26.1892543, Longitude = 28.0132699 }, //TNC new Campuses() { City = "University of Kwazulu Natal", Name = "Pietermaritzburg Campus", WebsiteLink = "www.uj.ac.za", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "University of Kwazulu Natal", Name = "Westville Campus", WebsiteLink = "www.uj.ac.za", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "University of Stellenbosch", Name = "Tygerberg Campus", WebsiteLink = "www.tnc.ac.za", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "University of Stellenbosch", Name = "Saldanha Bay campus", WebsiteLink = "www.rosebank.ac.za", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "University of Stellenbosch", Name = "Bellville campus", WebsiteLink = "www.ul.ac.za", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "University of Venda", Name = "Russell Road campus", WebsiteLink = "www.ul.ac.za", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "University of Venda", Name = "Thohoyandou Campus", WebsiteLink = "www.ul.ac.za", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "University of Venda", Name = "Thohoyandou Campus", WebsiteLink = "www.ul.ac.za", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "Tshwane North TVET College", Name = "Soshanguve South Campus", WebsiteLink = "www.tut.ac.za", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "Tshwane North TVET College", Name = "Soshanguve North Campus", WebsiteLink = "www.tut.ac.za", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "Tshwane North TVET College", Name = "Pretoria Campus", WebsiteLink = "www.tut.ac.za", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "Central JHB TVET College", Name = "Ellis Park Campus", WebsiteLink = "www.tut.ac.za", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "Central JHB TVET College", Name = "Alexandra Campus", WebsiteLink = "www.tut.ac.za", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "Central JHB TVET College", Name = "Parktown Campus", WebsiteLink = "www.tut.ac.za", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "Sedibeng TVET College", Name = "Heidelberg Satelite Campus", WebsiteLink = "www.uj.ac.za", Latitude = -26.1892543, Longitude = 28.0132699 }, //TNC new Campuses() { City = "Sedibeng TVET College", Name = "Vereeniging Campus", WebsiteLink = "www.uj.ac.za", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "Sedibeng TVET College", Name = "Sebokeng Campus", WebsiteLink = "www.uj.ac.za", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "CN Mahlangu", Name = "Nkangala Campus", WebsiteLink = "www.tnc.ac.za", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "CN Mahlangu", Name = "Siysbuswa campus", WebsiteLink = "www.rosebank.ac.za", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "CN Mahlangu", Name = "Middleburg campus", WebsiteLink = "www.ul.ac.za", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "False Bay TVET College", Name = "Muizenberg campus", WebsiteLink = "www.ul.ac.za", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "False Bay TVET College", Name = "Khayelitsha Campus", WebsiteLink = "www.ul.ac.za", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "False Bay TVET College", Name = "Mitchell’s Plain Campus", WebsiteLink = "www.ul.ac.za", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "South Cape TVET College", Name = "George Campus", WebsiteLink = "www.ul.ac.za", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "South Cape TVET College", Name = "Bitou Campus", WebsiteLink = "www.ul.ac.za", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "South Cape TVET College", Name = "Mossel Bay Campus", WebsiteLink = "www.ul.ac.za", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "Buffalo City TVET College", Name = "Southeast Technical College Campus", WebsiteLink = "www.ul.ac.za", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "Buffalo City TVET College", Name = "St Teresa Campus", WebsiteLink = "www.ul.ac.za", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "Buffalo City TVET College", Name = "Luther College Rochester Campus", WebsiteLink = "www.ul.ac.za", Latitude = -26.1892543, Longitude = 28.0132699 }, //////////////////////////new new Campuses() { City = "North West University", Name = "Mafikeng Campus", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "University of the Witwatersrand", Name = "West Campus", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "University of Cape Town", Name = "Breakwater Campus", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "Durban University of Technology", Name = "ML Sultan Campus", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "University of the Western Cape", Name = "Bellville Campus", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "Walter Sisulu University", Name = "Mthatha campus", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "Cape Peninsula University of Technology", Name = "Cape Town Campus", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "Vaal University of Technology", Name = "Vanderbijlpark Campus", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "Sol Plaatje University", Name = "Luther College Rochester Campus", Latitude = -26.1892543, Longitude = 28.0132699 }, //////////////////////////new new Campuses() { City = "North West University", Name = "Potchefstroom Campus", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "University of the Witwatersrand", Name = "East Campus", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "University of Cape Town", Name = "Hiddingh Campus", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "Durban University of Technology", Name = "Steve Biko Campus", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "University of the Western Cape", Name = "Tygerberg Hospital Campus", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "Walter Sisulu University", Name = "Butterworth campus", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "Cape Peninsula University of Technology", Name = "Granger Bay Campus", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "Vaal University of Technology", Name = "Secunda Campus", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "Sol Plaatje University", Name = "Mossel Bay Campus", Latitude = -26.1892543, Longitude = 28.0132699 }, //////////////////////////new new Campuses() { City = "North West University", Name = "Vaal Triangle Campus", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "University of the Witwatersrand", Name = "Parktown Campus", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "University of Cape Town", Name = "Medical Groote Schuur Campus", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "Durban University of Technology", Name = "Brickfield Campus", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "University of the Western Cape", Name = "Mitchell’s Plain Campus", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "Walter Sisulu University", Name = "Buffalo City campus", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "Cape Peninsula University of Technology", Name = "Mowbray Campus", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "Cape Peninsula University of Technology", Name = "Bellville Campus", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "Sol Plaatje University", Name = "Kimberley", Latitude = -26.1892543, Longitude = 28.0132699 }, ///////////////////new new Campuses() { City = "Ikhala FET College", Name = "Bellville Campus", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "King Hintsa FET College", Name = "Bellville Campus", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "Goldfields FET College", Name = "Bellville Campus", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "Elangeni FET College", Name = "Bellville Campus", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { Name = "Bellville Campus", City = "Majuba FET College", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "Letaba FET College", Name = "Bellville Campus", Latitude = -26.1892543, Longitude = 28.0132699 }, ///////////////////new new Campuses() { City = "Ikhala FET College", Name = "Bellville Campus", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "King Hintsa FET College", Name = "Bellville Campus", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "Goldfields FET College", Name = "Bellville Campus", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "Elangeni FET College", Name = "Bellville Campus", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "Majuba FET College", Name = "Bellville Campus", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "Letaba FET College", Name = "Bellville Campus", Latitude = -26.1892543, Longitude = 28.0132699 }, ///////////////////new new Campuses() { City = "Ikhala FET College", Name = "Bellville Campus", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "King Hintsa FET College", Name = "Bellville Campus", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "Goldfields FET College", Name = "Bellville Campus", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "Elangeni FET College", Name = "Bellville Campus" , Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "Majuba FET College", Name = "Bellville Campus", Latitude = -26.1892543, Longitude = 28.0132699 }, new Campuses() { City = "Letaba FET College", Name = "Bellville Campus", Latitude = -26.1892543, Longitude = 28.0132699 }, }; // Add rows to the User Table SQLiteAsyncConnection conn = new SQLiteAsyncConnection("institutionFinder.db"); await conn.InsertAllAsync(CampusesList); }
public static Task <int> InsertOrReplaceAllAsync(this SQLiteAsyncConnection connection, IEnumerable items) { return(connection.InsertAllAsync(items, "OR REPLACE")); }