public static DataTable RetourneListeValidation() { //cmd.CommandText = "SPX_GUI_RETOURNE_DABON"; try { using (galadbEntities context = new galadbEntities()) { IEnumerable <object> query = null; var _RCL_Validation = context.RCL_Validation; query = from p in _RCL_Validation select new { PK_ID = p.id, p.Code, p.Libelle }; return(Galatee.Tools.Utility.ListToDataTable(query)); } } catch (Exception ex) { throw ex; } }
public static void ValiderReclamation(CsDemandeReclamation pDemandeRecl, galadbEntities pContext) { try { galadbEntities contextinter = new galadbEntities(); RCL_Reclamation _Reclamation = new RCL_Reclamation(); if (pDemandeRecl.ReclamationRcl != null) { _Reclamation = Entities.ConvertObject <RCL_Reclamation, CsReclamationRcl>(pDemandeRecl.ReclamationRcl); } Entities.UpdateEntity <RCL_Reclamation>(_Reclamation, pContext); } catch (System.Data.Entity.Validation.DbEntityValidationException ex) { // Retrieve the error messages as a list of strings. //var errorMessages = ex.EntityValidationErrors // .SelectMany(x => x.ValidationErrors) // .Select(x => x.ErrorMessage); //// Join the list to a single string. //var fullErrorMessage = string.Join("; ", errorMessages); //// Combine the original exception message with the new one. //var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage); ////return exceptionMessage; //// Throw a new DbEntityValidationException with the improved exception message. //throw new System.Data.Entity.Validation.DbEntityValidationException(exceptionMessage, ex.EntityValidationErrors); throw ex; } }
public static bool UpdateEntity <T>(List <T> pEntity, galadbEntities pContext) where T : class { try { foreach (T _entity in pEntity) { try { if (pContext.Entry(_entity).State == EntityState.Detached) { pContext.Set <T>().Attach(_entity); } pContext.Entry(_entity).State = EntityState.Modified; } catch { continue; } } return(true); } catch (Exception ex) { throw ex; } }
public static DataTable ListeMenuSousMenu(string pModuleName, int Fk_idProfil) { try { using (galadbEntities context = new galadbEntities()) { var admMenu = context.ADMMENU; var MenuProfil = context.MENUSDUPROFIL; IEnumerable <object> query = from _MenuProfil in MenuProfil where _MenuProfil.ADMMENU.MODULE1.CODE == pModuleName && _MenuProfil.FK_IDPROFIL == Fk_idProfil select new { Module = _MenuProfil.ADMMENU.MODULE, MenuID = _MenuProfil.ADMMENU.PK_ID, //PK_MENUID, MenuText = _MenuProfil.ADMMENU.MENUTEXT, MainMenuID = _MenuProfil.ADMMENU.MAINMENUID, FormName = _MenuProfil.ADMMENU.FORMENAME, IsDock = _MenuProfil.ADMMENU.ISDOCK, IsControl = _MenuProfil.ADMMENU.ISCONTROLE, IdGroupProgram = _MenuProfil.ADMMENU.MODULE1.FK_IDGROUPPROGRAM, MenuOrder = _MenuProfil.ADMMENU.MENUORDER, }; return(Galatee.Tools.Utility.ListToDataTable(query)); } } catch (Exception ex) { throw ex; } }
public static List <CsTypeCompte> RetourneTypeCompte() { try { using (galadbEntities context = new galadbEntities()) { var _TypeCompte = context.COMPTA_TYPE_COMPTE; IEnumerable <object> query = from x in _TypeCompte select new { x.CODE, x.LIBELLE, x.PK_ID, x.AVECFILTRE, x.TABLEFILTRE, x.TABLEFILTRE1, x.TABLEFILTRE2, x.SIGNE, x.SOUSCOMPTE, x.VALEURMONTANT, x.USERCREATION, x.USERMODIFICATION, x.DATECREATION, x.DATEMODIFICATION }; DataTable dt = Galatee.Tools.Utility.ListToDataTable(query); return(Entities.GetEntityListFromQuery <CsTypeCompte>(dt)); } } catch (Exception ex) { throw; } }
public static List <CsCentreCompte> RetourneParamCentre() { try { using (galadbEntities context = new galadbEntities()) { var _TBanqueCompte = context.COMPTA_CENTRE; IEnumerable <object> query = from x in _TBanqueCompte select new { x.PK_ID, x.CODEACTIVITE, x.CODECENTRE, x.DC, x.LIBELLEACTIVITE, x.CODECOMPTA, x.CI }; DataTable dt = Galatee.Tools.Utility.ListToDataTable(query); return(Entities.GetEntityListFromQuery <CsCentreCompte>(dt)); } } catch (Exception ex) { throw; } }
public static List <CsOperationComptable> RetourneOperationComptable() { try { using (galadbEntities context = new galadbEntities()) { var _Operation = context.COMPTA_OPERATIONCOMPTABLE; IEnumerable <object> query = from x in _Operation select new { x.CODE, x.LIBELLE, x.PK_ID, x.COPERIDENTIFIANT, x.FK_IDCOPER, x.COPER.DC, x.USERCREATION, x.USERMODIFICATION, x.DATECREATION, x.DATEMODIFICATION, x.LIBELLECOMPTABLE }; DataTable dt = Galatee.Tools.Utility.ListToDataTable(query); return(Entities.GetEntityListFromQuery <CsOperationComptable>(dt)); } } catch (Exception ex) { throw ex; } }
public static int MAJImportFichier(Galatee.Structure.aImportFichier leParametrage) { try { using (galadbEntities context = new galadbEntities()) { PARAMETRAGEIMPORT import = context.PARAMETRAGEIMPORT.FirstOrDefault(c => c.CODE == leParametrage.CODE); if (import != null) { PARAMETRAGEIMPORT _limport = Entities.ConvertObject <PARAMETRAGEIMPORT, Galatee.Structure.aImportFichier>(leParametrage); Entities.UpdateEntity <PARAMETRAGEIMPORT>(_limport); return(_limport.CODE); } else { PARAMETRAGEIMPORT _limport = Entities.ConvertObject <PARAMETRAGEIMPORT, Galatee.Structure.aImportFichier>(leParametrage); Entities.InsertEntity <PARAMETRAGEIMPORT>(_limport); return(_limport.CODE); } } } catch (Exception ex) { throw ex; } }
public static DataTable RetourneListeModeReception() { //cmd.CommandText = "SPX_GUI_RETOURNE_DABON"; try { using (galadbEntities context = new galadbEntities()) { IEnumerable <object> query = null; var _SousControle = context.MODERECEPTION; query = from p in _SousControle select new { p.PK_ID, p.LIBELLE }; return(Galatee.Tools.Utility.ListToDataTable(query)); } } catch (Exception ex) { throw ex; } }
public static bool SaveAgent(List <Structure.CsAgent> agenttosynchro, string Requette) { using (galadbEntities Context = new galadbEntities()) { PARAMETRESGENERAUX PARAMETRESGENERAUX = Context.PARAMETRESGENERAUX.FirstOrDefault(p => p.CODE == "000406"); if (PARAMETRESGENERAUX != null) { PARAMETRESGENERAUX.LIBELLE = Requette; List <CsAgent> NouveauAgent = agenttosynchro.Where(a => a.ACTIF == true) != null?agenttosynchro.Where(a => a.ACTIF == true).ToList() : new List <CsAgent>(); List <AGENT> AgentToInsert = ConvertAgent(NouveauAgent); List <string> MatriculeAgent_a_Desactiver = agenttosynchro.Where(a => a.ACTIF == false).Select(a => a.MATRICULE).ToList(); List <ADMUTILISATEUR> UTILISATEUR = Context.ADMUTILISATEUR.Where(u => MatriculeAgent_a_Desactiver.Contains(u.MATRICULE)) != null?Context.ADMUTILISATEUR.Where(u => MatriculeAgent_a_Desactiver.Contains(u.MATRICULE)).ToList() : new List <ADMUTILISATEUR>(); foreach (var item in UTILISATEUR) { item.STATUSCOMPTE = Enumere.StatusSupprimer; } Entities.UpdateEntity <ADMUTILISATEUR>(UTILISATEUR, Context); Entities.UpdateEntity <PARAMETRESGENERAUX>(PARAMETRESGENERAUX, Context); bool result = Entities.InsertEntity <AGENT>(AgentToInsert, Context); Context.SaveChanges(); return(result); } else { return(false); } } }
public static string LoadRequest() { using (galadbEntities Context = new galadbEntities()) { return(Context.PARAMETRESGENERAUX.FirstOrDefault(p => p.CODE == "000406").LIBELLE); } }
public static bool DeleteImportFichier(int CodeImport) { try { using (galadbEntities context = new galadbEntities()) { PARAMETRAGEIMPORT import = context.PARAMETRAGEIMPORT.FirstOrDefault(c => c.CODE == CodeImport); if (import != null) { List <IMPORTCOLONNE> lstcolon = context.IMPORTCOLONNE.Where(c => c.ID_PARAMETRAGE == CodeImport).ToList(); foreach (IMPORTCOLONNE colon in lstcolon) { context.IMPORTCOLONNE.Remove(colon); context.SaveChanges(); } context.PARAMETRAGEIMPORT.Remove(import); context.SaveChanges(); return(true); } else { return(false); } }; } catch (Exception ex) { return(false); throw ex; } }
public static DataTable GetProfilUserByLoginName(int pIdUSer) { try { using (galadbEntities context = new galadbEntities()) { var profiluser = context.PROFILSUTILISATEUR; IEnumerable <object> query = from c in profiluser join a in context.MODULESDEFONCTION on c.PROFIL.FK_IDFONCTION equals a.FK_IDFONCTION where c.FK_IDADMUTILISATEUR == pIdUSer //&& c.DATEDEBUT.Value <= System.DateTime.Today.Date // && (c.DATEFIN >= System.DateTime.Today || c.DATEFIN == null) select new { c.PROFIL.CODE, c.PROFIL.FK_IDFONCTION, c.PROFIL.LIBELLE, c.PK_ID, c.DATEDEBUT, c.DATEFIN, CODEFONCTION = c.PROFIL.FONCTION.CODE, c.PROFIL.FONCTION.ROLENAME, MODULE = a.MODULE.CODE, c.FK_IDPROFIL, c.FK_IDADMUTILISATEUR }; return(Galatee.Tools.Utility.ListToDataTable(query)); } } catch (Exception ex) { throw ex; } }
public static decimal?RetourneSoldeInitialDocumentCampagne(string centre, string client, string ordre, string ndoc, string campagne) { using (galadbEntities context = new galadbEntities()) { decimal?sommeDebit = null; decimal?sommeCredit = null; var _lclientDebiteur = context.LCLIENT.Where(cl => cl.CENTRE == centre && cl.CLIENT == client && cl.ORDRE == ordre && cl.NDOC == ndoc && cl.DC == Enumere.Debit && cl.IDCOUPURE == campagne); if (_lclientDebiteur != null && _lclientDebiteur.Count() > 0) { sommeDebit = _lclientDebiteur.Sum(cl => cl.MONTANT); } else { sommeDebit = 0; } var _lclientCrediteur = context.LCLIENT.Where(cl => cl.CENTRE == centre && cl.CLIENT == client && cl.ORDRE == ordre && cl.NDOC == ndoc && cl.DC == Enumere.Credit && cl.IDCOUPURE == campagne); if (_lclientCrediteur != null && _lclientCrediteur.Count() > 0) { sommeCredit = _lclientCrediteur.Sum(cl => cl.MONTANT); } else { sommeCredit = 0; } sommeDebit = sommeDebit == null ? 0 : sommeDebit; sommeCredit = sommeCredit == null ? 0 : sommeCredit; decimal?difference = (sommeDebit - sommeCredit); return((difference < 0) ? 0 : difference); } }
public static DataTable GetCentreAffectation(int pIdUSer) { try { using (galadbEntities context = new galadbEntities()) { var CentreAffectation = context.CENTREAFFECTATION; IEnumerable <object> query = from c in CentreAffectation where c.FK_IDADMUTILISATEUR == pIdUSer select new { c.PK_ID, c.FK_IDCENTRE, c.FK_IDADMUTILISATEUR, c.DATEFINVALIDITE, c.DATEDEBUTVALIDITE }; return(Galatee.Tools.Utility.ListToDataTable(query)); } } catch (Exception ex) { throw ex; } }
public static DataTable ListeMenuParHabilitationProfil(string module) { try { using (galadbEntities context = new galadbEntities()) { var admMenu = context.ADMMENU; var Program = context.MODULE; IEnumerable <object> query = from _admMenu in admMenu join _Program in Program on _admMenu.MODULE.ToLower() equals _Program.CODE.ToLower() where _admMenu.MODULE.ToUpper() == module.ToUpper() select new { Module = _admMenu.MODULE, MenuID = _admMenu.PK_ID, //PK_MENUID, MenuText = _admMenu.MENUTEXT, MainMenuID = _admMenu.MAINMENUID, FormName = _admMenu.FORMENAME, IsDock = _admMenu.ISDOCK, IsControl = _admMenu.ISCONTROLE, IdGroupProgram = _Program.FK_IDGROUPPROGRAM, MenuOrder = _admMenu.MENUORDER, }; return(Galatee.Tools.Utility.ListToDataTable(query)); } } catch (Exception ex) { throw ex; } }
public static DataTable GetCentreDesProfilsUserByLoginName(int pIdUSer, int pIdrofil) { try { using (galadbEntities context = new galadbEntities()) { var Centreuser = context.CENTREDUPROFIL; IEnumerable <object> query = from c in Centreuser where c.FK_IDADMUTILISATEUR == pIdUSer && c.FK_IDPROFIL == pIdrofil && c.DATEFINVALIDITE == null select new { c.PK_ID, c.FK_IDADMUTILISATEUR, c.FK_IDPROFIL, c.FK_IDCENTRE, c.DATEDEBUTVALIDITE, c.DATEFINVALIDITE, FK_IDSITE = c.CENTRE1.SITE.PK_ID }; return(Galatee.Tools.Utility.ListToDataTable(query)); } } catch (Exception ex) { throw ex; } }
public static bool MAJImportColonne(Galatee.Structure.aImportFichierColonne lacolonne) { try { using (galadbEntities context = new galadbEntities()) { IMPORTCOLONNE colon = context.IMPORTCOLONNE.FirstOrDefault(c => c.ID_COLONNE == lacolonne.ID_COLONNE); if (colon != null) { IMPORTCOLONNE _lacolonne = Entities.ConvertObject <IMPORTCOLONNE, Galatee.Structure.aImportFichierColonne>(lacolonne); return(Entities.UpdateEntity <IMPORTCOLONNE>(_lacolonne)); } else { IMPORTCOLONNE _lacolonne = Entities.ConvertObject <IMPORTCOLONNE, Galatee.Structure.aImportFichierColonne>(lacolonne); return(Entities.InsertEntity <IMPORTCOLONNE>(_lacolonne)); } };; } catch (Exception ex) { throw ex; } }
public static bool RemoveInsertEntity <T>(List <T> pEntity) where T : class { try { using (galadbEntities context = new galadbEntities()) { foreach (T _entity in pEntity) // suppression des habilitation dans la base { if (context.Entry(_entity).State == EntityState.Detached) { context.Set <T>().Attach(_entity); context.Set <T>().Remove(_entity); } } context.SaveChanges(); foreach (T _entity in pEntity) // suppression des habilitation dans la base { if (context.Entry(_entity).State == EntityState.Detached) { context.Set <T>().Attach(_entity); context.Set <T>().Remove(_entity); } } context.SaveChanges(); return(true); } } catch (Exception ex) { throw ex; } }
public static DataTable ListeDesClientPourEnvoieMailDiffusion(int pidCentre, int pidSite, int pidCategorie, int pidTourne, bool sms, bool email) { try { using (galadbEntities context = new galadbEntities()) { var _Ag = context.AG; var query = ( from t in _Ag from x in t.CLIENT1 from br in t.BRT where (t.FK_IDTOURNEE == pidTourne || pidTourne == 0) && (x.FK_IDCENTRE == pidCentre || pidCentre == 0) && (x.CENTRE1.SITE.PK_ID == pidSite || pidSite == 0) && (x.FK_IDCATEGORIE == pidCategorie || pidCategorie == 0) && (x.EMAIL != null || x.TELEPHONE != null) select new { x.CENTRE, client = x.REFCLIENT, numfact = "", periode = "", x.ORDRE, NomClient = x.NOMABON, x.EMAIL , x.ISFACTUREEMAIL, x.ISFACTURESMS, x.TELEPHONE }); var lst = query.ToList(); if (!sms && !email && query != null) { query = (from x in query where x.ISFACTUREEMAIL.Value || x.ISFACTURESMS.Value select x); } else if (sms && query != null) { query = (from x in query where x.ISFACTURESMS.Value select x); } else if (email && query != null) { query = (from x in query where x.ISFACTUREEMAIL.Value select x); } return(Galatee.Tools.Utility.ListToDataTable(query.ToList())); } } catch (Exception ex) { throw ex; } }
private static DataTable RetournReglementByCrytere(int IdCentre, List <int> lstIdcaisse, List <string> OperationSelect, DateTime?DateCaisseDebut, DateTime?DateCaisseFin, DateTime?Date) { using (galadbEntities context = new galadbEntities()) { IEnumerable <object> query; query = ReglementByCrytere(IdCentre, lstIdcaisse, OperationSelect, DateCaisseDebut, DateCaisseFin, Date, context); return(Galatee.Tools.Utility.ListToDataTable(query)); } }
public static DataTable GetUserByLoginName(string pLogin) { try { using (galadbEntities context = new galadbEntities()) { var AdmUtilisateur = context.ADMUTILISATEUR; IEnumerable <object> query = from admUtilisateur in AdmUtilisateur where admUtilisateur.LOGINNAME.ToUpper() == pLogin.ToUpper() select new { CENTRE = admUtilisateur.CENTRE, admUtilisateur.MATRICULE, admUtilisateur.LIBELLE, admUtilisateur.PASSE, admUtilisateur.DMAJ, admUtilisateur.TRANS, admUtilisateur.LOGINNAME, admUtilisateur.E_MAIL, admUtilisateur.DATEDERNIEREMODIFICATION, admUtilisateur.DATEDEBUTVALIDITE, admUtilisateur.DATEFINVALIDITE, admUtilisateur.STATUSCOMPTE, admUtilisateur.DATEDERNIEREMODIFICATIONPASSWORD, admUtilisateur.INITUSERPASSWORD, admUtilisateur.NOMBREECHECSOUVERTURESESSION, admUtilisateur.DATEDERNIERECONNEXION, admUtilisateur.DERNIERECONNEXIONREUSSIE, admUtilisateur.DATEDERNIERVERROUILLAGE, admUtilisateur.BRANCHE, admUtilisateur.PERIMETREACTION, admUtilisateur.ESTSUPPRIMER, admUtilisateur.USERCREATION, admUtilisateur.DATEMODIFICATION, admUtilisateur.USERMODIFICATION, admUtilisateur.DATECREATION, ////admUtilisateur.FK_IDFONCTION, admUtilisateur.FK_IDCENTRE, FK_IDANCIENCENTRE = admUtilisateur.FK_IDCENTRE, PK_ID = admUtilisateur.PK_ID, admUtilisateur.FK_IDSTATUS, admUtilisateur.COMPTEWINDOW, NOM = admUtilisateur.LIBELLE, admUtilisateur.TELEPHONE, LIBELLESTATUSCOMPTE = admUtilisateur.ADMSTATUSCOMPTE.LIBELLE, LIBELLECENTRE = admUtilisateur.CENTRE1.LIBELLE, ////LIBELLEFONCTION = admUtilisateur.FONCTION1.ROLENAME, }; return(Galatee.Tools.Utility.ListToDataTable(query)); } } catch (Exception ex) { throw ex; } }
public static decimal?RetourneSoldeClientDate(int?Pk_Id, DateTime?date) { try { using (galadbEntities context = new galadbEntities()) { string centre = string.Empty; string client = string.Empty; string ordre = string.Empty; decimal?sommeDebit = null; decimal?sommeCredit = null; decimal?paiement = null; List <LCLIENT> _lclientDebiteur = context.LCLIENT.Where(cl => cl.FK_IDCLIENT == Pk_Id && cl.DC == Enumere.Debit && cl.DENR <= date && cl.TOP1 != "2").ToList(); if (_lclientDebiteur != null) { centre = _lclientDebiteur[0].CENTRE; client = _lclientDebiteur[0].CLIENT; ordre = _lclientDebiteur[0].ORDRE; sommeDebit = _lclientDebiteur.GroupBy(cl => new { cl.FK_IDCLIENT, cl.DC }).Select(cl => cl.Sum(x => x.MONTANT).Value).FirstOrDefault(); } else { sommeDebit = 0; } IEnumerable <LCLIENT> _lclientCrediteur = context.LCLIENT.Where(cl => cl.FK_IDCLIENT == Pk_Id && cl.DC == Enumere.Credit && cl.DENR <= date && cl.TOP1 != "2"); if (_lclientCrediteur != null) { sommeCredit = _lclientDebiteur.GroupBy(cl => new { cl.FK_IDCLIENT, cl.DC }).Select(cl => cl.Sum(x => x.MONTANT).Value).FirstOrDefault(); } else { sommeCredit = 0; } IEnumerable <TRANSCAISB> _paiementLclient = context.TRANSCAISB.Where(cl => cl.CLIENT == centre && cl.CLIENT == client && cl.ORDRE == ordre && cl.TOPANNUL == null && cl.DTRANS <= date); if (_paiementLclient != null) { paiement = _paiementLclient.GroupBy(p => new { p.CENTRE, p.CLIENT, p.ORDRE }).Select(p => p.Sum(x => (Char.Parse(x.DC) - 'D') * x.MONTANT - ('C' - Char.Parse(x.DC)) * x.MONTANT) + p.Sum(x => (Char.Parse(x.DC) - 'D') * x.ECART - ('C' - Char.Parse(x.DC)) * x.ECART)).FirstOrDefault(); } else { paiement = 0; } return(sommeDebit - sommeCredit - paiement); } } catch (Exception ex) { throw ex; } }
public static int RetourneEtatCaisse(string matricule, int?Fk_IdCaisse) { try { using (galadbEntities context = new galadbEntities()) { var clientT = context.TRANSCAISSE.Where(c => c.MATRICULE == matricule && c.DTRANS < DateTime.Today.Date && c.SAISIPAR == null && c.COPER != Enumere.CoperAjsutemenFondCaisse && c.COPER != Enumere.CoperFondCaisse); if (clientT != null && clientT.Count() > 0) { if (!string.IsNullOrEmpty(clientT.First().CLIENT)) { return(3); } } var HabilCaisse = context.HABILITATIONCAISSE.Where(c => c.MATRICULE == matricule && c.DATE_DEBUT < DateTime.Today.Date && c.DATE_FIN == null); if (HabilCaisse != null && HabilCaisse.Count() > 0) { return(3); } /* CAISSE DEJA ARRETE*/ //IEnumerable<TRANSCAISB> clientB = context.TRANSCAISB.Where(c => c.MATRICULE == matricule && c.HABILITATIONCAISSE.FK_IDCAISSE == Fk_IdCaisse && c.DTRANS == DateTime.Today && c.SAISIPAR == null && c.FK_IDHABILITATIONCAISSE != null); //c'etait fait pour gerer la mobilité de caisse donc on verifie la caisse du centre mais a cause des problem au demarage je commente 01/10/2016 IEnumerable <TRANSCAISB> clientB = context.TRANSCAISB.Where(c => c.MATRICULE == matricule && c.DTRANS == DateTime.Today.Date && c.SAISIPAR == null && c.FK_IDHABILITATIONCAISSE != null); if (clientB != null && clientB.Count() > 0) { if (!string.IsNullOrEmpty(clientB.First().CLIENT)) { return(2); } } /*Caisse ouverte a la demande*/ var clientO = context.OPENINGDAY.Where(c => c.KEYEDBY == matricule && c.OPEN == Enumere.CaisseStatOuverte); if (clientO != null && clientO.Count() > 0) { if (!string.IsNullOrEmpty(clientO.First().KEYEDBY)) { return(4); } } /*journée précédente non arretée*/ } return(0); } catch (Exception ex) { throw ex; } }
public static DataTable RetourneListeReclamation() { //cmd.CommandText = "SPX_GUI_RETOURNE_DABON"; try { using (galadbEntities context = new galadbEntities()) { IEnumerable <object> query = null; var _RCL_Reclamation = context.RCL_Reclamation; query = from p in _RCL_Reclamation select new { p.PK_ID, p.Ordre, p.NumeroReclamation, p.Fk_IdTypeReclamation, p.NomClient, p.Fk_IdClient, p.DateOuverture, p.DateTransmission, p.AgentEmetteur, p.AgentRecepteur, p.AgentValidation, p.DateRdv, p.DateRetourSouhaite, p.DateRetour, p.Observation, p.Fk_IdModeReception, p.Adresse, p.Email, p.NumeroTelephonePortable, p.NumeroTelephoneFixe, p.ObjetReclamation, p.ActionMenees, p.Fk_IdStatutReclamation, p.MotifReprise, p.NonConformite, p.LettreReponse, p.DateValidation, p.MotifRejet, p.Fk_IdCentre, }; return(Galatee.Tools.Utility.ListToDataTable(query)); } } catch (Exception ex) { throw ex; } }
public void Delete(Guid IdStrategieSecurite) { //SqlCommand cmd = new SqlCommand("spx_AdmStrategieSecurite_Delete", cn); try { Galatee.Entity.Model.ADMSTRATEGIESECURITE entity = new Galatee.Entity.Model.galadbEntities().ADMSTRATEGIESECURITE.Where(pk => pk.PK_ID == IdStrategieSecurite).FirstOrDefault(); Entities.DeleteEntity <Galatee.Entity.Model.ADMSTRATEGIESECURITE>(entity); } catch (Exception e) { throw e; } }
public static List <CsCompteSpecifique> RetourneCompteSpecifique() { try { using (galadbEntities Context = new galadbEntities()) { #region Récupe données à Manipuler depuis la BD var COMPTE_SPECIFIQUE = Context.COMPTA_COMPTE_SPECIFIQUE; #endregion #region Convertion des type de facture comptable en structure List <CsCompteSpecifique> ListeCompteSpecifique = Entities.ConvertObject <CsCompteSpecifique, COMPTA_COMPTE_SPECIFIQUE>(COMPTE_SPECIFIQUE != null ? COMPTE_SPECIFIQUE.ToList() : new List <COMPTA_COMPTE_SPECIFIQUE>()); #endregion foreach (CsCompteSpecifique item in ListeCompteSpecifique) { if (!string.IsNullOrEmpty(item.VALEURFILTRE)) { item.LSTVALEURFILTRE = new List <string>(); string[] valeur = item.VALEURFILTRE.Split(';'); foreach (var items in valeur) { item.LSTVALEURFILTRE.Add(items); } } if (!string.IsNullOrEmpty(item.VALEURFILTRE1)) { item.LSTVALEURFILTRE1 = new List <string>(); string[] valeur = item.VALEURFILTRE1.Split(';'); foreach (var items in valeur) { item.LSTVALEURFILTRE1.Add(items); } } if (!string.IsNullOrEmpty(item.VALEURFILTRE2)) { item.LSTVALEURFILTRE2 = new List <string>(); string[] valeur = item.VALEURFILTRE2.Split(';'); foreach (var items in valeur) { item.LSTVALEURFILTRE2.Add(items); } } } return(ListeCompteSpecifique); } } catch (Exception) { throw; } }
public static List <CsTypeFactureComptable> RetourneTypeFacture() { try { using (galadbEntities Context = new galadbEntities()) { //#region Récupe données à Manipuler depuis la BD //var TYPE_FACTURE_COMPTABILISE = Context.TYPE_FACTURE_COMPTABILISE; //var COPERS = Context.COPER_TYPE_FACTURE_COMPTABILISE; //var TYPE_COMPTE_TYPE_FACTURE_COMPTABLE = Context.TYPE_COMPTE_TYPE_FACTURE_COMPTABLE; //#endregion //#region Convertion des type de facture comptable en structure //List<CsTypeFactureComptable> ListeTypeFacture = Entities.ConvertObject<CsTypeFactureComptable, TYPE_FACTURE_COMPTABILISE>(TYPE_FACTURE_COMPTABILISE != null ? TYPE_FACTURE_COMPTABILISE.ToList() : new List<TYPE_FACTURE_COMPTABILISE>()); //#endregion //#region Récupérartion des des code opération(COPER) lié à chaque Type de facture comptable //foreach (var item in ListeTypeFacture) //{ // var LISTCOPER = COPERS.Where(c => c.FK_IDTYPE_FACTUE_COMPTABILISER == item.PK_ID); // item.LISTCOPER = LISTCOPER != null ? LISTCOPER.Select(c => c.COPER.CODE).ToList() : new List<string>(); // //item.DC = TYPE_COMPTE_TYPE_FACTURE_COMPTABLE.FirstOrDefault(c => c.FK_IDTYPE_COMPTE == item.PK_ID).DC;f //} //#endregion //#region Récupérartion des comptes (COPER) et des Type de compte(en indiquant la direction:debit ou credit) lié à chaque Type de facture comptable //foreach (var item in ListeTypeFacture) //{ // //Récupérartion des comptes (COPER) // var LISTCOPER = COPERS.Where(c => c.FK_IDTYPE_FACTUE_COMPTABILISER == item.PK_ID); // item.LISTCOPER = LISTCOPER != null ? LISTCOPER.Select(c => c.COPER.CODE).ToList() : new List<string>(); // //Récupérartion des Type de compte(en indiquant la direction:debit ou credit) // var LISTTYPECOMPTE = TYPE_COMPTE_TYPE_FACTURE_COMPTABLE.Where(c => c.FK_IDTYPE_FACTUE_COMPTABILISER == item.PK_ID); // item.LISTTYPECOMPTE = LISTTYPECOMPTE != null ? Entities.ConvertObject<CsTypeCompte, TYPE_COMPTE>(LISTTYPECOMPTE.Select(c => c.TYPE_COMPTE).ToList()) : new List<CsTypeCompte>(); // //En indiquant la direction:debit ou credit // item.LISTTYPECOMPTE.ForEach(t => t.DC = LISTTYPECOMPTE.FirstOrDefault(c => c.FK_IDTYPE_FACTUE_COMPTABILISER == item.PK_ID && c.FK_IDTYPE_COMPTE == c.PK_ID).DC); //} //#endregion //return ListeTypeFacture; return(null); } } catch (Exception ex) { return(null); } }
public static List <PARAMETRAGEIMPORT> RetourneAllImportFichier() { try { using (galadbEntities context = new galadbEntities()) { return(context.PARAMETRAGEIMPORT.ToList()); }; } catch (Exception ex) { throw ex; } }
public static DataTable SelectHabilitationByUser(int pIduser) { try { using (galadbEntities context = new galadbEntities()) { List <PROFILSUTILISATEUR> profiluser = context.PROFILSUTILISATEUR.Where(t => t.FK_IDADMUTILISATEUR == pIduser && t.DATEFIN == null).ToList(); IEnumerable <object> query = (from _profiluser in profiluser from _menuPro in _profiluser.PROFIL.FONCTION.MODULESDEFONCTION select new { FK_IDPROFIL = _profiluser.PROFIL.PK_ID, FK_CODEFONCTION = _profiluser.PROFIL.FONCTION.PK_ID, FK_IDMODULE = _menuPro.FK_IDMODULE, FK_IDGROUPPROGRAM = _menuPro.MODULE.FK_IDGROUPPROGRAM, ProgramName = _menuPro.MODULE.LIBELLE, ModuleName = _menuPro.MODULE.LIBELLE, Code = _menuPro.MODULE.CODE, //PK_ID = _menuPro.ADMMENU.PK_ID, //FK_IDMENU = _menuPro.ADMMENU.PK_ID, }).Distinct(); //IEnumerable<object> query = //(from _profiluser in profiluser //from _menuPro in context.MENUSDUPROFIL //select new //{ // FK_CODEFONCTION = _profiluser.PROFIL.FONCTION.PK_ID , // FK_IDMODULE = _menuPro.ADMMENU.MODULE1.PK_ID, // FK_IDGROUPPROGRAM = _menuPro.ADMMENU.MODULE1.GROUPPROGRAM.PK_ID, // ProgramName = _menuPro.ADMMENU.MODULE1.LIBELLE, // ModuleName = _menuPro.ADMMENU.MODULE1.LIBELLE, // Code = _menuPro.ADMMENU.MODULE1.CODE, // //PK_ID = _menuPro.ADMMENU.PK_ID, // //FK_IDMENU = _menuPro.ADMMENU.PK_ID, //}).Distinct(); return(Galatee.Tools.Utility.ListToDataTable(query.Distinct())); } } catch (Exception ex) { throw ex; } }