// GET: DossierFclExports/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
//à mettre dans une classeDAO
var viewModel = new DossierFCLDetail();
if (!String.IsNullOrEmpty(id))
{
ViewBag.FclID = id.ToString();
viewModel.Clients = leCliDuDoss.GetClientByIdDoss(id);;
viewModel.DossierFclExports = leDoss.GetDossById(id);
viewModel.InstruTrans = instruDoss.GetInstruTransByIdDoss(id);
viewModel.Bookings = lesBkDuDoss.getBookingByIdDoss(id);
viewModel.Conteneurs = leTCduDoss.getAllTCByIdDoss(id);
viewModel.Marchandises = laMarchDuTC.getMarchByIdFcl(id);
viewModel.Transporteurs = lesTransDuDoss.GetTransByIdDoss(id);
viewModel.CompagnieMaritimes = cmDuDoss.GetCMByIdDoss(id);
viewModel.Mads = madDuDoss.GetMadByIdDoss(id);
viewModel.LigneDeVentes = ldvDuDoss.GetLigneDeVenteByIdDoss(id);
viewModel.Devis = leDevisDuDoss.getDevisByIDDoss(id, ldvDuDoss.GetLigneDeVenteByIdDoss(id));
}
if (viewModel == null)
{
return(HttpNotFound());
}
return(View(viewModel));
}
// GET: DossierFclExports/Details/5
public async Task <ActionResult> Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
//à mettre dans une classeDAO
var viewModel = new DossierFCLDetail();
if (!String.IsNullOrEmpty(id))
{
var ctList = (from ppl in db.DossierFclExports
join bk in db.Bookings on ppl.FCL_ID equals bk.FCL_ID
join ct in db.Conteneurs on bk.BKG_NUM equals ct.BKG_NUM
where ppl.FCL_ID == id
select ct).ToList();
var transList = (from ppl in db.DossierFclExports
join it in db.InstruTransporteurs on id equals it.FCL_ID
join tr in db.Transporteurs on it.TRS_REF equals tr.TRS_REF
where ppl.FCL_ID == id
select tr).ToList();
var madList = (from ppl in db.DossierFclExports
join it in db.InstruTransporteurs on id equals it.FCL_ID
join md in db.MADs on it.MAD_ID equals md.MAD_ID
where ppl.FCL_ID == id
select md).ToList();
var cmList = (from ppl in db.DossierFclExports
join bk in db.Bookings on ppl.FCL_ID equals bk.FCL_ID
join cm in db.CompagnieMaritimes on bk.CM_REF equals cm.CM_REF
where ppl.FCL_ID == id
select cm).ToList();
var cli = (from ppl in db.DossierFclExports
join cl in db.Clients on ppl.CLT_ID equals cl.CLT_ID
where ppl.FCL_ID == id
select cl).ToList();
var ligneVente = (from ppl in db.DossierFclExports
join lv in db.LigneDeVentes on ppl.FCL_ID equals lv.FCL_ID
where ppl.FCL_ID == id
select lv).ToList();
int idDevis = (from ppl in ligneVente
select ppl.Devi.DEVIS_ID).FirstOrDefault();
var devisDetail = (from ppl in db.Devis
where ppl.DEVIS_ID == idDevis
select ppl).ToList();
List <Marchandise> lstMarch = new List <Marchandise>();
foreach (var mc in ctList)
{
foreach (var m in mc.Marchandises)
{
lstMarch.Add(m);
}
}
ViewBag.FclID = id.ToString();
viewModel.Clients = cli;
viewModel.DossierFclExports = db.DossierFclExports.Where(x => x.FCL_ID == id).Include(d => d.Bookings).Include(d => d.InstruTransporteurs);
viewModel.InstruTrans = viewModel.DossierFclExports.Where(x => x.FCL_ID == id.ToString()).Single().InstruTransporteurs;
viewModel.Bookings = viewModel.DossierFclExports.Where(x => x.FCL_ID == id.ToString()).Single().Bookings;
viewModel.Conteneurs = ctList;
viewModel.Marchandises = lstMarch;
viewModel.Transporteurs = transList;
viewModel.CompagnieMaritimes = cmList;
viewModel.Mads = madList;
viewModel.LigneDeVentes = ligneVente;
viewModel.Devis = devisDetail;
}
if (viewModel == null)
{
return(HttpNotFound());
}
return(View(viewModel));
}
