public void SupprimerEnBase() { using (ClientLinqDataContext dc = new ClientLinqDataContext()) { var req = from cli in dc.client where cli.noclient == this.NoClient select cli; client cliBdd = req.FirstOrDefault(); dc.client.DeleteOnSubmit(cliBdd); dc.SubmitChanges(); } }
public void EnregistrerModif() { using (ClientLinqDataContext dc = new ClientLinqDataContext()) { var req = from cli in dc.client where cli.noclient == this.NoClient select cli; client cliBdd = req.FirstOrDefault(); cliBdd.nom = this.nom; cliBdd.adresse = this.adresse; cliBdd.noregion = this.numRegion; dc.SubmitChanges(); } }
public void AjouterLeClient() { using (ClientLinqDataContext dc = new ClientLinqDataContext()) { client cliBdd = new client(); cliBdd.noclient = this.NoClient; cliBdd.nom = this.nom; cliBdd.adresse = this.adresse; cliBdd.noregion = this.numRegion; //client cliBdd2 = new client { noclient = this.NoClient, nom = this.nom, adresse = this.adresse, noregion = this.numRegion }; dc.client.InsertOnSubmit(cliBdd); dc.SubmitChanges(); } }