protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5WH_SWwBAaDA_1608 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_Guid();
//Put your code here
// Create delivery address for warehouse
Guid deliveryAddressID = Guid.Empty;
if (Parameter.SaveDeliveryAddressParam.City_Name != null && Parameter.SaveDeliveryAddressParam.City_Name != String.Empty)
{
deliveryAddressID = cls_Save_Address.Invoke(Connection, Transaction, Parameter.SaveDeliveryAddressParam, securityTicket).Result;
Parameter.SaveWarehouseParam.DeliveryAddress_RefID = deliveryAddressID;
}
// Create warehouse
if (Parameter.SaveWarehouseParam.IsDefaultShipmentWarehouse)
{
var defaultWarehouseParam = new ORM_LOG_WRH_Warehouse.Query()
{
IsDefaultShipmentWarehouse = true, Tenant_RefID = securityTicket.TenantID, IsDeleted = false
};
var defaultWarehouses = ORM_LOG_WRH_Warehouse.Query.Search(Connection, Transaction, defaultWarehouseParam);
if (defaultWarehouses != null && defaultWarehouses.Count > 0)
{
foreach (var defaultWH in defaultWarehouses)
{
defaultWH.IsDefaultShipmentWarehouse = false;
defaultWH.Save(Connection, Transaction);
}
}
}
var savedWarehouseID = cls_Save_Warehouse.Invoke(Connection, Transaction, Parameter.SaveWarehouseParam, securityTicket).Result;
if (Parameter.SaveWarehouseParam.IsDeleted)
{
ORM_CMN_PRO_DistributionCenter.Query distributionCentersQuery = new ORM_CMN_PRO_DistributionCenter.Query();
distributionCentersQuery.Warehouse_RefID = savedWarehouseID;
distributionCentersQuery.Tenant_RefID = securityTicket.TenantID;
distributionCentersQuery.IsDeleted = false;
List <ORM_CMN_PRO_DistributionCenter> distributionCentersList = ORM_CMN_PRO_DistributionCenter.Query.Search(Connection, Transaction, distributionCentersQuery);
foreach (var distributionCenter in distributionCentersList)
{
distributionCenter.IsDeleted = true;
distributionCenter.Save(Connection, Transaction);
}
}
returnValue.Result = savedWarehouseID;
return(returnValue);
#endregion UserCode
}
protected static FR_Bool Execute(DbConnection Connection, DbTransaction Transaction, P_L5PD_SDC_1531 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Bool();
returnValue.Result = true;
//Put your code here
ORM_CMN_PRO_DistributionCenter.Query distributionCentersQuery = new ORM_CMN_PRO_DistributionCenter.Query();
distributionCentersQuery.Product_RefID = Parameter.ProductID;
distributionCentersQuery.Tenant_RefID = securityTicket.TenantID;
distributionCentersQuery.IsDeleted = false;
List <ORM_CMN_PRO_DistributionCenter> distributionCentersList = ORM_CMN_PRO_DistributionCenter.Query.Search(Connection, Transaction, distributionCentersQuery);
ORM_CMN_PRO_DistributionCenter distributionCenter;
foreach (var area in Parameter.DistributionAreasWithWarehouses)
{
if (distributionCentersList.Any(i => i.LOG_REG_DistributionArea_RefID == area.DistributionAreaID))
{
// edit
distributionCenter = distributionCentersList.First(i => i.LOG_REG_DistributionArea_RefID == area.DistributionAreaID);
if (area.WarehouseID == Guid.Empty)
{
distributionCenter.Remove(Connection, Transaction);
continue;
}
distributionCenter.Warehouse_RefID = area.WarehouseID;
distributionCenter.Save(Connection, Transaction);
}
else
{
if (area.WarehouseID == Guid.Empty)
{
continue;
}
// create new
distributionCenter = new ORM_CMN_PRO_DistributionCenter();
distributionCenter.Warehouse_RefID = area.WarehouseID;
distributionCenter.Product_RefID = Parameter.ProductID;
distributionCenter.Tenant_RefID = securityTicket.TenantID;
distributionCenter.LOG_REG_DistributionArea_RefID = area.DistributionAreaID;
distributionCenter.Save(Connection, Transaction);
}
}
return(returnValue);
#endregion UserCode
}
protected static FR_L5PD_GERwWfT_0955 Execute(DbConnection Connection, DbTransaction Transaction, P_L5PD_GERwWfT_0955 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L5PD_GERwWfT_0955();
//Put your code here
L5PD_GERwWfT_0955 retVal = new L5PD_GERwWfT_0955();
List <L5PD_GERwWfT_0955a> distributionAreasWithWarehouses = new List <L5PD_GERwWfT_0955a>();
L2WH_GWHfIoT_1442[] warehouses = new L2WH_GWHfIoT_1442[0];
#region Get Distribution Areas
var distributionAreaResult = cls_Get_DistributionAreas_for_Tenant.Invoke(Connection, Transaction, securityTicket);
if (distributionAreaResult != null && distributionAreaResult.Result != null)
{
distributionAreasWithWarehouses.AddRange(distributionAreaResult.Result.Select(i => new L5PD_GERwWfT_0955a()
{
DistributionArea = i,
WarehouseID = Guid.Empty
}).ToList());
}
#endregion
#region Get Warehouses
P_L2WH_GWHfIoT_1442 warehousesParameter = new P_L2WH_GWHfIoT_1442();
warehousesParameter.WarehouseID = null;
var warehousesResult = cls_Get_Warehouse_for_ID_or_TenantID.Invoke(Connection, Transaction, warehousesParameter, securityTicket);
if (warehousesResult != null && warehousesResult.Result != null)
{
warehouses = warehousesResult.Result.OrderBy(i => i.Warehouse_Name).ToArray();
}
#endregion
#region Get Distribution Centers
ORM_CMN_PRO_DistributionCenter.Query distributionCentersQuery = new ORM_CMN_PRO_DistributionCenter.Query();
distributionCentersQuery.Product_RefID = Parameter.ProductID;
distributionCentersQuery.Tenant_RefID = securityTicket.TenantID;
distributionCentersQuery.IsDeleted = false;
List <ORM_CMN_PRO_DistributionCenter> distributionCentersList = ORM_CMN_PRO_DistributionCenter.Query.Search(Connection, Transaction, distributionCentersQuery);
foreach (var center in distributionCentersList)
{
if (center.LOG_REG_DistributionArea_RefID == Guid.Empty)
{
distributionAreasWithWarehouses.Add(new L5PD_GERwWfT_0955a()
{
WarehouseID = center.Warehouse_RefID,
DistributionArea = new L3DA_GDAfT_1442()
{
LOG_REG_DistributionAreaID = Guid.Empty
}
});
}
else if (distributionAreasWithWarehouses.Any(i => i.DistributionArea.LOG_REG_DistributionAreaID == center.LOG_REG_DistributionArea_RefID))
{
distributionAreasWithWarehouses
.First(i => i.DistributionArea.LOG_REG_DistributionAreaID == center.LOG_REG_DistributionArea_RefID)
.WarehouseID = center.Warehouse_RefID;
}
}
#endregion
retVal.DistributionAreasWithWarehouses = distributionAreasWithWarehouses.ToArray();
retVal.Warehouses = warehouses;
returnValue.Result = retVal;
return(returnValue);
#endregion UserCode
}
