private void toolBar_btnSearch_Click(object sender, string query)
{
try
{
if (!string.IsNullOrEmpty(query))
{
production_orderViewSource.View.Filter = i =>
{
production_order production_order = i as production_order;
if (production_order.name.ToLower().Contains(query.ToLower()) && production_order.types == entity.production_order.ProductionOrderTypes.Production)
{
return(true);
}
else
{
return(false);
}
};
}
else
{
production_orderViewSource.View.Filter = null;
}
}
catch (Exception ex)
{ toolBar.msgError(ex); }
}
private void toolIcon_Click(object sender)
{
production_order production_order = production_orderViewSource.View.CurrentItem as production_order;
production_orderproduction_order_detailViewSource.View.Filter = null;
List <production_order_detail> _production_order_detail = treeProject.ItemsSource.Cast <production_order_detail>().ToList();
foreach (production_order_detail production_order_detail in _production_order_detail.Where(x => x.IsSelected == true))
{
if (production_order_detail.parent != null)
{
production_order_detail.parent.status = entity.Status.Production.Approved;
}
production_order_detail.status = entity.Status.Production.Approved;
}
if (production_order.production_execution.Count() == 0)
{
production_execution production_execution = new production_execution();
production_execution.production_order = production_order;
production_execution.id_production_line = production_order.id_production_line;
production_execution.trans_date = DateTime.Now;
OrderDB.production_execution.Add(production_execution);
}
if (OrderDB.SaveChanges() > 0)
{
filter_task();
toolBar.msgSaved(OrderDB.NumberOfRecords);
}
}
private void toolBar_btnAnull_Click(object sender)
{
production_order production_order = production_orderViewSource.View.CurrentItem as production_order;
production_order.status = Status.Production.QA_Rejected;
OrderDB.SaveChanges();
}
public void RefreshData()
{
try
{
production_execution_detailProductViewSource.View.Refresh();
production_execution_detailProductViewSource.View.MoveCurrentToLast();
production_execution_detailRawViewSource.View.Refresh();
production_execution_detailRawViewSource.View.MoveCurrentToLast();
production_execution_detailSupplyViewSource.View.Refresh();
production_execution_detailSupplyViewSource.View.MoveCurrentToLast();
production_execution_detailAssetViewSource.View.Refresh();
production_execution_detailAssetViewSource.View.MoveCurrentToLast();
production_execution_detailServiceContractViewSource.View.Refresh();
production_execution_detailServiceContractViewSource.View.MoveCurrentToLast();
production_execution_detailServiceViewSource.View.Refresh();
production_execution_detailServiceViewSource.View.MoveCurrentToLast();
production_order production_order = production_orderViewSource.View.CurrentItem as production_order;
foreach (production_order_detail production_order_detail in production_order.production_order_detail)
{
production_order_detail.CalcExecutedQty_TimerTaks();
production_order_detail.CalcExecutedCost_TimerTaks();
}
}
catch { }
}
private void toolBar_btnCancel_Click(object sender)
{
production_order _production_order = (production_order)production_orderDataGrid.SelectedItem;
_production_order.State = EntityState.Unchanged;
production_orderViewSource.View.Refresh();
//OrderDB.CancelAllChanges();
}
private void toolBar_btnNew_Click(object sender)
{
production_order production_order = OrderDB.New("", production_order.ProductionOrderTypes.Production, 0);
production_order.State = EntityState.Added;
OrderDB.production_order.Add(production_order);
production_orderViewSource.View.MoveCurrentToLast();
}
private void btnSaveTask_Click(object sender)
{
if (OrderDB.SaveChanges() > 0)
{
production_order production_order = production_orderViewSource.View.CurrentItem as production_order;
production_order.State = EntityState.Modified;
Update_request();
stpcode.IsEnabled = false;
}
}
private void toolBar_btnApprove_Click(object sender)
{
production_order production_order = production_orderViewSource.View.CurrentItem as production_order;
production_order.status = Status.Production.Executed;
if (OrderDB.SaveChanges() > 0)
{
toolBar.msgApproved(1);
}
}
private void toolBar_btnEdit_Click(object sender)
{
if (production_orderDataGrid.SelectedItem != null)
{
production_order production_order = (production_order)production_orderDataGrid.SelectedItem;
production_order.IsSelected = true;
production_order.State = EntityState.Modified;
OrderDB.Entry(production_order).State = EntityState.Modified;
}
else
{
toolBar.msgWarning("Please Select an Item");
}
}
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 lblCancel_MouseDown(object sender, MouseButtonEventArgs e)
{
production_order production_order = (production_order)production_orderViewSource.View.CurrentItem;
shared_dbContext.db.production_order.Remove(production_order);
foreach (var item in project_taskLIST)
{
project_task _project_task = (project_task)item;
_project_task.IsSelected = false;
}
projectViewSource.View.Refresh();
Grid parentGrid = (Grid)this.Parent;
parentGrid.Children.Clear();
parentGrid.Visibility = Visibility.Hidden;
}
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;
}
}
private void toolBar_btnSave_Click(object sender)
{
production_order _production_order = (production_order)production_orderDataGrid.SelectedItem;
if ((_production_order.work_number == null || _production_order.work_number == string.Empty) && _production_order.id_range > 0)
{
if (_production_order.id_branch > 0)
{
entity.Brillo.Logic.Range.branch_Code = OrderDB.app_branch.Where(x => x.id_branch == _production_order.id_branch).FirstOrDefault().code;
}
if (_production_order.id_terminal > 0)
{
entity.Brillo.Logic.Range.terminal_Code = OrderDB.app_terminal.Where(x => x.id_terminal == _production_order.id_terminal).FirstOrDefault().code;
}
app_document_range app_document_range = OrderDB.app_document_range.Where(x => x.id_range == _production_order.id_range).FirstOrDefault();
_production_order.work_number = entity.Brillo.Logic.Range.calc_Range(app_document_range, true);
_production_order.RaisePropertyChanged("work_number");
}
OrderDB.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;
}
}
}
}
public void item_request_Click(object sender)
{
production_order production_order = ((production_order)production_orderViewSource.View.CurrentItem);
int id_production_order = ((production_order)production_orderViewSource.View.CurrentItem).id_production_order;
if (itemDataGrid.ItemsSource != null)
{
List <production_order_detail> production_order_detaillist = OrderDB.production_order_detail.ToList();
production_order_detaillist = production_order_detaillist.Where(x => x.IsSelected == true).ToList();
item_request item_request = new item_request();
item_request.name = ItemRequest.name;
item_request.comment = ItemRequest.comment;
item_request.id_department = ItemRequest.id_department;
item_request.id_production_order = id_production_order;
if (production_order.id_project != null)
{
project project = OrderDB.projects.Where(x => x.id_project == production_order.id_project).FirstOrDefault();
item_request.id_project = production_order.id_project;
item_request.id_branch = production_order.id_branch;
}
item_request.request_date = DateTime.Now;
foreach (production_order_detail data in production_order_detaillist.Where(x => x.IsSelected == true))
{
item_request_detail item_request_detail = new entity.item_request_detail();
item_request_detail.date_needed_by = ItemRequest.neededDate;
item_request_detail.id_order_detail = data.id_order_detail;
item_request_detail.urgency = ItemRequest.Urgencies;
int idItem = data.item.id_item;
item_request_detail.id_item = idItem;
item item = OrderDB.items.Where(x => x.id_item == idItem).FirstOrDefault();
if (item != null)
{
item_request_detail.item = item;
item_request_detail.comment = item_request_detail.item.name;
}
if (data.project_task != null)
{
item_request_detail.id_project_task = data.project_task.id_project_task;
List <project_task_dimension> project_task_dimensionList = OrderDB.project_task_dimension.Where(x => x.id_project_task == data.project_task.id_project_task).ToList();
foreach (project_task_dimension project_task_dimension in project_task_dimensionList)
{
item_request_dimension item_request_dimension = new item_request_dimension();
item_request_dimension.id_dimension = project_task_dimension.id_dimension;
item_request_dimension.id_measurement = project_task_dimension.id_measurement;
item_request_dimension.value = project_task_dimension.value;
string comment = item_request_detail.item.name;
comment += project_task_dimension.value.ToString();
comment += "X";
item_request_detail.comment = comment.Substring(0, comment.Length - 1);
item_request_detail.item_request_dimension.Add(item_request_dimension);
}
}
item_request_detail.quantity = data.quantity;
item_request.item_request_detail.Add(item_request_detail);
}
OrderDB.item_request.Add(item_request);
OrderDB.SaveChanges();
//item_requestViewSource.View.Filter = i =>
//{
// item_request _item_request = (item_request)i;
// if (_item_request.id_production_order == id_production_order)
// return true;
// else
// return false;
//};
}
crud_modal_request.Children.Clear();
crud_modal_request.Visibility = System.Windows.Visibility.Collapsed;
}
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();
}
}
