コード例 #1
0
 public Product UpdateProduct(Product product)
 {
     using (var data = new MarketDbContext())
     {
         data.Entry(product).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
         data.SaveChanges();
     }
     return(product);
 }
 public Category UpdateCategory(Category categories)
 {
     using (var data = new MarketDbContext())
     {
         data.Entry(categories).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
         data.SaveChanges();
         return(categories);
     }
 }
 public Category AddCategory(Category categories)
 {
     using (var data = new MarketDbContext())
     {
         data.Categories.Add(categories);
         data.SaveChanges();
     }
     return(categories);
 }
        public Category GetById(int id)
        {
            Category categories = new Category();

            using (var data = new MarketDbContext())
            {
                categories = data.Categories.FirstOrDefault(x => x.Id == id);
            }
            return(categories);
        }
        public List <Category> GetAll()
        {
            List <Category> categories = new List <Category>();

            using (var data = new MarketDbContext())
            {
                categories = data.Categories.ToList();
            }
            return(categories);
        }
        public Category DeleteCategory(int id)
        {
            Category categories = new Category();

            using (var data = new MarketDbContext())
            {
                categories = data.Categories.FirstOrDefault(x => x.Id == id);
                data.Categories.Remove(categories);
                data.SaveChanges();
            }
            return(categories);
        }
コード例 #7
0
 public BaseDataService()
 {
     this.Db = new MarketDbContext();
 }