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;
}
}
