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