public Task <List <clUbicacion> > GetUbicsFich(ClAuditoria2 auditoria)
{
string param = auditoria.Fichero;
//return database.QueryAsync<clUbicacion>("SELECT [Ubicacion] FROM [UbiNoc] where [Fichero]='" + param + "' group by [Ubicacion]");
return(database.QueryAsync <clUbicacion>("select [Ubicacion], [EstUbicacion], [DataMining], count(NOC) as Num_regs, count(case when [Noc]<>'' then 1 end) as Num_nocs, sum([Check]) as SumCk from UbiNOC where [Fichero] = '" + param + "' group by [Ubicacion], [EstUbicacion],[DataMining]"));
}
public Task <List <clUbicacion> > Rellena_lista_ubics(ClAuditoria2 auditoria)
{
return(App.Database.GetUbicsFich(auditoria));
}
