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;
}
