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