public void EnregistrerModif() { using (BddClientDataContext dc = new BddClientDataContext()) { var req = from cli in dc.clientbdd where cli.noclient == this.NoClient select cli; clientbdd cliBdd = req.FirstOrDefault(); cliBdd.nom = Nom; cliBdd.adresse = Adresse; //cliBdd.noregion = 0; dc.SubmitChanges(); } }
void ChargeClient(int noCli) { using (BddClientDataContext dc = new BddClientDataContext()) { // Récupération de la vue "clientregion" : script SQL disponible à la racine du depot GIT ;-) var req = from cli in dc.clientregion where cli.noclient == noCli select cli; clientregion cliBdd = req.FirstOrDefault(); if (req.Count() > 0) { Nom = cliBdd.nom; NoClient = cliBdd.noclient; Adresse = cliBdd.adresse; Region = cliBdd.nomregion; } } }