private void btnApprove_Click(object sender, RoutedEventArgs e) { item_request item_request = item_requestViewSource.View.CurrentItem as item_request; //Search User. security_user security_user = new security_user(); //Load User Name and Department. if (ItemDB.security_user.Where(x => x.id_user == CurrentSession.Id_User).FirstOrDefault() != null) { security_user = ItemDB.security_user.Where(x => x.id_user == CurrentSession.Id_User).FirstOrDefault(); item_request.request_user = security_user; item_request.security_user = security_user; item_request.id_department = security_user.security_role.id_department; } //Get Branch. if (ItemDB.app_branch.Where(x => x.id_branch == CurrentSession.Id_Branch).FirstOrDefault() != null) { item_request.id_branch = ItemDB.app_branch.Where(x => x.id_branch == CurrentSession.Id_Branch).FirstOrDefault().id_branch; } item_request.name = security_user.name + " Request"; ItemDB.SaveChanges(); //Creates a new Request item_request item_request_New = new item_request(); ItemDB.item_request.Add(item_request_New); item_requestViewSource.View.MoveCurrentTo(item_request_New); }
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; }
private void toolBar_btnNew_Click(object sender) { item_request item_request = new item_request(); item_request.IsSelected = true; // dbContext.sales_invoice.Local.Add(sales_invoice); dbContext.Entry(item_request).State = EntityState.Added; item_request.State = EntityState.Added; item_requestViewSource.View.MoveCurrentToLast(); }
private void toolBar_btnEdit_Click(object sender) { if (item_requestDataGrid.SelectedItem != null) { item_request item_request_old = (item_request)item_requestDataGrid.SelectedItem; item_request_old.IsSelected = true; item_request_old.State = EntityState.Modified; dbContext.Entry(item_request_old).State = EntityState.Modified; } else { toolBar.msgWarning("Please Select an Item"); } }
private void toolBar_btnCancel_Click(object sender) { // dbContext.CancelAllChanges(); if (item_requestDataGrid.SelectedItem != null) { item_request item_request = (item_request)item_requestDataGrid.SelectedItem; item_request.State = EntityState.Unchanged; dbContext.Entry(item_request).State = EntityState.Unchanged; } else { toolBar.msgWarning("Please Select an Item"); } }
private void toolBar_btnSearch_Click(object sender, string query) { if (!string.IsNullOrEmpty(query) && item_requestViewSource != null) { try { item_requestViewSource.View.Filter = i => { item_request item_request = i as item_request; if (item_request != null) { //Protect the code against null values. //string number = item_request.number != null ? item_request.number : ""; string name = item_request.name != null ? item_request.name : ""; if ((name.ToLower().Contains(query.ToLower())) ) { return(true); } else { return(false); } } else { return(false); } }; } catch //(Exception ex) { //throw ex; } } else { item_requestViewSource.View.Filter = null; } }
private void sbxItem_Select(object sender, RoutedEventArgs e) { if (sbxItem.ItemID > 0) { item item = ItemDB.items.Where(x => x.id_item == sbxItem.ItemID).FirstOrDefault(); if (item != null) { item_request item_request = item_requestViewSource.View.CurrentItem as item_request; if (item_request != null) { item_request_detail item_request_detail = new item_request_detail(); item_request_detail.id_item = sbxItem.ItemID; item_request_detail.item = item; item_request_detail.quantity = 1; item_request_detail.urgency = entity.item_request_detail.Urgencies.Medium; item_request.item_request_detail.Add(item_request_detail); item_requestitem_request_detailViewSource.View.Refresh(); } } } }
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; }