protected void GetInvoiceDetails() { #region getHeaderDetails query = "Select A.[DOCUMENT_NO],CONVERT(VARCHAR(11),A.[DOCUMENT_DATE] ,106) as [DOCUMENT_DATE], A.PURCH_INDENTNO, CONVERT(VARCHAR(11),A.[PURCH_INDENTDATE],106) AS PURCH_INDENTDATE, " + "A.MATERIAL_VALUE, A.PURCH_RECIEPTNO, A.TRANSPORTER_CODE,A.VEHICAL_NO, A.VEHICAL_TYPE, A.[SALE_INVOICENO] AS INVOICENO, " + " CONVERT(VARCHAR(11), A.[SALE_INVOICEDATE],106) AS INVOICEDATE from [ax].[ACXPURCHINVRECIEPTHEADER] A where A.[SITE_Code]='" + Session["SiteCode"].ToString() + "' " + "and A.[DATAAREAID]='" + Session["DATAAREAID"].ToString() + "' and A.PURCH_RECIEPTNO='" + drpRecieptNo.SelectedItem.Text + "' "; dt = new DataTable(); dt = obj.GetData(query); if (dt.Rows.Count > 0) { txtReceiptDate.Text = dt.Rows[0]["DOCUMENT_DATE"].ToString(); txtInvoiceDate.Text = dt.Rows[0]["INVOICEDATE"].ToString(); // decimal materialValue = Convert.ToDecimal(dt.Rows[0]["MATERIAL_VALUE"].ToString()); txtReceiptValue.Text = "0.00"; } #endregion #region Product Details query = "exec ACX_GET_NONSALABLEINVOICEDETAIL '" + Session["SiteCode"].ToString() + "','" + Session["DATAAREAID"].ToString() + "','" + drpRecieptNo.SelectedItem.Text + "',0"; dt = new DataTable(); dt = obj.GetData(query); if (dt.Rows.Count > 0) { DDLMaterialCode.DataSource = dt; DDLMaterialCode.DataTextField = "PRODUCTDESC"; DDLMaterialCode.DataValueField = "PRODUCT_CODE"; DDLMaterialCode.DataBind(); DDLMaterialCode.Items.Insert(0, new ListItem("--Select--", "0")); } #endregion }
protected void GetProduct() { #region Product Details dt = (DataTable)Session["MarketVRSDetails"]; if (dt != null) { DDLMaterialCode.DataSource = dt; DDLMaterialCode.DataTextField = "PRODUCT_NAME"; DDLMaterialCode.DataValueField = "PRODUCTCODE"; DDLMaterialCode.DataBind(); DDLMaterialCode.Items.Insert(0, new ListItem("--Select--", "0")); } #endregion }
protected void GetProduct() { #region Product Details string bucode; if (ddlBusinessUnit.SelectedIndex == 0) { bucode = ""; } else { bucode = ddlBusinessUnit.SelectedValue; } dt = new DataTable(); if (rdoColdRoomDistruction.Checked == true) { query = "exec ACX_GETDISTRUCTIONPRODUCTDETAILS '" + Session["SiteCode"].ToString() + "',0,'" + bucode + "'"; dt = obj.GetData(query); } else if (rdoMarketReturnDistruction.Checked == true) { // query = "exec ACX_GETDISTRUCTIONPRODUCTDETAILS '" + Session["SiteCode"].ToString() + "',1"; dt = (DataTable)Session["MarketDistructionDetails"]; if (dt != null) { var Value = dt.Select("Cust_Group ='" + ddlCustomerGroup.Text.Trim() + "' AND CUSTOMER_CODE ='" + ddlCustomer.Text.Trim() + "'"); dt = Value.CopyToDataTable(); var distValue = dt.DefaultView.ToTable(true, "PRODUCT_NAME", "PRODUCTCODE"); DataTable dtCust = new DataTable(); dtCust = (DataTable)distValue; dt = dtCust; } } if (dt != null) { DDLMaterialCode.DataSource = dt; DDLMaterialCode.DataTextField = "PRODUCT_NAME"; DDLMaterialCode.DataValueField = "PRODUCTCODE"; DDLMaterialCode.DataBind(); DDLMaterialCode.Items.Insert(0, new ListItem("--Select--", "0")); } #endregion }