/// <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);
}
public bool DeleteTransaction(int ProductStockID,INVAdjustStockCollection ajustStockCollection)
{
oDatabaseHelper = new DatabaseHelper();
bool ExecutionState = false;
oDatabaseHelper.BeginTransaction();
if (DeleteAdjustStock(oDatabaseHelper,ProductStockID))
{
foreach (INVAdjustStock adjustStock in ajustStockCollection)
{
if (!InsertDetailsAndCommit(oDatabaseHelper, adjustStock))
{
ExecutionState = false;
break;
}
else
ExecutionState = true;
}
}
else
ExecutionState = false;
if (ExecutionState)
oDatabaseHelper.CommitTransaction();
else
oDatabaseHelper.RollbackTransaction();
return ExecutionState;
}
/// <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;
}
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);
}
public FrmAdjustStockAddEdit(FrmAdjustmentSearch frmAdjustmentSearch)
{
InitializeComponent();
this._invProductStockWrapper = new INVProductStockWrapper();
this._inventoryWrapper = new INVInventoryWrapper();
this._stockTypeWrapper = new INVStockTypeWrapper();
this._adjustStockReasonWrapper = new INVAdjustStockReasonWrapper();
this._adjustStockWrapper = new INVAdjustStockWrapper();
this._adjustStock = new INVAdjustStock();
this._ProductWrapper = new BDProductWrapper();
this._adjustStockCollection = new INVAdjustStockCollection();
this._isEdit = false;
this._frmAdjustmentSearch = frmAdjustmentSearch;
}
public FrmAdjustStockAddEdit(FrmAdjustmentSearch frmAdjustmentSearch)
{
InitializeComponent();
this._invProductStockWrapper = new INVProductStockWrapper();
this._inventoryWrapper = new INVInventoryWrapper();
this._stockTypeWrapper = new INVStockTypeWrapper();
this._adjustStockReasonWrapper = new INVAdjustStockReasonWrapper();
this._adjustStockWrapper = new INVAdjustStockWrapper();
this._adjustStock = new INVAdjustStock();
this._ProductWrapper = new BDProductWrapper();
this._adjustStockCollection = new INVAdjustStockCollection();
this._isEdit = false;
this._frmAdjustmentSearch = frmAdjustmentSearch;
}
/// <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);
}
public bool SaveTransaction(INVAdjustStockCollection ajustStockCollection)
{
oDatabaseHelper = new DatabaseHelper();
bool ExecutionState = false;
oDatabaseHelper.BeginTransaction();
foreach (INVAdjustStock adjustStock in ajustStockCollection)
{
if (!InsertDetailsAndCommit(oDatabaseHelper, adjustStock))
{
ExecutionState = false;
break;
}
else
ExecutionState = true;
}
if (ExecutionState)
oDatabaseHelper.CommitTransaction();
else
oDatabaseHelper.RollbackTransaction();
return ExecutionState;
}
/// <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);
}
private static DataLayer.INVAdjustStockCollection GetAdjustStockFromBLLayer(INVAdjustStockCollection adjustStockCollection)
{
POS.DataLayer.INVAdjustStockCollection _adjustStockCollection = new DataLayer.INVAdjustStockCollection();
foreach (INVAdjustStock adjustStock in adjustStockCollection)
{
POS.DataLayer.INVAdjustStock _adjustStock = new POS.DataLayer.INVAdjustStock();
_adjustStock.ProductID = adjustStock.ProductID;
_adjustStock.AdjustReasonID = adjustStock.AdjustReasonID;
_adjustStock.AdjustStockID = adjustStock.AdjustStockID;
_adjustStock.BatchID = adjustStock.BatchID;
_adjustStock.InventoryID = adjustStock.InventoryID;
_adjustStock.StockTypeID = adjustStock.StockTypeID;
_adjustStock.Qty = adjustStock.Qty;
_adjustStock.UpdateDate = adjustStock.UpdateDate;
_adjustStock.UpdatedBy = adjustStock.UpdatedBy;
_adjustStock.CredateDate = adjustStock.CredateDate;
_adjustStock.CreatedBy = adjustStock.CreatedBy;
_adjustStock.ExpiryDate = adjustStock.ExpiryDate;
_adjustStock.BatchNumber = adjustStock.BatchNumber;
_adjustStockCollection.Add(_adjustStock);
}
return(_adjustStockCollection);
}
public bool SaveAdjustStock(INVAdjustStockCollection adjustStockCollection)
{
POS.DataLayer.INVAdjustStockCollection _adjustStockCollection = GetAdjustStockFromBLLayer(adjustStockCollection);
POS.DataLayer.INVAdjustStock adjustStockEntity = new DataLayer.INVAdjustStock();
return adjustStockEntity.SaveTransaction(_adjustStockCollection);
}
/// <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;
}
private static DataLayer.INVAdjustStockCollection GetAdjustStockFromBLLayer(INVAdjustStockCollection adjustStockCollection)
{
POS.DataLayer.INVAdjustStockCollection _adjustStockCollection = new DataLayer.INVAdjustStockCollection();
foreach (INVAdjustStock adjustStock in adjustStockCollection)
{
POS.DataLayer.INVAdjustStock _adjustStock = new POS.DataLayer.INVAdjustStock();
_adjustStock.ProductID = adjustStock.ProductID;
_adjustStock.AdjustReasonID = adjustStock.AdjustReasonID;
_adjustStock.AdjustStockID = adjustStock.AdjustStockID;
_adjustStock.BatchID = adjustStock.BatchID;
_adjustStock.InventoryID = adjustStock.InventoryID;
_adjustStock.StockTypeID = adjustStock.StockTypeID;
_adjustStock.Qty = adjustStock.Qty;
_adjustStock.UpdateDate = adjustStock.UpdateDate;
_adjustStock.UpdatedBy = adjustStock.UpdatedBy;
_adjustStock.CredateDate = adjustStock.CredateDate;
_adjustStock.CreatedBy = adjustStock.CreatedBy;
_adjustStock.ExpiryDate = adjustStock.ExpiryDate;
_adjustStock.BatchNumber = adjustStock.BatchNumber;
_adjustStockCollection.Add(_adjustStock);
}
return _adjustStockCollection;
}
public bool SaveAdjustStock(INVAdjustStockCollection adjustStockCollection)
{
POS.DataLayer.INVAdjustStockCollection _adjustStockCollection = GetAdjustStockFromBLLayer(adjustStockCollection);
POS.DataLayer.INVAdjustStock adjustStockEntity = new DataLayer.INVAdjustStock();
return(adjustStockEntity.SaveTransaction(_adjustStockCollection));
}
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 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 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;
}
