public IQueryable<OperationRawSG> OperationRawSGs(int CompteId, int? Year, int? Month, string Etat, string SearchString, string Montant) { var controlServices = new OperationRawServices(uow); return controlServices.OperationRawSG(CompteId, Year, Month, Etat, SearchString, Montant) .AsQueryable<OperationRawSG>() ; }
public IQueryable<RapproRaw> RapproRawsLastChargement() { OperationRawServices services = new OperationRawServices(uow); DateTime dateChargement = services.GetDateDernierChargementByGroupe(ProfileUser.GroupeId); IQueryable<RapproRaw> rappros = uow.RapproRaw.GetLastChargementByGroupeId(ProfileUser.GroupeId, dateChargement); IQueryable<RapproRaw> rapproNonPointes = uow.RapproRaw.GetNonPointesNotInLastChargementByGroupeId(ProfileUser.GroupeId, dateChargement); return rappros.Union(rapproNonPointes).OrderByDescending(r => r.DateRapprochement).AsQueryable(); }
public IQueryable<RapproRaw> RapproRawsDernier4mois(int nbJoursRappro) { OperationRawServices services = new OperationRawServices(uow); DateTime dateChargement = services.GetDateDernierChargementByGroupe(ProfileUser.GroupeId); DateTime dateDernier4Mois = dateChargement.AddDays(-nbJoursRappro); IQueryable<RapproRaw> rappros = uow.RapproRaw.GetChargementFromByGroupeId(ProfileUser.GroupeId, dateDernier4Mois); return rappros.AsQueryable(); }
public Acquisition AcquisitionByCompteId(int compteId) { var service = new OperationRawServices(uow); var dernierDateChargement = service.GetDateDernierChargementByCompte(compteId); var derniereDateRaw = service.GetDateDerniereOpeRawByCompte(compteId); var rapproPossible = service.GetRapproPossible(compteId); return new Acquisition(dernierDateChargement, derniereDateRaw, rapproPossible); }
public IQueryable<OperationRawSG> RawsDernierChargementGroupe() { var groupeId = ProfileUser.GroupeId; OperationRawServices services = new OperationRawServices(uow); DateTime dateChargement = services.GetDateDernierChargementByGroupe(groupeId) ; IQueryable<OperationRawSG> raws = uow.OperationRawSG .GetLastChargementByGroupeId(groupeId, dateChargement) ; return raws.AsQueryable(); }
private void PopulateDropDownListForCreate(int CompteId) { // Services OperationRawServices rawSVC = new OperationRawServices(uow); // Dernier chargement string dateDernierChargement = rawSVC.GetDateDernierChargementByCompte(CompteId); ViewBag.DateDernierChargement = dateDernierChargement; string derniereOperation = rawSVC.GetDerniereOpeRawByCompte(CompteId); ViewBag.DerniereOperation = derniereOperation; }