private static List <Telephone> GetListNumero(int idCli)
{
var list = new List <Telephone>();
// Demande de la liste des clients
var cmd = new SqlCommand();
cmd.CommandText = @"select T.Numero
from Client C
inner join Adresse A on A.IdClient = C.Id
inner join Telephone T on T.IdClient = C.Id
where C.Id= @IdClient";
cmd.Parameters.Add(new SqlParameter {
SqlDbType = SqlDbType.Int, ParameterName = "@IdClient", Value = idCli
});
using (var conn = new SqlConnection(Settings1.Default.GrandHotelConnexion))
{
//Connection à la base de données
cmd.Connection = conn;
conn.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var item = new Telephone();
item.Numero = (string)reader["Numero"];
list.Add(item);
}
}
}
return(list);
}
/*--> Ajouter un numero de téléphone */
public static void AjouterTelephone(Telephone t)
{
var cmd = new SqlCommand();
cmd.CommandText = @"insert Telephone (IdClient, Numero, CodeType, Pro)
values (@IdClient, @Numero, @CodeType, @Pro)" ;
cmd.Parameters.Add(new SqlParameter {
SqlDbType = SqlDbType.Int, ParameterName = "@IdClient", Value = t.IdClient
});
cmd.Parameters.Add(new SqlParameter {
SqlDbType = SqlDbType.NVarChar, ParameterName = "@Numero", Value = t.Numero
});
cmd.Parameters.Add(new SqlParameter {
SqlDbType = SqlDbType.NVarChar, ParameterName = "@CodeType", Value = t.CodeType
});
cmd.Parameters.Add(new SqlParameter {
SqlDbType = SqlDbType.Bit, ParameterName = "@Pro", Value = t.Pro
});
using (var cnx = new SqlConnection(Settings1.Default.GrandHotelConnexion))
{
cmd.Connection = cnx;
cnx.Open();
cmd.ExecuteNonQuery();
}
}
public void AjouterTeleOuMail(Telephone tele, Email mail, bool?a)
{
// ajout Telephone
if (a == true)
{
Telephones.Add(tele);
SaveChanges();
}
// ajout email
else
{
Emails.Add(mail);
SaveChanges();
}
}