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