// // UPDATE // public bool updateComposant(ComposantsEntity composants) { using (var context = new MADERA_V1Entities()) { MDR_Composants addComposant = (from c in context.MDR_Composants where c.Comp_Index == composants.Comp_Index select c).SingleOrDefault(); addComposant.Comp_Actif = composants.Comp_Actif; addComposant.Comp_Couleur = composants.Comp_Couleur; addComposant.Comp_Nom = composants.Comp_Nom; addComposant.Comp_Type = composants.Comp_Type; addComposant.Comp_Index = composants.Comp_Index; try { context.MDR_Composants.Add(addComposant); context.SaveChanges(); return(true); } catch (Exception e) { return(false); } } }
// // UPDATE // public bool updateEtatPaiement(EtatPaiementEntity etat) { using (var context = new MADERA_V1Entities()) { MDR_Etat_Paiement addEtat = (from e in context.MDR_Etat_Paiement where e.EPai_Index == etat.EPai_Index select e).SingleOrDefault(); addEtat.EPai_Actif = etat.EPai_Actif; addEtat.EPai_Date = etat.EPai_Date; addEtat.EPai_Etat = etat.EPai_Etat; addEtat.EPai_Index = etat.EPai_Index; try { context.MDR_Etat_Paiement.Add(addEtat); context.SaveChanges(); return(true); } catch (Exception e) { return(false); } } }
// // Fonction d'update d'un client // public bool updateClient(ClientEntity client) { using (var context = new MADERA_V1Entities()) { MDR_Clients updatingClient = (from c in context.MDR_Clients where c.Cli_Index == client.Cli_Index select c).SingleOrDefault(); updatingClient.Cli_Actif = client.Cli_Actif; updatingClient.Cli_Adresse = client.Cli_Adresse; updatingClient.Cli_Age = client.Cli_Age; updatingClient.Cli_CP = client.Cli_CP; updatingClient.Cli_Email = client.Cli_Email; updatingClient.Cli_Nom = client.Cli_Nom; updatingClient.Cli_Phone = client.Cli_Phone; updatingClient.Cli_Prenom = client.Cli_Prenom; updatingClient.Cli_Ville = client.Cli_Ville; try { context.SaveChanges(); return(true); } catch (Exception e) { return(false); } } }
// // Fonction de création d'un client // public bool createClient(ClientEntity client) { using (var context = new MADERA_V1Entities()) { MDR_Clients addCLient = new MDR_Clients(); addCLient.Cli_Actif = 1; addCLient.Cli_Adresse = client.Cli_Adresse; addCLient.Cli_Age = client.Cli_Age; addCLient.Cli_CP = client.Cli_CP; addCLient.Cli_Email = client.Cli_Email; addCLient.Cli_Nom = client.Cli_Nom; addCLient.Cli_Phone = client.Cli_Phone; addCLient.Cli_Prenom = client.Cli_Prenom; addCLient.Cli_Ville = client.Cli_Ville; try { context.MDR_Clients.Add(addCLient); context.SaveChanges(); return(true); } catch (Exception e) { return(false); } } }
// // UPDATE // public bool updateModule(ModulesEntity module) { using (var context = new MADERA_V1Entities()) { MDR_Modules addModule = (from m in context.MDR_Modules where m.Mod_Index == module.Mod_Index select m).SingleOrDefault(); addModule.Mod_Actif = module.Mod_Actif; addModule.Mod_Date = module.Mod_Date; addModule.Mod_Nom = module.Mod_Nom; addModule.Mod_Prix = module.Mod_Prix; addModule.Mod_Index = module.Mod_Index; try { context.SaveChanges(); return(true); } catch (Exception e) { return(false); } } }
// //Fonction de création d'un commercial // public bool createCommercial(CommerciauxEntity commercial) { using (var context = new MADERA_V1Entities()) { MDR_Commerciaux addCommercial = new MDR_Commerciaux(); addCommercial.Com_Actif = 1; addCommercial.Com_Identifiant = commercial.Com_Identifiant; addCommercial.Com_Mdp = commercial.Com_Mdp; addCommercial.Com_Nom = commercial.Com_Nom; try { context.MDR_Commerciaux.Add(addCommercial); context.SaveChanges(); return(true); } catch (Exception e) { return(false); } } }
public static List <ClientEntity> GetSearchAll(string search) { using (var context = new MADERA_V1Entities()) { var numCount1 = (from c in context.MDR_Clients where c.Cli_Nom.Contains(search) || c.Cli_Prenom.Contains(search) || c.Cli_Email.Contains(search) select new ClientEntity { Cli_Index = c.Cli_Index, Cli_Adresse = c.Cli_Adresse, Cli_Age = c.Cli_Age, Cli_CP = c.Cli_CP, Cli_Email = c.Cli_Email, Cli_Nom = c.Cli_Nom, Cli_Phone = c.Cli_Phone, Cli_Prenom = c.Cli_Prenom, Cli_Ville = c.Cli_Ville, Cli_Actif = c.Cli_Actif }).ToList(); context.MDR_Clients.Where(c => c.Cli_Nom.Contains(search)).Select(c => new ClientEntity() { }).ToList(); return(numCount1); } }
// // SELECT ALL // public List <GammesEntity> selectAllGamme() { using (var context = new MADERA_V1Entities()) { var gamme = (from g in context.MDR_Gammes select new GammesEntity { Gam_Actif = g.Gam_Actif, Gam_Index = g.Gam_Index, Gam_Nom = g.Gam_Nom }).ToList(); return(gamme); } }
// // SELECT ALL // public SitesEntity getAllSitesById(int IdSite) { using (var context = new MADERA_V1Entities()) { var site = (from s in context.MDR_Sites where s.Sts_Index == IdSite select new SitesEntity { Sts_Actif = s.Sts_Actif, Sts_Index = s.Sts_Index, Sts_Ville = s.Sts_Ville }).SingleOrDefault(); return(site); } }
// // SELECT ALL // public GammesEntity selectAllGamme(int IdGamme) { using (var context = new MADERA_V1Entities()) { var gamme = (from g in context.MDR_Gammes where g.Gam_Index == IdGamme select new GammesEntity { Gam_Actif = g.Gam_Actif, Gam_Index = g.Gam_Index, Gam_Nom = g.Gam_Nom }).SingleOrDefault(); return(gamme); } }
// // SELECT ALL // public TypesPaiementEntity getAllTypePaiementById(int IdType) { using (var context = new MADERA_V1Entities()) { var type = (from t in context.MDR_Types_Paiement where t.TPai_Index == IdType select new TypesPaiementEntity { TPai_Actif = t.TPai_Actif, TPai_Index = t.TPai_Index, TPai_Nom = t.TPai_Nom }).SingleOrDefault(); return(type); } }
// // SELECT ALL // public DevisEntity getAllDevisById(int IdDevis) { using (var context = new MADERA_V1Entities()) { var devis = (from d in context.MDR_Devis where d.Dev_Index == IdDevis select new DevisEntity { Dev_Index = d.Dev_Index, Dev_Actif = d.Dev_Actif, Dev_Prix = d.Dev_Prix }).SingleOrDefault(); return(devis); } }
// // Fonction de récupération peu importe actif ou non // public CommandesEntity getAllCommandeById(int IdCommande) { using (var context = new MADERA_V1Entities()) { var commande = (from c in context.MDR_Commandes where c.Comma_Index == IdCommande select new CommandesEntity { Comma_Index = c.Comma_Index, Comma_Actif = c.Comma_Actif, Comma_Prix = c.Comma_Prix }).SingleOrDefault(); return(commande); } }
// // SELECT ALL // public ModelesEntity getAllModelesById(int IdModeles) { using (var context = new MADERA_V1Entities()) { var modele = (from m in context.MDR_Modeles where m.Model_Index == IdModeles select new ModelesEntity { Model_Actif = m.Model_Actif, Model_Index = m.Model_Index, Model_Nom = m.Model_Nom }).SingleOrDefault(); return(modele); } }
// // SELECT ALL // public FournisseursEntity selectAllFournisseur(int IdFournisseur) { using (var context = new MADERA_V1Entities()) { var fournisseur = (from f in context.MDR_Fournisseurs where f.Four_Index == IdFournisseur select new FournisseursEntity { Four_Actif = f.Four_Actif, Four_Index = f.Four_Index, Four_Nom = f.Four_Nom }).SingleOrDefault(); return(fournisseur); } }
// // SELECT ALL // public PaiementEntity getAllPaiementById(int IdPaiement) { using (var context = new MADERA_V1Entities()) { var paiement = (from p in context.MDR_Paiement where p.Pai_Index == IdPaiement select new PaiementEntity { Pai_Actif = p.Pai_Actif, Pai_Etat = p.Pai_Etat, Pai_Index = p.Pai_Index, Pai_Type = p.Pai_Type }).SingleOrDefault(); return(paiement); } }
// // SELECT ALL // public List <ComposantsEntity> getAllComposant() { using (var context = new MADERA_V1Entities()) { var composant = (from c in context.MDR_Composants select new ComposantsEntity { Comp_Index = c.Comp_Index, Comp_Actif = c.Comp_Actif, Comp_Couleur = c.Comp_Couleur, Comp_Nom = c.Comp_Nom, Comp_Type = c.Comp_Type }).ToList(); return(composant); } }
// // SELECT ALL // public EtatPaiementEntity getAllEtatPaiement(int IdEtatPaiement) { using (var context = new MADERA_V1Entities()) { var Etat = (from e in context.MDR_Etat_Paiement where e.EPai_Index == IdEtatPaiement select new EtatPaiementEntity { EPai_Actif = e.EPai_Actif, EPai_Date = e.EPai_Date, EPai_Index = e.EPai_Index, EPai_Etat = e.EPai_Etat }).SingleOrDefault(); return(Etat); } }
// // SELECT ACTIVE // public ModulesEntity getActiveModulesById(int IdModules) { using (var context = new MADERA_V1Entities()) { var modules = (from m in context.MDR_Modules where m.Mod_Index == IdModules && m.Mod_Actif == 1 select new ModulesEntity { Mod_Actif = m.Mod_Actif, Mod_Index = m.Mod_Index, Mod_Date = m.Mod_Date, Mod_Nom = m.Mod_Nom, Mod_Prix = m.Mod_Prix }).SingleOrDefault(); return(modules); } }
// // Fonction de récupération d'une commande par ID (Toutes commandes, même inactives) // public CommerciauxEntity getAllCommercialById(int IdCommercial) { using (var context = new MADERA_V1Entities()) { var commercial = (from c in context.MDR_Commerciaux where c.Com_Index == IdCommercial select new CommerciauxEntity { Com_Actif = c.Com_Actif, Com_Identifiant = c.Com_Identifiant, Com_Index = c.Com_Index, Com_Mdp = c.Com_Mdp, Com_Nom = c.Com_Nom }).SingleOrDefault(); return(commercial); } }
// //Fonction de récupération d'un commercial (Il doit etre actif) // public CommerciauxEntity getActiveCommercialByEmail(string EmailCommercial) { using (var context = new MADERA_V1Entities()) { var commercial = (from c in context.MDR_Commerciaux where c.Com_Identifiant == EmailCommercial && c.Com_Actif == 1 select new CommerciauxEntity { Com_Actif = c.Com_Actif, Com_Identifiant = c.Com_Identifiant, Com_Index = c.Com_Index, Com_Mdp = c.Com_Mdp, Com_Nom = c.Com_Nom }).SingleOrDefault(); return(commercial); } }
// // SELECT // public ComposantsEntity getActiveComposantById(int IdComposants) { using (var context = new MADERA_V1Entities()) { var composant = (from c in context.MDR_Composants where c.Comp_Index == IdComposants && c.Comp_Actif == 1 select new ComposantsEntity { Comp_Index = c.Comp_Index, Comp_Actif = c.Comp_Actif, Comp_Couleur = c.Comp_Couleur, Comp_Nom = c.Comp_Nom, Comp_Type = c.Comp_Type }).SingleOrDefault(); return(composant); } }
// // DELETE // public bool disabledPaiement(int IdPaiement) { using (var context = new MADERA_V1Entities()) { MDR_Paiement addPaiement = (from p in context.MDR_Paiement where p.Pai_Index == IdPaiement select p).SingleOrDefault(); addPaiement.Pai_Actif = 0; try { context.SaveChanges(); return(true); } catch (Exception e) { return(false); } } }
// // Fonction de désactivation d'un commercial // public bool disabledCommercial(int IdCommercial) { using (var context = new MADERA_V1Entities()) { MDR_Commerciaux updatingCommercial = (from c in context.MDR_Commerciaux where c.Com_Index == IdCommercial select c).SingleOrDefault(); updatingCommercial.Com_Actif = 0; try { context.SaveChanges(); return(true); } catch (Exception e) { return(false); } } }
// // CREATE // public bool createGamme(GammesEntity gamme) { using (var context = new MADERA_V1Entities()) { MDR_Gammes addGamme = new MDR_Gammes(); addGamme.Gam_Actif = 1; addGamme.Gam_Nom = gamme.Gam_Nom; try { context.MDR_Gammes.Add(addGamme); context.SaveChanges(); return(true); } catch (Exception e) { return(false); } } }
// // DELETE // public bool deleteDevis(DevisEntity devis) { using (var context = new MADERA_V1Entities()) { MDR_Devis addDevis = (from d in context.MDR_Devis where d.Dev_Index == devis.Dev_Index select d).SingleOrDefault(); addDevis.Dev_Actif = 0; try { context.SaveChanges(); return(true); } catch (Exception e) { return(false); } } }
// // Fonction de suppression d'un client // public bool disabledClientById(int IdClient) { using (var context = new MADERA_V1Entities()) { MDR_Clients updatingClient = (from c in context.MDR_Clients where c.Cli_Index == IdClient select c).SingleOrDefault(); updatingClient.Cli_Actif = 0; try { context.SaveChanges(); return(true); } catch (Exception e) { return(false); } } }
// // CREATE // public bool createDevis(DevisEntity devis) { using (var context = new MADERA_V1Entities()) { MDR_Devis addDevis = new MDR_Devis(); addDevis.Dev_Actif = devis.Dev_Actif; addDevis.Dev_Prix = devis.Dev_Prix; try { context.MDR_Devis.Add(addDevis); context.SaveChanges(); return(true); } catch (Exception e) { return(false); } } }
// // CREATE // public bool createSites(SitesEntity site) { using (var context = new MADERA_V1Entities()) { MDR_Sites addSite = new MDR_Sites(); addSite.Sts_Actif = 1; addSite.Sts_Ville = site.Sts_Ville; try { context.MDR_Sites.Add(addSite); context.SaveChanges(); return(true); } catch { return(false); } } }
// // DELETE // public bool disabledSite(int IdSite) { using (var context = new MADERA_V1Entities()) { MDR_Sites addSite = (from s in context.MDR_Sites where s.Sts_Index == IdSite select s).SingleOrDefault(); addSite.Sts_Actif = 0; try { context.SaveChanges(); return(true); } catch { return(false); } } }