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;
}
