private void DeleteClick(object sender, RoutedEventArgs e) { MessageBoxButton button = MessageBoxButton.YesNo; MessageBoxImage icon = MessageBoxImage.Warning; //MessageBoxResult result = MessageBox.Show(MessageBoxDeleteConfirm, MessageBoxDeleteConfirmCaption, button, icon); MessageBoxResult result = MessageBox.Show(EmployeesDataContext.WPFMessageAndLabelForList.MessageBoxDeleteConfirm, EmployeesDataContext.WPFMessageAndLabelForList.MessageBoxDeleteConfirmCaption, button, icon); string error = null; switch (result) { case MessageBoxResult.Yes: ModelNotifiedForEmployees itemSelected = (ModelNotifiedForEmployees)DataGridEmployees.SelectedItem; dataConnection.DeleteData(itemSelected, out error); if (string.IsNullOrEmpty(error)) { EmployeesDataContext.modelNotifiedForEmployeesMain.Remove(itemSelected); } break; case MessageBoxResult.No: return; } if (error != null) { MessageBox.Show(error); } else { //MessageBox.Show(MessageBoxDeleteOK); MessageBox.Show(EmployeesDataContext.WPFMessageAndLabelForList.MessageBoxDeleteOK); btnReload_Click(null, null); } }
private void SaveNxNComboFor_EmployeeTerritories(ModelNotifiedForEmployees modelNotifiedForEmployees, out string error) { error = null; EmployeeTerritoriesBsn bsn = new EmployeeTerritoriesBsn(wpfConfig); foreach (ModelNotifiedForTerritories item in modelNotifiedForEmployees.LookDownComboDataTerritories) { if (item.ItemChanged) { item.ItemChanged = false; EmployeeTerritoriesInfo itemToAddOrDelete = new EmployeeTerritoriesInfo(); //Setting NxN object to include/delete itemToAddOrDelete.EmployeeID = modelNotifiedForEmployees.EmployeeID; itemToAddOrDelete.TerritoryID = item.TerritoryID; if (item.Check_Status) { bsn.InsertOne(itemToAddOrDelete, out error); } else { bsn.Delete(itemToAddOrDelete, out error); } } } }
private void btnOpenSimpleList_Territories_Click(object sender, RoutedEventArgs e) { ModelNotifiedForEmployees itemSelected = (ModelNotifiedForEmployees)DataGridEmployees.SelectedItem; Container_HelperWPFDataGrid container = new Container_HelperWPFDataGrid(); container.Data = itemSelected.LookDownComboDataTerritories; List <ColumnParametertInGrid> columnsInGrid = new List <ColumnParametertInGrid>(); ColumnParametertInGrid checkBoxColumn = new ColumnParametertInGrid(); ColumnParametertInGrid displayColumn = new ColumnParametertInGrid(); //Setting the checkbox field checkBoxColumn.FieldName = "Check_Status"; checkBoxColumn.FieldHeader = ""; checkBoxColumn.UserCanEdit = true; columnsInGrid.Add(checkBoxColumn); //Setting display field displayColumn.FieldName = "TerritoryDescription"; displayColumn.FieldHeader = "TerritoryDescription"; displayColumn.UserCanEdit = false; columnsInGrid.Add(displayColumn); container.ColumnsInGrid = columnsInGrid; //Setting the sortering: first the checked itens, then the display field //Example: "Col1;desc,Col2;asc" container.DefaultOrdering = "Check_Status;desc,TerritoryDescription;asc"; frmPopUpSimpleList frmPopUpSimpleList = new frmPopUpSimpleList(container); frmPopUpSimpleList.Show(); frmPopUpSimpleList.ApplyGridSetup(); }
//private void CollectionChanged(object sender, NotifyCollectionChangedEventArgs e) //{ //Notify("IncludeFolders"); //} public List <ModelNotifiedForEmployees> GetAllEmployees(out string error) { error = null; try { EmployeesBsn bsn = new EmployeesBsn(wpfConfig); List <EmployeesInfo> dbItems = bsn.GetAll(); List <ModelNotifiedForEmployees> notifiedItems = new List <ModelNotifiedForEmployees>(); foreach (EmployeesInfo dbItem in dbItems) { ModelNotifiedForEmployees itemToAdd = new ModelNotifiedForEmployees(); Cloner.CopyAllTo(typeof(EmployeesInfo), dbItem, typeof(ModelNotifiedForEmployees), itemToAdd); itemToAdd.ItemChanged = false; itemToAdd.NewItem = false; notifiedItems.Add(itemToAdd); } return(notifiedItems); } catch (Exception ex) { error = ex.Message; } return(null); }
private void btnExcludePhoto_Click(object sender, RoutedEventArgs e) { ModelNotifiedForEmployees itemSelected = (ModelNotifiedForEmployees)DataGridEmployees.SelectedItem; itemSelected.Photo = null; itemSelected.BtnAddPhotoVisibility = Visibility.Visible; itemSelected.BtnExcludePhotoVisibility = Visibility.Collapsed; }
public void DeleteData(ModelNotifiedForEmployees modelNotifiedForEmployees, out string error) { EmployeesBsn bsn = new EmployeesBsn(wpfConfig); EmployeesInfo dbItem = new EmployeesInfo(); Cloner.CopyAllTo(typeof(ModelNotifiedForEmployees), modelNotifiedForEmployees, typeof(EmployeesInfo), dbItem); bsn.DeleteByID(dbItem, out error); }
public void DeleteData(ModelNotifiedForEmployees modelNotifiedForEmployees, out string error) { EmployeesGenericREST EmployeesGenericREST = new EmployeesGenericREST(wpfConfig); DeleteEmployeesView deleteEmployeesView = new DeleteEmployeesView(); Cloner.CopyAllTo(typeof(ModelNotifiedForEmployees), modelNotifiedForEmployees, typeof(DeleteEmployeesView), deleteEmployeesView); EmployeesGenericREST.Delete(deleteEmployeesView, out error); }
public void AddData(ModelNotifiedForEmployees modelNotifiedForEmployees, out string error) { EmployeesGenericREST EmployeesGenericREST = new EmployeesGenericREST(wpfConfig); CreateEmployeesView createEmployeesView = new CreateEmployeesView(); Cloner.CopyAllTo(typeof(ModelNotifiedForEmployees), modelNotifiedForEmployees, typeof(CreateEmployeesView), createEmployeesView); EmployeesGenericREST.Insert(createEmployeesView, out error); }
public void AddData(ModelNotifiedForEmployees modelNotifiedForEmployees, out string error) { EmployeesBsn bsn = new EmployeesBsn(wpfConfig); EmployeesInfo dbItem = new EmployeesInfo(); Cloner.CopyAllTo(typeof(ModelNotifiedForEmployees), modelNotifiedForEmployees, typeof(EmployeesInfo), dbItem); bsn.InsertOne(dbItem, out error); modelNotifiedForEmployees.NewItem = false; Cloner.CopyAllTo(typeof(EmployeesInfo), dbItem, typeof(ModelNotifiedForEmployees), modelNotifiedForEmployees); }
public void SaveData(ModelNotifiedForEmployees modelNotifiedForEmployees, out string error) { EmployeesGenericREST EmployeesGenericREST = new EmployeesGenericREST(wpfConfig); UpdateEmployeesView updateEmployeesView = new UpdateEmployeesView(); Cloner.CopyAllTo(typeof(ModelNotifiedForEmployees), modelNotifiedForEmployees, typeof(UpdateEmployeesView), updateEmployeesView); EmployeesGenericREST.Update(updateEmployeesView, out error); //Saving NxN data for: EmployeeTerritories SaveNxNComboFor_EmployeeTerritories(modelNotifiedForEmployees, out error); }
private void btnAddPhoto_Click(object sender, RoutedEventArgs e) { ModelNotifiedForEmployees itemSelected = (ModelNotifiedForEmployees)DataGridEmployees.SelectedItem; frmDisplayBinaryData frmDisplayBinaryData = new frmDisplayBinaryData(itemSelected.Photo, GlobalEnums.MimeTypes.Image); frmDisplayBinaryData.ShowDialog(); //frmDisplayBinaryData.Owner = ToDo. Without owner, alt tab can bug itemSelected.Photo = frmDisplayBinaryData.myViewModel.BinData; itemSelected.BtnAddPhotoVisibility = Visibility.Collapsed; itemSelected.BtnExcludePhotoVisibility = Visibility.Visible; }
/// <summary> /// Triggered by change in grid's row. /// </summary> private void OnSelectionChanged(object sender, SelectionChangedEventArgs e) { if ((DataGridEmployees.SelectedItem == null) || DataGridEmployees.SelectedItem.GetType() != typeof(ModelNotifiedForEmployees)) { //New row on grid's bottom. By default do nothing when new row is included return; } ModelNotifiedForEmployees selectedItem = (ModelNotifiedForEmployees)DataGridEmployees.SelectedItem; LoadDetail(selectedItem); }
public void SaveData(ModelNotifiedForEmployees modelNotifiedForEmployees, out string error) { EmployeesBsn bsn = new EmployeesBsn(wpfConfig); EmployeesInfo dbItem = new EmployeesInfo(); Cloner.CopyAllTo(typeof(ModelNotifiedForEmployees), modelNotifiedForEmployees, typeof(EmployeesInfo), dbItem); //Saving NxN data fro: EmployeeTerritories SaveNxNComboFor_EmployeeTerritories(modelNotifiedForEmployees, out error); bsn.UpdateOne(dbItem, out error); }
private void OnMouseUpBinary(object sender, MouseButtonEventArgs e) { Image image = sender as Image; ModelNotifiedForEmployees itemSelected = (ModelNotifiedForEmployees)DataGridEmployees.SelectedItem; if (image.Tag.ToString().ToLower() == "Photo".ToLower()) { frmDisplayBinaryData frmDisplayBinaryData = new frmDisplayBinaryData(itemSelected.Photo, GlobalEnums.MimeTypes.Image); frmDisplayBinaryData.ShowDialog(); //frmDisplayBinaryData.Owner = ToDo. Without owner, alt tab can bug itemSelected.Photo = frmDisplayBinaryData.myViewModel.BinData; return; } MessageBox.Show("Error: 'btnSaveBinAs' does not contains the tag reference to target binary column."); }
/// <summary> /// Retrieve all data from Employees table. Used to fill combo box. /// </summary> /// <returns>List of Employees</returns> public List <ModelNotifiedForEmployees> GetAll_Employees(out string error) { error = null; EmployeesBsn bsn = new EmployeesBsn(wpfConfig); List <EmployeesInfo> dbItems = bsn.GetAll(); List <ModelNotifiedForEmployees> notifiedItems = new List <ModelNotifiedForEmployees>(); foreach (EmployeesInfo dbItem in dbItems) { ModelNotifiedForEmployees itemToAdd = new ModelNotifiedForEmployees(); Cloner.CopyAllTo(typeof(EmployeesInfo), dbItem, typeof(ModelNotifiedForEmployees), itemToAdd); notifiedItems.Add(itemToAdd); } return(notifiedItems); }
/// <summary> /// Load Detail form/list in master detail. Triggered by user's change in Grid's Row. /// When row change, load "DetailForm" or "Detail List" (need to be configured) /// </summary> /// <param name="selectedItem"></param> private void LoadDetail(ModelNotifiedForEmployees selectedItem) { if (selectedItem == null) { return; } if (DetailListEmployeeTerritories != null) { DetailListEmployeeTerritories.LoadGrid(x => x.EmployeeID == selectedItem.EmployeeID); } if (DetailListOrders != null) { DetailListOrders.LoadGrid(x => x.EmployeeID == selectedItem.EmployeeID); } if (DetailListTagEmployee != null) { DetailListTagEmployee.LoadGrid(x => x.EmployeeIDFK == selectedItem.EmployeeID); } /* Note: the detail form can load only ONE row from 'EmployeeTerritories'. It's necessary to inform DetailForm primary key here or create a custom Form.Load(). * if (DetailForm{0} != null) * { * //DetailFormEmployeeTerritories.LoadForm(selectedItem.EmployeeID); * } */ /* Note: the detail form can load only ONE row from 'Orders'. It's necessary to inform DetailForm primary key here or create a custom Form.Load(). * if (DetailForm{0} != null) * { * //DetailFormOrders.LoadForm(selectedItem.EmployeeID); * } */ /* Note: the detail form can load only ONE row from 'TagEmployee'. It's necessary to inform DetailForm primary key here or create a custom Form.Load(). * if (DetailForm{0} != null) * { * //DetailFormTagEmployee.LoadForm(selectedItem.EmployeeID); * } */ }
private void SaveNxNComboFor_EmployeeTerritories(ModelNotifiedForEmployees modelNotifiedForEmployees, out string error) { error = null; EmployeeTerritoriesGenericREST EmployeeTerritoriesGenericREST = new EmployeeTerritoriesGenericREST(wpfConfig); foreach (ModelNotifiedForTerritories item in modelNotifiedForEmployees.LookDownComboDataTerritories) { if (item.ItemChanged) { if (item.Check_Status) { CreateEmployeeTerritoriesView itemToAdd = new CreateEmployeeTerritoriesView(); //Setting NxN object to include/delete itemToAdd.EmployeeID = modelNotifiedForEmployees.EmployeeID; itemToAdd.TerritoryID = item.TerritoryID; EmployeeTerritoriesGenericREST.Insert(itemToAdd, out error); } else { DeleteEmployeeTerritoriesView itemToDelete = new DeleteEmployeeTerritoriesView(); //Setting NxN object to include/delete itemToDelete.EmployeeID = modelNotifiedForEmployees.EmployeeID; itemToDelete.TerritoryID = item.TerritoryID; EmployeeTerritoriesGenericREST.Delete(itemToDelete, out error); } if (error != null) { return; } item.ItemChanged = false; } } }
private void SaveClick(object sender, RoutedEventArgs e) { ModelNotifiedForEmployees itemSelected = (ModelNotifiedForEmployees)DataGridEmployees.SelectedItem; if (itemSelected == null) { return; } string error = null; if (itemSelected.NewItem) { dataConnection.AddData(itemSelected, out error); if (error == null) { btnReload_Click(null, null); } } else { dataConnection.SaveData(itemSelected, out error); } if (error == null) { //MessageBox.Show(MessageBoxSaveOK); MessageBox.Show(EmployeesDataContext.WPFMessageAndLabelForList.MessageBoxSaveOK); } else { //MessageBox.Show(MessageBoxSaveError + error); MessageBox.Show(EmployeesDataContext.WPFMessageAndLabelForList.MessageBoxSaveError + error); } }
private void OpenFormClick(object sender, RoutedEventArgs e) { ModelNotifiedForEmployees itemSelected = (ModelNotifiedForEmployees)DataGridEmployees.SelectedItem; if (itemSelected == null) { return; } //Uncomment this line to allow navigation //this.FrameMainWindow.Navigate(this.DetailListGeoCities); /* COMPILE ERROR WARNING!!! If this line crash: * a) Generate the FORM version of this list. * b) Re-generate the LIST without the "OpenForm" feature.# * c) Remove this chunk of code*/ MyApp.WPFForms.Employees.FormWPFEmployees page = new MyApp.WPFForms.Employees.FormWPFEmployees(config); page.LoadForm(itemSelected.EmployeeID); page.Setup_SetLanguage(CurrentLanguage); ContainerWindowSimple win = new ContainerWindowSimple(page, "Form Employees"); win.Show(); }
private List <ModelNotifiedForEmployees> FilterGrid(string filterValue) { filterValue = filterValue.ToLower(); List <ModelNotifiedForEmployees> filteredList = new List <ModelNotifiedForEmployees>(); foreach (ModelNotifiedForEmployees item in EmployeesDataContext.modelNotifiedForEmployeesMain) { if (item.EmployeeID.ToString().ToLower().Contains(filterValue)) { filteredList.Add(item); continue; } //Filter string values. if (item.LastName != null) { if (item.LastName.ToLower().Contains(filterValue)) { filteredList.Add(item); continue; } } if (item.FirstName != null) { if (item.FirstName.ToLower().Contains(filterValue)) { filteredList.Add(item); continue; } } if (item.Title != null) { if (item.Title.ToLower().Contains(filterValue)) { filteredList.Add(item); continue; } } if (item.TitleOfCourtesy != null) { if (item.TitleOfCourtesy.ToLower().Contains(filterValue)) { filteredList.Add(item); continue; } } if (item.Address != null) { if (item.Address.ToLower().Contains(filterValue)) { filteredList.Add(item); continue; } } if (item.City != null) { if (item.City.ToLower().Contains(filterValue)) { filteredList.Add(item); continue; } } if (item.Region != null) { if (item.Region.ToLower().Contains(filterValue)) { filteredList.Add(item); continue; } } if (item.PostalCode != null) { if (item.PostalCode.ToLower().Contains(filterValue)) { filteredList.Add(item); continue; } } if (item.Country != null) { if (item.Country.ToLower().Contains(filterValue)) { filteredList.Add(item); continue; } } if (item.HomePhone != null) { if (item.HomePhone.ToLower().Contains(filterValue)) { filteredList.Add(item); continue; } } if (item.Extension != null) { if (item.Extension.ToLower().Contains(filterValue)) { filteredList.Add(item); continue; } } if (item.Notes != null) { if (item.Notes.ToLower().Contains(filterValue)) { filteredList.Add(item); continue; } } if (item.PhotoPath != null) { if (item.PhotoPath.ToLower().Contains(filterValue)) { filteredList.Add(item); continue; } } //Filter FK values. if (item.ReportsTo != null) { ModelNotifiedForEmployees comboItem = EmployeesDataContext.modelNotifiedForEmployees.Where(x => x.EmployeeID == item.ReportsTo).FirstOrDefault(); if ((comboItem != null) && (comboItem.LastName != null) && (comboItem.LastName.ToLower().Contains(filterValue))) { filteredList.Add(item); continue; } } } return(filteredList); }