public IEnumerable<Dto.CommittenteDto> ReadCommittenti(IList<string> stati) { try { var ef = new DataLayer.EntitiesModel(); var committenti = QueryCommittenti(null, null, null, null, stati); var committentiDto = UtilityPOCO.Assemble<Dto.CommittenteDto>(committenti, true); return committentiDto; } catch (Exception ex) { UtilityError.Write(ex); } return null; }
public IEnumerable<Dto.FornitoreDto> ReadFornitori(Dto.CommessaDto commessa) { try { var ef = new DataLayer.EntitiesModel(); var fornitori = (from q in ef.Fornitores where q.CommessaId == commessa.Id select q); var fornitoriDto = UtilityPOCO.Assemble<Dto.FornitoreDto>(fornitori); return fornitoriDto; } catch (Exception ex) { UtilityError.Write(ex); } return null; }
public Dto.CentroCostoDto ReadCentroCosto(object id) { try { var ef = new DataLayer.EntitiesModel(); var centroCosto = (from q in ef.CentroCostos where q.Id == (int)id select q).FirstOrDefault(); var centroCostoDto = UtilityPOCO.Assemble<Dto.CentroCostoDto>(centroCosto); return centroCostoDto; } catch (Exception ex) { UtilityError.Write(ex); } return null; }
public IEnumerable<Dto.CommessaDto> ReadCommesse(IList<string> stati) { try { var ef = new DataLayer.EntitiesModel(); var commesse = (from q in ef.Commessas where stati.Contains(q.Stato) select q); var commesseDto = UtilityPOCO.Assemble<Dto.CommessaDto>(commesse, true); return commesseDto; } catch (Exception ex) { UtilityError.Write(ex); } return null; }
private IQueryable<DataLayer.Fornitore> QueryFornitori(string search = null, object advancedSearch = null, Dto.CommessaDto commessa = null, OrderBy orderBy = null, IList<string> stati=null) { try { var ef = new DataLayer.EntitiesModel(); var fornitori = (from q in ef.Fornitores select q); if(commessa!=null) fornitori = (from q in fornitori where q.CommessaId == commessa.Id select q); if (search != null && search.Length > 0) { var commesseId = (from q in QueryCommesse(search) select q.Id).ToList(); var anagraficheFornitoriId = (from q in QueryAnagraficheFornitori(search) select q.Id).ToList(); fornitori = (from q in fornitori where anagraficheFornitoriId.Contains(q.AnagraficaFornitoreId) || commesseId.Contains(q.CommessaId) select q); } if (stati != null && stati.Count >= 1) { IQueryable<DataLayer.Fornitore> fornitoriStati = null; foreach (var stato in stati) { var fornitoriStato = (from q in fornitori where q.Stato != null && q.Stato.Contains(stato) select q); if (fornitoriStati != null) fornitoriStati = fornitoriStati.Concat(fornitoriStato); else fornitoriStati = fornitoriStato; } fornitori = fornitoriStati; } if (advancedSearch != null) fornitori = fornitori.Where((Func<DataLayer.Fornitore, bool>)advancedSearch).AsQueryable(); fornitori = (from q in fornitori orderby q.AnagraficaFornitore.RagioneSociale select q); if (orderBy != null) { if (orderBy.Direction == TypeOrder.Ascending) fornitori = fornitori.OrderBy((Func<DataLayer.Fornitore, object>)orderBy.Value).AsQueryable(); else if (orderBy.Direction == TypeOrder.Descending) fornitori = fornitori.OrderByDescending((Func<DataLayer.Fornitore, object>)orderBy.Value).AsQueryable(); } return fornitori; } catch (Exception ex) { UtilityError.Write(ex); } return null; }
private IQueryable<DataLayer.Notifica> QueryNotifiche(string search = null, object advancedSearch = null, OrderBy orderBy = null, DateTime? dataMax=null, string applicazione=null) { try { var ef = new DataLayer.EntitiesModel(); var notifiche = (from q in ef.Notificas select q); if (search != null && search.Length > 0) notifiche = (from q in notifiche where q.Codice.StartsWith(search) || q.Applicazione.Contains(search) || q.Tipo.StartsWith(search) select q); if (advancedSearch != null) notifiche = notifiche.Where((Func<DataLayer.Notifica, bool>)advancedSearch).AsQueryable(); if (dataMax != null) notifiche = (from q in notifiche where q.Applicazione == applicazione && q.Data <= dataMax select q); notifiche = (from q in notifiche orderby q.Id descending select q); if (orderBy != null) { if (orderBy.Direction == TypeOrder.Ascending) notifiche = notifiche.OrderBy((Func<DataLayer.Notifica, object>)orderBy.Value).AsQueryable(); else if (orderBy.Direction == TypeOrder.Descending) notifiche = notifiche.OrderByDescending((Func<DataLayer.Notifica, object>)orderBy.Value).AsQueryable(); } return notifiche; } catch (Exception ex) { UtilityError.Write(ex); } return null; }
private IQueryable<DataLayer.Commessa> QueryCommesse(string search = null, object advancedSearch = null, OrderBy orderBy = null) { try { var ef = new DataLayer.EntitiesModel(); var commesse = (from q in ef.Commessas select q); if (search != null && search.Length > 0) commesse = (from q in commesse where q.Codice.StartsWith(search) || q.Denominazione.Contains(search) || q.Comune.StartsWith(search) || q.Descrizione.Contains(search) || q.Indirizzo.Contains(search) ||q.Provincia.StartsWith(search) || q.Riferimento.Contains(search) || q.Stato.StartsWith(search) select q); if (advancedSearch != null) commesse = commesse.Where((Func<DataLayer.Commessa,bool>)advancedSearch).AsQueryable(); commesse = (from q in commesse orderby q.Id descending select q); if (orderBy != null) { if (orderBy.Direction == TypeOrder.Ascending) commesse = commesse.OrderBy((Func<DataLayer.Commessa, object>)orderBy.Value).AsQueryable(); else if (orderBy.Direction == TypeOrder.Descending) commesse = commesse.OrderByDescending((Func<DataLayer.Commessa, object>)orderBy.Value).AsQueryable(); } return commesse; } catch (Exception ex) { UtilityError.Write(ex); } return null; }
private IQueryable<DataLayer.Incasso> QueryIncassi(string search = null, object advancedSearch = null, Dto.CommittenteDto committente = null, Dto.FatturaVenditaDto fatturaVendita = null, OrderBy orderBy = null) { try { var ef = new DataLayer.EntitiesModel(); var incassi = (from q in ef.Incassos select q); if(fatturaVendita!=null) incassi = (from q in incassi where q.FatturaVenditaId == fatturaVendita.Id select q); if (committente != null) { var fattureVendita = committente.FatturaVenditas; if (fattureVendita != null) { var fattureVenditaId = (from q in fattureVendita select q.Id).ToList(); incassi = (from q in incassi where fattureVenditaId.Contains(q.FatturaVenditaId) select q); } } if (search != null && search.Length > 0) { var fattureVenditaId = (from q in QueryFattureVendita(search) select q.Id).ToList(); incassi = (from q in incassi where q.Note.Contains(search) || q.Codice.StartsWith(search) || q.Descrizione.Contains(search) || q.TipoPagamento.Contains(search) || q.TransazionePagamento.Contains(search) || fattureVenditaId.Contains(q.FatturaVenditaId) select q); } if (advancedSearch != null) incassi = incassi.Where((Func<DataLayer.Incasso, bool>)advancedSearch).AsQueryable(); incassi = (from q in incassi orderby q.Id descending select q); if (orderBy != null) { if (orderBy.Direction == TypeOrder.Ascending) incassi = incassi.OrderBy((Func<DataLayer.Incasso, object>)orderBy.Value).AsQueryable(); else if (orderBy.Direction == TypeOrder.Descending) incassi = incassi.OrderByDescending((Func<DataLayer.Incasso, object>)orderBy.Value).AsQueryable(); } return incassi; } catch (Exception ex) { UtilityError.Write(ex); } return null; }
public Dto.AccountDto AuthenticateAccount(Dto.AccountDto account) { try { if (account != null && account.Username != null) { var ef = new DataLayer.EntitiesModel(); var accountAuthenticated = (from q in ef.Accounts where q.Username!=null && q.Username.ToUpper() == account.Username.ToUpper() && q.Password == account.Password select q).FirstOrDefault(); var accountAuthenticatedDto = UtilityPOCO.Assemble<Dto.AccountDto>(accountAuthenticated); return accountAuthenticatedDto; } } catch (Exception ex) { UtilityError.Write(ex); } return null; }
public Dto.AccountDto ReadAccount(object id) { try { var ef = new DataLayer.EntitiesModel(); var account = (from q in ef.Accounts where q.Id == (int)id select q).FirstOrDefault(); var accountDto = UtilityPOCO.Assemble<Dto.AccountDto>(account); return accountDto; } catch (Exception ex) { UtilityError.Write(ex); } return null; }
public Dto.IncassoDto ReadIncasso(object id) { try { var ef = new DataLayer.EntitiesModel(); var incasso = (from q in ef.Incassos where q.Id == (int)id select q).FirstOrDefault(); var incassoDto = UtilityPOCO.Assemble<Dto.IncassoDto>(incasso,true); return incassoDto; } catch (Exception ex) { UtilityError.Write(ex); } return null; }
private IQueryable<DataLayer.FatturaVendita> QueryFattureVendita(string search = null, object advancedSearch = null, Dto.CommittenteDto committente = null, DateTime? start = null, DateTime? end = null, OrderBy orderBy = null, IList<string> stati=null) { try { var ef = new DataLayer.EntitiesModel(); var fattureVendita = (from q in ef.FatturaVenditas select q); if(committente!=null) fattureVendita = (from q in fattureVendita where q.CommittenteId == committente.Id select q); if (start != null && end != null) fattureVendita = (from q in fattureVendita where start <= q.Scadenza && q.Scadenza <= end select q); if (search != null && search.Length > 0) { var committentiId = (from c in QueryCommittenti(search) select c.Id).ToList(); fattureVendita = (from q in fattureVendita where q.Numero.StartsWith(search) || q.Descrizione.Contains(search) || q.TipoPagamento.StartsWith(search) || committentiId.Contains(q.CommittenteId) || q.Descrizione.Contains(search) || q.TipoPagamento.Contains(search) select q); } if (advancedSearch != null) fattureVendita = fattureVendita.Where((Func<DataLayer.FatturaVendita, bool>)advancedSearch).AsQueryable(); if (stati != null && stati.Count >= 1) { IQueryable<DataLayer.FatturaVendita> fattureVenditaStati = null; foreach (var stato in stati) { var fattureVenditaStato = (from q in fattureVendita where q.Stato != null && q.Stato.Contains(stato) select q); if (fattureVenditaStati != null) fattureVenditaStati = fattureVenditaStati.Concat(fattureVenditaStato); else fattureVenditaStati = fattureVenditaStato; } fattureVendita = fattureVenditaStati; } fattureVendita = (from q in fattureVendita orderby q.Id descending select q); if (orderBy != null) { if (orderBy.Direction == TypeOrder.Ascending) fattureVendita = fattureVendita.OrderBy((Func<DataLayer.FatturaVendita, object>)orderBy.Value).AsQueryable(); else if (orderBy.Direction == TypeOrder.Descending) fattureVendita = fattureVendita.OrderByDescending((Func<DataLayer.FatturaVendita, object>)orderBy.Value).AsQueryable(); } return fattureVendita; } catch (Exception ex) { UtilityError.Write(ex); } return null; }
public IEnumerable<Dto.CommittenteDto> ReadCommittenti(IEnumerable<Dto.AnagraficaCommittenteDto> anagraficheCommittenti) { try { if (anagraficheCommittenti != null) { var ef = new DataLayer.EntitiesModel(); var anagraficheCommittentiId = (from q in anagraficheCommittenti select q.Id).ToList(); var committenti = (from q in ef.Committentes where anagraficheCommittentiId.Contains(q.AnagraficaCommittenteId) select q); var committentiDto = UtilityPOCO.Assemble<Dto.CommittenteDto>(committenti, true); //lettura ricorsiva return committentiDto; } } catch (Exception ex) { UtilityError.Write(ex); } return null; }
public IEnumerable<Dto.CommittenteDto> ReadCommittenti(Dto.AnagraficaCommittenteDto anagraficaCommittente) { try { var ef = new DataLayer.EntitiesModel(); var committenti = (from q in ef.Committentes where q.AnagraficaCommittenteId == anagraficaCommittente.Id select q); var committentiDto = UtilityPOCO.Assemble<Dto.CommittenteDto>(committenti, true); //lettura ricorsiva return committentiDto; } catch (Exception ex) { UtilityError.Write(ex); } return null; }
private IQueryable<DataLayer.ReportJob> QueryReportJobs(string search = null, object advancedSearch = null, OrderBy orderBy = null) { try { var ef = new DataLayer.EntitiesModel(); var reportJobs = (from q in ef.ReportJobs select q); if (search != null && search.Length > 0) { var anagraficheFornitoriId = (from q in QueryAnagraficheFornitori(search) select q.Id).ToList(); var anagraficheCommittentiId = (from q in QueryAnagraficheCommittenti(search) select q.Id).ToList(); reportJobs = (from q in reportJobs where q.Codice.StartsWith(search) || q.NomeFile.Contains(search) || q.Tipo.Contains(search) || q.Codice.StartsWith(search) || (q.AnagraficaFornitoreId!=null && anagraficheFornitoriId.Contains((int)q.AnagraficaFornitoreId)) || (q.AnagraficaCommittenteId!=null && anagraficheCommittentiId.Contains((int)q.AnagraficaCommittenteId)) select q); } if (advancedSearch != null) reportJobs = reportJobs.Where((Func<DataLayer.ReportJob, bool>)advancedSearch).AsQueryable(); reportJobs = (from q in reportJobs orderby q.Id descending select q); if (orderBy != null) { if (orderBy.Direction == TypeOrder.Ascending) reportJobs = reportJobs.OrderBy((Func<DataLayer.ReportJob, object>)orderBy.Value).AsQueryable(); else if (orderBy.Direction == TypeOrder.Descending) reportJobs = reportJobs.OrderByDescending((Func<DataLayer.ReportJob, object>)orderBy.Value).AsQueryable(); } return reportJobs; } catch (Exception ex) { UtilityError.Write(ex); } return null; }
public Dto.SALDto ReadSAL(object id) { try { var ef = new DataLayer.EntitiesModel(); var sal = (from q in ef.SALs where q.Id == (int)id select q).FirstOrDefault(); var salDto = UtilityPOCO.Assemble<Dto.SALDto>(sal); return salDto; } catch (Exception ex) { UtilityError.Write(ex); } return null; }
public Dto.NotificaDto ReadNotifica(Dto.NotificaDto notifica, int occorrenza) { try { var ef = new DataLayer.EntitiesModel(); var today = DateTime.Today; var _inizio = today.AddDays(-occorrenza); var inizio = new DateTime(_inizio.Year, _inizio.Month, _inizio.Day , 0, 0, 0); var fine = new DateTime(today.Year, today.Month, today.Day, 23, 59, 59); var _notifica = (from q in ef.Notificas where q.Codice == notifica.Codice && q.Tipo == notifica.Tipo && q.Applicazione == notifica.Applicazione && inizio <= q.Data && q.Data <= fine select q).FirstOrDefault(); var notificaDto = UtilityPOCO.Assemble<Dto.NotificaDto>(_notifica); return notificaDto; } catch (Exception ex) { UtilityError.Write(ex); } return null; }
private IQueryable<DataLayer.SAL> QuerySALs(string search = null, object advancedSearch = null, Dto.CommessaDto commessa = null, OrderBy orderBy = null) { try { var ef = new DataLayer.EntitiesModel(); var sals = (from q in ef.SALs select q); if(commessa!=null) sals = (from q in sals where q.CommessaId == commessa.Id select q); if (search != null && search.Length > 0) { var commesseId = (from c in QueryCommesse(search) select c.Id).ToList(); sals = (from q in sals where q.Codice.StartsWith(search) || q.Denominazione.StartsWith(search) || commesseId.Contains(q.CommessaId) select q); } if (advancedSearch != null) sals = sals.Where((Func<DataLayer.SAL, bool>)advancedSearch).AsQueryable(); sals = (from q in sals orderby q.Id descending select q); if (orderBy != null) { if (orderBy.Direction == TypeOrder.Ascending) sals = sals.OrderBy((Func<DataLayer.SAL, object>)orderBy.Value).AsQueryable(); else if (orderBy.Direction == TypeOrder.Descending) sals = sals.OrderByDescending((Func<DataLayer.SAL, object>)orderBy.Value).AsQueryable(); } return sals; } catch (Exception ex) { UtilityError.Write(ex); } return null; }
public Dto.CommessaDto ReadCommessa(object id, bool recursive=false) { try { var ef = new DataLayer.EntitiesModel(); var commessa = (from q in ef.Commessas where q.Id == (int)id select q).FirstOrDefault(); var commessaDto = UtilityPOCO.Assemble<Dto.CommessaDto>(commessa, recursive); //lettura ricorsiva return commessaDto; } catch (Exception ex) { UtilityError.Write(ex); } return null; }
private IQueryable<DataLayer.Account> QueryAccounts(string search = null, object advancedSearch = null, OrderBy orderBy = null) { try { var ef = new DataLayer.EntitiesModel(); var accounts = (from q in ef.Accounts select q); if (search != null && search.Length > 0) accounts = (from q in accounts where q.Nickname.StartsWith(search) || q.Username.Contains(search) select q); if (advancedSearch != null) accounts = accounts.Where((Func<DataLayer.Account, bool>)advancedSearch).AsQueryable(); accounts = (from q in accounts orderby q.Username select q); if (orderBy != null) { if (orderBy.Direction == TypeOrder.Ascending) accounts = accounts.OrderBy((Func<DataLayer.Account, object>)orderBy.Value).AsQueryable(); else if (orderBy.Direction == TypeOrder.Descending) accounts = accounts.OrderByDescending((Func<DataLayer.Account, object>)orderBy.Value).AsQueryable(); } return accounts; } catch (Exception ex) { UtilityError.Write(ex); } return null; }
public IEnumerable<Dto.CommessaDto> ReadCommesse(IEnumerable<Dto.FornitoreDto> fornitori) { try { var ef = new DataLayer.EntitiesModel(); var fornitoriId = (from q in fornitori select q.Id).ToList(); var commesse = (from q in ef.Fornitores where fornitoriId.Contains(q.Id) select q.Commessa); var commesseDto = UtilityPOCO.Assemble<Dto.CommessaDto>(commesse); return commesseDto; } catch (Exception ex) { UtilityError.Write(ex); } return null; }
public Dto.AnagraficaCommittenteDto ReadAnagraficaCommittente(Dto.CommittenteDto committente) { try { var ef = new DataLayer.EntitiesModel(); var anagraficaCommittente = (from q in ef.AnagraficaFornitores where q.Id==committente.AnagraficaCommittenteId select q).FirstOrDefault(); var anagraficaCommittenteDto = UtilityPOCO.Assemble<Dto.AnagraficaCommittenteDto>(anagraficaCommittente); return anagraficaCommittenteDto; } catch (Exception ex) { UtilityError.Write(ex); } return null; }
public Dto.FornitoreDto ReadFornitore(object id) { try { var ef = new DataLayer.EntitiesModel(); var fornitore = (from q in ef.Fornitores where q.Id == (int)id select q).FirstOrDefault(); var fornitoreDto = UtilityPOCO.Assemble<Dto.FornitoreDto>(fornitore, true); return fornitoreDto; } catch (Exception ex) { UtilityError.Write(ex); } return null; }
public Dto.AnagraficaArticoloDto ReadAnagraficaArticolo(object id) { try { var ef = new DataLayer.EntitiesModel(); var anagraficaArticolo = (from q in ef.AnagraficaArticolos where q.Id == (int)id select q).FirstOrDefault(); var anagraficaArticoloDto = UtilityPOCO.Assemble<Dto.AnagraficaArticoloDto>(anagraficaArticolo); return anagraficaArticoloDto; } catch (Exception ex) { UtilityError.Write(ex); } return null; }
public IEnumerable<Dto.FornitoreDto> ReadFornitori(Dto.AnagraficaFornitoreDto anagraficaFornitore) { try { var ef = new DataLayer.EntitiesModel(); var fornitori = (from q in ef.Fornitores where q.AnagraficaFornitoreId == anagraficaFornitore.Id select q); var fornitoriDto = UtilityPOCO.Assemble<Dto.FornitoreDto>(fornitori, true); //lettura ricorsiva return fornitoriDto; } catch (Exception ex) { UtilityError.Write(ex); } return null; }
private IQueryable<DataLayer.AnagraficaArticolo> QueryAnagraficheArticoli(string search = null, object advancedSearch = null, OrderBy orderBy = null, Dto.AziendaDto azienda=null) { try { var ef = new DataLayer.EntitiesModel(); var anagraficheArticoli = (from q in ef.AnagraficaArticolos select q); if (azienda != null) anagraficheArticoli = (from q in anagraficheArticoli where q.AziendaId == azienda.Id select q); if (search != null && search.Length > 0) anagraficheArticoli = (from q in anagraficheArticoli where q.Codice.StartsWith(search) || q.Descrizione.Contains(search) select q); if (advancedSearch != null) anagraficheArticoli = anagraficheArticoli.Where((Func<DataLayer.AnagraficaArticolo, bool>)advancedSearch).AsQueryable(); anagraficheArticoli = (from q in anagraficheArticoli orderby q.Codice select q); if (orderBy != null) { if (orderBy.Direction == TypeOrder.Ascending) anagraficheArticoli = anagraficheArticoli.OrderBy((Func<DataLayer.AnagraficaArticolo, object>)orderBy.Value).AsQueryable(); else if (orderBy.Direction == TypeOrder.Descending) anagraficheArticoli = anagraficheArticoli.OrderByDescending((Func<DataLayer.AnagraficaArticolo, object>)orderBy.Value).AsQueryable(); } return anagraficheArticoli; } catch (Exception ex) { UtilityError.Write(ex); } return null; }
public IEnumerable<Dto.FornitoreDto> ReadFornitori(IEnumerable<Dto.AnagraficaFornitoreDto> anagraficheFornitori) { try { if (anagraficheFornitori != null) { var ef = new DataLayer.EntitiesModel(); var anagraficheFornitoriId = (from q in anagraficheFornitori select q.Id).ToList(); var fornitori = (from q in ef.Fornitores where anagraficheFornitoriId.Contains(q.AnagraficaFornitoreId) select q); var fornitoriDto = UtilityPOCO.Assemble<Dto.FornitoreDto>(fornitori, true); //lettura ricorsiva return fornitoriDto; } } catch (Exception ex) { UtilityError.Write(ex); } return null; }
public Dto.ReportJobDto ReadReportJob(object id) { try { var ef = new DataLayer.EntitiesModel(); var reportJob = (from q in ef.ReportJobs where q.Id == (int)id select q).FirstOrDefault(); var reportJobDto = UtilityPOCO.Assemble<Dto.ReportJobDto>(reportJob); return reportJobDto; } catch (Exception ex) { UtilityError.Write(ex); } return null; }
private IQueryable<DataLayer.CentroCosto> QueryCentriCosto(string search = null, object advancedSearch = null, OrderBy orderBy = null) { try { var ef = new DataLayer.EntitiesModel(); var centriCosto = (from q in ef.CentroCostos select q); if (search != null && search.Length > 0) centriCosto = (from q in centriCosto where q.Codice.StartsWith(search) || q.Denominazione.Contains(search) select q); if (advancedSearch != null) centriCosto = centriCosto.Where((Func<DataLayer.CentroCosto, bool>)advancedSearch).AsQueryable(); centriCosto = (from q in centriCosto orderby q.Denominazione select q); if (orderBy != null) { if (orderBy.Direction == TypeOrder.Ascending) centriCosto = centriCosto.OrderBy((Func<DataLayer.CentroCosto, object>)orderBy.Value).AsQueryable(); else if (orderBy.Direction == TypeOrder.Descending) centriCosto = centriCosto.OrderByDescending((Func<DataLayer.CentroCosto, object>)orderBy.Value).AsQueryable(); } return centriCosto; } catch (Exception ex) { UtilityError.Write(ex); } return null; }
private IQueryable<DataLayer.PagamentoUnificatoFatturaAcquisto> QueryPagamentiUnificatiFatturaAcquisto(string search = null, object advancedSearch = null, Dto.PagamentoUnificatoDto pagamentoUnificato = null, OrderBy orderBy = null) { try { var ef = new DataLayer.EntitiesModel(); var pagamentiUnificatiFatturaAcquisto = (from q in ef.PagamentoUnificatoFatturaAcquistos select q); if(pagamentoUnificato!=null) pagamentiUnificatiFatturaAcquisto = (from q in pagamentiUnificatiFatturaAcquisto where q.PagamentoUnificatoId == pagamentoUnificato.Id select q); if (search != null && search.Length > 0) { var fatturaAcquistoId = (from q in QueryFattureAcquisto(search) select q.Id).ToList(); var pagamentiUnificatiId = (from q in QueryPagamentiUnificati(search) select q.Id).ToList(); pagamentiUnificatiFatturaAcquisto = (from q in pagamentiUnificatiFatturaAcquisto where q.Note.Contains(search) || pagamentiUnificatiId.Contains(q.PagamentoUnificatoId) || fatturaAcquistoId.Contains(q.FatturaAcquistoId) select q); } if (advancedSearch != null) pagamentiUnificatiFatturaAcquisto = pagamentiUnificatiFatturaAcquisto.Where((Func<DataLayer.PagamentoUnificatoFatturaAcquisto, bool>)advancedSearch).AsQueryable(); pagamentiUnificatiFatturaAcquisto = (from q in pagamentiUnificatiFatturaAcquisto orderby q.Id descending select q); if (orderBy != null) { if (orderBy.Direction == TypeOrder.Ascending) pagamentiUnificatiFatturaAcquisto = pagamentiUnificatiFatturaAcquisto.OrderBy((Func<DataLayer.PagamentoUnificatoFatturaAcquisto, object>)orderBy.Value).AsQueryable(); else if (orderBy.Direction == TypeOrder.Descending) pagamentiUnificatiFatturaAcquisto = pagamentiUnificatiFatturaAcquisto.OrderByDescending((Func<DataLayer.PagamentoUnificatoFatturaAcquisto, object>)orderBy.Value).AsQueryable(); } return pagamentiUnificatiFatturaAcquisto; } catch (Exception ex) { UtilityError.Write(ex); } return null; }