public TransferModalpage(AssetDetailNames Names_, SQLiteConnection _connection_, int count, AssetDisplayClass assetData, string Site, string Location, string Sublocation = null, string Person = null)
{
_connection = _connection_;
_Names = Names_;
_globalcount = count;
_Site = Site;
_Location = Location;
_Sublocation = Sublocation;
_assetData = assetData;
_People = Person;
BindingContext = _assetData;
InitializeComponent();
AssetName_.Text = _Names.Name;
Barcode.Text = _Names.Barcode;
SiteName_.Text = _Names.Site;
LocationName_.Text = _Names.Location;
SublocationName_.Text = _Names.SubLocation;
QuantityName_.Text = _Names.Quantity;
if (_People != null)
{
TransferButton.Text = "Assign";
QtyName_to_assign.Text = _Names.Quantity + " to assign";
}
else
{
QtyName_to_assign.Text = _Names.Quantity + " to move";
}
}
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);
}
public ShowSummaryPage(SQLiteConnection connection_, AssetDetailNames Names_, string Site_, string Location, string SubLocation, int Dep_ = 0)
{
_connection = connection_;
_Names = Names_;
InitializeComponent();
var result = Database.Assets.GetAssetListForSearch(_connection, Site_, Location, SubLocation, Dep_);
int Audited = 0, Moved = 0, Cust = 0, Added = 0, quant = 0, dpt = 0, emp = 0;
foreach (AssetDbClass Assetrecord in result)
{
var Result = JsonConvert.DeserializeObject <AssetJsonObject>(Assetrecord.AssetJSONDb);
switch (Result.AuditStatus)
{
case "AUDITED":
Audited = Audited + 1;
break;
case "RECON-Moved":
Moved = Moved + 1;
break;
case "RECON-Added":
Added = Added + 1;
break;
case "RECON-Custodian":
Cust = Cust + 1;
break;
case "RECON-Quantity":
quant = quant + 1;
break;
case "RECON-Department":
dpt = dpt + 1;
break;
default:
emp = emp + 1;
break;
}
}
var Workflow = new WorkflowClass
{
AuditedAssets = Audited.ToString(),
NotAudited = emp.ToString(),
ReconAdded = Added.ToString(),
TotalAssets = result.Count().ToString(),
ReconCustodian = Cust.ToString(),
ReconDepartment = dpt.ToString(),
ReconMoved = Moved.ToString(),
ReconQuantity = quant.ToString()
};
WorkflowSummary.ItemsSource = new List <WorkflowClass>
{
Workflow
};
}
public TransferListPage(AssetDetailNames Names_, SQLiteConnection _connection_, IEnumerable <AssetDisplayClass> transferList_, string Site, string Location, string Sublocation = null, string People = null)
{
_Names = Names_;
_connection = _connection_;
InitializeComponent();
_Site = Site;
_People = People;
_Location = Location;
_Sublocation = Sublocation;
TransferListView.ItemsSource = AssetDisplayClass.FullDetails(transferList_, _Names);
}
public LocationPage(SQLiteConnection connection_, SitesClass site, AssetDetailNames Names_)
{
_Names = Names_;
MessagingCenter.Subscribe <string>(this, "Datawedge", (sender) => {
SearchBar_.Text = sender;
});
BindingContext = site ?? throw new ArgumentNullException();
InitializeComponent();
BarcodeImage.Source = ImageSource.FromResource("eQuipMobile.Images.Camera_icon.png");
_connection = connection_;
_locationSiteID = site.SiteIdInternal;
locationListView.ItemsSource = GetLocations(_locationSiteID);
}
public AddAuditPage(AssetDetailNames Names_, string site, string location, string sublocation, int department, string barcode, SQLiteConnection connection)
{
_Names = Names_;
_connection = connection;
InitializeComponent();
BindingContext = _Names;
assetBarcode_.Text = barcode;
LoadSites(site);
LoadLocation(site, location);
LoadSublocations(location, sublocation);
LoadDepartment(department);
LoadCondition();
LoadUsage();
}
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);
}
public AuditList(AssetDetailNames Names_, IEnumerable <AssetDbClass> AssetList, SQLiteConnection connection, bool Auditing, string Site, string Location, string Sublocation, int Department, string Person = null, string PersonName = null)
{
try
{
MessagingCenter.Subscribe <AuditRecordPage, string>(this, "Pop", (sender, arg) =>
{
Navigation.PopAsync();
});
_Names = Names_;
InitializeComponent();
_AssetList = AssetList;
_Auditing = Auditing;
_Site = Site;
_Location = Location;
_Sublocation = Sublocation;
_Department = Department;
_connection = connection;
if (Database.Settings.GetTableData(_connection).BlindAudit)
{
AuditListView2.IsVisible = true;
AuditListView.IsVisible = false;
AuditListView2.ItemsSource = AssetClass.DbToAssetClass(_AssetList, _Names, _connection);
}
else
{
AuditListView.IsVisible = true;
AuditListView2.IsVisible = false;
AuditListView.ItemsSource = AssetClass.DbToAssetClass(_AssetList, _Names, _connection);
}
if (Person != null)
{
PersonButton.IsVisible = true;
_PersonID = Person;
PersonName_.Text = PersonName + "'s Assets";
}
}
catch (Exception exe)
{
DependencyService.Get <IError>().SendRaygunError(exe, Application.Current.Properties["user"].ToString() ?? "unsynced", Application.Current.Properties["url"].ToString() ?? "unsynced", null);
throw (new Exception(exe.Message));
}
}
public ScanBarcodeUpdatePage(AssetDetailNames Names_, AssetDisplayClass details, SQLiteConnection connection_)
{
InitializeComponent();
BindingContext = details;
_connection = connection_;
var inermediate = Database.Assets.GetAssetDataByAssetIDInternal(_connection, details.AssetIdInternal);
_synced = inermediate.First().Synced;
_Asset = AssetClass.DbToAssetClass(inermediate).First().AssetJSON;
details.Quantity = _Asset.Quantity;
_Names = Names_;
scanbarcodeupdateasset.ItemsSource = new List <AssetDisplayClass>()
{
AssetDisplayClass.GetDetails(details)
};
//if (Application.Current.MainPage.Height <= 568)
//{
// Scan_scroll.HeightRequest = 550;
//}
}
public AuditRecordPage(AssetDetailNames Names_, AssetDbClass Asset, string Site, string Location, string Sublocation, int Department, SQLiteConnection connection, string Person = null)
{
_Names = Names_;
InitializeComponent();
LoadNames();
if (Site == null)
{
_SiteID = Asset.Asset_SiteIdInternal;
_LocationID = Asset.Asset_locationIdInternal;
_Sublocation = Asset.Asset_SublocationIdInternal;
_Department = Asset.Asset_Department;
}
else
{
_SiteID = Site;
_LocationID = Location;
_Sublocation = Sublocation;
_Department = Department;
}
if (Person != null)
{
_Person = Person;
AuditButton_.Text = "Audit To Person";
}
_connection = connection;
QuantityDisplay.IsVisible = !Database.Settings.GetTableData(_connection).BlindAudit;
IEnumAsset_ = new AssetDbClass[] { Asset };
var AuditAsset_ = JsonConvert.DeserializeObject <AssetJsonObject>(Asset.AssetJSONDb);
if (AuditAsset_.AuditDate == Convert.ToDateTime("01/01/1900 00:00:00"))
{
auditDate_.Text = "";
}
else
{
auditDate_.Text = AuditAsset_.AuditDate.ToString("s");
}
BindingContext = AuditAsset_;
}
public SaveAndContinuePage(SQLiteConnection connection_, AssetDetailNames Names_, string SiteID, string LocationID, string Sublocation = null)
{
_Names = Names_;
_connection = connection_;
InitializeComponent();
BarcodeImage.Source = ImageSource.FromResource("eQuipMobile.Images.Camera_icon.png");
if (Application.Current.MainPage.Width < 768)
{
BarcodeImage.Margin = new Thickness(10, 0, 10, 0);
}
BarcodeBartext.Text = "Scan the " + Names_.Barcode + " or type it into the search bar to audit it.";
_SiteID = SiteID;
_LocationID = LocationID;
_Sublocation = Sublocation;
if (Application.Current.Properties.ContainsKey("Department") && Application.Current.Properties["Department"] != null)
{
LoadDepartment(Convert.ToInt16(Application.Current.Properties["Department"].ToString()));
}
else
{
LoadDepartment();
}
}
private void loadvalues()
{
try
{
AssetDetailNames Names = JsonConvert.DeserializeObject <AssetDetailNames>(Application.Current.Properties["DesignInformation"].ToString());
_Names = Names;
List <AssetDisplayClass> defaultList_ = new List <AssetDisplayClass>
{
AssetDisplayClass.FullDetails(
new AssetDisplayClass
{
AssetName = "Asset Name",
Barcode = "Example barcode",
LocationName = "Example Location",
SiteName = "Example Site",
Quantity = 0,
Asset_SublocationIdInternal = "Example sublocation",
AssetIdInternal = "00",
AssetSerialNo = "oo",
Cost = 4,
AssetBarcode_ = "Barcode",
AssetCost_ = "Cost",
AssetLocationName_ = "Location",
AssetQuantity_ = "Qty",
AssetSerialNo_ = "Serial",
AssetSubLocationName_ = "SubLocation",
AssetSiteName_ = "Site"
}, _Names)
};
defaultList = defaultList_;
}
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");
}
}
public static AssetDisplayClass FullDetails(AssetDisplayClass display_, AssetDetailNames Name)
{
AssetJsonObject details = new AssetJsonObject();
if (display_.AssetJSONDb != null)
{
details = JsonConvert.DeserializeObject <AssetJsonObject>(display_.AssetJSONDb);
}
else
{
details.Quantity = 0;
details.AssetSerialNo = "000000";
details.Price = 0;
}
var returnedAssetDb = new AssetDisplayClass
{
AssetIdInternal = display_.AssetIdInternal,
Barcode = display_.Barcode,
AssetName = display_.AssetName,
Quantity = details.Quantity,
AssetSerialNo = details.AssetSerialNo,
Cost = details.Price,
SiteName = display_.SiteName,
LocationName = display_.LocationName,
Asset_SublocationIdInternal = display_.Asset_SublocationIdInternal,
AssetJSONDb = display_.AssetJSONDb,
AssetBarcode_ = Name.Barcode,
AssetSiteName_ = Name.Site,
AssetLocationName_ = Name.Location,
AssetSerialNo_ = Name.SerialNo,
AssetSubLocationName_ = Name.SubLocation,
AssetQuantity_ = Name.Quantity,
AssetCost_ = Name.Price
};
return(returnedAssetDb);
}
public static List <AssetClass> DbToAssetClass(IEnumerable <AssetDbClass> AssetJSON_, AssetDetailNames Names = null, SQLiteConnection _connection = null)
{
var AssetList = new List <AssetClass>();
foreach (AssetDbClass AssetDBData in AssetJSON_)
{
var intermediateAsset = new AssetClass
{
AssetIdInternal = AssetDBData.AssetIdInternal,
Asset_SiteIdInternal = AssetDBData.Asset_SiteIdInternal,
Asset_locationIdInternal = AssetDBData.Asset_locationIdInternal,
Asset_SublocationIdInternal = AssetDBData.Asset_SublocationIdInternal,
AssetName = AssetDBData.AssetName,
Asset_Department = AssetDBData.Asset_Department,
AssetSerialNumber = AssetDBData.AssetSerialNumber,
Asset_PeopleIdInternal = AssetDBData.Asset_PeopleIdInternal,
Barcode = AssetDBData.Barcode,
AssetJSON = JsonConvert.DeserializeObject <AssetJsonObject>(AssetDBData.AssetJSONDb),
ChangesMade = JsonConvert.DeserializeObject <List <Changesmade> >(AssetDBData.AssetChangesDb),
Synced = AssetDBData.Synced
};
if (_connection != null)
{
try
{
intermediateAsset.SiteName_ = Database.Sites.GetTableData(_connection).Single(cm => cm.SiteIdInternal == AssetDBData.Asset_SiteIdInternal).SiteName;
intermediateAsset.LocationName_ = Database.Locations.GetTableDataFromSites(_connection, AssetDBData.Asset_SiteIdInternal).Single(cm => cm.LocationIdInternal == AssetDBData.Asset_locationIdInternal).LocationName;
}
catch (Exception exc)
{
DependencyService.Get <IError>().SendRaygunError(exc, Application.Current.Properties["user"].ToString() ?? "unsynced", Application.Current.Properties["url"].ToString() ?? "unsynced", null);
}
}
if (Names != null)
{
intermediateAsset.BarcodeDisplay_ = Names.Barcode;
intermediateAsset.AssetSerialNumberDisplay_ = Names.SerialNo;
intermediateAsset.Asset_SublocationIdInternalDisplay_ = Names.SubLocation;
intermediateAsset.QuantityDisplay_ = Names.Quantity;
intermediateAsset.OriginalPartDisplay_ = Names.OriginalPartNo;
intermediateAsset.AuditStatusDisplay_ = Names.AuditStatus;
intermediateAsset.UIDDisplay_ = Names.Asset_UID;
intermediateAsset.SiteDisplay_ = Names.Site;
intermediateAsset.LocationDisplay_ = Names.Location;
}
AssetList.Add(intermediateAsset);
}
return(AssetList);
}
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);
}
public static IEnumerable <AssetDisplayClass> FullDetails(IEnumerable <AssetDisplayClass> AssetDisplay, AssetDetailNames Name)
{
List <AssetDisplayClass> returnedAssetDb = new List <AssetDisplayClass>();
foreach (AssetDisplayClass display_ in AssetDisplay)
{
var details = JsonConvert.DeserializeObject <AssetJsonObject>(display_.AssetJSONDb);
var singledisplay = new AssetDisplayClass
{
AssetIdInternal = display_.AssetIdInternal,
Quantity = details.Quantity,
AssetSerialNo = details.AssetSerialNo,
Cost = details.Price,
Barcode = display_.Barcode,
AssetName = display_.AssetName,
SiteName = display_.SiteName,
LocationName = display_.LocationName,
Asset_SublocationIdInternal = display_.Asset_SublocationIdInternal,
AssetJSONDb = display_.AssetJSONDb,
AssetBarcode_ = Name.Barcode,
AssetSiteName_ = Name.Site,
AssetLocationName_ = Name.Location,
AssetSerialNo_ = Name.SerialNo,
AssetSubLocationName_ = Name.SubLocation,
AssetQuantity_ = Name.Quantity,
AssetCost_ = Name.Price
};
returnedAssetDb.Add(singledisplay);
}
return(returnedAssetDb);
}
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);
}
public static IEnumerable <PropertyPassDisplay> GetData(IEnumerable <PropertyPassDisplay> display, AssetDetailNames Names_)
{
var returnval = display;
foreach (PropertyPassDisplay PPDisplay in display)
{
PPDisplay.Display_Barcode = Names_.Barcode;
PPDisplay.Display_Quantity = Names_.Quantity;
}
return(returnval);
}
public static List <SitesClass> DbToSite(IEnumerable <SitesDbTable> SitesDb, SQLiteConnection _connection, AssetDetailNames Names = null)
{
var SitesList = new List <SitesClass>();
foreach (SitesDbTable SiteDbRecord in SitesDb)
{
var intermediateSite = new SitesClass
{
SiteIdInternal = SiteDbRecord.SiteIdInternal,
SiteName = SiteDbRecord.SiteName,
SiteCode = SiteDbRecord.SiteCode,
SiteDescription = SiteDbRecord.SiteDescription,
Count = Database.Locations.GetTableDataFromSites(_connection, SiteDbRecord.SiteIdInternal).Count()
};
if (Names != null)
{
intermediateSite.SiteName_ = Names.Site;
intermediateSite.LocationName = Names.Location;
}
SitesList.Add(intermediateSite);
}
return(SitesList);
}
