コード例 #1
0
ファイル: Request.xaml.cs プロジェクト: mercaditu/ERP
        private void crud_modalTransfer_IsVisibleChanged(object sender, DependencyPropertyChangedEventArgs e)
        {
            // Selecteditem_movement = itemMovement.item_movement;
            item_request_detail item_request_detail = (item_request_detail)item_requestitem_request_detailViewSource.View.CurrentItem;

            if (crud_modal.Visibility == Visibility.Hidden)
            {
                desion desion = (desion)item_request_decisionmovementDataGrid.SelectedItem;
                desion.decisionState = state.modified;
                item_request_decision item_request_decision = new global::entity.item_request_decision();
                item_request_decision.movement_id = (int)itemMovement.item_movement.id_movement;
                item_request_decision.IsSelected  = true;
                item_request_decision.id_location = desion.id_location;
                item_request_decision.quantity    = desion.decisionqty;
                item_request_decision.decision    = global::entity.item_request_decision.Decisions.Transfer;
                item_request_detail.item_request_decision.Add(item_request_decision);


                item_request_detail.item_request.GetTotalDecision();
                item_request_detail.RaisePropertyChanged("balance");
                dbContext.SaveChanges();
                item_requestViewSource.View.MoveCurrentToLast();
                item_requestViewSource.View.MoveCurrentTo(item_request_detail.item_request);
                item_request_detailitem_request_decisionViewSource.View.Refresh();
                toolBar_btnEdit_Click(sender);
            }
        }
コード例 #2
0
ファイル: Request.xaml.cs プロジェクト: mercaditu/ERP
        private void item_request_decisionproductionDataGrid_RowEditEnding(object sender, DataGridRowEditEndingEventArgs e)
        {
            CollectionViewSource item_requestitem_request_detailViewSource = ((CollectionViewSource)(FindResource("item_requestitem_request_detailViewSource")));
            item_request_detail  item_request_detail = item_requestitem_request_detailViewSource.View.CurrentItem as item_request_detail;

            if (item_request_decisionproductionDataGrid.SelectedItem != null)
            {
                desion desion = (desion)item_request_decisionproductionDataGrid.SelectedItem;

                if (desion.decisionState == state.added)
                {
                    desion.decisionState = state.modified;
                    item_request_decision item_request_decision = new global::entity.item_request_decision();
                    item_request_decision.IsSelected = true;
                    item_request_decision.quantity   = desion.decisionqty;
                    item_request_decision.decision   = global::entity.item_request_decision.Decisions.Production;
                    item_request_detail.item_request_decision.Add(item_request_decision);
                }
            }

            item_request_detail.item_request.GetTotalDecision();
            item_request_detail.RaisePropertyChanged("balance");
            dbContext.SaveChanges();
            item_requestViewSource.View.MoveCurrentToLast();
            item_requestViewSource.View.MoveCurrentTo(item_request_detail.item_request);
            item_request_detailitem_request_decisionViewSource.View.Refresh();
            toolBar_btnEdit_Click(sender);
        }
コード例 #3
0
ファイル: Request.xaml.cs プロジェクト: mercaditu/ERP
        private void item_request_decisionDataGrid_RowEditEnding(object sender, DataGridRowEditEndingEventArgs e)
        {
            CollectionViewSource item_requestitem_request_detailViewSource = ((CollectionViewSource)(FindResource("item_requestitem_request_detailViewSource")));
            item_request_detail  item_request_detail = (item_request_detail)item_requestitem_request_detailViewSource.View.CurrentItem;

            if (item_request_decisionmovementDataGrid.SelectedItem != null)
            {
                desion desion = (desion)item_request_decisionmovementDataGrid.SelectedItem;
                if (desion.avlqty < desion.decisionqty)
                {
                    toolBar.msgWarning("quantity is greater than available quantity");
                    return;
                }

                if (desion.decisionState == state.added)
                {
                    if (dbContext.items.Where(x => x.id_item == item_request_detail.id_item).FirstOrDefault().item_dimension.Count() > 0)
                    {
                        crud_modal.Children.Clear();
                        itemMovement.id_item     = item_request_detail.id_item;
                        itemMovement.id_location = desion.id_location;
                        itemMovement.db          = dbContext;

                        crud_modal.Visibility = Visibility.Visible;
                        crud_modal.Children.Add(itemMovement);
                    }
                    else
                    {
                        desion.decisionState = state.modified;
                        item_request_decision item_request_decision = new global::entity.item_request_decision();
                        item_request_decision.IsSelected  = true;
                        item_request_decision.id_location = desion.id_location;
                        item_request_decision.quantity    = desion.decisionqty;
                        item_request_decision.decision    = global::entity.item_request_decision.Decisions.Movement;
                        item_request_detail.item_request_decision.Add(item_request_decision);
                    }
                }
                else
                {
                }
            }

            item_request_detail.item_request.GetTotalDecision();
            item_request_detail.RaisePropertyChanged("balance");
            dbContext.SaveChanges();
            item_requestViewSource.View.MoveCurrentToLast();
            item_requestViewSource.View.MoveCurrentTo(item_request_detail.item_request);
            item_request_detailitem_request_decisionViewSource.View.Refresh();
            toolBar_btnEdit_Click(sender);
        }
