/// <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 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;
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>
/// <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;
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 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;
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 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;
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 INVProductStockBatchCollection</returns>
public INVProductStockBatchCollection SelectAllByForeignKeyBatchIDPaged(INVBatchPrimaryKey pk, int pageSize, int skipPages, string orderByStatement)
{
INVProductStockBatchCollection iNVProductStockBatchCollection = new INVProductStockBatchCollection();
foreach (POS.DataLayer.INVProductStockBatch _iNVProductStockBatch in POS.DataLayer.INVProductStockBatchBase.SelectAllByForeignKeyBatchIDPaged(new POS.DataLayer.INVBatchPrimaryKey(pk.BatchID), pageSize, skipPages, orderByStatement))
{
_iNVProductStockBatchWCF = new INVProductStockBatch();
_iNVProductStockBatchWCF.ProductStockBatchID = _iNVProductStockBatch.ProductStockBatchID;
_iNVProductStockBatchWCF.ProductStockID = _iNVProductStockBatch.ProductStockID;
_iNVProductStockBatchWCF.BatchID = _iNVProductStockBatch.BatchID;
_iNVProductStockBatchWCF.Qty = _iNVProductStockBatch.Qty;
iNVProductStockBatchCollection.Add(_iNVProductStockBatchWCF);
}
return(iNVProductStockBatchCollection);
}
/// <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 INVProductStockBatchCollection</returns>
public INVProductStockBatchCollection SelectAllByForeignKeyBatchID(INVBatchPrimaryKey pk)
{
INVProductStockBatchCollection iNVProductStockBatchCollection = new INVProductStockBatchCollection();
foreach (POS.DataLayer.INVProductStockBatch _iNVProductStockBatch in POS.DataLayer.INVProductStockBatchBase.SelectAllByForeignKeyBatchID(new POS.DataLayer.INVBatchPrimaryKey(pk.BatchID)))
{
_iNVProductStockBatchWCF = new INVProductStockBatch();
_iNVProductStockBatchWCF.ProductStockBatchID = _iNVProductStockBatch.ProductStockBatchID;
_iNVProductStockBatchWCF.ProductStockID = _iNVProductStockBatch.ProductStockID;
_iNVProductStockBatchWCF.BatchID = _iNVProductStockBatch.BatchID;
_iNVProductStockBatchWCF.Qty = _iNVProductStockBatch.Qty;
iNVProductStockBatchCollection.Add(_iNVProductStockBatchWCF);
}
return(iNVProductStockBatchCollection);
}
/// <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 INVAdjustStockCollection</returns>
public INVAdjustStockCollection SelectAllByForeignKeyBatchIDPaged(INVBatchPrimaryKey pk, int pageSize, int skipPages, string orderByStatement)
{
INVAdjustStockCollection iNVAdjustStockCollection = new INVAdjustStockCollection();
foreach (POS.DataLayer.INVAdjustStock _iNVAdjustStock in POS.DataLayer.INVAdjustStockBase.SelectAllByForeignKeyBatchIDPaged(new POS.DataLayer.INVBatchPrimaryKey(pk.BatchID), pageSize, skipPages, orderByStatement))
{
_iNVAdjustStockWCF = new INVAdjustStock();
_iNVAdjustStockWCF.AdjustStockID = _iNVAdjustStock.AdjustStockID;
_iNVAdjustStockWCF.ProductID = _iNVAdjustStock.ProductID;
_iNVAdjustStockWCF.BatchID = _iNVAdjustStock.BatchID;
_iNVAdjustStockWCF.Qty = _iNVAdjustStock.Qty;
_iNVAdjustStockWCF.AdjustReasonID = _iNVAdjustStock.AdjustReasonID;
_iNVAdjustStockWCF.CreatedBy = _iNVAdjustStock.CreatedBy;
_iNVAdjustStockWCF.CredateDate = _iNVAdjustStock.CredateDate;
_iNVAdjustStockWCF.UpdatedBy = _iNVAdjustStock.UpdatedBy;
_iNVAdjustStockWCF.UpdateDate = _iNVAdjustStock.UpdateDate;
iNVAdjustStockCollection.Add(_iNVAdjustStockWCF);
}
return(iNVAdjustStockCollection);
}
/// <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 INVAdjustStockCollection</returns>
public INVAdjustStockCollection SelectAllByForeignKeyBatchID(INVBatchPrimaryKey pk)
{
INVAdjustStockCollection iNVAdjustStockCollection = new INVAdjustStockCollection();
foreach (POS.DataLayer.INVAdjustStock _iNVAdjustStock in POS.DataLayer.INVAdjustStockBase.SelectAllByForeignKeyBatchID(new POS.DataLayer.INVBatchPrimaryKey(pk.BatchID)))
{
_iNVAdjustStockWCF = new INVAdjustStock();
_iNVAdjustStockWCF.AdjustStockID = _iNVAdjustStock.AdjustStockID;
_iNVAdjustStockWCF.ProductID = _iNVAdjustStock.ProductID;
_iNVAdjustStockWCF.BatchID = _iNVAdjustStock.BatchID;
_iNVAdjustStockWCF.Qty = _iNVAdjustStock.Qty;
_iNVAdjustStockWCF.AdjustReasonID = _iNVAdjustStock.AdjustReasonID;
_iNVAdjustStockWCF.CreatedBy = _iNVAdjustStock.CreatedBy;
_iNVAdjustStockWCF.CredateDate = _iNVAdjustStock.CredateDate;
_iNVAdjustStockWCF.UpdatedBy = _iNVAdjustStock.UpdatedBy;
_iNVAdjustStockWCF.UpdateDate = _iNVAdjustStock.UpdateDate;
iNVAdjustStockCollection.Add(_iNVAdjustStockWCF);
}
return(iNVAdjustStockCollection);
}
/// <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)));
}
///<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 DeleteAllByForeignKeyBatchID(INVBatchPrimaryKey pk)
{
return(POS.DataLayer.INVAdjustStockBase.DeleteAllByForeignKeyBatchID(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>
/// <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 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 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)));
}