/// <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 VSalesReturnHeader</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 VSalesReturnHeader in the form of an object of class VSalesReturnHeaderCollection</returns>
public VSalesReturnHeaderCollection SelectByField(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation)
{
VSalesReturnHeaderCollection vSalesReturnHeaderCollection = new VSalesReturnHeaderCollection();
foreach (POS.DataLayer.VSalesReturnHeader _vSalesReturnHeader in POS.DataLayer.VSalesReturnHeaderBase.SelectByField(field, fieldValue, fieldValue2, typeOperation))
{
_vSalesReturnHeaderWCF = new VSalesReturnHeader();
_vSalesReturnHeaderWCF.SlaesReturnHeaderID = _vSalesReturnHeader.SlaesReturnHeaderID;
_vSalesReturnHeaderWCF.ReturnDate = _vSalesReturnHeader.ReturnDate;
_vSalesReturnHeaderWCF.IsClosed = _vSalesReturnHeader.IsClosed;
_vSalesReturnHeaderWCF.InvoiceNumber = _vSalesReturnHeader.InvoiceNumber;
_vSalesReturnHeaderWCF.CustomerName = _vSalesReturnHeader.CustomerName;
_vSalesReturnHeaderWCF.SalesHeaderID = _vSalesReturnHeader.SalesHeaderID;
vSalesReturnHeaderCollection.Add(_vSalesReturnHeaderWCF);
}
return vSalesReturnHeaderCollection;
}
public static VSALSalesOrderCollection SelectByInvoiceNumber(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation)
{
DatabaseHelper oDatabaseHelper = new DatabaseHelper();
bool ExecutionState = false;
// Pass the specified field and its value to the stored procedure.
oDatabaseHelper.AddParameter("@Field", field);
oDatabaseHelper.AddParameter("@Value", fieldValue);
oDatabaseHelper.AddParameter("@Value2", fieldValue2);
oDatabaseHelper.AddParameter("@Operation", OperationCollection.Operation[(int)typeOperation]);
// The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure.
oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output);
IDataReader dr = oDatabaseHelper.ExecuteReader("gsp_VSALSalesOrder_SelectByField", ref ExecutionState);
VSALSalesOrderCollection VSALSalesOrderCollection = PopulateObjectsFromReader(dr);
dr.Close();
oDatabaseHelper.Dispose();
return VSALSalesOrderCollection;
}
/// <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 INVBatch</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 INVBatch in the form of an object of class INVBatchCollection</returns>
public INVBatchCollection SelectByField(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation)
{
INVBatchCollection iNVBatchCollection = new INVBatchCollection();
foreach (POS.DataLayer.INVBatch _iNVBatch in POS.DataLayer.INVBatchBase.SelectByField(field, fieldValue, fieldValue2, typeOperation))
{
_iNVBatchWCF = new INVBatch();
_iNVBatchWCF.BatchID = _iNVBatch.BatchID;
_iNVBatchWCF.BatchNumber = _iNVBatch.BatchNumber;
_iNVBatchWCF.ExpiryDate = _iNVBatch.ExpiryDate;
iNVBatchCollection.Add(_iNVBatchWCF);
}
return iNVBatchCollection;
}
/// <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 INVProductStockBatch</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 INVProductStockBatch in the form of an object of class INVProductStockBatchCollection</returns>
public INVProductStockBatchCollection SelectByField(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation)
{
INVProductStockBatchCollection iNVProductStockBatchCollection = new INVProductStockBatchCollection();
foreach (POS.DataLayer.INVProductStockBatch _iNVProductStockBatch in POS.DataLayer.INVProductStockBatchBase.SelectByField(field, fieldValue, fieldValue2, typeOperation))
{
_iNVProductStockBatchWCF = new INVProductStockBatch();
_iNVProductStockBatchWCF.ProductStockBatchID = _iNVProductStockBatch.ProductStockBatchID;
_iNVProductStockBatchWCF.ProductStockID = _iNVProductStockBatch.ProductStockID;
_iNVProductStockBatchWCF.BatchID = _iNVProductStockBatch.BatchID;
_iNVProductStockBatchWCF.Qty = _iNVProductStockBatch.Qty;
iNVProductStockBatchCollection.Add(_iNVProductStockBatchWCF);
}
return iNVProductStockBatchCollection;
}
/// <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 BDTaxType</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 BDTaxType in the form of an object of class BDTaxTypeCollection</returns>
public BDTaxTypeCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement)
{
BDTaxTypeCollection bDTaxTypeCollection = new BDTaxTypeCollection();
foreach (POS.DataLayer.BDTaxType _bDTaxType in POS.DataLayer.BDTaxTypeBase.SelectByFieldPaged(field, fieldValue, fieldValue2, typeOperation, pageSize, skipPages, orderByStatement))
{
_bDTaxTypeWCF = new BDTaxType();
_bDTaxTypeWCF.TaxTypeID = _bDTaxType.TaxTypeID;
_bDTaxTypeWCF.TaxTypeName = _bDTaxType.TaxTypeName;
_bDTaxTypeWCF.TaxValue = _bDTaxType.TaxValue;
bDTaxTypeCollection.Add(_bDTaxTypeWCF);
}
return bDTaxTypeCollection;
}
/// <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 INVTransferLine</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 INVTransferLine in the form of an object of class INVTransferLineCollection</returns>
public INVTransferLineCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement)
{
INVTransferLineCollection iNVTransferLineCollection = new INVTransferLineCollection();
foreach (POS.DataLayer.INVTransferLine _iNVTransferLine in POS.DataLayer.INVTransferLineBase.SelectByFieldPaged(field, fieldValue, fieldValue2, typeOperation, pageSize, skipPages, orderByStatement))
{
_iNVTransferLineWCF = new INVTransferLine();
_iNVTransferLineWCF.TransferLineID = _iNVTransferLine.TransferLineID;
_iNVTransferLineWCF.TransferHeaderID = _iNVTransferLine.TransferHeaderID;
_iNVTransferLineWCF.ProductID = _iNVTransferLine.ProductID;
_iNVTransferLineWCF.Qty = _iNVTransferLine.Qty;
_iNVTransferLineWCF.CreatedBy = _iNVTransferLine.CreatedBy;
_iNVTransferLineWCF.CreateDate = _iNVTransferLine.CreateDate;
_iNVTransferLineWCF.UpdatedBy = _iNVTransferLine.UpdatedBy;
_iNVTransferLineWCF.UpdateDate = _iNVTransferLine.UpdateDate;
_iNVTransferLineWCF.IsDeleted = _iNVTransferLine.IsDeleted;
_iNVTransferLineWCF.DeletedBy = _iNVTransferLine.DeletedBy;
_iNVTransferLineWCF.DeletedDate = _iNVTransferLine.DeletedDate;
iNVTransferLineCollection.Add(_iNVTransferLineWCF);
}
return iNVTransferLineCollection;
}
/// <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 SALSalesLine</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 SALSalesLine in the form of an object of class SALSalesLineCollection</returns>
public SALSalesLineCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement)
{
SALSalesLineCollection sALSalesLineCollection = new SALSalesLineCollection();
foreach (POS.DataLayer.SALSalesLine _sALSalesLine in POS.DataLayer.SALSalesLineBase.SelectByFieldPaged(field, fieldValue, fieldValue2, typeOperation, pageSize, skipPages, orderByStatement))
{
_sALSalesLineWCF = new SALSalesLine();
_sALSalesLineWCF.SalesLineID = _sALSalesLine.SalesLineID;
_sALSalesLineWCF.SalesHeaderID = _sALSalesLine.SalesHeaderID;
_sALSalesLineWCF.ProductID = _sALSalesLine.ProductID;
_sALSalesLineWCF.TotalQty = _sALSalesLine.TotalQty;
_sALSalesLineWCF.TotalBonus = _sALSalesLine.TotalBonus;
_sALSalesLineWCF.DiscountAmount = _sALSalesLine.DiscountAmount;
_sALSalesLineWCF.DiscountRatio = _sALSalesLine.DiscountRatio;
_sALSalesLineWCF.UnitPrice = _sALSalesLine.UnitPrice;
_sALSalesLineWCF.CreatedBy = _sALSalesLine.CreatedBy;
_sALSalesLineWCF.CreateDate = _sALSalesLine.CreateDate;
_sALSalesLineWCF.UpdatedBy = _sALSalesLine.UpdatedBy;
_sALSalesLineWCF.UpdateDate = _sALSalesLine.UpdateDate;
_sALSalesLineWCF.IsDeleted = _sALSalesLine.IsDeleted;
_sALSalesLineWCF.DeletedBy = _sALSalesLine.DeletedBy;
_sALSalesLineWCF.DeleteDate = _sALSalesLine.DeleteDate;
sALSalesLineCollection.Add(_sALSalesLineWCF);
}
return(sALSalesLineCollection);
}
/// <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 INVStockType</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 INVStockType in the form of an object of class INVStockTypeCollection</returns>
public INVStockTypeCollection SelectByField(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation)
{
INVStockTypeCollection iNVStockTypeCollection = new INVStockTypeCollection();
foreach (POS.DataLayer.INVStockType _iNVStockType in POS.DataLayer.INVStockTypeBase.SelectByField(field, fieldValue, fieldValue2, typeOperation))
{
_iNVStockTypeWCF = new INVStockType();
_iNVStockTypeWCF.StockTypeID = _iNVStockType.StockTypeID;
_iNVStockTypeWCF.StockTypeName = _iNVStockType.StockTypeName;
iNVStockTypeCollection.Add(_iNVStockTypeWCF);
}
return iNVStockTypeCollection;
}
/// <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 BDRefuseReason</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 BDRefuseReason in the form of an object of class BDRefuseReasonCollection</returns>
public BDRefuseReasonCollection SelectByField(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation)
{
BDRefuseReasonCollection bDRefuseReasonCollection = new BDRefuseReasonCollection();
foreach (POS.DataLayer.BDRefuseReason _bDRefuseReason in POS.DataLayer.BDRefuseReasonBase.SelectByField(field, fieldValue, fieldValue2, typeOperation))
{
_bDRefuseReasonWCF = new BDRefuseReason();
_bDRefuseReasonWCF.RefuseReasonID = _bDRefuseReason.RefuseReasonID;
_bDRefuseReasonWCF.RefuseReasonName = _bDRefuseReason.RefuseReasonName;
bDRefuseReasonCollection.Add(_bDRefuseReasonWCF);
}
return(bDRefuseReasonCollection);
}
/// <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 PaymentType</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 PaymentType in the form of an object of class PaymentTypeCollection</returns>
public PaymentTypeCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement)
{
PaymentTypeCollection paymentTypeCollection = new PaymentTypeCollection();
foreach (POS.DataLayer.PaymentType _paymentType in POS.DataLayer.PaymentTypeBase.SelectByFieldPaged(field, fieldValue, fieldValue2, typeOperation, pageSize, skipPages, orderByStatement))
{
_paymentTypeWCF = new PaymentType();
_paymentTypeWCF.PaymentTypeID = _paymentType.PaymentTypeID;
_paymentTypeWCF.PaymentTypeName = _paymentType.PaymentTypeName;
paymentTypeCollection.Add(_paymentTypeWCF);
}
return(paymentTypeCollection);
}
/// <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 PaymentType</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 PaymentType in the form of an object of class PaymentTypeCollection</returns>
public PaymentTypeCollection SelectByField(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation)
{
PaymentTypeCollection paymentTypeCollection = new PaymentTypeCollection();
foreach (POS.DataLayer.PaymentType _paymentType in POS.DataLayer.PaymentTypeBase.SelectByField(field, fieldValue, fieldValue2, typeOperation))
{
_paymentTypeWCF = new PaymentType();
_paymentTypeWCF.PaymentTypeID = _paymentType.PaymentTypeID;
_paymentTypeWCF.PaymentTypeName = _paymentType.PaymentTypeName;
paymentTypeCollection.Add(_paymentTypeWCF);
}
return(paymentTypeCollection);
}
/// <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 INVTakingInventoryLineBatch</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 INVTakingInventoryLineBatch in the form of an object of class INVTakingInventoryLineBatchCollection</returns>
public INVTakingInventoryLineBatchCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement)
{
INVTakingInventoryLineBatchCollection iNVTakingInventoryLineBatchCollection = new INVTakingInventoryLineBatchCollection();
foreach (POS.DataLayer.INVTakingInventoryLineBatch _iNVTakingInventoryLineBatch in POS.DataLayer.INVTakingInventoryLineBatchBase.SelectByFieldPaged(field, fieldValue, fieldValue2, typeOperation, pageSize, skipPages, orderByStatement))
{
_iNVTakingInventoryLineBatchWCF = new INVTakingInventoryLineBatch();
_iNVTakingInventoryLineBatchWCF.TakingLineBatchID = _iNVTakingInventoryLineBatch.TakingLineBatchID;
_iNVTakingInventoryLineBatchWCF.TakingLineID = _iNVTakingInventoryLineBatch.TakingLineID;
_iNVTakingInventoryLineBatchWCF.BatchID = _iNVTakingInventoryLineBatch.BatchID;
iNVTakingInventoryLineBatchCollection.Add(_iNVTakingInventoryLineBatchWCF);
}
return(iNVTakingInventoryLineBatchCollection);
}
/// <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 INVTakingInventoryLineBatch</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 INVTakingInventoryLineBatch in the form of an object of class INVTakingInventoryLineBatchCollection</returns>
public INVTakingInventoryLineBatchCollection SelectByField(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation)
{
INVTakingInventoryLineBatchCollection iNVTakingInventoryLineBatchCollection = new INVTakingInventoryLineBatchCollection();
foreach (POS.DataLayer.INVTakingInventoryLineBatch _iNVTakingInventoryLineBatch in POS.DataLayer.INVTakingInventoryLineBatchBase.SelectByField(field, fieldValue, fieldValue2, typeOperation))
{
_iNVTakingInventoryLineBatchWCF = new INVTakingInventoryLineBatch();
_iNVTakingInventoryLineBatchWCF.TakingLineBatchID = _iNVTakingInventoryLineBatch.TakingLineBatchID;
_iNVTakingInventoryLineBatchWCF.TakingLineID = _iNVTakingInventoryLineBatch.TakingLineID;
_iNVTakingInventoryLineBatchWCF.BatchID = _iNVTakingInventoryLineBatch.BatchID;
iNVTakingInventoryLineBatchCollection.Add(_iNVTakingInventoryLineBatchWCF);
}
return(iNVTakingInventoryLineBatchCollection);
}
/// <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 INVAdjustStockReason</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 INVAdjustStockReason in the form of an object of class INVAdjustStockReasonCollection</returns>
///
/// <remarks>
///
/// <RevisionHistory>
/// Author Date Description
/// DLGenerator 3/7/2015 2:37:09 PM Created function
///
/// </RevisionHistory>
///
/// </remarks>
///
public static INVAdjustStockReasonCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement)
{
DatabaseHelper oDatabaseHelper = new DatabaseHelper();
bool ExecutionState = false;
// Pass the specified field and its value to the stored procedure.
oDatabaseHelper.AddParameter("@Field", field);
oDatabaseHelper.AddParameter("@Value", fieldValue);
oDatabaseHelper.AddParameter("@Value2", fieldValue2);
oDatabaseHelper.AddParameter("@Operation", OperationCollection.Operation[(int)typeOperation]);
oDatabaseHelper.AddParameter("@PageSize", pageSize);
oDatabaseHelper.AddParameter("@SkipPages", skipPages);
oDatabaseHelper.AddParameter("@OrderByStatement", orderByStatement);
// The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure.
oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output);
IDataReader dr = oDatabaseHelper.ExecuteReader("gsp_INVAdjustStockReason_SelectByFieldPaged", ref ExecutionState);
INVAdjustStockReasonCollection INVAdjustStockReasonCollection = PopulateObjectsFromReader(dr);
dr.Close();
oDatabaseHelper.Dispose();
return(INVAdjustStockReasonCollection);
}
/// <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 PaymentType</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 PaymentType in the form of an object of class PaymentTypeCollection</returns>
public PaymentTypeCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement)
{
PaymentTypeCollection paymentTypeCollection = new PaymentTypeCollection();
foreach (POS.DataLayer.PaymentType _paymentType in POS.DataLayer.PaymentTypeBase.SelectByFieldPaged(field, fieldValue, fieldValue2, typeOperation, pageSize, skipPages, orderByStatement))
{
_paymentTypeWCF = new PaymentType();
_paymentTypeWCF.PaymentTypeID = _paymentType.PaymentTypeID;
_paymentTypeWCF.PaymentTypeName = _paymentType.PaymentTypeName;
paymentTypeCollection.Add(_paymentTypeWCF);
}
return paymentTypeCollection;
}
/// <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 BDCustomer</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 BDCustomer in the form of an object of class BDCustomerCollection</returns>
public BDCustomerCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement)
{
BDCustomerCollection bDCustomerCollection = new BDCustomerCollection();
foreach (POS.DataLayer.BDCustomer _bDCustomer in POS.DataLayer.BDCustomerBase.SelectByFieldPaged(field, fieldValue, fieldValue2, typeOperation, pageSize, skipPages, orderByStatement))
{
_bDCustomerWCF = new BDCustomer();
_bDCustomerWCF.CustomerID = _bDCustomer.CustomerID;
_bDCustomerWCF.CustomerName = _bDCustomer.CustomerName;
_bDCustomerWCF.CustomerCode = _bDCustomer.CustomerCode;
_bDCustomerWCF.Address = _bDCustomer.Address;
_bDCustomerWCF.Phone1 = _bDCustomer.Phone1;
_bDCustomerWCF.Phone2 = _bDCustomer.Phone2;
_bDCustomerWCF.Mobile1 = _bDCustomer.Mobile1;
_bDCustomerWCF.Mobile2 = _bDCustomer.Mobile2;
_bDCustomerWCF.Email = _bDCustomer.Email;
_bDCustomerWCF.IsActive = _bDCustomer.IsActive;
_bDCustomerWCF.Debit = _bDCustomer.Debit;
_bDCustomerWCF.Credit = _bDCustomer.Credit;
bDCustomerCollection.Add(_bDCustomerWCF);
}
return bDCustomerCollection;
}
/// <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 BDRefuseReason</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 BDRefuseReason in the form of an object of class BDRefuseReasonCollection</returns>
public BDRefuseReasonCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement)
{
BDRefuseReasonCollection bDRefuseReasonCollection = new BDRefuseReasonCollection();
foreach (POS.DataLayer.BDRefuseReason _bDRefuseReason in POS.DataLayer.BDRefuseReasonBase.SelectByFieldPaged(field, fieldValue, fieldValue2, typeOperation, pageSize, skipPages, orderByStatement))
{
_bDRefuseReasonWCF = new BDRefuseReason();
_bDRefuseReasonWCF.RefuseReasonID = _bDRefuseReason.RefuseReasonID;
_bDRefuseReasonWCF.RefuseReasonName = _bDRefuseReason.RefuseReasonName;
bDRefuseReasonCollection.Add(_bDRefuseReasonWCF);
}
return(bDRefuseReasonCollection);
}
/// <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 ADGroupRole</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 ADGroupRole in the form of an object of class ADGroupRoleCollection</returns>
public ADGroupRoleCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement)
{
ADGroupRoleCollection aDGroupRoleCollection = new ADGroupRoleCollection();
foreach (POS.DataLayer.ADGroupRole _aDGroupRole in POS.DataLayer.ADGroupRoleBase.SelectByFieldPaged(field, fieldValue, fieldValue2, typeOperation, pageSize, skipPages, orderByStatement))
{
_aDGroupRoleWCF = new ADGroupRole();
_aDGroupRoleWCF.GroupRoleID = _aDGroupRole.GroupRoleID;
_aDGroupRoleWCF.GroupID = _aDGroupRole.GroupID;
_aDGroupRoleWCF.RoleID = _aDGroupRole.RoleID;
aDGroupRoleCollection.Add(_aDGroupRoleWCF);
}
return aDGroupRoleCollection;
}
/// <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 PURPurchaseLineBatch</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 PURPurchaseLineBatch in the form of an object of class PURPurchaseLineBatchCollection</returns>
public PURPurchaseLineBatchCollection SelectByField(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation)
{
PURPurchaseLineBatchCollection pURPurchaseLineBatchCollection = new PURPurchaseLineBatchCollection();
foreach (POS.DataLayer.PURPurchaseLineBatch _pURPurchaseLineBatch in POS.DataLayer.PURPurchaseLineBatchBase.SelectByField(field, fieldValue, fieldValue2, typeOperation))
{
_pURPurchaseLineBatchWCF = new PURPurchaseLineBatch();
_pURPurchaseLineBatchWCF.PurchaseLineBatchID = _pURPurchaseLineBatch.PurchaseLineBatchID;
_pURPurchaseLineBatchWCF.PurchaseLineID = _pURPurchaseLineBatch.PurchaseLineID;
_pURPurchaseLineBatchWCF.BatchID = _pURPurchaseLineBatch.BatchID;
_pURPurchaseLineBatchWCF.Qty = _pURPurchaseLineBatch.Qty;
pURPurchaseLineBatchCollection.Add(_pURPurchaseLineBatchWCF);
}
return(pURPurchaseLineBatchCollection);
}
public Operation setUnary()
{
this.type = TypeOperation.OPERATION_UNARY;
return this;
}
/// <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 PURPurchaseLineBatch</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 PURPurchaseLineBatch in the form of an object of class PURPurchaseLineBatchCollection</returns>
public PURPurchaseLineBatchCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement)
{
PURPurchaseLineBatchCollection pURPurchaseLineBatchCollection = new PURPurchaseLineBatchCollection();
foreach (POS.DataLayer.PURPurchaseLineBatch _pURPurchaseLineBatch in POS.DataLayer.PURPurchaseLineBatchBase.SelectByFieldPaged(field, fieldValue, fieldValue2, typeOperation, pageSize, skipPages, orderByStatement))
{
_pURPurchaseLineBatchWCF = new PURPurchaseLineBatch();
_pURPurchaseLineBatchWCF.PurchaseLineBatchID = _pURPurchaseLineBatch.PurchaseLineBatchID;
_pURPurchaseLineBatchWCF.PurchaseLineID = _pURPurchaseLineBatch.PurchaseLineID;
_pURPurchaseLineBatchWCF.BatchID = _pURPurchaseLineBatch.BatchID;
_pURPurchaseLineBatchWCF.Qty = _pURPurchaseLineBatch.Qty;
pURPurchaseLineBatchCollection.Add(_pURPurchaseLineBatchWCF);
}
return(pURPurchaseLineBatchCollection);
}
/// <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 BDSupplier</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 BDSupplier in the form of an object of class BDSupplierCollection</returns>
public BDSupplierCollection SelectByField(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation)
{
BDSupplierCollection bDSupplierCollection = new BDSupplierCollection();
foreach (POS.DataLayer.BDSupplier _bDSupplier in POS.DataLayer.BDSupplierBase.SelectByField(field, fieldValue, fieldValue2, typeOperation))
{
_bDSupplierWCF = new BDSupplier();
_bDSupplierWCF.SupplierID = _bDSupplier.SupplierID;
_bDSupplierWCF.SupplierCode = _bDSupplier.SupplierCode;
_bDSupplierWCF.SupplierName = _bDSupplier.SupplierName;
_bDSupplierWCF.Address = _bDSupplier.Address;
_bDSupplierWCF.Phone1 = _bDSupplier.Phone1;
_bDSupplierWCF.phone2 = _bDSupplier.Phone2;
_bDSupplierWCF.Mobile1 = _bDSupplier.Mobile1;
_bDSupplierWCF.Mobile2 = _bDSupplier.Mobile2;
_bDSupplierWCF.Email = _bDSupplier.Email;
_bDSupplierWCF.IsActive = _bDSupplier.IsActive;
_bDSupplierWCF.Debit = _bDSupplier.Debit;
_bDSupplierWCF.Credit = _bDSupplier.Credit;
bDSupplierCollection.Add(_bDSupplierWCF);
}
return bDSupplierCollection;
}
/// <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 PURPurchaseReturnHeader</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 PURPurchaseReturnHeader in the form of an object of class PURPurchaseReturnHeaderCollection</returns>
public PURPurchaseReturnHeaderCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement)
{
PURPurchaseReturnHeaderCollection pURPurchaseReturnHeaderCollection = new PURPurchaseReturnHeaderCollection();
foreach (POS.DataLayer.PURPurchaseReturnHeader _pURPurchaseReturnHeader in POS.DataLayer.PURPurchaseReturnHeaderBase.SelectByFieldPaged(field, fieldValue, fieldValue2, typeOperation, pageSize, skipPages, orderByStatement))
{
_pURPurchaseReturnHeaderWCF = new PURPurchaseReturnHeader();
_pURPurchaseReturnHeaderWCF.PurchaseReturnID = _pURPurchaseReturnHeader.PurchaseReturnID;
_pURPurchaseReturnHeaderWCF.ReturnDate = _pURPurchaseReturnHeader.ReturnDate;
_pURPurchaseReturnHeaderWCF.OriginalHeaderID = _pURPurchaseReturnHeader.OriginalHeaderID;
_pURPurchaseReturnHeaderWCF.CreatedBy = _pURPurchaseReturnHeader.CreatedBy;
_pURPurchaseReturnHeaderWCF.CreateDate = _pURPurchaseReturnHeader.CreateDate;
_pURPurchaseReturnHeaderWCF.UpdatedBy = _pURPurchaseReturnHeader.UpdatedBy;
_pURPurchaseReturnHeaderWCF.UpdateDate = _pURPurchaseReturnHeader.UpdateDate;
_pURPurchaseReturnHeaderWCF.IsDeleted = _pURPurchaseReturnHeader.IsDeleted;
_pURPurchaseReturnHeaderWCF.DeletedBy = _pURPurchaseReturnHeader.DeletedBy;
_pURPurchaseReturnHeaderWCF.DeleteDate = _pURPurchaseReturnHeader.DeleteDate;
pURPurchaseReturnHeaderCollection.Add(_pURPurchaseReturnHeaderWCF);
}
return(pURPurchaseReturnHeaderCollection);
}
/// <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 BDTaxType</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 BDTaxType in the form of an object of class BDTaxTypeCollection</returns>
public BDTaxTypeCollection SelectByField(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation)
{
BDTaxTypeCollection bDTaxTypeCollection = new BDTaxTypeCollection();
foreach (POS.DataLayer.BDTaxType _bDTaxType in POS.DataLayer.BDTaxTypeBase.SelectByField(field, fieldValue, fieldValue2, typeOperation))
{
_bDTaxTypeWCF = new BDTaxType();
_bDTaxTypeWCF.TaxTypeID = _bDTaxType.TaxTypeID;
_bDTaxTypeWCF.TaxTypeName = _bDTaxType.TaxTypeName;
_bDTaxTypeWCF.TaxValue = _bDTaxType.TaxValue;
bDTaxTypeCollection.Add(_bDTaxTypeWCF);
}
return bDTaxTypeCollection;
}
/// <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 PURPurchaseReturnLine</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 PURPurchaseReturnLine in the form of an object of class PURPurchaseReturnLineCollection</returns>
public PURPurchaseReturnLineCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement)
{
PURPurchaseReturnLineCollection pURPurchaseReturnLineCollection = new PURPurchaseReturnLineCollection();
foreach (POS.DataLayer.PURPurchaseReturnLine _pURPurchaseReturnLine in POS.DataLayer.PURPurchaseReturnLineBase.SelectByFieldPaged(field, fieldValue, fieldValue2, typeOperation, pageSize, skipPages, orderByStatement))
{
_pURPurchaseReturnLineWCF = new PURPurchaseReturnLine();
_pURPurchaseReturnLineWCF.PurchaseReturnLineID = _pURPurchaseReturnLine.PurchaseReturnLineID;
_pURPurchaseReturnLineWCF.Qty = _pURPurchaseReturnLine.Qty;
_pURPurchaseReturnLineWCF.Reason = _pURPurchaseReturnLine.Reason;
_pURPurchaseReturnLineWCF.OriginalpurchaseLineID = _pURPurchaseReturnLine.OriginalpurchaseLineID;
_pURPurchaseReturnLineWCF.BatchID = _pURPurchaseReturnLine.BatchID;
_pURPurchaseReturnLineWCF.BatchNumber = _pURPurchaseReturnLine.BatchNumber;
_pURPurchaseReturnLineWCF.ExpiryDate = _pURPurchaseReturnLine.ExpiryDate;
pURPurchaseReturnLineCollection.Add(_pURPurchaseReturnLineWCF);
}
return(pURPurchaseReturnLineCollection);
}
/// <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 BDSupplierAccount</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 BDSupplierAccount in the form of an object of class BDSupplierAccountCollection</returns>
public BDSupplierAccountCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement)
{
BDSupplierAccountCollection bDSupplierAccountCollection = new BDSupplierAccountCollection();
foreach (POS.DataLayer.BDSupplierAccount _bDSupplierAccount in POS.DataLayer.BDSupplierAccountBase.SelectByFieldPaged(field, fieldValue, fieldValue2, typeOperation, pageSize, skipPages, orderByStatement))
{
_bDSupplierAccountWCF = new BDSupplierAccount();
_bDSupplierAccountWCF.SupplierAccountId = _bDSupplierAccount.SupplierAccountId;
_bDSupplierAccountWCF.PurcaseInvoiceID = _bDSupplierAccount.PurcaseInvoiceID;
_bDSupplierAccountWCF.PurchaseDate = _bDSupplierAccount.PurchaseDate;
_bDSupplierAccountWCF.SupplierID = _bDSupplierAccount.SupplierID;
_bDSupplierAccountWCF.InvoiceNumber = _bDSupplierAccount.InvoiceNumber;
_bDSupplierAccountWCF.TotalPrice = _bDSupplierAccount.TotalPrice;
_bDSupplierAccountWCF.PaidAmount = _bDSupplierAccount.PaidAmount;
_bDSupplierAccountWCF.IsVoid = _bDSupplierAccount.IsVoid;
_bDSupplierAccountWCF.RemainingAmount = _bDSupplierAccount.RemainingAmount;
_bDSupplierAccountWCF.CreateDate = _bDSupplierAccount.CreateDate;
_bDSupplierAccountWCF.CreatedBy = _bDSupplierAccount.CreatedBy;
_bDSupplierAccountWCF.updateDate = _bDSupplierAccount.updateDate;
_bDSupplierAccountWCF.UpdatedBy = _bDSupplierAccount.UpdatedBy;
_bDSupplierAccountWCF.IsDeleted = _bDSupplierAccount.IsDeleted;
_bDSupplierAccountWCF.DeleteDate = _bDSupplierAccount.DeleteDate;
_bDSupplierAccountWCF.DeletedBy = _bDSupplierAccount.DeletedBy;
_bDSupplierAccountWCF.Depit = _bDSupplierAccount.Depit;
_bDSupplierAccountWCF.Credit = _bDSupplierAccount.Credit;
_bDSupplierAccountWCF.LstDayToPay = _bDSupplierAccount.LstDayToPay;
_bDSupplierAccountWCF.ChequeNumber = _bDSupplierAccount.ChequeNumber;
_bDSupplierAccountWCF.InvoiceType = _bDSupplierAccount.InvoiceType;
bDSupplierAccountCollection.Add(_bDSupplierAccountWCF);
}
return bDSupplierAccountCollection;
}
/// <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
/// using the value of the field specified
/// </summary>
///
/// <param name="field" type="string">Field of the class PURPurchaseLine</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 PURPurchaseLine in the form of an object of class PURPurchaseLineCollection</returns>
public PURPurchaseLineCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement)
{
PURPurchaseLineCollection pURPurchaseLineCollection = new PURPurchaseLineCollection();
foreach (POS.DataLayer.PURPurchaseLine _pURPurchaseLine in POS.DataLayer.PURPurchaseLineBase.SelectByFieldPaged(field, fieldValue, fieldValue2, typeOperation, pageSize, skipPages, orderByStatement))
{
_pURPurchaseLineWCF = new PURPurchaseLine();
_pURPurchaseLineWCF.PurchaseLineID = _pURPurchaseLine.PurchaseLineID;
_pURPurchaseLineWCF.PurchaseHeaderID = _pURPurchaseLine.PurchaseHeaderID;
_pURPurchaseLineWCF.ProductID = _pURPurchaseLine.ProductID;
_pURPurchaseLineWCF.TotalQty = _pURPurchaseLine.TotalQty;
_pURPurchaseLineWCF.BonusQty = _pURPurchaseLine.BonusQty;
_pURPurchaseLineWCF.DiscountRatio = _pURPurchaseLine.DiscountRatio;
_pURPurchaseLineWCF.DiscountAmount = _pURPurchaseLine.DiscountAmount;
_pURPurchaseLineWCF.Unitprice = _pURPurchaseLine.Unitprice;
_pURPurchaseLineWCF.CreatedDate = _pURPurchaseLine.CreatedDate;
_pURPurchaseLineWCF.CreatedBy = _pURPurchaseLine.CreatedBy;
_pURPurchaseLineWCF.UpdateDate = _pURPurchaseLine.UpdateDate;
_pURPurchaseLineWCF.UpdatedBy = _pURPurchaseLine.UpdatedBy;
_pURPurchaseLineWCF.IsDeleted = _pURPurchaseLine.IsDeleted;
_pURPurchaseLineWCF.DeleteDate = _pURPurchaseLine.DeleteDate;
_pURPurchaseLineWCF.DeletedBy = _pURPurchaseLine.DeletedBy;
pURPurchaseLineCollection.Add(_pURPurchaseLineWCF);
}
return pURPurchaseLineCollection;
}
/// <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 ADUser</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 ADUser in the form of an object of class ADUserCollection</returns>
public ADUserCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement)
{
ADUserCollection aDUserCollection = new ADUserCollection();
foreach (POS.DataLayer.ADUser _aDUser in POS.DataLayer.ADUserBase.SelectByFieldPaged(field, fieldValue, fieldValue2, typeOperation, pageSize, skipPages, orderByStatement))
{
_aDUserWCF = new ADUser();
_aDUserWCF.UserID = _aDUser.UserID;
_aDUserWCF.UserFullName = _aDUser.UserFullName;
_aDUserWCF.UserName = _aDUser.UserName;
_aDUserWCF.Password = _aDUser.Password;
_aDUserWCF.GroupID = _aDUser.GroupID;
_aDUserWCF.Email = _aDUser.Email;
_aDUserWCF.Address = _aDUser.Address;
_aDUserWCF.Phone = _aDUser.Phone;
_aDUserWCF.Mobile = _aDUser.Mobile;
aDUserCollection.Add(_aDUserWCF);
}
return aDUserCollection;
}
/// <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 INVBatch</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 INVBatch in the form of an object of class INVBatchCollection</returns>
public INVBatchCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement)
{
INVBatchCollection iNVBatchCollection = new INVBatchCollection();
foreach (POS.DataLayer.INVBatch _iNVBatch in POS.DataLayer.INVBatchBase.SelectByFieldPaged(field, fieldValue, fieldValue2, typeOperation, pageSize, skipPages, orderByStatement))
{
_iNVBatchWCF = new INVBatch();
_iNVBatchWCF.BatchID = _iNVBatch.BatchID;
_iNVBatchWCF.BatchNumber = _iNVBatch.BatchNumber;
_iNVBatchWCF.ExpiryDate = _iNVBatch.ExpiryDate;
iNVBatchCollection.Add(_iNVBatchWCF);
}
return iNVBatchCollection;
}
/// <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 SALSalesHeader</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 SALSalesHeader in the form of an object of class SALSalesHeaderCollection</returns>
public SALSalesHeaderCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement)
{
SALSalesHeaderCollection sALSalesHeaderCollection = new SALSalesHeaderCollection();
foreach (POS.DataLayer.SALSalesHeader _sALSalesHeader in POS.DataLayer.SALSalesHeaderBase.SelectByFieldPaged(field, fieldValue, fieldValue2, typeOperation, pageSize, skipPages, orderByStatement))
{
_sALSalesHeaderWCF = new SALSalesHeader();
_sALSalesHeaderWCF.SalesHeaderID = _sALSalesHeader.SalesHeaderID;
_sALSalesHeaderWCF.SalesDate = _sALSalesHeader.SalesDate;
_sALSalesHeaderWCF.CustomerID = _sALSalesHeader.CustomerID;
_sALSalesHeaderWCF.InvoiceNumber = _sALSalesHeader.InvoiceNumber;
_sALSalesHeaderWCF.InvoiceDate = _sALSalesHeader.InvoiceDate;
_sALSalesHeaderWCF.SellerID = _sALSalesHeader.SellerID;
_sALSalesHeaderWCF.PaymentTypeID = _sALSalesHeader.PaymentTypeID;
_sALSalesHeaderWCF.TotalPrice = _sALSalesHeader.TotalPrice;
_sALSalesHeaderWCF.PaidAmount = _sALSalesHeader.PaidAmount;
_sALSalesHeaderWCF.RemainingAmount = _sALSalesHeader.RemainingAmount;
_sALSalesHeaderWCF.LastDayToPay = _sALSalesHeader.LastDayToPay;
_sALSalesHeaderWCF.TotalDiscountAmount = _sALSalesHeader.TotalDiscountAmount;
_sALSalesHeaderWCF.TotalDiscountRatio = _sALSalesHeader.TotalDiscountRatio;
_sALSalesHeaderWCF.IsClosed = _sALSalesHeader.IsClosed;
_sALSalesHeaderWCF.IsVoid = _sALSalesHeader.IsVoid;
_sALSalesHeaderWCF.IsPrinted = _sALSalesHeader.IsPrinted;
_sALSalesHeaderWCF.ServicePrice = _sALSalesHeader.ServicePrice;
_sALSalesHeaderWCF.TaxTypeID = _sALSalesHeader.TaxTypeID;
_sALSalesHeaderWCF.RefuseReasonID = _sALSalesHeader.RefuseReasonID;
_sALSalesHeaderWCF.CreatedBy = _sALSalesHeader.CreatedBy;
_sALSalesHeaderWCF.CreateDate = _sALSalesHeader.CreateDate;
_sALSalesHeaderWCF.UpdatedBy = _sALSalesHeader.UpdatedBy;
_sALSalesHeaderWCF.UpdateDate = _sALSalesHeader.UpdateDate;
_sALSalesHeaderWCF.IsDeleted = _sALSalesHeader.IsDeleted;
_sALSalesHeaderWCF.DeletedBy = _sALSalesHeader.DeletedBy;
_sALSalesHeaderWCF.DeletDate = _sALSalesHeader.DeletDate;
_sALSalesHeaderWCF.InventoryID = _sALSalesHeader.InventoryID;
_sALSalesHeaderWCF.FinalPrice = _sALSalesHeader.FinalPrice;
_sALSalesHeaderWCF.ChequeNumber = _sALSalesHeader.ChequeNumber;
sALSalesHeaderCollection.Add(_sALSalesHeaderWCF);
}
return sALSalesHeaderCollection;
}
/// <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 PaymentType</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 PaymentType in the form of an object of class PaymentTypeCollection</returns>
public PaymentTypeCollection SelectByField(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation)
{
PaymentTypeCollection paymentTypeCollection = new PaymentTypeCollection();
foreach (POS.DataLayer.PaymentType _paymentType in POS.DataLayer.PaymentTypeBase.SelectByField(field, fieldValue, fieldValue2, typeOperation))
{
_paymentTypeWCF = new PaymentType();
_paymentTypeWCF.PaymentTypeID = _paymentType.PaymentTypeID;
_paymentTypeWCF.PaymentTypeName = _paymentType.PaymentTypeName;
paymentTypeCollection.Add(_paymentTypeWCF);
}
return paymentTypeCollection;
}
/// <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 INVAdjustStockReason</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 INVAdjustStockReason in the form of an object of class INVAdjustStockReasonCollection</returns>
public INVAdjustStockReasonCollection SelectByField(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation)
{
INVAdjustStockReasonCollection iNVAdjustStockReasonCollection = new INVAdjustStockReasonCollection();
foreach (POS.DataLayer.INVAdjustStockReason _iNVAdjustStockReason in POS.DataLayer.INVAdjustStockReasonBase.SelectByField(field, fieldValue, fieldValue2, typeOperation))
{
_iNVAdjustStockReasonWCF = new INVAdjustStockReason();
_iNVAdjustStockReasonWCF.AdjustStockReasonID = _iNVAdjustStockReason.AdjustStockReasonID;
_iNVAdjustStockReasonWCF.AdjustStockreasonName = _iNVAdjustStockReason.AdjustStockreasonName;
iNVAdjustStockReasonCollection.Add(_iNVAdjustStockReasonWCF);
}
return iNVAdjustStockReasonCollection;
}
/// <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 INVStockType</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 INVStockType in the form of an object of class INVStockTypeCollection</returns>
public INVStockTypeCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement)
{
INVStockTypeCollection iNVStockTypeCollection = new INVStockTypeCollection();
foreach (POS.DataLayer.INVStockType _iNVStockType in POS.DataLayer.INVStockTypeBase.SelectByFieldPaged(field, fieldValue, fieldValue2, typeOperation, pageSize, skipPages, orderByStatement))
{
_iNVStockTypeWCF = new INVStockType();
_iNVStockTypeWCF.StockTypeID = _iNVStockType.StockTypeID;
_iNVStockTypeWCF.StockTypeName = _iNVStockType.StockTypeName;
iNVStockTypeCollection.Add(_iNVStockTypeWCF);
}
return iNVStockTypeCollection;
}
/// <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 BDRefuseReason</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 BDRefuseReason in the form of an object of class BDRefuseReasonCollection</returns>
public BDRefuseReasonCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement)
{
BDRefuseReasonCollection bDRefuseReasonCollection = new BDRefuseReasonCollection();
foreach (POS.DataLayer.BDRefuseReason _bDRefuseReason in POS.DataLayer.BDRefuseReasonBase.SelectByFieldPaged(field, fieldValue, fieldValue2, typeOperation, pageSize, skipPages, orderByStatement))
{
_bDRefuseReasonWCF = new BDRefuseReason();
_bDRefuseReasonWCF.RefuseReasonID = _bDRefuseReason.RefuseReasonID;
_bDRefuseReasonWCF.RefuseReasonName = _bDRefuseReason.RefuseReasonName;
bDRefuseReasonCollection.Add(_bDRefuseReasonWCF);
}
return bDRefuseReasonCollection;
}
/// <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 ADGroupRole</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 ADGroupRole in the form of an object of class ADGroupRoleCollection</returns>
public ADGroupRoleCollection SelectByField(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation)
{
ADGroupRoleCollection aDGroupRoleCollection = new ADGroupRoleCollection();
foreach (POS.DataLayer.ADGroupRole _aDGroupRole in POS.DataLayer.ADGroupRoleBase.SelectByField(field, fieldValue, fieldValue2, typeOperation))
{
_aDGroupRoleWCF = new ADGroupRole();
_aDGroupRoleWCF.GroupRoleID = _aDGroupRole.GroupRoleID;
_aDGroupRoleWCF.GroupID = _aDGroupRole.GroupID;
_aDGroupRoleWCF.RoleID = _aDGroupRole.RoleID;
aDGroupRoleCollection.Add(_aDGroupRoleWCF);
}
return aDGroupRoleCollection;
}
/// <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 BDRefuseReason</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 BDRefuseReason in the form of an object of class BDRefuseReasonCollection</returns>
public BDRefuseReasonCollection SelectByField(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation)
{
BDRefuseReasonCollection bDRefuseReasonCollection = new BDRefuseReasonCollection();
foreach (POS.DataLayer.BDRefuseReason _bDRefuseReason in POS.DataLayer.BDRefuseReasonBase.SelectByField(field, fieldValue, fieldValue2, typeOperation))
{
_bDRefuseReasonWCF = new BDRefuseReason();
_bDRefuseReasonWCF.RefuseReasonID = _bDRefuseReason.RefuseReasonID;
_bDRefuseReasonWCF.RefuseReasonName = _bDRefuseReason.RefuseReasonName;
bDRefuseReasonCollection.Add(_bDRefuseReasonWCF);
}
return bDRefuseReasonCollection;
}
/// <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 VPurchaseReturnHeader</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 VPurchaseReturnHeader in the form of an object of class VPurchaseReturnHeaderCollection</returns>
public VPurchaseReturnHeaderCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement)
{
VPurchaseReturnHeaderCollection vPurchaseReturnHeaderCollection = new VPurchaseReturnHeaderCollection();
foreach (POS.DataLayer.VPurchaseReturnHeader _vPurchaseReturnHeader in POS.DataLayer.VPurchaseReturnHeaderBase.SelectByFieldPaged(field, fieldValue, fieldValue2, typeOperation, pageSize, skipPages, orderByStatement))
{
_vPurchaseReturnHeaderWCF = new VPurchaseReturnHeader();
_vPurchaseReturnHeaderWCF.PurchaseReturnID = _vPurchaseReturnHeader.PurchaseReturnID;
_vPurchaseReturnHeaderWCF.ReturnDate = _vPurchaseReturnHeader.ReturnDate;
_vPurchaseReturnHeaderWCF.IsClosed = _vPurchaseReturnHeader.IsClosed;
_vPurchaseReturnHeaderWCF.InvoiceNumber = _vPurchaseReturnHeader.InvoiceNumber;
_vPurchaseReturnHeaderWCF.SupplierName = _vPurchaseReturnHeader.SupplierName;
_vPurchaseReturnHeaderWCF.PurcaseHeaderID = _vPurchaseReturnHeader.PurcaseHeaderID;
vPurchaseReturnHeaderCollection.Add(_vPurchaseReturnHeaderWCF);
}
return vPurchaseReturnHeaderCollection;
}
/// <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 PURPurchaseReturnLine</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 PURPurchaseReturnLine in the form of an object of class PURPurchaseReturnLineCollection</returns>
public PURPurchaseReturnLineCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement)
{
PURPurchaseReturnLineCollection pURPurchaseReturnLineCollection = new PURPurchaseReturnLineCollection();
foreach (POS.DataLayer.PURPurchaseReturnLine _pURPurchaseReturnLine in POS.DataLayer.PURPurchaseReturnLineBase.SelectByFieldPaged(field, fieldValue, fieldValue2, typeOperation, pageSize, skipPages, orderByStatement))
{
_pURPurchaseReturnLineWCF = new PURPurchaseReturnLine();
_pURPurchaseReturnLineWCF.PurchaseReturnLineID = _pURPurchaseReturnLine.PurchaseReturnLineID;
_pURPurchaseReturnLineWCF.Qty = _pURPurchaseReturnLine.Qty;
_pURPurchaseReturnLineWCF.Reason = _pURPurchaseReturnLine.Reason;
_pURPurchaseReturnLineWCF.OriginalpurchaseLineID = _pURPurchaseReturnLine.OriginalpurchaseLineID;
_pURPurchaseReturnLineWCF.BatchID = _pURPurchaseReturnLine.BatchID;
_pURPurchaseReturnLineWCF.BatchNumber = _pURPurchaseReturnLine.BatchNumber;
_pURPurchaseReturnLineWCF.ExpiryDate = _pURPurchaseReturnLine.ExpiryDate;
_pURPurchaseReturnLineWCF.PurchaseReturnHeaderID = _pURPurchaseReturnLine.PurchaseReturnHeaderID;
pURPurchaseReturnLineCollection.Add(_pURPurchaseReturnLineWCF);
}
return pURPurchaseReturnLineCollection;
}
/// <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 SALSalesReturnHeader</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 SALSalesReturnHeader in the form of an object of class SALSalesReturnHeaderCollection</returns>
public SALSalesReturnHeaderCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement)
{
SALSalesReturnHeaderCollection sALSalesReturnHeaderCollection = new SALSalesReturnHeaderCollection();
foreach (POS.DataLayer.SALSalesReturnHeader _sALSalesReturnHeader in POS.DataLayer.SALSalesReturnHeaderBase.SelectByFieldPaged(field, fieldValue, fieldValue2, typeOperation, pageSize, skipPages, orderByStatement))
{
_sALSalesReturnHeaderWCF = new SALSalesReturnHeader();
_sALSalesReturnHeaderWCF.SlaesReturnHeaderID = _sALSalesReturnHeader.SlaesReturnHeaderID;
_sALSalesReturnHeaderWCF.ReturnDate = _sALSalesReturnHeader.ReturnDate;
_sALSalesReturnHeaderWCF.OriginalSalesHeadeID = _sALSalesReturnHeader.OriginalSalesHeadeID;
_sALSalesReturnHeaderWCF.CreatedBy = _sALSalesReturnHeader.CreatedBy;
_sALSalesReturnHeaderWCF.CreateDate = _sALSalesReturnHeader.CreateDate;
_sALSalesReturnHeaderWCF.UpdatedBy = _sALSalesReturnHeader.UpdatedBy;
_sALSalesReturnHeaderWCF.UpdateDate = _sALSalesReturnHeader.UpdateDate;
_sALSalesReturnHeaderWCF.IsDeleted = _sALSalesReturnHeader.IsDeleted;
_sALSalesReturnHeaderWCF.DeletedBy = _sALSalesReturnHeader.DeletedBy;
_sALSalesReturnHeaderWCF.DeleteDate = _sALSalesReturnHeader.DeleteDate;
_sALSalesReturnHeaderWCF.IsClosed = _sALSalesReturnHeader.IsClosed;
_sALSalesReturnHeaderWCF.IsVoid = _sALSalesReturnHeader.IsVoid;
_sALSalesReturnHeaderWCF.InventoryID = _sALSalesReturnHeader.InventoryID;
_sALSalesReturnHeaderWCF.ReturnMoney = _sALSalesReturnHeader.ReturnMoney;
sALSalesReturnHeaderCollection.Add(_sALSalesReturnHeaderWCF);
}
return sALSalesReturnHeaderCollection;
}
/// <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 SALSalesReturnLine</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 SALSalesReturnLine in the form of an object of class SALSalesReturnLineCollection</returns>
public SALSalesReturnLineCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement)
{
SALSalesReturnLineCollection sALSalesReturnLineCollection = new SALSalesReturnLineCollection();
foreach (POS.DataLayer.SALSalesReturnLine _sALSalesReturnLine in POS.DataLayer.SALSalesReturnLineBase.SelectByFieldPaged(field, fieldValue, fieldValue2, typeOperation, pageSize, skipPages, orderByStatement))
{
_sALSalesReturnLineWCF = new SALSalesReturnLine();
_sALSalesReturnLineWCF.SalesReturnLineID = _sALSalesReturnLine.SalesReturnLineID;
_sALSalesReturnLineWCF.Qty = _sALSalesReturnLine.Qty;
_sALSalesReturnLineWCF.Reason = _sALSalesReturnLine.Reason;
_sALSalesReturnLineWCF.OriginalSalesLineID = _sALSalesReturnLine.OriginalSalesLineID;
_sALSalesReturnLineWCF.BatchID = _sALSalesReturnLine.BatchID;
_sALSalesReturnLineWCF.BatchNumber = _sALSalesReturnLine.BatchNumber;
_sALSalesReturnLineWCF.ExpiryDate = _sALSalesReturnLine.ExpiryDate;
_sALSalesReturnLineWCF.SalesReturnHeaderID = _sALSalesReturnLine.SalesReturnHeaderID;
sALSalesReturnLineCollection.Add(_sALSalesReturnLineWCF);
}
return sALSalesReturnLineCollection;
}
/// <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 ADUser</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 ADUser in the form of an object of class ADUserCollection</returns>
///
/// <remarks>
///
/// <RevisionHistory>
/// Author Date Description
/// DLGenerator 3/7/2015 2:37:27 PM Created function
///
/// </RevisionHistory>
///
/// </remarks>
///
public static ADUserCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement)
{
DatabaseHelper oDatabaseHelper = new DatabaseHelper();
bool ExecutionState = false;
// Pass the specified field and its value to the stored procedure.
oDatabaseHelper.AddParameter("@Field",field);
oDatabaseHelper.AddParameter("@Value", fieldValue );
oDatabaseHelper.AddParameter("@Value2", fieldValue2 );
oDatabaseHelper.AddParameter("@Operation", OperationCollection.Operation[(int)typeOperation] );
oDatabaseHelper.AddParameter("@PageSize",pageSize);
oDatabaseHelper.AddParameter("@SkipPages", skipPages );
oDatabaseHelper.AddParameter("@OrderByStatement", orderByStatement );
// The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure.
oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output);
IDataReader dr=oDatabaseHelper.ExecuteReader("gsp_ADUser_SelectByFieldPaged", ref ExecutionState);
ADUserCollection ADUserCollection = PopulateObjectsFromReader(dr);
dr.Close();
oDatabaseHelper.Dispose();
return ADUserCollection;
}
public DlgLogin(TypeOperation p_operation = TypeOperation.Login)
{
InitializeComponent();
operation = p_operation;
InitialiserLesChamps();
}
