public void InsertContributor(Contributor contributor) { SqlConnection connection = new SqlConnection(_connectionString); SqlCommand cmd = connection.CreateCommand(); cmd.CommandText = @"INSERT INTO Contributors VALUES (@firstName, @lastName, @cellNumber, @date, @alwaysInclude) SELECT SCOPE_IDENTITY()"; cmd.Parameters.AddWithValue("@firstName", contributor.FirstName); cmd.Parameters.AddWithValue("@lastName", contributor.LastName); cmd.Parameters.AddWithValue("@cellNumber", contributor.CellNumber); cmd.Parameters.AddWithValue("@date", contributor.Date); cmd.Parameters.AddWithValue("@alwaysInclude", contributor.AlwaysInclude); connection.Open(); contributor.Id = (int)(decimal)cmd.ExecuteScalar(); connection.Close(); connection.Dispose(); }
public void UpdateContributor(Contributor contributor) { SqlConnection connection = new SqlConnection(_connectionString); SqlCommand cmd = connection.CreateCommand(); cmd.CommandText = @"UPDATE Contributors SET FirstName = @firstName, LastName = @lastName, CellNumber = @cellNumber, Date = @date, AlwaysInclude = @alwaysInclude WHERE id = @id"; cmd.Parameters.AddWithValue("@firstName", contributor.FirstName); cmd.Parameters.AddWithValue("@lastName", contributor.LastName); cmd.Parameters.AddWithValue("@cellNumber", contributor.CellNumber); cmd.Parameters.AddWithValue("@date", contributor.Date); cmd.Parameters.AddWithValue("@alwaysInclude", contributor.AlwaysInclude); cmd.Parameters.AddWithValue("@id", contributor.Id); connection.Open(); cmd.ExecuteNonQuery(); connection.Close(); connection.Dispose(); }