示例#1
0
 public SignaturePage(PropertyPassDbTable PropertyPassTableID_, List <AssetDisplayClass> PropertyPassDisplayList_, SQLiteConnection connection_)
 {
     InitializeComponent();
     _PropertyPassTableID     = PropertyPassTableID_;
     _PropertyPassDisplayList = PropertyPassDisplayList_;
     _connection = connection_;
 }
示例#2
0
            public static IEnumerable <PropertyPassItemDbTable> ConvertListToDb(PropertyPassDbTable PropertyPassTable, List <AssetDisplayClass> AssetList)
            {
                var List = new List <PropertyPassItemDbTable>();

                foreach (AssetDisplayClass Asset in AssetList)
                {
                    var JsonObj = JsonConvert.DeserializeObject <AssetJsonObject>(Asset.AssetJSONDb);
                    var _PPI    = new PropertyPassItemDbTable
                    {
                        Asset_ID_Internal           = Asset.AssetIdInternal,
                        Assigned_By                 = PropertyPassTable.Assigned_By,
                        CheckOutDate                = DateTime.Now.ToString(),
                        DueDate                     = PropertyPassTable.DueDate,
                        PropertyPassID_Internal     = PropertyPassTable.PropertyPassID_Internal,
                        ModifiedOn                  = DateTime.Now.ToString(),
                        SiteIDInternal              = JsonObj.SiteIDInternal,
                        Quantity                    = Asset.Quantity,
                        PropertyPassItemID_Internal = GUID.Generate(),
                        AssetSerialNo               = JsonObj.AssetSerialNo,
                        CheckInDate                 = null,
                        Synced = true,
                    };
                    List.Add(_PPI);
                }
                return(List);
            }
示例#3
0
 public ScanBarcodePage(SQLiteConnection connection, string Person = null, bool PropertyPass = false, PropertyPassDbTable PropertyPassTableID = null)
 {
     MessagingCenter.Subscribe <string>(this, "Datawedge", (sender) => {
         searchbar.Text = sender;
     });
     loadvalues();
     if (Person != null)
     {
         _Person = Person;
     }
     _PropertyPass = PropertyPass;
     InitializeComponent();
     BarcodeImage.Source = ImageSource.FromResource("eQuipMobile.Images.Camera_icon.png");
     if (Application.Current.MainPage.Width < 768)
     {
         BarcodeImage.Margin = new Thickness(10, 0, 10, 0);
     }
     if (_PropertyPass)
     {
         _PropertyPassTableID = PropertyPassTableID;
         ScanLabel.Text       = "Scan barcode of asset to add to property pass";
     }
     _connection = connection;
     assetbarcodeListview.ItemsSource = defaultList;
 }
        public PropertyPassItemsList(SQLiteConnection connection, PropertyPassDbTable PropertyPassTableID)
        {
            _connection = connection;
            InitializeComponent();
            var propertyPassItems = Database.PropertyPassItem.GetTableDetailsByPropertyPassTable(_connection, PropertyPassTableID.PropertyPassID_Internal);

            _allPropItemsObs = new ObservableCollection <PropertyPassClass.PropertyPassDisplay>(PropertyPassClass.PropertyPassDisplay.GetData(propertyPassItems, _Names));
            //convert the propertyPass records to Asset displays with checkboxes GetTableDetailsByPropertyPassTable
            PropertyPassItemList.ItemsSource = propertyPassItems;
        }
        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");
            }
        }
示例#6
0
        public CheckinCheckoutPage(SQLiteConnection connection, string PropertyPassID)
        {
            var PPItemRecords = Database.PropertyPassItem.GetTableDataByPropertyPassTable(connection, PropertyPassID);

            _connection   = connection;
            _PropertyPass = PropertyPassID;
            _PPTable      = Database.PropertyPassTable.GetTableDataByID(_connection, _PropertyPass);
            InitializeComponent();
            if (PPItemRecords.Count() > 0)
            {
                CheckIn.IsEnabled = true;
            }
            else
            {
                CheckOut.IsEnabled = true;
            }
        }
示例#7
0
 public PropertyPassTable(PropertyPassDbTable PropertyPassDb = null)
 {
     if (PropertyPassDb != null)
     {
         Assigned_By             = PropertyPassDb.Assigned_By;
         AssignedToEmail         = PropertyPassDb.AssignedToEmail;
         AssignedToPhone         = PropertyPassDb.AssignedToPhone;
         Comments                = PropertyPassDb.Comments;
         CreationDate            = Convert.ToDateTime(PropertyPassDb.CreationDate);
         DueDate                 = Convert.ToDateTime(PropertyPassDb.DueDate);
         PeopleID_Internal       = PropertyPassDb.PeopleID_Internal;
         PropertyPassID_Internal = PropertyPassDb.PropertyPassID_Internal;
         PropertyPassLevel       = PropertyPassDb.PropertyPassLevel;
         SiteIDInternal          = PropertyPassDb.SiteIDInternal;
         TerminationDate         = Convert.ToDateTime(PropertyPassDb.TerminationDate);
         ModifiedOn              = Convert.ToDateTime(PropertyPassDb.ModifiedOn);
         SignaturePic            = PropertyPassDb.SignaturePic;
     }
 }