public void item_request_Click(object sender)
{
if (dgvMaintainceDetail.ItemsSource != null)
{
List <item_asset_maintainance_detail> item_asset_maintainance_detaillist = db.db.item_asset_maintainance_detail.ToList();
item_asset_maintainance_detaillist = item_asset_maintainance_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.request_date = DateTime.Now;
foreach (item_asset_maintainance_detail data in item_asset_maintainance_detaillist)
{
item_request_detail item_request_detail = new entity.item_request_detail();
item_request_detail.date_needed_by = ItemRequest.neededDate;
item_request_detail.id_maintainance_detail = data.id_maintainance_detail;
item_request_detail.urgency = ItemRequest.Urgencies;
int idItem = data.item.id_item;
item_request_detail.id_item = idItem;
item item = db.db.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;
}
item_request_detail.quantity = data.quantity;
item_request.item_request_detail.Add(item_request_detail);
}
db.db.item_request.Add(item_request);
db.db.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;
}
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;
}
