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