protected static FR_L5SO_DSP_1449 Execute(DbConnection Connection, DbTransaction Transaction, P_L5SO_DSP_1449 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L5SO_DSP_1449();
//get shipment position by ID
CL1_LOG_SHP.ORM_LOG_SHP_Shipment_Position shipmentPositionToDelete = new ORM_LOG_SHP_Shipment_Position();
shipmentPositionToDelete.Load(Connection, Transaction, Parameter.PositionID);
ORM_LOG_RSV_Reservation.Query.SoftDelete(Connection, Transaction,
new ORM_LOG_RSV_Reservation.Query
{
LOG_SHP_Shipment_Position_RefID = shipmentPositionToDelete.LOG_SHP_Shipment_PositionID,
IsDeleted = false
});
//remove shipment position
shipmentPositionToDelete.Remove(Connection, Transaction);
// update header total value
cls_Update_Current_TotalValue_on_ShipmentHeader_from_Positions.Invoke(Connection, Transaction, new P_L5SO_UCTVoSHfP_1549 {
ShipmentHeaderID = Parameter.ShipmentHeaderID
}, securityTicket);
returnValue.Result = new L5SO_DSP_1449();
returnValue.Result.DeletedPosition = Parameter.PositionID;
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5OD_DPSP_1408 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_Guid();
ORM_HEC_ShippingPosition_BarcodeLabel shippmentLabel = new ORM_HEC_ShippingPosition_BarcodeLabel();
var result = shippmentLabel.Load(Connection, Transaction, Parameter.ShippmentLabelID);
if (result.Status != FR_Status.Success || shippmentLabel.HEC_ShippingPosition_BarcodeLabelID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
shippmentLabel.IsDeleted = true;
shippmentLabel.Save(Connection, Transaction);
ORM_LOG_SHP_Shipment_Position logShippmentPosition = new ORM_LOG_SHP_Shipment_Position();
var result1 = logShippmentPosition.Load(Connection, Transaction, shippmentLabel.LOG_SHP_Shipment_Position_RefID);
if (result1.Status != FR_Status.Success || logShippmentPosition.LOG_SHP_Shipment_PositionID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
logShippmentPosition.IsDeleted = true;
logShippmentPosition.Save(Connection, Transaction);
return(returnValue);
#endregion UserCode
}
protected static FR_L5SO_SSPC_1240 Execute(DbConnection Connection, DbTransaction Transaction, P_L5SO_SSPC_1240 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L5SO_SSPC_1240();
//Put your code here
returnValue.Result = new L5SO_SSPC_1240();
//saving quantities and prices for positions
foreach (var correction in Parameter.Corrections)
{
var shipmentPosition = new ORM_LOG_SHP_Shipment_Position();
shipmentPosition.Load(Connection, Transaction, correction.PositionID);
shipmentPosition.QuantityToShip = correction.ChangedQuantity;
shipmentPosition.ShipmentPosition_PricePerUnitValueWithoutTax = correction.UnitPrice;
shipmentPosition.ShipmentPosition_ValueWithoutTax = Convert.ToDecimal(shipmentPosition.QuantityToShip) * correction.UnitPrice;
shipmentPosition.Save(Connection, Transaction);
}
//update shipment header
cls_Update_Current_TotalValue_on_ShipmentHeader_from_Positions.
Invoke(Connection, Transaction, new P_L5SO_UCTVoSHfP_1549 {
ShipmentHeaderID = Parameter.ShipmentHeaderID
}, securityTicket);
#endregion
returnValue.Result.IsSaved = true;
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L2SH_SLSSP_1413 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
var item = new ORM_LOG_SHP_Shipment_Position();
if (Parameter.LOG_SHP_Shipment_PositionID != Guid.Empty)
{
var result = item.Load(Connection, Transaction, Parameter.LOG_SHP_Shipment_PositionID);
}
if (Parameter.IsDeleted == true)
{
item.IsDeleted = true;
return(new FR_Guid(item.Save(Connection, Transaction), item.LOG_SHP_Shipment_PositionID));
}
//Creation specific parameters (Tenant, Account ... )
if (Parameter.LOG_SHP_Shipment_PositionID == Guid.Empty)
{
item.Tenant_RefID = securityTicket.TenantID;
}
item.ShipmentPositionITL = Parameter.ShipmentPositionITL;
item.LOG_SHP_Shipment_Header_RefID = Parameter.LOG_SHP_Shipment_Header_RefID;
item.CMN_PRO_Product_RefID = Parameter.CMN_PRO_Product_RefID;
item.CMN_PRO_ProductVariant_RefID = Parameter.CMN_PRO_ProductVariant_RefID;
item.CMN_PRO_ProductRelease_RefID = Parameter.CMN_PRO_ProductRelease_RefID;
item.TrackingInstance_ToShip_RefID = Parameter.TrackingInstance_ToShip_RefID;
item.QuantityToShip = Parameter.QuantityToShip;
item.ShipmentPosition_PricePerUnitValueWithoutTax = Parameter.ShipmentPosition_PricePerUnitValueWithoutTax;
item.ShipmentPosition_ValueWithoutTax = Parameter.ShipmentPosition_PricePerUnitValueWithoutTax * Convert.ToDecimal(item.QuantityToShip);
return(new FR_Guid(item.Save(Connection, Transaction), item.LOG_SHP_Shipment_PositionID));
#endregion UserCode
}
protected static FR_L5SO_RSP_1524 Execute(DbConnection Connection, DbTransaction Transaction, P_L5SO_RSP_1524 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L5SO_RSP_1524();
returnValue.Result = new L5SO_RSP_1524();
var shipmentPositionToReplace = new ORM_LOG_SHP_Shipment_Position();
shipmentPositionToReplace.Load(Connection, Transaction, Parameter.PositionID);
var startProduct = new ORM_CMN_PRO_Product();
startProduct.Load(Connection, Transaction, shipmentPositionToReplace.CMN_PRO_Product_RefID);
var finalProduct = new ORM_CMN_PRO_Product();
finalProduct.Load(Connection, Transaction, Parameter.ProductID);
shipmentPositionToReplace.ShipmentPosition_PricePerUnitValueWithoutTax = Parameter.Price;
shipmentPositionToReplace.ShipmentPosition_ValueWithoutTax = Parameter.Price * (Decimal)shipmentPositionToReplace.QuantityToShip;
shipmentPositionToReplace.CMN_PRO_Product_RefID = Parameter.ProductID;
returnValue.Result.ReplacedPosition = new FR_Guid(shipmentPositionToReplace.Save(Connection, Transaction), shipmentPositionToReplace.LOG_SHP_Shipment_PositionID).Result;
P_L2LN_GALFTID_1530 langParam = new P_L2LN_GALFTID_1530();
langParam.Tenant_RefID = securityTicket.TenantID;
SessionSecurityTicket fakeTicket = new SessionSecurityTicket();
var DBLanguages = cls_Get_All_Languages_ForTenantID.Invoke(Connection, Transaction, langParam, fakeTicket).Result;
var languages = DBLanguages.Select(i => new ISOLanguage()
{
ISO = i.ISO_639_1, LanguageID = i.CMN_LanguageID
}).ToList();
var dicts = EnumUtils.GetDictObjectsForStaticListData <ECustomMessages>(ResourceFilePath.CustomMessages, ORM_LOG_SHP_Shipment_Note.TableName, languages);
ORM_LOG_SHP_Shipment_Note note = new ORM_LOG_SHP_Shipment_Note();
note.LOG_SHP_Shipment_NoteID = Guid.NewGuid();
note.Shipment_Header_RefID = Parameter.ShipmentHeaderID;
note.Comment = String.Format(dicts["comment.article-replaced"].Contents[1].Content,
startProduct.Product_Name.Contents[0].Content, startProduct.Product_Number, finalProduct.Product_Name.Contents[0].Content, finalProduct.Product_Number);
note.Tenant_RefID = securityTicket.TenantID;
note.IsNotePrintedOnDeliveryPaper = true;
note.Save(Connection, Transaction);
returnValue.Result.ReplacedPosition = new FR_Guid(shipmentPositionToReplace.Save(Connection, Transaction), shipmentPositionToReplace.LOG_SHP_Shipment_PositionID).Result;
ORM_LOG_RSV_Reservation.Query.SoftDelete(Connection, Transaction,
new ORM_LOG_RSV_Reservation.Query
{
LOG_SHP_Shipment_Position_RefID = shipmentPositionToReplace.LOG_SHP_Shipment_PositionID,
IsDeleted = false
});
#region CommentedUseful
#endregion
cls_Update_Current_TotalValue_on_ShipmentHeader_from_Positions.Invoke(Connection, Transaction, new P_L5SO_UCTVoSHfP_1549 {
ShipmentHeaderID = Parameter.ShipmentHeaderID
}, securityTicket);
return(returnValue);
#endregion UserCode
}