public bool UpdateDetailCampagneSuiteRelance(List <CsDetailCampagne> lstDetCampagne)
{
try
{
int res = -1;
using (galadbEntities ctx = new galadbEntities())
{
foreach (CsDetailCampagne item in lstDetCampagne)
{
List <DETAILCAMPAGNE> lesDet = ctx.DETAILCAMPAGNE.Where(t => t.FK_IDCLIENT == item.FK_IDCLIENT && item.IDCOUPURE == t.IDCOUPURE).ToList();
if (lesDet.Count != 0)
{
if (lesDet.First().RELANCE != null)
{
lesDet.ForEach(t => t.RELANCE = t.RELANCE + 1);
}
else
{
lesDet.ForEach(t => t.RELANCE = 1);
}
}
}
res = ctx.SaveChanges();
}
return(res == -1 ? false : true);
}
catch (Exception)
{
throw;
}
}
public static DataTable RetournerCoodonnesAbonne(string IDCOUPURE)
{
try
{
using (galadbEntities context = new galadbEntities())
{
var AG = context.AG;
var camp = context.DETAILCAMPAGNE;
IEnumerable <object> localisations =
from a in AG
from b in a.BRT
from cl in a.CLIENT1
join d in camp on cl.PK_ID equals d.FK_IDCLIENT
where
d.IDCOUPURE == IDCOUPURE
select new
{
Centre = b.CENTRE,
Latitude = b.LATITUDE,
Longitude = b.LONGITUDE,
NomAbonne = cl.NOMABON,
NumeroClient = b.CLIENT,
Telephone = cl.TELEPHONE
};
return(Galatee.Tools.Utility.ListToDataTable(localisations));
}
}
catch (Exception ex)
{
throw ex;
}
}
/* En stand by */
public static DataTable RetournerCoodonnesAbonne(CsClientRechercher client)
{
try
{
using (galadbEntities context = new galadbEntities())
{
var Ag = context.AG;
IEnumerable <object> localisations =
from a in Ag
from c in a.CLIENT1
from b in a.BRT
where
a.CLIENT == client.CLIENT && a.CENTRE == client.CENTRE
select new
{
Centre = b.CENTRE,
Latitude = b.LATITUDE,
Longitude = b.LONGITUDE,
NomAbonne = c.NOMABON,
NumeroClient = b.CLIENT,
Telephone = c.TELEPHONE
};
return(Galatee.Tools.Utility.ListToDataTable(localisations));
}
}
catch (Exception ex)
{
throw ex;
}
}
public void DeleteMenuDuProfilByIdProfil(int idprofil)
{
//SqlCommand cmd = new SqlCommand("spx_AdmStrategieSecurite_Delete", cn);
try
{
List <Galatee.Entity.Model.MENUSDUPROFIL> lst_entity = new List <MENUSDUPROFIL>();
using (Galatee.Entity.Model.galadbEntities context = new galadbEntities())
{
lst_entity = context.MENUSDUPROFIL.Where(pk => pk.FK_IDPROFIL == idprofil).ToList();
}
foreach (var entity in lst_entity)
{
if (entity.PK_ID != 0)
{
Entities.DeleteEntity <Galatee.Entity.Model.MENUSDUPROFIL>(entity);
}
}
}
catch (Exception e)
{
throw e;
}
}
public List <CsDetailCampagne> PreavisSgc(CsCampagneGc lesCampagnes)
{
try
{
using (galadbEntities context = new galadbEntities())
{
var query = (
from camp in context.DETAILCAMPAGNESGC
where
camp.IDCAMPAGNEGC == lesCampagnes.PK_ID
orderby camp.FK_IDCLIENT
select new
{
camp.CLIENT,
camp.CENTRE,
camp.ORDRE,
camp.CLIENT1.NOMABON,
camp.FK_IDCLIENT,
MONTANTFRAIS = camp.MONTANT,
});
var dt = Galatee.Tools.Utility.ListToDataTable <object>(query);
return(Entities.GetEntityListFromQuery <CsDetailCampagne>(dt).Distinct().ToList());
}
}
catch (Exception ex)
{
throw ex;
}
}
public List <CsDetailCampagne> PaiementMandatementSg(CsMandatementGc lesCampagnes)
{
try
{
using (galadbEntities context = new galadbEntities())
{
var query = (
from camp in context.PAIEMENTCAMPAGNEGC
where
camp.FK_IDMANDATEMANT == lesCampagnes.PK_ID
select new
{
camp.MONTANT,
IDCOUPURE = camp.NUMEROMANDATEMENT,
DATEREGLEMENT = camp.DATECREATION
});
var dt = Galatee.Tools.Utility.ListToDataTable <object>(query);
return(Entities.GetEntityListFromQuery <CsDetailCampagne>(dt).Distinct().ToList());
}
}
catch (Exception ex)
{
throw ex;
}
}
public bool ValiderReclamation(CsDemandeReclamation LaDemande)
{
try
{
string DemandeID = string.Empty;
int resultTransaction = -1;
using (galadbEntities transaction = new galadbEntities())
{
try
{
ReclamationProcedure.ValiderReclamation(LaDemande, transaction);
resultTransaction = transaction.SaveChanges();
return(resultTransaction == -1 ? false : true);
}
catch (Exception ex)
{
throw ex;
}
};
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public List <CsDetailCampagne> RechercherSuiviCampagne(List <CsCAMPAGNE> lesCampagnes)
{
try
{
using (galadbEntities context = new galadbEntities())
{
List <string> lesIdCampagne = new List <string>();
foreach (var item in lesCampagnes)
{
lesIdCampagne.Add(item.IDCOUPURE);
}
var query = (
from camp in context.CAMPAGNE
from det in camp.DETAILCAMPAGNE
where
(lesIdCampagne.Contains(det.IDCOUPURE))
orderby det.IDCOUPURE, det.CENTRE, det.CLIENT, det.ORDRE
select new CsDetailCampagne
{
LIBELLECENTRE = det.CENTRE1.LIBELLE,
CENTRE = det.CENTRE,
CLIENT = det.CLIENT,
ORDRE = det.ORDRE,
NOMABON = det.CLIENT1.NOMABON,
ORDTOUR = det.ORDTOUR,
TOURNEE = det.TOURNEE,
RUE = det.CLIENT1.AG.RUE,
QUARTIER = det.CLIENT1.AG.QUARTIER1.LIBELLE,
COMPTEUR = det.COMPTEUR,
NOMAGENT = context.ADMUTILISATEUR.FirstOrDefault(t => t.MATRICULE == camp.MATRICULEPIA) != null ? context.ADMUTILISATEUR.FirstOrDefault(t => t.MATRICULE == camp.MATRICULEPIA).LIBELLE : string.Empty,
DEBUTORDTOURNEE = camp.DEBUT_ORDTOUR,
FINORDTOURNEE = camp.FIN_ORDTOUR,
DEBUTTOURNEE = camp.PREMIERE_TOURNEE,
FINTOURNEE = camp.DERNIERE_TOURNEE,
FK_IDCLIENT = det.FK_IDCLIENT,
IDCOUPURE = det.IDCOUPURE,
ISANNULATIONFRAIS = det.ISANNULATIONFRAIS,
ISAUTORISER = det.ISAUTORISER,
MOTIFANNULATION = det.MOTIFANNULATION,
MOTIFAUTORISATION = det.MOTIFAUTORISATION,
NOMBREFACTURE = det.NOMBREFACTURE,
SOLDEDUE = det.SOLDEDUE,
DATERDV = det.DATERDV.Value
}).Distinct();
List <CsDetailCampagne> Liste1 = new List <CsDetailCampagne>();
if (query != null)
{
Liste1 = query.ToList();
}
return(query.ToList());
}
}
catch (Exception ex)
{
throw ex;
}
}
public List <CsDetailCampagne> FraisCampagnePayer(List <CsCAMPAGNE> lesCampagnes)
{
try
{
using (galadbEntities context = new galadbEntities())
{
List <string> lesIdCampagne = new List <string>();
foreach (var item in lesCampagnes)
{
lesIdCampagne.Add(item.IDCOUPURE);
}
var query = (
from camp in context.LCLIENT
from trans in camp.TRANSCAISB
where
(lesIdCampagne.Contains(camp.IDCOUPURE)) && camp.COPER == Enumere.CoperFRP &&
string.IsNullOrEmpty(trans.TOPANNUL) && trans.NDOC != "TIMBRE"
select new CsDetailCampagne
{
FK_IDCLIENT = camp.FK_IDCLIENT,
MONTANTFRAIS = camp.MONTANT,
DATEREGLEMENT = trans.DTRANS,
IDCOUPURE = camp.IDCOUPURE,
});
List <CsDetailCampagne> Liste1 = new List <CsDetailCampagne>();
if (query != null)
{
Liste1 = query.ToList();
}
var query1 = (
from camp in context.LCLIENT
from trans in camp.TRANSCAISSE
where
(lesIdCampagne.Contains(camp.IDCOUPURE)) && camp.COPER == Enumere.CoperFRP &&
string.IsNullOrEmpty(trans.TOPANNUL) && trans.NDOC != "TIMBRE"
select new CsDetailCampagne
{
FK_IDCLIENT = camp.FK_IDCLIENT,
MONTANTFRAIS = camp.MONTANT,
DATEREGLEMENT = trans.DTRANS,
IDCOUPURE = camp.IDCOUPURE
});
List <CsDetailCampagne> Liste2 = new List <CsDetailCampagne>();
if (query != null)
{
Liste2 = query.ToList();
}
return(query.Union(query1).ToList());
}
}
catch (Exception ex)
{
throw ex;
}
}
public List <CsDetailCampagne> RetourneDetailCampagne(List <CsCAMPAGNE> lesCampagnes)
{
try
{
using (galadbEntities context = new galadbEntities())
{
List <string> lstIdCampagne = new List <string>();
lstIdCampagne.AddRange(lesCampagnes.Select(t => t.IDCOUPURE));
var query = (
from cl in context.DETAILCAMPAGNE
where
lstIdCampagne.Contains(cl.IDCOUPURE)
select new
{
cl.IDCOUPURE,
cl.CENTRE,
cl.CLIENT,
cl.ORDRE,
cl.COPER,
cl.MONTANT,
cl.EXIGIBILITE,
cl.TOURNEE,
cl.ORDTOUR,
cl.CATEGORIECLIENT,
cl.SOLDEDUE,
cl.NOMBREFACTURE,
cl.SOLDECLIENT,
cl.COMPTEUR,
cl.ISAUTORISER,
cl.MOTIFAUTORISATION,
NOMABON = cl.CLIENT1.NOMABON,
cl.FRAIS,
cl.ISANNULATIONFRAIS,
cl.MOTIFANNULATION,
cl.DATERDV,
cl.USERCREATION,
cl.USERMODIFICATION,
cl.FK_IDLCLIENT,
cl.FK_IDCENTRE,
cl.FK_IDCLIENT,
cl.FK_IDTOURNEE,
cl.FK_IDCATEGORIECLIENT,
cl.FK_IDCAMPAGNE,
cl.RELANCE,
cl.FK_IDTYPECOUPURE
}).Distinct();
var dt = Galatee.Tools.Utility.ListToDataTable <object>(query);
return(Entities.GetEntityListFromQuery <CsDetailCampagne>(dt));
}
}
catch (Exception)
{
throw;
}
}
public List <CsDetailCampagne> PaiementCampagneSgc(CsCampagneGc lesCampagnes)
{
try
{
using (galadbEntities context = new galadbEntities())
{
var query = (
from camp in context.DETAILCAMPAGNESGC
join y in context.TRANSCAISSE on camp.FK_IDLCLIENT equals y.FK_IDLCLIENT
where
camp.IDCAMPAGNEGC == lesCampagnes.PK_ID &&
//y.DTRANS >= lesCampagnes.DATECREATION &&
string.IsNullOrEmpty(y.TOPANNUL) &&
y.NDOC != "TIMBRE"
orderby camp.FK_IDCLIENT
select new
{
camp.CLIENT,
camp.CENTRE,
camp.ORDRE,
camp.CLIENT1.NOMABON,
camp.FK_IDCLIENT,
MONTANTFRAIS = camp.MONTANT,
MONTANTEREGLE = y.MONTANT,
camp.PK_ID
});
var query1 = (
from camp in context.DETAILCAMPAGNESGC
join y in context.TRANSCAISSE on camp.FK_IDLCLIENT equals y.FK_IDLCLIENT
where
camp.IDCAMPAGNEGC == lesCampagnes.PK_ID &&
y.DTRANS >= lesCampagnes.DATECREATION &&
string.IsNullOrEmpty(y.TOPANNUL) &&
y.NDOC != "TIMBRE"
orderby camp.FK_IDCLIENT
select new
{
camp.CLIENT,
camp.CENTRE,
camp.ORDRE,
camp.CLIENT1.NOMABON,
camp.FK_IDCLIENT,
MONTANTFRAIS = camp.MONTANT,
MONTANTEREGLE = y.MONTANT,
camp.PK_ID
});
var dt = Galatee.Tools.Utility.ListToDataTable <object>(query.Union(query1));
return(Entities.GetEntityListFromQuery <CsDetailCampagne>(dt).Distinct().ToList());
}
}
catch (Exception ex)
{
throw ex;
}
}
public bool Update(CsCentre pCentre)
{
try
{
//return Entities.UpdateEntity<Galatee.Entity.Model.CENTRE>(Entities.ConvertObject<Galatee.Entity.Model.CENTRE, CsCentre>(pCentre));
List <int> lstIdCentreInit = new List <int>();
List <int> lstIdProduitAnc = new List <int>();
List <int> lstIdProduitNouv = new List <int>();
List <int> lstIdProduitAJouter = new List <int>();
List <int> lstIdProduitSupprimer = new List <int>();
List <int> lstIdProduitNonModifier = new List <int>();
List <CsProduit> lstProduitAsupp = new List <CsProduit>();
List <CsProduit> lstProduitAjout = new List <CsProduit>();
List <CsProduit> lstProduitCentre = Entities.GetEntityListFromQuery <CsProduit>(ParamProcedure.PARAM_PRODUIT_CENTRE(pCentre.FK_IDCODESITE));
foreach (CsProduit items in lstProduitCentre)
{
lstIdProduitAnc.Add(items.FK_IDPRODUIT);
}
foreach (CsProduit items in pCentre.LESPRODUITSDUSITE)
{
lstIdProduitNouv.Add(items.FK_IDPRODUIT);
}
lstIdProduitAJouter = lstIdProduitNouv.Where(t => !lstIdProduitAnc.Contains(t)).ToList();
lstProduitAjout = pCentre.LESPRODUITSDUSITE.Where(t => lstIdProduitAJouter.Contains(t.FK_IDPRODUIT)).ToList();
// Supprimer
lstIdProduitSupprimer = lstIdProduitAnc.Where(t => !lstIdProduitNouv.Contains(t)).ToList();
lstProduitAsupp = lstProduitCentre.Where(t => lstIdProduitSupprimer.Contains(t.FK_IDPRODUIT)).ToList();
lstProduitAsupp.ForEach(t => t.DATEFIN = System.DateTime.Today);
//
CENTRE leCentre = new CENTRE();
leCentre = Entities.ConvertObject <Galatee.Entity.Model.CENTRE, CsCentre>(pCentre);
leCentre.PRODUITCENTRE = Entities.ConvertObject <Galatee.Entity.Model.PRODUITCENTRE, CsProduit>(pCentre.LESPRODUITSDUSITE);
int result = -1;
using (galadbEntities ctx = new galadbEntities())
{
Entities.UpdateEntity <Galatee.Entity.Model.CENTRE>(leCentre, ctx);
Entities.InsertEntity <Galatee.Entity.Model.PRODUITCENTRE>(Entities.ConvertObject <Galatee.Entity.Model.PRODUITCENTRE, CsProduit>(lstProduitAsupp), ctx);
Entities.InsertEntity <Galatee.Entity.Model.PRODUITCENTRE>(Entities.ConvertObject <Galatee.Entity.Model.PRODUITCENTRE, CsProduit>(lstProduitAjout), ctx);
result = ctx.SaveChanges();
}
return(result == -1 ? false : true);
}
catch (Exception ex)
{
throw ex;
}
}
public List <CsDetailCampagne> RetourneClientAutoriser(List <CsCAMPAGNE> lesCampagnes)
{
try
{
using (galadbEntities context = new galadbEntities())
{
List <string> lstIdCampagne = new List <string>();
foreach (CsCAMPAGNE item in lesCampagnes)
{
lstIdCampagne.Add(item.IDCOUPURE);
}
var query = (
from camp in context.CAMPAGNE
from det in camp.DETAILCAMPAGNE
where
lstIdCampagne.Contains(det.IDCOUPURE) && (det.ISAUTORISER == true || det.ISANNULATIONFRAIS == true)
orderby det.IDCOUPURE, det.CENTRE, det.CLIENT, det.ORDRE
select new CsDetailCampagne
{
LIBELLECENTRE = det.CENTRE1.LIBELLE,
DEBUTORDTOURNEE = camp.DEBUT_ORDTOUR,
FINORDTOURNEE = camp.FIN_ORDTOUR,
DEBUTTOURNEE = camp.PREMIERE_TOURNEE,
FINTOURNEE = camp.DERNIERE_TOURNEE,
ORDTOUR = det.ORDTOUR,
EXIGIBILITE = camp.DATE_EXIGIBILITE.Value,
NOMAGENT = context.ADMUTILISATEUR.FirstOrDefault(t => t.MATRICULE == camp.MATRICULEPIA) != null ? context.ADMUTILISATEUR.FirstOrDefault(t => t.MATRICULE == camp.MATRICULEPIA).LIBELLE : string.Empty,
NOMABON = det.CLIENT1.NOMABON,
CLIENT = det.CLIENT,
CENTRE = det.CENTRE,
ORDRE = det.ORDRE,
TOURNEE = det.TOURNEE,
RUE = det.CLIENT1.AG.RUE,
PORTE = det.CLIENT1.AG.PORTE,
QUARTIER = det.CLIENT1.AG.QUARTIER1.LIBELLE,
SOLDEDUE = det.SOLDEDUE.Value,
NOMBREFACTURE = det.NOMBREFACTURE.Value,
IDCOUPURE = camp.IDCOUPURE,
COMPTEUR = det.COMPTEUR,
FK_IDCLIENT = det.FK_IDCLIENT
}).Distinct();
List <CsDetailCampagne> Liste1 = new List <CsDetailCampagne>();
if (query != null)
{
Liste1 = query.ToList();
}
return(query.ToList());
}
}
catch (Exception ex)
{
throw ex;
}
}
public static bool DeleteDocumentScanne(galadbEntities pCommand, ObjDOCUMENTSCANNE entity)
{
try
{
return(Entities.DeleteEntity <Galatee.Entity.Model.DOCUMENTSCANNE>(Entities.ConvertObject <Galatee.Entity.Model.DOCUMENTSCANNE, ObjDOCUMENTSCANNE>(entity), pCommand));
}
catch (Exception ex)
{
throw ex;
}
}
public static bool InsertDeposit(galadbEntities pCommand, ObjDEPOSIT entity)
{
try
{
return(Entities.InsertEntity <Galatee.Entity.Model.DEPOSIT>(Entities.ConvertObject <Galatee.Entity.Model.DEPOSIT, ObjDEPOSIT>(entity), pCommand));
}
catch (Exception ex)
{
throw ex;
}
}
public static bool UpdateTravaux(galadbEntities command, ObjTRAVAUXDEVIS travaux)
{
try
{
return(Entities.UpdateEntity <Galatee.Entity.Model.TRAVAUXDEVIS>(Entities.ConvertObject <Galatee.Entity.Model.TRAVAUXDEVIS, ObjTRAVAUXDEVIS>(travaux), command));
}
catch (Exception ex)
{
throw ex;
}
}
public static bool DeleteElementsDevis(ObjELEMENTDEVIS entity, galadbEntities pCommand)
{
try
{
return(Entities.UpdateEntity <Galatee.Entity.Model.ELEMENTDEVIS>(Entities.ConvertObject <Galatee.Entity.Model.ELEMENTDEVIS, ObjELEMENTDEVIS>(entity), pCommand));
}
catch (Exception ex)
{
throw ex;
}
}
public static bool Insert(List <ObjAPPAREILSDEVIS> pEntityCollection, galadbEntities pCommand)
{
try
{
return(Entities.InsertEntity <Galatee.Entity.Model.APPAREILSDEVIS>(Entities.ConvertObject <Galatee.Entity.Model.APPAREILSDEVIS, ObjAPPAREILSDEVIS>(pEntityCollection), pCommand));
}
catch (Exception ex)
{
throw ex;
}
}
public static bool DeleteElementsDevis(galadbEntities pCommand, List <ObjELEMENTDEVIS> pListElementDevis)
{
try
{
return(Entities.DeleteEntity <Galatee.Entity.Model.ELEMENTDEVIS>(Entities.ConvertObject <Galatee.Entity.Model.ELEMENTDEVIS, ObjELEMENTDEVIS>(pListElementDevis), pCommand));
}
catch (Exception ex)
{
throw ex;
}
}
public static bool InsertSms(List <CsSms> pEntityCollection, galadbEntities pCommand)
{
try
{
return(Entities.InsertEntity <Galatee.Entity.Model.SMS>(Entities.ConvertObject <Galatee.Entity.Model.SMS, CsSms>(pEntityCollection), pCommand));
}
catch (Exception ex)
{
throw ex;
}
}
public CsDemandeReclamation RetourneLaDemande(int fk_demande)
{
//cmd.CommandText = "SPX_GUI_RETOURNE_DEMANDE";
CsDemandeReclamation _LaDemande = new CsDemandeReclamation();
try
{
galadbEntities transaction = new galadbEntities();
CsReclamationRcl _Reclamation = new CsReclamationRcl();
List <ADMUTILISATEUR> lstUser = transaction.ADMUTILISATEUR.ToList();
DEMANDE _DEMANDE = new DEMANDE();
_LaDemande.LaDemande = Entities.ConvertObject <CsDemandeBase, DEMANDE>(transaction.DEMANDE.FirstOrDefault(p => p.PK_ID == fk_demande));
try
{
DataTable dt = Galatee.Entity.Model.ReclamationProcedure.RetourneListeReclamationbyDemande(fk_demande);
_Reclamation = Entities.GetEntityFromQuery <CsReclamationRcl>(dt);
if (!string.IsNullOrEmpty(_Reclamation.AgentEmetteur))
{
_Reclamation.NOMAGENTCREATION = lstUser.FirstOrDefault(t => t.MATRICULE == _Reclamation.AgentEmetteur) != null?
lstUser.FirstOrDefault(t => t.MATRICULE == _Reclamation.AgentEmetteur).LIBELLE : string.Empty;
}
if (!string.IsNullOrEmpty(_Reclamation.AgentRecepteur))
{
_Reclamation.NOMAGENTRECEPTEUR = lstUser.FirstOrDefault(t => t.MATRICULE == _Reclamation.AgentRecepteur) != null?
lstUser.FirstOrDefault(t => t.MATRICULE == _Reclamation.AgentRecepteur).LIBELLE : string.Empty;
}
if (!string.IsNullOrEmpty(_Reclamation.AgentValidation))
{
_Reclamation.NOMAGENTVALIDATEUR = lstUser.FirstOrDefault(t => t.MATRICULE == _Reclamation.AgentValidation) != null?
lstUser.FirstOrDefault(t => t.MATRICULE == _Reclamation.AgentValidation).LIBELLE : string.Empty;
}
_LaDemande.ReclamationRcl = _Reclamation;
DataTable dtDoc = DevisProcedures.DEVIS_DOCUMENTSCANNE_RETOURNEByIdDemande(_LaDemande.LaDemande.PK_ID);
_LaDemande.DonneDeDemande = Entities.GetEntityListFromQuery <ObjDOCUMENTSCANNE>(dtDoc);
}
catch (Exception)
{
_LaDemande.ReclamationRcl = null;
}
transaction.Dispose();
return(_LaDemande);
}
catch (Exception ex)
{
throw ex;
}
}
private static object GetObjectValueFromTable(string TABLEREFERENCE, galadbEntities Context, string IDLine,
ref Type objType)
{
object theLine = default(object);
//return (IList)instance;
string NameSpaceClass = "Galatee.Entity.Model." + TABLEREFERENCE;
Type classType = Type.GetType(NameSpaceClass);
var dbSets = typeof(galadbEntities).GetProperties(BindingFlags.Public |
BindingFlags.Instance);
var monDbSet = dbSets.Where(pi => pi.PropertyType.IsGenericTypeDefinition &&
pi.PropertyType.GetGenericTypeDefinition() == typeof(DbSet <>) &&
pi.Name == TABLEREFERENCE)
.FirstOrDefault();
dynamic TABLE = Context.GetType().InvokeMember(TABLEREFERENCE.Trim(),
BindingFlags.GetProperty | BindingFlags.Public | BindingFlags.Instance,
null, Context, null);
object theList = System.Linq.Enumerable.ToList((dynamic)TABLE);
objType = GetListType(theList);
var abon = Context.ABON;
var listType = typeof(List <>);
var constructedListType = listType.MakeGenericType(objType);
var theCorrectList = Activator.CreateInstance(constructedListType);
//On a le type, on va recuperer l'élement même de la table
Parallel.ForEach((IEnumerable <dynamic>)theList, (item, state) =>
{
if (item.PK_ID.ToString() == IDLine)
{
theLine = item;
//On a trouve l'élément, on arrête le parallel foreach
state.Break();
}
});
//Disposition des variables
GC.SuppressFinalize(listType);
GC.SuppressFinalize(constructedListType);
GC.SuppressFinalize(theCorrectList);
GC.SuppressFinalize(objType);
return(theLine);
}
private static int GetAgentByMatricul(string p)
{
try
{
using (galadbEntities context = new galadbEntities())
{
return(context.ADMUTILISATEUR.First(d => d.MATRICULE == p).PK_ID);
}
}
catch (Exception ex)
{
throw ex;
}
}
public string ValiderInitReclamation(CsDemandeReclamation LaDemande)
{
try
{
string DemandeID = string.Empty;
bool Resultat = false;
int resultTransaction = -1;
using (galadbEntities transaction = new galadbEntities())
{
try
{
LaDemande.LaDemande.NUMDEM = AccueilProcedures.GetNumDevis(LaDemande.LaDemande);
LaDemande.ReclamationRcl.NumeroReclamation = LaDemande.LaDemande.NUMDEM;
LaDemande.ReclamationRcl.FK_IDDEMANDE = LaDemande.LaDemande.PK_ID;
//LaDemande.LeClient.NUMDEM = LaDemande.LaDemande.NUMDEM;
ReclamationProcedure.InsertionInitReclamation(LaDemande, transaction);
resultTransaction = transaction.SaveChanges();
if (resultTransaction != -1)
{
LaDemande.LaDemande.PK_ID = transaction.DEMANDE.FirstOrDefault(d => d.NUMDEM == LaDemande.LaDemande.NUMDEM && d.CENTRE == LaDemande.LaDemande.CENTRE).PK_ID;
if (LaDemande.LaDemande.PK_ID == 0)
{
using (galadbEntities tctx = new galadbEntities())
{
DEMANDE laDem = tctx.DEMANDE.FirstOrDefault(t => t.NUMDEM == LaDemande.LaDemande.NUMDEM);
if (laDem != null)
{
DemandeID = laDem.PK_ID + "." + LaDemande.LaDemande.NUMDEM;
}
};
}
else
{
DemandeID = LaDemande.LaDemande.PK_ID + "." + LaDemande.LaDemande.NUMDEM;
}
}
}
catch (Exception ex)
{
throw ex;
}
};
return(DemandeID);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private void ObtenirIdFonction(string fonction, List <CsModule> modules)
{
try
{
using (galadbEntities context = new galadbEntities())
{
FONCTION _fonction = context.FONCTION.FirstOrDefault(f => f.CODE == fonction);
//modules.ForEach(h => h.PK_ID = _fonction.PK_ID);
};
}
catch (Exception ex)
{
throw ex;
}
}
public bool Insert(CsAdmMenu admProfilUsers)
{
try
{
Galatee.Entity.Model.ADMMENU admProfilUser = Galatee.Tools.Utility.ConvertEntity <Galatee.Entity.Model.ADMMENU, CsAdmMenu>(admProfilUsers);
using (galadbEntities context = new galadbEntities())
{
return(Entities.InsertEntity <Galatee.Entity.Model.ADMMENU>(admProfilUser));
};
}
catch (Exception ex)
{
throw ex;
}
}
private void ObtenirIdFonction(string fonction, List <CsHabilitationProgram> habilitations)
{
try
{
using (galadbEntities context = new galadbEntities())
{
FONCTION _fonction = context.FONCTION.FirstOrDefault(f => f.CODE == fonction);
habilitations.ForEach(h => h.FK_IDFONCTION = _fonction.PK_ID);
};
}
catch (Exception ex)
{
throw ex;
}
}
public bool Insert(CsProfil admProfilUsers)
{
try
{
Galatee.Entity.Model.PROFILSUTILISATEUR admProfilUser = Galatee.Tools.Utility.ConvertEntity <Galatee.Entity.Model.PROFILSUTILISATEUR, CsProfil>(admProfilUsers);
using (galadbEntities context = new galadbEntities())
{
return(Entities.InsertEntity <PROFILSUTILISATEUR>(admProfilUser));
};
}
catch (Exception ex)
{
throw ex;
}
}
public bool Insert(CsModule admProfilUsers)
{
try
{
Galatee.Entity.Model.MODULE admProfilUser = Galatee.Tools.Utility.ConvertEntity <Galatee.Entity.Model.MODULE, CsModule>(admProfilUsers);
using (galadbEntities context = new galadbEntities())
{
return(Entities.InsertEntity <Galatee.Entity.Model.MODULE>(admProfilUser));
};
}
catch (Exception ex)
{
throw ex;
}
}
public CsClientFraude InsertClientFraude(List <CsClientFraude> sClientFraude)
{
using (galadbEntities context = new galadbEntities())
{
try
{
CsClientFraude ClientFrd = new CsClientFraude();
List <CLIENTFRAUDE> ClientFraude = Entities.ConvertObject <Galatee.Entity.Model.CLIENTFRAUDE, CsClientFraude>(sClientFraude);
Entities.InsertEntity <Galatee.Entity.Model.CLIENTFRAUDE>(ClientFraude);
context.SaveChanges();
ClientFrd = Entities.ConvertObject <CsClientFraude, CLIENTFRAUDE>(ClientFraude).FirstOrDefault();
//foreach (CLIENTFRAUDE items in ClientFraude)
//{
// ClientFrd.PK_ID = items.PK_ID;
// ClientFrd.Nomabon = items.Nomabon;
// ClientFrd.Centre = items.Centre;
// ClientFrd.Telephone = items.Telephone;
// ClientFrd.Porte = items.Porte;
// ClientFrd.FK_IDCENTRE = items.FK_IDCENTRE;
// ClientFrd.FK_IDCOMMUNE = items.FK_IDCOMMUNE;
// ClientFrd.FK_IDQUARTIER = items.FK_IDQUARTIER;
// ClientFrd.FK_RUE = items.FK_RUE;
// ClientFrd.FK_SECTEUR = items.FK_SECTEUR;
// ClientFrd.Client = items.Client;
// ClientFrd.Ordre = items.Ordre;
// ClientFrd.Commune = items.Commune;
// ClientFrd.Quartier = items.Quartier;
// ClientFrd.Rue = items.Rue;
// ClientFrd.Secteur = items.Secteur;
// ClientFrd.ContratAbonnement = items.ContratAbonnement;
// ClientFrd.ContratBranchement = items.ContratBranchement;
// ClientFrd.DateContratAbonnement = items.DateContratAbonnement;
// ClientFrd.DateContratBranchement = items.DateContratBranchement;
//}
return(ClientFrd);
}
catch (Exception ex)
{
throw ex;
}
}
}
