public void GetQueryCachedValues(CQuerieResult query) { Services.IDatabase cachedb = Services.XServices.Instance.GetService <Services.IDatabase>(); ViewModels.ProjectData ProjectData = Services.XServices.Instance.GetService <ViewModels.ProjectData>(); foreach (var row in query.Rows) { for (int i = 0; i < row.Items.Length; i++) { string uid = row.Items[0].UID; CCell item = row.Items[i]; string cachedvalue = cachedb.ReadCacheSpecValue(uid, "", ProjectData.SelectedProject.ProjectUID, ProjectData.SelectedLayer.UID, query.Columns[i].DisplayDescription); if (cachedvalue != "") { int result = 0; item.Text = cachedvalue; if (int.TryParse(cachedvalue, out result)) { item.NumericValue = result; } item.IsCachedValue = true; } } } }
private void GetAllDocuments() { List <ComosWebSDK.Data.CDocument> objects = null; Services.IDatabase db = Services.XServices.Instance.GetService <Services.IDatabase>(); ViewModels.ProjectData projectdata = Services.XServices.Instance.GetService <ViewModels.ProjectData>(); objects = db.GetAllDocuments(projectdata.SelectedProject.UID, projectdata.SelectedLayer.UID); listViewDocuments.ItemsSource = objects; }
private void btDelete_Clicked(object sender, EventArgs e) { Button bt = (Button)sender; ComosWebSDK.Data.CDocument doc = (ComosWebSDK.Data.CDocument)bt.BindingContext; Services.IDatabase db = Services.XServices.Instance.GetService <Services.IDatabase>(); Services.IPlatformSystem plataform = Services.XServices.Instance.GetService <Services.IPlatformSystem>(); db.DeleteDocument(doc.FileName); plataform.DeleteFile(doc.FileName); GetAllDocuments(); //this.ShowSpinner(Services.TranslateExtension.TranslateText("saving")); //await UploadDocument(doc.FileName, doc.UID, doc.Name); //this.HideSpinner(); }
private void GetAllObjectsWithCachedAttributes() { List <ComosWebSDK.Data.CObject> objects = null; Services.IDatabase db = Services.XServices.Instance.GetService <Services.IDatabase>(); ViewModels.ProjectData projectdata = Services.XServices.Instance.GetService <ViewModels.ProjectData>(); objects = db.GetDevicesWithCachedAttributes(projectdata.SelectedProject.UID, projectdata.SelectedLayer.UID); List <ComosWebSDK.Data.CObject> pictures = db.GetDevicesWithCachedPictures(projectdata.SelectedProject.UID, projectdata.SelectedLayer.UID); foreach (var item in pictures) { if (objects.Select(x => x.UID == item.UID).Count() == 0) { objects.Add(item); } } listViewUploads.ItemsSource = objects; }