private void treeProduct_SelectedItemChanged(object sender, RoutedPropertyChangedEventArgs <object> e) { production_order_detail production_order_detail = (production_order_detail)treeProduct.SelectedItem_; if (production_order_detail != null) { production_execution_detailProductViewSource.View.Filter = i => { production_execution_detail production_execution_detail = (production_execution_detail)i; if (production_execution_detail.item != null) { if (production_execution_detail.id_order_detail == production_order_detail.id_order_detail && production_execution_detail.item.id_item_type == item.item_type.Product) { return(true); } else { return(false); } } else { return(false); } }; } }
private void treeraw_SelectedItemChanged(object sender, RoutedPropertyChangedEventArgs <object> e) { production_order_detail production_order_detail = (production_order_detail)treeRaw.SelectedItem_; if (production_order_detail != null) { production_execution_detailRawViewSource.View.Filter = i => { production_execution_detail production_execution_detail = (production_execution_detail)i; if (production_execution_detail.id_order_detail == production_order_detail.id_order_detail && production_execution_detail.item.id_item_type == item.item_type.RawMaterial) { return(true); } else { return(false); } }; if (production_order_detail != null) { if (production_order_detail.project_task != null) { int _id_task = production_order_detail.project_task.id_project_task; project_task_dimensionViewSource = (CollectionViewSource)FindResource("project_task_dimensionViewSource"); project_task_dimensionViewSource.Source = ExecutionDB.project_task_dimension.Where(x => x.id_project_task == _id_task).ToList(); } } } }
public void add_item(production_order_detail production_order_detail) { production_order_detail.quantity = production_order_detailList.FirstOrDefault().quantity; production_order_detail.id_item = production_order_detailList.FirstOrDefault().id_item; production_order_detail.item = production_order_detailList.FirstOrDefault().item; production_order_detail.parent = production_order_detailList.FirstOrDefault().parent; production_order_detail.IsSelected = true; production_order_detail.State = EntityState.Added; production_order_detailList.FirstOrDefault().production_order.production_order_detail.Add(production_order_detail); if (production_order_detail.id_project_task > 0) { if (OrderDB.project_task.Where(x => x.id_project_task == production_order_detail.id_project_task).FirstOrDefault() != null) { project_task project_task = OrderDB.project_task.Where(x => x.id_project_task == production_order_detail.id_project_task).FirstOrDefault(); if (OrderDB.project_task_dimension.Where(x => x.id_project_task == project_task.id_project_task).ToList() != null) { List <project_task_dimension> project_task_dimensionList = OrderDB.project_task_dimension.Where(x => x.id_project_task == project_task.id_project_task).ToList(); foreach (project_task_dimension project_task_dimension in project_task_dimensionList) { production_order_dimension production_order_dimension = new production_order_dimension(); production_order_dimension.id_dimension = project_task_dimension.id_dimension; production_order_dimension.value = project_task_dimension.value; production_order_detail.production_order_dimension.Add(production_order_dimension); } } } } }
private void Insert_IntoDetail(production_order_detail production_order_detail, decimal Quantity) { if (_production_execution != null) { if (production_order_detail != null) { production_execution_detail _production_execution_detail = new entity.production_execution_detail(); //Adds Parent so that during approval, because it is needed for approval. if (production_order_detail.parent != null) { if (production_order_detail.parent.production_execution_detail != null) { _production_execution_detail.parent = production_order_detail.parent.production_execution_detail.FirstOrDefault(); } } _production_execution_detail.State = EntityState.Added; _production_execution_detail.id_item = production_order_detail.id_item; _production_execution_detail.item = production_order_detail.item; _production_execution_detail.quantity = Quantity; _production_execution_detail.id_project_task = production_order_detail.id_project_task; _production_execution_detail.movement_id = (int)id_movement; if (production_order_detail.item.unit_cost != null) { _production_execution_detail.unit_cost = (decimal)production_order_detail.item.unit_cost; } _production_execution_detail.production_execution = _production_execution; _production_execution_detail.id_order_detail = production_order_detail.id_order_detail; if (production_order_detail.item.is_autorecepie) { _production_execution_detail.is_input = false; } else { _production_execution_detail.is_input = true; } foreach (item_movement_dimension item_movement_dimension in item_movement.item_movement_dimension) { production_execution_dimension production_execution_dimension = new production_execution_dimension(); production_execution_dimension.id_dimension = item_movement_dimension.id_dimension; production_execution_dimension.value = item_movement_dimension.value; production_execution_dimension.id_measurement = (app_measurementViewSource.View.CurrentItem as app_measurement).id_measurement; _production_execution_detail.production_execution_dimension.Add(production_execution_dimension); } _production_execution.production_execution_detail.Add(_production_execution_detail); } } btnCancel_Click(null, null); }
private void btnAddParentTask_Click(object sender) { stpcode.IsEnabled = true; production_order production_order = production_orderViewSource.View.CurrentItem as production_order; production_order_detail n_production_order_detail = new production_order_detail(); n_production_order_detail.status = Status.Production.Pending; production_order.production_order_detail.Add(n_production_order_detail); production_orderproduction_order_detailViewSource.View.Refresh(); production_orderproduction_order_detailViewSource.View.MoveCurrentTo(n_production_order_detail); filter_task(); treeProject.SelectedItem_ = n_production_order_detail; }
private void item_ProductDataGrid_LoadingRowDetails(object sender, DataGridRowDetailsEventArgs e) { DataGrid DataGrid = (DataGrid)sender; production_order_detail obj = (production_order_detail)DataGrid.SelectedItem; if (obj != null) { if (obj.project_task != null) { int _id_task = obj.project_task.id_project_task; project_task_dimensionViewSource = (CollectionViewSource)FindResource("project_task_dimensionViewSource"); project_task_dimensionViewSource.Source = OrderDB.project_task_dimension.Where(x => x.id_project_task == _id_task).ToList(); } } }
public void filter_order(CollectionViewSource CollectionViewSource, item.item_type item_type) { int id_production_order = 0; if (production_executionViewSource.View.CurrentItem != null) { id_production_order = ((production_execution)production_executionViewSource.View.CurrentItem).id_production_order; } if (CollectionViewSource != null) { List <production_order_detail> _production_order_detail = ExecutionDB.production_order_detail.Where(a => a.status == Status.Production.Approved && (a.item.id_item_type == item_type || a.item.id_item_type == item.item_type.Task) && a.id_production_order == id_production_order) .ToList(); if (_production_order_detail.Count() > 0) { CollectionViewSource.Source = _production_order_detail; } else { CollectionViewSource.Source = null; } } if (CollectionViewSource != null) { if (CollectionViewSource.View != null) { CollectionViewSource.View.Filter = i => { production_order_detail production_order_detail = (production_order_detail)i; if (production_order_detail.parent == null) { return(true); } else { return(false); } }; } } }
private void treeSupply_SelectedItemChanged(object sender, RoutedPropertyChangedEventArgs <object> e) { production_order_detail production_order_detail = (production_order_detail)treeSupply.SelectedItem; if (production_order_detail != null) { production_execution_detailSupplyViewSource.View.Filter = i => { production_execution_detail production_execution_detail = (production_execution_detail)i; if (production_execution_detail.id_order_detail == production_order_detail.id_order_detail) { return(true); } else { return(false); } }; } }
private void btnNewTask_Click(object sender) { stpcode.IsEnabled = true; production_order production_order = production_orderViewSource.View.CurrentItem as production_order; production_order_detail production_order_detail = treeProject.SelectedItem as production_order_detail; if (production_order_detail != null) { //Adding a Child Item. if (production_order_detail.item != null) { if (production_order_detail.item.id_item_type == entity.item.item_type.Task) { production_order_detail n_production_order_detail = new production_order_detail(); n_production_order_detail.id_production_order = production_order.id_production_order; n_production_order_detail.production_order = production_order; n_production_order_detail.production_order.status = Status.Production.Pending; n_production_order_detail.quantity = 0; n_production_order_detail.status = Status.Production.Pending; production_order_detail.child.Add(n_production_order_detail); OrderDB.production_order_detail.Add(n_production_order_detail); production_orderproduction_order_detailViewSource.View.Refresh(); production_orderproduction_order_detailViewSource.View.MoveCurrentTo(n_production_order_detail); treeProject.SelectedItem_ = n_production_order_detail; } } } else { //Adding First Item production_order_detail n_production_order_detail = new production_order_detail(); n_production_order_detail.status = Status.Production.Pending; production_order.production_order_detail.Add(n_production_order_detail); production_orderproduction_order_detailViewSource.View.Refresh(); production_orderproduction_order_detailViewSource.View.MoveCurrentTo(n_production_order_detail); filter_task(); treeProject.SelectedItem_ = n_production_order_detail; } }
public void filter_task() { if (production_orderproduction_order_detailViewSource != null) { if (production_orderproduction_order_detailViewSource.View != null) { production_orderproduction_order_detailViewSource.View.Filter = i => { production_order_detail objproduction_order_detail = (production_order_detail)i; if (objproduction_order_detail.parent == null) { return(true); } else { return(false); } }; } } }
private void Insert_IntoDetail(production_order_detail production_order_detail, decimal Quantity) { production_execution _production_execution = (production_execution)projectDataGrid.SelectedItem; production_execution_detail _production_execution_detail = new entity.production_execution_detail(); //Adds Parent so that during approval, because it is needed for approval. if (production_order_detail.parent != null) { if (production_order_detail.parent.production_execution_detail != null) { _production_execution_detail.parent = production_order_detail.parent.production_execution_detail.FirstOrDefault(); } } _production_execution_detail.State = EntityState.Added; _production_execution_detail.id_item = production_order_detail.id_item; _production_execution_detail.item = production_order_detail.item; _production_execution_detail.quantity = Quantity; _production_execution_detail.id_project_task = production_order_detail.id_project_task; if (production_order_detail.item.unit_cost != null) { _production_execution_detail.unit_cost = (decimal)production_order_detail.item.unit_cost; } _production_execution_detail.production_execution = _production_execution; _production_execution_detail.id_order_detail = production_order_detail.id_order_detail; if (production_order_detail.item.is_autorecepie) { _production_execution_detail.is_input = false; } else { _production_execution_detail.is_input = true; } _production_execution.production_execution_detail.Add(_production_execution_detail); ExecutionDB.SaveChanges(); }
private void item_Select(object sender, EventArgs e) { if (sbxItem.ItemID > 0) { production_order production_order = production_orderViewSource.View.CurrentItem as production_order; item item = OrderDB.items.Where(x => x.id_item == sbxItem.ItemID).FirstOrDefault(); if (item != null && item.id_item > 0 && item.is_autorecepie && production_order != null) { production_order_detail production_order_detail_output = treeProject.SelectedItem as production_order_detail; if (production_order_detail_output != null) { production_order_detail_output.id_item = item.id_item; production_order_detail_output.item = item; production_order_detail_output.name = item.name; production_order_detail_output.RaisePropertyChanged("item"); production_order_detail_output.is_input = false; production_order_detail_output.quantity = 1; production_order_detail_output.production_order = production_order; production_order_detail_output.id_production_order = production_order.id_production_order; foreach (item_recepie_detail item_recepie_detail in item.item_recepie.FirstOrDefault().item_recepie_detail) { production_order_detail production_order_detail = new production_order_detail(); production_order_detail.name = item_recepie_detail.item.name; production_order_detail.id_item = item_recepie_detail.item.id_item; production_order_detail.item = item_recepie_detail.item; production_order_detail.RaisePropertyChanged("item"); production_order_detail.production_order = production_order; production_order_detail.id_production_order = production_order.id_production_order; if (item_recepie_detail.quantity > 0) { production_order_detail.quantity = (decimal)item_recepie_detail.quantity; } production_order_detail.is_input = true; production_order_detail_output.child.Add(production_order_detail); } filter_task(); } } else { production_order_detail production_order_detail_output = treeProject.SelectedItem as production_order_detail; if (production_order_detail_output != null) { production_order_detail_output.quantity = 1; production_order_detail_output.name = item.name; production_order_detail_output.id_item = item.id_item; production_order_detail_output.item = item; production_order_detail_output.RaisePropertyChanged("item"); production_order_detail_output.is_input = true; production_order_detail_output.production_order = production_order; production_order_detail_output.id_production_order = production_order.id_production_order; } } } }
private void UserControl_Loaded(object sender, RoutedEventArgs e) { production_order production_order = new production_order(); // Do not load your data at design time. if (!DesignerProperties.GetIsInDesignMode(this)) { //Load your data here and assign the result to the CollectionViewSource. production_orderViewSource = (CollectionViewSource)this.Resources["production_orderViewSource"]; shared_dbContext.db.production_order.Add(production_order); production_orderViewSource.Source = shared_dbContext.db.production_order.Local; production_lineViewSource = (CollectionViewSource)this.Resources["production_lineViewSource"]; shared_dbContext.db.production_line.Load(); production_lineViewSource.Source = shared_dbContext.db.production_line.Local; } if (project_taskLIST.Count() > 0) { production_order.id_project = project_taskLIST.FirstOrDefault().id_project; //Get Name. production_order.name = project_taskLIST.FirstOrDefault().project.name; production_order.RaisePropertyChanged("name"); //Date check. Get the range from task first, if blank get from Project. production_order.start_date_est = project_taskLIST.OrderBy(x => x.start_date_est).FirstOrDefault().start_date_est; production_order.end_date_est = project_taskLIST.OrderByDescending(x => x.end_date_est).FirstOrDefault().end_date_est; if (production_order.start_date_est == null || production_order.end_date_est == null) { production_order.start_date_est = project_taskLIST.OrderBy(x => x.start_date_est).FirstOrDefault().project.est_start_date; production_order.end_date_est = project_taskLIST.OrderByDescending(x => x.end_date_est).FirstOrDefault().project.est_end_date; } production_order.RaisePropertyChanged("start_date_est"); production_order.RaisePropertyChanged("end_date_est"); foreach (var item in project_taskLIST.Where(x => x.status == Status.Project.Approved)) { project_task _project_task = (project_task)item; production_order_detail production_order_detail = new production_order_detail(); production_order_detail.status = Status.Production.Pending; production_order_detail.id_order_detail = _project_task.id_project_task; production_order_detail.name = _project_task.item_description; production_order_detail.code = _project_task.code; //Ref Keys production_order_detail.item = _project_task.items; production_order_detail.id_item = _project_task.id_item; //If Item has Recepie if (_project_task.items.item_recepie.Count > 0) { production_order_detail.is_input = false; } else { production_order_detail.is_input = true; } if (_project_task.parent != null) { production_order_detail _production_order_detail = production_order.production_order_detail.Where(x => x.id_project_task == _project_task.parent.id_project_task).FirstOrDefault(); if (_production_order_detail != null) { production_order_detail.parent = _production_order_detail; } } production_order_detail.id_project_task = _project_task.id_project_task; if (_project_task.quantity_est > 0) { production_order_detail.quantity = (decimal)_project_task.quantity_est; } production_order.status = entity.Status.Production.Pending; production_order.production_order_detail.Add(production_order_detail); } shared_dbContext.db.production_order.Add(production_order); production_orderViewSource.View.MoveCurrentToLast(); } }
private void btnInsert_Click(object sender, EventArgs e) { production_order_detail production_order_detail = null; Button btn = sender as Button; decimal Quantity = 0M; item.item_type type = item.item_type.Task; if (btn.Name.Contains("Prod")) { Quantity = Convert.ToDecimal(txtProduct.Text); production_order_detail = treeProduct.SelectedItem_ as production_order_detail; type = item.item_type.Product; } else if (btn.Name.Contains("Raw")) { Quantity = Convert.ToDecimal(txtRaw.Text); production_order_detail = treeRaw.SelectedItem_ as production_order_detail; type = item.item_type.RawMaterial; } else if (btn.Name.Contains("Asset")) { Quantity = Convert.ToDecimal(txtAsset.Text); production_order_detail = treeAsset.SelectedItem_ as production_order_detail; type = item.item_type.FixedAssets; } else if (btn.Name.Contains("Supp")) { Quantity = Convert.ToDecimal(txtSupply.Text); production_order_detail = treeSupply.SelectedItem_ as production_order_detail; type = item.item_type.Supplies; } else if (btn.Name.Contains("ServiceContract")) { Quantity = Convert.ToDecimal(txtServicecontract.Text); production_order_detail = treeServicecontract.SelectedItem_ as production_order_detail; type = item.item_type.ServiceContract; } try { if (production_order_detail.is_input) { if (production_order_detail != null && Quantity > 0 && ( type == item.item_type.Product || type == item.item_type.RawMaterial || type == item.item_type.Supplies) ) { if (production_order_detail.item.item_dimension.Count() > 0) { Cognitivo.Configs.itemMovementFraction DimensionPanel = new Cognitivo.Configs.itemMovementFraction(); DimensionPanel.mode = Configs.itemMovementFraction.modes.Execution; production_execution _production_execution = production_executionViewSource.View.CurrentItem as production_execution; DimensionPanel.id_item = (int)production_order_detail.id_item; DimensionPanel.ExecutionDB = ExecutionDB; DimensionPanel.production_order_detail = production_order_detail; DimensionPanel._production_execution = _production_execution; DimensionPanel.Quantity = Quantity; crud_modal.Visibility = Visibility.Visible; crud_modal.Children.Add(DimensionPanel); } else { Insert_IntoDetail(production_order_detail, Quantity); RefreshData(); } } else { Insert_IntoDetail(production_order_detail, Quantity); RefreshData(); } } else { Insert_IntoDetail(production_order_detail, Quantity); RefreshData(); } } catch (Exception ex) { toolBar.msgError(ex); } }
public void adddatacontact(contact contact, cntrl.ExtendedTreeView treeview) { production_order_detail production_order_detail = (production_order_detail)treeview.SelectedItem_; if (production_order_detail != null) { if (contact != null) { //Product int id = Convert.ToInt32(((contact)contact).id_contact); if (id > 0) { production_execution _production_execution = (production_execution)production_executionViewSource.View.CurrentItem; production_execution_detail _production_execution_detail = new entity.production_execution_detail(); //Check for contact _production_execution_detail.id_contact = ((contact)contact).id_contact; _production_execution_detail.contact = contact; _production_execution_detail.quantity = 1; _production_execution_detail.item = production_order_detail.item; _production_execution_detail.id_item = production_order_detail.item.id_item; _production_execution.RaisePropertyChanged("quantity"); _production_execution_detail.is_input = true; _production_execution_detail.name = contact.name + ": " + production_order_detail.name; if (production_order_detail.id_project_task > 0) { _production_execution_detail.id_project_task = production_order_detail.id_project_task; } //Gets the Employee's contracts Hourly Rate. hr_contract contract = ExecutionDB.hr_contract.Where(x => x.id_contact == id && x.is_active).FirstOrDefault(); if (contract != null) { _production_execution_detail.unit_cost = contract.Hourly; } if (production_order_detail.item.id_item_type == item.item_type.Service) { if (cmbcoefficient.SelectedValue != null) { _production_execution_detail.id_time_coefficient = (int)cmbcoefficient.SelectedValue; } string start_date = string.Format("{0} {1}", dtpstartdate.Text, dtpstarttime.Text); _production_execution_detail.start_date = Convert.ToDateTime(start_date); string end_date = string.Format("{0} {1}", dtpenddate.Text, dtpendtime.Text); _production_execution_detail.end_date = Convert.ToDateTime(end_date); _production_execution_detail.id_production_execution = _production_execution.id_production_execution; _production_execution_detail.production_execution = _production_execution; _production_execution_detail.id_project_task = production_order_detail.id_project_task; _production_execution_detail.id_order_detail = production_order_detail.id_order_detail; _production_execution_detail.production_order_detail = production_order_detail; ExecutionDB.production_execution_detail.Add(_production_execution_detail); RefreshData(); } else if (production_order_detail.item.id_item_type == item.item_type.ServiceContract) { if (cmbcoefficient.SelectedValue != null) { _production_execution_detail.id_time_coefficient = (int)cmbsccoefficient.SelectedValue; } string start_date = string.Format("{0} {1}", dtpscstartdate.Text, dtpscstarttime.Text); _production_execution_detail.start_date = Convert.ToDateTime(start_date); string end_date = string.Format("{0} {1}", dtpscenddate.Text, dtpscendtime.Text); _production_execution_detail.end_date = Convert.ToDateTime(end_date); _production_execution_detail.id_production_execution = _production_execution.id_production_execution; _production_execution_detail.production_execution = _production_execution; _production_execution_detail.id_project_task = production_order_detail.id_project_task; _production_execution_detail.id_order_detail = production_order_detail.id_order_detail; _production_execution_detail.production_order_detail = production_order_detail; ExecutionDB.production_execution_detail.Add(_production_execution_detail); RefreshData(); } } } } else { toolBar.msgWarning("select Production order for insert"); } }
private void item_transfer_detailDataGrid_InitializingNewItem(object sender, InitializingNewItemEventArgs e) { production_order_detail production_order_detail = e.NewItem as production_order_detail; add_item(production_order_detail); }