public override void update(object obj) { try { GoodsImportEntity entity = obj as GoodsImportEntity; using (StoreManagementEntities context = new StoreManagementEntities()) { GoodsImportHistory old = context.GoodsImportHistories.Find(entity.ImportDate, entity.ProductID); int oldQuantity = old.Quantity; context.Entry(old).CurrentValues.SetValues(entity); Product product = context.Products.Find(entity.ProductID); product.Quantity = product.Quantity - oldQuantity + entity.Quantity; context.SaveChanges(); } } catch (Exception e) { CustomException ex = new CustomException(GetType().Name + " : Update " + obj.ToString() + "\n" + e.Message); ex.showPopupError(); } }
public override int insert(object obj) { try { GoodsImportEntity newEntity = obj as GoodsImportEntity; GoodsImportHistory entity = newEntity.Cast <GoodsImportHistory>(); using (StoreManagementEntities context = new StoreManagementEntities()) { context.GoodsImportHistories.Add(entity); Product product = context.Products.Find(entity.ProductID); product.Quantity += entity.Quantity; context.SaveChanges(); } return((int)entity.ImportDate.ToBinary()); } catch (Exception e) { CustomException ex = new CustomException(GetType().Name + " : Insert " + obj.ToString() + "\n" + e.Message); ex.showPopupError(); } return(-1); }
public override void delete(object obj) { try { GoodsImportEntity entity = obj as GoodsImportEntity; using (StoreManagementEntities context = new StoreManagementEntities()) { GoodsImportHistory delete = (from u in context.GoodsImportHistories where entity.ImportDate == u.ImportDate && entity.ProductID == u.ProductID select u).Single(); context.GoodsImportHistories.Remove(delete); Product product = context.Products.Find(entity.ProductID); product.Quantity -= entity.Quantity; context.SaveChanges(); } } catch (Exception e) { CustomException ex = new CustomException(GetType().Name + " : Delete " + obj.ToString() + "\n" + e.Message); ex.showPopupError(); } }