//Pioche dans ABO07
 public static DataTable ListeDesClientPourEnvoieMailRegroupement(int IdClient, List <string> lstPeriode, List <string> lstRegroupement, bool sms, bool email)
 {
     try
     {
         using (ABO07Entities context = new ABO07Entities())
         {
             var _LeCENTFAC = context.CENTFAC;
             var query      = (
                 from x in _LeCENTFAC
                 where
                 (lstPeriode == null || lstPeriode.Contains(x.PERIODE)) &&
                 (IdClient == 0 || x.FK_IDCLIENT == IdClient) &&
                 (lstRegroupement != null && lstRegroupement.Contains(x.REGROUPEMENT)) &&
                 (x.ISFACTUREEMAIL != null || x.ISFACTURESMS != null) &&
                 (x.EMAIL != null || x.TELEPHONE != null)
                 select new
             {
                 x.CENTRE,
                 x.CLIENT,
                 x.ORDRE,
                 NomClient = x.NOMABON,
                 x.PERIODE,
                 montant = x.TOTFTTC,
                 numfact = x.FACTURE,
                 ISFACTURE = x.ISFACTUREEMAIL.Value,
                 ISSMS = x.ISFACTURESMS.Value,
                 x.EMAIL,
                 x.TELEPHONE
             });
             if (!sms && !email && query != null)
             {
                 query = (from x in query
                          where x.ISFACTURE || x.ISSMS
                          select x);
             }
             else if (sms && query != null)
             {
                 query = (from x in query
                          where x.ISSMS
                          select x);
             }
             else if (email && query != null)
             {
                 query = (from x in query
                          where x.ISFACTURE
                          select x);
             }
             return(Galatee.Tools.Utility.ListToDataTable(query.ToList()));
         }
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Beispiel #2
0
 public static bool InsertEntityAbo07 <T>(T entity, ABO07Entities pContext) where T : class
 {
     try
     {
         if (pContext.Entry(entity).State == EntityState.Detached)
         {
             pContext.Set <T>().Add(entity);
         }
         return(true);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Beispiel #3
0
        public static bool UpdateEntity <T>(T pEntity, ABO07Entities pContext) where T : class
        {
            try
            {
                if (pContext.Entry(pEntity).State == EntityState.Detached)
                {
                    pContext.Set <T>().Attach(pEntity);
                }

                pContext.Entry(pEntity).State = EntityState.Modified;
                return(true);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        //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;
            }
        }
 public List <CsCredfac> GetCRedFacByRedevance(string centre, string periode)
 {
     try
     {
         using (ABO07Entities context = new ABO07Entities())
         {
             List <CsCredfac> Credfac = Entities.ConvertObject <CsCredfac, CREDFAC>(context.CREDFAC.Where(r => r.REDEVANCE == Enumere.Redevance).ToList());
             if (!string.IsNullOrWhiteSpace(centre))
             {
                 Credfac = Credfac.Where(r => r.CENTRE == centre).ToList();
             }
             if (!string.IsNullOrWhiteSpace(periode))
             {
                 Credfac = Credfac.Where(r => r.PERIODE == periode).ToList();
             }
             return(Credfac);
         }
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
        public static DataTable  ListeDesClientPourEnvoieMail(List <int> CentreClient, List <string> lstPeriode, bool sms, bool email)
        {
            try
            {
                using (ABO07Entities context = new ABO07Entities())
                {
                    var _LeCENTFAC             = context.CENTFAC;
                    IEnumerable <object> query =
                        from x in _LeCENTFAC
                        where CentreClient.Contains(x.FK_IDCENTRE) && lstPeriode.Contains(x.PERIODE) &&
                        ((x.ISFACTUREEMAIL != null && x.ISFACTUREEMAIL != false) || (x.ISFACTURESMS != null && x.ISFACTURESMS != false))
                        select new
                    {
                        x.CENTRE,
                        x.CLIENT,
                        x.ORDRE,
                        x.FACTURE,
                        x.PERIODE,
                        x.REGROUPEMENT,
                        x.CODCONSO,
                        x.CATEGORIECLIENT,
                        x.DFAC,
                        x.TOTFTAX,
                        x.TOTFHT,
                        x.TOURNEE,
                        //x.MOISCOMPTA,
                        x.COMMUNE,
                        //x.DATEENC,
                        //x.TYPEENC,
                        x.LOTRI,
                        x.COPER,
                        //x.MODEP,
                        x.ANCIENREPORT,
                        x.TOTFTTC,
                        x.LIENFAC,
                        x.SECTEUR,
                        x.QUARTIER,
                        x.ORDTOUR,
                        x.NOMABON,
                        x.RUE,
                        x.NOMRUE,
                        x.DRESABON,
                        //x.DATEFLAG,
                        x.USERCREATION,
                        x.DATECREATION,
                        x.USERMODIFICATION,
                        x.DATEMODIFICATION,
                        x.PK_ID,
                        x.FK_IDCENTRE,
                        x.FK_IDREGROUPEMENT,
                        x.FK_IDCODECONSOMMATEUR,
                        x.FK_IDCATEGORIECLIENT,
                        x.FK_IDMODEPAIEMENT,
                        x.FK_IDTOURNEE,
                        x.FK_IDCOMMUNE,
                        x.FK_IDCOPER,
                        x.FK_IDSECTEUR,
                        x.FK_IDQUARTIER,
                        x.FK_IDRUE,
                        x.ISFACTUREEMAIL,
                        x.EMAIL,
                        x.ISFACTURESMS,
                        x.TELEPHONE,
                        x.FK_IDCLIENT
                    };
                    return(Galatee.Tools.Utility.ListToDataTable(query));


                    //var _LeCENTFAC = context.CENTFAC;
                    //   IEnumerable<object> query =(
                    //                         from x in _LeCENTFAC
                    //                         where
                    //                         (lstPeriode == null || lstPeriode.Contains(x.PERIODE)) &&
                    //                         (CentreClient == null || CentreClient.Contains(x.FK_IDCENTRE )) &&
                    //                         (x.ISFACTUREEMAIL != null || x.ISFACTURESMS != null) &&
                    //                         ( x.EMAIL != null || x.TELEPHONE!=null)
                    //                         select new
                    //                         {
                    //                             x.CENTRE,
                    //                             x.CLIENT,
                    //                             x.ORDRE,
                    //                             NomClient = x.NOMABON,
                    //                             x.PERIODE,
                    //                             montant = x.TOTFTTC,
                    //                             numfact = x.FACTURE,
                    //                             ISFACTURE=x.ISFACTUREEMAIL ,
                    //                             ISSMS=    x.ISFACTURESMS
                    //                             ,x.EMAIL
                    //                             ,x.TELEPHONE
                    //                         });
                    ////if (!sms && !email && query!=null)
                    ////{
                    ////    query = (from x in query
                    ////            where  x.ISFACTURE || x.ISSMS
                    ////            select x);
                    ////}
                    ////else if (sms && query != null)
                    ////{
                    ////    query = (from x in query
                    ////             where x.ISSMS
                    ////             select x);
                    ////}
                    ////else if (email && query != null)
                    ////{
                    ////    query = (from x in query
                    ////             where x.ISFACTURE
                    ////             select x);
                    ////}
                    //return Galatee.Tools.Utility.ListToDataTable(query);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public static List <CENTFAC> ListeFactureDuplicata(string centre, string client, string ordre, string periode, string numFacture)
        {
            //using (ABO07Entities c = new ABO07Entities())
            //{


            //RECUPE DE L'ENTETE DE FACTURE
            #region RECUPE DE L'ENTETE DE FACTURE
            string Pperiode    = string.IsNullOrEmpty(periode) ? "" : periode;
            string PnumFacture = string.IsNullOrEmpty(numFacture) ? "" : numFacture;
            string vide        = "";

            ABO07Entities c      = new ABO07Entities();
            var           query_ = (from d in c.CENTFAC
                                    where (d.CENTRE == centre &&
                                           d.CLIENT == client &&
                                           d.ORDRE == ordre &&
                                           (d.FACTURE == numFacture || PnumFacture == vide) &&
                                           (d.PERIODE == periode || Pperiode == vide))


                                    select d).ToList();


            return((List <CENTFAC>)query_);

            #endregion

            ////UPDATE DE LA STRUCTURE CsLafactureClient
            //#region UPDATE DE LA STRUCTURE CsLafactureClient
            //     CsLafactureClient _tt = new CsLafactureClient();
            //     //_tt = Galatee.Entity.Model.EserviceProcedure.ListeFactureABO07(centre, client, ordre, periode, numFacture);
            //    //Galatee.Entity.Model.ENTFAC dt_ = Galatee.Entity.Model.EserviceProcedure.ListeFacturegaladb(centre, client, ordre, periode, numFacture);

            //     _tt._LeEntatfac = Entities.ConvertObject<CsEnteteFacture, Galatee.Entity.Model.CENTFAC>(dt);
            //     _tt._LstRedFact = Entities.ConvertObject<List<CsRedevanceFacture>, IEnumerable<Galatee.Entity.Model.CREDFAC>>(dt.CREDFAC.ToList());

            //     _tt._LstProfact = Entities.ConvertObject<List< CsProduitFacture>,IEnumerable<Galatee.Entity.Model.CPROFAC>>(dt.CPROFAC.ToList());


            //                List<CsRedevance> lestranche =ListeDesREdevance();
            //    if (_tt._Ls
            //        foreach (CsRedevanceFacture item in _tt._LstRedFact)
            //        {
            //            CsRedevance laTranchRech = lestranche.FirstOrDefault(p => p.NUMREDEVANCE == item.Redevance && item.Produit == p.FK_PRODUIT && item.Tranche == p.TRANCHE);
            //            if (laTranchRech != null)
            //            {
            //                item.Produit = laTranchRech.FK_PRODUIT;
            //                item.LibelleRedevance = laTranchRech.LIBELLE;
            //            }
            //        }
            //        List<CsProduitFacture> lesProduitFacture = ListeDesProduit();
            //        foreach (var item in _tt._LstProfact)
            //        {
            //            CsProduitFacture leProduit = lesProduitFacture.FirstOrDefault(p => p.Pk_Id == item.Pk_Id && item.Compteur == p.Compteur && item.Centre == p.Centre);
            //            if tRedFact != null && _tt._LstRedFact.Count > 0)
            //    {(leProduit != null)
            //            {
            //                item.Produit = leProduit.Produit;

            //            }
            //        }

            //        List<CsCategorieClient> lescategorieclient = ListeDesCategorieClient();

            //        CsCategorieClient lacategorieclient = lescategorieclient.FirstOrDefault(p => p.PK_CATEGORIECLIENT == _tt._LeEntatfac.Catcli);
            //        if (lacategorieclient != null)
            //            {
            //                _tt._LeEntatfac.Catcli = lacategorieclient.LIBELLE;

            //            }

            //    }
            //    #endregion
            //    return _tt;
            //};
        }