private void AppBarToggleButton_Checked(object sender, RoutedEventArgs e)
{
AppBarToggleButton favButton = sender as AppBarToggleButton;
//if ((bool)favButton.IsChecked)
//{
// var path = ApplicationData.Current.LocalFolder.Path + "/myDb1.DB";
// var con = new SQLiteAsyncConnection(path);
// //await con.InsertAllAsync(results);
// await con.QueryAsync<Result>(string.Format("insert into Result (name,name) values('{0}','{1}')", results[0].name, tblock.Text));
//}
//else
//{
//}
if ((bool)favButton.IsChecked)
{
var path = ApplicationData.Current.LocalFolder.Path + "/myDb1.DB";
var con = new SQLiteAsyncConnection(path);
con.QueryAsync<Favourite>(string.Format("insert into Favourite (placeName,userName) values('{0}','{1}')", results[0].name, tblock.Text));
}
else if (!(bool)favButton.IsChecked)
{
var path = ApplicationData.Current.LocalFolder.Path + "/myDb1.DB";
var con = new SQLiteAsyncConnection(path);
con.QueryAsync<Favourite>(string.Format("delete from Favourite where placeName = '{0}' and username='******'", results[0].name, tblock.Text));
}
}
public async Task <List <Movie> > GetFavorites()
{
try
{
await CreateTable();
var db = new SQLite.SQLiteAsyncConnection(_dbPath);
// var db = new SQLiteAsyncConnection(_dbPath);
List <Movie> results = await db.QueryAsync <Movie>("Select * FROM Movie");
string logResult = "";
foreach (Movie result in results)
{
logResult += result.id + "-" + result.title + ",";
}
Log.Debug("GetFavorites", "Returned " + logResult);
return(results);
}
catch (SQLiteException ex)
{
Log.Debug("Get Favorites", "Exception " + ex.Message);
return(new List <Movie>());
}
}
protected override async void OnNavigatedTo(NavigationEventArgs e)
{
tblock.Text = !string.IsNullOrEmpty((App.Current as App).NavigateText) ? (App.Current as App).NavigateText : string.Empty;
var path = ApplicationData.Current.LocalFolder.Path + "/mydb.db";
var con = new SQLiteAsyncConnection(path);
//con.QueryAsync<person>("select name from person where name= ") + "";
//con.UpdateAsync("update person set password='******' where password='******' ");
//person p1 = new person();
//List<person> allpersons1 = new List<person>();
//allpersons1 = await con.QueryAsync<person>("select name from person where name=" + "\'" + tblock.Text + "\'");
//if (allpersons1.Count == 1)
//{
// p1 = allpersons1[0];
//}
//await con.QueryAsync<person>("alter TABLE person add column isConfirmed integer ");
if (isAdmin)
{
users.Visibility = Visibility.Visible;
List<person> notConfirmedUsers = await con.QueryAsync<person>("select name from person where isConfirmed = 0");
users.ItemsSource = notConfirmedUsers;
}
else
{
users.Visibility = Visibility.Collapsed;
}
}
async Task<ObservableCollection<MusicLibraryViewModel.ArtistItem>> Load()
{
var connection = new SQLiteAsyncConnection(_dbPath);
return new ObservableCollection<MusicLibraryViewModel.ArtistItem>(
await connection.QueryAsync<MusicLibraryViewModel.ArtistItem>(
"select * from ArtistItem"));
}
public async Task<ObservableCollection<MapModel>> Load()
{
SQLiteAsyncConnection connection = new SQLiteAsyncConnection(SQLiteConfiguration.ConnectionString);
_dataSources = new ObservableCollection<MapModel>(await connection.QueryAsync<MapModel>("SELECT * FROM Maps"));
return _dataSources;
}
private void button_Click(object sender, RoutedEventArgs e)
{
if (File.Exists("Data.sql"))
{
// File.Create("data1.db");
acre.Text = "Exist Exist";
}
else if (File.Exists("data1.db"))
{
if (File.Exists("data.db"))
{acre.Text = "Exist";}
}
SQLiteAsyncConnection conn = new SQLiteAsyncConnection(DB_PATH, true);
var query = conn.QueryAsync<chemicalnames2>("select * from chemicalnames2");
/* if (File.Exists("data1.db"))
{ acre.Text = "data1 Exist"; }
else
acre.Text = "data Exist";* /
string[] array = new string[100];
//string arr = dbconn.Query<Task>("select Title from Task ").FirstOrDefault().ToString();
array[0] = "string";
int i;
for (i = 1; i < 100; i++)
{
array[i] = dbconn.Query<chemicalnames2>("select chemicalname from chemicalnames2 where srno='" + i + "'").FirstOrDefault().ToString();
}
items = new ObservableCollection<string>();
foreach (string str in array)
items.Add(str);
areapicker.ItemsSource = items;
if (File.Exists("data.db"))
{
// Create the database connection
using(var db = new SQLiteConnection("data.db"))
{
// If the table does not exist, create it
db.CreateTable<chemicalnames2>();
acre.Text = "true";
// Retrieve a list of data from the database
// List data = db.Table<chemicalnames2>().ToList<chemicalnames2>().ToString();
}
}*/
// var tp = dbconn.Query<chemicalnames2>("select chemicalname from chemicalnames2 where srno='" + area.Text + "'").FirstOrDefault().ToString();
//acre.Text = tp.ToString();
}
async Task<ObservableCollection<MusicLibraryViewModel.AlbumItem>> LoadAlbumsFromId(int artistId)
{
var connection = new SQLiteAsyncConnection(_dbPath);
return new ObservableCollection<MusicLibraryViewModel.AlbumItem>(
await connection.QueryAsync<MusicLibraryViewModel.AlbumItem>(
string.Format("select * from AlbumItem where ArtistId = {0}", artistId)));
}
private async void checkUser()
{
if (!string.IsNullOrWhiteSpace(LoginModel.BadgeId) && !string.IsNullOrWhiteSpace(LoginModel.Password))
{
SQLiteAsyncConnection connection = new SQLiteAsyncConnection("Test.db");
var result = await connection.QueryAsync<Employee>("SELECT * from Employee where BadgeId=\"" + LoginModel.BadgeId + "\"");
//var result = await connection.ExecuteAsync("SELECT count("+""+"\"BadgeId\""+")"+ " from Employee");
System.Diagnostics.Debug.WriteLine("validating user");
#region
if (result.Count != 0 && result[0].Password == LoginModel.Password && result[0].BadgeId == LoginModel.BadgeId)
{
System.Diagnostics.Debug.WriteLine("user validated");
Container.BadgeId = result[0].BadgeId;
Container.Designation = result[0].Designation;
Container.Manager = result[0].Manager;
Container.Skill = result[0].Skill;
Container.EName = result[0].EName;
Container.Level = result[0].Level;
if (result[0].Level != "1")
{
Container.Enable = Visibility.Visible;
}
else
{
Container.Enable = Visibility.Collapsed;
}
((Frame)Window.Current.Content).Navigate(typeof(Profile));
}
#endregion
else
{
//set the message for user
//LoginModel.UserFeedBack = "Username or Password is Invalid!";
//UserFeedBack = Visibility.Visible;
//LoginModel.BadgeId = null;
//LoginModel.Password = null;
var errmsg = new MessageDialog("Invalid username or password");
await errmsg.ShowAsync();
((Frame)Window.Current.Content).Navigate(typeof(MainPage));
}
}
else
{
var errmsg = new MessageDialog("Please enter the Details");
await errmsg.ShowAsync();
}
}
protected async override void OnNavigatedTo(NavigationEventArgs e)
{
bool dbExist = await CheckDbAsync("moneybook.db");
if (!dbExist)
{
await CreateDatabaseAsync();
//await CreateTaiKhoanItems();
}
// Get Items
SQLiteAsyncConnection conn = new SQLiteAsyncConnection("moneybook.db");
var query = conn.Table<taikhoan>();
taikhoans = await query.ToListAsync();
var queryk = await conn.QueryAsync<ghichep>("SELECT * from ghichep order by ngay");
List<ghichep> n = new List<ghichep>();
foreach (ghichep g in queryk.ToList())
{
n.Add(g);
}
//var qGhiChep = conn.Table<ghichep>();
//ghicheps = await qGhiChep.ToListAsync();
// Show Tiems
taikhoanList.ItemsSource = taikhoans;
var result = from item in n
group item by DateTime.Parse(item.Ngay).ToString("dd-MM-yyyy")
into grp
orderby grp.Key
select grp;
cvsGhiChepList.Source = result;
ghichepListpv.DataContext = n;
double sotienbandau = 0;
var Sotienquery = await conn.QueryAsync<taikhoan>("SELECT sotienbandau from taikhoan");
foreach (var g in Sotienquery.ToList())
{
sotienbandau += double.Parse(g.Sotienbandau);
}
tongsodutaikhoan.Text = "Tổng: " + sotienbandau.ToString("#,##0") +" đ";
}
protected override async void OnNavigatedTo(NavigationEventArgs e)
{
this.navigationHelper.OnNavigatedTo(e);
SQLiteAsyncConnection conn = new SQLiteAsyncConnection("moneybook.db");
var query = await conn.QueryAsync<taikhoan>("SELECT tentaikhoan from taikhoan");
List<string> n = new List<string>();
foreach (var g in query.ToList())
{
n.Add(g.Tentaikhoan);
}
tutaikhoan.ItemsSource = n;
}
protected async override void OnNavigatedTo(NavigationEventArgs e)
{
part = e.Parameter as string;
label.Text = part;
// Get users
SQLiteAsyncConnection connection = new SQLiteAsyncConnection("institutionFinder.db");
users = await connection.QueryAsync<Courses>("Select * FROM Courses");
// Show users
viewcourses.ItemsSource = users;
}
private async void Button_Click_3(object sender, RoutedEventArgs e)
{
string result = "";
var path = ApplicationData.Current.LocalFolder.Path + @"\Users.db";
var db = new SQLiteAsyncConnection(path);
List<User> all = await db.QueryAsync<User>("Select* from Users");
var count = all.Any() ? all.Count : 0;
foreach (var item in all)
{
result += "email" + item.email.ToString() + "\nFstname" + item.name+"\n";
}
MessageDialog msg = new MessageDialog(result.ToString());
await msg.ShowAsync();
}
protected override async void OnNavigatedTo(NavigationEventArgs e)
{
SQLiteAsyncConnection conn = new SQLiteAsyncConnection("moneybook.db");
var taikhoanID = (int)e.Parameter;
var query = await conn.QueryAsync<taikhoan>("SELECT * from taikhoan WHERE Id = " + taikhoanID);
foreach (var g in query.ToList())
{
id = g.Id;
tentaikhoan.Text = g.Tentaikhoan;
loaitaikhoan.SelectedItem = loaitaikhoan.Items.Cast<ComboBoxItem>().Where(cmbi => (string)cmbi.Tag == g.Loaitaikhoan).First();
loaitiente.SelectedItem = loaitiente.Items.Cast<ComboBoxItem>().Where(cmbi => (string)cmbi.Tag == g.Loaitiente).First();
sotienbandau.Text = g.Sotienbandau;
ghichu.Text = g.Ghichu;
}
}
protected async override void OnNavigatedTo(NavigationEventArgs e)
{
part = e.Parameter as string;
navigated.Text = part;
// Get users
SQLiteAsyncConnection connection = new SQLiteAsyncConnection("institutionFinder.db");
users = await connection.QueryAsync<Campuses>("Select * FROM Campuses WHERE City ='" + part + "'");
// Show users
UserList.ItemsSource = users;
}
public static async Task<OCSettings> getSettings()
{
String path = ApplicationData.Current.LocalFolder.Path + "/OCTranspo.sqlite";
SQLiteAsyncConnection conn = new SQLiteAsyncConnection(path);
var count = await conn.ExecuteScalarAsync<int>("SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name='OCSettings'");
if (count > 0)
{
String Query = "SELECT * from OCSettings LIMIT 1;";
List<OCSettings> settings = await conn.QueryAsync<OCSettings>(Query);
return settings.First<OCSettings>();
}
else
{
createSettingsTable();
return await getSettings();
}
}
public async void losuj()
{
if (baza == "eFiszki")
{
baza = "AppData";
}
var path = Windows.Storage.ApplicationData.Current.LocalFolder.Path + @"\" + baza + ".sqlite";
var db = new SQLiteAsyncConnection(path);
PobierzDaneBazy = await db.QueryAsync<UserDefaultDataBase>("Select * From UserDefaultDataBase");
if (PobierzDaneBazy.Count == 0)
{
MessageDialog dialog = new MessageDialog("Error");
await dialog.ShowAsync();
this.Frame.Navigate(typeof(gamesszubienica1));
}
else
{
Random rnd = new Random();
indeks = rnd.Next(PobierzDaneBazy.Count);
slowkoen = PobierzDaneBazy[indeks].SlowkoEn;
tablica_zamknieta = slowkoen.ToCharArray();
foreach (char element in tablica_zamknieta)
{
if (element.ToString() == " ")
{
slowko_zamkniete = slowko_zamkniete + " " + " ";
}
else
{
slowko_zamkniete = slowko_zamkniete + "_" + " ";
}
}
foreach (char element in tablica_zamknieta)
{
slowko_otwarte = slowko_otwarte + element + " ";
}
wylosowaneslowko.Text = slowko_zamkniete;
}
}
private async void loginbtn_Click(object sender, RoutedEventArgs e)
{
(App.Current as App).NavigateText = unametxt.Text;
var path = ApplicationData.Current.LocalFolder.Path + "/myDb1.DB";
var con = new SQLiteAsyncConnection(path);
person p1 = new person();
List<person> allpersons = new List<person>();
allpersons = await con.QueryAsync<person>("select name,password from person where name=" + "\'" + unametxt.Text + "\'" + "and password="******"\'" + pwdtxt.Password + "\'");
if (allpersons.Count == 1)
{
p1 = allpersons[0];
Frame.Navigate(typeof(MainPage));
}
}
protected async override void OnNavigatedTo(NavigationEventArgs e)
{
// Show users
aps = e.Parameter as string;
SQLiteAsyncConnection connection = new SQLiteAsyncConnection("institutionFinder.db");
var users = await connection.QueryAsync<Courses>("Select courses FROM Courses where Id = " + 21 + "");
// Get users
course = users.SingleOrDefault();
qCourses.Text = "You Qualify for " + course.courses;
}
async protected override void OnNavigatedTo(NavigationEventArgs e)
{
activeCharacter = e.Parameter as Character;
// load all transaction items
var sqlite = new SQLiteAsyncConnection(activeCharacter.CharID + ".sqlite");
List<Transaction> items = await sqlite.QueryAsync<Transaction>("SELECT * FROM 'Transaction' GROUP BY TypeID ORDER BY TypeName");
this.Itemlist.ItemsSource = items;
this.Categories.AddItems(items);
this.Categories.ItemSelect += this.LoadData;
SolidColorBrush line_sales = new SolidColorBrush(Color.FromArgb(255, 116, 195, 101));
Style point_sales = new Style();
point_sales.TargetType = typeof(DataPoint);
point_sales.Setters.Add(new Setter(BackgroundProperty, line_sales));
(LineChart.Series[0] as LineSeries).Background = line_sales;
(LineChart.Series[0] as LineSeries).DataPointStyle = point_sales;
SolidColorBrush line_salesAvg = new SolidColorBrush(Color.FromArgb(255, 34, 139, 34));
Style point_salesAvg = new Style();
point_salesAvg.TargetType = typeof(DataPoint);
point_salesAvg.Setters.Add(new Setter(BackgroundProperty, line_salesAvg));
point_salesAvg.Setters.Add(new Setter(WidthProperty, 0));
point_salesAvg.Setters.Add(new Setter(HeightProperty, 0));
(LineChart.Series[1] as LineSeries).Background = line_salesAvg;
(LineChart.Series[1] as LineSeries).DataPointStyle = point_salesAvg;
SolidColorBrush line_buys = new SolidColorBrush(Color.FromArgb(255, 196, 2, 51));
Style point_buys = new Style();
point_buys.TargetType = typeof(DataPoint);
point_buys.Setters.Add(new Setter(BackgroundProperty, line_buys));
(LineChart.Series[2] as LineSeries).Background = line_buys;
(LineChart.Series[2] as LineSeries).DataPointStyle = point_buys;
SolidColorBrush line_buysAvg = new SolidColorBrush(Color.FromArgb(255, 237, 28, 36));
Style point_buysAvg = new Style();
point_buysAvg.TargetType = typeof(DataPoint);
point_buysAvg.Setters.Add(new Setter(BackgroundProperty, line_buysAvg));
point_buysAvg.Setters.Add(new Setter(WidthProperty, 0));
point_buysAvg.Setters.Add(new Setter(HeightProperty, 0));
(LineChart.Series[3] as LineSeries).Background = line_buysAvg;
(LineChart.Series[3] as LineSeries).DataPointStyle = point_buysAvg;
}
public async Task <bool> IsFavorite(string movieid)
{
try
{
await CreateTable();
var db = new SQLite.SQLiteAsyncConnection(_dbPath);
List <Movie> results = await db.QueryAsync <Movie>("Select _id FROM Movie WHERE _id = " + movieid);
Log.Debug("IsFavorite", "movieid '" + movieid + "' returned " + results.Count + "results");
return(results.Count > 0);
}
catch (SQLiteException ex)
{
Log.Debug("IsFavorite", "Exception " + ex.Message);
return(false);
}
}
protected override async void OnNavigatedTo(NavigationEventArgs e)
{
this.navigationHelper.OnNavigatedTo(e);
SQLiteAsyncConnection conn = new SQLiteAsyncConnection("moneybook.db");
var taikhoanItem = (taikhoan)e.Parameter;
id = taikhoanItem.Id;
var qGhiChep = conn.Table<ghichep>().Where(t => t.Tutaikhoan.Contains(taikhoanItem.Tentaikhoan));
ghicheps = await qGhiChep.ToListAsync();
ghichepListItems.ItemsSource = ghicheps;
double sotienbandau = 0;
var Sotienquery = await conn.QueryAsync<taikhoan>("SELECT sotienbandau from taikhoan where Id = " + id);
foreach (var g in Sotienquery.ToList())
{
sotienbandau = double.Parse(g.Sotienbandau);
}
tonggiatritaikhoan.Text = "Số dư: " + sotienbandau.ToString("#,##0")+ " đ";
}
protected override async void OnNavigatedTo(NavigationEventArgs e)
{
SQLiteAsyncConnection conn = new SQLiteAsyncConnection("moneybook.db");
var query = await conn.QueryAsync<taikhoan>("SELECT tentaikhoan from taikhoan");
List<string> n = new List<string>();
foreach (var g in query.ToList())
{
n.Add(g.Tentaikhoan);
}
tutaikhoan.ItemsSource = n;
var ghichepItem = (ghichep)e.Parameter;
id = ghichepItem.Id;
loai.SelectedItem = loai.Items.Cast<ComboBoxItem>().Where(cmbi => (string)cmbi.Tag == ghichepItem.Loai).First();
sotien.Text = ghichepItem.Sotien;
mucdichchi.Text = ghichepItem.Mucdichchi;
ngay.Date = DateTime.Parse(ghichepItem.Ngay);
gio.Time = TimeSpan.Parse(ghichepItem.Gio);
ghichu.Text = ghichepItem.Ghichu;
tutaikhoan.SelectedValue = ghichepItem.Tutaikhoan;
}
protected async override void OnNavigatedTo(NavigationEventArgs e)
{
RootObject r1 = new RootObject();
gv2.ItemsSource = results;
tblock.Text = (App.Current as App).NavigateText;
var path = ApplicationData.Current.LocalFolder.Path + "/myDb1.DB";
var con = new SQLiteAsyncConnection(path);
List<Favourite> favs = await con.QueryAsync<Favourite>(string.Format("select id from Favourite where userName = '******' and placeName = '{1}'", tblock.Text, results[0].name)) as List<Favourite>;
if (favs.Count > 0 && favs.First().id > 0)
{
aptb.IsChecked = true;
}
//con.CreateTableAsync<Favourite>();
}
private async void zacznij()
{
// StandardLearningStart.IsEnabled = false;
gamesnextbutton.IsEnabled = true;
gamespreviousbutton.IsEnabled = true;
var path = Windows.Storage.ApplicationData.Current.LocalFolder.Path + @"\" + baza + ".sqlite";
var db = new SQLiteAsyncConnection(path);
PobierzDaneBazy = await db.QueryAsync<UserDefaultDataBase>("Select * From UserDefaultDataBase");
if (PobierzDaneBazy.Count == 0)
{
MessageDialog dialog = new MessageDialog("Error");
await dialog.ShowAsync();
this.Frame.Navigate(typeof(GamesStandardLeaning1));
}
else
{
gamespreviousbutton.IsEnabled = false;
StandatdLearningslowkoPL.Text = PobierzDaneBazy[licznik].SlowkoPl;
StandatdLearningslowkoEN.Text = PobierzDaneBazy[licznik].SlowkoEn;
}
}
private async void loginbtn_Click(object sender, RoutedEventArgs e)
{
if (unametxt.Text == "trilok" && pwdtxt.Password == "trilok")
{
(App.Current as App).NavigateText = unametxt.Text;
Dashboard.isAdmin = true;
this.Frame.Navigate(typeof(Dashboard));
Dashboard.userName = "******";
}
else
{
var path = ApplicationData.Current.LocalFolder.Path + "/mydb.db";
var con = new SQLiteAsyncConnection(path);
person p1 = new person();
Dashboard.isAdmin = false;
List<person> allpersons = new List<person>();
allpersons = await con.QueryAsync<person>("select name,password from person where name=" + "\'" + unametxt.Text + "\'" + "and password="******"\'" + pwdtxt.Password + "\'");
if (allpersons.Count == 1)
{
(App.Current as App).NavigateText = unametxt.Text;
p1 = allpersons[0];
//username = unametxt.Text;
Frame.Navigate(typeof(Dashboard));
Dashboard.userName = p1.name;
}
else
{
var m = new MessageDialog("invalid login").ShowAsync();
}
}
}
private async void Button_Click_1(object sender, RoutedEventArgs e)
{
string baza = comboboxusunzbazy.SelectedValue.ToString();
string slowko = comboboxslowkodousuniecia.SelectedValue.ToString();
string[] tablica = slowko.Split(new[] {'.'});
if (baza.Equals("eFiszki"))
{
baza = "AppData";
}
var path = Windows.Storage.ApplicationData.Current.LocalFolder.Path + @"\" + baza + ".sqlite";
var db = new SQLiteAsyncConnection(path);
var maxid = 0;
List<UserDefaultDataBase> result = await db.QueryAsync<UserDefaultDataBase>("Select max(id) as Id From UserDefaultDataBase");
foreach (var item in result)
{
maxid = item.Id;
}
int indeksdousuniecia = Convert.ToInt32(tablica[0]);
var all = await db.QueryAsync<UserDefaultDataBase>("Select * From UserDefaultDataBase");
var del = await db.FindAsync<UserDefaultDataBase>(u => u.Id == indeksdousuniecia);
await db.DeleteAsync(del);
//Debug.WriteLine("maksymalny indeks: " + maxid + ", indeks do usuniecia:" + indeksdousuniecia);
//if (maxid != indeksdousuniecia)
//{
// List<UserDefaultDataBase> updateid = await db.QueryAsync<UserDefaultDataBase>("Select * From UserDefaultDataBase Where Id = ?", new object[] { maxid });
// var update = updateid.First();
// update.Id += 100;
// update.SlowkoEn = "toz to dziala";
// await db.UpdateAsync(update);
// Debug.WriteLine("Update indeksu:" + maxid + " na " + indeksdousuniecia);
// //foreach (var i in updateid)
// //{
// // Debug.WriteLine(i.Id);
// //}
// //await db.QueryAsync<UserDefaultDataBase>("Update UserDefaultDataBase set id= ? where id=?", new object[] {maxid, indeksdousuniecia });
// //foreach (var i in updateid)
// //{
// // var update = updateid.First();
// // update.Id = indeksdousuniecia;
// // await db.UpdateAsync(update);
// //}
//}
comboboxslowkodousuniecia.Items.Clear();
setcomboslowko();
}
public async void setcomboslowko()
{
comboboxslowkodousuniecia.IsEnabled = true;
buttonusunslowko.IsEnabled = false;
comboboxslowkodousuniecia.Items.Clear();
String Result = "";
string wybranabaza = comboboxusunzbazy.SelectedValue.ToString();
if (wybranabaza.Equals("eFiszki"))
{
wybranabaza = "AppData";
}
var path = Windows.Storage.ApplicationData.Current.LocalFolder.Path + @"\" + wybranabaza + ".sqlite";
var db = new SQLiteAsyncConnection(path);
List<UserDefaultDataBase> allUsers = await db.QueryAsync<UserDefaultDataBase>("Select * From UserDefaultDataBase");
var count = allUsers.Any() ? allUsers.Count : 0;
foreach (var item in allUsers)
{
Result = item.Id + ". " + item.SlowkoPl + " - " + item.SlowkoEn;
comboboxslowkodousuniecia.Items.Add(Result);
}
}
private async void generateHierarchy()
{
list.Clear();
PeerList.Clear();
SQLiteAsyncConnection connection = new SQLiteAsyncConnection("Test.db");
var result = await connection.QueryAsync<Employee>("WITH CTE AS( SELECT EName,Skill,Designation,ManagerId AS ManagerId FROM Employee WHERE BadgeId =\"" + BadgeId+ "\" UNION ALL SELECT E.EName,E.Skill,E.Designation, E.ManagerId FROM Employee E INNER JOIN CTE ON E.BadgeId = CTE.ManagerId) SELECT * FROM CTE");
var result2 = await connection.QueryAsync<Employee>("SELECT EName,Designation,Skill FROM Employee WHERE Manager =\"" + Manager + "\"");
foreach (var person in result)
{
if (person.EName!=EName)
{
list.Add(person);
//Some.Add(person);
}
}
list= new ObservableCollection<Employee>(list.Reverse());
ListViewItem l = new ListViewItem();
foreach (var peer in result2)
{
if (peer.EName!=EName)
{
PeerList.Add(peer);
}
}
}
public static async Task<ObservableCollection<OCDirection>> getFavourites()
{
//TODO Math.
String path = ApplicationData.Current.LocalFolder.Path + "/OCTranspo.sqlite";
SQLiteAsyncConnection conn = new SQLiteAsyncConnection(path);
var count = await conn.ExecuteScalarAsync<int>("SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name='OCDirection'");
if (count > 0)
{
String Query = "SELECT Id, * from OCDirection;";
List<OCDirection> stops = await conn.QueryAsync<OCDirection>(Query);
ObservableCollection<OCDirection> directionsCollection = new ObservableCollection<OCDirection>(stops);
return directionsCollection;
}
else
{
createFavouritesTable();
return await getFavourites();
}
}
public Task <List <Product> > GetProductsByCategoryIdAsync(int ID)
{
return(_database.QueryAsync <Product>(
$"SELECT * FROM[Product] WHERE [CategoryID] = { ID}"));
}
public static async Task<List<OCSchedule>> getScheduleForDayAndStop(String day, String stop, int route)
{
String path = ApplicationData.Current.LocalFolder.Path + "/OCTranspo.sqlite";
SQLiteAsyncConnection conn = new SQLiteAsyncConnection(path);
var count = await conn.ExecuteScalarAsync<int>("SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name='OCStop'");
if (count > 0)
{
int date = getTodaysDate();
String Query = "SELECT * from OCSchedule where start_date <= " + date + " AND end_date >= " + date + " AND stop_code = '" + stop + "' AND route_short_name='" + route + "' AND " + day.ToLower() + " = '1' ORDER BY arrival_time";
List<OCSchedule> schedule = await conn.QueryAsync<OCSchedule>(Query);
return schedule;
}
else
{
OCTranspoStopsData.initDB();
return await getScheduleForDayAndStop(day, stop, route);
}
}
private async void enterbtn_Click(object sender, RoutedEventArgs e)
{
var path = ApplicationData.Current.LocalFolder.Path + "/mydb.db";
var con = new SQLiteAsyncConnection(path);
person loginPerson = (await con.QueryAsync<person>("select isConfirmed from person where name='" + Dashboard.userName + "'"))[0];
if (loginPerson.isConfirmed == 1)
{
List<person> all = new List<person>();
all = await con.QueryAsync<person>("select name,email,country,gender,phone from person where name='" + searchboxtxt.Text + "' AND isConfirmed= 1 ");
// var mm1 = new MessageDialog("no matches found").ShowAsync();
String res = "";
foreach (person a in all)
{
res += "\n\n" + a.name + "\n\n" + a.email + "\n\n" + a.country + "\n\n" + a.gender + "\n\n" + a.phone;
}
restxtblock.Text = res;
}
else
{
var md1 = new MessageDialog("No permission to search for users").ShowAsync();
}
}
public async Task<ObservableCollection<MapLocationModel>> LoadLocations(Guid mapId)
{
SQLiteAsyncConnection connection = new SQLiteAsyncConnection(SQLiteConfiguration.ConnectionString);
_locations = new ObservableCollection<MapLocationModel>(await connection.QueryAsync<MapLocationModel>("SELECT * FROM MapLocations WHERE MapId = ?", mapId));
return _locations;
}
