public void AddSimcha(Simcha simcha)
{
var connection = new SqlConnection(_connectionString);
SqlCommand cmd = connection.CreateCommand();
cmd.CommandText = "INSERT INTO Simchas " +
"(Name, Date) " +
"VALUES(@Name, @Date)";
cmd.Parameters.AddWithValue("@Name", simcha.Name);
cmd.Parameters.AddWithValue("@Date", simcha.Date);
connection.Open();
cmd.ExecuteNonQuery();
}
public Simcha GetSimcha(int Id)
{
var connection = new SqlConnection(_connectionString);
SqlCommand cmd = connection.CreateCommand();
cmd.CommandText = "SELECT * From Simchas WHERE Id = @id";
cmd.Parameters.AddWithValue("@id", Id);
connection.Open();
SqlDataReader reader = cmd.ExecuteReader();
if (!reader.Read())
{
return(null);
}
Simcha simcha = new Simcha();
simcha.Id = (int)reader["Id"];
simcha.Date = (DateTime)reader["Date"];
simcha.Name = (string)reader["Name"];
return(simcha);
}
