public AssetListPage(SQLiteConnection connection_, LocationClass location, AssetDetailNames Names_, SublocationClass sublocation = null, DepartmentClass department = null) { _Names = Names_; MessagingCenter.Subscribe <string>(this, "Datawedge", (sender) => { SearchBar_.Text = sender; }); if (department != null) { BindingContext = department ?? throw new ArgumentNullException(); } else if (sublocation != null) { BindingContext = sublocation ?? throw new ArgumentNullException(); } else { BindingContext = location ?? throw new ArgumentNullException(); } _location = location; _sublocation = sublocation; _department = department; InitializeComponent(); BarcodeImage.Source = ImageSource.FromResource("eQuipMobile.Images.Camera_icon.png"); _connection = connection_; AssetListView.ItemsSource = GetAssetList(_location, _sublocation, _department); }
private void LoadSublocations(string LocationID = null) { var selectedSublocation = ""; var SublocationList = SublocationClass.DbToSubLocation(Database.SubLocations.GetTableDataFromLocations(_connection, LocationID)); assetSubLocation_.Items.Add("No " + _Names.SubLocation); foreach (SublocationClass sublocation in SublocationList) { assetSubLocation_.Items.Add(sublocation.SubLocationName); if (LocationID != null) { if (sublocation.Location_ID_Internal == LocationID) { selectedSublocation = sublocation.SubLocationName; } } if (selectedSublocation != "") { assetSubLocation_.SelectedItem = selectedSublocation; } else { assetSubLocation_.SelectedIndex = 0; } } }
private void GetData() { //instead of doing this, get all assets data from that location and send it to audit list string locationName; LocationClass LocationInfo = new LocationClass(); //gets location id internal if (assetLocation_.SelectedIndex >= 0) { locationName = assetLocation_.Items[assetLocation_.SelectedIndex]; LocationInfo = LocationClass.DbToLocation(Database.Locations.GetTableDataFromSites(_connection, _siteID), _connection).First(cm => cm.LocationName == locationName); } if (assetSubLocation_.SelectedIndex >= 1) { try { var sublocation = SublocationClass.DbToSubLocation(Database.SubLocations.GetTableData(_connection)).First(cm => cm.SubLocationName == assetSubLocation_.Items[assetSubLocation_.SelectedIndex]); Navigation.PushAsync(new AssetListPage(_connection, LocationInfo, Names_, sublocation)); } catch (Exception exc) { DependencyService.Get <IError>().SendRaygunError(exc, Application.Current.Properties["user"].ToString() ?? "unsynced", Application.Current.Properties["url"].ToString() ?? "unsynced", null); Navigation.PushAsync(new AssetListPage(_connection, LocationInfo, Names_)); } } else { Navigation.PushAsync(new AssetListPage(_connection, LocationInfo, Names_)); } }
List <AssetClass> GetAssetList(LocationClass location, SublocationClass sublocation, DepartmentClass department, string searchText = null) { var AssetList = AssetClass.DbToAssetClass(Database.Assets.GetAssetListForSearch(_connection, location, sublocation, department), _Names); if (String.IsNullOrWhiteSpace(searchText)) { return(AssetList); } return(AssetList.Where(c => (c.AssetName.Contains(searchText) || c.Barcode.Contains(searchText))).ToList()); }
List <SublocationClass> GetSublocations(LocationClass location_Class, string searchText = null) { var Sublocations = SublocationClass.DbToSubLocation(Database.SubLocations.GetTableDataFromLocations(_connection, location_Class.LocationIdInternal), _Names); if (String.IsNullOrWhiteSpace(searchText)) { return(Sublocations); } return(Sublocations.Where(c => c.SubLocationName.Contains(searchText)).ToList()); }
private void LoadSublocations(string LocationID = null, string SublocationName = null) { var SublocationList = SublocationClass.DbToSubLocation(Database.SubLocations.GetTableDataFromLocations(_connection, LocationID)); assetSubLocation_.Items.Add("No " + Names_.SubLocation); foreach (SublocationClass sublocation in SublocationList) { assetSubLocation_.Items.Add(sublocation.SubLocationName); } if (SublocationName != null) { assetSubLocation_.SelectedItem = SublocationName; } else { assetSubLocation_.SelectedIndex = 0; } }
public static List <SublocationClass> DbToSubLocation(IEnumerable <SubLocationsDbTable> SublocationDb, AssetDetailNames Names = null) { var SubLocationClassList = new List <SublocationClass>(); foreach (SubLocationsDbTable SubLocationDbrecord in SublocationDb) { var _intSubLoc = new SublocationClass { SubLocationName = SubLocationDbrecord.SubLocationName ?? "DefaultSublocationName", Location_ID_Internal = SubLocationDbrecord.Location_ID_Internal, SubLocationID_Internal = SubLocationDbrecord.SubLocationID_Internal }; if (Names != null) { _intSubLoc.SubLocationName_ = Names.SubLocation; } SubLocationClassList.Add(_intSubLoc); } return(SubLocationClassList); }