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"));
}
