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 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 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 bool InsertionLigneComptable(List <CsEcritureComptable> LigneComptable) { try { List <COMPTA_ECRITURECOMPTABLE> ECRITURE_COMPTABLE = new List <COMPTA_ECRITURECOMPTABLE>(); using (galadbEntities Context = new galadbEntities()) { LigneComptable.ForEach(u => u.CREDIT1 = u.CREDIT); LigneComptable.ForEach(u => u.DEBIT1 = u.DEBIT); ECRITURE_COMPTABLE.AddRange(Entities.ConvertObject <COMPTA_ECRITURECOMPTABLE, CsEcritureComptable>(LigneComptable)); Entities.InsertEntity <COMPTA_ECRITURECOMPTABLE>(ECRITURE_COMPTABLE, Context); return(Context.SaveChanges() > 0 ? true : false); } } catch (Exception ex) { throw ex; } }
public static bool InsertEntity <T>(T entity) where T : class { try { using (galadbEntities context = new galadbEntities()) { if (context.Entry(entity).State == EntityState.Detached) { context.Set <T>().Add(entity); context.SaveChanges(); return(true); } } return(false); } catch (Exception ex) { throw ex; } }
public static bool DeleteEntity <T>(List <T> pEntity) where T : class { try { using (galadbEntities context = new galadbEntities()) { foreach (T _entity in pEntity) { 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 bool DeleteImportFichierColonne(int CodeColonne) { try { using (galadbEntities context = new galadbEntities()) { IMPORTCOLONNE colonne = context.IMPORTCOLONNE.FirstOrDefault(c => c.ID_COLONNE == CodeColonne); if (colonne != null) { context.IMPORTCOLONNE.Remove(colonne); context.SaveChanges(); return(true); } else { return(false); } }; } catch (Exception ex) { throw ex; } }