//
// Fonction de création d'un client
//
public bool createClient(ClientEntity client)
{
using (var context = new MADERA_V1Entities())
{
MDR_Clients addCLient = new MDR_Clients();
addCLient.Cli_Actif = 1;
addCLient.Cli_Adresse = client.Cli_Adresse;
addCLient.Cli_Age = client.Cli_Age;
addCLient.Cli_CP = client.Cli_CP;
addCLient.Cli_Email = client.Cli_Email;
addCLient.Cli_Nom = client.Cli_Nom;
addCLient.Cli_Phone = client.Cli_Phone;
addCLient.Cli_Prenom = client.Cli_Prenom;
addCLient.Cli_Ville = client.Cli_Ville;
try
{
context.MDR_Clients.Add(addCLient);
context.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
//
// Fonction d'update d'un client
//
public bool updateClient(ClientEntity client)
{
using (var context = new MADERA_V1Entities())
{
MDR_Clients updatingClient = (from c in context.MDR_Clients
where c.Cli_Index == client.Cli_Index
select c).SingleOrDefault();
updatingClient.Cli_Actif = client.Cli_Actif;
updatingClient.Cli_Adresse = client.Cli_Adresse;
updatingClient.Cli_Age = client.Cli_Age;
updatingClient.Cli_CP = client.Cli_CP;
updatingClient.Cli_Email = client.Cli_Email;
updatingClient.Cli_Nom = client.Cli_Nom;
updatingClient.Cli_Phone = client.Cli_Phone;
updatingClient.Cli_Prenom = client.Cli_Prenom;
updatingClient.Cli_Ville = client.Cli_Ville;
try
{
context.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
//
// Fonction de suppression d'un client
//
public bool disabledClientById(int IdClient)
{
using (var context = new MADERA_V1Entities())
{
MDR_Clients updatingClient = (from c in context.MDR_Clients
where c.Cli_Index == IdClient
select c).SingleOrDefault();
updatingClient.Cli_Actif = 0;
try
{
context.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}