protected void btnSearch_Click(object sender, EventArgs e) { try { CreamBell_DMS_WebApps.App_Code.Global baseObj = new CreamBell_DMS_WebApps.App_Code.Global(); if (txtFromDate.Text.Trim().Length > 0) { if (!baseObj.IsDate(txtFromDate.Text)) { string message = "alert('Invalid From Date !!!');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", message, true); txtFromDate.Focus(); return; } } if (txtToDate.Text.Trim().Length > 0) { if (!baseObj.IsDate(txtToDate.Text)) { string message = "alert('Invalid To Date !!!');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", message, true); txtToDate.Focus(); return; } } CreamBell_DMS_WebApps.App_Code.Global obj = new CreamBell_DMS_WebApps.App_Code.Global(); bool b = ValidateSearch(); GridView1.DataSource = null; GridView2.DataSource = null; GridView2.DataBind(); if (b == true) { DateTime endDate = Convert.ToDateTime(this.txtToDate.Text); //endDate.AddDays(1); //DateTime end = endDate.AddDays(1); string FromDate = Convert.ToDateTime(txtFromDate.Text).ToString("dd-MMM-yyyy"); string ToDate = endDate.ToString("dd-MMM-yyyy"); //string query = "Select A.PURCH_RETURNNO as INVOICE_NO , A.PURCH_RETURNDATE as INVOIC_DATE, A.Purch_recieptno as SO_NO,case when CONVERT(VARCHAR(10),PURCH_RECIEPTDATE , 103)= '01/01/1900' then '' else CONVERT(VARCHAR(10),PURCH_RECIEPTDATE , 103) end AS SO_DATE, ('[' + A.SITE_CODE +']' + ' ' + B.NAME) as CUSTOMER , A.Return_docvalue as INVOICE_VALUE" + // " from ax.[ACXPURCHRETURNHEADER] A INNER JOIN ax.inventsite B ON A.SITE_CODE=B.SITEID" + // " where A.SITE_CODE= '" + Session["SiteCode"].ToString() + "' and PURCH_RETURNDATE>='" + FromDate + "' and PURCH_RETURNDATE<='" + ToDate + "'"; string query = "Select A.PURCH_RETURNNO as INVOICE_NO , A.PURCH_RETURNDATE as INVOIC_DATE, A.Purch_recieptno as SO_NO,case when CONVERT(VARCHAR(10),PURCH_RECIEPTDATE , 103)= '01/01/1900' then '' else CONVERT(VARCHAR(10),PURCH_RECIEPTDATE , 103) end AS SO_DATE, ('[' + A.SITE_CODE +']' + ' ' + B.NAME) as CUSTOMER , A.Return_docvalue as INVOICE_VALUE" + " from ax.[ACXPURCHRETURNHEADER] A INNER JOIN ax.inventsite B ON A.SITE_CODE=B.SITEID" + " where A.SITE_CODE IN (" + ucRoleFilters.GetCommaSepartedSiteId() + ") and PURCH_RETURNDATE>='" + FromDate + "' and PURCH_RETURNDATE<='" + ToDate + "'"; //if (txtInvoiceNoStart.Text != string.Empty && txtInvoiceNoEnd.Text != string.Empty) //{ // try // { // string[] strInvoicefromsplit = txtInvoiceNoStart.Text.Split('-'); // string[] strInvoiceTosplit = txtInvoiceNoEnd.Text.Split('-'); // query = query + "and cast(Right(A.invoice_no,6) as int) between " + strInvoicefromsplit[1] + " and " + strInvoiceTosplit[1] + " "; // } // catch // { // ScriptManager.RegisterStartupScript(this, this.GetType(), "Alert", " alert('Invoice number is not in correct format !! ');", true); // GridView1.DataSource = null; // GridView1.DataBind(); // return; // } // // //} //if (drpPSR.SelectedItem.Text != string.Empty && drpPSR.SelectedItem.Text != "Select...") //{ // query = query + "and B.psr_code='" + drpPSR.SelectedItem.Value + "' "; // // if (drpBeat.SelectedItem.Text != string.Empty && drpBeat.SelectedItem.Text != "Select...") // { // query = query + "and B.psr_beat='" + drpBeat.SelectedItem.Value + "' "; // // if (drpCustomer.SelectedItem.Text != string.Empty && drpCustomer.Text != "Select...") // { // query = query + "and A.CUSTOMER_CODE='" + drpCustomer.SelectedItem.Value + "' "; // } // } //} if (ddlSearchNew.Text == "Sales Invoice No" && txtSearch.Text != "") { query = query + "AND A.PURCH_RETURNNO like '%" + txtSearch.Text.Trim().ToString() + "%'"; } //if (ddlSearch.Text == "Customer") //{ // query = query + " and (A.CUSTOMER_CODE like '%" + txtSearch.Text.Trim().ToString() + "%' or B.CUSTOMER_NAME like '%" + txtSearch.Text.Trim().ToString() + "%') "; //} query = query + " ORDER BY A.PURCH_RETURNDATE DESC, A.PURCH_RETURNNO DESC"; DataTable dtFilter = obj.GetData(query); if (dtFilter.Rows.Count > 0) { GridView1.DataSource = dtFilter; GridView1.DataBind(); CheckBox chk = (CheckBox)GridView1.HeaderRow.FindControl("checkAll"); chk.Checked = true; foreach (GridViewRow grv in GridView1.Rows) { CheckBox chkAll = (CheckBox)grv.Cells[0].FindControl("chklist"); chkAll.Checked = true; } // uppanel.Update(); } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "Alert", " alert('No Data Exist !! ');", true); GridView1.DataSource = null; GridView1.DataBind(); //GridDetail(); txtSearch.Text = string.Empty; } } } catch (Exception ex) { ErrorSignal.FromCurrentContext().Raise(ex); } }
protected void btnSearch_Click(object sender, EventArgs e) { CreamBell_DMS_WebApps.App_Code.Global baseObj = new CreamBell_DMS_WebApps.App_Code.Global(); if (txtFromDate.Text.Trim().Length > 0) { if (!baseObj.IsDate(txtFromDate.Text)) { string message = "alert('Invalid From Date !!!');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alert", message, true); txtFromDate.Focus(); return; } } if (txtToDate.Text.Trim().Length > 0) { if (!baseObj.IsDate(txtToDate.Text)) { string message = "alert('Invalid To Date !!!');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alert", message, true); txtToDate.Focus(); return; } } CreamBell_DMS_WebApps.App_Code.Global obj = new CreamBell_DMS_WebApps.App_Code.Global(); bool b = ValidateSearch(); GridView1.DataSource = null; GridView2.DataSource = null; GridView2.DataBind(); if (b == true) { DateTime endDate = Convert.ToDateTime(this.txtToDate.Text); string FromDate = Convert.ToDateTime(txtFromDate.Text).ToString("dd-MMM-yyyy"); string ToDate = endDate.ToString("dd-MMM-yyyy"); if (ddlState.SelectedItem.Text == "Select...") { ScriptManager.RegisterStartupScript(this, this.GetType(), "Alert", " alert('Please fill the State !! ');", true); return; } else { if (ddlSiteId.SelectedItem.Text == "Select...") { ScriptManager.RegisterStartupScript(this, this.GetType(), "Alert", " alert('Please fill the Distributor !! ');", true); return; } else { string query = "EXEC USP_SERVICEINVOICEDETAIL '" + ddlSiteId.SelectedValue + "','" + FromDate + "','" + ToDate + "'"; DataTable dtFilter = obj.GetData(query); if (dtFilter.Rows.Count > 0) { GridView1.DataSource = dtFilter; GridView1.DataBind(); CheckBox chk = (CheckBox)GridView1.HeaderRow.FindControl("checkAll"); chk.Checked = true; foreach (GridViewRow grv in GridView1.Rows) { CheckBox chkAll = (CheckBox)grv.Cells[0].FindControl("chklist"); chkAll.Checked = true; } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "Alert", " alert('No Data Exist !! ');", true); GridView1.DataSource = null; GridView1.DataBind(); } } } } }