/// <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 BDProduct</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 BDProduct in the form of an object of class BDProductCollection</returns> public BDProductCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement) { BDProductCollection bDProductCollection = new BDProductCollection(); foreach (POS.DataLayer.BDProduct _bDProduct in POS.DataLayer.BDProductBase.SelectByFieldPaged(field, fieldValue, fieldValue2, typeOperation, pageSize, skipPages, orderByStatement)) { _bDProductWCF = new BDProduct(); _bDProductWCF.ProductID = _bDProduct.ProductID; _bDProductWCF.ProductName = _bDProduct.ProductName; _bDProductWCF.ProductGroupID = _bDProduct.ProductGroupID; _bDProductWCF.ProductCode = _bDProduct.ProductCode; _bDProductWCF.IsAcceptBatch = _bDProduct.IsAcceptBatch; _bDProductWCF.ProductPrice = _bDProduct.ProductPrice; _bDProductWCF.IsFixedPrice = _bDProduct.IsFixedPrice; _bDProductWCF.HasDiscount = _bDProduct.HasDiscount; _bDProductWCF.DiscountAmount = _bDProduct.DiscountAmount; _bDProductWCF.DescountRatio = _bDProduct.DescountRatio; _bDProductWCF.IsActive = _bDProduct.IsActive; _bDProductWCF.Notes = _bDProduct.Notes; _bDProductWCF.MinPrice = _bDProduct.MinPrice; _bDProductWCF.MaxPrice = _bDProduct.MaxPrice; bDProductCollection.Add(_bDProductWCF); } return(bDProductCollection); }
/// <summary> /// This method will return a list of objects representing all records in the table. /// </summary> /// /// <returns>list of objects of class BDProduct in the form of object of BDProductCollection </returns> public BDProductCollection SelectAll() { BDProductCollection bDProductCollection = new BDProductCollection(); foreach (POS.DataLayer.BDProduct _bDProduct in POS.DataLayer.BDProductBase.SelectAll()) { _bDProductWCF = new BDProduct(); _bDProductWCF.ProductID = _bDProduct.ProductID; _bDProductWCF.ProductName = _bDProduct.ProductName; _bDProductWCF.ProductGroupID = _bDProduct.ProductGroupID; _bDProductWCF.ProductCode = _bDProduct.ProductCode; _bDProductWCF.IsAcceptBatch = _bDProduct.IsAcceptBatch; _bDProductWCF.ProductPrice = _bDProduct.ProductPrice; _bDProductWCF.IsFixedPrice = _bDProduct.IsFixedPrice; _bDProductWCF.HasDiscount = _bDProduct.HasDiscount; _bDProductWCF.DiscountAmount = _bDProduct.DiscountAmount; _bDProductWCF.DescountRatio = _bDProduct.DescountRatio; _bDProductWCF.IsActive = _bDProduct.IsActive; _bDProductWCF.Notes = _bDProduct.Notes; _bDProductWCF.MinPrice = _bDProduct.MinPrice; _bDProductWCF.MaxPrice = _bDProduct.MaxPrice; bDProductCollection.Add(_bDProductWCF); } return(bDProductCollection); }
public BDProductCollection SelectAllProductsByGroupID(int InventoryID, BDProductGroupPrimaryKey pk) { BDProductCollection bDProductCollection = new BDProductCollection(); var result = POS.DataLayer.BDProduct.SelectAllProductsByGroupID(InventoryID, new POS.DataLayer.BDProductGroupPrimaryKey(pk.ProductGroupID)); if (result != null) { foreach (POS.DataLayer.BDProduct _bDProduct in result) { _bDProductWCF = new BDProduct(); _bDProductWCF.ProductID = _bDProduct.ProductID; _bDProductWCF.ProductName = _bDProduct.ProductName; _bDProductWCF.ProductGroupID = _bDProduct.ProductGroupID; _bDProductWCF.ProductCode = _bDProduct.ProductCode; _bDProductWCF.IsAcceptBatch = _bDProduct.IsAcceptBatch; _bDProductWCF.ProductPrice = _bDProduct.ProductPrice; _bDProductWCF.IsFixedPrice = _bDProduct.IsFixedPrice; _bDProductWCF.HasDiscount = _bDProduct.HasDiscount; _bDProductWCF.DiscountAmount = _bDProduct.DiscountAmount; _bDProductWCF.DescountRatio = _bDProduct.DescountRatio; _bDProductWCF.IsActive = _bDProduct.IsActive; _bDProductWCF.Notes = _bDProduct.Notes; _bDProductWCF.MinPrice = _bDProduct.MinPrice; _bDProductWCF.MaxPrice = _bDProduct.MaxPrice; _bDProductWCF.TotalQty = _bDProduct.TotalQty; bDProductCollection.Add(_bDProductWCF); } } return(bDProductCollection); }
/// <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 BDProduct in the form of an object of class BDProductCollection </returns> public BDProductCollection SelectAllPaged(int?pageSize, int?skipPages, string orderByStatement) { BDProductCollection bDProductCollection = new BDProductCollection(); foreach (POS.DataLayer.BDProduct _bDProduct in POS.DataLayer.BDProductBase.SelectAllPaged(pageSize, skipPages, orderByStatement)) { _bDProductWCF = new BDProduct(); _bDProductWCF.ProductID = _bDProduct.ProductID; _bDProductWCF.ProductName = _bDProduct.ProductName; _bDProductWCF.ProductGroupID = _bDProduct.ProductGroupID; _bDProductWCF.ProductCode = _bDProduct.ProductCode; _bDProductWCF.IsAcceptBatch = _bDProduct.IsAcceptBatch; _bDProductWCF.ProductPrice = _bDProduct.ProductPrice; _bDProductWCF.IsFixedPrice = _bDProduct.IsFixedPrice; _bDProductWCF.HasDiscount = _bDProduct.HasDiscount; _bDProductWCF.DiscountAmount = _bDProduct.DiscountAmount; _bDProductWCF.DescountRatio = _bDProduct.DescountRatio; _bDProductWCF.IsActive = _bDProduct.IsActive; _bDProductWCF.Notes = _bDProduct.Notes; _bDProductWCF.MinPrice = _bDProduct.MinPrice; _bDProductWCF.MaxPrice = _bDProduct.MaxPrice; bDProductCollection.Add(_bDProductWCF); } return(bDProductCollection); }
/// <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 BDProduct</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 BDProduct in the form of an object of class BDProductCollection</returns> public BDProductCollection SelectByField(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation) { BDProductCollection bDProductCollection = new BDProductCollection(); foreach (POS.DataLayer.BDProduct _bDProduct in POS.DataLayer.BDProductBase.SelectByField(field, fieldValue, fieldValue2, typeOperation)) { _bDProductWCF = new BDProduct(); _bDProductWCF.ProductID = _bDProduct.ProductID; _bDProductWCF.ProductName = _bDProduct.ProductName; _bDProductWCF.ProductGroupID = _bDProduct.ProductGroupID; _bDProductWCF.ProductCode = _bDProduct.ProductCode; _bDProductWCF.IsAcceptBatch = _bDProduct.IsAcceptBatch; _bDProductWCF.ProductPrice = _bDProduct.ProductPrice; _bDProductWCF.IsFixedPrice = _bDProduct.IsFixedPrice; _bDProductWCF.HasDiscount = _bDProduct.HasDiscount; _bDProductWCF.DiscountAmount = _bDProduct.DiscountAmount; _bDProductWCF.DescountRatio = _bDProduct.DescountRatio; _bDProductWCF.IsActive = _bDProduct.IsActive; _bDProductWCF.Notes = _bDProduct.Notes; bDProductCollection.Add(_bDProductWCF); } return(bDProductCollection); }
public BDProductCollection SelectAllProductsByGroupID(int InventoryID, BDProductGroupPrimaryKey pk) { BDProductCollection bDProductCollection = new BDProductCollection(); var result = POS.DataLayer.BDProduct.SelectAllProductsByGroupID(InventoryID, new POS.DataLayer.BDProductGroupPrimaryKey(pk.ProductGroupID)); if (result != null) { foreach (POS.DataLayer.BDProduct _bDProduct in result) { _bDProductWCF = new BDProduct(); _bDProductWCF.ProductID = _bDProduct.ProductID; _bDProductWCF.ProductName = _bDProduct.ProductName; _bDProductWCF.ProductGroupID = _bDProduct.ProductGroupID; _bDProductWCF.ProductCode = _bDProduct.ProductCode; _bDProductWCF.IsAcceptBatch = _bDProduct.IsAcceptBatch; _bDProductWCF.ProductPrice = _bDProduct.ProductPrice; _bDProductWCF.IsFixedPrice = _bDProduct.IsFixedPrice; _bDProductWCF.HasDiscount = _bDProduct.HasDiscount; _bDProductWCF.DiscountAmount = _bDProduct.DiscountAmount; _bDProductWCF.DescountRatio = _bDProduct.DescountRatio; _bDProductWCF.IsActive = _bDProduct.IsActive; _bDProductWCF.Notes = _bDProduct.Notes; _bDProductWCF.MinPrice = _bDProduct.MinPrice; _bDProductWCF.MaxPrice = _bDProduct.MaxPrice; _bDProductWCF.TotalQty = _bDProduct.TotalQty; bDProductCollection.Add(_bDProductWCF); } } return bDProductCollection; }
/// <summary> /// This method will return a list of objects representing all records in the table. /// </summary> /// /// <returns>list of objects of class BDProduct in the form of object of BDProductCollection </returns> public BDProductCollection SelectAll() { BDProductCollection bDProductCollection = new BDProductCollection(); foreach (POS.DataLayer.BDProduct _bDProduct in POS.DataLayer.BDProductBase.SelectAll()) { _bDProductWCF = new BDProduct(); _bDProductWCF.ProductID = _bDProduct.ProductID; _bDProductWCF.ProductName = _bDProduct.ProductName; _bDProductWCF.ProductGroupID = _bDProduct.ProductGroupID; _bDProductWCF.ProductCode = _bDProduct.ProductCode; _bDProductWCF.IsAcceptBatch = _bDProduct.IsAcceptBatch; _bDProductWCF.ProductPrice = _bDProduct.ProductPrice; _bDProductWCF.IsFixedPrice = _bDProduct.IsFixedPrice; _bDProductWCF.HasDiscount = _bDProduct.HasDiscount; _bDProductWCF.DiscountAmount = _bDProduct.DiscountAmount; _bDProductWCF.DescountRatio = _bDProduct.DescountRatio; _bDProductWCF.IsActive = _bDProduct.IsActive; _bDProductWCF.Notes = _bDProduct.Notes; _bDProductWCF.MinPrice = _bDProduct.MinPrice; _bDProductWCF.MaxPrice = _bDProduct.MaxPrice; bDProductCollection.Add(_bDProductWCF); } return bDProductCollection; }
public BDProductCollection GetAllProductsForOpenningQuantities(int InventoryID) { BDProductCollection bDProductCollection = new BDProductCollection(); var result = POS.DataLayer.BDProduct.GetAllProductsForOpenningQuantities(InventoryID); if (result != null) { foreach (POS.DataLayer.BDProduct _bDProduct in result) { _bDProductWCF = new BDProduct(); _bDProductWCF.ProductID = _bDProduct.ProductID; _bDProductWCF.ProductName = _bDProduct.ProductName; _bDProductWCF.ProductCode = _bDProduct.ProductCode; _bDProductWCF.IsAcceptBatch = _bDProduct.IsAcceptBatch; bDProductCollection.Add(_bDProductWCF); } } return(bDProductCollection); }
public BDProductCollection GetAllProductsForOpenningQuantities(int InventoryID) { BDProductCollection bDProductCollection = new BDProductCollection(); var result = POS.DataLayer.BDProduct.GetAllProductsForOpenningQuantities(InventoryID); if (result != null) { foreach (POS.DataLayer.BDProduct _bDProduct in result) { _bDProductWCF = new BDProduct(); _bDProductWCF.ProductID = _bDProduct.ProductID; _bDProductWCF.ProductName = _bDProduct.ProductName; _bDProductWCF.ProductCode = _bDProduct.ProductCode; _bDProductWCF.IsAcceptBatch = _bDProduct.IsAcceptBatch; bDProductCollection.Add(_bDProductWCF); } } return bDProductCollection; }
public static BDProductCollection SelectAllProductsByGroupID(int InventoryID, BDProductGroupPrimaryKey pk) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(); bool ExecutionState = false; BDProductCollection obj = null; oDatabaseHelper.AddParameter("@ProductGroupID", pk.ProductGroupID); oDatabaseHelper.AddParameter("@InventoryID", InventoryID); oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); IDataReader dr = oDatabaseHelper.ExecuteReader("usp_SelectAllByGroupID", ref ExecutionState); obj = new BDProductCollection(); obj = PopulateObjectsFromReaderWithCheckingReader(dr, oDatabaseHelper); dr.Close(); oDatabaseHelper.Dispose(); return obj; }
/// <summary> /// This method will get row(s) from the database using the value of the field specified /// along with the details of the child table. /// </summary> /// /// <param name="pk" type="BDProductGroupPrimaryKey">Primary Key information based on which data is to be fetched.</param> /// <param name="pageSize" type="int">Number of records returned.</param> /// <param name="skipPages" type="int">The number of missing pages.</param> /// <param name="orderByStatement" type="string">The field value to number.</param> /// /// <returns>object of class BDProductCollection</returns> public BDProductCollection SelectAllByForeignKeyProductGroupIDPaged(BDProductGroupPrimaryKey pk, int pageSize, int skipPages, string orderByStatement) { BDProductCollection bDProductCollection = new BDProductCollection(); foreach (POS.DataLayer.BDProduct _bDProduct in POS.DataLayer.BDProductBase.SelectAllByForeignKeyProductGroupIDPaged(new POS.DataLayer.BDProductGroupPrimaryKey(pk.ProductGroupID), pageSize, skipPages, orderByStatement)) { _bDProductWCF = new BDProduct(); _bDProductWCF.ProductID = _bDProduct.ProductID; _bDProductWCF.ProductName = _bDProduct.ProductName; _bDProductWCF.ProductGroupID = _bDProduct.ProductGroupID; _bDProductWCF.ProductCode = _bDProduct.ProductCode; _bDProductWCF.IsAcceptBatch = _bDProduct.IsAcceptBatch; _bDProductWCF.ProductPrice = _bDProduct.ProductPrice; _bDProductWCF.IsFixedPrice = _bDProduct.IsFixedPrice; _bDProductWCF.HasDiscount = _bDProduct.HasDiscount; _bDProductWCF.DiscountAmount = _bDProduct.DiscountAmount; _bDProductWCF.DescountRatio = _bDProduct.DescountRatio; _bDProductWCF.IsActive = _bDProduct.IsActive; _bDProductWCF.Notes = _bDProduct.Notes; bDProductCollection.Add(_bDProductWCF); } return(bDProductCollection); }
/// <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 BDProductCollection</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 3/7/2015 2:37:24 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// internal static BDProductCollection PopulateObjectsFromReaderWithCheckingReader(IDataReader rdr, DatabaseHelper oDatabaseHelper) { BDProductCollection list = new BDProductCollection(); if (rdr.Read()) { BDProduct obj = new BDProduct(); PopulateObjectFromReader(obj, rdr); list.Add(obj); while (rdr.Read()) { obj = new BDProduct(); 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 BDProductCollection</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 3/7/2015 2:37:24 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// internal static BDProductCollection PopulateObjectsFromReader(IDataReader rdr) { BDProductCollection list = new BDProductCollection(); while (rdr.Read()) { BDProduct obj = new BDProduct(); PopulateObjectFromReader(obj,rdr); list.Add(obj); } return list; }
/// <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 BDProduct</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 BDProduct in the form of an object of class BDProductCollection</returns> public BDProductCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement) { BDProductCollection bDProductCollection = new BDProductCollection(); foreach (POS.DataLayer.BDProduct _bDProduct in POS.DataLayer.BDProductBase.SelectByFieldPaged(field, fieldValue, fieldValue2, typeOperation, pageSize, skipPages, orderByStatement)) { _bDProductWCF = new BDProduct(); _bDProductWCF.ProductID = _bDProduct.ProductID; _bDProductWCF.ProductName = _bDProduct.ProductName; _bDProductWCF.ProductGroupID = _bDProduct.ProductGroupID; _bDProductWCF.ProductCode = _bDProduct.ProductCode; _bDProductWCF.IsAcceptBatch = _bDProduct.IsAcceptBatch; _bDProductWCF.ProductPrice = _bDProduct.ProductPrice; _bDProductWCF.IsFixedPrice = _bDProduct.IsFixedPrice; _bDProductWCF.HasDiscount = _bDProduct.HasDiscount; _bDProductWCF.DiscountAmount = _bDProduct.DiscountAmount; _bDProductWCF.DescountRatio = _bDProduct.DescountRatio; _bDProductWCF.IsActive = _bDProduct.IsActive; _bDProductWCF.Notes = _bDProduct.Notes; _bDProductWCF.MinPrice = _bDProduct.MinPrice; _bDProductWCF.MaxPrice = _bDProduct.MaxPrice; bDProductCollection.Add(_bDProductWCF); } return bDProductCollection; }
/// <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 BDProduct in the form of an object of class BDProductCollection </returns> public BDProductCollection SelectAllPaged(int? pageSize, int? skipPages, string orderByStatement) { BDProductCollection bDProductCollection = new BDProductCollection(); foreach (POS.DataLayer.BDProduct _bDProduct in POS.DataLayer.BDProductBase.SelectAllPaged(pageSize, skipPages, orderByStatement)) { _bDProductWCF = new BDProduct(); _bDProductWCF.ProductID = _bDProduct.ProductID; _bDProductWCF.ProductName = _bDProduct.ProductName; _bDProductWCF.ProductGroupID = _bDProduct.ProductGroupID; _bDProductWCF.ProductCode = _bDProduct.ProductCode; _bDProductWCF.IsAcceptBatch = _bDProduct.IsAcceptBatch; _bDProductWCF.ProductPrice = _bDProduct.ProductPrice; _bDProductWCF.IsFixedPrice = _bDProduct.IsFixedPrice; _bDProductWCF.HasDiscount = _bDProduct.HasDiscount; _bDProductWCF.DiscountAmount = _bDProduct.DiscountAmount; _bDProductWCF.DescountRatio = _bDProduct.DescountRatio; _bDProductWCF.IsActive = _bDProduct.IsActive; _bDProductWCF.Notes = _bDProduct.Notes; _bDProductWCF.MinPrice = _bDProduct.MinPrice; _bDProductWCF.MaxPrice = _bDProduct.MaxPrice; bDProductCollection.Add(_bDProductWCF); } return bDProductCollection; }