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);
}
