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 LectureDonnees()
{
using (ClientLinqDataContext dc = new ClientLinqDataContext())
{
foreach (client cli in dc.client)
{
Console.WriteLine("{0} - {1} - {2} - {3} ", cli.noclient, cli.nom, cli.adresse, cli.noregion);
}
Console.WriteLine("--");
}
}
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 LireDonnees(string nomClient)
{
using (ClientLinqDataContext dc = new ClientLinqDataContext())
{
var req = from cli in dc.client where cli.nom == nomClient select cli;
client cliBdd = req.FirstOrDefault();
this.nom = cliBdd.nom;
this.NoClient = cliBdd.noclient;
this.adresse = cliBdd.adresse;
this.numRegion = cliBdd.noregion ?? 0; // si mon objet à gauche est null, je retourne ma valeur à droite
}
}
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();
}
}