/// <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; }