apibendrintas duomenų tvarkymo (CRUD) aprašas

CRUD.cs

// atmintinė https://docs.google.com/document/d/1K9GQRF5N5pjGiUUrfWpVSkXM13LSWuG8IV4uorEKG3E/edit
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

using WpfApplication3_Finansai; // naudoja Babkes

// reik suinstaliuot nuget paketą linq2db.mysql
using DataModels;
using LinqToDB; 
using LinqToDB.Common;

namespace DUOM_CRUD   // galite pasikeisti
{

    public interface IRepository<T> // saugykla
    {
        // interface members
        void Add(T obj);
        T Retrieve(int nr);
        void Update(int nr, T obj);
        void Delete(int nr);

        IEnumerable<T> List();
        //IEnumerable<T> List(Expression<Func<T, bool>> predicate);

    }

    class FinansaiList : IRepository<Babkes>
    {
        List<Babkes> items;

        FinansaiList() { items = new List<Babkes>(); }

        public void Add(Babkes obj)
        {
            items.Add(obj);
        }

        public Babkes Retrieve(int nr)
        {
            return items[nr];
        }

        public void Update(int nr, Babkes obj)
        {
            items[nr] = obj;
        }

        public void Delete(int nr)
        {
            items.RemoveAt(nr);
        }

        public IEnumerable<Babkes> List() { return items; }
    }


    class FinansaiDB : IRepository<finansai>
    {



        public void Add(finansai obj)
        {
            using (var db = new DataModels.demoDB())
            {
                db.Insert(obj);
            }

        }

        public finansai Retrieve(int nr)
        {
           using (var db = new DataModels.demoDB())
            {

                var q = from b in db.finansai
                        where b.ID == nr
                        select b;

                return q.First();
            }
        }

        public void Update(int nr, finansai obj)
        {
            using (var db = new DataModels.demoDB())
            {
                //db.finansai
                //   .Where(p => p.ID == obj.ID)
                   //.Set(p => p.kas, obj.kas)
                   //.Set(p => p.kiek, obj.kiek)
                   //.Update(obj);

                db.Update(obj);
            }

        }

        public void Delete(int nr)
        {
            using (var db = new DataModels.demoDB())
            {
                db.finansai
                    .Where(p => p.ID==nr)
                    .Delete();
            }
        }

        public IEnumerable<finansai> List()
        {
            using (var db = new DataModels.demoDB())
            {
                
                var q = 
                    from c in db.finansai
                    select c;

                return q.ToList();
            }
        }
    }

}