private DataTable Search() { db = new DatabaseClass(); string sql = ""; string orderByPart = "ORDER BY JournalCode "; if (radCashRecipt.Checked) { #region radCashRecipt sql = "SELECT * FROM vwCashRecieptsReport WHERE CR_No IS NOT NULL "; if (ddlProfitCenters.SelectedValue != "0") sql = string.Format("{0} AND CenterID={1} ", sql, ddlProfitCenters.SelectedValue); if (txtFrom2.SelectedDate != null) sql = string.Format("{0} AND TransactionDate>='{1}' ", sql, DatabaseClass.FormatDateString(txtFrom2.SelectedDate.ToString())); if (txtTo2.SelectedDate != null) sql = string.Format(" {0} AND TransactionDate<='{1}' ", sql, DatabaseClass.FormatDateString(txtTo2.SelectedDate.ToString())); sql = string.Format("{0} {1} ", sql, orderByPart); return db.ExecuteQuery(sql); #endregion } else if (radChequeRecipt.Checked) { #region radChequeRecipt sql = "SELECT * FROM vwChequeRecieptsReport WHERE CR_No IS NOT NULL "; if (ddlProfitCenters.SelectedValue != "0") sql = string.Format("{0} AND CenterID={1} ", sql, ddlProfitCenters.SelectedValue); if (txtFrom2.SelectedDate != null) sql = string.Format("{0} AND TransactionDate>='{1}' ", sql, DatabaseClass.FormatDateString(txtFrom2.SelectedDate.ToString())); if (txtTo2.SelectedDate != null) sql = string.Format(" {0} AND TransactionDate<='{1}' ", sql, DatabaseClass.FormatDateString(txtTo2.SelectedDate.ToString())); sql = string.Format("{0} {1} ", sql, orderByPart); return db.ExecuteQuery(sql); #endregion } else if (radCashDisburment.Checked) { #region radCashDisburment sql = "SELECT * FROM vwCashDisbursementsReport WHERE CD_No IS NOT NULL "; if (ddlProfitCenters.SelectedValue != "0") sql = string.Format("{0} AND CenterID={1} ", sql, ddlProfitCenters.SelectedValue); if (txtFrom2.SelectedDate != null) sql = string.Format("{0} AND TransactionDate>='{1}' ", sql, DatabaseClass.FormatDateString(txtFrom2.SelectedDate.ToString())); if (txtTo2.SelectedDate != null) sql = string.Format(" {0} AND TransactionDate<='{1}' ", sql, DatabaseClass.FormatDateString(txtTo2.SelectedDate.ToString())); sql = string.Format("{0} {1} ", sql, orderByPart); return db.ExecuteQuery(sql); #endregion } else if (radChequeDisburment.Checked) { #region radChequeDisburment sql = "SELECT * FROM vwChequeDisbursementsReport WHERE CD_No IS NOT NULL "; if (ddlProfitCenters.SelectedValue != "0") sql = string.Format("{0} AND CenterID={1} ", sql, ddlProfitCenters.SelectedValue); if (txtFrom2.SelectedDate != null) sql = string.Format("{0} AND TransactionDate>='{1}' ", sql, DatabaseClass.FormatDateString(txtFrom2.SelectedDate.ToString())); if (txtTo2.SelectedDate != null) sql = string.Format(" {0} AND TransactionDate<='{1}' ", sql, DatabaseClass.FormatDateString(txtTo2.SelectedDate.ToString())); sql = string.Format("{0} {1} ", sql, orderByPart); return db.ExecuteQuery(sql); #endregion } else return new DataTable(); }
protected void btnPrint_Click1(object sender, EventArgs e) { try { string sql = ""; lblFeedBack.Text = ""; db = new DatabaseClass(); if (radCashRecipt.Checked) { sql = string.Format("SELECT * FROM vwCashRecieptsReport WHERE CR_NO={0} ORDER BY JournalCode ", int.Parse(txtCRNo.Text)); DataTable dt = db.ExecuteQuery(sql); if (dt.Rows.Count > 0) { Session["vwCashRecieptsReport"] = dt; string url = "ViewCashReceiptReport.aspx"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectViewCashReceiptReport", "window.open('" + url + "', '_new')", true); } else lblFeedBack.Text = "No Data"; } else if (radChequeRecipt.Checked) { sql = string.Format("SELECT * FROM vwChequeRecieptsReport WHERE CR_NO={0} ORDER BY JournalCode ", int.Parse(txtCRNo.Text)); DataTable dt = db.ExecuteQuery(sql); if (dt.Rows.Count > 0) { Session["vwChequeRecieptsReport"] = dt; string url = "ViewChequeRecieptReport.aspx"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectViewChequeRecieptReport", "window.open('" + url + "', '_new')", true); } else lblFeedBack.Text = "No Data"; //sql = string.Format("SELECT * FROM vwChequeMgmtFullInfo WHERE RecordID={0} ", int.Parse(txtCRNo.Text)); //DataTable dt = db.ExecuteQuery(sql); //if (dt.Rows.Count > 0) //{ // Session["vwChequeMgmtFullInfo"] = dt; // string url = "ViewChequeRecieptReport.aspx"; // ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectViewChequeRecieptReport", "window.open('" + url + "', '_new')", true); //} //else // lblFeedback.Text = "No Data"; } else if (radCashDisburment.Checked) { sql = string.Format("SELECT * FROM vwCashDisbursementsReport WHERE CD_NO={0} ORDER BY JournalCode ", int.Parse(txtCDNo.Text)); DataTable dt = db.ExecuteQuery(sql); if (dt.Rows.Count > 0) { Session["vwCashDisbusrsesReport"] = dt; string url = "ViewCashDisbursesReport.aspx"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectViewCashDisbursesReport", "window.open('" + url + "', '_new')", true); } else lblFeedBack.Text = "No Data"; } else if (radChequehDisburment.Checked) { sql = string.Format("SELECT * FROM vwChequeDisbursementsReport WHERE CD_NO={0} ORDER BY JournalCode ", int.Parse(txtCDNo.Text)); DataTable dt = db.ExecuteQuery(sql); if (dt.Rows.Count > 0) { Session["vwChequeDisbursementsReport"] = dt; string url = "ViewChequeDisbursesReport.aspx"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectViewChequeDisbursesReport", "window.open('" + url + "', '_new')", true); } else lblFeedBack.Text = "No Data"; //sql = string.Format("SELECT * FROM vwChequeMgmtFullInfo WHERE RecordID={0} ", int.Parse(txtCDNo.Text)); //DataTable dt = db.ExecuteQuery(sql); //if (dt.Rows.Count > 0) //{ // Session["vwChequeMgmtFullInfo"] = dt; // string url = "ViewChequeDisbursesReport.aspx"; // ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectViewChequeRecieptReport", "window.open('" + url + "', '_new')", true); //} //else // lblFeedback.Text = "No Data"; } else lblFeedBack.Text = "No Data"; ClearControls(sender); ddlCurrencies_SelectedIndexChanged(sender, new EventArgs()); } catch (Exception ex) { lblFeedBack.Text = ex.Message; } }
protected void gvResults_RowCommand(object sender, GridViewCommandEventArgs e) { try { if (e.CommandName == "SendByEmail") { } else if (e.CommandName == "Print") { db = new DatabaseClass(); DataTable dtResult; int transID = int.Parse(e.CommandArgument.ToString()); //int.Parse(gvResults.SelectedValue.ToString()); string sql = string.Format("SELECT TOP 1 IsCheque, IsCashReciept, isCashDisburment FROM vwGLMasterDetailed WHERE transactionid={0} ", transID); DataTable dt = db.ExecuteQuery(sql); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; if (bool.Parse(dr["IsCheque"].ToString())) { if (bool.Parse(dr["IsCashReciept"].ToString())) { sql = string.Format("SELECT * FROM vwChequeRecieptsReport WHERE TransactionId={0} AND CR_NO IS NOT NULL ", transID); dtResult = db.ExecuteQuery(sql); if (dtResult.Rows.Count > 0) { Session["vwChequeRecieptsReport"] = dtResult; string url = "ViewChequeRecieptReport.aspx"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectViewChequeRecieptReport", "window.open('" + url + "', '_new')", true); } else lblFeedback.Text = "No Data"; } else if (bool.Parse(dr["isCashDisburment"].ToString())) { sql = string.Format("SELECT * FROM vwChequeDisbursementsReport WHERE TransactionId={0} AND CD_NO IS NOT NULL ", transID); dtResult = db.ExecuteQuery(sql); if (dtResult.Rows.Count > 0) { Session["vwChequeDisbursementsReport"] = dtResult; string url = "ViewChequeDisbursesReport.aspx"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectViewChequeDisbursesReport.aspx", "window.open('" + url + "', '_new')", true); } else lblFeedback.Text = "No Data"; } else lblFeedback.Text = "No Data"; } else { if (bool.Parse(dr["IsCashReciept"].ToString())) { sql = string.Format("SELECT * FROM vwCashRecieptsReport WHERE TransactionId={0} AND CR_NO IS NOT NULL ", transID); dtResult = db.ExecuteQuery(sql); if (dtResult.Rows.Count > 0) { Session["vwCashRecieptsReport"] = dtResult; string url = "ViewCashReceiptReport.aspx"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectViewCashReceiptReport", "window.open('" + url + "', '_new')", true); } else lblFeedback.Text = "No Data"; } else if (bool.Parse(dr["isCashDisburment"].ToString())) { sql = string.Format("SELECT * FROM vwCashDisbursementsReport WHERE TransactionId={0} AND CD_NO IS NOT NULL ", transID); dtResult = db.ExecuteQuery(sql); if (dtResult.Rows.Count > 0) { Session["vwCashDisbusrsesReport"] = dtResult; string url = "ViewCashDisbursesReport.aspx"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectViewCashDisbursesReport", "window.open('" + url + "', '_new')", true); } else lblFeedback.Text = "No Data"; } else lblFeedback.Text = "No Data"; } } else lblFeedback.Text = "No Data"; } } catch (Exception ex) { lblFeedback.Text = ex.Message; } }