private void LoadLocation(string siteID = null, string LocationID = null)
        {
            var selectedLocationName = "";

            //site ID set so that it can be used to get locations later
            _siteID = siteID;
            var locationList = LocationClass.DbToLocation(Database.Locations.GetTableDataFromSites(_connection, siteID), _connection);

            foreach (LocationClass locations_ in locationList)
            {
                assetLocation_.Items.Add(locations_.LocationName);
                if (LocationID != null)
                {
                    if (locations_.LocationIdInternal == LocationID)
                    {
                        selectedLocationName = locations_.LocationName;
                    }
                }
            }
            if (selectedLocationName != "")
            {
                assetLocation_.SelectedItem = selectedLocationName;
            }
            else
            {
                assetLocation_.SelectedIndex = 0;
            }
        }
示例#2
0
        public static List <LocationClass> DbToLocation(IEnumerable <LocationsDbTable> LocationDb, SQLiteConnection _connection, AssetDetailNames Names = null)
        {
            var LocationClassList = new List <LocationClass>();

            foreach (LocationsDbTable LocationDbrecord in LocationDb)
            {
                var _intLoc = new LocationClass
                {
                    LocationIdInternal  = LocationDbrecord.LocationIdInternal,
                    LocationBarcode     = LocationDbrecord.LocationBarcode,
                    LocationDescription = LocationDbrecord.LocationDescription,
                    LocationName        = LocationDbrecord.LocationName,
                    SiteIdInternal      = LocationDbrecord.SiteIdInternal,
                    SubCount            = Database.SubLocations.GetTableDataFromLocations(_connection, LocationDbrecord.LocationIdInternal).Count(),
                    Count = Database.Assets.GetTableDataFromSiteLocation(_connection, LocationDbrecord.SiteIdInternal, LocationDbrecord.LocationIdInternal).Count()
                };
                if (Names != null)
                {
                    _intLoc.LocationName_    = Names.Location;
                    _intLoc.SublocationName_ = Names.SubLocation;
                }
                LocationClassList.Add(_intLoc);
            }
            return(LocationClassList);
        }
示例#3
0
 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 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;
                }
            }
        }
示例#5
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_));
            }
        }
        private void AddTransferAsset(string data)
        {
            try
            {
                var data_ = JsonConvert.DeserializeObject <TransferClassData>(data);
                if (transferList == null)
                {
                    var toSite = SitesClass.DbToSite(Database.Sites.GetTableData(_connection), _connection).First(cm => cm.SiteIdInternal == data_.ToSite);
                    data_.SiteNameTo = toSite.SiteName;
                    var fromsite = SitesClass.DbToSite(Database.Sites.GetTableData(_connection), _connection).First(cm => cm.SiteIdInternal == data_.FromSite);
                    data_.SiteNameFrom     = fromsite.SiteName;
                    data_.LocationNameTo   = LocationClass.DbToLocation(Database.Locations.GetTableDataFromSites(_connection, toSite.SiteIdInternal), _connection).First(cm => cm.LocationIdInternal == data_.ToLocation).LocationName;
                    data_.LocationNameFrom = LocationClass.DbToLocation(Database.Locations.GetTableDataFromSites(_connection, fromsite.SiteIdInternal), _connection).First(cm => cm.LocationIdInternal == data_.FromLocation).LocationName;
                    transferList           = new List <TransferClassData> {
                        data_
                    };
                }
                else
                {
                    var toSite = SitesClass.DbToSite(Database.Sites.GetTableData(_connection), _connection).First(cm => cm.SiteIdInternal == data_.ToSite);
                    data_.SiteNameTo = toSite.SiteName;
                    var fromsite = SitesClass.DbToSite(Database.Sites.GetTableData(_connection), _connection).First(cm => cm.SiteIdInternal == data_.FromSite);
                    data_.SiteNameFrom     = fromsite.SiteName;
                    data_.LocationNameTo   = LocationClass.DbToLocation(Database.Locations.GetTableDataFromSites(_connection, toSite.SiteIdInternal), _connection).First(cm => cm.LocationIdInternal == data_.ToLocation).LocationName;
                    data_.LocationNameFrom = LocationClass.DbToLocation(Database.Locations.GetTableDataFromSites(_connection, fromsite.SiteIdInternal), _connection).First(cm => cm.LocationIdInternal == data_.FromLocation).LocationName;
                    transferList.Add(data_);
                }

                scanned_.Text = transferList.Count.ToString();
            }catch (Exception exc)
            {
                DependencyService.Get <IError>().SendRaygunError(exc, Application.Current.Properties["user"].ToString() ?? "unsynced", Application.Current.Properties["url"].ToString() ?? "unsynced", null);
                DisplayAlert("Error", exc.Message, "OK");
            }
        }
