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 = EmployeesDataContext.modelNotifiedForEmployeesMain;
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();
}
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 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 ModelNotifiedForEmployees GetEmployeesByID(int EmployeeID, out string error)
{
error = null;
EmployeesGenericREST EmployeesGenericREST = new EmployeesGenericREST(wpfConfig);
GetEmployeesView getEmployeesView = EmployeesGenericREST.GetByPK <GetEmployeesView>(EmployeeID, out error)[0];
ModelNotifiedForEmployees modelNotifiedForEmployees = new ModelNotifiedForEmployees();
Cloner.CopyAllTo(typeof(GetEmployeesView), getEmployeesView, typeof(ModelNotifiedForEmployees), modelNotifiedForEmployees);
return(modelNotifiedForEmployees);
}
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 ModelNotifiedForEmployees GetEmployeesByID(int EmployeeID, out string error)
{
error = null;
EmployeesBsn bsn = new EmployeesBsn(wpfConfig);
EmployeesInfo dbItem = bsn.GetValueByID(EmployeeID);
ModelNotifiedForEmployees item = new ModelNotifiedForEmployees();
Cloner.CopyAllTo(typeof(EmployeesInfo), dbItem, typeof(ModelNotifiedForEmployees), item);
return(item);
}
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);
}
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);
}
/// <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);
}
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;
}
}
}
