/// <summary>
/// This method will get row(s) from the database using the value of the field specified
/// along with the details of the child table.
/// </summary>
///
/// <param name="pk" type="INVStockTypePrimaryKey">Primary Key information based on which data is to be fetched.</param>
///
/// <returns>object of class INVTakingInventoryLineCollection</returns>
public INVTakingInventoryLineCollection SelectAllByForeignKeyStockTypeID(INVStockTypePrimaryKey pk)
{
INVTakingInventoryLineCollection iNVTakingInventoryLineCollection = new INVTakingInventoryLineCollection();
foreach (POS.DataLayer.INVTakingInventoryLine _iNVTakingInventoryLine in POS.DataLayer.INVTakingInventoryLineBase.SelectAllByForeignKeyStockTypeID(new POS.DataLayer.INVStockTypePrimaryKey(pk.StockTypeID)))
{
_iNVTakingInventoryLineWCF = new INVTakingInventoryLine();
_iNVTakingInventoryLineWCF.TakingLineID = _iNVTakingInventoryLine.TakingLineID;
_iNVTakingInventoryLineWCF.TakingHeaderID = _iNVTakingInventoryLine.TakingHeaderID;
_iNVTakingInventoryLineWCF.ProductID = _iNVTakingInventoryLine.ProductID;
_iNVTakingInventoryLineWCF.ActualQty = _iNVTakingInventoryLine.ActualQty;
_iNVTakingInventoryLineWCF.ExpectedQty = _iNVTakingInventoryLine.ExpectedQty;
_iNVTakingInventoryLineWCF.CreatedBy = _iNVTakingInventoryLine.CreatedBy;
_iNVTakingInventoryLineWCF.CreateDate = _iNVTakingInventoryLine.CreateDate;
_iNVTakingInventoryLineWCF.UpdatedBy = _iNVTakingInventoryLine.UpdatedBy;
_iNVTakingInventoryLineWCF.UpdateDate = _iNVTakingInventoryLine.UpdateDate;
_iNVTakingInventoryLineWCF.IsDeleted = _iNVTakingInventoryLine.IsDeleted;
_iNVTakingInventoryLineWCF.DeletedBy = _iNVTakingInventoryLine.DeletedBy;
_iNVTakingInventoryLineWCF.DeleteDate = _iNVTakingInventoryLine.DeleteDate;
_iNVTakingInventoryLineWCF.StockTypeID = _iNVTakingInventoryLine.StockTypeID;
iNVTakingInventoryLineCollection.Add(_iNVTakingInventoryLineWCF);
}
return(iNVTakingInventoryLineCollection);
}
/// <summary>
/// This method will return an object representing the record matching the primary key information specified.
/// </summary>
///
/// <param name="pk" type="INVStockTypePrimaryKey">Primary Key information based on which data is to be fetched.</param>
///
/// <returns>object of class INVStockType</returns>
public INVStockType SelectOne(INVStockTypePrimaryKey pk)
{
_iNVStockTypeWCF = new INVStockType();
_iNVStockType = POS.DataLayer.INVStockTypeBase.SelectOne(new POS.DataLayer.INVStockTypePrimaryKey(pk.StockTypeID));
_iNVStockTypeWCF.StockTypeID = _iNVStockType.StockTypeID;
_iNVStockTypeWCF.StockTypeName = _iNVStockType.StockTypeName;
return(_iNVStockTypeWCF);
}
/// <summary>
/// This method will get row(s) from the database using the value of the field specified
/// along with the details of the child table.
/// </summary>
///
/// <param name="pk" type="INVStockTypePrimaryKey">Primary Key information based on which data is to be fetched.</param>
/// <param name="pageSize" type="int">Number of records returned.</param>
/// <param name="skipPages" type="int">The number of missing pages.</param>
/// <param name="orderByStatement" type="string">The field value to number.</param>
///
/// <returns>object of class INVProductStockCollection</returns>
public INVProductStockCollection SelectAllByForeignKeyStockTypeIDPaged(INVStockTypePrimaryKey pk, int pageSize, int skipPages, string orderByStatement)
{
INVProductStockCollection iNVProductStockCollection = new INVProductStockCollection();
foreach (POS.DataLayer.INVProductStock _iNVProductStock in POS.DataLayer.INVProductStockBase.SelectAllByForeignKeyStockTypeIDPaged(new POS.DataLayer.INVStockTypePrimaryKey(pk.StockTypeID), pageSize, skipPages, orderByStatement))
{
_iNVProductStockWCF = new INVProductStock();
_iNVProductStockWCF.ProductStockID = _iNVProductStock.ProductStockID;
_iNVProductStockWCF.ProductID = _iNVProductStock.ProductID;
_iNVProductStockWCF.TotalQty = _iNVProductStock.TotalQty;
_iNVProductStockWCF.StockTypeID = _iNVProductStock.StockTypeID;
_iNVProductStockWCF.OpeningQty = _iNVProductStock.OpeningQty;
_iNVProductStockWCF.OpennigDate = _iNVProductStock.OpennigDate;
_iNVProductStockWCF.CreateDate = _iNVProductStock.CreateDate;
_iNVProductStockWCF.CreatedBy = _iNVProductStock.CreatedBy;
_iNVProductStockWCF.UpdateDate = _iNVProductStock.UpdateDate;
_iNVProductStockWCF.UpdatedBy = _iNVProductStock.UpdatedBy;
iNVProductStockCollection.Add(_iNVProductStockWCF);
}
return(iNVProductStockCollection);
}
/// <summary>
/// This method will get row(s) from the database using the value of the field specified
/// along with the details of the child table.
/// </summary>
///
/// <param name="pk" type="INVStockTypePrimaryKey">Primary Key information based on which data is to be fetched.</param>
///
/// <returns>object of class INVProductStockCollection</returns>
public INVProductStockCollection SelectAllByForeignKeyStockTypeID(INVStockTypePrimaryKey pk)
{
INVProductStockCollection iNVProductStockCollection = new INVProductStockCollection();
foreach (POS.DataLayer.INVProductStock _iNVProductStock in POS.DataLayer.INVProductStockBase.SelectAllByForeignKeyStockTypeID(new POS.DataLayer.INVStockTypePrimaryKey(pk.StockTypeID)))
{
_iNVProductStockWCF = new INVProductStock();
_iNVProductStockWCF.ProductStockID = _iNVProductStock.ProductStockID;
_iNVProductStockWCF.ProductID = _iNVProductStock.ProductID;
_iNVProductStockWCF.TotalQty = _iNVProductStock.TotalQty;
_iNVProductStockWCF.StockTypeID = _iNVProductStock.StockTypeID;
_iNVProductStockWCF.OpeningQty = _iNVProductStock.OpeningQty;
_iNVProductStockWCF.OpennigDate = _iNVProductStock.OpennigDate;
_iNVProductStockWCF.CreateDate = _iNVProductStock.CreateDate;
_iNVProductStockWCF.CreatedBy = _iNVProductStock.CreatedBy;
_iNVProductStockWCF.UpdateDate = _iNVProductStock.UpdateDate;
_iNVProductStockWCF.UpdatedBy = _iNVProductStock.UpdatedBy;
iNVProductStockCollection.Add(_iNVProductStockWCF);
}
return(iNVProductStockCollection);
}
///<summary>
///This method will Delete the object from the database
///</summary>
///<param name="pk" type="INVStockTypePrimaryKey">Primary Key information based on which data is to be fetched.</param>
/// <returns>True if succeeded</returns>
public bool Delete(INVStockTypePrimaryKey pk)
{
return(POS.DataLayer.INVStockTypeBase.Delete(new POS.DataLayer.INVStockTypePrimaryKey(pk.StockTypeID)));
}
/// <summary>
/// This method will delete row(s) from the database using the value of the field specified
/// along with the details of the child table.
/// </summary>
///
/// <param name="pk" type="INVStockTypePrimaryKey">Primary Key information based on which data is to be deleted.</param>
///
/// <returns>True if succeeded</returns>
public bool DeleteAllByForeignKeyStockTypeID(INVStockTypePrimaryKey pk)
{
return(POS.DataLayer.INVProductStockBase.DeleteAllByForeignKeyStockTypeID(new POS.DataLayer.INVStockTypePrimaryKey(pk.StockTypeID)));
}
/// <summary>
/// This method will delete row(s) from the database using the value of the field specified
/// along with the details of the child table.
/// </summary>
///
/// <param name="pk" type="INVStockTypePrimaryKey">Primary Key information based on which data is to be deleted.</param>
///
/// <returns>True if succeeded</returns>
public bool DeleteAllByForeignKeyStockTypeID(INVStockTypePrimaryKey pk)
{
return(POS.DataLayer.INVTakingInventoryLineBase.DeleteAllByForeignKeyStockTypeID(new POS.DataLayer.INVStockTypePrimaryKey(pk.StockTypeID)));
}
