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 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 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(); } }
protected override object convertToEntity(object obj) { if (obj == null) { throw new CustomException(GetType().Name + " : Converting to Entity Null Value"); } GoodsImportEntity entity = obj.Cast <GoodsImportEntity>(); return(entity); }
private void Xoa_Click(object sender, RoutedEventArgs e) { try { MessageBoxResult result = MessageBox.Show("Are you sure?", "Confirm", MessageBoxButton.YesNo, MessageBoxImage.Question); switch (result) { case MessageBoxResult.Yes: { try { ImportHistoryEntity tmp = (sender as Button).DataContext as ImportHistoryEntity; GoodsImportEntity entity = new GoodsImportEntity() { ImportDate = tmp.ImportDate, ProductID = tmp.ProductID, Quantity = tmp.Quantity }; (new GoodsImportDAO()).delete(entity); RefreshImportHistory(); MessageBox.Show("Xóa đơn nhập hàng thành công", "Result", MessageBoxButton.OK, MessageBoxImage.Information); Import_Product.LoadMain(); } catch { } } break; case MessageBoxResult.No: break; } } catch { MessageBox.Show("Đã xảy ra lỗi khi xóa. Vui lòng thử lại", "Error", MessageBoxButton.OK, MessageBoxImage.Error); } }
private void btn_Update_Click(object sender, RoutedEventArgs e) { int oldQuantity = int.Parse(txt_Quantity.Text); int importQuantity = int.Parse(txt_ImportQuantity.Text); if (oldQuantity + importQuantity <= 5) { MessageBox.Show("Cần nhập nhiều hơn mức tồn tối thiểu (5 sản phẩm)", "Error", MessageBoxButton.OK, MessageBoxImage.Error); return; } GoodsImportEntity entity = new GoodsImportEntity() { ImportDate = DateTime.Now, ProductID = int.Parse(txt_Id.Text), Quantity = int.Parse(txt_ImportQuantity.Text) }; GoodsImportDAO importDAO = new GoodsImportDAO(); importDAO.insert(entity); products.RemoveAll(temp => temp.ProductID == int.Parse(txt_Id.Text)); CollectionViewSource.GetDefaultView(listBox.ItemsSource).Refresh(); MessageBox.Show("Nhập hàng thành công", "Info", MessageBoxButton.OK, MessageBoxImage.Information); txt_ImportQuantity.Clear(); listBox.SelectedIndex = 0; ImportHistory.RefreshImportHistory(); }
public override object get(object ID, Type type = null) { GoodsImportEntity entity = null; try { DateTime ImportDate = (DateTime)ID?.GetType().GetProperty("ImportDate")?.GetValue(ID, null); int ProductID = (int)ID?.GetType().GetProperty("ProductID")?.GetValue(ID, null); using (StoreManagementEntities context = new StoreManagementEntities()) { entity = context.GoodsImportHistories.Find(ImportDate, ProductID).Cast <GoodsImportEntity>(); } } catch (Exception e) { CustomException ex = new CustomException(GetType().Name + " : Get " + ID + "\n" + e.Message); ex.showPopupError(); } return(entity); }
public override object getAll(Type type = null) { List <GoodsImportEntity> listGoodsImportEntities = new List <GoodsImportEntity>(); try { using (StoreManagementEntities context = new StoreManagementEntities()) { foreach (GoodsImportHistory obj in context.GoodsImportHistories) { GoodsImportEntity entity = obj.Cast <GoodsImportEntity>(); listGoodsImportEntities.Add(entity); } } } catch (Exception e) { CustomException ex = new CustomException(GetType().Name + " : GetAll \n" + e.Message); ex.showPopupError(); } return(listGoodsImportEntities); }