private async Task <bool> LoadTasks()
{
bool result = false;
try
{
ViewModels.ProjectData projectdata = Services.XServices.Instance.GetService <ViewModels.ProjectData>();
IComosWeb m_ComosWeb = Services.XServices.Instance.GetService <IComosWeb>();
IDatabase db = Services.XServices.Instance.GetService <IDatabase>();
//this.ShowToast($"Finding CObject on DB");
CObject o = db.GetCObjectByFullName(projectdata.SelectedLayer.UID, Constants.QueryWorkPackagesSystemFullName);
if (o == null)
{
try
{
o = await m_ComosWeb.GetObjectBySystemFullName(projectdata.SelectedLayer, Constants.QueryInspectionsSystemFullName);
}
catch (Exception ex)
{
await App.Current.MainPage.DisplayAlert("Error", "Error al cargar query: " + ex.Message, Services.TranslateExtension.TranslateText("OK"));
return(false);
}
db.InsertCObject(o, projectdata.SelectedLayer.UID);
}
if (o == null)
{
await App.Current.MainPage.DisplayAlert(Services.TranslateExtension.TranslateText("error"), Services.TranslateExtension.TranslateText("my_tasks_not_found"), "OK");
return(false);
}
try
{
m_QueryResult = await m_ComosWeb.GetqueriesResult(
projectdata.SelectedDB.Key, o.ProjectUID, o.OverlayUID, projectdata.SelectedLanguage.LCID, o.UID, null);
}
catch (Exception ex)
{
await App.Current.MainPage.DisplayAlert("Error", "Error al cargar query: " + ex.Message, Services.TranslateExtension.TranslateText("OK"));
return(false);
}
if (m_QueryResult != null)
{
Converters.IsQueryCachedValue cachehandler = new Converters.IsQueryCachedValue();
cachehandler.GetQueryCachedValues(m_QueryResult);
if (m_QueryResult.Rows.Length > 0)
{
List <ViewModel> tasks = new List <ViewModel>();
foreach (var row in m_QueryResult.Rows)
{
tasks.Add(new ViewModel(m_QueryResult.Columns, row));
}
this.TasksCollection = tasks.ToArray();
OnPropertyChanged("TasksCollection");
OnPropertyChanged("TasksAttributeNames");
UpdateSortingAndGrouping();
}
else
{
ShowToast(Services.TranslateExtension.TranslateText("no_tasks_found"));
}
result = true;
}
else
{
//page not loaded at comosweboffline
ShowToast(Services.TranslateExtension.TranslateText("no_tasks_found"));
}
ListViewTasks.EndRefresh();
return(result);
}
catch (Exception e)
{
await App.Current.MainPage.DisplayAlert(Services.TranslateExtension.TranslateText("error"), e.Message, "OK");
return(false);
}
}
public static async Task <bool> LoadLogBookForm()
{
CQuerieResult m_QueryResult;
try
{
ViewModels.ProjectData projectdata = Services.XServices.Instance.GetService <ViewModels.ProjectData>();
IComosWeb m_ComosWeb = Services.XServices.Instance.GetService <IComosWeb>();
IDatabase db = Services.XServices.Instance.GetService <IDatabase>();
CObject o = db.GetCObjectByFullName(projectdata.SelectedLayer.UID, Constants.QueryLogBookTypesFullName);
if (o == null)
{
try
{
o = await m_ComosWeb.GetObjectBySystemFullName(projectdata.SelectedLayer, Constants.QueryLogBookTypesFullName);
}
catch (TaskCanceledException) { return(false); } // If there is a Logout Request
catch (Exception ex)
{
await App.Current.MainPage.DisplayAlert("Error", "Error al cargar query: " + ex.Message, Services.TranslateExtension.TranslateText("OK"));
return(false);
}
db.InsertCObject(o, projectdata.SelectedLayer.UID);
}
if (o == null)
{
await App.Current.MainPage.DisplayAlert(Services.TranslateExtension.TranslateText("error"), Services.TranslateExtension.TranslateText("no_logbook_types_found"), "OK");
return(false);
}
try
{
m_QueryResult = await m_ComosWeb.GetqueriesResult(
projectdata.SelectedDB.Key, o.ProjectUID, o.OverlayUID, projectdata.SelectedLanguage.LCID, o.UID, null);
}
catch (TaskCanceledException) { return(false); } // If there is a Logout Request
catch (Exception ex)
{
await App.Current.MainPage.DisplayAlert("Error", "Error al cargar query: " + ex.Message, Services.TranslateExtension.TranslateText("OK"));
return(false);
}
if (m_QueryResult != null)
{
Converters.IsQueryCachedValue cachehandler = new Converters.IsQueryCachedValue();
cachehandler.GetQueryCachedValues(m_QueryResult);
if (m_QueryResult.Rows.Length > 0)
{
logBook = new ViewModel(m_QueryResult.Columns, m_QueryResult.Rows[0]);
return(true);
}
else
{
await App.Current.MainPage.DisplayAlert(Services.TranslateExtension.TranslateText("error"), Services.TranslateExtension.TranslateText("no_logbook_types_found"), "OK");
return(false);
}
}
else
{
await App.Current.MainPage.DisplayAlert(Services.TranslateExtension.TranslateText("error"), Services.TranslateExtension.TranslateText("no_logbook_types_found"), "OK");
return(false);
}
}
catch (Exception e)
{
await App.Current.MainPage.DisplayAlert(Services.TranslateExtension.TranslateText("error"), e.Message, "OK");
return(false);
}
}
