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);
}
}
}
}
/// <summary>
/// Get all itens filtering direct in DB. Up: More optimized because filters DB. Down: less flexible, don't support dynamic filters.
/// </summary>
/// <param name="generalBodyGet"></param>
/// <param name="error"></param>
/// <returns></returns>
public List <GetEmployeeTerritoriesView> GetAllWithDBFilter(GeneralBodyGet generalBodyGet, out RestExceptionError error)
{
try
{
if ((generalBodyGet == null) || (generalBodyGet.Filters == null) || (generalBodyGet.Filters.Count == 0))
{
error = new RestExceptionError();
error.ExceptionMessage = "";
error.InternalMessage = "Url does not contains filter section";
}
error = null;
EmployeeTerritoriesBsn bsn = new EmployeeTerritoriesBsn(restConfig);
List <DataFilterExpressionDB> dbFilter = HelperRESTFilterToDB.FilterRestFilterToDBExpression(generalBodyGet.Filters);
List <EmployeeTerritoriesInfo> dbItems = bsn.GetAll(dbFilter);
List <GetEmployeeTerritoriesView> result = new List <GetEmployeeTerritoriesView>();
foreach (EmployeeTerritoriesInfo item in dbItems)
{
GetEmployeeTerritoriesView view = new GetEmployeeTerritoriesView();
Cloner.CopyAllTo(typeof(EmployeeTerritoriesInfo), item, typeof(GetEmployeeTerritoriesView), view);
result.Add(view);
}
return(result);
}
catch (Exception ex)
{
error = new RestExceptionError();
error.ExceptionMessage = ex.Message;
}
return(null);
}
/// <summary>
/// Get all itens to populate NXN relation used in ComboNxNEmployeeTerritories
/// </summary>
public List <ModelNotifiedForEmployeeTerritories> GetAllEmployeeTerritories(int EmployeeID, out string error)
{
error = null;
try
{
EmployeeTerritoriesBsn bsn = new EmployeeTerritoriesBsn(wpfConfig);
EmployeeTerritoriesInfo filter = new EmployeeTerritoriesInfo();
filter.EmployeeID = EmployeeID;
List <EmployeeTerritoriesInfo> dbItems = bsn.GetSome(filter);
List <ModelNotifiedForEmployeeTerritories> notifiedItems = new List <ModelNotifiedForEmployeeTerritories>();
foreach (EmployeeTerritoriesInfo dbItem in dbItems)
{
ModelNotifiedForEmployeeTerritories itemToAdd = new ModelNotifiedForEmployeeTerritories();
Cloner.CopyAllTo(typeof(EmployeeTerritoriesInfo), dbItem, typeof(ModelNotifiedForEmployeeTerritories), itemToAdd);
itemToAdd.ItemChanged = false;
notifiedItems.Add(itemToAdd);
}
return(notifiedItems);
}
catch (Exception ex)
{
error = ex.Message;
}
return(null);
}
public void DeleteData(ModelNotifiedForEmployeeTerritories modelNotifiedForEmployeeTerritories, out string error)
{
EmployeeTerritoriesBsn bsn = new EmployeeTerritoriesBsn(wpfConfig);
EmployeeTerritoriesInfo dbItem = new EmployeeTerritoriesInfo();
Cloner.CopyAllTo(typeof(ModelNotifiedForEmployeeTerritories), modelNotifiedForEmployeeTerritories, typeof(EmployeeTerritoriesInfo), dbItem);
bsn.DeleteByID(dbItem, out error);
}
public void AddData(ModelNotifiedForEmployeeTerritories modelNotifiedForEmployeeTerritories, out string error)
{
EmployeeTerritoriesBsn bsn = new EmployeeTerritoriesBsn(wpfConfig);
EmployeeTerritoriesInfo dbItem = new EmployeeTerritoriesInfo();
Cloner.CopyAllTo(typeof(ModelNotifiedForEmployeeTerritories), modelNotifiedForEmployeeTerritories, typeof(EmployeeTerritoriesInfo), dbItem);
bsn.InsertOne(dbItem, out error);
modelNotifiedForEmployeeTerritories.NewItem = false;
Cloner.CopyAllTo(typeof(EmployeeTerritoriesInfo), dbItem, typeof(ModelNotifiedForEmployeeTerritories), modelNotifiedForEmployeeTerritories);
}
public ModelNotifiedForEmployeeTerritories GetEmployeeTerritoriesByID(int EmployeeID, string TerritoryID, out string error)
{
error = null;
EmployeeTerritoriesBsn bsn = new EmployeeTerritoriesBsn(wpfConfig);
EmployeeTerritoriesInfo dbItem = bsn.GetValueByID(EmployeeID, TerritoryID);
ModelNotifiedForEmployeeTerritories item = new ModelNotifiedForEmployeeTerritories();
Cloner.CopyAllTo(typeof(EmployeeTerritoriesInfo), dbItem, typeof(ModelNotifiedForEmployeeTerritories), item);
return(item);
}
public void TryUpdate(UpdateEmployeeTerritoriesView viewToUpdate, out RestExceptionError error)
{
error = null;
EmployeeTerritoriesInfo dbViewToInclude = new EmployeeTerritoriesInfo();
try
{
Cloner.CopyAllTo(typeof(UpdateEmployeeTerritoriesView), viewToUpdate, typeof(EmployeeTerritoriesInfo), dbViewToInclude);
}
catch (Exception ex)
{
error = new RestExceptionError();
error.InternalMessage = "Internal Error parsing data for (EmployeeTerritories.TryUpdate/Parsing)";
error.ExceptionMessage = ex.Message;
error.SourceError = RestExceptionError._SourceError.ServerSide;
error.StackTrace = ex.StackTrace;
}
try
{
EmployeeTerritoriesBsn bsn = new EmployeeTerritoriesBsn(restConfig);
string dbError = null;
bsn.UpdateOne(dbViewToInclude, out dbError);
if (dbError != null)
{
error = new RestExceptionError();
error.InternalMessage = "Internal Error Save data for [EmployeeTerritories.TryUpdate]";
error.ExceptionMessage = dbError;
error.SourceError = RestExceptionError._SourceError.ServerSide;
error.StackTrace = "";
}
}
catch (Exception ex)
{
error = new RestExceptionError();
error.InternalMessage = "Internal Error Update data for [EmployeeTerritories.TryUpdate]";
error.ExceptionMessage = ex.Message;
error.SourceError = RestExceptionError._SourceError.ServerSide;
error.StackTrace = ex.StackTrace;
}
}
public List <GetEmployeeTerritoriesView> GetAll(out RestExceptionError error)
{
try
{
error = null;
EmployeeTerritoriesBsn bsn = new EmployeeTerritoriesBsn(restConfig);
List <EmployeeTerritoriesInfo> dbItems = bsn.GetAll();
List <GetEmployeeTerritoriesView> result = new List <GetEmployeeTerritoriesView>();
foreach (EmployeeTerritoriesInfo item in dbItems)
{
GetEmployeeTerritoriesView view = new GetEmployeeTerritoriesView();
Cloner.CopyAllTo(typeof(EmployeeTerritoriesInfo), item, typeof(GetEmployeeTerritoriesView), view);
result.Add(view);
}
return(result);
}
catch (Exception ex)
{
error = new RestExceptionError();
error.ExceptionMessage = ex.Message;
}
return(null);
}
