public int CreateCategory(CategoryModel cm) { int result = DaoUtilities.NO_CHANGES; CATEGORY c = db.CATEGORY.Create(); c.CAT_ID = cm.CategoryId; c.CAT_NAME = cm.Name; c.CAT_DESCR = cm.Description; c.CAT_VALIDATIONDATE = cm.ValidationDate; c.CAT_PARENT = cm.ParentId; db.CATEGORY.Add(c); try { int saveResult = db.SaveChanges(); if (saveResult == 1) result = DaoUtilities.SAVE_SUCCESSFUL; } catch (DbUpdateConcurrencyException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.UPDATE_CONCURRENCY_EXCEPTION; } catch (DbUpdateException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.UPDATE_EXCEPTION; } catch (DbEntityValidationException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.ENTITY_VALIDATION_EXCEPTION; } catch (NotSupportedException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.UNSUPPORTED_EXCEPTION; } catch (ObjectDisposedException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.DISPOSED_EXCEPTION; } catch (InvalidOperationException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.INVALID_OPERATION_EXCEPTION; } return result; }
public int DeleteCategory(CategoryModel cm) { int result = DaoUtilities.NO_CHANGES; CATEGORY c = db.CATEGORY.Find(cm.CategoryId); if (c != null) { db.CATEGORY.Remove(c); try { int saveResult = db.SaveChanges(); if (saveResult == 1) result = DaoUtilities.SAVE_SUCCESSFUL; } catch (DbUpdateConcurrencyException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.UPDATE_CONCURRENCY_EXCEPTION; } catch (DbUpdateException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.UPDATE_EXCEPTION; } catch (DbEntityValidationException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.ENTITY_VALIDATION_EXCEPTION; } catch (NotSupportedException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.UNSUPPORTED_EXCEPTION; } catch (ObjectDisposedException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.DISPOSED_EXCEPTION; } catch (InvalidOperationException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.INVALID_OPERATION_EXCEPTION; } } return result; }
/// <summary> /// Convert a category from the database to a CategoryModel /// </summary> /// <param name="c"></param> /// <returns></returns> public CategoryModel ConvertCategoryToCategoryModel(CATEGORY c) { CategoryModel cm = new CategoryModel(); if (c != null) { cm.CategoryId = c.CAT_ID; cm.Name = c.CAT_NAME; cm.Description = c.CAT_DESCR; cm.ValidationDate = c.CAT_VALIDATIONDATE; cm.ParentId = c.CAT_PARENT; } else cm = null; return cm; }