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