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