عملیات CRUD در ASP.NET Core MVC وبروزرسانی دات نت فریمورک – جلسه ۴۸

    public interface ICostRepository
    {
        Cost GetCostByID(int id);
        IEnumerable<Cost> GetAllCost();
        Cost Create(Cost NewCost);
        Cost Update(Cost UpdateCost);
        Cost Delete(int id);
    }

        public Cost Create(Cost NewCost)
        {
            costs.Add(NewCost);
            return NewCost;
        }

        public IEnumerable<Cost> GetAllCost()
        {
            return costs;
        }

        public Cost GetCostByID(int id)
        {
            return costs.FirstOrDefault(c => c.ID == id);
        }

        public Cost Update(Cost UpdateCost)
        {
            Cost SelectedCost = costs.FirstOrDefault(x => x.ID == UpdateCost.ID);
            if (SelectedCost != null)
            {
                SelectedCost.Amount = UpdateCost.Amount;
                SelectedCost.RegisteredDate = UpdateCost.RegisteredDate;
                SelectedCost.CategoryID = UpdateCost.CategoryID;
                SelectedCost.Comment = UpdateCost.Comment;
                SelectedCost.PaymentMethod = UpdateCost.PaymentMethod;
                return UpdateCost;
            }
            return null;
        }

        public Cost Delete(int id)
        {
            Cost SelectedCost = costs.FirstOrDefault(x => x.ID == id);
            if(SelectedCost!= null)
            {
                costs.Remove(SelectedCost);
                return SelectedCost;
            }
            return null;
        }

    public class StaticCostRepository : ICostRepository
    {
        private List<Cost> costs = new List<Cost>
        {
            new Cost{ID=1, Amount=100.00M,RegisteredDate=new DateTime(2022,02,19),CategoryID=1,Comment="New Record",PaymentMethod=PaymentMethods.Cash  },
            new Cost{ID=2, Amount=25.00M,RegisteredDate=new DateTime(2022,02,13),CategoryID=2,Comment="New Record",PaymentMethod=PaymentMethods.Credit  },
            new Cost{ID=3, Amount=700.00M,RegisteredDate=new DateTime(2022,02,11),CategoryID=3,Comment="New Record",PaymentMethod=PaymentMethods.Debit  }
        };

        public Cost Create(Cost NewCost)
        {
            costs.Add(NewCost);
            return NewCost;
        }

        public Cost Delete(int id)
        {
            Cost SelectedCost = costs.FirstOrDefault(x => x.ID == id);
            if(SelectedCost!= null)
            {
                costs.Remove(SelectedCost);
                return SelectedCost;
            }
            return null;
        }

        public IEnumerable<Cost> GetAllCost()
        {
            return costs;
        }

        public Cost GetCostByID(int id)
        {
            return costs.FirstOrDefault(c => c.ID == id);
        }

        public Cost Update(Cost UpdateCost)
        {
            Cost SelectedCost = costs.FirstOrDefault(x => x.ID == UpdateCost.ID);
            if (SelectedCost != null)
            {
                SelectedCost.Amount = UpdateCost.Amount;
                SelectedCost.RegisteredDate = UpdateCost.RegisteredDate;
                SelectedCost.CategoryID = UpdateCost.CategoryID;
                SelectedCost.Comment = UpdateCost.Comment;
                SelectedCost.PaymentMethod = UpdateCost.PaymentMethod;
                return UpdateCost;
            }
            return null;
        }
    }

    public class WebAppDBContext : DbContext
    {
        public WebAppDBContext(DbContextOptions<WebAppDBContext> options) : base(options)
        {
        }
        public DbSet<Category> Categories { get; set; }
        public DbSet<Cost> Costs { get; set; }
    }

    public class SQLServerCostRepository : ICostRepository
    {
        private readonly WebAppDBContext context;

        public SQLServerCostRepository(WebAppDBContext _context)
        {
            context = _context;
        }
    }

        public Cost Create(Cost NewCost)
        {
            context.Costs.Add(NewCost);
            context.SaveChanges();
            return NewCost;
        }

        public IEnumerable<Cost> GetAllCost()
        {
            return context.Costs;
        }

        public Cost GetCostByID(int id)
        {
            return context.Costs.FirstOrDefault(x => x.ID == id);
        }

        public Cost Update(Cost UpdateCost)
        {
            Cost SelectedCost = context.Costs.FirstOrDefault(x => x.ID == UpdateCose.ID);
            if (SelectedCost != null)
            {
                SelectedCost.Amount = UpdateCose.Amount;
                SelectedCost.RegisteredDate = UpdateCose.RegisteredDate;
                SelectedCost.CategoryID = UpdateCose.CategoryID;
                SelectedCost.Comment = UpdateCose.Comment;
                SelectedCost.PaymentMethod = UpdateCose.PaymentMethod;
                context.SaveChanges();
                return UpdateCose;
            }
            return null;
        }

        public Cost Update(Cost UpdateCost)
        {
            var SelectedCost = context.Costs.Attach(UpdateCost);
            SelectedCost.State = Microsoft.EntityFrameworkCore.EntityState.Modified;
            context.SaveChanges();
            return UpdateCost;
        }

    public class SQLServerCostRepository : ICostRepository
    {
        private readonly WebAppDBContext context;

        public SQLServerCostRepository(WebAppDBContext _context)
        {
            context = _context;
        }
        public Cost Create(Cost NewCost)
        {
            context.Costs.Add(NewCost);
            context.SaveChanges();
            return NewCost;
        }

        public Cost Delete(int id)
        {
            Cost SelectedCost = context.Costs.FirstOrDefault(x => x.ID == id);
            if (SelectedCost != null)
            {
                context.Costs.Remove(SelectedCost);
                context.SaveChanges();
                return SelectedCost;
            }
            return null;
        }

        public IEnumerable<Cost> GetAllCost()
        {
            return context.Costs;
        }

        public Cost GetCostByID(int id)
        {
            return context.Costs.FirstOrDefault(x => x.ID == id);
        }

        public Cost Update(Cost UpdateCost)
        {
            var SelectedCost = context.Costs.Attach(UpdateCost);
            SelectedCost.State = Microsoft.EntityFrameworkCore.EntityState.Modified;
            context.SaveChanges();
            return UpdateCost;
        }
    }

        public void ConfigureServices(IServiceCollection services)
        {
            services.AddDbContextPool<WebAppDBContext>
                (options=> options.UseSqlServer(Configuration.GetConnectionString("CostDBConnectionSQLServer")));
            services.AddControllersWithViews();
            services.AddScoped<ICostRepository, SQLServerCostRepository>();
        }