public void Add(Misafir misafir)
{
ConnectionControl();
SqlCommand command = new SqlCommand("INSERT INTO Misafirler VALUES(@Ad,@Soyad,@KimlikId,@Telefon,@Email)", _connection);
command.Parameters.AddWithValue("@Ad", misafir.Ad);
command.Parameters.AddWithValue("@Soyad", misafir.Soyad);
command.Parameters.AddWithValue("@KimlikId", misafir.KimlikId);
command.Parameters.AddWithValue("@Telefon", misafir.Telefon);
command.Parameters.AddWithValue("@Email", misafir.Email);
command.ExecuteNonQuery();
_connection.Close();
}
public List <Misafir> GetMisafir()
{
ConnectionControl();
SqlCommand command = new SqlCommand("SELECT * FROM Misafirler ORDER BY Ad ASC", _connection);
SqlDataReader reader = command.ExecuteReader();
List <Misafir> misafirler = new List <Misafir>();
while (reader.Read())
{
Misafir misafir = new Misafir
{
Id = (int)reader["Id"],
Ad = reader["Ad"].ToString(),
Soyad = reader["Soyad"].ToString(),
KimlikId = reader["KimlikId"].ToString(),
Telefon = reader["Telefon"].ToString(),
Email = reader["Email"].ToString(),
};
misafirler.Add(misafir);
}
reader.Close();
_connection.Close();
return(misafirler);
}
