/// <summary>
/// This method will return an object representing the record matching the primary key information specified.
/// </summary>
///
/// <param name="pk" type="INVBatchPrimaryKey">Primary Key information based on which data is to be fetched.</param>
///
/// <returns>object of class INVBatch</returns>
public INVBatch SelectOne(INVBatchPrimaryKey pk)
{
_iNVBatchWCF = new INVBatch();
_iNVBatch = POS.DataLayer.INVBatchBase.SelectOne(new POS.DataLayer.INVBatchPrimaryKey(pk.BatchID));
_iNVBatchWCF.BatchID = _iNVBatch.BatchID;
_iNVBatchWCF.BatchNumber = _iNVBatch.BatchNumber;
_iNVBatchWCF.ExpiryDate = _iNVBatch.ExpiryDate;
return _iNVBatchWCF;
}
/// <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="INVBatchPrimaryKey">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 PURPurchaseReturnLineCollection</returns>
public PURPurchaseReturnLineCollection SelectAllByForeignKeyPurchaseReturnLineIDPaged(INVBatchPrimaryKey pk, int pageSize, int skipPages, string orderByStatement)
{
PURPurchaseReturnLineCollection pURPurchaseReturnLineCollection=new PURPurchaseReturnLineCollection();
foreach (POS.DataLayer.PURPurchaseReturnLine _pURPurchaseReturnLine in POS.DataLayer.PURPurchaseReturnLineBase.SelectAllByForeignKeyPurchaseReturnLineIDPaged(new POS.DataLayer.INVBatchPrimaryKey(pk.BatchID), pageSize, skipPages, orderByStatement))
{
_pURPurchaseReturnLineWCF = new PURPurchaseReturnLine();
_pURPurchaseReturnLineWCF.PurchaseReturnLineID = _pURPurchaseReturnLine.PurchaseReturnLineID;
_pURPurchaseReturnLineWCF.Qty = _pURPurchaseReturnLine.Qty;
_pURPurchaseReturnLineWCF.Reason = _pURPurchaseReturnLine.Reason;
_pURPurchaseReturnLineWCF.OriginalpurchaseLineID = _pURPurchaseReturnLine.OriginalpurchaseLineID;
_pURPurchaseReturnLineWCF.BatchID = _pURPurchaseReturnLine.BatchID;
_pURPurchaseReturnLineWCF.BatchNumber = _pURPurchaseReturnLine.BatchNumber;
_pURPurchaseReturnLineWCF.ExpiryDate = _pURPurchaseReturnLine.ExpiryDate;
_pURPurchaseReturnLineWCF.PurchaseReturnHeaderID = _pURPurchaseReturnLine.PurchaseReturnHeaderID;
pURPurchaseReturnLineCollection.Add(_pURPurchaseReturnLineWCF);
}
return pURPurchaseReturnLineCollection;
}
///<summary>
///This method will Delete the object from the database
///</summary>
///<param name="pk" type="INVBatchPrimaryKey">Primary Key information based on which data is to be fetched.</param>
/// <returns>True if succeeded</returns>
public bool Delete(INVBatchPrimaryKey pk)
{
return POS.DataLayer.INVBatchBase.Delete(new POS.DataLayer.INVBatchPrimaryKey(pk.BatchID));
}
/// <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="INVBatchPrimaryKey">Primary Key information based on which data is to be deleted.</param>
///
/// <returns>True if succeeded</returns>
public bool DeleteAllByForeignKeyPurchaseReturnLineID(INVBatchPrimaryKey pk)
{
return POS.DataLayer.PURPurchaseReturnLineBase.DeleteAllByForeignKeyPurchaseReturnLineID(new POS.DataLayer.INVBatchPrimaryKey(pk.BatchID));
}
/// <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="INVBatchPrimaryKey">Primary Key information based on which data is to be fetched.</param>
///
/// <returns>object of class PURPurchaseReturnLineCollection</returns>
public PURPurchaseReturnLineCollection SelectAllByForeignKeyPurchaseReturnLineID(INVBatchPrimaryKey pk)
{
PURPurchaseReturnLineCollection pURPurchaseReturnLineCollection=new PURPurchaseReturnLineCollection();
foreach (POS.DataLayer.PURPurchaseReturnLine _pURPurchaseReturnLine in POS.DataLayer.PURPurchaseReturnLineBase.SelectAllByForeignKeyPurchaseReturnLineID(new POS.DataLayer.INVBatchPrimaryKey(pk.BatchID)))
{
_pURPurchaseReturnLineWCF = new PURPurchaseReturnLine();
_pURPurchaseReturnLineWCF.PurchaseReturnLineID = _pURPurchaseReturnLine.PurchaseReturnLineID;
_pURPurchaseReturnLineWCF.Qty = _pURPurchaseReturnLine.Qty;
_pURPurchaseReturnLineWCF.Reason = _pURPurchaseReturnLine.Reason;
_pURPurchaseReturnLineWCF.OriginalpurchaseLineID = _pURPurchaseReturnLine.OriginalpurchaseLineID;
_pURPurchaseReturnLineWCF.BatchID = _pURPurchaseReturnLine.BatchID;
_pURPurchaseReturnLineWCF.BatchNumber = _pURPurchaseReturnLine.BatchNumber;
_pURPurchaseReturnLineWCF.ExpiryDate = _pURPurchaseReturnLine.ExpiryDate;
_pURPurchaseReturnLineWCF.PurchaseReturnHeaderID = _pURPurchaseReturnLine.PurchaseReturnHeaderID;
pURPurchaseReturnLineCollection.Add(_pURPurchaseReturnLineWCF);
}
return pURPurchaseReturnLineCollection;
}
/// <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="INVBatchPrimaryKey">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 PURPurchaseLineBatchCollection</returns>
public PURPurchaseLineBatchCollection SelectAllByForeignKeyBatchIDPaged(INVBatchPrimaryKey pk, int pageSize, int skipPages, string orderByStatement)
{
PURPurchaseLineBatchCollection pURPurchaseLineBatchCollection=new PURPurchaseLineBatchCollection();
foreach (POS.DataLayer.PURPurchaseLineBatch _pURPurchaseLineBatch in POS.DataLayer.PURPurchaseLineBatchBase.SelectAllByForeignKeyBatchIDPaged(new POS.DataLayer.INVBatchPrimaryKey(pk.BatchID), pageSize, skipPages, orderByStatement))
{
_pURPurchaseLineBatchWCF = new PURPurchaseLineBatch();
_pURPurchaseLineBatchWCF.PurchaseLineBatchID = _pURPurchaseLineBatch.PurchaseLineBatchID;
_pURPurchaseLineBatchWCF.PurchaseLineID = _pURPurchaseLineBatch.PurchaseLineID;
_pURPurchaseLineBatchWCF.BatchID = _pURPurchaseLineBatch.BatchID;
_pURPurchaseLineBatchWCF.Qty = _pURPurchaseLineBatch.Qty;
pURPurchaseLineBatchCollection.Add(_pURPurchaseLineBatchWCF);
}
return pURPurchaseLineBatchCollection;
}
/// <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="INVBatchPrimaryKey">Primary Key information based on which data is to be fetched.</param>
///
/// <returns>object of class PURPurchaseLineBatchCollection</returns>
public PURPurchaseLineBatchCollection SelectAllByForeignKeyBatchID(INVBatchPrimaryKey pk)
{
PURPurchaseLineBatchCollection pURPurchaseLineBatchCollection=new PURPurchaseLineBatchCollection();
foreach (POS.DataLayer.PURPurchaseLineBatch _pURPurchaseLineBatch in POS.DataLayer.PURPurchaseLineBatchBase.SelectAllByForeignKeyBatchID(new POS.DataLayer.INVBatchPrimaryKey(pk.BatchID)))
{
_pURPurchaseLineBatchWCF = new PURPurchaseLineBatch();
_pURPurchaseLineBatchWCF.PurchaseLineBatchID = _pURPurchaseLineBatch.PurchaseLineBatchID;
_pURPurchaseLineBatchWCF.PurchaseLineID = _pURPurchaseLineBatch.PurchaseLineID;
_pURPurchaseLineBatchWCF.BatchID = _pURPurchaseLineBatch.BatchID;
_pURPurchaseLineBatchWCF.Qty = _pURPurchaseLineBatch.Qty;
pURPurchaseLineBatchCollection.Add(_pURPurchaseLineBatchWCF);
}
return pURPurchaseLineBatchCollection;
}
/// <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="INVBatchPrimaryKey">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 SALSalesLineBatchCollection</returns>
public SALSalesLineBatchCollection SelectAllByForeignKeyBatchIDPaged(INVBatchPrimaryKey pk, int pageSize, int skipPages, string orderByStatement)
{
SALSalesLineBatchCollection sALSalesLineBatchCollection=new SALSalesLineBatchCollection();
foreach (POS.DataLayer.SALSalesLineBatch _sALSalesLineBatch in POS.DataLayer.SALSalesLineBatchBase.SelectAllByForeignKeyBatchIDPaged(new POS.DataLayer.INVBatchPrimaryKey(pk.BatchID), pageSize, skipPages, orderByStatement))
{
_sALSalesLineBatchWCF = new SALSalesLineBatch();
_sALSalesLineBatchWCF.SalesLineBatchID = _sALSalesLineBatch.SalesLineBatchID;
_sALSalesLineBatchWCF.SalesLineID = _sALSalesLineBatch.SalesLineID;
_sALSalesLineBatchWCF.BatchID = _sALSalesLineBatch.BatchID;
_sALSalesLineBatchWCF.Qty = _sALSalesLineBatch.Qty;
sALSalesLineBatchCollection.Add(_sALSalesLineBatchWCF);
}
return sALSalesLineBatchCollection;
}
/// <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="INVBatchPrimaryKey">Primary Key information based on which data is to be fetched.</param>
///
/// <returns>object of class SALSalesLineBatchCollection</returns>
public SALSalesLineBatchCollection SelectAllByForeignKeyBatchID(INVBatchPrimaryKey pk)
{
SALSalesLineBatchCollection sALSalesLineBatchCollection=new SALSalesLineBatchCollection();
foreach (POS.DataLayer.SALSalesLineBatch _sALSalesLineBatch in POS.DataLayer.SALSalesLineBatchBase.SelectAllByForeignKeyBatchID(new POS.DataLayer.INVBatchPrimaryKey(pk.BatchID)))
{
_sALSalesLineBatchWCF = new SALSalesLineBatch();
_sALSalesLineBatchWCF.SalesLineBatchID = _sALSalesLineBatch.SalesLineBatchID;
_sALSalesLineBatchWCF.SalesLineID = _sALSalesLineBatch.SalesLineID;
_sALSalesLineBatchWCF.BatchID = _sALSalesLineBatch.BatchID;
_sALSalesLineBatchWCF.Qty = _sALSalesLineBatch.Qty;
sALSalesLineBatchCollection.Add(_sALSalesLineBatchWCF);
}
return sALSalesLineBatchCollection;
}
/// <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="INVBatchPrimaryKey">Primary Key information based on which data is to be deleted.</param>
///
/// <returns>True if succeeded</returns>
public bool DeleteAllByForeignKeyBatchID(INVBatchPrimaryKey pk)
{
return POS.DataLayer.SALSalesLineBatchBase.DeleteAllByForeignKeyBatchID(new POS.DataLayer.INVBatchPrimaryKey(pk.BatchID));
}
