private void crud_modal_IsVisibleChanged(object sender, DependencyPropertyChangedEventArgs e) { // Selecteditem_movement = itemMovement.item_movement; if (crud_modal.Visibility == Visibility.Hidden) { item_transfer item_transfer = item_transferViewSource.View.CurrentItem as item_transfer; if (item_transfer != null) { item_transfer_detail item_transfer_detail = new item_transfer_detail(); item_transfer_detail.id_item_product = ((item)cbxItem.Data).item_product.FirstOrDefault().id_item_product; item_transfer_detail.item_product = ((item)cbxItem.Data).item_product.FirstOrDefault(); item_transfer_detail.movement_id = (int)itemMovement.item_movement.id_movement; item_transfer_detail.quantity_destination = 1; item_transfer_detail.quantity_origin = 1; item item = ((item)cbxItem.Data); foreach (item_movement_dimension item_movement_dimension in itemMovement.item_movement.item_movement_dimension) { item_transfer_dimension item_transfer_dimension = new item_transfer_dimension(); item_transfer_dimension.id_transfer_detail = item_transfer_detail.id_transfer_detail; item_transfer_dimension.id_dimension = item_movement_dimension.id_dimension; if (dbContext.app_dimension.Where(x => x.id_dimension == item_movement_dimension.id_dimension).FirstOrDefault() != null) { item_transfer_dimension.app_dimension = dbContext.app_dimension.Where(x => x.id_dimension == item_movement_dimension.id_dimension).FirstOrDefault(); } item_transfer_dimension.value = item_movement_dimension.value; item_transfer_detail.item_transfer_dimension.Add(item_transfer_dimension); } item_transfer.item_transfer_detail.Add(item_transfer_detail); } CollectionViewSource item_transferitem_transfer_detailViewSource = ((CollectionViewSource)(FindResource("item_transferitem_transfer_detailViewSource"))); item_transferitem_transfer_detailViewSource.View.Refresh(); } }
void insertDetail() { item_transfer item_transfer = item_transferViewSource.View.CurrentItem as item_transfer; item item = ((item)cbxItem.Data); if (item != null) { if (item.item_dimension.Count() > 0) { crud_modal.Children.Clear(); itemMovement.id_item = (int)((item)cbxItem.Data).id_item; itemMovement.id_location = item_transfer.app_location_origin.id_location; itemMovement.db = ProductMovementDB; crud_modal.Visibility = Visibility.Visible; crud_modal.Children.Add(itemMovement); } else { if (item_transfer != null) { item_transfer_detail item_transfer_detail = new item_transfer_detail(); item_transfer_detail.id_item_product = ((item)cbxItem.Data).item_product.FirstOrDefault().id_item_product; item_transfer_detail.item_product = ((item)cbxItem.Data).item_product.FirstOrDefault(); item_transfer_detail.quantity_destination = 1; item_transfer_detail.quantity_origin = 1; if (itemMovement.item_movement != null) { if (itemMovement.item_movement.item_movement_dimension != null) { foreach (item_movement_dimension item_movement_dimension in itemMovement.item_movement.item_movement_dimension) { item_transfer_dimension item_transfer_dimension = new item_transfer_dimension(); item_transfer_dimension.id_transfer_detail = item_transfer_detail.id_transfer_detail; item_transfer_dimension.id_dimension = item_movement_dimension.id_dimension; if (dbContext.app_dimension.Where(x => x.id_dimension == item_movement_dimension.id_dimension).FirstOrDefault() != null) { item_transfer_dimension.app_dimension = dbContext.app_dimension.Where(x => x.id_dimension == item_movement_dimension.id_dimension).FirstOrDefault(); } item_transfer_dimension.value = item_movement_dimension.value; item_transfer_detail.item_transfer_dimension.Add(item_transfer_dimension); } } } item_transfer.item_transfer_detail.Add(item_transfer_detail); } CollectionViewSource item_transferitem_transfer_detailViewSource = ((CollectionViewSource)(FindResource("item_transferitem_transfer_detailViewSource"))); item_transferitem_transfer_detailViewSource.View.Refresh(); } } }
private void crud_modal_IsVisibleChanged(object sender, DependencyPropertyChangedEventArgs e) { item item = ProductTransferDB.items.Where(x => x.id_item == sbxItem.ItemID).FirstOrDefault(); item_transfer item_transfer = item_transferViewSource.View.CurrentItem as item_transfer; if (crud_modal.Visibility == Visibility.Hidden) { if (item != null && item.item_product != null && item_transfer != null && item.id_item_type != entity.item.item_type.Task && item.id_item_type != entity.item.item_type.Service && item.id_item_type != entity.item.item_type.ServiceContract) { item_transfer_detail item_transfer_detail = new item_transfer_detail(); item_transfer_detail.status = Status.Documents_General.Pending; item_transfer_detail.quantity_origin = 1; item_transfer_detail.timestamp = DateTime.Now; item_transfer_detail.movement_id = (int)itemMovement.item_movement.id_movement; item_transfer_detail.item_product = item.item_product.FirstOrDefault(); item_transfer_detail.id_item_product = item_transfer_detail.item_product.id_item_product; item_transfer_detail.Quantity_InStock = (decimal)StockCalculations.Count_ByBranch((int)id_branch_originComboBox.SelectedValue, item_transfer_detail.item_product.id_item, DateTime.Now); item_transfer_detail.RaisePropertyChanged("item_product"); foreach (item_movement_dimension item_movement_dimension in itemMovement.item_movement.item_movement_dimension) { item_transfer_dimension item_transfer_dimension = new item_transfer_dimension(); item_transfer_dimension.id_transfer_detail = item_transfer_detail.id_transfer_detail; item_transfer_dimension.id_dimension = item_movement_dimension.id_dimension; if (ProductTransferDB.app_dimension.Where(x => x.id_dimension == item_movement_dimension.id_dimension).FirstOrDefault() != null) { item_transfer_dimension.app_dimension = ProductTransferDB.app_dimension.Where(x => x.id_dimension == item_movement_dimension.id_dimension).FirstOrDefault(); } item_transfer_dimension.value = item_movement_dimension.value; item_transfer_detail.item_transfer_dimension.Add(item_transfer_dimension); } item_transfer.item_transfer_detail.Add(item_transfer_detail); } else { toolBar.msgWarning("Item Error"); } item_transferViewSource.View.Refresh(); item_transferitem_transfer_detailViewSource.View.Refresh(); } }
private void btnSave_Click(object sender, RoutedEventArgs e) { IEnumerable <DbEntityValidationResult> validationresult = entity.db.GetValidationErrors(); if (validationresult.Count() == 0) { for (int i = 0; i < item_transfer_detailDataGrid.Items.Count - 1; i++) { item_transfer_detail item = (item_transfer_detail)item_transfer_detailDataGrid.Items[i]; item_movement item_movement_origin = new item_movement(); item_movement_origin.debit = 0; item_movement_origin.credit = item.quantity_origin; item_movement_origin.id_location = item.item_transfer.app_location_origin.id_location; // item_movement_origin.transaction_id = 0; item_movement_origin.status = Status.Stock.InStock; item_movement_origin.trans_date = item.item_transfer.trans_date; if (item.item_product.id_item_product != 0) { if (entity.db.item_product.Where(x => x.id_item_product == item.id_item_product).FirstOrDefault() != null) { item_movement_origin.id_item_product = entity.db.item_product.Where(x => x.id_item_product == item.id_item_product).FirstOrDefault().id_item_product; } } entity.db.item_movement.Add(item_movement_origin); item_movement item_movement_dest = new item_movement(); item_movement_dest.debit = item.quantity_destination; item_movement_dest.credit = 0; item_movement_dest.id_location = item.item_transfer.app_location_destination.id_location; //item_movement_dest.transaction_id = 0; item_movement_dest.status = Status.Stock.InStock; item_movement_dest.trans_date = item.item_transfer.trans_date; if (item.item_product.id_item_product != 0) { if (entity.db.item_product.Where(x => x.id_item_product == item.id_item_product).FirstOrDefault() != null) { item_movement_dest.id_item_product = entity.db.item_product.Where(x => x.id_item_product == item.id_item_product).FirstOrDefault().id_item_product; } } entity.db.item_movement.Add(item_movement_dest); } entity.SaveChanges(); } }
private void toolBar_btnApprove_Click(object sender) { item_transfer item_transfer = item_transferViewSource.View.CurrentItem as item_transfer; if ((item_transfer.number == null || item_transfer.number == string.Empty) && item_transfer.app_document_range != null) { entity.Brillo.Logic.Document _Document = new entity.Brillo.Logic.Document(); if (item_transfer.id_branch > 0) { if (dbContext.app_branch.Where(x => x.id_branch == item_transfer.id_branch).FirstOrDefault() != null) { entity.Brillo.Logic.Range.branch_Code = dbContext.app_branch.Where(x => x.id_branch == item_transfer.id_branch).FirstOrDefault().code; } } if (item_transfer.id_terminal > 0) { if (dbContext.app_terminal.Where(x => x.id_terminal == item_transfer.id_terminal).FirstOrDefault() != null) { entity.Brillo.Logic.Range.terminal_Code = dbContext.app_terminal.Where(x => x.id_terminal == item_transfer.id_terminal).FirstOrDefault().code; } } if (item_transfer.id_user > 0) { if (dbContext.security_user.Where(x => x.id_user == item_transfer.id_user).FirstOrDefault() != null) { entity.Brillo.Logic.Range.user_Code = dbContext.security_user.Where(x => x.id_user == item_transfer.id_user).FirstOrDefault().code; } } if (item_transfer.id_project > 0) { if (dbContext.projects.Where(x => x.id_project == item_transfer.id_project).FirstOrDefault() != null) { entity.Brillo.Logic.Range.project_Code = dbContext.projects.Where(x => x.id_project == item_transfer.id_project).FirstOrDefault().code; } } app_document_range app_document_range = item_transfer.app_document_range; item_transfer.number = entity.Brillo.Logic.Range.calc_Range(app_document_range, true); } item_transfer.user_requested = dbContext.security_user.Where(x => x.id_user == CurrentSession.Id_User).FirstOrDefault(); item_transfer.user_given = dbContext.security_user.Where(x => x.id_user == CurrentSession.Id_User).FirstOrDefault(); item_transfer.status = Status.Transfer.Approved; dbContext.SaveChanges(); for (int i = 0; i < item_transfer_detailDataGrid.Items.Count; i++) { entity.Brillo.Logic.Stock stock = new entity.Brillo.Logic.Stock(); item_transfer_detail item_transfer_detail = (item_transfer_detail)item_transfer_detailDataGrid.Items[i]; List <entity.Brillo.StockList> Items_InStockLIST; app_currencyfx app_currencyfx = ProductMovementDB.app_currencyfx.Where(x => x.app_currency.is_active).FirstOrDefault(); app_location app_location = item_transfer_detail.item_transfer.app_location_origin; if (itemMovement.item_movement != null) { entity.Brillo.Stock stockBrillo = new entity.Brillo.Stock(); Items_InStockLIST = stockBrillo.ScalarMovement(itemMovement.item_movement); } else { entity.Brillo.Stock stockBrillo = new entity.Brillo.Stock(); Items_InStockLIST = stockBrillo.List(app_location.app_branch, app_location, item_transfer_detail.item_product); } ///Debit Movement from Origin. List <item_movement> item_movement_originList; item_movement_originList = stock.DebitOnly_MovementLIST(ProductMovementDB, Items_InStockLIST, Status.Stock.InStock, entity.App.Names.Movement, item_transfer_detail.id_transfer, item_transfer_detail.id_transfer_detail, app_currencyfx, item_transfer_detail.item_product, app_location, item_transfer_detail.quantity_origin, item_transfer_detail.item_transfer.trans_date, stock.comment_Generator(entity.App.Names.Movement, item_transfer_detail.item_transfer.number != null ? item_transfer_detail.item_transfer.number.ToString() : "", "")); ProductMovementDB.item_movement.AddRange(item_movement_originList); //Credit Movement to Destination item_movement item_movement_dest; item_movement parent_item_movement = item_movement_originList.FirstOrDefault(); List <item_movement_dimension> DimensionList = null; if (item_movement_originList.FirstOrDefault().item_movement_dimension.Count() > 0) { DimensionList = new List <item_movement_dimension>(); foreach (item_movement_dimension item_movement_dimension in item_movement_originList.FirstOrDefault().item_movement_dimension) { item_movement_dimension _item_movement_dimension = new item_movement_dimension(); _item_movement_dimension.id_dimension = item_movement_dimension.id_dimension; _item_movement_dimension.value = item_movement_dimension.value; DimensionList.Add(_item_movement_dimension); } } item_movement_dest = stock.CreditOnly_Movement( Status.Stock.InStock, entity.App.Names.Movement, item_transfer_detail.id_transfer, item_transfer_detail.id_transfer_detail, app_currencyfx, item_transfer_detail.item_product, item_transfer_detail.item_transfer.app_location_destination, item_transfer_detail.quantity_destination, item_transfer_detail.item_transfer.trans_date, item_movement_originList.Sum(x => (x.item_movement_value.Sum(y => y.unit_value) / (x.item_movement_value.Count() != 0 ? x.item_movement_value.Count() : 1))), stock.comment_Generator(entity.App.Names.Movement, item_transfer_detail.item_transfer.number != null ? item_transfer_detail.item_transfer.number.ToString() : "", ""), DimensionList ); //item_movement_dest._parent = Items_InStockLIST.FirstOrDefault(); ProductMovementDB.item_movement.Add(item_movement_dest); item_transfer.status = Status.Transfer.Approved; } if (item_transfer.status == Status.Transfer.Approved && item_transfer.app_document_range != null) { entity.Brillo.Document.Start.Automatic(item_transfer, item_transfer.app_document_range); } if (ProductMovementDB.SaveChanges() > 0) { toolBar.msgSaved(ProductMovementDB.NumberOfRecords); itemMovement = new Configs.itemMovement(); } }
private void SmartBox_Item_Select(object sender, RoutedEventArgs e) { item_transfer item_transfer = item_transferViewSource.View.CurrentItem as item_transfer; item item = ProductTransferDB.items.Where(x => x.id_item == sbxItem.ItemID).FirstOrDefault(); if (item != null) { if (item.item_dimension.Count() > 0) { crud_modal.Children.Clear(); itemMovement.id_item = item.id_item; itemMovement.id_location = item_transfer.app_branch_origin.app_location.FirstOrDefault().id_location; itemMovement.db = ProductTransferDB; crud_modal.Visibility = Visibility.Visible; crud_modal.Children.Add(itemMovement); } else { if (item != null && item.item_product != null && item_transfer != null && item.id_item_type != entity.item.item_type.Task && item.id_item_type != entity.item.item_type.Service && item.id_item_type != entity.item.item_type.ServiceContract) { item_transfer_detail item_transfer_detail = new item_transfer_detail(); item_transfer_detail.status = Status.Documents_General.Pending; item_transfer_detail.quantity_origin = 1; int BranchID = (int)id_branch_originComboBox.SelectedValue; item_transfer_detail.Quantity_InStock = (decimal)StockCalculations.Count_ByBranch(BranchID, item.id_item, DateTime.Now); if (item_transfer_detail.quantity_origin < item_transfer_detail.Quantity_InStock) { item_transfer_detail.StockLevel = Status.Documents_General.Pending; } else { item_transfer_detail.StockLevel = Status.Documents_General.Annulled; } item_transfer_detail.timestamp = DateTime.Now; item_transfer_detail.item_product = item.item_product.FirstOrDefault(); item_transfer_detail.id_item_product = item_transfer_detail.item_product.id_item_product; item_transfer_detail.RaisePropertyChanged("item_product"); item_transfer.item_transfer_detail.Add(item_transfer_detail); } else { toolBar.msgWarning("Item Error"); } item_transferViewSource.View.Refresh(); item_transferitem_transfer_detailViewSource.View.Refresh(); } } }