/**
* Get Attribute Set Instance from ID or Product
* @param ctx context
* @param M_AttributeSetInstance_ID id or 0
* @param M_Product_ID required if id is 0
* @return Attribute Set Instance or null
*/
public static MAttributeSetInstance Get(Ctx ctx,
int M_AttributeSetInstance_ID, int M_Product_ID)
{
MAttributeSetInstance retValue = null;
// Load Instance if not 0
if (M_AttributeSetInstance_ID != 0)
{
_log.Fine("From M_AttributeSetInstance_ID=" + M_AttributeSetInstance_ID);
return(new MAttributeSetInstance(ctx, M_AttributeSetInstance_ID, null));
}
// Get new from Product
_log.Fine("From M_Product_ID=" + M_Product_ID);
if (M_Product_ID == 0)
{
return(null);
}
String sql = "SELECT M_AttributeSet_ID, M_AttributeSetInstance_ID "
+ "FROM M_Product "
+ "WHERE M_Product_ID=" + M_Product_ID;
DataTable dt = null;
IDataReader idr = null;
try
{
idr = DataBase.DB.ExecuteReader(sql, null, null);
dt = new DataTable();
dt.Load(idr);
idr.Close();
foreach (DataRow dr in dt.Rows)
{
int M_AttributeSet_ID = Utility.Util.GetValueOfInt(dr[0].ToString()); //Convert.ToInt32(dr[0]);//.getInt(1);
// M_AttributeSetInstance_ID = dr.getInt(2); // needed ?
retValue = new MAttributeSetInstance(ctx, 0, M_AttributeSet_ID, null);
}
}
catch (Exception ex)
{
if (idr != null)
{
idr.Close();
}
_log.Log(Level.SEVERE, sql, ex);
}
finally { dt = null; }
return(retValue);
}
// Create Asset From Invoice Mohit
/**
* Shipment Constructor
* @param Invoice
* @param shipLine shipment line
* @param deliveryCount 0 or number of delivery
*/
public MAsset(MInvoice invoice, MInvoiceLine invoiceline, int deliveryCount)
: this(invoiceline.GetCtx(), 0, invoiceline.Get_TrxName())
{
SetClientOrg(invoiceline);
SetValueNameDescription(invoice, invoiceline, deliveryCount);
// Header
//SetIsOwned(true);
SetC_BPartner_ID(invoice.GetC_BPartner_ID());
SetC_BPartner_Location_ID(invoice.GetC_BPartner_Location_ID());
SetAD_User_ID(invoice.GetAD_User_ID());
//SetM_Locator_ID(invoice.GetM_Locator_ID());
SetIsInPosession(true);
SetAssetServiceDate(invoice.GetDateAcct());
// Line
MProduct product = invoiceline.GetProduct();
SetM_Product_ID(product.GetM_Product_ID());
SetA_Asset_Group_ID(product.GetA_Asset_Group_ID());
//////////////////////////////*
//Changes for vafam
// SetAssetServiceDate(shipment.GetMovementDate());
//SetGuaranteeDate(TimeUtil.AddDays(shipment.GetMovementDate(), product.GetGuaranteeDays()));
MAssetGroup _assetGroup = new MAssetGroup(GetCtx(), GetA_Asset_Group_ID(), invoice.Get_TrxName());
if (_assetGroup.IsOwned())
{
SetIsOwned(true);
//SetC_BPartner_ID(0);
}
if (_assetGroup.IsDepreciated())
{
SetIsDepreciated(true);
SetIsFullyDepreciated(false);
}
////////////////////////////////////
//Change by Sukhwinder for setting Asset type and amortization template on Asset window, MANTIS ID:1762
int countVA038 = Util.GetValueOfInt(DB.ExecuteScalar("SELECT COUNT(AD_MODULEINFO_ID) FROM AD_MODULEINFO WHERE PREFIX='VA038_' "));
int countVAFAM = Util.GetValueOfInt(DB.ExecuteScalar("SELECT COUNT(AD_MODULEINFO_ID) FROM AD_MODULEINFO WHERE PREFIX='VAFAM_' "));
if (countVA038 > 0)
{
Set_Value("VA038_AmortizationTemplate_ID", Utility.Util.GetValueOfInt(_assetGroup.Get_Value("VA038_AmortizationTemplate_ID")));
}
if (countVAFAM > 0)
{
Set_Value("VAFAM_AssetType", _assetGroup.Get_Value("VAFAM_AssetType").ToString());
Set_Value("VAFAM_DepreciationType_ID", Utility.Util.GetValueOfInt(_assetGroup.Get_Value("VAFAM_DepreciationType_ID")));
}
////////////////////////////////////
// Guarantee & Version
SetGuaranteeDate(TimeUtil.AddDays(invoice.GetDateInvoiced(), product.GetGuaranteeDays()));
SetVersionNo(product.GetVersionNo());
if (invoiceline.GetM_AttributeSetInstance_ID() != 0) // Instance
{
MAttributeSetInstance asi = new MAttributeSetInstance(GetCtx(), invoiceline.GetM_AttributeSetInstance_ID(), Get_TrxName());
SetM_AttributeSetInstance_ID(asi.GetM_AttributeSetInstance_ID());
SetLot(asi.GetLot());
SetSerNo(asi.GetSerNo());
}
SetHelp(invoiceline.GetDescription());
// Qty
int units = product.GetSupportUnits();
if (units == 0)
{
units = 1;
}
if (deliveryCount != 0) // one asset per UOM
{
SetQty(invoiceline.GetQtyEntered(), units);
}
else
{
SetQty((Decimal)units);
}
SetM_InOutLine_ID(invoiceline.GetM_InOutLine_ID());
Set_Value("C_InvoiceLine_ID", invoiceline.GetC_InvoiceLine_ID());
// Activate
MAssetGroup ag = MAssetGroup.Get(GetCtx(), GetA_Asset_Group_ID());
if (!ag.IsCreateAsActive())
{
SetIsActive(false);
}
}
/**
* Shipment Constructor
* @param shipment shipment
* @param shipLine shipment line
* @param deliveryCount 0 or number of delivery
*/
public MAsset(MInOut shipment, MInOutLine shipLine, int deliveryCount)
: this(shipment.GetCtx(), 0, shipment.Get_TrxName())
{
SetClientOrg(shipment);
SetValueNameDescription(shipment, shipLine, deliveryCount);
// Header
// SetIsOwned(true);
SetC_BPartner_ID(shipment.GetC_BPartner_ID());
SetC_BPartner_Location_ID(shipment.GetC_BPartner_Location_ID());
SetAD_User_ID(shipment.GetAD_User_ID());
SetM_Locator_ID(shipLine.GetM_Locator_ID());
SetIsInPosession(true);
SetAssetServiceDate(shipment.GetDateAcct());
// Line
MProduct product = shipLine.GetProduct();
SetM_Product_ID(product.GetM_Product_ID());
SetA_Asset_Group_ID(product.GetA_Asset_Group_ID());
//////////////////////////////*
//Changes for vafam
// SetAssetServiceDate(shipment.GetMovementDate());
//SetGuaranteeDate(TimeUtil.AddDays(shipment.GetMovementDate(), product.GetGuaranteeDays()));
MAssetGroup _assetGroup = new MAssetGroup(GetCtx(), GetA_Asset_Group_ID(), shipment.Get_TrxName());
if (_assetGroup.IsOwned())
{
SetIsOwned(true);
//SetC_BPartner_ID(0);
}
if (_assetGroup.IsDepreciated())
{
SetIsDepreciated(true);
SetIsFullyDepreciated(false);
}
//Change by Sukhwinder for setting Asset type and amortization template on Asset window, MANTIS ID:1762
int countVA038 = Util.GetValueOfInt(DB.ExecuteScalar("SELECT COUNT(AD_MODULEINFO_ID) FROM AD_MODULEINFO WHERE PREFIX='VA038_' "));
int countVAFAM = Util.GetValueOfInt(DB.ExecuteScalar("SELECT COUNT(AD_MODULEINFO_ID) FROM AD_MODULEINFO WHERE PREFIX='VAFAM_' "));
if (countVA038 > 0)
{
Set_Value("VA038_AmortizationTemplate_ID", Utility.Util.GetValueOfInt(_assetGroup.Get_Value("VA038_AmortizationTemplate_ID")));
}
if (countVAFAM > 0)
{
Set_Value("VAFAM_AssetType", _assetGroup.Get_Value("VAFAM_AssetType").ToString());
Set_Value("VAFAM_DepreciationType_ID", Utility.Util.GetValueOfInt(_assetGroup.Get_Value("VAFAM_DepreciationType_ID")));
}
////////////////////////////////////
// Guarantee & Version
SetGuaranteeDate(TimeUtil.AddDays(shipment.GetMovementDate(), product.GetGuaranteeDays()));
SetVersionNo(product.GetVersionNo());
if (shipLine.GetM_AttributeSetInstance_ID() != 0) // Instance
{
MAttributeSetInstance asi = new MAttributeSetInstance(GetCtx(), shipLine.GetM_AttributeSetInstance_ID(), Get_TrxName());
SetM_AttributeSetInstance_ID(asi.GetM_AttributeSetInstance_ID());
SetLot(asi.GetLot());
SetSerNo(asi.GetSerNo());
}
SetHelp(shipLine.GetDescription());
// Qty
int units = product.GetSupportUnits();
if (units == 0)
{
units = 1;
}
if (deliveryCount != 0) // one asset per UOM
{
SetQty(shipLine.GetMovementQty(), units);
}
else
{
SetQty((Decimal)units);
}
SetM_InOutLine_ID(shipLine.GetM_InOutLine_ID());
// Activate
MAssetGroup ag = MAssetGroup.Get(GetCtx(), GetA_Asset_Group_ID());
if (!ag.IsCreateAsActive())
{
SetIsActive(false);
}
//Check if the Software Industry module installed, update following fields on Asset window
if (Env.IsModuleInstalled("VA077_"))
{
//Set default values
SetIsInPosession(false);
SetIsOwned(false);
SetIsActive(true);
SetIsDisposed(false);
Set_Value("VA077_SerialNo", shipLine.Get_Value("VA077_SerialNo"));
Set_Value("VA077_CNAutodesk", shipLine.Get_Value("VA077_CNAutodesk"));
Set_Value("VA077_RegEmail", shipLine.Get_Value("VA077_RegEmail"));
Set_Value("VA077_IsCustAsset", "Y");
Set_Value("VA077_OldSN", shipLine.Get_Value("VA077_OldSN"));
Set_Value("VA077_UserRef_ID", shipLine.Get_Value("VA077_UserRef_ID"));
Set_Value("VA077_ProductInfo", shipLine.Get_Value("VA077_ProductInfo"));
Set_Value("VA077_ServiceContract_ID", shipLine.Get_Value("VA077_ServiceContract_ID"));
Set_Value("AD_OrgTrx_ID", shipLine.Get_Value("AD_OrgTrx_ID"));
if (Util.GetValueOfBool(product.Get_Value("VA077_LicenceTracked")))
{
Set_Value("VA077_LicenceTracked", "Y");
}
else
{
Set_Value("VA077_LicenceTracked", "N");
}
}
}
/**
* Shipment Constructor
* @param shipment shipment
* @param shipLine shipment line
* @param deliveryCount 0 or number of delivery
*/
public MAsset(MInOut shipment, MInOutLine shipLine, int deliveryCount)
: this(shipment.GetCtx(), 0, shipment.Get_TrxName())
{
SetClientOrg(shipment);
SetValueNameDescription(shipment, shipLine, deliveryCount);
// Header
SetIsOwned(true);
SetC_BPartner_ID(shipment.GetC_BPartner_ID());
SetC_BPartner_Location_ID(shipment.GetC_BPartner_Location_ID());
SetAD_User_ID(shipment.GetAD_User_ID());
SetM_Locator_ID(shipLine.GetM_Locator_ID());
SetIsInPosession(true);
// Line
MProduct product = shipLine.GetProduct();
SetM_Product_ID(product.GetM_Product_ID());
SetA_Asset_Group_ID(product.GetA_Asset_Group_ID());
//////////////////////////////*
//Changes for vafam
// SetAssetServiceDate(shipment.GetMovementDate());
//SetGuaranteeDate(TimeUtil.AddDays(shipment.GetMovementDate(), product.GetGuaranteeDays()));
MAssetGroup _assetGroup = new MAssetGroup(GetCtx(), GetA_Asset_Group_ID(), shipment.Get_TrxName());
if (_assetGroup.IsOwned())
{
SetIsOwned(true);
//SetC_BPartner_ID(0);
}
if (_assetGroup.IsDepreciated())
{
SetIsDepreciated(true);
SetIsFullyDepreciated(false);
}
////////////////////////////////////
// Guarantee & Version
SetGuaranteeDate(TimeUtil.AddDays(shipment.GetMovementDate(), product.GetGuaranteeDays()));
SetVersionNo(product.GetVersionNo());
if (shipLine.GetM_AttributeSetInstance_ID() != 0) // Instance
{
MAttributeSetInstance asi = new MAttributeSetInstance(GetCtx(), shipLine.GetM_AttributeSetInstance_ID(), Get_TrxName());
SetM_AttributeSetInstance_ID(asi.GetM_AttributeSetInstance_ID());
SetLot(asi.GetLot());
SetSerNo(asi.GetSerNo());
}
SetHelp(shipLine.GetDescription());
// Qty
int units = product.GetSupportUnits();
if (units == 0)
{
units = 1;
}
if (deliveryCount != 0) // one asset per UOM
{
SetQty(shipLine.GetMovementQty(), units);
}
else
{
SetQty((Decimal)units);
}
SetM_InOutLine_ID(shipLine.GetM_InOutLine_ID());
// Activate
MAssetGroup ag = MAssetGroup.Get(GetCtx(), GetA_Asset_Group_ID());
if (!ag.IsCreateAsActive())
{
SetIsActive(false);
}
}
