public void AddContribution(Contribution c)
        {
            GetFromDB    db     = new GetFromDB(_conStr);
            Contribution exists = db.GetContributions().Find(contribution => contribution.SimchaId == c.SimchaId &&
                                                             contribution.ContributorId == c.ContributorId);

            using (SqlConnection connection = new SqlConnection(_conStr))
                using (SqlCommand command = connection.CreateCommand())
                {
                    if (exists != null)
                    {
                        command.CommandText = "UPDATE Contributions SET Amount = @amount WHERE SimchaId = @simchaId AND ContributorId = @contributorId";
                    }
                    else
                    {
                        command.CommandText = "INSERT INTO Contributions (Amount, ContributorId, SimchaId) "
                                              + " VALUES (@amount, @contributorId, @simchaId)";
                    }
                    command.Parameters.AddWithValue("@amount", c.Amount);
                    command.Parameters.AddWithValue("@contributorId", c.ContributorId);
                    command.Parameters.AddWithValue("@simchaId", c.SimchaId);
                    connection.Open();
                    command.ExecuteNonQuery();
                }
        }
Exemplo n.º 2
0
        //public List<Contributor> GetContributors(string searchTerm)
        //{
        //    List<Contributor> result = new List<Contributor>();
        //    using (SqlConnection connection = new SqlConnection(_conStr))
        //    using (SqlCommand command = connection.CreateCommand())
        //    {
        //        command.CommandText = "SELECT * FROM Contributors WHERE FirstName LIKE @searchTerm OR LastName LIKE @searchTerm";
        //        command.Parameters.AddWithValue("@searchTerm", $"'%{searchTerm}%'");
        //        connection.Open();
        //        SqlDataReader reader = command.ExecuteReader();
        //        while (reader.Read())
        //        {
        //            Contributor c = new Contributor();
        //            c.Id = (int)reader["Id"];
        //            c.FirstName = (string)reader["FirstName"];
        //            c.LastName = (string)reader["LastName"];
        //            c.CellNumber = (string)reader["CellNumber"];
        //            c.DateCreated = (DateTime)reader["DateCreated"];
        //            c.AlwaysInclude = (bool)reader["AlwaysInclude"];
        //            result.Add(c);
        //        }
        //    }
        //    return result;
        //}
        //private List<Deposit> GetDeposits(int contributorId)
        //{
        //    List<Deposit> result = new List<Deposit>();
        //    using (SqlConnection connection = new SqlConnection(_conStr))
        //    using (SqlCommand command = connection.CreateCommand())
        //    {
        //        command.CommandText = "SELECT * FROM Deposits WHERE ContributorId = @id";
        //        command.Parameters.AddWithValue("@id", contributorId);
        //        connection.Open();
        //        SqlDataReader reader = command.ExecuteReader();
        //        while (reader.Read())
        //        {
        //            Deposit d = new Deposit();
        //            d.Amount = (decimal)reader["Amount"];
        //            d.Id = (int)reader["Id"];
        //            d.ContributorId = (int)reader["ContributorId"];
        //            result.Add(d);
        //        }
        //        return result;
        //    }
        //}
        public List <Contribution> GetContributions()
        {
            List <Contribution> result = new List <Contribution>();

            using (SqlConnection connection = new SqlConnection(_conStr))
                using (SqlCommand command = connection.CreateCommand())
                {
                    command.CommandText = "SELECT * FROM Contributions";
                    connection.Open();
                    SqlDataReader reader = command.ExecuteReader();
                    while (reader.Read())
                    {
                        Contribution c = new Contribution();
                        c.Amount        = (decimal)reader["Amount"];
                        c.SimchaId      = (int)reader["SimchaId"];
                        c.ContributorId = (int)reader["ContributorId"];
                        result.Add(c);
                    }
                    return(result);
                }
        }