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