示例#7
0
        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());
        }
示例#8
0
        List <LocationClass> GetLocations(string site_id, string searchText = null)
        {
            var locations = LocationClass.DbToLocation(Database.Locations.GetTableDataFromSites(_connection, site_id), _connection, _Names);

            if (String.IsNullOrWhiteSpace(searchText))
            {
                return(locations);
            }
            return(locations.Where(c => (c.LocationName.Contains(searchText) || c.LocationBarcode.Contains(searchText))).ToList());
        }
示例#9
0
        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 AssetLocation__SelectedIndexChanged(object sender, EventArgs e)
 {
     if (assetLocation_.SelectedIndex != -1)
     {
         assetSubLocation_.Items.Clear();
         if (assetLocation_.SelectedIndex > -1)
         {
             var locationName = assetLocation_.Items[assetLocation_.SelectedIndex];
             var LocationInfo = LocationClass.DbToLocation(Database.Locations.GetTableDataFromSites(_connection, _siteID), _connection).First(cm => cm.LocationName == locationName);
             LoadSublocations(LocationInfo.LocationIdInternal);
         }
     }
 }
示例#11
0
        public SublocationPage(SQLiteConnection _connection_, LocationClass location, AssetDetailNames Names_)
        {
            _Names = Names_;
            MessagingCenter.Subscribe <string>(this, "Datawedge", (sender) => {
                SearchBar_.Text = sender;
            });
            BindingContext = location ?? throw new ArgumentNullException();
            _location      = location;
            _connection    = _connection_;
            var SublocationsPresent = Database.SubLocations.GetTableDataFromLocations(_connection, _location.LocationIdInternal);

            InitializeComponent();
            BarcodeImage.Source             = ImageSource.FromResource("eQuipMobile.Images.Camera_icon.png");
            SublocationListView.ItemsSource = GetSublocations(_location);
        }
示例#12
0
 private void assetLocation__SelectedIndexChanged(object sender, EventArgs e)
 {
     if (assetLocation_.SelectedIndex != -1)
     {
         assetSubLocation_.Items.Clear();
         if (assetLocation_.SelectedIndex > -1)
         {
             var locationName = assetLocation_.Items[assetLocation_.SelectedIndex];
             var LocationInfo = LocationClass.DbToLocation(Database.Locations.GetTableDataFromSites(_connection, _siteID), _connection).First(cm => cm.LocationName == locationName);
             if (Application.Current.Properties.ContainsKey("AuditedSublocation") && Application.Current.Properties["AuditedSublocation"] != null)
             {
                 LoadSublocations(LocationInfo.LocationIdInternal, Application.Current.Properties["AuditedSublocation"].ToString());
             }
             else
             {
                 LoadSublocations(LocationInfo.LocationIdInternal);
             }
         }
     }
 }
