Beispiel #1
0
 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;
 }
Beispiel #2
0
        private void dgrd_OrderLines_CellValueChanged(object sender, DataGridViewCellEventArgs e)
        {
            if (e.RowIndex != -1 && e.ColumnIndex == dgrd_OrderLines.Columns["ProductName"].Index)
            {
                BDProductPrimaryKey pk = new BDProductPrimaryKey();
                pk.ProductID = Convert.ToInt32(dgrd_OrderLines.Rows[e.RowIndex].Cells["ProductName"].Value);
                BDProduct _product = _productWrapper.SelectOne(pk);
                dgrd_OrderLines.Rows[e.RowIndex].Cells["IsAcceptBatch"].Value = _product.IsAcceptBatch;

                if (_product.IsAcceptBatch == true)
                {
                    dgrd_OrderLines.Rows[e.RowIndex].Cells["BatchNumber"].ReadOnly = false;
                    dgrd_OrderLines.Rows[e.RowIndex].Cells["ExpiryDate"].ReadOnly  = false;
                }
                else
                {
                    dgrd_OrderLines.Rows[e.RowIndex].Cells["BatchNumber"].ReadOnly = true;
                    dgrd_OrderLines.Rows[e.RowIndex].Cells["ExpiryDate"].ReadOnly  = true;
                }
            }

            if (e.RowIndex != -1 && e.ColumnIndex == dgrd_OrderLines.Columns["TotalQty"].Index ||
                e.RowIndex != -1 && e.ColumnIndex == dgrd_OrderLines.Columns["PurchasePrice"].Index)
            {
                CalculateTotal();
            }
        }
Beispiel #3
0
        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);
        }
Beispiel #4
0
		/// <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;
		}
Beispiel #5
0
        private void AdjustScreenControls()
        {
            BDProduct _bDProduct = (BDProduct)cbx_Product.SelectedItem;

            if (!(bool)_bDProduct.IsFixedPrice)
            {
                lbl_MinPriceHeader.Visible = true;
                lbl_MinPriceValue.Visible  = true;
                tbx_Price.Enabled          = true;
                tbx_Price.ReadOnly         = false;
                tbx_Price.Text             = "";
                lbl_MinPriceValue.Text     = _bDProduct.MinPrice.ToString();
            }
            else
            {
                lbl_MinPriceHeader.Visible = false;
                lbl_MinPriceValue.Visible  = false;
                tbx_Price.Enabled          = false;
                tbx_Price.ReadOnly         = true;
                tbx_Price.Text             = _bDProduct.ProductPrice.ToString();
            }

            if ((bool)_bDProduct.HasDiscount)
            {
                tbx_Discount.Text = (_bDProduct.DescountRatio * 100).ToString() + "%";
            }
        }
 private void initEntity(int productId)
 {
     try
     {
         BDProductPrimaryKey pk = new BDProductPrimaryKey();
         pk.ProductID = productId;
         _bdProduct   = _bdProductWrapper.SelectOne(pk);
         loadUI();
     }
     catch (Exception ex)
     {
         throw;
     }
 }
Beispiel #7
0
 private void initEntity(int productId)
 {
     try
     {
         BDProductPrimaryKey pk = new BDProductPrimaryKey();
         pk.ProductID = productId;
         _bdProduct   = _bdProductWrapper.SelectOne(pk);
         loadUI();
     }
     catch (Exception ex)
     {
         MessageBox.Show("حدث خطأ برجاء تكرار العمليه مره اخرى واذا تكرر الخطا برجاءالاتصال بالشخص المصمم للبرنامج وارسال رسالة الخطا التى ستظهر بعد قليل له");
         MessageBox.Show(ex.Message);
     }
 }
Beispiel #8
0
        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);
        }
Beispiel #9
0
        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;
        }
Beispiel #10
0
        private void num_Quantity_ValueChanged(object sender, EventArgs e)
        {
            if (string.IsNullOrEmpty(num_Quantity.Text))
            {
                return;
            }
            if (cbx_Product.SelectedIndex == -1)
            {
                num_Quantity.Text = "0";
                MessageBox.Show("لابد من أختيار منتج أولا");
                return;
            }
            BDProduct _bDProduct = (BDProduct)cbx_Product.SelectedItem;

            if (_bDProduct.TotalQty < Convert.ToDecimal(num_Quantity.Text))
            {
                MessageBox.Show("الكمية المتاحة فى المخزن أقل من الكمية المدخلة");
                num_Quantity.Text = "0";
                return;
            }
        }
