public static LignesConsultations getOneLignesConsultation(Guid pCodeConsultations, Guid pNumLigne) { using (DbConnection cnx = ConnectionBDD.SeConnecter()) { LignesConsultations uneConsultation = new LignesConsultations(); SqlDataAdapter monAdapter = new SqlDataAdapter(); DataTable resultat = new DataTable(); SqlParameter monParametre; SqlCommand cmd = (SqlCommand)cnx.CreateCommand(); cmd.CommandText = " SELECT * " + " FROM LignesConsultations" + " WHERE CodeConsultation = @codeConsultation" + " AND NumLigne = @NumLigne ; "; monParametre = new SqlParameter("@codeConsultation", pCodeConsultations); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@NumLigne", pNumLigne); cmd.Parameters.Add(monParametre); monAdapter.SelectCommand = cmd; monAdapter.Fill(resultat); uneConsultation = new LignesConsultations(resultat.Rows[0]); return(uneConsultation); } }
public static void Add(LignesConsultations lignesConsultation) { using (DbConnection cnx = ConnectionBDD.SeConnecter()) { SqlParameter monParametre; SqlCommand cmd = (SqlCommand)cnx.CreateCommand(); cmd.CommandText = " exec ajout_ligneConsultation @CodeConsultation, @DateVigueur, @CodeGroupement, @Prix, @RappelEnvoye, @Archive"; monParametre = new SqlParameter("@CodeConsultation", lignesConsultation.CodeConsultation); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@CodeGroupement", lignesConsultation.CodeGroupement); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@DateVigueur", lignesConsultation.DateVigueur); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@Prix", lignesConsultation.Prix); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@RappelEnvoye", lignesConsultation.RappelEnvoye); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@Archive", lignesConsultation.Archive); cmd.Parameters.Add(monParametre); cmd.ExecuteNonQuery(); } }
public static Baremes GetOne(Baremes pBareme) { using (DbConnection cnx = ConnectionBDD.SeConnecter()) { SqlDataAdapter monAdapter = new SqlDataAdapter(); DataTable resultat = new DataTable(); SqlParameter monParametre; SqlCommand cmd = (SqlCommand)cnx.CreateCommand(); cmd.CommandText = " SELECT * " + " FROM Baremes " + " WHERE CodeGroupement = @CodeGroupement " + " AND DateVigueur = @DateVigueur "; monParametre = new SqlParameter("@CodeGroupement", pBareme.CodeGroupement); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@DateVigueur", pBareme.DateVigueur); cmd.Parameters.Add(monParametre); monAdapter.SelectCommand = cmd; monAdapter.Fill(resultat); return(new Baremes(resultat.Rows[0])); } }
// Attention, modification de la clé primaire, risque d'erreurs ! public static void Update(Races maNouvelleRace, Races monAncienneRace) { using (DbConnection cnx = ConnectionBDD.SeConnecter()) { SqlParameter monParametre; SqlCommand cmd = (SqlCommand)cnx.CreateCommand(); cmd.CommandText = " UPDATE Races " + " SET (Race = @nouvelleRace, Espece = @nouvelleEspece) " + " WHERE Race = @ancienneRace " + " AND Espece = @ancienneEspece ;"; monParametre = new SqlParameter("@nouvelleRace", maNouvelleRace.Race); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@nouvelleEspece", maNouvelleRace.Espece); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@ancienneRace", monAncienneRace.Race); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@ancienneEspece", monAncienneRace.Espece); cmd.Parameters.Add(monParametre); try { cmd.ExecuteScalar(); } catch (Exception) { throw new Exception("Echec de la modification de la race"); } } }
public static List <Baremes> ComboLibelle(string typeActe) { using (DbConnection cnx = ConnectionBDD.SeConnecter()) { SqlDataAdapter monAdapter = new SqlDataAdapter(); DataTable maDataTable = new DataTable(); List <Baremes> listeBaremes = new List <Baremes>(); SqlParameter monParametre; SqlCommand cmd = (SqlCommand)cnx.CreateCommand(); cmd.CommandText = " SELECT * " + " FROM Baremes " + " WHERE TypeActe = @typeActe"; monParametre = new SqlParameter("@typeActe", typeActe); cmd.Parameters.Add(monParametre); monAdapter.SelectCommand = cmd; monAdapter.Fill(maDataTable); foreach (DataRow unBaremes in maDataTable.Rows) { listeBaremes.Add(new Baremes(unBaremes)); } return(listeBaremes); } }
public static void AddBareme(Baremes pBareme) { using (DbConnection cnx = ConnectionBDD.SeConnecter()) { SqlParameter monParametre; string pNomVaccin = ADO_Vaccins.getListeVaccins().Find(x => x.CodeVaccin == pBareme.CodeVaccin).NomVaccin; string dateVigueur = DateTime.Now.ToString("dd/MM/yy"); SqlCommand cmd = (SqlCommand)cnx.CreateCommand(); cmd.CommandText = " exec ajout_bareme @codeGroupement, @dateVigueur, @typeActe, " + "@libelle, @tarifFixe, @tarifMini, @tarifMaxi, @nomVaccin;"; monParametre = new SqlParameter("@codeGroupement", pBareme.CodeGroupement); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@dateVigueur", dateVigueur); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@typeActe", pBareme.TypeActe); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@libelle", pBareme.Libelle); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@tarifFixe", pBareme.TarifFixe ?? Convert.DBNull); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@tarifMini", pBareme.TarifMini ?? Convert.DBNull); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@tarifMaxi", pBareme.TarifMaxi ?? Convert.DBNull); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@nomVaccin", pNomVaccin); cmd.Parameters.Add(monParametre); cmd.ExecuteNonQuery(); } }
public static void reinitialiserMotPasseVeto(Veterinaires veto, string pNouveauCode, string pVerifCode) { using (DbConnection cnx = ConnectionBDD.SeConnecter()) { List <Veterinaires> listeVeto = new List <Veterinaires>(); SqlDataAdapter monAdapter = new SqlDataAdapter(); DataTable resultat = new DataTable(); if (pNouveauCode.Equals(pVerifCode)) { SqlParameter monParametre; SqlCommand cmd = (SqlCommand)cnx.CreateCommand(); cmd.CommandText = "update Veterinaires set MotPasse = @MotPasse where CodeVeto = @codeVeto"; monParametre = new SqlParameter("@MotPasse", pNouveauCode); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@codeVeto", veto.CodeVeto); cmd.Parameters.Add(monParametre); monAdapter.SelectCommand = cmd; monAdapter.Fill(resultat); foreach (DataRow unVeto in resultat.Rows) { listeVeto.Add(new Veterinaires(unVeto)); } } } }
public Clients GetOneWithoutArchive(Guid?pCodeClient) { cnx = ConnectionBDD.SeConnecter(); try { DataTable maDataTable = new DataTable(); SqlDataAdapter monAdapter = new SqlDataAdapter(); SqlParameter monParametre; SqlCommand cmd = (SqlCommand)cnx.CreateCommand(); cmd.CommandText = " SELECT * " + " FROM Clients " + " WHERE CodeClient = @codeClient " + " AND Archive = 0 ;"; monParametre = new SqlParameter("@codeClient", pCodeClient); cmd.Parameters.Add(monParametre); monAdapter.SelectCommand = cmd; monAdapter.Fill(maDataTable); return(new Clients(maDataTable.Rows[0])); } catch (Exception ex) { throw new Exception("Une erreur c'est produite lors de la séléction d'un client non archivé :\n" + ex.Message); } finally { cnx.Close(); } }
public static Clients Rechercher(string nomClient) { using (DbConnection cnx = ConnectionBDD.SeConnecter()) { Clients unClient = new Clients(); SqlDataAdapter monAdapter = new SqlDataAdapter(); DataTable maDataTable = new DataTable(); SqlParameter monParametre; SqlCommand cmd = (SqlCommand)cnx.CreateCommand(); cmd.CommandText = " SELECT TOP(1) * " + " FROM Clients" + " WHERE NomClient LIKE '%' + @nomClient + '%'" + " AND Archive = 0 ;"; monParametre = new SqlParameter("@nomClient", nomClient); cmd.Parameters.Add(monParametre); monAdapter.SelectCommand = cmd; monAdapter.Fill(maDataTable); foreach (DataRow clientEnCours in maDataTable.Rows) { unClient = new Clients(clientEnCours); break; } return(unClient); } }
public static bool Authentification(string identifiant, string motDePasse) { using (DbConnection cnx = ConnectionBDD.SeConnecter()) { SqlParameter monParametre; SqlCommand cmd = (SqlCommand)cnx.CreateCommand(); cmd.CommandText = " SELECT COUNT(*) " + " FROM UsersLogins " + " WHERE Identifiant = @identifiant " + " AND MotDePasse = @motDePasse "; monParametre = new SqlParameter("@identifiant", identifiant); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@motDePasse", motDePasse); cmd.Parameters.Add(monParametre); if (int.Parse(cmd.ExecuteScalar().ToString()) > 0) { return(true); } else { return(false); } } }
public void Delete(Guid pCodeClient) { cnx = ConnectionBDD.SeConnecter(); try { SqlParameter monParametre; SqlCommand cmd = (SqlCommand)cnx.CreateCommand(); cmd.CommandText = " UPDATE Animaux SET Archive = 1 WHERE CodeClient = @codeClient ; " + " UPDATE Clients SET Archive = 1 WHERE CodeClient = @codeClient ; "; monParametre = new SqlParameter("@codeClient", pCodeClient); cmd.Parameters.Add(monParametre); cmd.ExecuteScalar(); } catch (Exception ex) { throw new Exception("Echec de la suppression du client :\n" + ex.Message); } finally { cnx.Close(); } }
public static void Delete(Races maRace) { using (DbConnection cnx = ConnectionBDD.SeConnecter()) { SqlParameter monParametre; SqlCommand cmd = (SqlCommand)cnx.CreateCommand(); cmd.CommandText = " DELETE FROM Races " + " WHERE Race = @race " + " AND Espece = @espece "; monParametre = new SqlParameter("@race", maRace.Race); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@espece", maRace.Espece); cmd.Parameters.Add(monParametre); try { cmd.ExecuteScalar(); } catch (Exception) { throw new Exception("Echec de la suppression de la race"); } } }
public static Agendas GetOne(Agendas monAgenda) { using (DbConnection cnx = ConnectionBDD.SeConnecter()) { SqlDataAdapter monAdapter = new SqlDataAdapter(); DataTable resultat = new DataTable(); SqlParameter monParametre; SqlCommand cmd = (SqlCommand)cnx.CreateCommand(); cmd.CommandText = " SELECT * " + " FROM Agendas " + " WHERE CodeVeto = @CodeVeto " + " AND DateRdv = @DateRdv " + " AND CodeAnimal = @CodeAnimal ;"; monParametre = new SqlParameter("@Agendas", monAgenda.CodeVeto); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@DateRdv", monAgenda.DateRDV); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@CodeAnimal", monAgenda.CodeAnimal); cmd.Parameters.Add(monParametre); monAdapter.SelectCommand = cmd; monAdapter.Fill(resultat); return(new Agendas(resultat.Rows[0])); } }
public static List <Agendas> GetAllWithDetail() { using (DbConnection cnx = ConnectionBDD.SeConnecter()) { SqlDataAdapter monAdapter = new SqlDataAdapter(); DataTable maDataTable = new DataTable(); List <Agendas> listeAgendas = new List <Agendas>(); Agendas monAgenda; SqlCommand cmd = (SqlCommand)cnx.CreateCommand(); cmd.CommandText = " SELECT * " + " FROM Agendas Ag " + " INNER JOIN Veterinaires V ON Ag.CodeVeto = V.CodeVeto " + " INNER JOIN Animaux An ON Ag.CodeAnimal = An.CodeAnimal " + " INNER JOIN Clients C ON An.CodeClient = C.CodeClient "; monAdapter.SelectCommand = cmd; monAdapter.Fill(maDataTable); foreach (DataRow unAgendas in maDataTable.Rows) { monAgenda = new Agendas(unAgendas); monAgenda.NomAnimal = unAgendas["NomAnimal"].ToString(); monAgenda.NomClient = unAgendas["NomClient"].ToString(); monAgenda.PrenomClient = unAgendas["PrenomClient"].ToString(); monAgenda.Race = unAgendas["Race"].ToString(); listeAgendas.Add(monAgenda); } return(listeAgendas); } }
public static void Delete(Agendas monAgenda) { using (DbConnection cnx = ConnectionBDD.SeConnecter()) { SqlParameter monParametre; SqlCommand cmd = (SqlCommand)cnx.CreateCommand(); cmd.CommandText = " DELETE FROM Agendas " + " WHERE CodeVeto = @CodeVeto " + " AND DateRdv = @DateRdv " + " AND CodeAnimal = @CodeAnimal "; monParametre = new SqlParameter("@CodeVeto", monAgenda.CodeVeto); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@DateRdv", monAgenda.DateRDV); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@CodeAnimal", monAgenda.CodeAnimal); cmd.Parameters.Add(monParametre); try { cmd.ExecuteScalar(); } catch (Exception) { throw new Exception("Echec de la suppression de la race"); } } }
public static Races GetOne(Races maRace) { using (DbConnection cnx = ConnectionBDD.SeConnecter()) { SqlDataAdapter monAdapter = new SqlDataAdapter(); DataTable resultat = new DataTable(); SqlParameter monParametre; SqlCommand cmd = (SqlCommand)cnx.CreateCommand(); cmd.CommandText = " SELECT * " + " FROM Races " + " WHERE Race = @race " + " AND Espece = @espece "; monParametre = new SqlParameter("@race", maRace.Race); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@espece", maRace.Espece); cmd.Parameters.Add(monParametre); monAdapter.SelectCommand = cmd; monAdapter.Fill(resultat); return(new Races(resultat.Rows[0])); } }
public static Veterinaires getOneVeto(Guid pCodeVeto) { using (DbConnection cnx = ConnectionBDD.SeConnecter()) { Veterinaires unVeto = new Veterinaires(); SqlDataAdapter monAdapter = new SqlDataAdapter(); DataTable maDataTable = new DataTable(); SqlParameter monParametre; SqlCommand cmd = (SqlCommand)cnx.CreateCommand(); cmd.CommandText = " SELECT * " + " FROM Veterinaires" + " WHERE CodeVeto = @codeVeto"; monParametre = new SqlParameter("@codeVeto", pCodeVeto); cmd.Parameters.Add(monParametre); monAdapter.SelectCommand = cmd; monAdapter.Fill(maDataTable); foreach (DataRow uneOccurence in maDataTable.Rows) { unVeto = new Veterinaires(uneOccurence); } return(unVeto); } }
public static void ajouterVeto(string pNomVeto, string pPrenomVeto, string pMotPasse) { using (DbConnection cnx = ConnectionBDD.SeConnecter()) { string login; List <Veterinaires> listeVeto = new List <Veterinaires>(); SqlDataAdapter monAdapter = new SqlDataAdapter(); DataTable resultat = new DataTable(); SqlParameter monParametre; pNomVeto = pNomVeto.ToUpper(); pPrenomVeto = pPrenomVeto[0].ToString().ToUpper() + pPrenomVeto.Substring(1).ToLower(); pMotPasse = pMotPasse.ToUpper(); login = pNomVeto[0].ToString().ToUpper() + pPrenomVeto.ToLower(); SqlCommand cmd = (SqlCommand)cnx.CreateCommand(); cmd.CommandText = " exec ajout_Veterinaire @nomVeto, @motPasse, 0 ; exec ajout_UsersLogins @login, @motPasse"; monParametre = new SqlParameter("@nomVeto", pNomVeto + ' ' + pPrenomVeto); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@motPasse", pMotPasse); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@login", login); cmd.Parameters.Add(monParametre); monAdapter.SelectCommand = cmd; monAdapter.Fill(resultat); foreach (DataRow unVeto in resultat.Rows) { listeVeto.Add(new Veterinaires(unVeto)); } } }
public static void Add(Races maRace) { using (DbConnection cnx = ConnectionBDD.SeConnecter()) { SqlParameter monParametre; SqlCommand cmd = (SqlCommand)cnx.CreateCommand(); cmd.CommandText = " INSERT INTO Races(Race, Espece) " + " VALUES (@race, @espece);"; monParametre = new SqlParameter("@race", maRace.Race); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@espece", maRace.Espece); cmd.Parameters.Add(monParametre); try { cmd.ExecuteScalar(); } catch (Exception) { throw new Exception("Echec de l'insertion de la race"); } } }
public List <Clients> GetAll() { cnx = ConnectionBDD.SeConnecter(); try { DataTable maDataTable = new DataTable(); SqlDataAdapter monAdapter = new SqlDataAdapter(); List <Clients> listeClient = new List <Clients>(); SqlCommand cmd = (SqlCommand)cnx.CreateCommand(); cmd.CommandText = " SELECT * " + " FROM Clients " + " WHERE Archive = 0 ; "; monAdapter.SelectCommand = cmd; monAdapter.Fill(maDataTable); foreach (DataRow unClient in maDataTable.Rows) { listeClient.Add(new Clients(unClient)); } return(listeClient); } catch (Exception ex) { throw new Exception("Une erreur c'est produite lors de la séléction de tous les clients :\n" + ex.Message); } finally { cnx.Close(); } }
public static void supprimerVaccin(Guid pCodeVaccin) { using (DbConnection cnx = ConnectionBDD.SeConnecter()) { SqlParameter monParametre; SqlCommand cmd = (SqlCommand)cnx.CreateCommand(); cmd.CommandText = "update Vaccins set Archive = 1 where CodeVaccin = @codeVaccin"; monParametre = new SqlParameter("@codeVaccin", pCodeVaccin); cmd.Parameters.Add(monParametre); cmd.ExecuteNonQuery(); } }
public static void Delete(Consultation consultation) { using (DbConnection cnx = ConnectionBDD.SeConnecter()) { SqlParameter monParametre; SqlCommand cmd = (SqlCommand)cnx.CreateCommand(); cmd.CommandText = " DELETE FROM LignesConsultations WHERE CodeConsultation = @CodeConsultation ;" + " DELETE FROM Consultations WHERE CodeConsultation = @CodeConsultation; "; monParametre = new SqlParameter("@CodeConsultation", consultation.CodeConsultation); cmd.Parameters.Add(monParametre); cmd.ExecuteNonQuery(); } }
public static void ajouterVaccins(string pNomVaccin, int pQuantiteVaccin, int pPeriode) { using (DbConnection cnx = ConnectionBDD.SeConnecter()) { SqlParameter monParametre; SqlCommand cmd = (SqlCommand)cnx.CreateCommand(); cmd.CommandText = " exec ajout_vaccin @nomVaccin, @quantite, @periode"; monParametre = new SqlParameter("@nomVaccin", pNomVaccin); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@quantite", pQuantiteVaccin); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@periode", pPeriode); cmd.Parameters.Add(monParametre); cmd.ExecuteNonQuery(); } }
public void Update(Clients unClient) { cnx = ConnectionBDD.SeConnecter(); try { SqlParameter monParametre; SqlCommand cmd = (SqlCommand)cnx.CreateCommand(); cmd.CommandText = " UPDATE Clients " + " SET NomClient = @NomClient, PrenomClient = @PrenomClient, Adresse1 = @Adresse1, Adresse2 = @Adresse2, CodePostal = @CodePostal, Ville = @Ville, NumTel = @NumTel, Assurance = @Assurance, Email = @Email, Remarque = @Remarque, Archive = @Archive ; "; monParametre = new SqlParameter("@NomClient", unClient.NomClient); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@PrenomClient", unClient.PrenomClient); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@Adresse1", unClient.Adresse1); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@Adresse2", unClient.Adresse2); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@CodePostal", unClient.CodePostal); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@Ville", unClient.Ville); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@NumTel", unClient.NumTel); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@Assurance", unClient.Assurance); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@Email", unClient.Email); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@Remarque", unClient.Remarque); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@Archive", unClient.Archive); cmd.Parameters.Add(monParametre); cmd.ExecuteScalar(); } catch (Exception ex) { throw new Exception("Echec de la modification du client :\n" + ex.Message); } finally { cnx.Close(); } }
public static void Update(Consultation consultation) { using (DbConnection cnx = ConnectionBDD.SeConnecter()) { SqlParameter monParametre; SqlCommand cmd = (SqlCommand)cnx.CreateCommand(); cmd.CommandText = " UPDATE Consultations " + " SET Commentaire = @commentaire " + " WHERE CodeConsultation = @codeConsultation"; monParametre = new SqlParameter("@commentaire", consultation.Commentaire); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@codeConsultation", consultation.CodeConsultation); cmd.Parameters.Add(monParametre); cmd.ExecuteNonQuery(); } }
public static void supprimerVeto(Veterinaires veto) { using (DbConnection cnx = ConnectionBDD.SeConnecter()) { List <Veterinaires> listeVeto = new List <Veterinaires>(); SqlDataAdapter monAdapter = new SqlDataAdapter(); DataTable resultat = new DataTable(); SqlCommand cmd = (SqlCommand)cnx.CreateCommand(); cmd.CommandText = "update Veterinaires set Archive = 1 where CodeVeto = '" + veto.CodeVeto + "'"; monAdapter.SelectCommand = cmd; monAdapter.Fill(resultat); foreach (DataRow unVeto in resultat.Rows) { listeVeto.Add(new Veterinaires(unVeto)); } } }
public static void Delete(LignesConsultations pLigneConsultation) { using (DbConnection cnx = ConnectionBDD.SeConnecter()) { SqlParameter monParametre; SqlCommand cmd = (SqlCommand)cnx.CreateCommand(); cmd.CommandText = " DELETE FROM LignesConsultations " + " WHERE CodeConsultation = @codeConsultations " + " AND NumLigne = @NumLigne; "; monParametre = new SqlParameter("@codeConsultations", pLigneConsultation.CodeConsultation); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@NumLigne", pLigneConsultation.NumLigne); cmd.Parameters.Add(monParametre); cmd.ExecuteNonQuery(); } }
public void Add(Clients unClient) { cnx = ConnectionBDD.SeConnecter(); try { SqlParameter monParametre; SqlCommand cmd = (SqlCommand)cnx.CreateCommand(); cmd.CommandText = " exec ajout_client @NomClient, @PrenomClient, @Adresse1, @Adresse2, @CodePostal, @Ville, @NumTel, @Assurance, @Email, @Archive;"; monParametre = new SqlParameter("@NomClient", unClient.NomClient); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@PrenomClient", unClient.PrenomClient); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@Adresse1", unClient.Adresse1); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@Adresse2", unClient.Adresse2); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@CodePostal", unClient.CodePostal); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@Ville", unClient.Ville); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@NumTel", unClient.NumTel ?? String.Empty); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@Assurance", unClient.Assurance ?? String.Empty); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@Email", unClient.Email ?? String.Empty); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@Archive", unClient.Archive ?? false); cmd.Parameters.Add(monParametre); cmd.ExecuteScalar(); } catch (Exception ex) { throw new Exception("Echec de l'insertion d'un client :\n" + ex.Message); } finally { cnx.Close(); } }
public static List <Agendas> GetAgendaWithParams(Guid pCodeVeto, DateTime pDateRDV) { using (DbConnection cnx = ConnectionBDD.SeConnecter()) { SqlDataAdapter monAdapter = new SqlDataAdapter(); DataTable maDataTable = new DataTable(); List <Agendas> listeAgendas = new List <Agendas>(); Agendas monAgenda; SqlParameter monParametre; string maDteEnString = pDateRDV.ToShortDateString(); SqlCommand cmd = (SqlCommand)cnx.CreateCommand(); cmd.CommandText = " SELECT * " + " FROM Agendas Ag " + " INNER JOIN Veterinaires V ON Ag.CodeVeto = V.CodeVeto " + " INNER JOIN Animaux An ON Ag.CodeAnimal = An.CodeAnimal " + " INNER JOIN Clients C ON An.CodeClient = C.CodeClient " + " WHERE CONVERT (CHAR(10), Ag.DateRdv, 103) = @dateRDV " + " AND Ag.CodeVeto = @codeVeto " + " ORDER BY Ag.DateRdv"; monParametre = new SqlParameter("@dateRDV", maDteEnString); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@codeVeto", pCodeVeto); cmd.Parameters.Add(monParametre); monAdapter.SelectCommand = cmd; monAdapter.Fill(maDataTable); foreach (DataRow unAgendas in maDataTable.Rows) { monAgenda = new Agendas(unAgendas); monAgenda.NomAnimal = unAgendas["NomAnimal"].ToString(); monAgenda.NomClient = unAgendas["NomClient"].ToString(); monAgenda.PrenomClient = unAgendas["PrenomClient"].ToString(); monAgenda.Race = unAgendas["Race"].ToString(); listeAgendas.Add(monAgenda); } return(listeAgendas); } }
public static void updateVaccin(Guid pCodeVaccin, string pNomVaccin, int pQuantiteVaccin, int pPeriode) { using (DbConnection cnx = ConnectionBDD.SeConnecter()) { SqlParameter monParametre; SqlCommand cmd = (SqlCommand)cnx.CreateCommand(); cmd.CommandText = "update Vaccins set NomVaccin = @nomVaccin, QuantiteStock = @quantiteVaccin, " + "PeriodeValidite = @periode where CodeVaccin = @codeVaccin"; monParametre = new SqlParameter("@nomVaccin", pNomVaccin); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@quantiteVaccin", pQuantiteVaccin); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@periode", pPeriode); cmd.Parameters.Add(monParametre); monParametre = new SqlParameter("@codeVaccin", pCodeVaccin); cmd.Parameters.Add(monParametre); cmd.ExecuteNonQuery(); } }