/// <summary> /// Invoked when this page is about to be displayed in a Frame. /// </summary> /// <param name="e">Event data that describes how this page was reached. /// This parameter is typically used to configure the page.</param> protected override void OnNavigatedTo(NavigationEventArgs e) { Translate(); DatabaseHelperClass dbhandle = new DatabaseHelperClass(); ObservableCollection <Classes.Idioma> myLang = dbhandle.ReadIdiomas(); ObservableCollection <Classes.Pais> myCount = dbhandle.ReadPaises(); ComboBoxLang.ItemsSource = myLang.OrderBy(i => i.Nome).ToList(); ComboBoxCountry.ItemsSource = myCount.OrderBy(i => i.Nome).ToList(); CultureInfo ci = new CultureInfo(Windows.System.UserProfile.GlobalizationPreferences.Languages[0]); string SOlang = ci.TwoLetterISOLanguageName; Boolean langfound = false; foreach (var lang in myLang) { if (SOlang == lang.Codigo_Idioma) { langfound = true; } } if (!langfound) { NoLangPanel.Visibility = Visibility.Visible; btnPanel.Margin = new Thickness(0, 0, 0, 0); } }
private void listBoxobj_SelectionChanged(object sender, SelectionChangedEventArgs e) { Classes.Conteudo_Topico m = new Classes.Conteudo_Topico(); m = listBoxobj.SelectedItem as Classes.Conteudo_Topico; // If selected index is -1 (no selection) do nothing if (listBoxobj.SelectedIndex == -1) { return; } // Check if Subtopic Exists string s = Convert.ToString(m.parent_topico.Titulo); DatabaseHelperClass dbtopicos = new DatabaseHelperClass(); Boolean exists = dbtopicos.SubtopicExist(s); if (exists) { // Navigate to the new page Frame.Navigate(typeof(Pages.Subtopicos), m.parent_topico.Titulo); } else { // Navigate to the new page Frame.Navigate(typeof(Pages.Conteudo), m.parent_topico); } // Reset selected index to -1 (no selection) listBoxobj.SelectedIndex = -1; }
/// <summary> /// Invoked when this page is about to be displayed in a Frame. /// </summary> /// <param name="e">Event data that describes how this page was reached. /// This parameter is typically used to configure the page.</param> protected override void OnNavigatedTo(NavigationEventArgs e) { MainPage.instance.change_title("Esquadra mais próxima"); DatabaseHelperClass dbtemas = new DatabaseHelperClass(); ObservableCollection <Classes.Entidade> EntList = dbtemas.ReadEntidade(); this.EntList = EntList; CalcDist(); closest_police(); NomeEnt.Text = closest.Nome; MoradaEnt.Text = closest.Morada; CodPostalEnt.Text = closest.Codigo_Postal; TeleEnt.Text = closest.Telefone.ToString(); EmailEnt.Text = closest.Email; if (closest.Fax.ToString() == "0") { FaxEnt.Text = "Não Disponível"; FaxEnt.Foreground = new SolidColorBrush(Colors.Gray); } else { FaxEnt.Text = closest.Fax.ToString(); } ImageEnt.Source = new BitmapImage(new Uri(ConfigData.Iconpath + closest.Anexo, UriKind.Absolute)); MapFrame.Navigate(typeof(Pages.Contactos), closest); Translate(); }
private async void CalcDist() { var geolocator = new Geolocator(); Geoposition position; Position CurrentP = new Position(); try { // Carry out the operation Geoposition pos = position = MainPage.instance.getPos(); CurrentP.Latitude = position.Coordinate.Latitude; CurrentP.Longitude = position.Coordinate.Longitude; } catch { //Operation aborted Your App does not have permission to access location data. //Launcher.LaunchUriAsync(new Uri("ms-settings-location:")); } DatabaseHelperClass dbtemas = new DatabaseHelperClass(); foreach (var E in EntList) { double lat = dbtemas.latitude(E.N_Vertice); double lon = dbtemas.longitude(E.N_Vertice); Position TargetP = new Position(); TargetP.Latitude = lat; TargetP.Longitude = lon; E.dist = Distance(CurrentP, TargetP, DistanceType.Kilometers); } }
public AddingViewModel(IDialogService dialogService, INavigationService navigationService) { IsActivitySplitViewPaneOpen = false; _dialogService = dialogService; _navigationService = navigationService; ContactListCollection = new ObservableCollection <ContactList>(); int counts = ContactListCollection.Count; //VideosObservableCollections = GetVideos(); WorkOrder = new ObservableCollection <SimpleDemoData>() { new SimpleDemoData { GTitle = "Equipments", Id = 1, count = 3, Image = "/Images/Big/Artboard [email protected]" }, new SimpleDemoData { GTitle = "Inspections", Id = 2, count = 53, Image = "/Images/Big/Artboard 1 copy [email protected]" }, new SimpleDemoData { GTitle = "Notifications", Id = 3, count = counts, Image = "/Images/Big/Artboard 1 [email protected]" }, new SimpleDemoData { GTitle = "WorkOrders", Id = 4, count = 90, Image = "/Images/Big/Artboard 1 copy [email protected]" } }; NotificationsStatus = new ObservableCollection <string>() { "Completed", "Progress", "Submitted" }; // TreeItems = BuildTree(5, 5); Db_Helper = new DatabaseHelperClass();//Creating object for DatabaseHelperClass.cs from ViewModel/DatabaseHelperClass.cs }
//Для отображения списка устройств и выбора активного в комбобоксе private void ReadDeviceList_Loaded(object sender, RoutedEventArgs e) { ObservableCollection <Device> ComboList = new ObservableCollection <Device>(); ReadAllDeviceList dbdevices = new ReadAllDeviceList(); DatabaseHelperClass Db_Helper = new DatabaseHelperClass(); ComboList = dbdevices.GetAllDevices(); try { ComboBox.ItemsSource = ComboList.OrderBy(i => i.Id).ToList(); if (Sync_Page.Main_Current_Device.Model != null) { CurrentDevice = Sync_Page.Main_Current_Device; foreach (var device in ComboList) { if (device.Name == CurrentDevice.Name) { var index = ComboList.IndexOf(device); ComboBox.SelectedIndex = index; } } ReadSongList_Loaded(); } else { Percent.Text = "На устройстве будет свободно __ Gb"; } } catch { //Пустое значение } }
/// <summary> /// Invoked when this page is about to be displayed in a Frame. /// </summary> /// <param name="e">Event data that describes how this page was reached. /// This parameter is typically used to configure the page.</param> protected override void OnNavigatedTo(NavigationEventArgs e) { MainPage.instance.change_title("Definições"); Translate(); DatabaseHelperClass dbidiomas = new DatabaseHelperClass(); ObservableCollection <Classes.Idioma> myLang = dbidiomas.ReadIdiomas();//Get all DB contacts string pht = "Selected Language"; foreach (var lang in myLang) { if (localSettings.Values["Idioma"].ToString() == lang.Codigo_Idioma) { pht = lang.Nome; } } ComboBoxIdioma.PlaceholderText = pht; ComboBoxIdioma.ItemsSource = myLang.ToList(); Geolocator locator = new Geolocator(); if (locator.LocationStatus == PositionStatus.Disabled) { geoText.Visibility = Visibility.Visible; } }
private async void AddContact_Click(object sender, RoutedEventArgs e) { DatabaseHelperClass Db_Helper = new DatabaseHelperClass(); if (NametxtBx.Text != "" && PhonetxtBx.Text != "") { string gendertext; if (GenderMaleRd.IsChecked == true) { gendertext = "Nam"; } else if (GenderFemaleRd.IsChecked == true) { gendertext = "Nữ"; } else { gendertext = "Nam"; } Db_Helper.Insert(new Contacts(NametxtBx.Text.Trim(), PhonetxtBx.Text.Trim(), EmailtxtBx.Text.Trim(), AddresstxtBx.Text.Trim(), gendertext));// //NavigationService.Navigate(new Uri("/Views/ReadContactList.xaml", UriKind.Relative)); NavigationService.GoBack(); } else { MessageBox.Show("Bạn chưa nhập họ tên hoặc số điện thoại!"); } }
private void Button_Click(object sender, RoutedEventArgs e) { ExpenseReport deletingExpense = (sender as Button).Tag as ExpenseReport; DatabaseHelperClass.DeleteExpenseReport(deletingExpense); this.Context.LoadReport.Execute(); }
private void NavigationHelper_LoadState(object sender, LoadStateEventArgs e) { DatabaseHelperClass dbHelper = new DatabaseHelperClass(); ObservableCollection <ImageModel> favImages = dbHelper.GetImages(); ImageGrid.DataContext = favImages; }
private async void AddEmployee_Click(object sender, RoutedEventArgs e) { Saving.IsActive = true; DatabaseHelperClass Db_Helper = new DatabaseHelperClass();//Creating object for DatabaseHelperClass.cs from ViewModel/DatabaseHelperClass.cs if (NametxtBx.Text != "" & PhonetxtBx.Text != "" & PositiontxtBx.Text != "" & AddresstxtBx.Text != "" & AgetxtBx.Text != "" & RatetxtBx.Text != "") { Db_Helper.Insert(new Employees(NametxtBx.Text, PhonetxtBx.Text, PositiontxtBx.Text, AddresstxtBx.Text, AgetxtBx.Text, RatetxtBx.Text)); ReadAllEmployeesList dbAtte = new ReadAllEmployeesList(); DB_Employees = dbAtte.GetAllEmployees(); newAtte.GenerateAttendance(NametxtBx.Text); Employees.EmployeeAdded = true; //reference that the navigation came from adding employee if (fromMainPage != "firstEmployee") { Frame.BackStack.RemoveAt(Frame.BackStackDepth - 1); //removing the back button's previous history } Frame.Navigate(typeof(EmployeeBuddy)); //after adding Employee redirect to EmployeeBuddy page } else { MessageDialog messageDialog = new MessageDialog("Please fill all the fields");//Text should not be empty await messageDialog.ShowAsync(); Saving.IsActive = false; } }
private void DeleteAll_Click(object sender, RoutedEventArgs e) { DatabaseHelperClass Db_Helper = new DatabaseHelperClass(); Db_Helper.DeleteAllContact(); //delete all DB contacts DB_ContactList.Clear(); //Clear collections listBoxobj.ItemsSource = DB_ContactList; }
private void Page_Loaded(object sender, RoutedEventArgs e) { ObservableCollection <makinat> DB_ContactList = new ObservableCollection <makinat>(); DatabaseHelperClass dbcontacts = new DatabaseHelperClass(); DB_ContactList = dbcontacts.ReadContacts(); listBoxobj.ItemsSource = DB_ContactList.OrderByDescending(i => i.Id).ToList(); }
public DetailSViewModel(INavigationService navigationService, IDialogService dialogService) { _navigationService = navigationService; _dialogService = dialogService; MessengerInstance.Register <ContactList>(this, p => GetContacts(p)); Db_Helper = new DatabaseHelperClass(); }
private async void ListViewItem_Loaded(object sender, RoutedEventArgs e) { DatabaseHelperClass db = new DatabaseHelperClass(); if (RefInBack) { //Start Of EventsAPI call db.DeleteAllEvents(); List <EventClass> listevents = new List <EventClass>(); listevents = await GetEventsAPIAsync(); db.Insert(listevents); //End of Events API Call List <EventClass> l = new List <EventClass>(); l = db.ReadEvents(); List <EventClass> Day1_Events = new List <EventClass>(); List <EventClass> Day2_Events = new List <EventClass>(); List <EventClass> Day3_Events = new List <EventClass>(); List <EventClass> Day4_Events = new List <EventClass>(); Day1_Events = (l.Where(p => p.Day == "1").ToList()).OrderBy(eve => eve.Name).ToList(); Day2_Events = (l.Where(p => p.Day == "2").ToList()).OrderBy(eve => eve.Name).ToList(); Day3_Events = (l.Where(p => p.Day == "3").ToList()).OrderBy(eve => eve.Name).ToList(); Day4_Events = (l.Where(p => p.Day == "4").ToList()).OrderBy(eve => eve.Name).ToList(); List <Day> list = new List <Day>(); Day day1 = new Day(); day1.Events = Day1_Events; day1.day = "day 1"; Day day2 = new Day(); day2.Events = Day2_Events; day2.day = "day 2"; Day day3 = new Day(); day3.Events = Day3_Events; day3.day = "day 3"; Day day4 = new Day(); day4.Events = Day4_Events; day4.day = "day 4"; list.Add(day1); list.Add(day2); list.Add(day3); list.Add(day4); RefInBack = false; this.defaultViewModel["Days"] = list; (sender as ListView).ItemsSource = this.defaultViewModel["Days"]; } }
private async void Fbook(object sender, RoutedEventArgs e) { DatabaseHelperClass dbhelper = new DatabaseHelperClass(); ImageModel mm = mal; dbhelper.Insert(mm); MessageDialog SuccessMsg = new MessageDialog("Image added sucessfully to your favorites"); await SuccessMsg.ShowAsync(); }
private void DeleteAll_Click(object sender, RoutedEventArgs e) { DatabaseHelperClass delete = new DatabaseHelperClass(); delete.DeleteAllContact(); //delete all DB contacts DB_ContactList.Clear(); //Clear collections btnDelete.IsEnabled = false; listBoxobj.ItemsSource = DB_ContactList; }
protected override void OnNavigatedTo(NavigationEventArgs e) { var param = e.Parameter as string[]; rootPage = param[0]; sqlip = param[1]; localDb = new DatabaseHelperClass(sqlip); errorLog = new ErrorLog(sqlip); }
private void ruaj_Click(object sender, RoutedEventArgs e) { DatabaseHelperClass Db_Helper = new DatabaseHelperClass(); Db_Helper.Insert(new Tabela.makinat("Auto", localSettings.Values["targa"].ToString(), localSettings.Values["shasia"].ToString())); Frame.Navigate(typeof(shfaqMakinat)); }
public MainPage() { this.InitializeComponent(); DatabaseHelperClass dbhelp = new DatabaseHelperClass(); dbhelp.OnCreate("sample2.sqlite"); Windows.Phone.UI.Input.HardwareButtons.BackPressed += HardwareButtons_BackPressed; this.NavigationCacheMode = NavigationCacheMode.Required; }
private void InsertMusicFormat() { string[] ListFormat = new string[] { "mp3", "flac", "alac", "m4a", "ape", "ogg", "wav", "wma", "aac" }; DatabaseHelperClass Db_Helper = new DatabaseHelperClass(); foreach (string format in ListFormat) { Db_Helper.Insert(new MusicFormat(format)); } }
private void Command(IUICommand command) { if (command.Label.Equals("Yes")) { DatabaseHelperClass Db_Helper = new DatabaseHelperClass(); Db_Helper.DeleteAllContact(); //delete all DB contacts DB_ContactList.Clear(); //Clear collections Btn_Delete.IsEnabled = false; listBoxobj.ItemsSource = DB_ContactList; } }
/// <summary> /// Populates the page with content passed during navigation. Any saved state is also /// provided when recreating a page from a prior session. /// </summary> /// <param name="sender"> /// The source of the event; typically <see cref="NavigationHelper"/> /// </param> /// <param name="e">Event data that provides both the navigation parameter passed to /// <see cref="Frame.Navigate(Type, Object)"/> when this page was initially requested and /// a dictionary of state preserved by this page during an earlier /// session. The state will be null the first time a page is visited.</param> private void NavigationHelper_LoadState(object sender, LoadStateEventArgs e) { Category cat = e.NavigationParameter as Category; this.DataContext = cat; DatabaseHelperClass db = new DatabaseHelperClass(); List <EventClass> list = db.ReadEvents(); EventsList.ItemsSource = list.Where(item => item.cid == cat.cid).ToList(); }
protected override void OnNavigatedTo(NavigationEventArgs e) { Category cat = e.Parameter as Category; this.DataContext = cat; DatabaseHelperClass db = new DatabaseHelperClass(); List <EventClass> list = db.ReadEvents(); EventsList.ItemsSource = list.Where(item => item.cid == cat.cid).ToList(); }
public static void Init(string _sqlip) { try { sqlsrv = new SqlServerRepository(_sqlip); localdb = new DatabaseHelperClass(_sqlip); } catch (Exception ex) { throw ex; } }
public void Filter_Fav_SelectionChanged(object sender, SelectionChangedEventArgs e) { List <int> Favs = new List <int>(); if ((sender as ComboBox).SelectedIndex == 1) { Day dayfav = new Day(); dayfav.day = ""; ObservableCollection <EventClass> FavEvents = new ObservableCollection <EventClass>(); var roamingSettings = ApplicationData.Current.RoamingSettings; if (roamingSettings.Values["Favs"] != null) { Favs = Deserialize <List <int> >(roamingSettings.Values["Favs"].ToString()); } if (Favs.Count == 0) { dayfav.day = "No Favourites Added Yet.."; } else { DatabaseHelperClass db = new DatabaseHelperClass(); foreach (int id in Favs) { if (db.ReadEventById(id) != null) { FavEvents.Add(db.ReadEventById(id)); } } foreach (EventClass eve in FavEvents) { eve.Fav_Image = ""; } } dayfav.Events = FavEvents; Favourites.Clear(); Favourites.Add(dayfav); MyPivot.ItemsSource = Favourites; } else { AssignItemSource(); MyPivot.ItemsSource = Days; } }
private async void AddContact_Click(object sender, RoutedEventArgs e) { DatabaseHelperClass Db_Helper = new DatabaseHelperClass();//Creating object for DatabaseHelperClass.cs from ViewModel/DatabaseHelperClass.cs if (NametxtBx.Text != "" & PhonetxtBx.Text != "") { Db_Helper.Insert(new Contacts(NametxtBx.Text, PhonetxtBx.Text)); Frame.Navigate(typeof(HomePage));//after add contact redirect to contact listbox page } else { } }
private void Translate() { ApplicationDataContainer localSettings = ApplicationData.Current.LocalSettings; if (localSettings.Values["Idioma"].ToString() == "pt") { return; } DatabaseHelperClass dbhandle = new DatabaseHelperClass(); NewTitle = dbhandle.Translate(NewTitle); }
/// <summary> /// Invoked when this page is about to be displayed in a Frame. /// </summary> /// <param name="e">Event data that describes how this page was reached. /// This parameter is typically used to configure the page.</param> protected override void OnNavigatedTo(NavigationEventArgs e) { Translate(); MainPage.instance.change_title(NewTitle); MainPage.instance.seach_clear(); string Text = e.Parameter.ToString(); DatabaseHelperClass dbtemas = new DatabaseHelperClass(); ObservableCollection <Search_Result> ResultList = dbtemas.Search(Text); listBoxobj.ItemsSource = ResultList.ToList(); }
public App() { this.InitializeComponent(); this.Suspending += OnSuspending; if (!CheckFileExists(nameDataBase).Result) { try { DatabaseHelperClass.CreateDatabase(); } catch { } } }
/// <summary> /// Invoked when this page is about to be displayed in a Frame. /// </summary> /// <param name="e">Event data that describes how this page was reached. /// This parameter is typically used to configure the page.</param> protected override void OnNavigatedTo(NavigationEventArgs e) { MainPage.instance.change_title("Temas"); DatabaseHelperClass dbtemas = new DatabaseHelperClass(); ObservableCollection <Classes.Conteudo_Tema> TemasList = dbtemas.ReadTemas();//Get all DB contacts foreach (var Temas in TemasList) { Temas.parent_tema.Icone = ConfigData.Iconpath + Temas.parent_tema.Icone; } listBoxobj.ItemsSource = TemasList.OrderByDescending(i => i.Titulo).ToList();//Latest contact ID can Display first }