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