/// <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 INVTakingInventoryLineCollection</returns> public INVTakingInventoryLineCollection SelectAllByForeignKeyStockTypeID(INVStockTypePrimaryKey pk) { INVTakingInventoryLineCollection iNVTakingInventoryLineCollection = new INVTakingInventoryLineCollection(); foreach (POS.DataLayer.INVTakingInventoryLine _iNVTakingInventoryLine in POS.DataLayer.INVTakingInventoryLineBase.SelectAllByForeignKeyStockTypeID(new POS.DataLayer.INVStockTypePrimaryKey(pk.StockTypeID))) { _iNVTakingInventoryLineWCF = new INVTakingInventoryLine(); _iNVTakingInventoryLineWCF.TakingLineID = _iNVTakingInventoryLine.TakingLineID; _iNVTakingInventoryLineWCF.TakingHeaderID = _iNVTakingInventoryLine.TakingHeaderID; _iNVTakingInventoryLineWCF.ProductID = _iNVTakingInventoryLine.ProductID; _iNVTakingInventoryLineWCF.ActualQty = _iNVTakingInventoryLine.ActualQty; _iNVTakingInventoryLineWCF.ExpectedQty = _iNVTakingInventoryLine.ExpectedQty; _iNVTakingInventoryLineWCF.CreatedBy = _iNVTakingInventoryLine.CreatedBy; _iNVTakingInventoryLineWCF.CreateDate = _iNVTakingInventoryLine.CreateDate; _iNVTakingInventoryLineWCF.UpdatedBy = _iNVTakingInventoryLine.UpdatedBy; _iNVTakingInventoryLineWCF.UpdateDate = _iNVTakingInventoryLine.UpdateDate; _iNVTakingInventoryLineWCF.IsDeleted = _iNVTakingInventoryLine.IsDeleted; _iNVTakingInventoryLineWCF.DeletedBy = _iNVTakingInventoryLine.DeletedBy; _iNVTakingInventoryLineWCF.DeleteDate = _iNVTakingInventoryLine.DeleteDate; _iNVTakingInventoryLineWCF.StockTypeID = _iNVTakingInventoryLine.StockTypeID; iNVTakingInventoryLineCollection.Add(_iNVTakingInventoryLineWCF); } return(iNVTakingInventoryLineCollection); }
/// <summary> /// This method will return an object representing the record matching the primary key information specified. /// </summary> /// /// <param name="pk" type="INVStockTypePrimaryKey">Primary Key information based on which data is to be fetched.</param> /// /// <returns>object of class INVStockType</returns> public INVStockType SelectOne(INVStockTypePrimaryKey pk) { _iNVStockTypeWCF = new INVStockType(); _iNVStockType = POS.DataLayer.INVStockTypeBase.SelectOne(new POS.DataLayer.INVStockTypePrimaryKey(pk.StockTypeID)); _iNVStockTypeWCF.StockTypeID = _iNVStockType.StockTypeID; _iNVStockTypeWCF.StockTypeName = _iNVStockType.StockTypeName; return(_iNVStockTypeWCF); }
/// <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 Delete the object from the database ///</summary> ///<param name="pk" type="INVStockTypePrimaryKey">Primary Key information based on which data is to be fetched.</param> /// <returns>True if succeeded</returns> public bool Delete(INVStockTypePrimaryKey pk) { return(POS.DataLayer.INVStockTypeBase.Delete(new POS.DataLayer.INVStockTypePrimaryKey(pk.StockTypeID))); }
/// <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="INVStockTypePrimaryKey">Primary Key information based on which data is to be deleted.</param> /// /// <returns>True if succeeded</returns> public bool DeleteAllByForeignKeyStockTypeID(INVStockTypePrimaryKey pk) { return(POS.DataLayer.INVProductStockBase.DeleteAllByForeignKeyStockTypeID(new POS.DataLayer.INVStockTypePrimaryKey(pk.StockTypeID))); }
/// <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="INVStockTypePrimaryKey">Primary Key information based on which data is to be deleted.</param> /// /// <returns>True if succeeded</returns> public bool DeleteAllByForeignKeyStockTypeID(INVStockTypePrimaryKey pk) { return(POS.DataLayer.INVTakingInventoryLineBase.DeleteAllByForeignKeyStockTypeID(new POS.DataLayer.INVStockTypePrimaryKey(pk.StockTypeID))); }