public virtual ItemKit LoadItemKit(com.Sconit.Entity.MasterData.Item parentItem, com.Sconit.Entity.MasterData.Item childItem)
{
string hql = @"from ItemKit entity where entity.ParentItem.Code = ? and entity.ChildItem.Code = ?";
IList <ItemKit> result = FindAllWithCustomQuery <ItemKit>(hql, new object[] { parentItem.Code, childItem.Code }, new IType[] { NHibernateUtil.String, NHibernateUtil.String });
if (result != null && result.Count > 0)
{
return(result[0]);
}
else
{
return(null);
}
}
public virtual UomConversion LoadUomConversion(com.Sconit.Entity.MasterData.Item item, com.Sconit.Entity.MasterData.Uom alterUom, com.Sconit.Entity.MasterData.Uom baseUom)
{
string hql = @"from UomConversion entity where entity.Item.Code = ? and entity.AlterUom.Code = ? and entity.BaseUom.Code = ?";
IList <UomConversion> result = FindAllWithCustomQuery <UomConversion>(hql, new object[] { item.Code, alterUom.Code, baseUom.Code }, new IType[] { NHibernateUtil.String, NHibernateUtil.String, NHibernateUtil.String });
if (result != null && result.Count > 0)
{
return(result[0]);
}
else
{
return(null);
}
}
public virtual ItemReference LoadItemReference(com.Sconit.Entity.MasterData.Item item, com.Sconit.Entity.MasterData.Party party, String referenceCode)
{
string hql = @"from ItemReference entity where entity.Item.Code = ? and entity.Party.Code = ? and entity.ReferenceCode = ?";
IList <ItemReference> result = FindAllWithCustomQuery <ItemReference>(hql, new object[] { item.Code, party.Code, referenceCode }, new IType[] { NHibernateUtil.String, NHibernateUtil.String, NHibernateUtil.String });
if (result != null && result.Count > 0)
{
return(result[0]);
}
else
{
return(null);
}
}
public virtual PriceListDetail LoadPriceListDetail(com.Sconit.Entity.MasterData.PriceList priceList, DateTime startDate, com.Sconit.Entity.MasterData.Item item, Currency currency)
{
string hql = @"from PriceListDetail entity where entity.PriceList.Code = ? and entity.StartDate = ? and entity.Item.Code = ? and entity.Currency.Code = ?";
IList <PriceListDetail> result = FindAllWithCustomQuery <PriceListDetail>(hql, new object[] { priceList.Code, startDate, item.Code, currency.Code }, new IType[] { NHibernateUtil.String, NHibernateUtil.DateTime, NHibernateUtil.String, NHibernateUtil.String });
if (result != null && result.Count > 0)
{
return(result[0]);
}
else
{
return(null);
}
}
public IList<ItemKit> GetChildItemKit(Item parentItem, bool includeInActive)
{
return GetChildItemKit(parentItem.Code, includeInActive);
}
public IList<ItemKit> GetChildItemKit(Item parentItem)
{
return GetChildItemKit(parentItem.Code, false);
}
public virtual void DeleteUomConversion(com.Sconit.Entity.MasterData.Item item, com.Sconit.Entity.MasterData.Uom alterUom, com.Sconit.Entity.MasterData.Uom baseUom)
{
entityDao.DeleteUomConversion(item, alterUom, baseUom);
}
public virtual UomConversion LoadUomConversion(com.Sconit.Entity.MasterData.Item item, com.Sconit.Entity.MasterData.Uom alterUom, com.Sconit.Entity.MasterData.Uom baseUom)
{
return(entityDao.LoadUomConversion(item, alterUom, baseUom));
}
public IList<ItemReference> GetItemReference(Item item, Party partyFrom, Party partyTo)
{
return GetItemReference(item.Code, partyFrom.Code, partyTo.Code);
}
public virtual ItemReference LoadItemReference(com.Sconit.Entity.MasterData.Item item, com.Sconit.Entity.MasterData.Party party, String referenceCode)
{
return(entityDao.LoadItemReference(item, party, referenceCode));
}
public virtual void DeleteItemKit(com.Sconit.Entity.MasterData.Item parentItem, com.Sconit.Entity.MasterData.Item childItem)
{
entityDao.DeleteItemKit(parentItem, childItem);
}
public virtual ItemKit LoadItemKit(com.Sconit.Entity.MasterData.Item parentItem, com.Sconit.Entity.MasterData.Item childItem)
{
return(entityDao.LoadItemKit(parentItem, childItem));
}
public virtual PriceListDetail LoadPriceListDetail(com.Sconit.Entity.MasterData.PriceList priceList, DateTime startDate, com.Sconit.Entity.MasterData.Item item, Currency currency)
{
return(entityDao.LoadPriceListDetail(priceList, startDate, item, currency));
}
public virtual void DeleteItemKit(com.Sconit.Entity.MasterData.Item parentItem, com.Sconit.Entity.MasterData.Item childItem)
{
string hql = @"from ItemKit entity where entity.ParentItem.Code = ? and entity.ChildItem.Code = ?";
Delete(hql, new object[] { parentItem.Code, childItem.Code }, new IType[] { NHibernateUtil.String, NHibernateUtil.String });
}
public virtual void DeleteUomConversion(com.Sconit.Entity.MasterData.Item item, com.Sconit.Entity.MasterData.Uom alterUom, com.Sconit.Entity.MasterData.Uom baseUom)
{
string hql = @"from UomConversion entity where entity.Item.Code = ? and entity.AlterUom.Code = ? and entity.BaseUom.Code = ?";
Delete(hql, new object[] { item.Code, alterUom.Code, baseUom.Code }, new IType[] { NHibernateUtil.String, NHibernateUtil.String, NHibernateUtil.String });
}
public decimal ConvertUomQty(Item item, Uom sourceUom, decimal sourceQty, Uom targetUom)
{
return ConvertUomQty(item.Code, sourceUom, sourceQty, targetUom);
}
public override ItemReference LoadItemReference(Item item, Party party, string referenceCode)
{
string partyCode = party == null ? string.Empty : party.Code;
return this.LoadItemReference(item.Code, partyCode, referenceCode);
}
