bazar.Accrual.UpdatePaid C# (CSharp) Method

        private void UpdatePaid()
        {
            string sql = "SELECT accrual_pay_id, SUM(sum) as sum FROM payment_details " +
                    "WHERE payment_id IN " +
                    "(SELECT id FROM payments WHERE accrual_id = @accrual_id) " +
                    "GROUP BY accrual_pay_id";
            TreeIter iter;

            MySqlCommand cmd = new MySqlCommand(sql, QSMain.connectionDB);
            cmd.Parameters.AddWithValue("@accrual_id", entryNumber.Text);
            MySqlDataReader rdr = cmd.ExecuteReader();

            decimal paid;
            foreach(object[] row in ServiceListStore)
            {
                row[(int)ServiceCol.paid_text] = String.Format ("{0:0.00}", 0);
                row[(int)ServiceCol.paid] = 0;
            }

            while (rdr.Read())
            {
                if( ListStoreWorks.SearchListStore (ServiceListStore, rdr.GetInt64("accrual_pay_id"), (int)ServiceCol.id, out iter))
                {
                    paid = rdr.GetDecimal ("sum");
                    ServiceListStore.SetValue (iter, (int)ServiceCol.paid_text, String.Format ("{0:0.00}", paid));
                    ServiceListStore.SetValue (iter, (int)ServiceCol.paid, paid);
                }
            }
            rdr.Close();
        }