예제 #1
0
 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>()
         ;
 }
예제 #2
0
 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();
 }
예제 #3
0
 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();
 }
예제 #4
0
        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);
        }
예제 #5
0
 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();
 }
예제 #6
0
        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;
        }