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