public void Update(Animaux monAnimal) { try { SqlParameter monParametre; if (!monAnimal.Archive.HasValue) { monAnimal.Archive = false; } SqlCommand cmd = (SqlCommand)maConnexion().CreateCommand(); cmd.CommandText = " UPDATE Animaux " + " SET NomAnimal = @NomAnimal, Sexe = @Sexe, Couleur = @Couleur, Race = @Race, Espece = @Espece, CodeClient = @CodeClient, Tatouage = @Tatouage, Antecedents = @Antecedents, Archive = @Archive " + " WHERE CodeAnimal = @CodeAnimal ; "; monParametre = new SqlParameter("@NomAnimal", monAnimal.NomAnimal); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@Sexe", monAnimal.Sexe); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@Couleur", monAnimal.Couleur ?? String.Empty); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@Race", monAnimal.Race.Race); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@Espece", monAnimal.Race.Espece); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@CodeClient", monAnimal.CodeClient); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@Tatouage", monAnimal.Tatouage ?? String.Empty); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@Antecedents", monAnimal.Antecedents ?? String.Empty); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@Archive", monAnimal.Archive); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@CodeAnimal", monAnimal.CodeAnimal.Value); cmd.Parameters.Add(monParametre); cmd.ExecuteScalar(); } catch (Exception ex) { throw new Exception("Echec de la modification de l'animal :\n" + ex.Message); } finally { cnx.Close(); } }
public void Add(Animaux unAnimal) { try { SqlParameter monParametre; Clients proprietaire = new ADO_Clients().GetOne(unAnimal.CodeClient.Value); if (!unAnimal.Archive.HasValue) { unAnimal.Archive = false; } SqlCommand cmd = (SqlCommand)maConnexion().CreateCommand(); cmd.CommandText = " exec ajout_animal @Nomclient, @PrenomClient, @NomAnimal, @Sexe, @Couleur, @Espece, @Race, @Archive;"; monParametre = new SqlParameter("@Nomclient", proprietaire.NomClient); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@PrenomClient", proprietaire.PrenomClient); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@NomAnimal", unAnimal.NomAnimal); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@Sexe", unAnimal.Sexe); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@Couleur", unAnimal.Couleur); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@Race", unAnimal.Race.Race); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@Espece", unAnimal.Race.Espece); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@Archive", unAnimal.Archive.Value); cmd.Parameters.Add(monParametre); cmd.ExecuteScalar(); } catch (Exception ex) { throw new Exception("Echec de l'insertion d'un animal :\n" + ex.Message); } finally { cnx.Close(); } }
public static void ajouterDeuxLignesNonFacture(Consultation consultation) { using (DbConnection cnx = ConnectionBDD.SeConnecter()) { ADO_Animal monAnimalDAL = new ADO_Animal(); Veterinaires _veto = ADO_Veterinaires.getOneVeto(consultation.CodeVeto.Value); Animaux _animaux = monAnimalDAL.GetOne(consultation.CodeAnimal.Value); SqlParameter monParametre; SqlCommand cmd = (SqlCommand)cnx.CreateCommand(); cmd.CommandText = " exec ajout_Consultation2 @DateConsultation, @nomVeto, @nomAnimal"; monParametre = new SqlParameter("@nomVeto", _veto.NomVeto); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@nomAnimal", _animaux.NomAnimal); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@DateConsultation", consultation.DateConsultation.Value); cmd.Parameters.Add(monParametre); cmd.ExecuteNonQuery(); } }
public static void Add(Agendas monAgenda) { ADO_Animal animalDAL = new ADO_Animal(); ADO_Clients clientDAL = new ADO_Clients(); Animaux monAnimal = animalDAL.GetOne(monAgenda.CodeAnimal.Value); Clients monClient = clientDAL.GetOne(monAnimal.CodeClient.Value); Veterinaires monVeto = ADO_Veterinaires.getOneVeto(monAgenda.CodeVeto.Value); using (DbConnection cnx = ConnectionBDD.SeConnecter()) { SqlParameter monParametre; SqlCommand cmd = (SqlCommand)cnx.CreateCommand(); cmd.CommandText = " exec ajout_agenda @nomClient, @prenomClient, @nomAnimal, @nomVeto, @dateRdv ;"; monParametre = new SqlParameter("@nomClient", monClient.NomClient); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@prenomClient", monClient.PrenomClient); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@nomAnimal", monAnimal.NomAnimal); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@nomVeto", monVeto.NomVeto); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@dateRdv", monAgenda.DateRDV); cmd.Parameters.Add(monParametre); try { cmd.ExecuteNonQuery(); } catch (Exception ex) { throw new Exception("Echec de l'insertion dans l'agnda :\n" + ex.Message); } } }