//Pioche dans ABO07 public static DataTable ListeDesFactures(string centre, string client, string ordre, string periode, string numFacture) { try { using (ABO07Entities context = new ABO07Entities()) { List <object> query = null; using (galadbEntities context1 = new galadbEntities()) { CENTFAC MyCENFAC = new CENTFAC(); var _LeCENTFAC = context.CENTFAC; var _LCPROFAC = context.CPROFAC; var _leCREDFAC = context.CREDFAC; var _laREDVANCE = context1.REDEVANCE; var _lEVENEMENT = context1.EVENEMENT; //var _ = context1.ENTFAC; var _REDFACT = context1.REDFAC; var _ENTFAC = context1.ENTFAC; var _PROFAC = context1.PROFAC; var _AG = context1.AG; #region if (_leCREDFAC.FirstOrDefault(d => d.CENTRE == centre && d.CLIENT == client && d.FACTURE == numFacture && d.PERIODE == periode) != null) { query.Add(ListeFactureABO07(centre, client, ordre, periode, numFacture)); } #endregion #region else { //query = ListeFacturegaladb(centre, client, ordre, periode, numFacture, query, _LeCENTFAC); } #endregion } return(Galatee.Tools.Utility.ListToDataTable(query)); } } catch (Exception ex) { throw ex; } }
//Edition de facture public List <CsFactureClient> ListeDesFactures(string centre, string client, string ordre, string periode, string numFacture) { try { CsLafactureClient entfacs = new CsLafactureClient(); Galatee.Entity.Model.CENTFAC dt = Galatee.Entity.Model.EserviceProcedure.ListeFactureABO07(centre, client, ordre, periode, numFacture).FirstOrDefault(); entfacs._LstProfact = Entities.ConvertObject <CsProduitFacture, Galatee.Entity.Model.CPROFAC>(dt.CPROFAC.ToList()); entfacs._LstRedFact = Entities.ConvertObject <CsRedevanceFacture, Galatee.Entity.Model.CREDFAC>(dt.CREDFAC.ToList()); entfacs._LeEntatfac = Entities.ConvertObject <CsEnteteFacture, Galatee.Entity.Model.CENTFAC>(dt); decimal?AncSolde = 0; //Galatee.Entity.Model.FonctionCaisse.RetourneSoldeClient(entfacs._LeEntatfac.FK_IDCLIENT); galadbEntities context = new galadbEntities(); List <UNITECOMPTAGE> _lstUniteComptage = context.UNITECOMPTAGE.ToList(); List <REDEVANCE> _lstRedevence = context.REDEVANCE.ToList(); List <CsFactureClient> lstFactureEdite = new List <CsFactureClient>(); int i = 0; foreach (CsProduitFacture items in entfacs._LstProfact) { foreach (CsRedevanceFacture itemss in entfacs._LstRedFact.OrderBy(p => p.TRANCHE)) { CsFactureClient FactureEdite = new CsFactureClient(); FactureEdite.Unite = _lstUniteComptage.FirstOrDefault(x => x.CODE == itemss.UNITE).LIBELLE; //FactureEdite.LibelleTranche = _lstRedevence.FirstOrDefault(x => x.PRODUIT == items.PRODUIT && x.CODE == itemss.REDEVANCE && x.TRANCHE == itemss.TRANCHE).LIBELLE; //FactureEdite.AncienReport = (AncSolde == 0 || AncSolde == null) ? 0 : AncSolde; //new CsFactureClient().MajRedevanceFacture(ref FactureEdite, itemss); //new CsFactureClient().MajProduitFacture(ref FactureEdite, items); //new CsFactureClient().MajEnteteFacture(ref FactureEdite, entfacs._LeEntatfac); FactureEdite.SoldeTotFTTC = FactureEdite.TotFTTC + AncSolde; //FactureEdite.dateExige = Convert.ToDateTime(Convert.ToDateTime(entfacs._LeEntatfac.DFAC) + TimeSpan.FromDays((int)entfacs._LeEntatfac.EXIG )).ToShortDateString(); i++; FactureEdite.OrdreAffichage = i; lstFactureEdite.Add(FactureEdite); } } if (entfacs._LstRedFact.Count < 19) { for (int j = i + 1; j <= 19; j++) { CsFactureClient FactureEdite = new CsFactureClient(); //if (entfacs._LstProfact != null) //{ // if (entfacs._LstProfact.Count > 0) // new CsFactureClient().MajProduitFacture(ref FactureEdite, entfacs._LstProfact[0]); //} //if (true) //{ // new CsFactureClient().MajEnteteFacture(ref FactureEdite, entfacs._LeEntatfac); //} FactureEdite.SoldeTotFTTC = FactureEdite.TotFTTC + AncSolde; FactureEdite.OrdreAffichage = j; lstFactureEdite.Add(FactureEdite); } } context.Dispose(); return(lstFactureEdite); } catch (Exception ex) { throw new Exception(ex.Message); } }