private void GetDropDownData()
        {
            var siteName = assetSite_.Items[assetSite_.SelectedIndex];

            _Site = SitesClass.DbToSite(Database.Sites.GetTableData(_connection), _connection).First(cm => cm.SiteName == siteName).SiteIdInternal;

            var LocationName = assetLocation_.Items[assetLocation_.SelectedIndex];
            var __           = LocationClass.DbToLocation(Database.Locations.GetTableDataFromSites(_connection, _Site), _connection);

            _Location = __.First(cm => (cm.LocationName == LocationName && cm.SiteIdInternal == _Site)).LocationIdInternal;

            if (assetSubLocation_.SelectedIndex > 0)
            {
                _Sublocation = assetSubLocation_.Items[assetSubLocation_.SelectedIndex];
            }

            if (_Assign)
            {
                if (person_.SelectedIndex >= 0)
                {
                    var personName = person_.Items[person_.SelectedIndex];
                    _People = PeopleClass.DbToPeople(Database.People.GetTableData(_connection), _connection).First(cm => cm.PeopleName == personName).PeopleIDInternal;
                }
            }
        }
Пример #2
0
        private void LoadPerson()
        {
            var PersonList = PeopleClass.DbToPeople(Database.People.GetTableData(_connection), _connection);

            foreach (PeopleClass person in PersonList)
            {
                PropertyPassPerson.Items.Add(person.PeopleName);
            }
        }
Пример #3
0
        private async void AddPropertyPass(object sender, EventArgs e)
        {
            string      siteName, personName;
            SitesClass  siteInfo   = new SitesClass();
            PeopleClass personInfo = new PeopleClass();
            var         field      = CheckValues();

            if (field == "")
            {
                //gets site
                if (PropertyPassSite.SelectedIndex >= 0)
                {
                    siteName = PropertyPassSite.Items[PropertyPassSite.SelectedIndex];
                    siteInfo = SitesClass.DbToSite(Database.Sites.GetTableData(_connection), _connection).Single(cm => cm.SiteName == siteName);
                }

                //gets people
                if (PropertyPassPerson.SelectedIndex >= 0)
                {
                    personName = PropertyPassPerson.Items[PropertyPassPerson.SelectedIndex];
                    personInfo = PeopleClass.DbToPeople(Database.People.GetTableData(_connection), _connection).Single(cm => cm.PeopleName == personName);
                }
                var PPdata = new PropertyPassDbTable()
                {
                    AssignedToEmail         = PropertyPassEmail.Text,
                    CreationDate            = DateTime.Now.ToString("s"),
                    AssignedToPhone         = PropertyPassPhone.Text,
                    ModifiedOn              = DateTime.Now.ToString("s"),
                    Comments                = PropertyPassComments.Text,
                    DueDate                 = PropertyPassDueDate.Date.ToString("s"),
                    PeopleID_Internal       = personInfo.PeopleIDInternal,
                    SiteIDInternal          = siteInfo.SiteIdInternal,
                    PropertyPassID_Internal = GUID.Generate(),
                    Assigned_By             = Application.Current.Properties["user"].ToString(),
                    Synced = true
                };

                Database.PropertyPassTable.Insert(_connection, PPdata);
                await DisplayAlert("Complete", "The property pass table has been added.", "OK");

                await Navigation.PopAsync();
            }
            else
            {
                await DisplayAlert("Error", "The " + field + " field is required", "OK");
            }
        }
        private void LoadPerson()
        {
            var PersonList = PeopleClass.DbToPeople(Database.People.GetTableData(_connection), _connection);

            foreach (PeopleClass person in PersonList)
            {
                person_.Items.Add(person.PeopleName);
            }
            try
            {
                person_.SelectedIndex = 0;
            }
            catch (Exception exc)
            {
                DependencyService.Get <IError>().SendRaygunError(exc, Application.Current.Properties["user"].ToString() ?? "unsynced", Application.Current.Properties["url"].ToString() ?? "unsynced", null);
                DisplayAlert("Error", "You need people records to use this function", "OK");
                Navigation.PopAsync();
            }
        }