public ActionResult UpdateRedevancesVendeur([FromUri] int idCommande)
{
try
{
var commandeAUpdate =
(from commande
in ctxt.PPHistoriquePaiements
where commande.NoCommande == idCommande
select commande).First();
commandeAUpdate.Redevance *= -1;
ctxt.SubmitChanges();
DetailsRedevances details =
(from vendeur
in ctxt.PPVendeurs
join paiement
in ctxt.PPHistoriquePaiements
on vendeur.NoVendeur equals paiement.NoVendeur
into paiementsVendeur
where vendeur.NoVendeur == commandeAUpdate.NoVendeur
select new DetailsRedevances
{
Paiements = paiementsVendeur.ToList(),
Vendeur = vendeur,
}).First();
return(PartialView("Gestionnaire/Redevances/_DetailsRedevances", details));
}
catch (InvalidOperationException e)
{
return(HttpBadRequest());
}
}
private ActionResult Redevances(int id)
{
try
{
var redevances =
(from paiement
in ctxt.PPHistoriquePaiements
where paiement.NoVendeur == id && paiement.Redevance > 0
select paiement).ToList();
var vendeur =
(from v
in ctxt.PPVendeurs
where v.NoVendeur == id
select v).First();
var viewModel = new DetailsRedevances
{
Vendeur = vendeur,
Paiements = redevances,
};
return(PartialView("Gestionnaire/Redevances/_DetailsRedevances", viewModel));
}
catch (InvalidOperationException e)
{
return(new HttpStatusCodeResult(HttpStatusCode.NotFound));
}
}