/// <summary>
/// This method will return a list of objects representing the specified number of entries from the specified record number in the table
/// using the value of the field specified
/// </summary>
///
/// <param name="field" type="string">Field of the class INVProductStock</param>
/// <param name="fieldValue" type="object">Value for the field specified.</param>
/// <param name="fieldValue2" type="object">Value for the field specified.</param>
/// <param name="typeOperation" type="TypeOperation">Operator that is used if fieldValue2=null or fieldValue2="".</param>
/// <param name="orderByStatement" type="string">The field value to number.</param>
/// <param name="pageSize" type="int">Number of records returned.</param>
/// <param name="skipPages" type="int">The number of missing pages.</param>
///
/// <returns>List of object of class INVProductStock in the form of an object of class INVProductStockCollection</returns>
public INVProductStockCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement)
{
INVProductStockCollection iNVProductStockCollection = new INVProductStockCollection();
foreach (POS.DataLayer.INVProductStock _iNVProductStock in POS.DataLayer.INVProductStockBase.SelectByFieldPaged(field, fieldValue, fieldValue2, typeOperation, 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;
_iNVProductStockWCF.InventoryID = _iNVProductStock.InventoryID;
_iNVProductStockWCF.IsBlocked = _iNVProductStock.IsBlocked;
iNVProductStockCollection.Add(_iNVProductStockWCF);
}
return(iNVProductStockCollection);
}
// private POS.DataLayer.INVProductStock _iNVProductStock;
public INVProductStockCollection GetInventoryStock(int?ProductStockID, string productCode, string productName, bool?IsAcceptBatch, bool getWithBatch)
{
INVProductStockCollection iNVProductStockCollection = new INVProductStockCollection();
foreach (POS.DataLayer.INVProductStock _iNVProductStock in POS.DataLayer.INVProductStock.GetInventoryStock(ProductStockID, productCode, productName, IsAcceptBatch, getWithBatch))
{
_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;
_iNVProductStockWCF.ProductCode = _iNVProductStock.ProductCode;
_iNVProductStockWCF.ProductName = _iNVProductStock.ProductName;
_iNVProductStockWCF.StockType = _iNVProductStock.StockType;
_iNVProductStockWCF.BatchNo = _iNVProductStock.BatchNo;
_iNVProductStockWCF.ExpiryDate = _iNVProductStock.ExpiryDate;
_iNVProductStockWCF.BatchQty = _iNVProductStock.BatchQty;
iNVProductStockCollection.Add(_iNVProductStockWCF);
}
return(iNVProductStockCollection);
}
// private POS.DataLayer.INVProductStock _iNVProductStock;
public INVProductStockCollection GetInventoryStock(int? ProductStockID, string productCode, string productName, bool? IsAcceptBatch, bool getWithBatch,int? InventoryID)
{
INVProductStock _iNVProductStockWCF;
INVProductStockCollection iNVProductStockCollection = new INVProductStockCollection();
foreach (POS.DataLayer.INVProductStock _iNVProductStock in POS.DataLayer.INVProductStock.GetInventoryStock(ProductStockID, productCode, productName, IsAcceptBatch, getWithBatch, InventoryID))
{
_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;
_iNVProductStockWCF.ProductCode = _iNVProductStock.ProductCode;
_iNVProductStockWCF.ProductName = _iNVProductStock.ProductName;
_iNVProductStockWCF.StockType = _iNVProductStock.StockType;
_iNVProductStockWCF.BatchNo = _iNVProductStock.BatchNo;
_iNVProductStockWCF.ExpiryDate = _iNVProductStock.ExpiryDate;
_iNVProductStockWCF.BatchQty = _iNVProductStock.BatchQty;
_iNVProductStockWCF.IsAcceptBatch = _iNVProductStock.IsAcceptBatch;
iNVProductStockCollection.Add(_iNVProductStockWCF);
}
return iNVProductStockCollection;
}
public bool SaveProductStockLine(INVProductStockCollection iNVProductStockCollection)
{
foreach (INVProductStock _iNVProductStockWCF in iNVProductStockCollection)
{
POS.DataLayer.INVProductStock iNVProductStock = new DataLayer.INVProductStock();
iNVProductStock.BatchNo = _iNVProductStockWCF.BatchNo;
iNVProductStock.BatchQty = _iNVProductStockWCF.BatchQty;
iNVProductStock.CreatedBy = GlobalVariables.CurrentUser.UserID;
iNVProductStock.CreateDate = _iNVProductStockWCF.CreateDate;
iNVProductStock.ExpiryDate = _iNVProductStockWCF.ExpiryDate;
iNVProductStock.InventoryID = _iNVProductStockWCF.InventoryID;
iNVProductStock.OpeningQty = _iNVProductStockWCF.OpeningQty;
iNVProductStock.OpennigDate = _iNVProductStockWCF.OpennigDate;
iNVProductStock.ProductID = _iNVProductStockWCF.ProductID;
iNVProductStock.StockTypeID = 1;
iNVProductStock.TotalQty = _iNVProductStockWCF.TotalQty;
iNVProductStock.UpdateDate = _iNVProductStockWCF.UpdateDate;
iNVProductStock.UpdatedBy = _iNVProductStockWCF.UpdatedBy;
if (!iNVProductStock.InsertINVProductStockWithBatch(iNVProductStock))
{
return false;
}
}
return true;
}
public bool SaveProductStockLine(INVProductStockCollection iNVProductStockCollection)
{
foreach (INVProductStock _iNVProductStockWCF in iNVProductStockCollection)
{
POS.DataLayer.INVProductStock iNVProductStock = new DataLayer.INVProductStock();
iNVProductStock.BatchNo = _iNVProductStockWCF.BatchNo;
iNVProductStock.BatchQty = _iNVProductStockWCF.BatchQty;
iNVProductStock.CreatedBy = GlobalVariables.CurrentUser.UserID;
iNVProductStock.CreateDate = _iNVProductStockWCF.CreateDate;
iNVProductStock.ExpiryDate = _iNVProductStockWCF.ExpiryDate;
iNVProductStock.InventoryID = _iNVProductStockWCF.InventoryID;
iNVProductStock.OpeningQty = _iNVProductStockWCF.OpeningQty;
iNVProductStock.OpennigDate = _iNVProductStockWCF.OpennigDate;
iNVProductStock.ProductID = _iNVProductStockWCF.ProductID;
iNVProductStock.StockTypeID = 1;
iNVProductStock.TotalQty = _iNVProductStockWCF.TotalQty;
iNVProductStock.UpdateDate = _iNVProductStockWCF.UpdateDate;
iNVProductStock.UpdatedBy = _iNVProductStockWCF.UpdatedBy;
if (!iNVProductStock.InsertINVProductStockWithBatch(iNVProductStock))
{
return(false);
}
}
return(true);
}
/// <summary>
/// This method will return a list of objects representing all records in the table.
/// </summary>
///
/// <returns>list of objects of class INVProductStock in the form of object of INVProductStockCollection </returns>
public INVProductStockCollection SelectAll()
{
INVProductStockCollection iNVProductStockCollection = new INVProductStockCollection();
foreach (POS.DataLayer.INVProductStock _iNVProductStock in POS.DataLayer.INVProductStockBase.SelectAll())
{
_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;
_iNVProductStockWCF.InventoryID = _iNVProductStock.InventoryID;
_iNVProductStockWCF.IsBlocked = _iNVProductStock.IsBlocked;
iNVProductStockCollection.Add(_iNVProductStockWCF);
}
return(iNVProductStockCollection);
}
/// <summary>
/// This method will return a list of objects representing the specified number of entries from the specified record number in the table.
/// </summary>
///
/// <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>list of objects of class INVProductStock in the form of an object of class INVProductStockCollection </returns>
public INVProductStockCollection SelectAllPaged(int?pageSize, int?skipPages, string orderByStatement)
{
INVProductStockCollection iNVProductStockCollection = new INVProductStockCollection();
foreach (POS.DataLayer.INVProductStock _iNVProductStock in POS.DataLayer.INVProductStockBase.SelectAllPaged(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;
_iNVProductStockWCF.InventoryID = _iNVProductStock.InventoryID;
_iNVProductStockWCF.IsBlocked = _iNVProductStock.IsBlocked;
iNVProductStockCollection.Add(_iNVProductStockWCF);
}
return(iNVProductStockCollection);
}
public frmOpenningQuantities()
{
InitializeComponent();
iNVProductStockCollection = new INVProductStockCollection();
_iNVInventoryWrapper = new INVInventoryWrapper();
_bDProductWrapper = new BDProductWrapper();
_iNVProductStockWrapper = new INVProductStockWrapper();
FillInventoryCBX();
}
public frmOpenningQuantities()
{
InitializeComponent();
iNVProductStockCollection = new INVProductStockCollection();
_iNVInventoryWrapper = new INVInventoryWrapper();
_bDProductWrapper = new BDProductWrapper();
_iNVProductStockWrapper = new INVProductStockWrapper();
FillInventoryCBX();
}
/// <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 get row(s) from the database using the value of the field specified
/// </summary>
///
/// <param name="field" type="string">Field of the class INVProductStock</param>
/// <param name="fieldValue" type="object">Value for the field specified.</param>
/// <param name="fieldValue2" type="object">Value for the field specified.</param>
/// <param name="typeOperation" type="TypeOperation">Operator that is used if fieldValue2=null or fieldValue2="".</param>
///
/// <returns>List of object of class INVProductStock in the form of an object of class INVProductStockCollection</returns>
public INVProductStockCollection SelectByField(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation)
{
INVProductStockCollection iNVProductStockCollection = new INVProductStockCollection();
foreach (POS.DataLayer.INVProductStock _iNVProductStock in POS.DataLayer.INVProductStockBase.SelectByField(field, fieldValue, fieldValue2, typeOperation))
{
_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 return a list of objects representing all records in the table.
/// </summary>
///
/// <returns>list of objects of class INVProductStock in the form of object of INVProductStockCollection </returns>
public INVProductStockCollection SelectAll()
{
INVProductStockCollection iNVProductStockCollection = new INVProductStockCollection();
foreach (POS.DataLayer.INVProductStock _iNVProductStock in POS.DataLayer.INVProductStockBase.SelectAll())
{
_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;
_iNVProductStockWCF.InventoryID = _iNVProductStock.InventoryID;
_iNVProductStockWCF.IsBlocked = _iNVProductStock.IsBlocked;
iNVProductStockCollection.Add(_iNVProductStockWCF);
}
return iNVProductStockCollection;
}
private static INVProductStockCollection Fill(IDataReader dr, bool getWithBatch)
{
INVProductStockCollection collection = new INVProductStockCollection();
while (dr.Read())
{
INVProductStock obj = new INVProductStock();
obj.ProductStockID = dr.GetInt32(dr.GetOrdinal(ALLINVProductStockFields.ProductStockID));
obj.ProductID = dr.GetInt32(dr.GetOrdinal(ALLINVProductStockFields.ProductID));
obj.TotalQty = dr.GetDecimal(dr.GetOrdinal(ALLINVProductStockFields.TotalQty));
obj.StockTypeID = dr.GetInt32(dr.GetOrdinal(ALLINVProductStockFields.StockTypeID));
obj.ProductName = dr.GetString(dr.GetOrdinal(ALLINVProductStockFields.ProductName));
obj.StockType = dr.GetString(dr.GetOrdinal(ALLINVProductStockFields.StockTypeName));
if (!dr.IsDBNull(dr.GetOrdinal(ALLINVProductStockFields.ProductCode)))
{
obj.ProductCode = dr.GetString(dr.GetOrdinal(ALLINVProductStockFields.ProductCode));
}
if (dr.GetOrdinal("IsAcceptBatch") != null)
{
obj.IsAcceptBatch = dr.GetBoolean(dr.GetOrdinal("IsAcceptBatch"));
}
if (getWithBatch)
{
if (dr.GetOrdinal(ALLINVProductStockFields.BatchNumber) != null)
{
obj.BatchNo = dr.GetString(dr.GetOrdinal(ALLINVProductStockFields.BatchNumber));
}
if (dr.GetOrdinal(ALLINVProductStockFields.ExpiryDate) != null)
{
obj.ExpiryDate = dr.GetDateTime(dr.GetOrdinal(ALLINVProductStockFields.ExpiryDate));
}
if (dr.GetOrdinal(ALLINVProductStockFields.BatchQty) != null)
{
obj.BatchQty = dr.GetDecimal(dr.GetOrdinal(ALLINVProductStockFields.BatchQty));
}
}
collection.Add(obj);
}
return collection;
}
/// <summary>
/// Populates the fields for multiple objects from the columns found in an open reader.
/// </summary>
///
/// <param name="rdr" type="IDataReader">An object that implements the IDataReader interface</param>
///
/// <returns>Object of INVProductStockCollection</returns>
///
/// <remarks>
///
/// <RevisionHistory>
/// Author Date Description
/// DLGenerator 3/7/2015 2:37:24 PM Created function
///
/// </RevisionHistory>
///
/// </remarks>
///
internal static INVProductStockCollection PopulateObjectsFromReaderWithCheckingReader(IDataReader rdr, DatabaseHelper oDatabaseHelper)
{
INVProductStockCollection list = new INVProductStockCollection();
if (rdr.Read())
{
INVProductStock obj = new INVProductStock();
PopulateObjectFromReader(obj, rdr);
list.Add(obj);
while (rdr.Read())
{
obj = new INVProductStock();
PopulateObjectFromReader(obj, rdr);
list.Add(obj);
}
oDatabaseHelper.Dispose();
return list;
}
else
{
oDatabaseHelper.Dispose();
return null;
}
}
/// <summary>
/// Populates the fields for multiple objects from the columns found in an open reader.
/// </summary>
///
/// <param name="rdr" type="IDataReader">An object that implements the IDataReader interface</param>
///
/// <returns>Object of INVProductStockCollection</returns>
///
/// <remarks>
///
/// <RevisionHistory>
/// Author Date Description
/// DLGenerator 3/7/2015 2:37:24 PM Created function
///
/// </RevisionHistory>
///
/// </remarks>
///
internal static INVProductStockCollection PopulateObjectsFromReader(IDataReader rdr)
{
INVProductStockCollection list = new INVProductStockCollection();
while (rdr.Read())
{
INVProductStock obj = new INVProductStock();
PopulateObjectFromReader(obj,rdr);
list.Add(obj);
}
return list;
}
/// <summary>
/// This method will return a list of objects representing the specified number of entries from the specified record number in the table
/// using the value of the field specified
/// </summary>
///
/// <param name="field" type="string">Field of the class INVProductStock</param>
/// <param name="fieldValue" type="object">Value for the field specified.</param>
/// <param name="fieldValue2" type="object">Value for the field specified.</param>
/// <param name="typeOperation" type="TypeOperation">Operator that is used if fieldValue2=null or fieldValue2="".</param>
/// <param name="orderByStatement" type="string">The field value to number.</param>
/// <param name="pageSize" type="int">Number of records returned.</param>
/// <param name="skipPages" type="int">The number of missing pages.</param>
///
/// <returns>List of object of class INVProductStock in the form of an object of class INVProductStockCollection</returns>
public INVProductStockCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement)
{
INVProductStockCollection iNVProductStockCollection = new INVProductStockCollection();
foreach (POS.DataLayer.INVProductStock _iNVProductStock in POS.DataLayer.INVProductStockBase.SelectByFieldPaged(field, fieldValue, fieldValue2, typeOperation, 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;
_iNVProductStockWCF.InventoryID = _iNVProductStock.InventoryID;
_iNVProductStockWCF.IsBlocked = _iNVProductStock.IsBlocked;
iNVProductStockCollection.Add(_iNVProductStockWCF);
}
return iNVProductStockCollection;
}
/// <summary>
/// This method will return a list of objects representing the specified number of entries from the specified record number in the table.
/// </summary>
///
/// <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>list of objects of class INVProductStock in the form of an object of class INVProductStockCollection </returns>
public INVProductStockCollection SelectAllPaged(int? pageSize, int? skipPages, string orderByStatement)
{
INVProductStockCollection iNVProductStockCollection = new INVProductStockCollection();
foreach (POS.DataLayer.INVProductStock _iNVProductStock in POS.DataLayer.INVProductStockBase.SelectAllPaged(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;
_iNVProductStockWCF.InventoryID = _iNVProductStock.InventoryID;
_iNVProductStockWCF.IsBlocked = _iNVProductStock.IsBlocked;
iNVProductStockCollection.Add(_iNVProductStockWCF);
}
return iNVProductStockCollection;
}
