public void AddMedecin() { Medecin m = new Medecin(); Console.Write($"{Messages.MedecinNom}"); m.Nom = Console.ReadLine(); Console.Write($"{Messages.MedecinPrenom}"); m.Prenom = Console.ReadLine(); Console.Write($"{Messages.MedecinTelephone}"); m.Tel = Console.ReadLine(); Console.Write($"{Messages.MedecinSpecialite}"); foreach (Specialite s in GetSpecialite()) { Console.Write(s.CodeSpec.ToString() + " " + s.SpecialiteM + " / "); } m.CodeSpecialite = Convert.ToInt32(Console.ReadLine()); //string c = GetSpecialite().Find((x) => x.CodeSpec == m.CodeSpecialite).SpecialiteM; if (m.CodeSpecialite == 1) { m.IdService = 2; } else if (m.CodeSpecialite == 2) { m.IdService = 1; } else if (m.CodeSpecialite == 3) { m.IdService = 2; } else if (m.CodeSpecialite == 4) { m.IdService = 7; } else if (m.CodeSpecialite == 5) { m.IdService = 4; } else if (m.CodeSpecialite == 6) { m.IdService = 6; } else if (m.CodeSpecialite == 7) { m.IdService = 3; } SqlCommand command = new SqlCommand("INSERT INTO Medecin (Nom, Prenom, Tel, CodeSpecialite, IdService) OUTPUT INSERTED.ID VALUES(@n,@p,@t,@cs,@i)", Connection.Instance); command.Parameters.Add(new SqlParameter("@n", m.Nom)); command.Parameters.Add(new SqlParameter("@p", m.Prenom)); command.Parameters.Add(new SqlParameter("@t", m.Tel)); command.Parameters.Add(new SqlParameter("@cs", m.CodeSpecialite)); command.Parameters.Add(new SqlParameter("@i", m.IdService)); Connection.Instance.Open(); m.Id = (int)command.ExecuteScalar(); command.Dispose(); Connection.Instance.Close(); }
public List <Medecin> GetMedecinByName(string name) { SqlCommand command = new SqlCommand("SELECT m.Id, m.Nom, m.Prenom FROM Medecin as m where m.Nom= @name", Connection.Instance); command.Parameters.Add(new SqlParameter("@name", name)); Connection.Instance.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Medecin m = new Medecin() { Id = reader.GetInt32(0), Nom = reader.GetString(1), Prenom = reader.GetString(2), }; listeMedecins.Add(m); } reader.Close(); command.Dispose(); Connection.Instance.Close(); return(listeMedecins); }