// // 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); } } }
// // UPDATE // public bool updateSite(SitesEntity site) { using (var context = new MADERA_V1Entities()) { MDR_Sites addSite = (from s in context.MDR_Sites where s.Sts_Index == site.Sts_Index select s).SingleOrDefault(); addSite.Sts_Actif = site.Sts_Actif; addSite.Sts_Ville = site.Sts_Ville; addSite.Sts_Index = site.Sts_Index; try { context.SaveChanges(); return(true); } catch { return(false); } } }