public bool DeleteAdjustStock(int id)
{
bool deleted = false;
try
{
INVAdjustStockCollection ajustStockCollection = new INVAdjustStockCollection();
INVAdjustStock _adjustNewStock = new INVAdjustStock();
INVAdjustStock _adjustOldStock = new INVAdjustStock();
INVAdjustStockPrimaryKey pk = new INVAdjustStockPrimaryKey();
pk.AdjustStockID = id;
_adjustNewStock = SelectOne(pk);
_adjustOldStock = SelectOne(pk);
INVAdjustStock _EditNewAdjustStock = _adjustNewStock;
_EditNewAdjustStock.Qty *= -1;
ajustStockCollection.Add(_EditNewAdjustStock);
INVAdjustStock _EditOldAdjustStock = _adjustOldStock;
_EditOldAdjustStock.StockTypeID = _adjustOldStock.OldStockTypeID;
ajustStockCollection.Add(_EditOldAdjustStock);
POS.DataLayer.INVAdjustStock adjustStockEntity = new DataLayer.INVAdjustStock();
deleted = adjustStockEntity.DeleteTransaction(id, GetAdjustStockFromBLLayer(ajustStockCollection));
}
catch (Exception ex)
{
throw ex;
}
return(deleted);
}
/// <summary>
/// This method will return a list of objects representing all records in the table.
/// </summary>
///
/// <returns>list of objects of class INVAdjustStock in the form of object of INVAdjustStockCollection </returns>
public INVAdjustStockCollection SelectAll()
{
INVAdjustStockCollection iNVAdjustStockCollection = new INVAdjustStockCollection();
foreach (POS.DataLayer.INVAdjustStock _iNVAdjustStock in POS.DataLayer.INVAdjustStockBase.SelectAll())
{
_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;
_iNVAdjustStockWCF.StockTypeID = _iNVAdjustStock.StockTypeID;
_iNVAdjustStockWCF.OldStockTypeID = _iNVAdjustStock.OldStockTypeID;
_iNVAdjustStockWCF.InventoryID = _iNVAdjustStock.InventoryID;
_iNVAdjustStockWCF.ExpiryDate = _iNVAdjustStock.ExpiryDate;
_iNVAdjustStockWCF.BatchNumber = _iNVAdjustStock.BatchNumber;
iNVAdjustStockCollection.Add(_iNVAdjustStockWCF);
}
return(iNVAdjustStockCollection);
}
/// <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 INVAdjustStock</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 INVAdjustStock in the form of an object of class INVAdjustStockCollection</returns>
public INVAdjustStockCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement)
{
INVAdjustStockCollection iNVAdjustStockCollection = new INVAdjustStockCollection();
foreach (POS.DataLayer.INVAdjustStock _iNVAdjustStock in POS.DataLayer.INVAdjustStockBase.SelectByFieldPaged(field, fieldValue, fieldValue2, typeOperation, 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;
_iNVAdjustStockWCF.StockTypeID = _iNVAdjustStock.StockTypeID;
_iNVAdjustStockWCF.OldStockTypeID = _iNVAdjustStock.OldStockTypeID;
_iNVAdjustStockWCF.InventoryID = _iNVAdjustStock.InventoryID;
_iNVAdjustStockWCF.ExpiryDate = _iNVAdjustStock.ExpiryDate;
_iNVAdjustStockWCF.BatchNumber = _iNVAdjustStock.BatchNumber;
iNVAdjustStockCollection.Add(_iNVAdjustStockWCF);
}
return(iNVAdjustStockCollection);
}
/// <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 INVAdjustStock in the form of an object of class INVAdjustStockCollection </returns>
public INVAdjustStockCollection SelectAllPaged(int?pageSize, int?skipPages, string orderByStatement)
{
INVAdjustStockCollection iNVAdjustStockCollection = new INVAdjustStockCollection();
foreach (POS.DataLayer.INVAdjustStock _iNVAdjustStock in POS.DataLayer.INVAdjustStockBase.SelectAllPaged(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;
_iNVAdjustStockWCF.StockTypeID = _iNVAdjustStock.StockTypeID;
_iNVAdjustStockWCF.OldStockTypeID = _iNVAdjustStock.OldStockTypeID;
_iNVAdjustStockWCF.InventoryID = _iNVAdjustStock.InventoryID;
_iNVAdjustStockWCF.ExpiryDate = _iNVAdjustStock.ExpiryDate;
_iNVAdjustStockWCF.BatchNumber = _iNVAdjustStock.BatchNumber;
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>
/// <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 get row(s) from the database using the value of the field specified
/// </summary>
///
/// <param name="field" type="string">Field of the class INVAdjustStock</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 INVAdjustStock in the form of an object of class INVAdjustStockCollection</returns>
public INVAdjustStockCollection SelectByField(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation)
{
INVAdjustStockCollection iNVAdjustStockCollection = new INVAdjustStockCollection();
foreach (POS.DataLayer.INVAdjustStock _iNVAdjustStock in POS.DataLayer.INVAdjustStockBase.SelectByField(field, fieldValue, fieldValue2, typeOperation))
{
_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);
}
new private bool Validate()
{
bool isValid = false;
bool isValidProduct = false;
int ProductID = 0;
int? oldStockTypeId = dgrid_stock.SelectedRows.Count > 0 ? int.Parse(dgrid_stock.SelectedRows[0].Cells["col_StockTypeID"].Value.ToString()) : 0;
string BatchID = dgrid_batches.SelectedRows.Count > 0 ? dgrid_batches.SelectedRows[0].Cells["col_batch"].Value.ToString() : "";
DateTime?ExpiryDate = dgrid_batches.SelectedRows.Count > 0 ? Convert.ToDateTime(dgrid_batches.SelectedRows[0].Cells["col_expiry"].Value.ToString()) : (DateTime?)null;
decimal oldQty = dgrid_batches.SelectedRows.Count > 0 ? Convert.ToDecimal(dgrid_batches.SelectedRows[0].Cells["col_batchQty"].Value.ToString()) : Convert.ToDecimal(dgrid_stock.SelectedRows[0].Cells["col_qty"].Value.ToString());
int AdjustReasonID = 0;
int StockTypeID = 0;
int InventoryID = 0;
decimal Qty = num_Qty.Value;
int.TryParse(dgrid_stock.SelectedRows[0].Cells["col_invProductStock"].Value.ToString(), out ProductID);
int.TryParse(cbx_AdjustReason.SelectedValue.ToString(), out AdjustReasonID);
int.TryParse(cbx_StockTypeTO.SelectedValue.ToString(), out StockTypeID);
int.TryParse(cbx_Store.SelectedValue.ToString(), out InventoryID);
if (ProductID > 0)
{
isValidProduct = true;
BDProductPrimaryKey pk = new BDProductPrimaryKey();
pk.ProductID = ProductID;
if (_ProductWrapper.SelectOne(pk).IsAcceptBatch == true)
{
isValidProduct = (!string.IsNullOrEmpty(BatchID) && ExpiryDate.HasValue);
}
}
if (!isValidProduct || AdjustReasonID == 0 || StockTypeID == 0 || InventoryID == 0 || Qty == 0 || Qty > oldQty || oldStockTypeId == StockTypeID)
{
isValid = false;
}
else
{
isValid = true;
if (_isEdit)
{
INVAdjustStock _EditNewAdjustStock = _adjustStock;
_EditNewAdjustStock.Qty *= -1;
_adjustStockCollection.Add(_EditNewAdjustStock);
INVAdjustStock _EditOldAdjustStock = _adjustStock;
_adjustStock.StockTypeID = _adjustStock.OldStockTypeID;
_adjustStockCollection.Add(_EditOldAdjustStock);
}
_adjustStock.ProductID = ProductID;
_adjustStock.AdjustReasonID = AdjustReasonID;
_adjustStock.AdjustStockID = _adjustStockID;
_adjustStock.BatchID = null;
_adjustStock.InventoryID = InventoryID;
_adjustStock.StockTypeID = StockTypeID;
_adjustStock.OldStockTypeID = oldStockTypeId;
_adjustStock.Qty = Qty;
_adjustStock.BatchNumber = BatchID;
_adjustStock.ExpiryDate = ExpiryDate;
if (_isEdit)
{
_adjustStock.UpdateDate = DateTime.Now;
_adjustStock.UpdatedBy = GlobalVariables.CurrentUser.UserID;
}
else
{
_adjustStock.CredateDate = DateTime.Now;
_adjustStock.CreatedBy = GlobalVariables.CurrentUser.UserID;
}
INVAdjustStock _oldAdjustStock = new INVAdjustStock();
_oldAdjustStock.ProductID = ProductID;
_oldAdjustStock.AdjustReasonID = AdjustReasonID;
_oldAdjustStock.AdjustStockID = _adjustStockID;
_oldAdjustStock.BatchID = null;
_oldAdjustStock.InventoryID = InventoryID;
_oldAdjustStock.StockTypeID = oldStockTypeId;
_oldAdjustStock.Qty = (-1 * Qty);
_oldAdjustStock.BatchNumber = BatchID;
_oldAdjustStock.ExpiryDate = ExpiryDate;
if (_isEdit)
{
_oldAdjustStock.UpdateDate = DateTime.Now;
_oldAdjustStock.UpdatedBy = GlobalVariables.CurrentUser.UserID;
}
else
{
_oldAdjustStock.CredateDate = DateTime.Now;
_oldAdjustStock.CreatedBy = GlobalVariables.CurrentUser.UserID;
}
_adjustStockCollection.Add(_oldAdjustStock);
}
return(isValid);
}
/// <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 INVAdjustStockCollection</returns>
///
/// <remarks>
///
/// <RevisionHistory>
/// Author Date Description
/// DLGenerator 4/4/2015 1:32:30 PM Created function
///
/// </RevisionHistory>
///
/// </remarks>
///
internal static INVAdjustStockCollection PopulateObjectsFromReaderWithCheckingReader(IDataReader rdr, DatabaseHelper oDatabaseHelper)
{
INVAdjustStockCollection list = new INVAdjustStockCollection();
if (rdr.Read())
{
INVAdjustStock obj = new INVAdjustStock();
PopulateObjectFromReader(obj, rdr);
list.Add(obj);
while (rdr.Read())
{
obj = new INVAdjustStock();
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 INVAdjustStockCollection</returns>
///
/// <remarks>
///
/// <RevisionHistory>
/// Author Date Description
/// DLGenerator 4/4/2015 1:32:30 PM Created function
///
/// </RevisionHistory>
///
/// </remarks>
///
internal static INVAdjustStockCollection PopulateObjectsFromReader(IDataReader rdr)
{
INVAdjustStockCollection list = new INVAdjustStockCollection();
while (rdr.Read())
{
INVAdjustStock obj = new INVAdjustStock();
PopulateObjectFromReader(obj,rdr);
list.Add(obj);
}
return list;
}
public bool DeleteAdjustStock(int id)
{
bool deleted = false;
try
{
INVAdjustStockCollection ajustStockCollection = new INVAdjustStockCollection();
INVAdjustStock _adjustNewStock = new INVAdjustStock();
INVAdjustStock _adjustOldStock = new INVAdjustStock();
INVAdjustStockPrimaryKey pk = new INVAdjustStockPrimaryKey();
pk.AdjustStockID = id;
_adjustNewStock = SelectOne(pk);
_adjustOldStock = SelectOne(pk);
INVAdjustStock _EditNewAdjustStock = _adjustNewStock;
_EditNewAdjustStock.Qty *= -1;
ajustStockCollection.Add(_EditNewAdjustStock);
INVAdjustStock _EditOldAdjustStock = _adjustOldStock;
_EditOldAdjustStock.StockTypeID = _adjustOldStock.OldStockTypeID;
ajustStockCollection.Add(_EditOldAdjustStock);
POS.DataLayer.INVAdjustStock adjustStockEntity = new DataLayer.INVAdjustStock();
deleted = adjustStockEntity.DeleteTransaction(id, GetAdjustStockFromBLLayer(ajustStockCollection));
}
catch (Exception ex)
{
throw ex;
}
return deleted;
}
/// <summary>
/// This method will return a list of objects representing all records in the table.
/// </summary>
///
/// <returns>list of objects of class INVAdjustStock in the form of object of INVAdjustStockCollection </returns>
public INVAdjustStockCollection SelectAll()
{
INVAdjustStockCollection iNVAdjustStockCollection = new INVAdjustStockCollection();
foreach (POS.DataLayer.INVAdjustStock _iNVAdjustStock in POS.DataLayer.INVAdjustStockBase.SelectAll())
{
_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;
_iNVAdjustStockWCF.StockTypeID = _iNVAdjustStock.StockTypeID;
_iNVAdjustStockWCF.OldStockTypeID = _iNVAdjustStock.OldStockTypeID;
_iNVAdjustStockWCF.InventoryID = _iNVAdjustStock.InventoryID;
_iNVAdjustStockWCF.ExpiryDate = _iNVAdjustStock.ExpiryDate;
_iNVAdjustStockWCF.BatchNumber = _iNVAdjustStock.BatchNumber;
iNVAdjustStockCollection.Add(_iNVAdjustStockWCF);
}
return iNVAdjustStockCollection;
}
/// <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 INVAdjustStock</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 INVAdjustStock in the form of an object of class INVAdjustStockCollection</returns>
public INVAdjustStockCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement)
{
INVAdjustStockCollection iNVAdjustStockCollection = new INVAdjustStockCollection();
foreach (POS.DataLayer.INVAdjustStock _iNVAdjustStock in POS.DataLayer.INVAdjustStockBase.SelectByFieldPaged(field, fieldValue, fieldValue2, typeOperation, 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;
_iNVAdjustStockWCF.StockTypeID = _iNVAdjustStock.StockTypeID;
_iNVAdjustStockWCF.OldStockTypeID = _iNVAdjustStock.OldStockTypeID;
_iNVAdjustStockWCF.InventoryID = _iNVAdjustStock.InventoryID;
_iNVAdjustStockWCF.ExpiryDate = _iNVAdjustStock.ExpiryDate;
_iNVAdjustStockWCF.BatchNumber = _iNVAdjustStock.BatchNumber;
iNVAdjustStockCollection.Add(_iNVAdjustStockWCF);
}
return iNVAdjustStockCollection;
}
/// <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 INVAdjustStock in the form of an object of class INVAdjustStockCollection </returns>
public INVAdjustStockCollection SelectAllPaged(int? pageSize, int? skipPages, string orderByStatement)
{
INVAdjustStockCollection iNVAdjustStockCollection = new INVAdjustStockCollection();
foreach (POS.DataLayer.INVAdjustStock _iNVAdjustStock in POS.DataLayer.INVAdjustStockBase.SelectAllPaged(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;
_iNVAdjustStockWCF.StockTypeID = _iNVAdjustStock.StockTypeID;
_iNVAdjustStockWCF.OldStockTypeID = _iNVAdjustStock.OldStockTypeID;
_iNVAdjustStockWCF.InventoryID = _iNVAdjustStock.InventoryID;
_iNVAdjustStockWCF.ExpiryDate = _iNVAdjustStock.ExpiryDate;
_iNVAdjustStockWCF.BatchNumber = _iNVAdjustStock.BatchNumber;
iNVAdjustStockCollection.Add(_iNVAdjustStockWCF);
}
return iNVAdjustStockCollection;
}
