//Update category public Z_Consultant_Category UpdateCategory(CategoryModelForPost category) { //var query = _categoryRepository.TableNoTracking.AsQueryable(); var categoryDb = _categoryRepository.Table.Where(c => c.Id == category.Id).FirstOrDefault(); if (categoryDb == null) { return(null); } // query //query.Where(m => m.Id == category.Id); //var categoryDb = query.FirstOrDefault(); categoryDb.Name = category.Name; categoryDb.Description = category.Description; categoryDb.IsActive = category.IsActive; categoryDb.DateUpdated = DateTime.Now; _categoryRepository.Update(categoryDb); return(categoryDb); }
//Add category public Z_Consultant_Category AddCategory(CategoryModelForPost category) { var categoryDb = new Z_Consultant_Category { Name = category.Name, DateCreated = DateTime.Now, DateUpdated = DateTime.Now, Description = category.Description, IsActive = category.IsActive }; if (categoryDb != null) { _categoryRepository.Insert(categoryDb); } return(categoryDb); }