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
}
