public void AddSimcha(Simcha s) { SqlConnection connection = new SqlConnection(_connectionstring); SqlCommand command = connection.CreateCommand(); command.CommandText = @"INSERT INTO simchas(Name,Date) VALUES(@name,@date); SELECT @@Identity"; command.Parameters.AddWithValue("@name", s.Name); command.Parameters.AddWithValue("@date", s.Date); connection.Open(); s.Id = (int)(decimal)command.ExecuteScalar(); }
public IEnumerable <Simcha> GetAllSimchas() { SqlConnection connection = new SqlConnection(_connectionstring); SqlCommand command = connection.CreateCommand(); command.CommandText = "SELECT * FROM Simchas"; connection.Open(); SqlDataReader reader = command.ExecuteReader(); List <Simcha> simchas = new List <Simcha>(); while (reader.Read()) { Simcha s = new Simcha(); s.Id = (int)reader["Id"]; s.Name = (string)reader["Name"]; s.Date = (DateTime)reader["Date"]; s.Count = GetContributorCount(s.Id); s.Balance = GetBalanceForSimcha(s.Id); simchas.Add(s); } return(simchas); }