Beispiel #11
0
		/// <summary>
		/// This method will return an object representing the record matching the primary key information specified.
		/// </summary>
		///
		/// <param name="pk" type="BDProductPrimaryKey">Primary Key information based on which data is to be fetched.</param>
		///
		/// <returns>object of class BDProduct</returns>
		public BDProduct SelectOne(BDProductPrimaryKey pk)
		{
			_bDProductWCF = new BDProduct();
			_bDProduct = POS.DataLayer.BDProductBase.SelectOne(new POS.DataLayer.BDProductPrimaryKey(pk.ProductID));
			
				_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;
				
			return _bDProductWCF;
		}
Beispiel #12
0
        private void dgrd_ReturnOrderLines_CellValueChanged(object sender, DataGridViewCellEventArgs e)
        {
            try
            {
                var senderGrid = (DataGridView)sender;

                if (e.RowIndex != -1 && (e.ColumnIndex == senderGrid.Columns["TotalQty"].Index /*|| e.ColumnIndex == senderGrid.Columns["UnitPrice"].Index*/) && !string.IsNullOrEmpty(senderGrid.Rows[e.RowIndex].Cells["TotalQty"].Value.ToString()))
                {
                    if (Convert.ToInt32(senderGrid.Rows[e.RowIndex].Cells["ProductName"].Value) == -1)
                    {
                        MessageBox.Show("أختر صنف أولا");
                        return;
                    }
                    if (Convert.ToInt32(senderGrid.Rows[e.RowIndex].Cells["StockType"].Value) == -1)
                    {
                        MessageBox.Show("أختر نوع مرتجع أولا");
                        return;
                    }


                    VSALSalesOrder vSALSalesOrder = vSALSalesOrderCollection.Where(a => a.ProductID == Convert.ToInt32(senderGrid.Rows[e.RowIndex].Cells["ProductName"].Value)).SingleOrDefault();
                    if (Convert.ToInt32(senderGrid.Rows[e.RowIndex].Cells["TotalQty"].Value) > vSALSalesOrder.TotalQty)
                    {
                        MessageBox.Show("الكمية المرتجعه اكبر من الكميه المدخله فى الفاتوره الاصليه");
                        return;
                    }

                    if (senderGrid.Rows[e.RowIndex].Cells["UnitPrice"].Value != null && senderGrid.Rows[e.RowIndex].Cells["TotalQty"].Value != null)
                    {
                        tbx_Total.Text = (CalculateTotal(Convert.ToDouble(senderGrid.Rows[e.RowIndex].Cells["UnitPrice"].Value) * Convert.ToDouble(senderGrid.Rows[e.RowIndex].Cells["TotalQty"].Value))).ToString();
                    }
                    else
                    {
                        return;
                    }
                }

                if (e.RowIndex != -1 && e.ColumnIndex == senderGrid.Columns["ProductName"].Index)
                {
                    VSALSalesOrder vSALSalesOrder = vSALSalesOrderCollection.Where(a => a.ProductID == Convert.ToInt32(senderGrid.Rows[e.RowIndex].Cells["ProductName"].Value)).SingleOrDefault();
                    if (vSALSalesOrder == null)
                    {
                        MessageBox.Show("هذا الصنف غير موجود بالفاتورة الاصليه");
                        senderGrid.Rows[e.RowIndex].ErrorText = "هذا الصنف غير موجود بالفاتورة الاصليه";
                        //senderGrid.Rows[e.RowIndex].Cells["ProductName"].Value = null;
                        senderGrid.Rows[e.RowIndex].Cells["ProductName"].Style.BackColor = Color.Red;
                        return;
                    }

                    BDProductPrimaryKey pk = new BDProductPrimaryKey();
                    pk.ProductID = Convert.ToInt32(senderGrid.Rows[e.RowIndex].Cells["ProductName"].Value);

                    BDProduct _product = bDProductWrapper.SelectOne(pk);
                    senderGrid.Rows[e.RowIndex].Cells["IsAcceptBatch"].Value = _product.IsAcceptBatch;

                    if (_product.IsAcceptBatch == true)
                    {
                        senderGrid.Rows[e.RowIndex].Cells["BatchNumber"].ReadOnly = false;
                        senderGrid.Rows[e.RowIndex].Cells["ExpiryDate"].ReadOnly  = false;
                    }
                    else
                    {
                        senderGrid.Rows[e.RowIndex].Cells["BatchNumber"].ReadOnly = true;
                        senderGrid.Rows[e.RowIndex].Cells["ExpiryDate"].ReadOnly  = true;
                    }
                    senderGrid.Rows[e.RowIndex].Cells["UnitPrice"].Value = vSALSalesOrder.FinalPrice;
                }

                if (e.RowIndex != -1 && e.ColumnIndex == senderGrid.Columns["ExpiryDate"].Index)
                {
                    if (Convert.ToInt32(senderGrid.Rows[e.RowIndex].Cells["ProductName"].Value) == -1)
                    {
                        MessageBox.Show("أختر صنف أولا");
                        return;
                    }
                    DateTime result;
                    if (!DateTime.TryParse(senderGrid.Rows[e.RowIndex].Cells["ExpiryDate"].Value.ToString(), out result))
                    {
                        MessageBox.Show("صيغة تاريخ الصلاحية غير صحيحة لابد ان تكون (يوم -شهر -سنة)");
                        senderGrid.Rows[e.RowIndex].Cells["ExpiryDate"].Style.BackColor = Color.Red;
                        senderGrid.Rows[e.RowIndex].Cells["ExpiryDate"].Value           = "";
                    }
                    else
                    {
                        senderGrid.Rows[e.RowIndex].Cells["ExpiryDate"].Style.BackColor = Color.White;
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("حدث خطأ برجاء تكرار العمليه مره اخرى واذا تكرر الخطا برجاءالاتصال بالشخص المصمم للبرنامج وارسال رسالة الخطا التى ستظهر بعد قليل له");
                MessageBox.Show(ex.Message);
            }
        }
        private void dgrd_ReturnOrderLines_CellValueChanged(object sender, DataGridViewCellEventArgs e)
        {
            var senderGrid = (DataGridView)sender;

            if (e.RowIndex != -1 && e.ColumnIndex == senderGrid.Columns["TotalQty"].Index && !string.IsNullOrEmpty(senderGrid.Rows[e.RowIndex].Cells["TotalQty"].Value.ToString()))
            {
                if (Convert.ToInt32(senderGrid.Rows[e.RowIndex].Cells["ProductName"].Value) == -1)
                {
                    MessageBox.Show("أختر صنف أولا");
                    return;
                }
                VSALSalesOrder vSALSalesOrder = vSALSalesOrderCollection.Where(a => a.ProductID == Convert.ToInt32(senderGrid.Rows[e.RowIndex].Cells["ProductName"].Value)).SingleOrDefault();
                if (vSALSalesOrder == null)
                {
                    MessageBox.Show("هذا الصنف غير موجود بالفاتورة الاصليه");
                    senderGrid.Rows[e.RowIndex].ErrorText = "هذا الصنف غير موجود بالفاتورة الاصليه";
                    senderGrid.Rows[e.RowIndex].Cells["ProductName"].Style.BackColor = Color.Red;
                    return;
                }
                //else
                //{
                //    if ((sALSalesReturnLineCollection.Where(a => a.OriginalSalesLineID == vSALSalesOrder.SalesLineID).ToList().Count) == 0)
                //        sALSalesReturnLineCollection.Add(new SALSalesReturnLine()
                //        {
                //            OriginalSalesLineID = vSALSalesOrder.SalesLineID,
                //            Qty = (decimal)senderGrid.Rows[e.RowIndex].Cells["TotalQty"].Value,
                //            BatchNumber = vSALSalesOrder.IsAcceptBatch == true ? senderGrid.Rows[e.RowIndex].Cells["BatchNumber"].Value.ToString() : null,
                //            ExpiryDate = vSALSalesOrder.IsAcceptBatch == true ? Convert.ToDateTime(senderGrid.Rows[e.RowIndex].Cells["ExpiryDate"].Value) : (DateTime?)null,
                //            Reason = senderGrid.Rows[e.RowIndex].Cells["Reason"].Value.ToString()
                //        });
                //    else
                //    {
                //        sALSalesReturnLineCollection.RemoveAt(sALSalesReturnLineCollection.IndexOf(sALSalesReturnLineCollection.Where(a => a.OriginalSalesLineID == vSALSalesOrder.SalesLineID).SingleOrDefault()));
                //        sALSalesReturnLineCollection.Add(new SALSalesReturnLine()
                //        {
                //            OriginalSalesLineID = vSALSalesOrder.SalesLineID,
                //            Qty = (decimal)senderGrid.Rows[e.RowIndex].Cells["TotalQty"].Value,
                //            BatchNumber = vSALSalesOrder.IsAcceptBatch == true ? senderGrid.Rows[e.RowIndex].Cells["BatchNumber"].Value.ToString() : null,
                //            ExpiryDate = vSALSalesOrder.IsAcceptBatch == true ? Convert.ToDateTime(senderGrid.Rows[e.RowIndex].Cells["ExpiryDate"].Value) : (DateTime?)null,
                //            Reason = senderGrid.Rows[e.RowIndex].Cells["Reason"].Value.ToString()
                //        });
                //    }
                //}

                tbx_Total.Text = (CalculateTotal((double)senderGrid.Rows[e.RowIndex].Cells["UnitPrice"].Value * (double)senderGrid.Rows[e.RowIndex].Cells["TotalQty"].Value)).ToString();
            }

            if (e.RowIndex != -1 && e.ColumnIndex == senderGrid.Columns["ProductName"].Index)
            {
                BDProductPrimaryKey pk = new BDProductPrimaryKey();
                pk.ProductID = Convert.ToInt32(senderGrid.Rows[e.RowIndex].Cells["ProductName"].Value);

                BDProduct _product = bDProductWrapper.SelectOne(pk);
                senderGrid.Rows[e.RowIndex].Cells["IsAcceptBatch"].Value = _product.IsAcceptBatch;

                if (_product.IsAcceptBatch == true)
                {
                    senderGrid.Rows[e.RowIndex].Cells["BatchNumber"].ReadOnly = false;
                    senderGrid.Rows[e.RowIndex].Cells["ExpiryDate"].ReadOnly  = false;
                }
                else
                {
                    senderGrid.Rows[e.RowIndex].Cells["BatchNumber"].ReadOnly = true;
                    senderGrid.Rows[e.RowIndex].Cells["ExpiryDate"].ReadOnly  = true;
                }
            }
        }
Beispiel #14
0
		/// <summary>
		/// This method will insert one new row into the database using the property Information
		/// </summary>
		///
		/// <param name="bDProduct" type="BDProduct">This BDProduct  will be inserted in the database.</param>
		///
		/// <returns>True if succeeded</returns>
		public bool Insert(BDProduct bDProduct)
		{
			_bDProduct = new POS.DataLayer.BDProduct();
			_bDProduct.ProductID=bDProduct.ProductID;
			_bDProduct.ProductName=bDProduct.ProductName;
			_bDProduct.ProductGroupID=bDProduct.ProductGroupID;
			_bDProduct.ProductCode=bDProduct.ProductCode;
			_bDProduct.IsAcceptBatch=bDProduct.IsAcceptBatch;
			_bDProduct.ProductPrice=bDProduct.ProductPrice;
			_bDProduct.IsFixedPrice=bDProduct.IsFixedPrice;
			_bDProduct.HasDiscount=bDProduct.HasDiscount;
			_bDProduct.DiscountAmount=bDProduct.DiscountAmount;
			_bDProduct.DescountRatio=bDProduct.DescountRatio;
			_bDProduct.IsActive=bDProduct.IsActive;
			_bDProduct.Notes=bDProduct.Notes;
			_bDProduct.MinPrice=bDProduct.MinPrice;
			_bDProduct.MaxPrice=bDProduct.MaxPrice;
			
			return _bDProduct.Insert();
		}
Beispiel #15
0
			///<summary>
		/// This method will update one new row into the database using the property Information
		/// </summary>
		///
		/// <param name="bDProduct" type="BDProduct">This BDProduct  will be updated in the database.</param>
		///
		/// <returns>True if succeeded</returns>
		public bool Update(BDProduct bDProduct)
		{
			_bDProduct=POS.DataLayer.BDProduct.SelectOne(new POS.DataLayer.BDProductPrimaryKey(bDProduct.ProductID));
			
			_bDProduct.ProductName=bDProduct.ProductName;
			_bDProduct.ProductGroupID=bDProduct.ProductGroupID;
			_bDProduct.ProductCode=bDProduct.ProductCode;
			_bDProduct.IsAcceptBatch=bDProduct.IsAcceptBatch;
			_bDProduct.ProductPrice=bDProduct.ProductPrice;
			_bDProduct.IsFixedPrice=bDProduct.IsFixedPrice;
			_bDProduct.HasDiscount=bDProduct.HasDiscount;
			_bDProduct.DiscountAmount=bDProduct.DiscountAmount;
			_bDProduct.DescountRatio=bDProduct.DescountRatio;
			_bDProduct.IsActive=bDProduct.IsActive;
			_bDProduct.Notes=bDProduct.Notes;
			_bDProduct.MinPrice=bDProduct.MinPrice;
			_bDProduct.MaxPrice=bDProduct.MaxPrice;
			
			return _bDProduct.Update();
		}
Beispiel #16
0
		/// <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;
		}
Beispiel #17
0
		/// <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;
		}