示例#13
0
 private void assetLocation__SelectedIndexChanged(object sender, EventArgs e)
 {
     if (assetLocation_.SelectedIndex != -1)
     {
         if (assetLocation_.SelectedIndex == 0)
         {
             MissingLocationStack.IsVisible = true;
         }
         else
         {
             MissingLocationStack.IsVisible = false;
             assetSubLocation_.Items.Clear();
             if (assetLocation_.SelectedIndex > -1)
             {
                 var locationName = assetLocation_.Items[assetLocation_.SelectedIndex];
                 var LocationInfo = LocationClass.DbToLocation(Database.Locations.GetTableDataFromSites(_connection, _siteID), _connection).First(cm => cm.LocationName == locationName);
                 LoadSublocations();
             }
         }
     }
 }
示例#14
0
        private async void SaveAndContinue(object sender, EventArgs e)
        {
            if (assetSite_.SelectedIndex < 0 || assetLocation_.SelectedIndex < 0)
            {
                await DisplayAlert("Error", "Please select  values from the dropdown", "OK");
            }
            else
            {
                var siteName    = assetSite_.Items[assetSite_.SelectedIndex];
                var SiteDetails = SitesClass.DbToSite(Database.Sites.GetTableData(_connection), _connection).First(cm => cm.SiteName == siteName);

                var LocationName    = assetLocation_.Items[assetLocation_.SelectedIndex];
                var LocationDetails = LocationClass.DbToLocation(Database.Locations.GetTableDataFromSites(_connection, SiteDetails.SiteIdInternal), _connection).First(cm => cm.LocationName == LocationName);

                if (assetSubLocation_.SelectedIndex <= 0)
                {
                    await Navigation.PushAsync(new SaveAndContinuePage(_connection, Names_, SiteDetails.SiteIdInternal, LocationDetails.LocationIdInternal));
                }
                else
                {
                    await Navigation.PushAsync(new SaveAndContinuePage(_connection, Names_, SiteDetails.SiteIdInternal, LocationDetails.LocationIdInternal, assetSubLocation_.Items[assetSubLocation_.SelectedIndex]));
                }
            }
        }
