public DataSet GetDaybookDetailsForReporting(VoucherSearch voucher) { DataSet ds = null; try { Database db = DatabaseFactory.CreateDatabase(Constant.Database_Connection_Name); DbCommand cmd = db.GetStoredProcCommand(Constant.SP_Voucher_Report_DayBookByDateRange); db.AddInParameter(cmd, "@dFromDate", DbType.DateTime, voucher.FromDate.Value); db.AddInParameter(cmd, "@dToDate", DbType.DateTime, voucher.ToDate.Value); ds = db.ExecuteDataSet(cmd); } catch (System.Exception ex) { ds = null; throw ex; } return(ds); }
public DataSet SearchVoucher(VoucherSearch voucher) { DataSet ds = null; try { Database db = DatabaseFactory.CreateDatabase(Constant.Database_Connection_Name); DbCommand cmd = db.GetStoredProcCommand(Constant.SP_Voucher_SearchVouchers); if (voucher.ChequeDateFrom == DateTime.MinValue) { db.AddInParameter(cmd, "@dtChequeDateFrom", DbType.DateTime, DBNull.Value); } else { db.AddInParameter(cmd, "@dtChequeDateFrom", DbType.DateTime, voucher.ChequeDateFrom); } if (voucher.ChequeDateTo == DateTime.MinValue) { db.AddInParameter(cmd, "@dtChequeDateTo", DbType.DateTime, DBNull.Value); } else { db.AddInParameter(cmd, "@dtChequeDateTo", DbType.DateTime, voucher.ChequeDateTo); } db.AddInParameter(cmd, "@sChequeNumberFrom", DbType.String, voucher.ChequeNumberFrom); db.AddInParameter(cmd, "@sChequeNumberTo", DbType.String, voucher.ChequeNumberTo); ds = db.ExecuteDataSet(cmd); } catch (System.Exception ex) { ds = null; throw ex; } return(ds); }
protected void btnSearch_Click(object sender, EventArgs e) { try { VoucherSearch search = new VoucherSearch(); if (dtpFromDate.Text == string.Empty) { search.FromDate = null; } else { search.FromDate = dtpFromDate.Date; } if (dtpToDate.Text == string.Empty) { search.ToDate = null; } else { search.ToDate = dtpToDate.Date; } DataSet ds = new VoucherDAO().GetDaybookDetailsForReporting(search); Session["DayBookReport"] = ds; dxgvExpenseReport.DataSource = ds; dxgvExpenseReport.DataBind(); } catch (Exception ex) { ex.Data.Add("UILayerException", this.GetType().ToString() + Constant.Error_Seperator + "protected void btnSearch_Click(object sender, EventArgs e)"); if (Master.LoggedUser != null && Master.LoggedUser.UserName != null && Master.LoggedUser.UserName != string.Empty) Response.Redirect("Error.aspx?LogId=" + LankaTilesExceptions.WriteEventLogs(ex, Constant.Database_Connection_Name, Master.LoggedUser.UserName), false); else Response.Redirect("Error.aspx?LogId=" + LankaTilesExceptions.WriteEventLogs(ex, Constant.Database_Connection_Name, "Annonimous"), false); } }
private DataSet Search() { try { VoucherSearch search = new VoucherSearch(); search.ChequeNumberFrom = txtChqNoFrom.Text.Trim(); search.ChequeNumberTo = txtChqNoTo.Text.Trim(); if (dtpFromDate.Text.Trim() == String.Empty) { search.ChequeDateFrom = DateTime.MinValue; } else { search.ChequeDateFrom = DateTime.Parse(dtpFromDate.Value.ToString()); } if (dtpToDate.Text.Trim() == String.Empty) { search.ChequeDateTo = DateTime.MinValue; } else { search.ChequeDateTo = DateTime.Parse(dtpToDate.Value.ToString()); } return new VoucherDAO().SearchVoucher(search); } catch(Exception ex) { throw ex; } }
public DataSet SearchVoucher(VoucherSearch voucher) { DataSet ds = null; try { Database db = DatabaseFactory.CreateDatabase(Constant.Database_Connection_Name); DbCommand cmd = db.GetStoredProcCommand(Constant.SP_Voucher_SearchVouchers); if (voucher.ChequeDateFrom == DateTime.MinValue) { db.AddInParameter(cmd, "@dtChequeDateFrom", DbType.DateTime, DBNull.Value); } else { db.AddInParameter(cmd, "@dtChequeDateFrom", DbType.DateTime, voucher.ChequeDateFrom); } if (voucher.ChequeDateTo == DateTime.MinValue) { db.AddInParameter(cmd, "@dtChequeDateTo", DbType.DateTime, DBNull.Value); } else { db.AddInParameter(cmd, "@dtChequeDateTo", DbType.DateTime, voucher.ChequeDateTo); } db.AddInParameter(cmd, "@sChequeNumberFrom", DbType.String, voucher.ChequeNumberFrom); db.AddInParameter(cmd, "@sChequeNumberTo", DbType.String, voucher.ChequeNumberTo); ds = db.ExecuteDataSet(cmd); } catch (System.Exception ex) { ds = null; throw ex; } return ds; }
public DataSet GetExpencesForReportingByDateRange(VoucherSearch voucher) { DataSet ds = null; try { Database db = DatabaseFactory.CreateDatabase(Constant.Database_Connection_Name); DbCommand cmd = db.GetStoredProcCommand(Constant.SP_Voucher_Report_ExpencesByDateRange); db.AddInParameter(cmd, "@dFromDate", DbType.DateTime, voucher.FromDate.Value); db.AddInParameter(cmd, "@dToDate", DbType.DateTime, voucher.ToDate.Value); ds = db.ExecuteDataSet(cmd); } catch (System.Exception ex) { ds = null; throw ex; } return ds; }