public ProductSaleData GetProductSale(double product, double warehouse) { DataTable dt = ABB.DAL.Sales.V_SUPPORT_LIST_DAL.GetProductWithPromotion(warehouse, DateTime.Now.Date, product, ""); ProductSaleData data = new ProductSaleData(); if (dt.Rows.Count > 0) { if (!Convert.IsDBNull(dt.Rows[0]["BARCODE"])) data.BARCODE = dt.Rows[0]["BARCODE"].ToString(); if (!Convert.IsDBNull(dt.Rows[0]["DISCOUNT"])) data.DISCOUNT = Convert.ToDouble(dt.Rows[0]["DISCOUNT"]); if (!Convert.IsDBNull(dt.Rows[0]["ISVAT"])) data.ISVAT = dt.Rows[0]["ISVAT"].ToString(); if (!Convert.IsDBNull(dt.Rows[0]["NAME"])) data.PRODUCTNAME = dt.Rows[0]["NAME"].ToString(); if (!Convert.IsDBNull(dt.Rows[0]["PRICE"])) data.UNITPRICE = Convert.ToDouble(dt.Rows[0]["PRICE"]); if (!Convert.IsDBNull(dt.Rows[0]["LOID"])) data.PRODUCT = Convert.ToDouble(dt.Rows[0]["LOID"]); if (!Convert.IsDBNull(dt.Rows[0]["UNIT"])) data.UNIT = Convert.ToDouble(dt.Rows[0]["UNIT"]); if (!Convert.IsDBNull(dt.Rows[0]["UNITNAME"])) data.UNITNAME = dt.Rows[0]["UNITNAME"].ToString(); } return data; }
private void SetProductDetail(ProductSaleData data, GridViewRow gRow, TextBox txtBarcode, DropDownList cmbProduct, TextBox txtUnit, Label lblUnitName, TextBox txtPrice, TextBox txtNetPrice, TextBox txtQty, Label lblNormalDiscount, Label lblIsVat) { txtBarcode.Text = data.BARCODE; cmbProduct.SelectedIndex = cmbProduct.Items.IndexOf(cmbProduct.Items.FindByValue(data.PRODUCT.ToString())); txtUnit.Text = data.UNIT.ToString(); lblUnitName.Text = data.UNITNAME; txtPrice.Text = SaleObj.CalculateUnitPrice(data.UNITPRICE, Convert.ToDouble(this.txtVat.Text), data.ISVAT).ToString(Constz.DblFormat); txtNetPrice.Text = SaleObj.CalcucateProductTotalItem(Convert.ToDouble(txtPrice.Text), Convert.ToDouble(txtQty.Text == "" ? "0" : txtQty.Text), 0).ToString(Constz.DblFormat); lblNormalDiscount.Text = data.DISCOUNT.ToString(Constz.DblFormat); lblIsVat.Text = data.ISVAT; //if (txtBarcode.ID == "txtNewBarCode" && txtBarcode.Text != "") // InsertData(gRow); }