public static Acte GetActe(Guid codeActe) { Acte result = new Acte(); try { using (SqlConnection cnx = DALAccess.GetConnection()) { SqlCommand command = cnx.CreateCommand(); command.CommandType = System.Data.CommandType.Text; command.CommandText = "SELECT LC.CodeConsultation, LC.NumLigne, LC.CodeGroupement, LC.DateVigueur, LC.Prix, B.TypeActe, B.Libelle FROM LignesConsultations LC JOIN Baremes B ON LC.CodeGroupement = B.CodeGroupement WHERE LC.NumLigne = @codeActe AND LC.Archive = 0;"; command.Parameters.AddWithValue("@codeActe", codeActe); SqlDataReader dt = command.ExecuteReader(); int colCode = dt.GetOrdinal("CodeConsultation"); int colActe = dt.GetOrdinal("NumLigne"); int colGroup = dt.GetOrdinal("CodeGroupement"); int colDateVigueur = dt.GetOrdinal("DateVigueur"); int colPrix = dt.GetOrdinal("Prix"); int colType = dt.GetOrdinal("TypeActe"); int colLibelle = dt.GetOrdinal("Libelle"); while (dt.Read()) { result.numConsultation = dt.GetGuid(colCode); result.numActe = dt.GetGuid(colActe); result.codeGroupement = dt.GetString(colGroup); result.dateVigueur = dt.GetString(colDateVigueur); result.prix = dt.GetDecimal(colPrix); result.typeActe = dt.GetString(colType); result.libelle = dt.GetString(colLibelle); } } } catch (Exception ex) { throw new ApplicationException("Erreur : " + ex.Message); } return(result); }
public static int GetDernierCodeVaccin() { try { using (SqlConnection cnx = DALAccess.GetConnection()) { SqlCommand command = cnx.CreateCommand(); command.CommandType = System.Data.CommandType.Text; command.CommandText = "SELECT MAX(CodeGroupement) + 1 FROM Baremes WHERE TypeActe = 'VACC'"; String dResult = command.ExecuteScalar().ToString(); int resultat = int.Parse(dResult); return(resultat); } } catch (Exception ex) { throw new ApplicationException("Erreur : " + ex.Message); } }
public static List <Vaccin> GetVaccins() { List <Vaccin> list = new List <Vaccin>(); try { using (SqlConnection cnx = DALAccess.GetConnection()) { SqlCommand command = cnx.CreateCommand(); command.CommandType = System.Data.CommandType.Text; command.CommandText = "SELECT * FROM Vaccins WHERE Archive = 0 ORDER BY QuantiteStock"; SqlDataReader dt = command.ExecuteReader(); list = builderObject(dt); } } catch (Exception ex) { throw new ApplicationException("Erreur : " + ex.Message); } return(list); }
public static Guid AddVaccin(Vaccin leVaccin) { try { using (SqlConnection cnx = DALAccess.GetConnection()) { SqlCommand command = cnx.CreateCommand(); command.CommandType = System.Data.CommandType.Text; command.CommandText = "EXEC ajout_vaccin @nomvaccin, @periodevalidite, @quantite"; command.Parameters.AddWithValue("@nomvaccin", leVaccin.nomVaccin); command.Parameters.AddWithValue("@periodevalidite", leVaccin.periodeValidite); command.Parameters.AddWithValue("@quantite", leVaccin.quantiteStock); Guid dResult = (Guid)command.ExecuteScalar(); return(dResult); } } catch (Exception ex) { throw new ApplicationException("Erreur : " + ex.Message); } }
public static Guid AddConsultation(Consultation consultation) { try { using (SqlConnection cnx = DALAccess.GetConnection()) { SqlCommand command = cnx.CreateCommand(); command.CommandType = System.Data.CommandType.Text; command.CommandText = "EXEC ajout_consultation @dateconsultation, @codeVeto, @codeAnimal, @commentaire"; command.Parameters.AddWithValue("@dateconsultation", consultation.dateConsultation); command.Parameters.AddWithValue("@codeVeto", consultation.codeVeto); command.Parameters.AddWithValue("@codeAnimal", consultation.codeAnimal); command.Parameters.AddWithValue("@commentaire", consultation.commentaire == null ? String.Empty : consultation.commentaire); Guid dResult = (Guid)command.ExecuteScalar(); return(dResult); } } catch (Exception ex) { throw new ApplicationException("Erreur : " + ex.Message); } }
public static int AddLogin(Login login) { try { using (SqlConnection cnx = DALAccess.GetConnection()) { SqlCommand command = cnx.CreateCommand(); command.CommandType = System.Data.CommandType.Text; command.CommandText = "EXEC ajout_login @login, @password, 0;"; command.Parameters.AddWithValue("@login", login.loginUser); command.Parameters.AddWithValue("@password", login.passwordUser); Decimal dResult = (decimal)command.ExecuteScalar(); int resultat = (int)dResult; return(resultat); } } catch (Exception ex) { throw new ApplicationException("Erreur : " + ex.Message); } }
public static Guid AddFacture(Facture facture) { try { using (SqlConnection cnx = DALAccess.GetConnection()) { SqlCommand command = cnx.CreateCommand(); command.CommandType = System.Data.CommandType.Text; command.CommandText = "EXEC ajout_facture @DateFact, @nomVeto, @nomanimal, @dateConsultation, @etat"; command.Parameters.AddWithValue("@DateFact", facture.dateFacture); command.Parameters.AddWithValue("@nomVeto", facture.nomVeto); command.Parameters.AddWithValue("@nomanimal", facture.nomAnimal); command.Parameters.AddWithValue("@dateConsultation", facture.dateConsult); command.Parameters.AddWithValue("@etat", facture.etat); Guid dResult = (Guid)command.ExecuteScalar(); return(dResult); } } catch (Exception ex) { throw new ApplicationException("Erreur : " + ex.Message); } }
public static Veterinaire GetVeterinaireConnect(String User, String Passwd) { Veterinaire veto = new Veterinaire(); try { using (SqlConnection cnx = DALAccess.GetConnection()) { SqlCommand command = cnx.CreateCommand(); command.CommandType = System.Data.CommandType.Text; command.CommandText = "SELECT * FROM Veterinaires V JOIN Logins L ON V.RefLogin = L.ID WHERE L.Login = @login AND L.Password = @password"; command.Parameters.AddWithValue("@login", User); command.Parameters.AddWithValue("@password", Passwd); SqlDataReader dt = command.ExecuteReader(); int colId = dt.GetOrdinal("CodeVeto"); int colNom = dt.GetOrdinal("NomVeto"); int colArchive = dt.GetOrdinal("Archive"); int colRefLogin = dt.GetOrdinal("RefLogin"); while (dt.Read()) { veto.nomVeto = dt.GetString(colNom); veto.archive = dt.GetBoolean(colArchive); veto.refLogin = dt.GetInt32(colRefLogin); veto.codeVeto = dt.GetGuid(colId); } } } catch (Exception ex) { throw new ApplicationException("Erreur : " + ex.Message); } return(veto); }
public static bool CheckRDV(Guid codeVeto, DateTime laDate) { try { using (SqlConnection cnx = DALAccess.GetConnection()) { SqlCommand command = cnx.CreateCommand(); command.CommandType = System.Data.CommandType.Text; command.CommandText = "SELECT * FROM Agendas WHERE CodeVeto = @codeVeto AND DateRdv = @date"; command.Parameters.AddWithValue("@codeVeto", codeVeto); command.Parameters.AddWithValue("@date", laDate); SqlDataReader dt = command.ExecuteReader(); int resultat = 0; while (dt.Read()) { resultat++; } if (resultat == 0) { return(true); } else { return(false); } } } catch (Exception ex) { throw new ApplicationException("Erreur : " + ex.Message); } }