/// <summary>
/// Ajoute une spécificité en base
/// </summary>
public void AddSpecialite()
{
Specialite spec = new Specialite();
bool res = false;
_getSpec = new List <Specialite>();
_getSpec = ListAllSpec();
Console.WriteLine($"{Messages.TitreAjouterSpecialiteMedecin}");
Console.Write($"{ Messages.TitreNouvelleSpecialiteMedecin}");
spec.SpecialiteM = Console.ReadLine();
do
{
res = _getSpec.Exists(x => x.SpecialiteM.ToLower().Contains(spec.SpecialiteM.ToLower()));
if (res)
{
Messages.AfficherMessageErreur("Cette spécialité existe déjà");
Console.WriteLine(" ");
Console.Write($"{ Messages.TitreNouvelleSpecialiteMedecin} :");
spec.SpecialiteM = Console.ReadLine();
}
}while (res);
int max = _getSpec[0].CodeSpec;
for (int i = 1; i < _getSpec.Count; i++)
{
if (max <= _getSpec[i].CodeSpec)
{
max = _getSpec[i].CodeSpec;
}
}
max = max + 1;
SqlCommand command = new SqlCommand("INSERT INTO Spec (Specialite, CodeSpec) OUTPUT INSERTED.Id VALUES (@s, @c)", Connection.Instance);
command.Parameters.Add(new SqlParameter("@s", spec.SpecialiteM[0].ToString().ToUpper() + spec.SpecialiteM.Substring(1).ToLower()));
command.Parameters.Add(new SqlParameter("@c", max));
Connection.Instance.Open();
spec.Id = (int)command.ExecuteScalar();
command.Dispose();
Connection.Instance.Close();
Messages.AfficherMessageInsertOk(Messages.InsertOk);
}
public List <Specialite> GetSpecialite()
{
SqlCommand command = new SqlCommand("SELECT * FROM Spec", Connection.Instance);
Connection.Instance.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Specialite s = new Specialite()
{
Id = reader.GetInt32(0),
SpecialiteM = reader.GetString(1),
CodeSpec = reader.GetInt32(2)
};
listeSpecialites.Add(s);
}
reader.Close();
command.Dispose();
Connection.Instance.Close();
return(listeSpecialites);
}