public void AddSimcha(Simcha s) { using (SqlConnection connection = new SqlConnection(_conStr)) using (SqlCommand command = connection.CreateCommand()) { command.CommandText = "INSERT INTO Simchas (Name, Date) VALUES (@name, @date)"; command.Parameters.AddWithValue("@name", s.Name); command.Parameters.AddWithValue("@date", s.Date); connection.Open(); command.ExecuteNonQuery(); } }
public Simcha GetSimcha(int id) { Simcha simcha = new Simcha(); using (SqlConnection connection = new SqlConnection(_conStr)) using (SqlCommand command = connection.CreateCommand()) { command.CommandText = "SELECT * FROM Simchas WHERE Id = @id"; command.Parameters.AddWithValue("@id", id); connection.Open(); SqlDataReader reader = command.ExecuteReader(); reader.Read(); simcha.Id = (int)reader["Id"]; simcha.Date = (DateTime)reader["Date"]; simcha.Name = (string)reader["Name"]; } return(simcha); }