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;
}
}
