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); }