public void DeleteCategory(int ID)
{
Models.DBObjects.Category categoryToDelete = dbContext.Categories.FirstOrDefault(x => x.CategoryID == ID);
if (categoryToDelete != null)
{
dbContext.Categories.DeleteOnSubmit(categoryToDelete);
dbContext.SubmitChanges();
}
}
public void UpdateCategory(CategoryModel categoryModel)
{
Models.DBObjects.Category existingCategory = dbContext.Categories.FirstOrDefault(x => x.CategoryID == categoryModel.CategoryID);
if (existingCategory != null)
{
existingCategory.CategoryID = categoryModel.CategoryID;
existingCategory.Name = categoryModel.Name;
existingCategory.Description = categoryModel.Description;
dbContext.SubmitChanges();
}
}
private Models.DBObjects.Category MapModelToDbObject(CategoryModel categoryModel)
{
Models.DBObjects.Category dbCategoryModel = new Models.DBObjects.Category();
if (categoryModel != null)
{
dbCategoryModel.CategoryID = categoryModel.CategoryID;
dbCategoryModel.Name = categoryModel.Name;
dbCategoryModel.Description = categoryModel.Description;
return(dbCategoryModel);
}
return(null);
}
private CategoryModel MapDbObjectToModel(Models.DBObjects.Category dbCategory)
{
CategoryModel categoryModel = new CategoryModel();
if (dbCategory != null)
{
categoryModel.CategoryID = dbCategory.CategoryID;
categoryModel.Name = dbCategory.Name;
categoryModel.Description = dbCategory.Description;
return(categoryModel);
}
return(null);
}
