/// <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="PURPurchaseLinePrimaryKey">Primary Key information based on which data is to be fetched.</param>
///
/// <returns>object of class PURPurchaseLineBatchCollection</returns>
public PURPurchaseLineBatchCollection SelectAllByForeignKeyPurchaseLineID(PURPurchaseLinePrimaryKey pk)
{
PURPurchaseLineBatchCollection pURPurchaseLineBatchCollection = new PURPurchaseLineBatchCollection();
foreach (POS.DataLayer.PURPurchaseLineBatch _pURPurchaseLineBatch in POS.DataLayer.PURPurchaseLineBatchBase.SelectAllByForeignKeyPurchaseLineID(new POS.DataLayer.PURPurchaseLinePrimaryKey(pk.PurchaseLineID)))
{
_pURPurchaseLineBatchWCF = new PURPurchaseLineBatch();
_pURPurchaseLineBatchWCF.PurchaseLineBatchID = _pURPurchaseLineBatch.PurchaseLineBatchID;
_pURPurchaseLineBatchWCF.PurchaseLineID = _pURPurchaseLineBatch.PurchaseLineID;
_pURPurchaseLineBatchWCF.BatchID = _pURPurchaseLineBatch.BatchID;
pURPurchaseLineBatchCollection.Add(_pURPurchaseLineBatchWCF);
}
return(pURPurchaseLineBatchCollection);
}
/// <summary>
/// This method will return an object representing the record matching the primary key information specified.
/// </summary>
///
/// <param name="pk" type="PURPurchaseLinePrimaryKey">Primary Key information based on which data is to be fetched.</param>
///
/// <returns>object of class PURPurchaseLine</returns>
public PURPurchaseLine SelectOne(PURPurchaseLinePrimaryKey pk)
{
_pURPurchaseLineWCF = new PURPurchaseLine();
_pURPurchaseLine = POS.DataLayer.PURPurchaseLineBase.SelectOne(new POS.DataLayer.PURPurchaseLinePrimaryKey(pk.PurchaseLineID));
_pURPurchaseLineWCF.PurchaseLineID = _pURPurchaseLine.PurchaseLineID;
_pURPurchaseLineWCF.PurchaseHeaderID = _pURPurchaseLine.PurchaseHeaderID;
_pURPurchaseLineWCF.ProductID = _pURPurchaseLine.ProductID;
_pURPurchaseLineWCF.TotalQty = _pURPurchaseLine.TotalQty;
_pURPurchaseLineWCF.BonusQty = _pURPurchaseLine.BonusQty;
_pURPurchaseLineWCF.DiscountRatio = _pURPurchaseLine.DiscountRatio;
_pURPurchaseLineWCF.DiscountAmount = _pURPurchaseLine.DiscountAmount;
_pURPurchaseLineWCF.Unitprice = _pURPurchaseLine.Unitprice;
_pURPurchaseLineWCF.CreatedDate = _pURPurchaseLine.CreatedDate;
_pURPurchaseLineWCF.CreatedBy = _pURPurchaseLine.CreatedBy;
_pURPurchaseLineWCF.UpdateDate = _pURPurchaseLine.UpdateDate;
_pURPurchaseLineWCF.UpdatedBy = _pURPurchaseLine.UpdatedBy;
_pURPurchaseLineWCF.IsDeleted = _pURPurchaseLine.IsDeleted;
_pURPurchaseLineWCF.DeleteDate = _pURPurchaseLine.DeleteDate;
_pURPurchaseLineWCF.DeletedBy = _pURPurchaseLine.DeletedBy;
return(_pURPurchaseLineWCF);
}
/// <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="PURPurchaseLinePrimaryKey">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 INVTakingInventoryLineBatchCollection</returns>
public INVTakingInventoryLineBatchCollection SelectAllByForeignKeyTakingLineIDPaged(PURPurchaseLinePrimaryKey pk, int pageSize, int skipPages, string orderByStatement)
{
INVTakingInventoryLineBatchCollection iNVTakingInventoryLineBatchCollection = new INVTakingInventoryLineBatchCollection();
foreach (POS.DataLayer.INVTakingInventoryLineBatch _iNVTakingInventoryLineBatch in POS.DataLayer.INVTakingInventoryLineBatchBase.SelectAllByForeignKeyTakingLineIDPaged(new POS.DataLayer.PURPurchaseLinePrimaryKey(pk.PurchaseLineID), pageSize, skipPages, orderByStatement))
{
_iNVTakingInventoryLineBatchWCF = new INVTakingInventoryLineBatch();
_iNVTakingInventoryLineBatchWCF.TakingLineBatchID = _iNVTakingInventoryLineBatch.TakingLineBatchID;
_iNVTakingInventoryLineBatchWCF.TakingLineID = _iNVTakingInventoryLineBatch.TakingLineID;
_iNVTakingInventoryLineBatchWCF.BatchID = _iNVTakingInventoryLineBatch.BatchID;
iNVTakingInventoryLineBatchCollection.Add(_iNVTakingInventoryLineBatchWCF);
}
return(iNVTakingInventoryLineBatchCollection);
}
/// <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="PURPurchaseLinePrimaryKey">Primary Key information based on which data is to be fetched.</param>
///
/// <returns>object of class INVTakingInventoryLineBatchCollection</returns>
public INVTakingInventoryLineBatchCollection SelectAllByForeignKeyTakingLineID(PURPurchaseLinePrimaryKey pk)
{
INVTakingInventoryLineBatchCollection iNVTakingInventoryLineBatchCollection = new INVTakingInventoryLineBatchCollection();
foreach (POS.DataLayer.INVTakingInventoryLineBatch _iNVTakingInventoryLineBatch in POS.DataLayer.INVTakingInventoryLineBatchBase.SelectAllByForeignKeyTakingLineID(new POS.DataLayer.PURPurchaseLinePrimaryKey(pk.PurchaseLineID)))
{
_iNVTakingInventoryLineBatchWCF = new INVTakingInventoryLineBatch();
_iNVTakingInventoryLineBatchWCF.TakingLineBatchID = _iNVTakingInventoryLineBatch.TakingLineBatchID;
_iNVTakingInventoryLineBatchWCF.TakingLineID = _iNVTakingInventoryLineBatch.TakingLineID;
_iNVTakingInventoryLineBatchWCF.BatchID = _iNVTakingInventoryLineBatch.BatchID;
iNVTakingInventoryLineBatchCollection.Add(_iNVTakingInventoryLineBatchWCF);
}
return(iNVTakingInventoryLineBatchCollection);
}
/// <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="PURPurchaseLinePrimaryKey">Primary Key information based on which data is to be deleted.</param>
///
/// <returns>True if succeeded</returns>
public bool DeleteAllByForeignKeyTakingLineID(PURPurchaseLinePrimaryKey pk)
{
return(POS.DataLayer.INVTakingInventoryLineBatchBase.DeleteAllByForeignKeyTakingLineID(new POS.DataLayer.PURPurchaseLinePrimaryKey(pk.PurchaseLineID)));
}
///<summary>
///This method will Delete the object from the database
///</summary>
///<param name="pk" type="PURPurchaseLinePrimaryKey">Primary Key information based on which data is to be fetched.</param>
/// <returns>True if succeeded</returns>
public bool Delete(PURPurchaseLinePrimaryKey pk)
{
return(POS.DataLayer.PURPurchaseLineBase.Delete(new POS.DataLayer.PURPurchaseLinePrimaryKey(pk.PurchaseLineID)));
}
/// <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="PURPurchaseLinePrimaryKey">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 SelectAllByForeignKeyPurchaseLineIDPaged(PURPurchaseLinePrimaryKey pk, int pageSize, int skipPages, string orderByStatement)
{
PURPurchaseLineBatchCollection pURPurchaseLineBatchCollection = new PURPurchaseLineBatchCollection();
foreach (POS.DataLayer.PURPurchaseLineBatch _pURPurchaseLineBatch in POS.DataLayer.PURPurchaseLineBatchBase.SelectAllByForeignKeyPurchaseLineIDPaged(new POS.DataLayer.PURPurchaseLinePrimaryKey(pk.PurchaseLineID), 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="PURPurchaseLinePrimaryKey">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 SelectAllByForeignKeyOriginalpurchaseLineIDPaged(PURPurchaseLinePrimaryKey pk, int pageSize, int skipPages, string orderByStatement)
{
PURPurchaseReturnLineCollection pURPurchaseReturnLineCollection = new PURPurchaseReturnLineCollection();
foreach (POS.DataLayer.PURPurchaseReturnLine _pURPurchaseReturnLine in POS.DataLayer.PURPurchaseReturnLineBase.SelectAllByForeignKeyOriginalpurchaseLineIDPaged(new POS.DataLayer.PURPurchaseLinePrimaryKey(pk.PurchaseLineID), 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="PURPurchaseLinePrimaryKey">Primary Key information based on which data is to be fetched.</param>
///
/// <returns>object of class PURPurchaseReturnLineCollection</returns>
public PURPurchaseReturnLineCollection SelectAllByForeignKeyOriginalpurchaseLineID(PURPurchaseLinePrimaryKey pk)
{
PURPurchaseReturnLineCollection pURPurchaseReturnLineCollection = new PURPurchaseReturnLineCollection();
foreach (POS.DataLayer.PURPurchaseReturnLine _pURPurchaseReturnLine in POS.DataLayer.PURPurchaseReturnLineBase.SelectAllByForeignKeyOriginalpurchaseLineID(new POS.DataLayer.PURPurchaseLinePrimaryKey(pk.PurchaseLineID)))
{
_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="PURPurchaseLinePrimaryKey">Primary Key information based on which data is to be deleted.</param>
///
/// <returns>True if succeeded</returns>
public bool DeleteAllByForeignKeyOriginalpurchaseLineID(PURPurchaseLinePrimaryKey pk)
{
return(POS.DataLayer.PURPurchaseReturnLineBase.DeleteAllByForeignKeyOriginalpurchaseLineID(new POS.DataLayer.PURPurchaseLinePrimaryKey(pk.PurchaseLineID)));
}