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