private void LoadPurchaseReturnHeaderList()
{
CreamBell_DMS_WebApps.App_Code.Global obj = new Global();
//string query= " Select A.PURCH_RETURNNO,A.PURCH_RETURNDATE, A.PURCH_RECIEPTNO, A.PURCH_RECIEPTDATE, A.SALE_INVOICENO, SUM(B.AMOUNT) as TOTAMOUNT " +
// " from [ax].[ACXPURCHRETURNHEADER] A INNER JOIN [ax].[ACXPURCHRETURNLINE] B ON A.PURCH_RETURNNO=B.PURCH_RETURNNO GROUP BY " +
// " A.PURCH_RETURNNO,A.PURCH_RETURNDATE, A.PURCH_RECIEPTNO, A.PURCH_RECIEPTDATE, A.SALE_INVOICENO ";
string query = "Select A.PURCH_RETURNNO,A.PURCH_RETURNDATE, A.PURCH_RECIEPTNO, A.PURCH_RECIEPTDATE, A.SALE_INVOICENO, SUM(B.AMOUNT) as TOTAMOUNT " +
"from [ax].[ACXPURCHRETURNHEADER] A INNER JOIN [ax].[ACXPURCHRETURNLINE] B ON A.PURCH_RETURNNO=B.PURCH_RETURNNO AND A.SITE_CODE=B.SITEID " +
"Where A.SITE_CODE='" + Session["SiteCode"].ToString() + "' and A.DATAAREAID='" + Session["DATAAREAID"].ToString() + "' " +
" GROUP BY A.PURCH_RETURNNO,A.PURCH_RETURNDATE, A.PURCH_RECIEPTNO, A.PURCH_RECIEPTDATE, A.SALE_INVOICENO Order By A.PURCH_RETURNDATE desc";
DataTable dt = obj.GetData(query);
if (dt.Rows.Count > 0)
{
GridHeaderDetail.DataSource = dt;
GridHeaderDetail.DataBind();
//GridHeaderDetail.Columns[5].Visible = false;
}
}
//GetPurchaseOrder(Convert.ToDateTime(txtFromDate.Text).ToString("dd-MMM-yyyy"), Convert.ToDateTime(txtToDate.Text).ToString("dd-MMM-yyyy"));
private void SearchdataByFilter(string searchFilter, string searchText)
{
CreamBell_DMS_WebApps.App_Code.Global obj = new Global();
string query = " Select A.PURCH_RETURNNO,A.PURCH_RETURNDATE, A.PURCH_RECIEPTNO, A.PURCH_RECIEPTDATE, A.SALE_INVOICENO, SUM(B.AMOUNT) as TOTAMOUNT " +
" from [ax].[ACXPURCHRETURNHEADER] A INNER JOIN [ax].[ACXPURCHRETURNLINE] B ON A.PURCH_RETURNNO=B.PURCH_RETURNNO ";
if (DDLSearchFilter.Text == "Receipt Number")
{
query = query + " where A.PURCH_RECIEPTNO ='" + searchText + "' and A.SITE_CODE='" + Session["SiteCode"].ToString() + "' and A.DATAAREAID='" + Session["DATAAREAID"].ToString() + "' GROUP BY A.PURCH_RETURNNO,A.PURCH_RETURNDATE, A.PURCH_RECIEPTNO, A.PURCH_RECIEPTDATE, A.SALE_INVOICENO";
}
if (DDLSearchFilter.Text == "Receipt Date")
{
query = query + " where A.PURCH_RECIEPTDATE ='" + searchText + "' and A.SITE_CODE='" + Session["SiteCode"].ToString() + "' and A.DATAAREAID='" + Session["DATAAREAID"].ToString() + "' GROUP BY A.PURCH_RETURNNO,A.PURCH_RETURNDATE, A.PURCH_RECIEPTNO, A.PURCH_RECIEPTDATE, A.SALE_INVOICENO";
}
if (DDLSearchFilter.Text == "Return Number")
{
query = query + " where A.PURCH_RETURNNO ='" + searchText + "' and A.SITE_CODE='" + Session["SiteCode"].ToString() + "' and A.DATAAREAID='" + Session["DATAAREAID"].ToString() + "' GROUP BY A.PURCH_RETURNNO,A.PURCH_RETURNDATE, A.PURCH_RECIEPTNO, A.PURCH_RECIEPTDATE, A.SALE_INVOICENO";
}
if (DDLSearchFilter.Text == "Return Date")
{
query = query + " where A.PURCH_RETURNDATE ='" + searchText + "' and A.SITE_CODE='" + Session["SiteCode"].ToString() + "' and A.DATAAREAID='" + Session["DATAAREAID"].ToString() + "' GROUP BY A.PURCH_RETURNNO,A.PURCH_RETURNDATE, A.PURCH_RECIEPTNO, A.PURCH_RECIEPTDATE, A.SALE_INVOICENO";
}
DataTable dt = obj.GetData(query);
if (dt.Rows.Count > 0)
{
GridHeaderDetail.DataSource = dt;
GridHeaderDetail.DataBind();
gridLineDetails.Visible = true;
}
else
{
this.Page.ClientScript.RegisterStartupScript(GetType(), "Alert", " alert('No Data Found !');", true);
LoadPurchaseReturnHeaderList();
gridLineDetails.Visible = false;
}
}
