public bool DeleteCategory(int id) { try { CatagoryTbl obj = _dbentity.CatagoryTbls.Where(x => x.CategoryID_PK == id).FirstOrDefault(); _dbentity.CatagoryTbls.Remove(obj); _dbentity.SaveChanges(); return(true); } catch (Exception) { throw; } }
public bool UpdateCategory(CategoryModels editObj) { try { CatagoryTbl dbObj = _dbentity.CatagoryTbls.Where(x => x.CategoryID_PK == editObj.CategoryID_PK).FirstOrDefault(); dbObj.CategoryName = editObj.CategoryName; dbObj.CategoryDescription = editObj.CategoryDescription; dbObj.MinPrice = editObj.MinPriceRange; dbObj.MaxPrice = editObj.MaxPriceRange; dbObj.DisplayOrder = editObj.DisplayOrder; _dbentity.SaveChanges(); return(true); } catch (Exception ex) { throw; } }
public int CreateCategory(CategoryModels obj) { try { var dbData = new CatagoryTbl(); dbData.CategoryName = obj.CategoryName; dbData.CategoryDescription = obj.CategoryDescription; dbData.MinPrice = obj.MinPriceRange; dbData.MaxPrice = obj.MaxPriceRange; dbData.DisplayOrder = obj.DisplayOrder; _dbentity.CatagoryTbls.Add(dbData); _dbentity.SaveChanges(); return(dbData.CategoryID_PK); } catch (Exception ex) { throw; } }
public CategoryModels GetCategoryByID(int id) { try { CatagoryTbl catDtls = _dbentity.CatagoryTbls.Where(x => x.CategoryID_PK == id).FirstOrDefault(); CategoryModels obj = new CategoryModels(); obj.CategoryID_PK = catDtls.CategoryID_PK; obj.CategoryName = catDtls.CategoryName; obj.CategoryDescription = catDtls.CategoryDescription; obj.MinPriceRange = catDtls.MinPrice; obj.MaxPriceRange = catDtls.MaxPrice; obj.DisplayOrder = catDtls.DisplayOrder; return(obj); } catch (Exception ex) { throw; } }