public void Update(double sum, int id)
        {
            IDbConnection con = DBUtils.getConnection();

            using (var comm = con.CreateCommand())
            {
                comm.CommandText = "update Cases set TotalSum=@sum where Id=@id";
                IDbDataParameter paramSum = comm.CreateParameter();
                paramSum.ParameterName = "@sum";
                paramSum.Value         = sum;
                comm.Parameters.Add(paramSum);

                IDbDataParameter paramId = comm.CreateParameter();
                paramId.ParameterName = "@id";
                paramId.Value         = id;
                comm.Parameters.Add(paramId);
                var dataR = comm.ExecuteNonQuery();
                if (dataR == 0)
                {
                    throw new RepositoryException("No case updated!");
                }
            }
        }
        public IEnumerable <Case> FindAll()
        {
            IDbConnection con   = DBUtils.getConnection();
            IList <Case>  cases = new List <Case>();

            using (var comm = con.CreateCommand())
            {
                comm.CommandText = "select * from Cases";

                using (var dataR = comm.ExecuteReader())
                {
                    while (dataR.Read())
                    {
                        int    idV      = dataR.GetInt32(0);
                        String name     = dataR.GetString(1);
                        double totalSum = dataR.GetDouble(2);
                        Case   caz      = new Case(idV, name, totalSum);
                        cases.Add(caz);
                    }
                }
            }

            return(cases);
        }