protected void btnSearch_Click(object sender, EventArgs e) { try { VoucherRecievableSearch voucherSearch = new VoucherRecievableSearch(); voucherSearch.FromDate = dtpFromDate.Date; voucherSearch.ToDate = dtpToDate.Date; DataSet dsPOs = (new VoucherRecievableDAO()).GetPaymentsReveivedForReporting(voucherSearch); Session["PaymentsRecieved"] = dsPOs; if (dsPOs != null && dsPOs.Tables[0].Rows.Count > 0) { dxgvPaymentsReceived.DataSource = dsPOs; dxgvPaymentsReceived.DataBind(); } else { dxgvPaymentsReceived.DataSource = dsPOs; dxgvPaymentsReceived.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); } } }
public DataSet GetPaymentsReveivedForReporting(VoucherRecievableSearch voucherSearch) { try { Database db = DatabaseFactory.CreateDatabase(Constant.Database_Connection_Name); DbCommand dbCommand = db.GetStoredProcCommand(Constant.SP_Voucher_Report_Payments_ReceivedByDateRange); db.AddInParameter(dbCommand, "@dFromDate", DbType.DateTime, voucherSearch.FromDate.Value); db.AddInParameter(dbCommand, "@dToDate", DbType.DateTime, voucherSearch.ToDate.Value); return(db.ExecuteDataSet(dbCommand)); } catch (System.Exception ex) { ex.Data.Add("BusinessLayerException", GetType().ToString() + Constant.Error_Seperator + "public DataSet GetPaymentsReveivedForReporting(VoucherRecievableSearch voucherSearch)"); return(null); throw ex; } }
public DataSet GetPaymentsReveivedForReporting(VoucherRecievableSearch voucherSearch) { try { Database db = DatabaseFactory.CreateDatabase(Constant.Database_Connection_Name); DbCommand dbCommand = db.GetStoredProcCommand(Constant.SP_Voucher_Report_Payments_ReceivedByDateRange); db.AddInParameter(dbCommand, "@dFromDate", DbType.DateTime, voucherSearch.FromDate.Value); db.AddInParameter(dbCommand, "@dToDate", DbType.DateTime, voucherSearch.ToDate.Value); return db.ExecuteDataSet(dbCommand); } catch (System.Exception ex) { ex.Data.Add("BusinessLayerException", GetType().ToString() + Constant.Error_Seperator + "public DataSet GetPaymentsReveivedForReporting(VoucherRecievableSearch voucherSearch)"); return null; throw ex; } }