public List <item_movement> CalculateStock(production_execution production_execution, List <item_movement> item_movementList) { foreach (production_execution_detail detail in production_execution.production_execution_detail .Where(x => x.item.id_item_type == item.item_type.Product || x.item.id_item_type == item.item_type.RawMaterial)) { item_product item_product = Stock.FindNFix_ItemProduct(detail.item); List <item_movement> _item_movementList; _item_movementList = db.item_movement.Where(x => x.id_location == production_execution.production_line.id_location && x.id_item_product == item_product.id_item_product && x.status == entity.Status.Stock.InStock && (x.credit - (x._child.Count() > 0 ? x._child.Sum(y => y.debit) : 0)) > 0).ToList(); if (item_product.cogs_type == item_product.COGS_Types.LIFO && _item_movementList != null) { _item_movementList = _item_movementList.OrderBy(x => x.trans_date).ToList(); } else if (_item_movementList != null) { _item_movementList = _item_movementList.OrderByDescending(x => x.trans_date).ToList(); } else { //Adding into List if _item_movementList is empty. item_movementList.Add(Stock.debit_Movement(entity.Status.Stock.InStock, App.Names.ProductionExecustion, detail.id_production_execution, item_product.id_item_product, (int)production_execution.production_line.id_location, detail.quantity, production_execution.trans_date, Stock.comment_Generator(App.Names.ProductionExecustion, production_execution.id_production_execution.ToString(), "") )); } foreach (item_movement object_Movement in _item_movementList) { decimal qty_ExexustionDetail = detail.quantity; if (qty_ExexustionDetail > 0) { item_movement item_movement = new item_movement(); if (detail.is_input) { decimal movement_debit_quantity = qty_ExexustionDetail; if (object_Movement.credit <= qty_ExexustionDetail) { movement_debit_quantity = object_Movement.credit; } else { movement_debit_quantity = qty_ExexustionDetail; } //If input is true, then we should DEBIT Stock. item_movement = Stock.debit_Movement(entity.Status.Stock.InStock, App.Names.ProductionExecustion, (int)detail.id_production_execution, item_product.id_item_product, (int)production_execution.production_line.id_location, movement_debit_quantity, production_execution.trans_date, Stock.comment_Generator(App.Names.ProductionExecustion, production_execution.id_production_execution.ToString(), "")); } else { //If input is false, then we should CREDIT Stock. item_movement = Stock.credit_Movement(entity.Status.Stock.InStock, App.Names.ProductionExecustion, (int)detail.id_production_execution, item_product.id_item_product, (int)production_execution.production_line.id_location, qty_ExexustionDetail, production_execution.trans_date, Stock.comment_Generator(App.Names.ProductionExecustion, production_execution.id_production_execution.ToString(), "")); } item_movement._parent = object_Movement; //Logic for Value item_movement_value item_movement_value = new item_movement_value(); item_movement_value.unit_value = object_Movement.item_movement_value.Sum(i => i.unit_value); item_movement_value.id_currencyfx = object_Movement.item_movement_value.FirstOrDefault().id_currencyfx; item_movement_value.comment = item_movement.comment; item_movement.item_movement_value.Add(item_movement_value); //Adding into List item_movementList.Add(item_movement); qty_ExexustionDetail = qty_ExexustionDetail - object_Movement.credit; } } } return(item_movementList); }
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(); } }