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