public int CreateProduct(ProductModel pm) { int result = DaoUtilities.NO_CHANGES; PRODUCT p = db.PRODUCT.Create(); p.PRODUCT_ID = pm.ProductId; p.PRODUCT_NAME = pm.Name; p.PRODUCT_DESCRIPTION = pm.Description; p.PRODUCT_AVAILABLEQUANTITY = pm.AvailableQuantity; p.PRODUCT_MEMBERREDUCTION = pm.MemberReduction; p.PRODUCT_CAT = pm.CategoryId; p.PRODUCT_USERID = pm.UserId; p.PRODUCT_PRICE = pm.Price; db.PRODUCT.Add(p); 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 DeleteProduct(ProductModel pm) { int result = DaoUtilities.NO_CHANGES; PRODUCT p = db.PRODUCT.Find(pm.ProductId); if (p != null) { db.PRODUCT.Remove(p); 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 product from the database to a ProductModel /// </summary> /// <param name="p"></param> /// <returns></returns> public ProductModel ConvertProductToProductModel(PRODUCT p) { ProductModel pm = new ProductModel(); if (p != null) { pm.ProductId = p.PRODUCT_ID; pm.Name = p.PRODUCT_NAME; pm.Description = p.PRODUCT_DESCRIPTION; pm.AvailableQuantity = p.PRODUCT_AVAILABLEQUANTITY; pm.MemberReduction = p.PRODUCT_MEMBERREDUCTION; pm.CategoryId = p.PRODUCT_CAT; pm.UserId = p.PRODUCT_USERID; pm.Price = p.PRODUCT_PRICE; } else pm = null; return pm; }