/// <summary> /// This method will return a list of objects representing all records in the table. /// </summary> /// /// <returns>list of objects of class SALSalesLine in the form of object of SALSalesLineCollection </returns> public SALSalesLineCollection SelectAll() { SALSalesLineCollection sALSalesLineCollection = new SALSalesLineCollection(); foreach (POS.DataLayer.SALSalesLine _sALSalesLine in POS.DataLayer.SALSalesLineBase.SelectAll()) { _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 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 return a list of objects representing the specified number of entries from the specified record number in the table. /// </summary> /// /// <param name="pageSize" type="int">Number of records returned.</param> /// <param name="skipPages" type="int">The number of missing pages.</param> /// <param name="orderByStatement" type="string">The field value to number.</param> /// /// <returns>list of objects of class SALSalesLine in the form of an object of class SALSalesLineCollection </returns> public SALSalesLineCollection SelectAllPaged(int?pageSize, int?skipPages, string orderByStatement) { SALSalesLineCollection sALSalesLineCollection = new SALSalesLineCollection(); foreach (POS.DataLayer.SALSalesLine _sALSalesLine in POS.DataLayer.SALSalesLineBase.SelectAllPaged(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> /// Populates the fields for multiple objects from the columns found in an open reader. /// </summary> /// /// <param name="rdr" type="IDataReader">An object that implements the IDataReader interface</param> /// /// <returns>Object of SALSalesLineCollection</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 3/7/2015 2:37:16 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// internal static SALSalesLineCollection PopulateObjectsFromReaderWithCheckingReader(IDataReader rdr, DatabaseHelper oDatabaseHelper) { SALSalesLineCollection list = new SALSalesLineCollection(); if (rdr.Read()) { SALSalesLine obj = new SALSalesLine(); PopulateObjectFromReader(obj, rdr); list.Add(obj); while (rdr.Read()) { obj = new SALSalesLine(); PopulateObjectFromReader(obj, rdr); list.Add(obj); } oDatabaseHelper.Dispose(); return list; } else { oDatabaseHelper.Dispose(); return null; } }
/// <summary> /// Populates the fields for multiple objects from the columns found in an open reader. /// </summary> /// /// <param name="rdr" type="IDataReader">An object that implements the IDataReader interface</param> /// /// <returns>Object of SALSalesLineCollection</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 3/7/2015 2:37:16 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// internal static SALSalesLineCollection PopulateObjectsFromReader(IDataReader rdr) { SALSalesLineCollection list = new SALSalesLineCollection(); while (rdr.Read()) { SALSalesLine obj = new SALSalesLine(); PopulateObjectFromReader(obj,rdr); list.Add(obj); } return list; }
/// <summary> /// This method will return a list of objects representing all records in the table. /// </summary> /// /// <returns>list of objects of class SALSalesLine in the form of object of SALSalesLineCollection </returns> public SALSalesLineCollection SelectAll() { SALSalesLineCollection sALSalesLineCollection = new SALSalesLineCollection(); foreach (POS.DataLayer.SALSalesLine _sALSalesLine in POS.DataLayer.SALSalesLineBase.SelectAll()) { _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 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 return a list of objects representing the specified number of entries from the specified record number in the table. /// </summary> /// /// <param name="pageSize" type="int">Number of records returned.</param> /// <param name="skipPages" type="int">The number of missing pages.</param> /// <param name="orderByStatement" type="string">The field value to number.</param> /// /// <returns>list of objects of class SALSalesLine in the form of an object of class SALSalesLineCollection </returns> public SALSalesLineCollection SelectAllPaged(int? pageSize, int? skipPages, string orderByStatement) { SALSalesLineCollection sALSalesLineCollection = new SALSalesLineCollection(); foreach (POS.DataLayer.SALSalesLine _sALSalesLine in POS.DataLayer.SALSalesLineBase.SelectAllPaged(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; }