示例#15
0
        private async void Button_Clicked_1(object sender, EventArgs e)
        {
            try
            {
                if (CheckValues())
                {
                    LocationClass LocationInfo = new LocationClass();
                    string        _LocationID  = "00000000-0000-0000-0000-00000000";
                    string        _Sublocation = null;
                    int           _Department  = 0;
                    string        desc         = "Asset created during audit. ";

                    string siteName = assetSite_.Items[assetSite_.SelectedIndex];
                    string _SiteID  = SitesClass.DbToSite(Database.Sites.GetTableData(_connection), _connection).First(cm => cm.SiteName == siteName).SiteIdInternal;

                    //gets location id internal
                    if (assetLocation_.SelectedIndex >= 0)
                    {
                        _LocationID = GUID.Generate().Substring(0, 7);
                        if (assetLocation_.SelectedIndex == 0)
                        {
                            if (MissingLoc.Text == null)
                            {
                                MissingLoc.Text = "Location added without name";
                            }
                            Database.Locations.Insert(_connection, new LocationsDbTable
                            {
                                LocationBarcode     = "Added " + _Names.Location,
                                LocationDescription = "Added " + _Names.Location,
                                LocationIdInternal  = _LocationID,
                                LocationName        = MissingLoc.Text,
                                SiteIdInternal      = _SiteID,
                            });
                            desc = desc + MissingLoc.Text;
                        }
                        else
                        {
                            string locationName = assetLocation_.Items[assetLocation_.SelectedIndex];
                            _LocationID = LocationClass.DbToLocation(Database.Locations.GetTableDataFromSites(_connection, _siteID), _connection).First(cm => cm.LocationName == locationName).LocationIdInternal;
                        }
                    }

                    if (assetSubLocation_.SelectedIndex == -1)
                    {
                        _Sublocation = null;
                    }
                    else
                    {
                        _Sublocation = assetSubLocation_.Items[assetSubLocation_.SelectedIndex];
                    }

                    if (assetDepartment_.SelectedIndex >= 0)
                    {
                        string departmentName = assetDepartment_.Items[assetDepartment_.SelectedIndex];
                        _Department = DepartmentClass.DbToDepartment(Database.Department.GetTableData(_connection)).First(cm => cm.DepartmentName == departmentName).ID;
                    }

                    //gets condition
                    ConditionClass conditionInfo = new ConditionClass();
                    if (assetCondition_.SelectedIndex >= 0)
                    {
                        string conditionName = assetCondition_.Items[assetCondition_.SelectedIndex];
                        conditionInfo = ConditionClass.DbToCondition(Database.Condition.GetTableData(_connection), _connection).First(cm => cm.ConditionLabel == conditionName);
                    }

                    //gets usages
                    UsageClass UsageInfo = new UsageClass();
                    if (assetUsage_.SelectedIndex >= 0)
                    {
                        string usageName = assetUsage_.Items[assetUsage_.SelectedIndex];
                        UsageInfo = UsageClass.DbToUsage(Database.Usage.GetTableData(_connection), _connection).First(cm => cm.UsageLabel == usageName);
                    }
                    string defcategory = Database.Category.GetTableData(_connection).First().AssetCategoryIDInternal;

                    AssetJsonObject newAsset = new AssetJsonObject
                    {
                        SiteIDInternal     = _SiteID,
                        LocationIDInternal = _LocationID,
                        SubLocation        = _Sublocation,
                        DataGatherID       = _Department,
                        AssetIDInternal    = GUID.Generate(),
                        IsActive           = true,
                        DateModified       = DateTime.Now,
                        AuditDate          = DateTime.Now,
                        AuditStatus        = "RECON-Added",
                        AssetName          = "RECON-Added Asset",
                        AssetDescription   = desc,
                        Barcode            = assetBarcode_.Text,
                        PeopleIDInternal   = "00000000-0000-0000-0000-000000000000",
                        AssetStatus        = "",
                        AssetSerialNo      = "",
                        Price                   = 0,
                        PurchaseDate            = Convert.ToDateTime("1/1/1900"),
                        PurchaseOrderNo         = "",
                        Quantity                = 1,
                        ShortageOverage         = 1,
                        Vendor                  = "",
                        Asset_UID               = "",
                        ThumbnailImage          = "",
                        OriginalPartNo          = "",
                        POStatus                = "N",
                        POLine                  = 0,
                        Model                   = "",
                        Mfg                     = "",
                        AssetConditionID        = conditionInfo.ConditionID,
                        AssetUsageID            = UsageInfo.UsageID,
                        AssetCategoryIDInternal = defcategory
                    };

                    //make into class
                    AssetClass asset = new AssetClass(newAsset);
                    ///make into databse format
                    var AssetForDb = AssetClass.AssetClassToDb(asset, false);
                    //save to database
                    Database.Assets.Insert(_connection, AssetForDb);
                    Application.Current.Properties["AuditedSite"]        = newAsset.SiteIDInternal;
                    Application.Current.Properties["AuditedLocation"]    = newAsset.LocationIDInternal;
                    Application.Current.Properties["AuditedSublocation"] = newAsset.SubLocation;
                    Application.Current.Properties["LastAssetID"]        = newAsset.AssetIDInternal;
                    Application.Current.Properties["Department"]         = newAsset.DataGatherID;
                    await DisplayAlert("Complete", "Asset Audited", "OK");

                    await Navigation.PopModalAsync();
                }
                else
                {
                    await DisplayAlert("Error", "There is a missing required data field. \"" + MissingField + "\" ", "OK");
                }
            }
            catch (Exception exe)
            {
                DependencyService.Get <IError>().SendRaygunError(exe, Application.Current.Properties["user"].ToString() ?? "Unsynced", Application.Current.Properties["url"].ToString() ?? "Unsynced", null);
                await DisplayAlert("Error", exe.Message, "OK");
            }
        }