コード例 #4
0
ファイル: Request.xaml.cs プロジェクト: mercaditu/ERP
        private void item_request_detailMovementDataGrid_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            entity.Properties.Settings setting = new entity.Properties.Settings();
            int id_branch = setting.branch_ID;
            CollectionViewSource item_requestitem_request_detailViewSource = ((CollectionViewSource)(FindResource("item_requestitem_request_detailViewSource")));
            item_request_detail  item_request_detail = (item_request_detail)item_requestitem_request_detailViewSource.View.CurrentItem;

            if (item_request_detail != null)
            {
                item _item    = dbContext.items.Where(x => x.id_item == item_request_detail.id_item).FirstOrDefault();
                var  movement =
                    (from items in dbContext.item_movement
                     where items.status == Status.Stock.InStock &&
                     items.item_product.id_item == item_request_detail.id_item &&
                     items.app_location.id_branch == id_branch
                     group items by new { items.app_location }
                     into last
                     select new
                {
                    id_location = last.Key.app_location.id_location,
                    location = last.Key.app_location.name,
                    quntitiy = last.Sum(x => x.credit != null ? x.credit : 0) - last.Sum(x => x.debit != null ? x.debit : 0),
                }).ToList();


                List <desion> list_desion = new List <desion>();
                foreach (dynamic item in movement)
                {
                    // int id_location = (int)item.location;
                    desion desion = new desion();
                    desion.id_item       = _item.id_item;
                    desion.id_location   = item.id_location;
                    desion.location      = item.location;
                    desion.name          = _item.name;
                    desion.avlqty        = item.quntitiy;
                    desion.decisionqty   = 0;
                    desion.decisionState = state.added;
                    list_desion.Add(desion);
                }
                item_request_decisionmovementDataGrid.ItemsSource = list_desion;


                var transfer =
                    //(from items in dbContext.item_transfer_detail
                    // where items.item_product.id_item == item_request_detail.id_item
                    // group items by new { items.item_transfer.app_branch_destination }
                    //     into last
                    //     select new
                    //     {
                    //         id_location = last.Key.app_branch_destination.app_location.Where(x => x.is_default).FirstOrDefault().id_location,
                    //         branch = last.Key.app_branch_destination.name,
                    //         quntitiy = last.Sum(x => x.quantity_destination != null ? x.quantity_destination : 0),

                    //     }).ToList();

                    (from items in dbContext.item_movement
                     where items.status == Status.Stock.InStock &&
                     items.item_product.id_item == item_request_detail.id_item

                     group items by new { items.app_location.app_branch }
                     into last
                     select new
                {
                    id_location = last.Key.app_branch.app_location.Where(x => x.is_default).FirstOrDefault().id_location,
                    branch = last.Key.app_branch.name,
                    quntitiy = last.Sum(x => x.credit != null ? x.credit : 0) - last.Sum(x => x.debit != null ? x.debit : 0),
                }).ToList();
                List <desion> list_desion_transfer = new List <desion>();
                foreach (dynamic item in transfer)
                {
                    desion desion = new desion();
                    desion.branch        = item.branch;
                    desion.id_location   = item.id_location;
                    desion.id_item       = _item.id_item;
                    desion.name          = _item.name;
                    desion.avlqty        = item.quntitiy;
                    desion.decisionqty   = 0;
                    desion.decisionState = state.added;
                    list_desion_transfer.Add(desion);
                }
                item_request_decisiontransferDataGrid.ItemsSource = list_desion_transfer;

                List <desion> list_desion_purchase = new List <desion>();
                desion        purchasedesion       = new desion();
                purchasedesion.decisionState = state.added;
                purchasedesion.decisionqty   = 0;
                list_desion_purchase.Add(purchasedesion);
                item_request_decisionpurchaseDataGrid.ItemsSource = list_desion_purchase;


                List <desion> list_desion_production = new List <desion>();
                desion        productiondesion       = new desion();
                productiondesion.name = item_request_detail.item.name;
                productiondesion.RaisePropertyChanged("name");
                productiondesion.decisionqty   = 0;
                productiondesion.decisionState = state.added;
                list_desion_production.Add(productiondesion);
                item_request_decisionproductionDataGrid.ItemsSource = list_desion_production;
            }
        }